PROFESSIONAL SUMMARY:

• Over 8 years of IT experience including Database Design, Development, Implementation and Administration in various domains such as Telecommunication, Insurance, Banking, Healthcare and Transportation.
• Experience in SSIS package scripting, scheduling, monitoring, deployment and production support.
• Expert in designing (development) and deployment of SSIS package from various sources like MS access, Oracle, DB2, Excel, Microsoft SQL Server, Flat file, Web Services and XML.
• Expertise in data models, data flows and data dictionaries.
• Good knowledge of Normalization and De - Normalization techniques.
• Experience in SQL Server scripting- Stored Procedures, Triggers, User-defined Functions, Views, indexes and constraints.
• Transformed data using Data Transformation Services (DTS) (2000) and SQL Server Integration Services (SSIS) (2005/2008/2008 R2/2012).
• Expertise in configuring and creating SSIS solutions for ETL and Business Intelligence Process for Data Integration and Migration services.
• Proficient in Merging data from various Heterogeneous Data sources, Populating Dimension and Fact tables in Data warehouses and Data Marts, Cleaning and Standardizing data loaded into OLTP and OLAP databases using SSIS.
• Expertise in creating and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
• Experience in managing and automating Control flow, Data flow, Events and Logging programmatically using Microsoft .NET framework for SSIS packages.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Experience in Microsoft Visual C# in script component of SSIS.
• Extensive knowledge of Designing, Developing and deploying various kinds of reports using SSRS using relational and multidimensional data.
• Expertise in writing T-SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Experienced using FTP and SFTP servers to upload and receive files.
• Very good experience in working with several types of reports including drill-down, drill through, sub reports, matrix, charts, graphs, Power view, Excel PowerPivot and front end UI application dashboard portals.
• Skilled in error and event handling: precedence Constraints, Break Points, Check points and Logging.
• Experience in Troubleshooting Report Processing, Subscription, Delivery and Configuration Problems.
• Good knowledge on Oracle PL/SQL.
• Experience in production support, ETL executions and resolving root causes.
• Excellent knowledge in Dimensional Modeling using Kimball methodology, Star/Snowflake Schemas and ODS.
• Good experience with Database Tuning Advisor, Performance Monitor and SQL Profiler for tracing and auditing.
• Experience in SQL administration activities like installation, configuration, maintenance, backup and restore of SQL Server databases.
• Extensively used Team Foundation Server (TFS), Visual Source Safe and Tortoise Subversion.
• Holding a valid H1-B-visa. (Valid till end of 2016).

TECHNICAL SKILLS:

RDBMS: SQL Server 2000/2005/2008/2008 R2/2012, Oracle, Teradata, MS Access, Sybase, IBM DB2

Database Tools: SQL Server Management Studio, MS Access, MS Excel, Query Editor

Programming Languages: T-SQL, PL/SQL, C#, VB.NET, HTML and Shell Scripting

Reporting Tools: Crystal Reports 2008, SQL Server Reporting Services

ETL Tools: Data Transformation Services (DTS), SQL Server Integration Services

BI Tool: Business Objects, SSIS,SSRS, SSAS

Data Modeling: ER-Win, MS- Visio 2003/2007

Operating Systems: Windows Server 2003, Windows 2000 Advanced Server/Professional, Windows XP Professional

PROFESSIONAL EXPERIENCE:

Confidential, Louisville, KY

BI Developer

Responsibilities:

• Involved in the complete Software Development Life Cycle including Analysis, Design, Implementation, Testing and Maintenance.
• Developed SQL Server 2012 Databases objects i.e. Schemas, Tables, Indexes, Stored procedures and Views.
• Written complex SQL statements using joins, sub queries and correlated sub queries and Query expression
• Extracted data from various sources like SQL Server 2012, Oracle 11g, IBM DB2, Flat files, XML and Web services from Client servers and through FTP.
• Involved in re-design, re-code, and deploy new data extractions using SQL Server Integration Services, and designed and produced documentation of data transformations for all extractions.
• Involved in creation/review of functional requirement specifications and supporting documents for business systems, experience in database design process and data modeling process.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• The packages created included a variety of transformations, for example Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
• Monitored Full/Incremental/Daily Loads and support all scheduled ETL jobs for batch processing.
• Created SSIS packages for File Transfer between locations using FTP task.
• Involved in daily code drops and archives on the production databases during maintenance windows.
• Created automated processes for activities such as database backup and sequential running of SSIS Packages using SQL Server Agent job.
• Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Created 31 days of daily table partition SQL Server Agent job on development and production tables.
• Provided support to database Servers in Production, QA and Development.
• Created ETL process and data mapping documents for future s.

Environment: MS SQL Server 2012, BIDS/Data tools (SSIS), T-SQL, C#, Share Point Portal Server, TFS, Oracle 11g, TOAD, IBM DB2 9.5.1, Visual Studio 2012.

Confidential, Atlanta, GA

SSIS/ETL Developer

Responsibilities:

• Extracted data from different sources and stored the data into the intermediate Staging Database using SSIS ETL tool.
• Maintained all the SQL documents including installation and data conversion Procedure documents.
• Complex business requirements were transformed into ETL using a variety of transformations like Aggregate, Derived Column, Data Conversion, Union All, Merge Join, and Lookup.
• Created SQL Server Reports for Management using SSRS. Tasks included defining requirements, design, develop, test, implement and maintain reports using SSRS 2012.
• Developed several reports with consistent drill-down functionality including Drilldown reports, Summary reports and Master Detail reports.
• Wrote complex Stored Procedures, coding and triggers to capture updated and deleted data from OLTP systems.
• Developed Custom Functions, Manual Running Totals and Complex Formulas for reports.
• Experienced in implementation of strong referential integrity and auditing by the use of triggers.
• Prepared the complete data mapping for all the migrated jobs using SSIS.
• Deployed the SSIS Packages to the MSDB as well as File System based on the requirements.
• Designed ETL Packages with Microsoft SSIS 2012 to pull data from various sources like DB2, SQL Server, Flat Files and other systems to individual Data marts which ultimately go into Enterprise Data Warehouse (EDW).
• Involved in the development of custom SQL, T-SQL, custom stored procedures, functions and triggers.
• Created the automated processes for the activities such as database backup processes and SSIS, SSRS Packages to run sequentially using SQL Server Agent job and windows Scheduler.
• Developed Cross-Tabbed and Sub-Reports in SSRS 2008R2.
• Designed and Developed matrix, tabular and parametric Reports in the SQL Server Reporting Services 2008R2.
• Used breaks, calculations, sorts, filters and sections to enhance data presentation in reports.
• ETL process was documented for future s.

Environment: MS SQL Server 2008R2/2012, BIDS/Data tools (SSIS, SSRS), T-SQL, C#, Share Point Portal Server,TOAD, Erwin, TFS, Oracle, Visual Studio.NET 2010.

Confidential, Louisville, KY

SSIS/ETL Developer

Responsibilities:

• Responsible for all project lifecycle phases, from specifications and coding through deployment, testing, debugging, documentation and maintenance.
• Managing physical database design & creation, devising strategies for backups, recovery & fine-tuning.
• Responsible for monthly releases and production support.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Created SSIS Packages using SSIS Designer to export heterogeneous data from OLEDB Source (Oracle), Excel Spreadsheet to SQL Server 2008R2.
• Developed T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Extensively working with off shore team and coordinating the workflow based on everyday Project Status.
• Created robustSSISpackages with row counts, verifications, notifications, security and production servers, ftp, compress txt files, indexing and table constraints.
• Implemented complex business requirement in backend using efficient stored procedures and flexible functions, and facilitated easy implementation to the front end application.
• Loading source files in to raw tables for data mining and data ware housing tasks.
• Modifying database programs to increase processing performance, referred to as Performance tuning.
• Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports and Charts.
• Generated and formatted Reports using Global Variables, Expressions and Functions for the reports.
• Promoted database objects from test/develop to production. Coordinated and communicated production schedules within development team.
• Experience in scheduling and deployment of reports and uploading files to a report server catalog from the report manger.
• Tested the new applications in various environments including Dev, QA and Production.

Environment: MS SQL Server 2008/2008R2, SQL/SSIS/SSRS, C#, T-SQL, Agile, Visual Studio.NET 2008, Oracle, .XML, TFS, SharePoint 2010, MS Office.

Confidential, Dallas, TX

BI Developer

Responsibilities:

• Created and developed data dictionary, tables, views, indexes, functions and advanced queries for databases by using Query Analyzer and SQL Server Enterprise Manager.
• Created reports by retrieving the data from cube using MDX reports.
• Involved in creating SSIS jobs to automate the reports generation, cube refresh packages.
• Designed MDX queries to retrieve data from SSAS cubes.
• Designed high level ETL architecture for overall data transfer from OLTP to OLAP with the help of SSIS.
• Performed operations like Data reconciliation, validation and error handling after extracting data into SQL Server.
• Set package configuration in SSIS to redirect path from test environment to production environment.
• Using SSAS created OLAP cubes for data mining and created reports from OLAP cubes using SSRS.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services.
• Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
• Experience in moving the data from heterogeneous data sources like oracle, xml etc. to SQL using SSIS.
• Lead the development of automated DTS/SSIS packages to extract, transfer, load and convert data from various.
• Worked on Huge Data Transfers from & to SQL Server Databases using SSIS, and used configuration files and Environment variables for production deployment.
• Created necessary steps to enhance user response time by improving queries and their index selections to minimize IO and eliminate table scans.
• Enhancing the SSIS Packages and deploying from development server to production server.

Environment: SQL Server 2005/2008, Query Analyzer, SQL/SSIS/SSRS, C#, Visual Studio.NET, ProClarity Server, TFS, XML, BizTalk, MS Excel, Oracle, Visual Source Safe.

Confidential

SQL/SSRS Developer

Responsibilities:

• Gathered functional requirements and designed the technical specifications.
• Developed complex stored procedures, functions, views and triggers in SQL Server.
• Experienced in development of extracting, transforming and loading (ETL), maintenance and support of enterprise data warehouse system and corresponding marts.
• Developed stored procedures to transform the data from enterprise data warehouse to APT data mart to build dimensions and load data to fact tables.
• Provided production support by running Month End process every month to load the shipment history for respective divisions in the SQL database.
• Created DTS package to schedule the jobs for batch processing.
• Performing intensive data analysis, testing for quality assurance, and migrating releases into stage and production environments.
• Extensive experience in creating several reports such asdrill down reports, parameterized reports, linked reports, sub reports, Matrix Reports and Chart reportsusingSQL Server Reporting Services(SSRS).
• Utilized Pivot tables to provide structure to Reports in proper format
• Experience in generating reports using linked reports, sub reports and filters in SQL server reporting services (SSRS).
• Generated various Report models on Views (due to security issues) and deployed them on to the production reporting server and generated various Report models and ad-hoc reports.
• Worked on DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.
• Deployed the packages on staging and production.
• Designed Star Schema and Snow flaked schemas in the process of data modeling.

Environment: UNIX, Shell Scripting SQL/SSIS /SSRS, VB.NET, Enterprise Manager, SQL Profiler, DTS, T-SQL, Erwin, Oracle, Rational Clear Quest, BCP, Replication

Confidential

SQL Server Developer/ DBA

Responsibilities:

• Designed, implemented and administrated SQL Server 2000/2005 database.
• Created and Modified Stored Procedures, Triggers, Views according to the business.
• Wrote T-SQL statements using DML and DDL for retrieval of the data.
• Developed various reports to validate the data between source and the target systems.
• Automated scripts in TSQL, DTS, and BCP to import data from various ODBC sources into production SQL Server databases.
• Created indexes, constraints and rules on database objects.
• Used Database Engine Tuning advisor and SQL Profiler for Monitoring memory, processor, Disk I/O and SQL Queries.
• Prepared policy documents for Installation and Configuration of MS SQL Server 2005.
• Created and monitored Database maintenance plans for checking database integrity.
• Established backup and recovery procedures for remodeled databases and implemented automated jobs for database backup.
• Created Jobs, Alerts and scheduled DTS to generate Reports.
• Performance tuning to optimize SQL queries using query analyzer.

Environment: SQL Server 2000/2005, Microsoft Visual, VBScript, Microsoft Visio, Windows 2000/XP, IIS 5.0, Clear Quest, Replication.