SUMMARY

Enthusiastic, Flexible and Goal oriented team player with extensive experience as SQL server developer with more than 7 years of experience in Banking, Insurance and Information Technology. With strong understanding of data & analytics worked in analyzing, designing, tuning, and developing Client/Server database applications and various segments of Software Development Life Cycle (SDLC), using MS SQL Server, SQL Server Integration, Reporting & Analysis Services. Worked extensively on T - SQL coding and creating reports.

TECHNICAL SKILLS

Operating system:  MS Windows 2010/2003/XP/2000/98, MS-DOS, Unix-Ubuntu

Programming Language:  T-SQL, PL/SQL, VB, C, C#, Java(Basics)

Database:  SQL Server 2012/2008/2005 , MS Excel, Oracle, MS Access, Dbase

BI Tools:  SQL Server BI Development studio (BIDS), MS Visual Studio, Power Builder

SQL Tools:  SSMS, SSIS, SSRS, SSAS

Methodology: Agile, Scrum process, Water Fall

Packages:  Microsoft office 2014/2010/2007/2003/2000 , Ms Visio

PROFESSIONAL EXPERIENCE

Confidential, Bloomington, IL

Sr MS SQL /ETL Developer

Responsibilities:

• Responsible for ETL operations using SQL Server Integration Services (SSIS). Involved for sending and reviewing data from heterogeneous sources like (Excel, CSV, Oracle, flat file).
• Created many SSIS packages using Import/Export Wizard. Designed many Packages using SSIS Designer by using Control Flow and Data Flow Tasks with ETL Tool.
• Worked on Agile/scrum.
• Developed and deployed SSIS packages for ETL from OLTP and various sources to stage in the data warehouse to perform Aggregate, Audit, Derived Columns, Lookup, Fuzzy Lookup, Merge Join, Conditional Split, OLE DB Command and more. Performed ETL mappings using MS SQL Server Integration Services.
• Worked with Parameters and Expressions in SSIS package.
• Used Control Flow elements like Sequence Container, For- each Loop Container and For Loop Container in SSIS.
• Used Execute SQL task, Execute Process task, execute packages task, File System task, and Send Mail task in SSIS.
• Enforced data consistency by adding data viewer to the transformations and created dynamic packages by using variables to store the data into SQL-Warehouse.
• Generated reports using SSRS that could be used to send information to different Primary Vendors, Clients and Managers.
• Extensively used SQL Server Reporting Services 2008 with relational and multidimensional data.
• Developed reports with charts, matrixes, and sub report. Deployed reports on web server for user viewing in windows and share point mode.
• Involved in unit testing against the developed packages and reports.
• Written complex SQL statements using joins, sub queries and correlated sub queries.
• Analyzing and writing Stored Procedures, Functions, Index & Triggers in SQL.
• Used Execution plan for Performance Tuning.
• Participated in Databases Architecture and data modeling design.
• Deploy SSAS OLAP cubes on development and production server for performance analysis.

Environment: Windows XP, C#, VB, T-SQL, MS SQL Server 2014, MS SQL Server Analysis Services 2012, MS SQL Server Integration Services 2012.

Confidential, WASHINGTON, DC

Sr. SQL/ ETL Developer

Responsibilities:

• Developed packages to pull data from heterogeneous sources, transform the data per the business requirement and load into the destination tables.
• Transformed the data using different SSIS transformations like Aggregate, split, join, merge, derived column, Multicast, Term extraction and data conversion of SQL Server Integration Services (SSIS).
• Worked with Data viewer in Data flow task for debugging package and Logging by enabling it to record the events and error message from the package.
• Worked with configuration process for dynamic connection string.
• Worked with Job scheduling for Execution of Package in development and Production Environment.
• Developed standard reporting structures, dashboards, drilldowns, and multilevel drill down, cascading, parameterized and sub reports etc. with different types of format.
• Extensively worked in migrating office writer reports to SSRS-2008.
• Responsible for ongoing maintenance and change management to existing reports and optimize report performance in SSRS-2008.
• Wrote and maintained database documentation, including data standards, procedures, definitions for the data dictionary and logical and physical models of the databases.
• Coordinated in the day to day activities of the team relating to DB objects.
• Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis.

Environment: SQL Server 2012/2008R2 Enterprise Edition, SSIS/SSRS 2012, Visual Studio 2012, VB.net, TSQL, .Net framework, MS Access, Windows Server 2003.

Confidential New York, NY

MS SQL /BI developer

Responsibilities:

• Developed SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, Oracle, flat file) by using multiple transformations provided by SSIS such as Slowly Changing Dimension, Data Conversion, Derived Column, Lookup, Conditional Split, Bulk Insert, Merge and union all.
• Worked with project lead and business users to understand business processes, gather and documented project requirements, and translate them into ETL Design Specifications.
• Created data mapping documents for ETL process (SSIS). Worked on writing the insert, update and delete quires joining multiple tables to make changes in the staging tables.
• Performed tasks like execute SQL task, data flow task, file system task for ETL process.
• Performed error handling in SSIS using Event Handling and logging.
• Worked with control flow and data flow tasks like Containers, Precedence Constraints, and Execute SQL task in SSIS.
• Worked with Deployment of package using Deployment Utility.
• Experience supporting business processes for financial fund source management, contract management, and budgetary reporting
• Created different types of Tabular, Matrix, Drill-Down, Cascaded parameterized, Chart report and Sub reports in multiple formats using SSRS.
• Used Parameter, Expression, Grouping, Total and Formatting in SSRS reports.
• Worked with DBA to design/implement/maintain the Data Warehouse and Business Intelligence solutions.
• Analyzed data for data quality and improved data architecture.
• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
• Designing and developing SQL Server 2008 Databases, Tables, Indexes, Stored procedures, Views, Triggers.

Environment: SQL Server 2008R2/2012 Enterprise Edition, SQL Server Data Tools, SQL Server Management Studio, SSIS, SSRS, SSAS, TSQL, Visual Studio, Excel

Confidential, PITTSBURGH, PA

MS SQL / BI Developer

Responsibilities:

• Created SSIS Packages using Execute SQL task, Data Flow Task, Merge Join, Derived column, Sort, Data conversion, Conditional split, union all, Pivot Transformation, Fuzzy Lookup, Term extraction, Aggregate according to the business requirements.
• Created logging for ETL load at package and task level to log number of records processed by each package and task in a package using SSIS.
• Used Script task for Data Flow and Error Handling in SSIS.
• Created a sustainable reporting practice and means of storing and sharing/ publishing the information and reports using subscriptions.
• Contributed to develop ETL/reporting standards for the organization.
• Database backup and restoring it.
• Wrote efficient T-SQL queries using complex stored procedures, functions, views, triggers, and indexes on MS SQL Server 2012.
• Built indexes, views, store procedures, functions, and triggers on MS SQL Server 2012.
• Increased query performance by performing monitoring, tuning, and Optimizing Indexes tasks using SQL Profiler.
• Created and updated database objects like Complex stored procedures, joins, tables, User Defined functions (UDF’s) for business logic.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.

Environment: MS SQL Server 2012, MS SQL Server Management Studio (SSMS), MS SQL Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS)

Confidential

MS SQL / SSIS/SSRS/BI Developer

Responsibilities:

• Create a Package to update the data warehouse database using SSIS.
• Involved in re-design, re-code, and deploy new data extractions using SSIS, and designed and produced documentation of data transformations for all extractions.
• Worked with heterogeneous sources such as flat files and relational sources.
• Worked with various sources in the data flow tasks and used various transformations. Some of the transformation are Row count, merge, merge join, union, Look up transformation, audit, aggregate.
• Worked extensively on bad data with configuring the error output, Conditional split, derived column, fuzzy lookup transformation.
• Deployed the packages in catalog method and worked on job scheduling and send mail task.
• Used Reporting objects like Tabular, Matrix, Sub Reports, Parameterized reports using SSRS.
• Created report in BIDS, and deployed & executed in Report Manager.
• Took complete ownership of DB on data comparison, troubleshooting and performance.
• Interacted with the Business Admin and gather the requirements and analyzed them.
• Worked closely with clients as part of a development team to evaluate requirements and developed BI / DW solutions.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Involved in understanding the business requirements & existing data model.
• Designed and developed monthly, Bi- Weekly, Tax Reports for our Clients

Environment: MS SQL Server 2008/2008R2, T-SQL, SQL Server Reporting services, SQL Server Integration Services, Management Studio, SQL server Profiler.