ETL architectures Resume Profile

OBJECTIVE BI developer/Database Analyst/Reporting Developer

SUMMARY

Over7 years ofexperienceof SQL server 2008/2012 database, Access, Oracle, Business Intelligence tools SSIS, SSAS, and SSRS, Crystal Reports
Expertise in designing, developing, supporting database objects stored procedures, functions, tables, views and generatereportsfor business requirements in SQL server 2008/2012 database and Oracle database
Expertise in data integration solution development using SQL Server Integration Service SSIS
Experience of creatingETL packages using SQL Server 2008 SSIS Designer to extract data from flat file, transform the data, and insert the transformed data into fact table, load different types of dimension and fact tables into Data Warehouse, deploy SSISpackages and solution into production system
Power user of advanced SQL queries with table join, sub-queries, group functions, single row functions, set operations,CTE and T-SQL,PL/SQL
Experience of business intelligent project developments inbuildingreports from a varietyof data source and meta-data usingSQL queries,SSRS and Crystal Reports, Excel PowerPivot
Enterprise in generating various of business reports using SQL Server SSRS including matrix report, parameter report, dashboard with chart, drill-down function building reports from SSAS cube using MDX query designer configuring report server and deployed reports on SharePoint.
Enterprise of loading data from flat data file, excel file into SQL Server database table using BCP, bulk insert, Import and Export Data load data from flat data file, excel sheet into Oracle database using SQL Loader, SQL developer and Toad
Strong data mapping and data analysisskills applied in SSIS packages and reporting designs and developments
Robust MS Access and Excel skills including pivot tables.

SKILLS

Database: Oracle 11g, SQL server 2008/2012, Access, SSIS, SSAS

Reporting Service: Access 2007, SSRS, Crystal Reports, SharePoint 2010, PowerPivot

MS office: Word, Excel, PowerPoint, Access

Languages: SQL, PL/SQL, T-SQL

Others: Toad, SQL developer, SQLPlus, FTP

EXPERIENCE

Confidential

Create dimension/fact tables, design and fully implement ETL architectures capable of handling high volume of data inSSIS based Enterprise
Modifyand tune SSIS ETL packages with Type II SCD attributes, create and schedule ETL agent job in TEST Environments and test the ETL packages successfully
DevelopSSRS reports, deploy the reports onto SharePoint, and deliverthe weekly /daily reports automatically tofinance, engineering, market and management departments
Develop complicated SSRS KPI reports and dashboard for different KPIto management department
Upgrade excel or excel pivot reports to SSRS reports and implement automatically delivery
Build complicated datasetsfrom SSAS cube using MDX andimprove the report performance dramatically
Trouble shooting ETL package and SQL server agent job, validate data and cleanse the duplication

Confidential

Work with clients from several industries and generate a variety of business reports using SSRS, Access and Crystal Reports
Design and Create tablesfor client, load data and pursue data cleansing and auditing
Design ETL packages using SSIS to extract data from flat file, Oracle database/SQL server database, transform the data and load into different database, datawarehouse facts and dimension tables.
Built reports from SSAS cube and MDX query designer.
Upload the weblog files into database and analyzed the weblog data
Migrate data from SQL server to Oracle 11g based on client's business requirements.

Confidential

Perform drug/screening and scale-up synthesis, project management andmanufacture process documentation,
Extract data from different chemical database,clinical trial, flat file, and migrate to SQL server 2008 database for advanced analysis
Develop chemical/drug data mining and analysis solution using SQL server 2008, BIDS SSAS and Excel
Generate complex reports using complex SQL queries including single row functions, table join, sub-queries, group functions and set operation.

Confidential

Develop chemical database for drug/medicine,design and synthesize new drugbuilding blocks.
Maintain databases ofchemical catalog and purchase, manage the chemical in-stock and sales information using SQL Server 2008 and Access Migrate data from Access database to SQL server 2008 database.
Data analysis using Access, SQL server 2008 SSRS to generate ad-hoc and monthly sales and finance reports.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship