SUMMARY:

• Near to 12 years of IT Experience in the Analysis, Design, Architect, Development and Implementation.
• Strong technical knowledge in SSIS, SSRS, SQL - SERVER 7/2000/2005/2008 and Worked on several Data warehouse Projects and designed OLAP/OLTP databases.
• Successfully completed several ASP.Net Projects using C# and VB.Net

TECHNICAL SKILLS:

Operating System: Windows 9x/NT 4.0/2000/2003 , Linux, UNIX

Languages: C#

GUI: Visual Basic 6.0, VB.Net

Internet Technologies: ASP 3.0, ASP.NET, Java Script, VBScript

Back-End: MS SQL Server 7.0/2000/2005/2008 , MS Accesses

Middleware: COM, DCOM

Reporting Tool: Crystal Reports 10.0,SSRS

Data Warehousing: MS Business Intelligence (SSIS, SSAS), Data Stage, Microstrategy

Data Modeling: Erwin, Visio, EA

PROFESSIONAL EXPERIENCE:

Confidential, Nashville, TN

Sr. DW Consultant

Responsibilities:

• Involved in Analyzing the different Source and Confidential System.
• Designed the Package differently for each feed and developed ETL packages for moving data into warehouse using SSIS2008.
• Packages are tested using the End to End Auditing built inside the package and Schema manually.
• Responsible for Deploying the SSIS packages and scheduling the package through Jobs.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Deploy SSIS Package into Production/QA/INT and used Package configuration to export various package properties to make package environment independent.
• Implemented Event Handlers and Error Handling in SSIS packages and notified job status to DWH data users.
• Imported data from text files and excel spread sheets into SQL Server 2008 database using SSIS package.
• Used Query Execution Plan, Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Used Database Engine Tuning Advisor tool for analyzing the Procedures and Queries for effective Indexes and Statistics.
• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.
• Involved in scheduling, creating snapshots and subscriptions for the reports.
• Responsible for writing SQL Agent jobs to Schedule the packages.
• Responsible for monitoring all the Jobs scheduled in the Prod/QA/INT Environment. To do this task, I have design and Automated the job status package to monitor the package and send info on the job status.
• C# Script is used for coding the Script component and Script task (SSIS 2008)

Environment: SQL Server 2008/SSIS/SSRS/C#

Confidential, Minneapolis, MN

Project Lead/ Sr. SSIS Developer/ Architect

Responsibilities:

• Analyzed the System and determined the business requirement needs.
• Involved in Design, Architecture of the System and worked as an onsite Coordinator.
• Developed ETL packages for moving data from DB to DB using SSIS2005.
• Packages are tested using the End to End Auditing built inside the package.
• Responsible for Deploying the SSIS packages and scheduling the package through Jobs.
• Prepared the SSIS Package Deployment and used Package configuration to export various package properties to make package environment independent.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Used Query Execution Plan, Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Used Database Engine Tuning Advisor tool for analyzing the Procedures and Queries for effective Indexes and Statistics.
• Worked with T-SQL to create Tables and stored Procedures.
• Worked on Parameterized Reports and Sub Reports.
• Responsible for writing SQL Agent jobs to Schedule the packages.
• VB.NET Script is used for coding the Script task (SSIS 2005)

Environment: SQL Server 2005/SSIS/SSRS/VB.Net

Confidential, Redmond, WA

ETL Architect

Responsibilities:

• Involved in writing the Technical design document.
• Involved in migrating the Epiphany ETL extractors to SSIS 2005 Packages and OLAP (Snow Flake Schema) database.
• Packages are tested using row count logs and Schema manually.
• Responsible for Deploying the SSIS packages and scheduling the package through Jobs.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Prepared the SSIS Package/Epiphany extractor deployment and used Package configuration to export various package properties to make package environment independent.
• Implemented Event Handlers and Error Handling in SSIS packages/Epiphany extractors and 24/7 supports provided for the ETL operations. In case of failure, it will be notified to the marketing users
• Used Query Execution Plan, Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Used Database Engine Tuning Advisor tool for analyzing the Procedures and Queries for effective Indexes and Statistics.
• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.
• Involved in scheduling, creating snapshots and subscriptions for the reports.
• Responsible for writing SQL Agent jobs to Schedule the packages.
• VB.NET Script is used for coding the Script task (SSIS 2005)
• Developed ASP.NET pages for maintaining the Marketing users.

Environment: SSIS 2005/ SQL Server 2000/5/Epiphany/ASP.NET/C#

Confidential, Redmond, WA

ETL Architect

Responsibilities:

• Involved in designing the package, normalizing the table in OLAP (Snow flake schema).
• Developed ETL packages for moving data from DB, Web Services to DB using SSIS2005.
• Responsible for Deploying the SSIS packages and scheduling the package through Jobs.
• Prepared the SSIS Package Deployment and used Package configuration to export various package properties to make package environment independent.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Used Query Execution Plan, Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Used Database Engine Tuning Advisor tool for analyzing the Procedures and Queries for effective Indexes and Statistics.
• Worked with T-SQL to create Tables and stored Procedures.
• Worked on Parameterized Reports and Sub Reports.
• Responsible for writing SQL Agent jobs to Schedule the packages.
• Developed ASP.NET pages to store the user preference regions for viewing the report.
• Configured the IIS on Windows Server 2003 and deployed ASP.Net build.

Environment: SQL Server 2005/SSIS/C# /ASP.Net

Confidential, Redmond, WA

ETL Architect

Responsibilities:

• Developed ASP.NET Pages to support Administration UI, which is used to set system wide configuration settings.
• Dashboard UI, which allows users to view the server performance dashboard reports, with features like personalization of the default view, drill-down views, graphical and tabular views, basic/advance filters, toolbar customization to customize the graphs on home page
• Involved in designing the OLTP schema for the system.
• Responsible for Unit testing the ASP.NET pages and Stored Procedures.
• Used Query Execution Plan, Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Used Database Engine Tuning Advisor tool for analyzing the Procedures and Queries for effective Indexes and Statistics.
• Worked with T-SQL to create Tables and stored Procedures.
• Configured the IIS on Windows Server 2003 and deployed ASP.Net build.

Environment: SQL Server 2000/5/C# /ASP.Net/VC++SWS

Confidential, TX

Sr. Application Engineer

Responsibilities:

• Involved in writing the Technical design document.
• Developed ASP.NET pages for different modules (Planning, Purchase, Receipt, Issue, BOM, Multi-Site Material Consolidation) on the need basis.
• Used Query Execution Plan, Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Worked with T-SQL to create Tables and stored Procedures.
• Worked on Parameterized Reports and Sub Reports.
• Developed Generalized Lookup component, which was used across the ASP.NET project
• Configured the IIS on Windows Server 2003 and deployed ASP.Net build.

Environment: SQL Server 2000/C# /ASP.Net/VB.NET/Crystal Reports

Confidential

Module Lead

Responsibilities:

• Developed ASP.NET pages for E-pay and Inbound tracker
• Developed VB 6 application for Falcon Integrator
• Used Query Execution Plan, Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Worked with T-SQL to create Tables and stored Procedures.
• Worked on Excel Reports, Generated by the .NET Application
• Developed the Interface for interacting with the DAVOX dialer.
• Configured the IIS on Windows Server 2003 and deployed ASP.Net build.

Environment: SQL Server 2000/VB 6.0/VB.NET/ASP.NET/Davox Dialer/ Mainframe Replicator.