SUMMARY

• Over 6 years of IT experience including Database Design, Development, Administration.
• Extensive experience in all phases of Project Life Cycle Requirements, Analysis, Architecture, Design, Building, Unit & Integration Testing, Migration and Training, Deployment and Production Support.
• Expert 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.
• Transformed data using Data Transformation Services (DTS) (2000) and SQL Server Integration Services (SSIS) (2005/2008/2008 R2).
• Expert in 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.
• 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 for Monitoring and Tuning MS SQL Server Performance.
• Configured Transactional Replication and Log Shipping with SQL Server Management Studio as well as basic account management and troubleshooting with connectivity, security and firewall issues.
• Conducted Performance Tuning using SQL Profiler and Windows Performance Monitor.
• Configured Database mail, linked servers in SQL server 2005.
• Experience in migrating data from Sql Server 2000/2005 to Mysql.
• Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• 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, Business Intelligence Development Studio, Data Transformation Services, MySQL

Database: Oracle 10g/9i/8i/7.x,MS SQL Server 2008R2/2005 2000, MS Access 2000, MySQL.

Operating Systems: Microsoft Windows XP/ 2003/2000/2008.

ETL Tools: DTS, SSIS, Informatica

Languages: SQL, PL/SQL, T- SQL

PROFESSIONAL EXPERIENCE

Confidential

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.
• Written stored procedures and T-sql to create the Unit Test case results.
• 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.
• 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.
• Used DBCC commands to troubleshoot issues related to database consistency.
• Used SQL Server Profiler to monitor and record database activities of particular users and applications
• Setup Database Maintenance Plans to reorganize indexes, re-indexing and update the index statistics on the production databases.
• Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Created and developed Stored Procedures and Functions in PL/SQL for the front end.
• Developed and changed Procedures, Functions, Packages, Triggers, and Views using PL/SQL Provided support to development applications for various databases.

Environment: Sql Server 2008R2/2005, Oracle, PL/SQL, T-SQL, MySQL

Confidential

Sql server Developer

Responsibilities:

• Installing and Configuring SQL Server 2008/2005, Analysis services (SSAS), Integration Services (SSIS) and Reporting services (SSRS) for QA and DEV environments.
• Proficient in 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.
• Used SQL queries to join between fact and dimension tables and constraints on the data to return selected information.
• Increased the performance necessary for statistical reporting by 25% after performance monitoring, tuning and optimizing indexes.
• Designed and implemented ETL job restart ability using Checkpoints and optimal package design techniques in SSIS.
• Taking Database full Backup, Transaction log backup & differential backup in daily Routine.
• Expert in design and development of SQL Server Integration Services (SSIS) packages and using various control flow task and data flow transformation.
• 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
• 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.
• Created GAP analysis documents for data awareness of client.
• Lead the development of automated DTS/SSIS packages to extract, transfer, load and convert data from various.
• Migrated existing DTS packages to SSIS Packages using SQL Server Integration Services (SSIS).

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

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
• 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.
• Import/Export 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:

• Importing data from different varieties of sources like flat file excel file or CSV files.
• Created and developed Stored Procedures and Functions in PL/SQL.
• Highly motivated SQL server Developer with good Experience in Database and Business Intelligence Technologies with expertise on ETL process.
• Installing, Upgrading and Configuring Microsoft SQL Server 2005/2000.
• Creating procedures using TSQL DDL/DML, perform most of the SQL Server Enterprise Manager and Management Studio functionality using T-SQL Scripts and Batches
• Writing complex SQL queries involving multiple tables inner and outer joins.
• Create stored procedures to create and load tables on Mysql side from CSV files.
• Create Store procedures and many t-sql scripts to validate the data.
• Working on creating DTS packages to extract data from Sql Server 2000 and insert into the database.
• Designed and implemented ETL job restart ability using Checkpoints and optimal package design techniques in SSIS
• Established ETL design practices for optimization and performance of packages and Parameterized SSIS packages with the use of environment variables
• 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.
• Created number of database Triggers using PL/SQL.
• Worked on optimizing the queries by creating various clustered, non-clustered indexes and indexed views.
• Created complex stored procedures for several customized reports based on requirement.
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.

Environment: MySql, Sql Server 2000/2005, Sql, Pl/Sql.