SUMMARY

• Experienced in Creating, Configuring and Fine - tuning ETL workflows designed between Homogenous and Heterogeneous Systems using SSIS of MS SQL Server 2012, 2008r2, 2008 and MS SQL Server 2005 respectively.
• Experienced in creating complex SSIS and DTS packages for ETL purposes. Implemented complicated transformations to be used in SSIS packages.
• Experienced in Data Conversion, Normalization and Data Modeling, Multi-Dimensional Modeling and involved in creation of Fact Tables, Dimension Tables, Star Schema and Snowflake dimensional schema using Erwin Tool.
• High expertise in creating Reports of all types in SSRS, like Ad-hoc Reports, Drill-Down Reports, Drill-Through Reports, parameterized Reports, Pivot and Tabular Reports based on client requirement.
• Experienced in writing Parameterized Queries for generating Tabular reports and Sub reports using Global variables, Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2012/2008/2005.
• Strong experience in Stored Procedure, Formulated Stored Procedure/TSQL coding, Performance Tuning and Query Optimization.
• Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, views, indexes, user profiles, Relational Database models, Data integrity, query writing and SQL joins.
• Expert in using tools such as Bulk Copy (BCP) and Data Transformation Services (DTS).
• Extensive knowledge in developing and implementing Disaster Recovery Model, and Replication Models.
• Expert in using tools like MS SQL Profiler, Index Tuning Wizard, Windows Performance for monitoring and tuning SQL Server performance.
• Excellent communication and inter-personal skills with ability to develop creative solutions

TECHNICAL SKILLS

Database: SQL Server 2012/2008R2/2008/2005, MS Access 2003 & 2000

SQL Tools: Query Analyzer, Profiler, Query Execution Plan, Counter

Reports Development/Management: SSRS (SQL Server Reporting Services), MS Access, Excell

Data Modeling: Toad Data Modeler, Erwin, SSDD (SQL Server Database Diagram)

Programming: SQL, T-SQL,JOIN, Store Procedures, Trigger, Functions

SSIS: SSIS Package create, manage, deploy

Operating System: Windows Server 2008/R2, 2003/R2, 2000, VMware

Hardware/Storage: SAN, RAID

Performance Monitoring Tool: Profiler, Execution Plan, PerfMon, Database Tuning Advisor, DMV, Activity Monitor

PROFESSIONAL EXPERIENCE

Confidential, St. Louis, MO

SSIS/SSRS/SQL Developer //DBA

Responsibilities:

• Involved in SSIS Package creation from package design documents to package build.
• Involved in Unit testing of the SSIS extract packages and also building validation packages to check the accuracy of the data migrated.
• Used various SSIS data flow transformations, such as Data Conversion, Conditional Split, Derived Column, and Lookup which were used for Data Scrubbing and Data Validation Checks during staging, before loading the data into Data Warehouse.
• Created Test packages to validate the SSIS packages build.
• Created and modified Stored Procedures, Functions, and Indexes.
• Expertise in generating reports using MS Reporting Services 2012.
• Experience in generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services.
• DesignedSSIS packages to Extract data from different sources like SQL server 2008, MS Excel, MS Access; transform them and then load intoDimension and Fact tables in Data Warehouse using SSIS.

Confidential, Morgan Hill, CA

SQL DBA/Database Administrator/Developer

Responsibilities:

• Installed, Configured, and Managed SQL Server 2012,2008, 2005 & 2000 in development, test, and production environment
• Installed and Configured SQL Server 2008 for testing different features and stability
• Backup/Recovery:
• Strong knowledge and working experience in Database Backup and Disaster Recovery
• Experienced with Point-in-Time Recovery
• Restored Database from backup
• Database High Availability:
• Installed, Configured and Maintained Database Mirroring including automatic fail-over option in SQL Server 2008
• Configured Log Shipping as Standby database from Production database for Reporting purposes
• Clustering using SQL Server 2008/2005
• Configured and Maintained Replications
• Used DBCC to check database conditions, fix database corruption, rebuild indexes and other database Maintenance purposes as well
• Installed, Configured, and administered SQL Server Reporting Services (SSRS)
• Developed Reports for different purposes like DBA Reports, user reports using SSRS and Report Builder 3.0 & 2.0
• Deployed Reports and managed security of report server including folder level
• SSIS Package create, deploy and manage
• Moved data from flat file, Excel, Oracle, MySQL, MS Access, OLEDB Data Sources to SQL Server
• SQL Server 2000 to 2005/2008/2008 R2
• SQL Server 2005 to SQL Server 2008/2008 R2/2012
• Between databases in MS SQL Server 2000, 2005, 2008,2008r2/2012
• Oracle 10gR2/11gR2 databases to SQL Server 2008 R2
• My-SQL 4.1.0/5.0.15 databases to SQL Server 2005 and 2008 R2
• Strong Theoretical and Practical work experience on Conceptual, Logical, and Physical Data Model
• Worked on data modeling projects from starting to finishing, generated scripts for objects, Developed Relationship, and Created E-R Diagram
• Backward & Forward Engineering for Logical and Physical Data Model respectively
• Tools used: Erwin, Toad Data Modeler, and SSDD
• Created and managed Object, Schema, Indexes, Constraints
• Applied SP (Service Pack) on SQL Server 2000, 2005, 2008, 2008 R2 /2012
• Applied Patch on Windows Server 2003, 2003 R2, 2008
• Database Monitoring/Performance Tuning:
• Strong on database Monitoring and Performance tuning
• Scheduled jobs to automate different activities such monitoring database health, disk space, job alert, index monitoring, stats monitoring etc.
• T-SQL, Trigger, and Stored-Procedures
• Optimize SQL queries and Stored Procedures
• DTS/SSIS:
• Export & Import data from Flat file, CSV file to/from SQL Server Database using DTS, SSIS, and BCP
• Export & Import data from/to databases like Oracle, My-SQL, and Access to/from SQL Server

Work Environment: Windows Server 2008 R2, 2003 R2, IIS 7.5, 6.5, SQL Server 2012,2008 R2, 2005.

Confidential

Database developer

Responsibilities:

• Involved in SSIS Package creation from package design documents to package build.
• Involved in Unit testing of the SSIS extract packages and also building validation packages to check the accuracy of the data migrated.
• Used various SSIS data flow transformations, such as Data Conversion, Conditional Split, Derived Column, and Lookup which were used for Data Scrubbing and Data Validation Checks during staging, before loading the data into Data Warehouse.
• Created Test packages to validate the SSIS packages build.
• Created and modified Stored Procedures, Functions, and Indexes.
• Expertise in generating reports using MS Reporting Services 2012.
• Experience in generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services.
• DesignedSSIS packages to Extract data from different sources like SQL server 2008, MS Excel, MS Access; transform them and then load intoDimension and Fact tables in Data Warehouse using SSIS.
• Responsible for computer hardware and maintenance . create a schedule that would not disrupt operations.
• Assisted in trying to find new clients to expand company revenue
• Responsible for maintaining hardware troubleshooting log and submitting a summary report to management each week.
• Assisted in planning and executing several large-scale computer hardware upgrades.
• Responsible for developing support protocols whenever new hardware was installed.
• Responsible for maintaining hardware troubleshooting log and submitting a summary report to management each week.
• Assisted in planning and executing several large-scale computer hardware upgrades.
• Responsible for developing support protocols whenever new hardware was installed.
• Responsiblew for windows security and active directory control .