Database Analyst Consultant Resume

Summary

Around 5 years’ experience of SQL Server 2008/2012, Oracle 11g, Access 2007/2010 database and Data Loading and reporting tools such as: SSIS, SSRS and Crystal Reports 2008/2011.
Strong data manage and reporting experience on quantitative analysis.
Professional experience on load variety of large volume data files into SQL server 2008/2012 database tables, migrate Oracle tables into SQL Server 2008/2012 database tables and generate Report with SSRS.
Experience on high performance data integration solutions - Microsoft SQL Server Integration Service (SSIS), including extraction, transformation, and load (ETL) packages for data warehousing.
Robust MS Access and Excel skills with Pivot tables, Macros and VBA programming and Power BI reporting.
Strong team player with great verbal, written communication and interpersonal skills. Hard worker. Willing to take responsibilities.
Proven ability to approach problems effectively, prioritize and complete multiple tasks.
Created ETL packages using SQL Server 2008/2012 SSIS Designer to extracted data from flat file, reformat the data, and insert the reformatted data into fact table, loaded different types of dimension and fact tables into data warehouse, deployed SSIS packages and solutions into production system using SQL Server Business Intelligence Development Studio(BIDS) or Visual Studio.
Developed projects using SQL Server 2008/2012 SSAS, created data source/data source view/cube with measure and dimensions, configured attributes of dimension table with hierarchy relationships; modified cube and dimensions, deployed KPIs on SSRS and create different metrics, added new measure groups and dimensions; created data-mining solutions in BIDS (Visual Studio), deployed them to SSAS instance, trained the model and queried the model using DMX.
Generated variety of business reports using SQL Server 2008/2012 SSRS including metrix report, parameter report, dashboard with charts and drill down function; built reports from Analysis Services cube using MDX query designer; configured report server and deployed reports on web server.
Configured SQL Server 2008/2012 and Oracle SQL 10g/11g/11gR2 database parameter files to adjust the memory usage and file size.
Created database tables with various constraints including primary key, foreign key, etc.
Loaded data from flat data files onto SQL Server 2008 database table using bcp, bulk insert, and table export/import; loaded data from flat data files and excel sheet into Oracle database using SQL*Loader and SQL Developer.
Extracted data from SQL Server 2008 database tables and Oracle database tables into flat data files and Excel sheet.
Power user of advanced SQL queries with multi-table joins, group functions, subqueries, set operations and T-SQL or PL/SQL functions.
Generated variety of business reports using SQL queries, sqlplus, SSRS and Excel.
Generated variety of business reports using SQL Server 2008 sql query, SSRS, Crystal Report 2008 and Excel 2007 Pivot table.

TECHNICAL SKILLS

Database: SQL Server 2008/2012 (5 years), Oracle 11g (3 years), MSBI 2008/2012, SSIS (4 years), Access 2007/2010

Reporting: Access 2007/2010, SSRS (5 years), Crystal Reports 2008/2011 (3 years)

Language: SQL (5 years), T-SQL (3 years)

MS Office: Word, Excel, PowerPoint, Access

PROFESSIONAL EXPERIENCE

Database Analyst Consultant

Confidential

Responsibilities:

Using linked server (SQL Server) or database link (Oracle) cross-reference other distributed database with Primary Key, Foreign Key and linking their related knowledge together (quarry data, join tables).
Generated monthly, weekly and ad-hoc report base on the statistical analysis data so that to be strong supporter for sales department.
Designed various Drill-through and Drill-down operation in SSRS reports to make them user-friendly.
Maintained and debugged the existing reports daily to make sure reports running correctly and punctually.
Created SSIS projects and packages using data flow task, execute SQL task, derived columns, condition split, foreach loop container and slowly changing dimension task etc. generated underlying data for reporting and exported/imported data to/from excel spreadsheets, text file, MS access and CSV files.
Used SSIS and SQL script (stored procedures, bcp, bulk insert and SQL loader) to transfer data from data centre (OLTP base or OLETP data warehouse) to reporting data mart.
Solid SQL query and T-SQL skills make quality and efficient SQL query codes.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship