SUMMARY

• Over 9 years of experience in design, development, testing, deployment, management and analysis of business applications such as data migration, integration, conversion, data warehouse.
• Strong understanding of Software Development Life Cycle(SDLC), Agile Methodology, Database concepts. Design Documentation, Development, Unit Testing, assist User Acceptance Testing, Implementation, Post Implementation Support and Maintenance.
• Involved in implementing the end to end ETL life cycle,
• Understanding the requirement from business user
• Involved in designing the dimensional Model like star schema, snow flake schema
• Create source to Target columns mapping spread sheet
• Prepare the DDL scripts for creating table in DW and Staging database
• Create ETL mapping, package, workflow as per requirements
• Unit test of all the ETL components, submitting the results
• Prepared the migration template
• Coordinated with the ETL testing for fixing the defects
• Asist performed the sanity testing after QA migration assure that works roughly as expect
• Used involve peer review
• Extensive knowledge in database SQL query optimization & performance tuning using execution plan, performance tools like SQL Profiler, Index, and good practicing build SQL query.
• Experience with T - SQL (DDL and DML) in constructing tables, user defined functions(UDF), views, complex stored procedures, cursor, clustered and non-clustered indexes, relational database models, data dictionaries (meta data), data integrity and appropriate triggers to facilitate efficient data manipulation and consistent data storage.
• Created database tables with various constraints including primary key, foreign key, etc.
• Skilled T-SQL and PL/SQL, Stored Procedure, function, trigger, cursor.
• Professional experience on load variety of large volume data files to database tables, migrate Oracle/ MS SQL Server tables into SQL Server database tables.
• Experience on high performance data integration solutions, Using Microsoft SQL Server Integration Service (SSIS) as ETL tool migration data from data source to target.
• Experience using different scope variables create reusable SSIS pattern(template). Implement Delta, increment loading and Update audit table.
• Strong experience in using Execute SQL Task to create SSIS packages using T-SQL, Stored Procedures and advance coding concepts together with SSIS transformations, Stored procedures to produce SSIS packages which are high on performance
• Strong Experience in using SSIS Script task or SSIS Script Component to create complex transformation logic using C# using C# script task Not only loading standard Flat File, but also Loading non-standard or irregular flat files to database. such as receipt, name card, row with parent child relationship.
• Using C# script task Download files from FTP site dynamically dynamic loop folders in ftp site, find files we need, then loading to SQL databases.
• Using SSIS Script Task Pulling data from http, website, FTP site, Share Point, loading to database table.
• Pulling data from OLTP to staging area, ODS (Operational Data Store) cleansing and reformat the data, load data into fact tables and dimension tables of Data Warehouse (OLAP).
• Experience in providing Logging, Error handling by using Event Handler and Custom Logging for SSIS Packages
• Configuration SSIS package, Deployed SSIS packages to DEV, QA, and PROD environment and schedule job.
• Using Informatica Power Center as another ETL tool migrate data.
• Generated variety of business reports using SQL Server SSRS including matrix 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.
• Generate report using Power BI. Import data from difference source, cleansing, transformation data, create table join, create date model, generate custom dashboard.
• Generate report using Tableau. Extract data from source, transform data, cleansing data, merge data using join, analytics data. Create calculation, filter, parameter per requirement. Generate functionality, user friendly custom dashboard.
• Strong team player with good technical, ability to work in group as well as independently with minimal supervision.
• Great verbal, written communication and interpersonal skills.
• Ability to work in team environment, Onsite /Offshore coordination.
• Proven ability to approach problems effectively, able to meet tight deadlines prioritize and complete multiple tasks.
• Quick learner, take initiator, and hard working. Willing to take responsibilities.

TECHNICAL SKILLS

• SQL Server 2008/2012/2014/2016 , Oracle 11g/12c, MSBI 2008/2012/2013/2015 , SSIS, Access 2008/2011/2013 , TFS, Share Point
• SSIS, T-SQL, Informatica Power Center 9.1
• SSRS, Access 2007/2010/2012 , POWER BI, Tableau, Crystal Reports
• SQL, T-SQL, PL/SQL, C#, Python, VBA, Excel Visual Basic
• SVN, Git
• Jira agile scrum
• Getting data from HTML, Website, FTP
• Generate XML out by using SQL script and C#
• Loading xml input using SSIS XML TASK AND SCRIPT TASK
• Big Data Cloudera, MySQL
• Word, Excel, PowerPoint, Access

PROFESSIONAL EXPERIENCE

Confidential, CA

SQL Developer

Responsibilities:

• Review and interpret ongoing business to report requirements
• Research required data
• Build appropriate and useful reporting deliverables.
• Analyze existing SQL queries for performance improvements
• Suggest new queries
• Develop procedures and scripts for data migration
• Provide timely scheduled management reporting
• Using SSRS and Power BI to visualize the report
• Create ETL mapping, workflow, processing as per requirements
• Using enterprise SSIS standard to create SSIS reusable packages
• Loading data to Data Warehouse/Database from remote server, linked server included SQL server and Flat File, etc.
• Database migration /create DEV/QA/UAT environment

Environment: SQL Server 2008, 2012, 2016, SSIS, SSRS, Power BI, SQL Agent, SVN, Visual Studio 2008/2012/2015(and related SSDT), C#, Jira, Git

Confidential, Agoura Hills, CA

Senior SQL/ETL Developer

Responsibilities:

• Involved in implementing the end to end ETL life cycle
• Understanding the requirement from business user
• Create source to Target columns mapping spread sheet
• Prepare the DDL scripts for creating table in DW and Staging database
• Create ETL mapping, workflow as per requirements
• Using enterprise SSIS standard to create SSIS reusable packages
• Loading data to Data Warehouse/Database from remote server, linked server include SQL server and Oracle server, and Flat File, etc.
• Database migration /create DEV/QA/UAT environment
• Using MDR (META DATA REPOSITORY) to create data conversion and mapping sheet, mapping dependency
• Prepared the migration template
• Performed the sanity testing after QA migration assure that works roughly as expect
• Create New Stored procedures per business requirements and rewrite old stored procedure per data mapping sheet.
• Deploy ETL packages and schedule job using JAMS/SQL agent

Confidential

Senior ETL/MSBI Developer

Responsibilities:

• Maintain and support existing ETL packages and reports.
• Interpreted business logic and developed appropriate data-flows and data dependencies.
• Create or rewrite stored procedures
• Integration Service (SSIS) as ETL tool migration data from data source to target.
• Used SQL/T-SQL, C# Script task(component) to do data cleansing and transformation.
• Experience using different scope variables create reusable SSIS pattern(template). Implement Delta, increment loading and Update audit table.
• Strong experience in using Execute SQL Task to create SSIS packages using T-SQL, Stored Procedures to produce SSIS packages which are high on performance
• Create source to Target columns mapping spread sheet
• Create ETL mapping, workflow as per requirements
• Prepared the migration template
• Use SSRS to generate matrix report, parameter report, and dashboard report with charts and drill down function.
• Using power BI generate custom dashboard report.