SUMMARY

• Offering 11years of information technology (IT) experience in system analysis, design, development, database administration and support of MS SQL Server in production, quality assurance (QA), and development and replication environments.
• Proficient in gathering business requirements from business stakeholders, analyzing document system and functional requirement specifications, and maintaining requirements.
• Excellent knowledge of software development life cycle (SDLC) and data warehouse life cycle (DWLC).
• Hands - on experience in data warehouse concepts, normalization and denormalization.
• Strong experience in Oracle, MS SQL Server, with Business Intelligence in SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS).
• Performed extract, transform, load (ETL) operations to support the data loads and transformations using SSIS, Talend, and BODI.
• Strong experience in Talend big data services. Managed Talend jobs and user access using Talend Management Console.
• Strong experience in Talend job design using Talend Studio. Published jobs into Talend Management Console and scheduled execution.
• Assist application developers in creating conceptual database designs that meet business and technical objectives of various projects.
• Work with production support 24/7, development, and user acceptance testing (UAT) environments.
• Performance tuning, query optimization, client/server connectivity, and database consistency checks using DBCC utilities.
• Performance monitor and profiler to solve dead locks and long-running queries.
• Hands-on experience with T-SQL, distributed queries, and correlated sub queries, and used most of the system functions.
• Created BI reports using SSRS, Crystal Reports, Tableau, Power BI, and BIRST.
• Excellent analytical, interpersonal, and communication skills. Desire to excel, fast learner, hard working, and versatile team player.
• Experience in leading offshore team and helping them understand technical design documents and setup environments.

TECHNICAL SKILLS

Languages and Tools: SQL, T-SQL, PL/SQL, R, Python

Web Technologies: HTML, XML, JavaScript

ETL Tools: Talend Studio for big data, Business Object Data Integrator, SQL Enterprise Manager, SQL Server Management Studio, SSIS, SSAS, Visual Studio

Software: Microsoft Office

Databases: MySQL, SQL Server, Oracle, DB2, Microsoft Access

BI Reporting: SQL Server Reporting Services (SSRS), Crystal Reports, Tableau, Power BI

Operating Systems: Windows, UNIX

PROFESSIONAL EXPERIENCE

Confidential

Senior ETL Developer

Responsibilities:

• Created complex stored procedures, triggers, functions (UDF), indexes, tables, views, and other T-SQL code and SQL joins for applications following SQL code standards.
• Installed and configured servers and clients using SQL Server 2016. Upgraded SQL databases.
• Created database maintenance plan for the performance of SQL Server, which covered database integrity checks, updated database statistics, and re-indexing.
• Query optimizations (T-SQL or Query Analyzer) using query analyzer and index tuning wizards.
• Used data modification language (DML) to insert and update data, satisfying the referential integrity constraints and atomicity, consistency, isolation, and durability (ACID) properties.
• Performed database administrative responsibilities to backup database on schedule or ad hoc basis, and restore them as needed by the team.
• Created packages in SSIS with error handling, worked with different transformation methods in SSIS. and loaded data to target databases.
• Designed and developed SSIS packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 2012 for further data analysis and reporting by using multiple transformations provided by SSIS such as data conversion, conditional split, bulk insert, merge, and union all.
• Designed SSIS package for updating the data mart from online transaction processing (OLTP) database and validation of aggregate data from the operational data store (ODS) and OLTP database.
• Designed and developed Talend jobs by using Talend Studio to extract data from various data sources and loading to the enterprise data warehouse (EDWH) for further data analysis and reporting purposes.
• Published Talend jobs to Talend Management Console and created and scheduled plans.
• Worked closely with data business analyst to understand database differences between old and new systems, and client's custom enhancement to develop migration plan.
• Communicated routinely with offshore client to report data quality and possible solutions for data discrepancies.
• Created SQL script to implement test unit cases and ensure data quality.
• Worked closely with QA team to perform front-end testing and report generation to make sure migrated data was compatible with front-end application.
• Provided on-call support during live migration run, and helped analyze and resolve ad hoc issues.
• Developed and deployed reports on server using SSRS and also developed report with Power BI.
• Monitored Talend jobs and SQL Server Agent jobs 24/7. If jobs failed due to different issue, like source data issue, table structure change, etc., immediately created P1 ticket and assigned to related group or, if possible, solved within team.

Environment: SQL Server 2005/2008/2012/2016 , T-SQL, Windows Enterprise Server 2003/2008/2012 , Enterprise Manager, SQL Server Management Studio, SQL Server Business Intelligence Studio, SQL Server Profiler, XML, BizTalk Server 2004, Erwin, Microsoft Visio 2003, SFTP, SAP BODI,SSIS SSRS, Talend data integrator.

Confidential

SSRS Report Developer, SQL Developer, Consultant

Responsibilities:

• Actively involved in agile activities like Sprint planning, Sprint review meeting, Sprint retrospective, and daily standup meeting.
• Developed and implemented a vital process in the migration and transition of all internal reports from preview report site to SSRS.
• Extracted data from internal data system to SSRS.
• Developed, designed and created different reports using SSRS tool, deployed to report server, and managed reports.
• Tracked trouble-ticket requests from end users to fix reports.
• Modified Stored Procedures and formulated basic coding and scripting to be utilized for internal reports.
• Developed and updated stored procedures, views, and user-defined functions for the application.
• Created linked server, new to SQL Server 2008, which enabled T-SQL queries to be issued against multiple servers from a single central management server.
• Scheduled and managed daily, weekly, and monthly operational reports of different clients based on business requirements.
• Wrote parameterized queries, drill through reports, and formatted SQL Server reports in SSRS 2008, 2008 R2, 2012, 2014 using data from ETL loads, SQL Server Analysis Services (SSAS) cubes, and various heterogeneous data sources.
• Defined data warehouse (star and snow flake schema), fact table, cubes, dimensions, and measures using SSAS.
• Worked with report manager for deploying the reports across all environments.
• Installed and configured reporting services and assigned permissions to different levels of users in SSRS.
• Created ad hoc, parameterized reports, linked reports, snapshots, drilldown, and drill through reports using SQL SSRS 2008, 2008 R2, 2012.
• Designed and developed SSIS packages to extract data from various data sources such as Access database, Excel spreadsheet and flat files into SQL Server 2012 for further data analysis and reporting by using multiple transformations provided by SSIS such as data conversion, conditional split, bulk insert, merge, and union all.
• Used SSIS to create ETL packages to validate, extract, transform, and load data to a database (from one server database to another server database).
• Created configuration files to deploy the SSIS packages across all environments.

Environment: SQL Server 2005/2008, 2016, T-SQL, Windows Enterprise Server 2008/2010, Enterprise Manager, SQL Server Management Studio, SQL Server Business Intelligence Studio, SQL Server Profiler, Erwin, Microsoft Visio 2015, SFTP Server.