Jennifer Li
***********@*****.***
SUMMARY
Over 2 years of experience in Data Modeling, Database Design, Programming, Development and Implementation Database systems using Microsoft SQL Server 2008/2008 R2 and Microsoft SQL Server 2012.
Active participation in Software Development Life Cycle (SDLC) specifically waterfall and Agile Scrum methodology.
Strong experience with T-SQL in writing various queries, triggers, user defined functions, store procedures, views, indexes and cursors.
Expert in using tools like MS SQL Profiler, Index Tuning Wizard, Performance monitor activity monitor for the performance tuning and trouble shooting for SQL server and T-SQL.
Expertise in Data Conversion, Normalization and Data Modeling, Multi-Dimensional Modeling and involved in creation of Fact Tables, Dimension Tables, Star Schema and Snowflake dimensional schema using Erwin Tool.
Experience in developing various SSIS packages to generate data staging area and transform data from OLTP system into Data warehouse.
Experience in using control flow task and data flow transformation such as For Each Loop Container, Execute Package task, Execute SQL Task, Sent Mail task, Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Slowly Changing Dimension.
Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled SSIS Packages.
Experience in developing and designing drill down drill through, matrix report and ad-hoc reports through SSRS and report builder
Experienced deploying, managing and maintaining reports using report manager.
Experience in up grading and migrating from SQL Server 2008 to to SQL Server 2012
Flexible, enthusiastic and project oriented team player with excellent written, verbal communication and leadership skills to develop creative solutions for challenging client needs.
Expertise in SQL Server Analysis Services (SSAS) to deliver online analytical processing (OLAP) and data mining functionality for business intelligence applications.
Experience in Developing and Deploying OLAP cubes, Facts and Dimension tables from data warehouse
Used MDX (Multi-dimensional Expressions) queries for calculated members of a cube and KPIs (Key Performance Indicators).
Experience in implementing database mirroring and replications.
Experience in index rebuilding and reorganization.
Performed accident DBA in full backup, transactional backup, differential backup and created user defined roles and logins.
SKILLSET
SQL/T-SQL(certified), SAS(certified), C#, XML, Microsoft SQL Server 2008/2008 R2, Microsoft SQL Server 2012, BIDS, SSTD, SSMS, SSIS, SSRS, SSAS, Visual Studio 2012, DBA, Erwin, SQL Server Agent, Bulk insert, SQL Profiler, MS SQL Server Index Tuning Wizard, Performance Monitor
EXPERIENCE
Microsoft SQL Server BI developer/SSIS/SSRS/SSAS
02/2015-08/2015
Puracap Pharmaceuticals South Plainfiled, NJ
Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse.
Used various SSIS tasks such as Conditional Split, Derived Column, lookup which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
Developed and deployed data transfers packages to the appropriate destinations using SSIS.
Created jobs, Alerts, SQL Mail Agent, and schedule SSIS Packages.
Identified the database tables for defining queries to generate reports for analysis of data using SQL Server Reporting Services in Report Builder.
Defined the report layout and identified Datasets for the report generation.
Created different type of reports including Cross-tab, Conditional, Drill-down, Sub reports also parameterized reports.
Designed and created Report templates, bar graphs and pie charts based on the financial data.
Scheduled the monthly/weekly/daily reports to run automatically.
Developed, implemented and maintained various database objects such as Stored Procedures, Triggers, Functions, Indexes and Views.
Used VSS to store, run, view, edit and revert back to different versions of the design in case of a system crash.
Designed partitions in Cubes on time for improvement in performance using SSAS.
Maintaining the existing cubes and creating new cubes with dimensions, measures and calculated members for slicing and dicing data from the call center Data Warehouse. Using MDX expressions for the various calculated members, actions and KPIs.
Used MDX to extract cube data and created pivot tables for analysis.
Environments: MS SQL Server 2000, MS SQL Server 2005, SQL server Reporting Services 2005, SQL Analysis Server (SSAS), SQL Server Integration Services (SSIS), VSS, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL, ERWIN.
Microsoft SQL Server BI developer/SSIS/SSRS
PetroChina Urumqi Petrochemical Company, Urumqi, China
09/2010-12/2011
Gathered data and documenting it for further reference and designed Database using Erwin data modeler.
Planned, Defined and Designed data based on business requirement and provided documentation.
Created SSIS package to load data from XML Files and SQL Server 2008 to SQL Server 2012 by using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
Developed Unit Test Plans for SSIS packages for checking the functionality of each component.
Modified the existing SSIS packages to meet the changes specified by the users.
Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis using SQL Server Agent.
Involved in creating alerts for successful or unsuccessful completion of scheduled jobs.
Worked in setup logging environment to track the status of the events like error raise, task fail.
Generated parameterized reports, sub reports, tabular reports using SSRS 2012.
Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2012.
Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS 2012
Created reports to retrieve data using Stored Procedures that accept parameters.
Scheduled the monthly weekly daily reports to run automatically onto the Dashboard
Responsible for Monitoring and Tuning Report performance.
Created various database object like stored procedures, functions, tables, views.
Configured the report viewing security for various users at various levels using Report Manager.
Scheduled report and exported in PDF format.
Fine tuned SQL Queries for maximum efficiency and performance using SQL Profiler and Database Engine Tuning Advisor.
Provided documentation for all kinds of reports and SSIS packages.
Designed and implemented Stored Procedures and Triggers for automating tasks.
Environment: Microsoft SQL Server 2005/2008R2, SQL Server Management Studio (SSMS), SQL Server Business Intelligence Development Studio (BIDS), SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Oracle 10g/11g, Visual Studio 2008, C#, T-SQL, XML, IIS 6.0/7.0, ERWIN.
EDUCATION
Shanghai University Bachelor of Finance(2007-2011)
University of Delaware Master of Finance (2012-2013)