DBAs

Hockessin, Delaware, United States

Yearly Stats: $0 Earned |

The guru of

Services




DBAs

High quality and timely service within your budget. One stop solution for all your data needs.

*Result-oriented and efficient Senior BI Developer/Data Analyst/Business Analyst with 12+ years of diversified experience.

*Proven strong expertise in Database Design and Development especially in implementing Business Intelligence solutions using MS SQL Server 2012/2008R2/2008/2005 SSIS/SSRS/SSAS, Access and Excel.

*Thoroughly versed in all aspects of Accounting, Finance, IT&Internal Auditing providing strong expertise in a variety of business domains.

*Strong ability in utilizing IT tools to create effective solutions to business problems.

*Extensive SQL Development experience in a Financial/Government/Service environment with a strong understanding of business processes & data & analytics.
*Extensive knowledge and experience in dealing with Relational Database Management Systems including Normalization, Stored Procedure, Constraint, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors.
*Worked on all activities related to the development, implementation, administration and support of ETL process for large-scale Data Warehouses using SSIS.
*Experience in writing MDX queries and performance tuning SSAS cubes.
*Extensive experience delivering OLAP solutions by developing Corporate Dashboard Reporting using SSRS and Power Pivot in Excel 2010.
*Professional experience of most advanced SQL Server 2008 & 2012 Database server installation, login and user creation, role and permission configuration.
*Extensive experience in using SQL Server Profiler to monitor the SQL server for deadlocks, long running queries and tune the same to improve performance.

Work Terms

Flexible work hours. Can work on evenings and wekends. Prefer communicate via email adress: yiqunw@gmail.com.