Employment History

Confidential

MS ETL Developer

Responsibilities:

• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Designed and tested Unit, Integration and Regression packages to extract, transform and load data using SSIS
• Participated in the full lifecycle of ETL software development - analysis, design, build, documentation and testing for the project.
• Migrated data from Heterogeneous data Sources and legacy system to centralized SQL Server databases using SQL Server Integration Services SSIS
• Wrote complex queries, DDL, DML, functions, triggers, stored procedures, and views.
• Created , designed , developed SSIS packages for data Importing, Cleansing and Parsing. Extracted, cleansed and validated data from Excel, Text files and XML files using OLE DB connection.
• Tuned several slow running queries in Production. Implemented Indexes and re-indexed to achieve time performance.
• Performance tuning of SQL queries and stored procedures using SQL profiler and index tuning advisor.
• Extensively done data modeling.
• Designed, developed, modified and enhanced the database structures and database objects.
• Generated various Report models on Views and deployed them on to the production reporting server
• Used complex expressions to Calculate, Group, Filter, Parameterize, and Format the contents of the report according to the requirement.
• Created standard report Subscriptions and Data Driven report Subscriptions
• Transferred data into various formatted files and immediately updated my managers with the automated email systems.
• Used Agile for Software development methods .
• Used SSIS to create ETL packages .dtsx files to validate, extract, transform and load data to data warehouse databases
• Used configuration files in SSIS to ease the process of moving the packages across servers
• Optimized queries by looking at Execution Plan for better tuning of the database.
• Monitored, optimized and Performance Tuning of Regression Servers using Performance monitor, SQL Profilers, Activity Monitor.
• Tested applications for performance, data integrity, validation issues, job scheduling and alerts.

Environment:

MS SQL Server 2005/2008,T-SQL, 2012 SQL Server Reporting Services 2005/2008,2012, SQL Server Integration Services 2005/2008, MS Excel, Microsoft Visual Studio Team Foundation Server 2010

Confidential

MS SQL Server Developer/ETL Developer

Responsibilities:

• Extensively done data modeling.
• Created T-SQL queries for schemas, views, stored procedures, triggers and functions for data migration. .
• Created , designed , developed SSIS packages to import and export data from Excel, Xml and Text files and transformed data from various data sources using OLE DB connection by creating various SSIS packages.
• Created SQL scripts to insert/update and delete data in MS SQL database. Created database tables, wrote stored procedures to update and clean the old data.
• Extract, Transfer and Loading ETL of data from flat file, excel sources, etc using SSIS
• Participated in the full lifecycle of ETL software development - analysis, design, build, documentation and testing for the project.
• Migrated data from Heterogeneous data Sources and legacy system DB2, Access, Excel to centralized SQL Server databases using SQL Server Integration Services SSIS
• Wrote complex queries, DDL, DML, functions, triggers, stored procedures, and views for new and existing applications.
• Created SSIS packages to import and export data from Excel, Xml and Text files and transformed data from various data sources using OLE DB connection by creating various SSIS packages.
• Tuned several slow running queries in Production. Implemented Indexes and re-indexed to achieve time performance.
• Performance tuning of SQL queries and stored procedures using SQL profiler and index tuning advisor.
• Used SSRS to create, execute, and deliver tabular, matrix, and charts reports.
• Designed, developed, modified and enhanced the database structures and database objects.
• Generated various Report models on Views and deployed them on to the production reporting server
• Used complex expressions to Calculate, Group, Filter, Parameterize, and Format the contents of the report according to the requirement.
• Created standard report Subscriptions and Data Driven report Subscriptions
• Transferred data into various formatted files and immediately updated my managers with the automated email systems.
• Used SSIS to create ETL packages .dtsx files to validate, extract, transform and load data to data warehouse databases
• Used config files in SSIS to ease the process of moving the packages across servers
• Optimized queries by looking at Execution Plan for better tuning of the database.
• Monitored, optimized and Performance Tuning of Regression Servers using Performance monitor, SQL Profilers, Activity Monitor.
• Tested applications for performance, data integrity, validation issues, job scheduling and alerts.

Environment:

MS SQL Server 2005/2008, SQL Server Reporting Services 2005/2008, SQL Server Integration Services 2005/2008, MS Excel, MS Windows Server 2003, Oracle 10g/9i.

Confidential

MS SQL Server Developer/ETL Developer

Responsibilities:

• Installed, upgraded and migrated databases from Oracle database to MS SQL Server 2005/2008.
• Generated reports using MS SQL Server Reporting Services 2005/2008 from OLTP and OLAP data sources.
• Extensively done data modeling.
• Developed ad-hoc reports, drill through reports, drill down reports, parameterized reports, and other report models using MS SQL Server 2005 SSRS.
• Constructed the OLAP cube using SSAS and used SSIS to transform the data into OLAP.
• Created T-SQL queries for schemas, views, stored procedures, triggers and functions for data migration. Involved in the project from planning stage to pushing codes to production.
• Designed ER diagrams and mapped the data into database objects and performed normalization of the database in OLTP.
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agent using SSAS.
• Wrote MDX scripts to create name sets and calculated members and created reports by dragging data from cube in SSAS.
• Worked as a technical expert in the design, development, and maintenance of OLAP cubes and databases.
• Created , designed , developed SSIS packages .
• Created new logical and physical design of database to fit new business requirement and implemented new design into SQL Server 2005.
• Performed system study and requirements analysis, prepared data flow diagrams, entity relationship diagrams, data diagrams, and table structures to store the data.
• Created SQL scripts to insert/update and delete data in MS SQL database. Created database tables, wrote stored procedures to update and clean the old data and also helped the front end application developers with their queries.
• Created SSIS packages to import and export data from Excel, Xml and Text files and transformed data from various data sources using OLE DB connection by creating various SSIS packages.
• Designed and created different ETL packages using SSIS and transferred data from Oracle source to MS SQL server destination.
• Performance tuning of SQL queries and stored procedures using SQL profiler and index tuning advisor.
• Configured SQL mail agent for sending automatic emails on errors and developed complex reports using multiple data providers, user defined objects, charts, and synchronized queries.

Environment: MS SQL Server 2005/2008, MS SQL Server reporting services SSRS , Integration Services SSIS , Analysis Services SSAS , T-SQL, SQL Server Query Analyzer, Visual Studio, Windows XP, Window Server 2003/2008.

Confidential

MS SQL Server/SSRS/ SSIS Developer

Responsibilities:

• Migrating databases from SQL 2005 to SQL 2008 in production and test environments.
• Wrote complex queries, DDL, DML, functions, triggers, stored procedures, and views for new and existing applications. Extensively done data modeling.
• Used SSRS to create, execute, and deliver tabular, matrix, and charts reports.
• Designed, developed, modified and enhanced the database structures and database objects.
• Generated various Report models on Views and deployed them on to the production reporting server
• Used complex expressions to Calculate, Group, Filter, Parameterize, and Format the contents of the report according to the requirement.
• Created standard report Subscriptions and Data Driven report Subscriptions
• Transferred data into various formatted files and immediately updated my managers with the automated email systems.
• Used SSIS to create ETL packages .dtsx files to validate, extract, transform and load data to data warehouse databases
• Tuned several slow running queries in Production. Implemented Indexes and re-indexed to achieve time performance.
• Used config files in SSIS to ease the process of moving the packages across servers
• Optimized queries by looking at Execution Plan for better tuning of the database.
• Monitored, optimized and Performance Tuning of Regression Servers using Performance monitor, SQL Profilers, Activity Monitor.
• Tested applications for performance, data integrity, validation issues, job scheduling and alerts.

Environment:

MS SQL Server 2005/2008, T-SQL, SQL Server Reporting Services 2005/2008, SQL Server Integration Services 2005/2008, MS Excel, MS Windows Server 2003, Oracle 10g/9i.