SUMMARY:

• Over 7 years of IT experience including Database Design, Development, Administration.
• Experience in all phases of Project Life Cycle Requirements, Analysis, Architecture, Design, Building, Unit & Integration Testing, Migration and, Deployment and Production Support.
• Involved in creation/review of functional requirement specifications and supporting documents for business systems, experience in database design process and data modeling process.
• Experience in writing T - SQL Queries, working on DTS, SSIS, SSRS and Data Migration.
• Experience in writing FUNCTIONS, TRIGGERS, CURSORS
• Experience in Writing and Debugging Stored Procedures and Triggers, Troubleshooting database issues.
• Experience in creating Indexes for faster performance and Views for controlling user access to data.
• Experience in optimizing performance of various long running queries and stored procedures using SQL Profiler and Database tuning wizard
• Experience in Extraction, Transforming and Loading (ETL) data flows using SSIS; creating mappings/workflows to extract data from SQL Server and Flat File sources and load into various Business Entities
• Transformed data using Data Transformation Services (DTS) (2000) and SQL Server Integration Services (SSIS) (2005/2008/2008 R2/2012).
• Worked on creating SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task ….
• Built Efficient SSIS packages for processing facts and Dimension tables with complex transforms.
• Involved in migration of DTS Packages (2000) to SSIS (2008R2/2012) and troubleshoot migration issues
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Good Understanding ofStarSchema and SnowflakeSchemain Relational Data Warehouse (OLAP).
• Good knowledge in developing and designing reports through SSRS and Excel.
• Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports.
• Experience in using tools like Database Engine Tuning Advisor, SQL Profiler, Index Tuning Wizard and Windows Performance Monitor
• Worked with supporting large customer base and worked directly with end-users and supported all the requirement changes, issues tracking systems request and data related issues
• Excellent analytical, Interpersonal and Communication skills, fast learner, hardworking and versatile team player.

TECHNICAL SKILLS:

Tools: SQL Server Management Studio, Enterprise Manager, Query Analyzer, SQL Profiler, Data Base Engine Tuning Advisor, SSIS, SSRS, Data Transformation Services

Database: MS SQL Server 2012/2008R2/2005/2000, MS Access, MySQL.

ETL Tools: DTS, SSIS, Informatica

Reporting Tools: Excel, Sql Server Reporting 2012/2008/2005

Programming: SQL, PL/SQL, T- SQL

PROFESSIONAL EXPERIENCE:

Confidential, Richfield, OH

Sql server Developer

Responsibilities:

• Interacting with Business users, gathering and analyzing requirements.
• Worked in test based Development process.
• Worked on Developing SSIS Templates for Data Migration in sql server 2008R2.
• Involved in developing Packages for implementing business logic through Stored Procedures and Functions.
• Migrated data from legacy system (text based files, Excel spreadsheets, and Access) to SQL Server databases using SQL Server Integration Services (SSIS) and stored procedures to overcome the transformation constraints.
• Created complex SQL queries by joining multiple tables, dynamic SQL and sub queries in TSQL.
• Partitioning the Fact Tables and aggregate materialized views for enhanced Performance.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Worked on Data warehouse star schema, Fact and Dimensions.
• Managing the schema objects like tables, indexes, views, etc.
• Implemented Facts and Dimension tables to perform analysis in Star Schema.
• Created Alerts for successful or unsuccessful completion of scheduled Jobs.
• Extensive worked on Tuning SQL queries to improve the query performance.
• Created and developed Stored Procedures and Functions in PL/SQL for Data profiling.
• Established ETL design practices for optimization and performance of packages and Parameterized SSIS packages with the use of environment variables.
• Implemented Error handling and utilized Event handlers for automated notifications using SSIS.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS)
• Developed various drill down and drill through reports which involved complex chart based reports.
• Upgraded SSIS Packages from Sql Server 2005 to Sql Server 2008R2.
• Setup Database Maintenance Plans to reorganize indexes, re-indexing and update the index statistics on the production databases.

Environment: Sql Server 2012/2008/2005, Visual Studio, MS Access, MS Excel, MS office 2007, T-sql,stored procedures

Confidential

Sql server Developer

Responsibilities:

• Worked on Installing and Configuring SQL Server 2008/2005, Analysis services (SSAS), Integration Services (SSIS) and Reporting services (SSRS) for QA and DEV environments.
• Worked creating Index, Views, Complex Stored Procedures, appropriate Functions, and effective Triggers to facilitate efficient data manipulation and data consistency.
• Written SQL Scripts to do the Data Profiling like clarify the structure, content, relationships and derivation rules of the data
• Written integrated Stored Procedures to generate the Reports.
• Written SQL queries to join between fact and dimension tables and constraints on the data to return selected information.
• Worked on design and development of SQL Server Integration Services (SSIS) packages and using various control flow task and data flow transformation.
• Worked on creating various clustered/non-clustered indexes, triggers, check constraints and functions.
• Worked on writing the stored procedures to create the balance reports.
• Established ETL design practices for optimization and performance of packages and Parameterized SSIS packages with the use of environment variables
• Worked on Automating ETL Data loads and established efficient ways of Error Handling in SSIS
• Implemented Error handling and utilized Event handlers for automated notifications using SSIS.
• Created SSIS package to get data from different sources, consolidate and merge into one single source.
• Migrated existing DTS packages to SSIS Packages using SQL Server Integration Services (SSIS).

Environment: Sql Server 2000/2005/2008, Visual Studio, MS Access, MS Excel, MS office 2007,T-sql,Pl/sql

Confidential, San Francisco

SQL Developer

Responsibilities:

• Coordinated with the Business users to collect requirements.
• Prepared Business Requirement Specification that gives the comprehensive details about the requirements.
• Worked on Logical and Physical Data Modelling.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Worked with loading and migrating data using Mysql Database utilities and worked very closely with Database performance tuning and scripting
• Worked on Scheduling SSIS jobs (SQL Agent), Migrating DTS packages to SSIS packages
• Worked with moving data from Oracle to SQL server and migrated the PL/SQL code to SSIS packages
• Created SSIS package to get data from different sources, consolidate and merge into one single source.
• Created / modified SSIS packages to load the data into the data warehouse environment.
• Worked on Import/Export tool and successfully migrated the Databases such as DB2 to SQL Server 2000 using SSIS.
• Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Created database objects like Tables, Sequence, Views and Indexes.
• Participated in System test case preparation and execution.
• Worked on tuning the SQL Queries.

Environment: Sql Server 2005,T-SQL, Mysql

Confidential

Database developer

Responsibilities:

• Installing and Configuring SQL Server 2005, Analysis services (SSAS), Integration Services (SSIS) and Reporting services (SSRS) for QA and DEV environments.
• Worked on creating Index, Views, Complex Stored Procedures, appropriate Functions, and effective Triggers to facilitate efficient data manipulation and data consistency.
• Written SQL Scripts to do the Data Profiling like clarify the structure, content, relationships and derivation rules of the data
• Developed and modified PL/SQL code to make new enhancements or resolve problems, as per customer requirements.
• Written SQL queries to join between fact and dimension tables and constraints on the data to return selected information.
• Automated ETL Data loads and established efficient ways of Error Handling in SSIS
• Implemented Error handling and utilized Event handlers for automated notifications using SSIS.
• Created SSIS package to get data from different sources, consolidate and merge into one single source.

Environment: Sql Server 2000/2005/2008, Visual Studio, MS Access, MS Excel, MS office 2007,T-sql,Pl/sql