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).
• 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.
• 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.
• Upgraded SSIS Packages from Sql Server 2005 to Sql Server 2008R2.
• 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.
• 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:

• Requirement analysis of a banking system.
• Designed ER diagrams and normalization of database.
• Used Developer 2000 to create forms.
• Developed scripts to create tables, views, procedures and functions and executed them using SQL*Plus.
• Wrote triggers to handle user generated events.
• Modules like Login, deposit, withdrawal, interest calculation & account balance were developed.
• Session management to provide security to web access.
• Used Developer 2000 to generate reports of statements for users.
• Run batch jobs for loading database tables from flat files using SQL*Loader
• Created Unix Shell scripts for automating the execution process.
• Created Records, Tables, Objects, Collections (Nested Tables and arrays), and Error Handling.

Environment: Developer 2000, SQL, PL/SQL, ORACLE 9i, Windows 2000