SUMMARY

• MS SQL Server Developer with 10 years of IT experience as a MS SQL Server.
• Extensive experience with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development, Testing and Implementation.
• Leadership experience leading different BI and ETL projects.
• MS SQL Server 2008/2012, Business Intelligence, MS SQL Server Integration Services SSIS, MS SQL Server Reporting Services SSRS.
• Expert in Developing SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from different sources.
• Expert in Creating, Configuring and Fine - tuning SSIS packages, SSRS reports and T-SQL queries.
• Strong experience in designing and developing and deploying enterprise SSRS reports.
• Great knowledge using tools like MS SQL Profiler, Index Tuning Wizard.
• Highly proficient in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Functions, Relational Database Models and Data Integrity, SQL joins and Query Writing.
• Strong experience managing various projects (impact analyses, data analyses, leading meetings, gathering requirements, assigning tasks, development, QA and deployment
• Good Informatica knowledge

TECHNICAL SKILLS

• MS SQL Server 2005/2008/2012
• MS SQL Server Integration Service SSIS
• MS SQL Reporting Services SSRS
• SharePoint
• Microsoft Excel
• Outlook
• MS SQL Profiler
• SQL Query Analyzer
• MS SQL Server Index Tuning Wizard
• T-SQL
• TFS and QC.

PROFESSIONAL EXPERIENCE

Confidential

Sr. SQL Server Developer

Responsibilities:

• SSRS Reports, Data Cleansing and SSIS ETL design and development.
• Create, modify and troubleshoot all SSRS reports and other data related duties, which are related to state, school, and all student reports.
• Design, create and configure ETL / ELT using SSIS.
• Data Cleansing and Database objects tuning.
• Create, modify Stored Procedures and other Database objects for enhancement or Bug fixing.

Confidential

Sr. SQL Server ETL Lead

Responsibilities:

• Led and coordinated various ETL projects.
• Designed, coded, tested and implemented data integration and reporting solutions using SQL Server 2008/2012 Technologies
• Designed and created a process to maintain batch log tables and error logging tables to handle errors using event handlers, error handling.
• Designed and created high level ETL architecture and SSIS package templates to ensure reliability, accuracy and consistency of the overall ETL process
• Extracted, transformed and loaded data using SSIS packages from different servers and data sources.
• Implemented business solution workflows and documentations using Visio and TFS.
• Mentored junior developers (offshore and Onshore)
• Designed, developed, tested, tuned, and implemented relational databases using Microsoft SQL Server solutions including but not limited to stored procedures, views, and functions
• Provided database development support to development team
• Produced ad-hoc queries and developed reports to support business needs (SSRS)
• Supported database administration as needed( backup, restore, compare and update)

Confidential, Agoura Hills, CA

Sr.SQL Server Developer/ETL/ Production Support

Responsibilities:

• Developed, supported, tested, and managed more than 300 SSIS Packages scheduled to run daily using JAMS.
• Project lead for the CFPB project (Impact analyses, data analyses, data mapping, development and testing).
• Participated in the Server database Migration - Modified and standardized all of the existing SSIS packages to point to the new servers (Production and analytical) - to improve performance.
• Participated in creating Lower Level environment (Dev and QA servers)
• Designed, created and developed numerous SSIS packages to download/upload data from/into different sources and destinations (SQL Server/ SharePoint / Oracle /TeraData/Flat File/XML File... ETC) to meet the LOB needs ( Monthly release)
• Monitored the server performance and preparing a daily performance report.
• Participated in designing a standard SSIS Template to organize the ETL process for the entire team.
• Participated in gathering requirements, data analyses and data mapping. (HLD, LLD)

Confidential, Irvine, CA

Tech Ops Support

Responsibilities:

• Designed and developed SSIS packages to load data from different source like SAP DW, Excel, Flat File, SharePoint, SQL and Oracle Database to SQL Server 2008 using different tasks and tools like, foreach loop, Lookup, Union, SQL Task, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and XML Task.
• 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.
• Created 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.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008.
• Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS 2008
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Created various database object like stored procedures, functions, tables, views
• 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.

Confidential, Columbus, OH

Tech Ops Support

Responsibilities:

• Implemented the Data Cleansing using various transformations such as Lookup, Fuzzy Lookup and Derived Column.
• Migrated SSIS packages from development server to production server using package configuration.
• Created SSRS reports (Parameterized, Linked, Snapshot, Cached, Ad hoc, Click through, Drill down, Drill through, Sub reports)
• Designed and implemented Parameterized and Cascading Parameterized reports using SSRS.
• Deployed generated reports onto the Report Server to access it through browser.
• Responsible for generating annual reports based on the growth of company with respect to customers.
• Created Complex Stored Procedures, Triggers, Functions, Indexes, Tables, and Views.
• Improved Performance of the database by creating Clustered and non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
• Conducted user training sessions and supported the requests for enhancements, modifications and new reports.

Confidential

Data Analyst

Responsibilities:

• Analyzed, reviewed and trend forecasted complex data
• Presented analysis and interpretation for operational and business review and planning
• Supported short and long term operational/strategic business activities / forecasting
• Developed recommended business solutions through research and analysis of data and business process and implement when appropriate
• Data cleansing
• Improve business processes and reports by identifying deficiencies, and development and implementation of recommended solutions
• Determined goals, developed plan, led implementation, and supported training
• Presented results and development plans to the executive level