OBJECTIVE: Data Analyst/Reporting Engineer /Business intelligence developer

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 in Data 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.

EXPERIENCE

BI developer

Confidential

• Analyze raw data from various data sources to develop ETL packages using SSIS
• Data transferring design and development: design and develop the SSIS package and stored procedures for data transferring, deploy, monitor, and maintain the ETL.
• Build OLAP cubes for BI data analysis using SSAS Generate Business Reports using SSRS based on different clients' requirements.
• Implement Incremental and full load based on business requirement, and used Event Handlers to clean the data from different data sources.
• Ensure data integrity and perform data cleansing through preprocessing
• Implement data mapping, data validation, data modeling and develop SQL queries for ad-hoc reports.
• Perform problem analysis, troubleshooting, problem recreation, and root cause analysis.
• Document and maintain ETL processes. Schedule ETL jobs.
• Monitor ETL work flow and performance develop logs and debug methods as needed.

BI Analyst

Confidential

• Managed Sears Commerce Services database and ensure data integrity and accuracy
• Prepared data for marketplace analytics and develop SQL queries for ad-hoc reports.
• Generated multiple management financial reports for marketplace analytics team.
• Tracked general business activity, identified trends and changes, and provided clear insights and recommendations to business partners and senior management.
• Identified and evaluated key metrics to satisfy business partner's need and objective.
• Improved Analytics team processes e.g. streamlining, automation, and documentation.
• Performed ad hoc analysis. Developed various operational Drill-through and Drill-down reports.
• 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 data warehouse to generate reports.

BI developer/Data Analyst

Confidential

• 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

• 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.

Postdoctoral Research Associate

Confidential

Responsible for the technical completion of the whole project including sample collection, methodology development, data collection and processing, database design and administration, experiment implement, collection, processing and analysis of data, and report, presentation and paper preparation. Performed research data analysis, database design and administration using MS Access, and Crystal Reports.

Postdoctoral research fellow

Confidential

Research, design and administrate databases. Conduct the analysis and processing of research data including photosynthetic membrane proteins and genomic data, microarray data and laboratory data.

TECHNICAL SKILLS

• Database: SQL Server 2008/2012, Access 2007/2010, Oracle 10g/11g, OBIEE11g
• Reporting: Access 2007, SSRS, Crystal Report 2008, MS SharePoint, OBIEE 11g,
• Language: SQL, T-SQL PL-SQL, basic C , R.
• Data Modeling: Erwin Modeler, PowerDesigner, Microsoft SSMS
• MS Office: Word, Excel, PowerPoint, Outlook, Access, and Project