SUMMARY

• Experience with MS SQL Server2008/2012, Oracle, Access databases and reporting tools such as SSRS, OBIEE11g and Crystal Reports.
• Proficient with T - SQL query coding, unit test, and reporting in quantitative analysis.
• Expertise in database design, database creation and maintenance, performance monitoring and tuning, troubleshooting, normalization, replication and documentation.
• Experience in high performance data integration solutions including using SSIS to create packages for data extraction, transformation, and loading (ETL), data validation, ETL data to data warehouse/data marts.
• Extensive experience in loading a variety of large volume data files into SQL server database, developing scripts for data migrating from heterogeneous sources including Oracle into SQL Server database.
• Import/Export data, Bulk Insert and BCP, configure, deploy and scheduled SSIS Packages.
• Knowledgeable in designing customized Dimension ETL (e.g. SCD) and Fact ETL for data warehouse and using C# codes for SSIS package and SSRS reports.
• Expert in designing standard and ad-hoc reports using SSRS and generating multi-valued parameterized reports (drill down/through, linked, matrix,and cascaded reports, Sub Reports), dashboards, scorecards and KPIs.
• Professional experience inData modeling (Star and Snow Flake Schemas) for Data Mart/Warehouse.
• Skilled in developing OLAP cubes (including ROLAP, MOLAP, HOLAP), dimensions, facts, data source views and processing SSAS objects, performing Data Mining with SSAS.
• Robust MS Access and Excel skills with PowerPivot (Pivot tables) and in depth knowledge on ETL strategies, Data Mapping, Data Conversion, Data Cleansing and VLDB and partitioning.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Involved in the creation of different scripts and functions using PL/SQL in ORACLE.
• Hands-on experience in Generating OBIEE/Analytics Reports and Repository (Physical, Business Model and Mapping and Presentation layers) for both Stand-Alone and Integrated Siebel Analytics/OBIEE11g Admin tool implementations. Extensively worked in creating hierarchies and aggregates in the BMML.
• Proficiency in data and object level Security in Siebel Analytics/OBIEE11g.
• Hands-on experience in customizing OBIEE dashboards and reports. Created mock up reports and dashboards for review by the business users; Performed Data Validation in the reports and dashboards.
• Skilled at assessing client needs, working in groups, suggesting ideas that enhance efficiency and maximize performance, implementing technology solutions, and training/supporting end users.
• Quick learner and hard worker with great interpersonal skills; willing to take responsibilities. Proven ability to approach problems effectively, prioritize and complete multiple tasks.

TECHNICAL SKILLS

Database: SQL Server 2008/2012, Access 2007/2010, Oracle 10g/11g, OBIEE11g

Reporting: Access 2007, SSRS, Crystal Report 2008, MS SharePoint, OBIEE 11gLanguage SQL, T-SQL PL-SQL, basic C#, R.

Data Modeling: Erwin Modeler, Power Designer, Microsoft SSMS

MS Office: Word, Excel, PowerPoint, Outlook, Access, Project, and Visio

Environment: Windows (Server), Unix(Solaris), Linux, VMWare

PROFESSIONAL EXPERIENCE

BI developer (Online BI analytics)

Confidential

Responsibilities:

• Data transferring design and development: evaluate and consolidate data, design and develop the SSIS package and stored procedures for data transferring, deploy, monitor, and maintain the ETL.
• Create dimension and fact tables in data marts/data warehouse using T-SQL based on business reporting requirements.
• Implemented Incremental load, and used Event Handlers to clean the data from different data sources.
• Developed various operational Drill-through and Drill-down reports using SSRS
• Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports.
• Used cascaded parameters to generate a report from two different Data Sets.
• Populate data from test server for testing purpose; Test the ETL packages and stored procedures; Debug the codes and packages; Implement the tested stored procedures and packages in production server.
• Build OLAP cubes for BI data analysis.
• Generate Business Reports using SSRS and SharePoint based on different clients’ requirements.
• Involved with Query Optimization to increase the performance of the Report.

BI developer/Data Analyst

Confidential

Responsibilities:

• Migrated data from Heterogeneous Data Sources and legacy system (Oracle, Access, Excel) to SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
• Retrieve and modify data using SQL Server2008 and BIDS and acquire virus target information by data mining, and identified potential host targets of viral virulence factors from over 260 databases.
• Implemented data modeling (conceptual, logical and physical data modeling); developed projects using SQL Server 2008 SSAS and Erwin Modeler, designed data warehouse.
• Created ETL packages using SQL Server to extract data from heterogeneous files, reformatted the data, and inserted into tables, loaded different types of dimension and fact tables into data warehouse, deployed SSIS packages and solutions into production system.
• Database and Log Backups and Scheduling Backups by creating and deploying SSIS packages.
• 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 created different metrics, added new measure groups and dimensions; created data-mining solutions in BIDS, deployed them to SSAS instance, trained the model and queried the model using DMX.
• Involved in analyzing, designing, building, testing of OLAP cubes with SSAS.
• Interacting with the Database Administrator to maintain the database used DBCC Statements to perform maintenance tasks before backing up the databases.
• Generated a variety of business reports using OBIEE11g and SSRS including matrix report, parameterized 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 and SharePoint, built Performance Points Dashboards in SharePoint 2010.

Data Analyst

Confidential

Responsibilities:

• Used MS Access, Excel and SQL Server 2008 as tools to collect and analyze data.
• Designed business intelligence solutions to meet the client's business requirements; Created databases for heart disease gene mutants, purified proteins and FRET data; and maintained databases to track information.
• Created SSIS packages to ETL data from the flat files, excel files, csv, oracle data files into data marts/data warehouse using SSIS to support data integration needs;
• Performed data modeling, independently designed and created independently data marts and a data warehouse using Erwin Modeler and SSAS.
• Designed and developed BI environments to support reporting, analysis and visualizations requirements by using SQL queries, T-SQL and SSAS.
• Developed and tuned database applications in Oracle and SQL Server; Retrieve and modify data using SQL Server2008 and BIDS and acquire disease information from different database.
• Database and Log Backups and Scheduling Backups by creating and deploying SSIS packages.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division for evaluating research projects using SSRS and crystal reports.