SUMMARY:

• Experience in Application Design, development, deployment using Waterfall, AGILE model.
• Experience in Data Modeling (ER Model, Dimension Model)
• Good client - facing and presentation skills with ability to write clear, concise technical documentation.
• Extensive experience in BI Solutions (ETL & Reporting) using SSIS which involves various heterogeneous sources and creating packages using SSIS/DTS for Import &, Export of Data and T-SQL programming.
• Hands on experience with performing various SSIS data transformation tasks like Look-ups, Merge, Conditional Splits, Data Conversion, Derived Column and Event Handlers, Error Handlers etc.
• Expertise in creating and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
• Extensive Experience in RDBMS concepts such as Tables, User Defined Data Types, Indexes, Views, Functions, CTE’s, Table Variables and Stored Procedures for various business applications.
• Experience in SQL Optimizing by using SQL Profiler, Index Tuning Wizard, Database Tuning Advisor, DBCC Commands, DMV’s, and Query Execution Plans.
• Experience in conversion of packages from legacy systems (DTS SSIS) and migrating, deploying the SSIS Projects / packages across Dev/UAT/Prod environments.
• Expert in automating process by creating jobs and error reporting using Alerts, mails using SMTP.

TECHNICAL COMPETENCIES:

• MS SQL Server Integration Services 2012/2008 (SSIS)
• MS SQL Server 2012/2008
• OOPS, Design Patterns (Strategy, Proxy), UML (Use Case, Sequence Diagram)
• MS Team Foundation Server 2012 (TFS), MS Visual Source Safe (VSS), Sub-Version 1.5
• ORSYP Dollar Universe Job Scheduler, Enterprise Turn Point (ETP) for UAT/Prod turn creation.
• Microsoft ASP.NET, C#.NET
• MS SQL Server Reporting Services 2008 (SSRS), MS SQL Server Analysis Services 2008 (SSAS)
• Oracle Primavera P6 (Project Management tool)

PROFESSIONAL EXPERIENCE:

Confidential, Louisville, KY

Project Leader, ETL Designer & Developer, SQL Developer

Responsibilities:

• Design and development of ETL Solution like SSIS project and packages
• Experience developing SSIS packages, source is file system or Oracle database and destination is SQL database or flat file. Source data comes in form of compressed file. Leading the Project team on design, development, testing and deployment front.
• Execute SQL task, Data Flow Task, Data Conversion, Derived Columns, Script Task, For Loop Container, Sequence Container, OLE DB Source - Destination, AttUnity Connections, Task Factory Components, Flat File Source - Destination, Event Handlers. Creation of SSIS environment variables and configurations.
• Design, develop, deploy and manage Database objects - tables, functions, stores procedures, indexes, views as per application modules
• Evaluate and analyses the query execution plan as one of the performance tuning task for reducing cost of query execution.
• Created turn requests for the deployment of Database Objects like - scripts, Stored Procedures, Functions; .NET objects; SSIS packages to QA and Production environment. DBA makes use of ETP for deployment of the objects.
• Technical Documentation (Design document, Module s/w Development documents)
• Service Desk and Incident Tickets tracking.
• Process alignment of changes, problems, incidents, business impacts etc.
• Design and Development of SSIS Packages, web application.
• SQL Developments in terms of implementing Stored Procedures, Functions, View
• Mentoring and Guiding offshore team members.
• Assignment tracking and Release Planning.

Environment: Waterfall, AGILE MS SQL Server 2012, SSIS 2012, Visual Studio 2012 TFS, .NET, ASP.NET, ORSYP Dollar Universe, Enterprise Turn Point (ETP) for turn creation. Microsoft Parallel Data Warehouse (PDW)

Confidential, Nashville, TN

Project Leader, ETL Designer & Developer, SQL Developer

Responsibilities:

• Design and development of ETL Solution like SSIS project and packages
• Deployment of the SSIS Project to Integration and Test environment
• Used Database Engine, Integration Services, Reporting Services from SSMS
• Designed, developed and delivered an optimized solution which is based on MS SQL Server 2008 using SSIS.
• Design, develop, deploy and manage Database objects - tables, functions, stores procedures, indexes, views as per application modules
• Evaluate and analyses the query execution plan as one of the performance tuning task for minimizing cost of query execution.
• Used as ETL tool. In most of the SSIS packages, source is XML file, Oracle database, Sybase database and destination is SQL database or flat file.
• Components used - Execute SQL task, Data Flow Task, Data Conversion, Derived Columns, Script Task, For Loop Container, Sequence Container, OLE DB Source - Destination, XML File Source, Event Handlers
• Creation of XML configuration files for SSIS File System deployment
• Creation of architectural design diagrams which helps in understanding the system
• Design, Development and Deployment of Reports

Environment: MS SQL Server 2008, MS SQL Server Integration Services 2008 (SSIS), Sub Version 1.5

Confidential, Charlotte, NC

Project Leader, ETL Designer & Developer, SQL Developer

Responsibilities:

• Leading the ETL Project team on development and unit testing front.
• Creation of Report Security Model. This helps in setting up policies for report users
• Deployment of the reports on TEST, QA and Production environment
• Design architectural aspect of the ETL
• Design and Development of SSIS Packages.
• Guiding junior team members.
• SQL Developments in terms of implementing Stored Procedures, Functions
• Project related documentation (Design of ETL Import and Export Approach, SSIS package Test Cases, SSIS Deployment Guide)

Environment: AGILE, MS SQL Server 2008, MS SQL Server Integration Services 2008 (SSIS), ASP.NET, MS SQL Server Reporting Services 2008 (SSRS), MS Visual Source Safe, Sub-version 1.5

Confidential, NY

Project Leader, Primavera Project Admin, SQL Developer

Responsibilities:

• Leading the Project team on enhancement and unit testing front.
• The reporting services platform implemented by using SSRS 2008 as current capabilities and features of the oracle primavera reporting infrastructure are limited and complex.
• Primavera P6 client administration and support with respect to project managements, resource management and reporting assignment.
• MKS Integrity Client 2009 administration and support with respect to MKS objects which includes Request For Change, User, Requirement Task, Development Task, Testing Task, Release Task, Defect, Workflows, Access permissions, Query.
• SSRS 2005/2008 Report Design, Development, Deployment
• Management of SSRS 2005/2008 Production, Test and Development environment.
• Smoke Testing with respect to MKS items and SSRS 2005/2008 reports.
• Project related documentation (Application System Maintenance & Support document)

Environment: Oracle Primavera P6, MKS Integrity Client 2009, MS SQL Server 2005/2008, MS SQL Server Reporting Services 2005/2008 (SSRS)

Confidential

SSIS (ETL) Solution Designer & Developer, SQL Developer

Responsibilities:

• Understanding the business requirement and propose design solution / strategy.
• Effort Estimation
• Design and Development of Dimension Data Model
• Design and Development of SSIS Packages
• SQL Developments in terms of implementing Stored Procedures, Functions, View
• Design and Development of MOLAP Cube in SSAS
• Design and Development of SQL Agent Jobs
• UAT and Production deployment of the applications
• Project related technical documentation

Environment: Business Intelligence, Data Warehousing, Microsoft Business Intelligence (MSBI), MS SQL Server 2008, MS SQL Server Integration Services 2008 (SSIS), MS SQL Server Analysis Services 2008 (SSAS)

Confidential

.NET Application Developer, SQL Developer

Responsibilities:

• UI development of the assigned modules
• Programming of the assigned modules
• Development of SQL Queries and Stored Procedures.
• Integration Testing, System Testing of the Application
• Deployment of the Web Application on Integration and UAT Server

Environment: Microsoft ASP.NET, C#.NET, JavaScript, Oracle 10g, Model View Presenter (MVP) Pattern

Confidential

.NET Application Developer, SQL Developer

Responsibilities:

• UI development of the assigned modules
• Development of SQL Queries and Stored Procedures.
• Development of SQL issue resolution scripts.
• Integration Testing of the Application
• UAT and Production deployment of the applications

Environment: AGILE, Microsoft ASP.NET, C#.NET, JavaScript, Oracle 9i, Microsoft Visual Source Safe (VSS)

Confidential, Dallas, TX

SSIS (ETL) Designer & Developer, SQL Developer, .NET Developer

Responsibilities:

• UI development and programming of the assigned modules
• Development of SSIS Packages
• Development of SQL Queries and Stored Procedures.
• Development of SQL issue resolution scripts.
• Integration Testing of the Application
• UAT and Production deployment of the applications
• Project related documentation - Application Overview Document.

Environment: Microsoft SQL Server 2005, Microsoft SQL Server Integration Services 2005 (SSIS), Microsoft ASP.NET, C#.NET

Confidential

SQL Developer, .NET Developer, Application Designer

Responsibilities:

• Understanding the business requirement and propose design solution / strategy.
• UI development of the assigned modules
• Programming of the assigned modules
• Implementation of SQL Queries and Stored Procedures
• UAT and Production deployment of the applications
• Release Management
• Project related documentation

Environment: MS SQL Server 2000, MS Visual Studio 6.0, MS .NET 2.0, MS C#.NET, Design Patterns (Strategy, Proxy).