SUMMARY

• Over 7 years of IT experience with a strong background in Data warehousing projects development and four years of ETL & Reporting experience using SQL Server SSIS/SSRS in a high transaction and multi server production environment.
• Proficient in Installing, Configuring, Managing, Monitoring and Troubleshooting SQL Server 2008/2005/2000 .
• Expert in Extraction, Transforming and Loading (ETL) using SSIS creating mappings/workflows to extract data from DB2, SQL Server, Excel file, other databases and Flat File sources and load into various Business Entities.
• Excellent backend skills in creating SQL objects like Tables, complex Stored Procedures, Views, Indexes, effective Functions and appropriate Triggers to facilitate efficient data manipulation and data consistency.
• Expertise in writing T - SQL (DML & DDL) Code, Query optimization & performance tuning. Used SQL Profiler, Execution plan, Performance Monitor and DBCC commands.
• Good knowledge of SDLC, RDBMS, logical and physical data modeling and database design using Erwin.
• Experience in converting the environment from IBM InfoSphere DataStage to SSIS.
• Expertise in SSIS direct and Indirect Configuration(XML, SQL Server) set up, SSIS Audit and Logging, Error Handling, Expressions and Variables.
• Expertise in performance tuning of Data Flow Task in SSIS Packages.
• Good Hand on Resolving complex issues and Error Handling in SSIS.
• Experience in creating Historical and Incremental Jobs, Alerts, setting up SQL server mail agent for SSIS packages.
• Very good SQL Server Administration skills including backup recovery, database maintenance, user authorizations, database creation, Tables, indexes.
• Expert in report writing using SQL Server Reporting Services (SSRS) and in creating various types of reports like Drill Down, Drill Through, Parameterized, Matrix, and Chart Report, Web reporting by customizing URL Access.
• Proficient knowledge of creating feeds from OLTP to Data Warehouse.
• Experience in Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, Fact and Dimensional tables and Operational Data Store (ODS).
• Expertise in deploying SSIS Package, SSRS Reports and SSAS Cubes using command line utilities.
• Expertise in Creating Cluster Index and Non Cluster Index, Covered Index, and Indexed View to improve performance on Database side.
• Good Experience on SQL Server profiler and Database tuning advisor to tune Scripts, Queries, SP, Function over Database.
• Experience Working in Agile, Scrum and Rational Process (waterfall) model.
• Excellent skill in Testing SSIS, SSRS, SSAS, TSQL objects. (While Box and Black Box)
• Good Experience in writing Production Deployment Documents, Mapping Document, Test Scenarios and Release documents.
• Flexible, enthusiastic and project oriented team player with excellent written, verbal communication and leadership skills to develop creative solutions for challenging client needs.
• Self learning ability and Leadership Quality.

TECHNICAL SKILLS

Database Tools: SQL Enterprises Manager, SQL Profiler, Query Analyzer SQL

ETL Tools: Data Transformation Services (DTS), SQL Server Integration Services (SSIS), Import Export Data, Bulk Insert. IBM InfoSphere DataStage

Data Modeling Tools: ERWIN, MS Visio, Rational Rose

Programming Language: T-SQL, C, C++, HTML, XML, Visual Basic 6.0, ASP.NET, C#.NET, Java Script

Web Tools: MS-Front Page, Macromedia Dream Weaver, IIS 5.0, FTP, TCP/IP, LAN, MS-Outlook Express.

Reporting Tools: Crystal Reports 9/10/11, SQL Server Reporting Services (SSRS), MS Access, MS Excel.

Databases: SQL Server 2008/2005/2000 , DB2, MS Access

Operating Systems: Windows 9x/NT/XP/Vista, UNIX, Linux

PROFESSIONAL EXPERIENCE

Confidential

SQL Server BI Developer

Responsibilities:

• Participated in Business Analysis & requirement collection.
• Involved in design the template of SSIS packages to approach the business requirement.
• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (CSV, Excel, SQL 2005). y
• Created/updated Stored Procedure, Triggers, User Defined Functions, CTE, joins, analytical functions for update the existing tables.
• Removed Duplicate records from the source using complex query, analytical functions.
• To achieve business requirements, used for-Each Loop Container, Sequence Container, task, Expressions, Execute SQL task, Variables, Send Mail Task, Package Execution task.
• Used Look up, Derived Column, Conditional Split, and Aggregate transformation to manipulate data in SSIS package data flow.
• Provided Dynamic Configuration, Custom Package Logging, Error Handling, and Notification mail
• Created deployment utility to deploy SSIS Packages.
• Created Drill Down, Parameterized Reports, Chart Reports from Cube using Tables using T-SQL based on business requirement.
• Tuned queries using Query Optimization techniques.
• Actively participated in review meetings with BI Manager and Sr. Business Analyst to ensure that the development of projects meet business and system requirements.
• SQL Server Profiler for tuning report queries and improves performance in SQL Server.
• Worked closely with DBA team to regularly monitor system for bottlenecks and implement appropriate solutions.
• Run Import/export wizard to load data between TEST and DEV Server, provided CSV and Excel files to mangers for the particular records they want for different meetings.
• Ran test on SSIS packages, Stored Procedures, Reports and wrote script to check functionality of code.
• Created mapping document for Dimensions and Facts.
• Helped team lead to create Production Release documents.
• Actively participated in meetings for change management from OBIEE to SQL SERVER.

Environment: Microsoft SQL Server 2008/2005 Enterprise edition, SSMS, SSIS, SSRS, Microsoft Visual studio 2005, SQL Profiler, Windows Server 2003/XP 64-bit Edition.

Confidential, Cincinnati, OH

SQL Server Developer

Responsibilities:

• Involved in Business Analysis & Requirement collection.
• Involved in meeting for change the environment from IBM InfoSphere DataStage to SSIS
• Designed Data Warehouse and Database for the system using Star Schema which includes Tables, Stored Procedure and Indexes in SQL Server Management Studio.
• Implemented ETL to Extract and Transform data from Flat File or CSV, SQL Server 2005 instances and to load into Staging Database. The main purpose to load into staging database is to change all string values to integer. And then to Data Warehouse for further Data Analysis by using multiple transformations provided by SSIS such as Data Conversion, Lookup, Conditional Split, Slowly Changing Dimension, Merge and Union all. Scheduled and maintained every mid-night and weekly load data by creating corresponding job task by SQL Server Agent in SSMS.
• Use Data Viewers in SSIS Packages to see whether the data flow properly or not.
• Created and updated complex Stored Procedures, Triggers and User Defined Functions for logical T-SQL implementation.
• Created Views to facilitate easy user interface implementation and Triggers on them to facilitate consistent data entry into the database.
• Create crystal reports using Business Objects.
• Manage Report Security by using SSMS. Connect to Reporting Server and set different roles and different security level to different users.
• Use SQL Server Profiler for tuning report queries and improve performance in SQL Server.
• Actively participated in review meetings with Project Manager to ensure that the development of projects meet business and system requirements.
• Documenting the development work.

Environment: IBM Info Sphere Data Stage,MS SQL Server 2008/2005 Enterprise Edition, Windows Server 2003, SQL Server Management Studio(SSMS), SQL Server Integration Services (SSIS), Business Object, Microsoft Visual Studio 2005.

Confidential, Plano, TX

SQL Server Developer

Responsibilities:

• Created new database logical and physical design to fit new business requirement and implemented new design into SQL Server 2000.
• Successfully migrated old data from legacy system into SQL Server 2000 using DTS Packages.
• Successfully created schema change scripts to existing objects to synchronize with changing business rules.
• Created indexed generic views to facilitate easy user interface implementation and enforce security on critical customer information.
• Filtered bad data from legacy system using complex T-SQL statements, and implemented various constraint and triggers for data consistency.
• Created complex Stored Procedures and Functions for integrity checks of migrated data.
• Implemented batch processing for approval process using Jobs and DTS.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Created Database Maintenance Plans for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Created Users and Roles, and managed security and permission of database.
• Documentation of all the processes involved in maintaining the database for future .
• Develop documentation that sufficiently describes technical deliverable as required for internal controls and maintaining documentation of the database for future .
• Actively participated in User Acceptance Testing, and debugging of the system.

Environment: MS SQL Server 2000, T-SQL, MS Excel, MS Access 2000, Erwin, Windows NT 4.0

Confidential, Des Moines, IA

SQL Server BI Developer

Responsibilities:

• Migrating SQL Server 2000 DTS Packages to SSIS Packages for uploading various formats of files and data from the legacy databases and SQL Server 2000 to MS SQL Server 2005 Data warehouse using SQL Server Integration Services (SSIS).
• Create complex scripts to do chucking and massaging of legacy data in staging area of SSIS package.
• Drop and recreate Index on the DSS system while data migrating.
• Schedule Jobs to run SSIS package in night feed to DSS system for fresh day data.
• Generated server side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
• Modified existing databases by adding/removing tables there by altering referential integrity, primary key constraints and relationships according to requirements
• Created trace in SQL Profiler and used Data base engine tuning advisor for Performance tuning on stored procedures and Scripts.
• Created pivot table to provide structured to Reports in proper manner like months etc.
• Wrote documentation for the packages and scripts and job created for migrate data.
• Deployed reports to Report Manager and Troubleshooting for any error occur in execution.
• Responsible for implementing robust Disaster Recovery Plan.
• Planning and scheduling backup strategy to ensure reliable backup.
• Participated in testing during the UAT (QA testing). Mentored and monitored team development and status

Environment: SQL Server 2005/2000, Data Transformation Services, SQL Server Integration Services, MS Excel 2003, MS Access 2003, Enterprise Manager, Management Studio, SQL Profiler and SSRS.

Confidential

SQL Server DBA/Developer

Responsibilities:

• To ensure trouble free access to SQL Server databases 24 hours a day.
• Monitored health conditions of databases and performed a day to day task like taking backups and restoring them.
• Monitoring Log shipping/Replication and trouble shooting of errors.
• Planning for and carrying out installation and upgrade of SQL Servers.
• Security issues related to logins, database users, and application roles and linked Servers.
• Performance Tuning of SQL queries and stored procedures using SQL profiler.
• Involved in troubleshooting and maintaining databases.
• Analyzing the problems in the production environment and try to develop new procedures and methods for monitoring the problems and send alert messages to take pro-active action.
• Wrote scripts for generating Daily Backup Report, verifying completion of all routine backups, Log Space utilization monitoring etc.
• Prepared schedule and template report for Database Health-check activities.
• Involved in Design and Development of Recovery Plan.

Environment: SQL Server 2005/2000, Windows 2000/NT4.0, MS Excel, MS Access, SQL Profiler, Replication, Management Studio, Backup software, DTS, T-SQL, and BCP.