SUMMARY

• 7+ years of administration and development experience on Database Design and Development in SQL server 2008/2005/2000 system in OLTP and OLAP environment.
• 5 years of experience in SSIS, SSAS and SSRS of MS SQL Server.
• Highly expert in translating Business System Design document into technical design document
• In - depth knowledge of Transact-SQL (DDL, DML).
• Excellent skills in implementing ETL Packages using DTS and SSIS 2008/ 2005.
• Proficient in implementing all transformations available on the SSIS toolbox.
• Excellent knowledge of using variables and expressions in packages.
• Experience in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools (SSIS, DTS, Bulk Insert, XML).
• Experience in Importing/Exporting Data from various data sources like Excel, Oracle, DB2 and Flat file using BCP, Bulk Insert & DTS utility.
• Experience in installation, upgrade and configuration of Microsoft SQL Server and databases.
• Experience in scheduling SSIS packages using SQL Server Agent.
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Experience in administrating the created reports and assigning permission to the valid users for executing the reports.
• Excellent knowledge in creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T-SQL.
• Experience in writing complex T-SQL queries using Inner, Left, Right, Outer and Cross Joins.
• Good knowledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Triggers and Primary and Foreign Keys.
• Hands on Experience in Installing, Configuring, Managing, monitoring and troubleshooting SQL Server 2005/2000.
• Worked extensively on system analysis, design, development, testing and implementation of projects (Complete SDLC) and capable of handling responsibilities independently as well as a proactive team
• Expert in resolving the performance issue of SSIS packages.
• Worked on development/staging/production environments and used Team foundation server/visual source safe for version controls and communication’s well as defining Actions, translations and perspectives.
• Good skills with computer science concepts and programming.
• Very good communication skills, good interpersonal skills & desire to excel, fast learner, hardworking and a versatile team player.

TECHNICAL SKILLS

• MS-SQL Server 2005/2000/2008
• Oracle 8i/9i/10g
• MS Access
• T- SQL
• PL/SQL
• C
• C++
• C#
• HTML
• XML
• Java
• ASP .NET
• VB6 .NET
• SQL Server BI Development Studio (BIDS)
• MS Visual Studio 2008/2005
• Crystal Reports
• Erwin 7.2/4.5/4.0
• MS Visio 2003/2007
• Rational Clear Case
• Clear Quest
• Autosys
• SQL server Reporting Services (SSRS)
• SQL Server Integration Services (SSIS)
• DTS
• Windows 98/2000/2003/ XP/NT/Vista
• Windows 2000Advanced Server

PROFESSIONAL EXPERIENCE

Confidential, NY

SQL Server/SSIS Developer

Responsibilities:

• Analysis of Business System Design document includes identifying impact on existing system.
• Studied detail changes that need to be made to each business process that is performed by all the systems impacted.
• Identified the existing tables that need to be changed.
• Analyzed the columns of new tables and prepared detail T-SQL scripts of tables.
• Involved in discussion of new database creation and migrate object from old database to new development database.
• Thoroughly read report layout and report behavior specification document of different load and matching exceptions report
• Involved in conversion of business requirement in to technical requirement.
• Created SSIS packages to migrate data from different data sources to data warehouse.
• Successfully extracted transformed and load data into data warehouse.
• Created packages by testing and cleaning the Standardized Data by using tools in Data Flow Transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and more) for existing/new packages and huge CSV file import from different data sources and other ongoing tasks for mapping.
• Extensively designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task, Data conversion task, Derived Column task and Script Task in SSIS Designer.
• Scheduled SSIS packages for running monthly and weekly feeds from various guarantors and multiple servers and resources.
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Designed, deployed, and maintained of various SSRS Reports in SQL Server 2008.
• Wrote Parameterized Queries for generating Tabular reports and Sub reports using Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2008.
• Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2008.
• Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2008.
• Responsible for the Performance tuning of the SQL Commands with the use of the SQL Profiler and Database Engine Tuning Wizard

Confidential, Chicago, IL

SQL Server /SSIS/SSRS Developer

Responsibilities:

• Created SSIS packages to clean and load data to data warehouse.
• Created package to transfer data between OLTP and OLAP databases.
• Created SSIS Packages using Derived Columns, Condition Split, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Created a table to save dirty records.
• Extracted data from oracle to load to data warehouse (SQL Server 2005).
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agent
• Used Notification services to generate error messages and send them to the user through e-mails, pager messages, and PDA as well as window messengers.
• Reviewed and adjusted deliverables involved during SDLC involving database changes/development.
• Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications
• Provided knowledge transfer to the company’s SQL programmers.
• Created and tuned stored procedures, triggers and tables.
• Created several materialized views and UDF’s to be accessed by the new front end applications.
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases
• Optimized the performance of various SQL scripts, stored procedures and triggers by using embedded UDFs, CTEs and System stored procedures.
• Experience in using Clear Quest to modify and track defects and change requests.
• Used Clear quest to analyze project progress by running queries, charts, and reports.
• Experience in using update statistic and run Sp Recompile for the table to test the table script.
• Successfully tested all task in staging and stored all versions of data using team foundation server (TFS).

Confidential, Cincinnati, OH

SQL Server/ SSIS Developer

Responsibilities:

• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Generated database monitering and data validation reports in SQL Server Reporting Service (SSRS).
• Deployed SSIS packages and Reports to Production Servers.
• Upgraded databases from SQL Server 2000 to SQL Server 2005.
• Responsible for the design and development of .Net web applications for firm's Solutions.
• Migrated data using ETL Tool in SSIS.
• Maintained system monitoring jobs and provide high availability support.
• Created partition table for very large database for good performance.
• Worked on Migration of packages from DTS using SQL Server Reporting Service(SSIS).
• Participated Databases Architecture and data Modoling design.
• Performing DBA functions, installing, configuring and supporting database systems.
• Reported all events and requirements through established reporting mechanisms in SSRS.
• Fully supported change management procedures.
• Reviewed and developed data models and database designs with development teams
• Wrote store procedures for some job automations.
• Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications.
• Experience in testing to rename the table to a temporary table by using sp rename.
• Experience in creating new table script to test the existing table.
• Responsible for writing SQL queries, stored procedures, views, triggers, T-SQL and DTS/SSIS
• Designed and developed OLAP using MS SQL Server Analysis Services
• Designed and developed MS SQL Server Reporting Services(SSRS) under SQL Server 2000 and SQL Server 2005
• In charge of converting data using SQL Server 2005 using SSIS

Confidential, Columbus, Ohio

SQL Server/BI Developer (SSIS)

Responsibilities:

• Designed and Developed Database Objects like Tables, Stored Procedures, Triggers, Rules, Defaults, user defined data types and functions for this project.
• Developed, tested and implemented Referential Integrity rules and regulations through constraints, triggers and views, partitioned views.
• Maintained databases, performed software installations and monitored Database Performance.
• Implemented automated backup and database maintenance / cleanup jobs.
• Managing Logins, Users, Roles and User permissions.
• Regular responsibilities for updating staging and dimensional databases as well as rebuilding the dimensions and cubes on Analysis Services(SSAS)
• Created Views for specific columns on a table to maintain privacy of a customer data.
• Created Indexes to get the high level performance.
• Performing the ETL operations to support the incremental, historical data loads and transformations using SSIS.
• Designed SSIS packages for loading data from ODS to Data mart.
• Designed SSIS packages for synchronizing the data between two different servers.
• Maintained databases, performed software installations and upgrades, monitored Database Performance.
• Involved in reverse and forward loading of the schema of a database using Erwin.
• Responsible for gathering Business Requirements and System Specification from users.
• Designed numerous ad-hoc and custom reports using SQL Reporting Services.
• Created various Tabular and Matrix Reports using SSRS.
• Created Ad-hoc reports and cascading reports for historical data using SSRS.
• Experience in the design, development and maintenance of different cubes using SSAS.
• Involved in the post deployment maintenance of canned reports and cubes.
• Experience in designing the reports in ProClarity for SSAS cubes.
• Involved in the implementation of Performance Point Server (PPS).
• Created and scheduled jobs for various tasks and also was responsible for maintaining jobs through Autosys.

Confidential, Huntsville, AL

SQL Server SSIS Developer

Responsibilities:

• Installation SQL Server 2005 with the latest service packs.
• Created Views for specific columns on a table to maintain privacy of a customer data.
• Database capacity planning and space forecasting.
• Migrated Database from SQL Server by using side by side migration.
• Creating tables, indexes and designing constraints.
• Wrote several SQL Scripts such as finding long running queries, blocking sessions, archiving data from production to archive server and populating reporting data.
• Actively worked on SQL XML and X-path queries.
• Wrote scripts to review object permissions in all databases.
• Performance Monitoring with SQL Profiler, Windows System Monitor and using a monitoring tool called Embarcadero DB Artisan and Performance Center.
• Extensively involved in designing the SSIS packages to export data of flat file source to SQL Server database.
• Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS)
• Migrated DTS packages from SQL Server and scheduled their execution time.
• Created SSIS packages using Active X scripts and with Error Handling.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Wrote stored procedures for report generation in SQL Server2005.
• Successfully deployed reports in various sources like XML, Web browser and PDF.
• Administrated the created Reports by assigning permission to the valid user for executing the reports.
• Created and Maintained Database Maintenance Plans.
• Implemented Database Mirroring between Development and Test Server.
• Creation and maintenance of Databases, creating Roles and managing user permissions, resolving Blocks and deadlocks.
• Good knowledge on SQL LiteSpeed a Backup solution for MS SQL Server.
• Helping Development Team in deploying and testing the application, which uses SQL Server as a database.
• Integrate SQL Server 2005 reporting services with Microsoft Share point Portal Server to deliver automatically generated reports to the Share Point portal
• Experience in using T-SQL for creating stored procedures, indexes, cursors and function
• Reviewed Third Party tools Diagnostic Manager ( Idera ) and Site Scope so as to help automate routine tasks such as monitoring, blocking and consolidate status of scheduled jobs

Confidential

SQL Server BI Developer

Responsibilities:

• Gathered functional requirements and written the technical specifications
• Designed logical / physical data models and defined primary key, foreign key using Erwin tool.
• Wrote T-SQL statements using DML and DDL for retrieval of the data.
• Created complex stored procedures, triggers and cursors in SQL Server.
• Developed source to target specifications.
• Developed stored procedures, functions, views and triggers.
• Developed stored procedures to transform the data from enterprise data warehouse to APT data mart to build dimensions and load data to fact tables.
• Created DTS package to schedule the jobs for batch processing.
• Performance tuning to optimize SQL queries using query analyzer.
• Created indexes, constraints and rules on database objects