SUMMARY

• 7 years of experience in working with Data Warehousing & Business Intelligence solution Design,in the area of specifically related to MS SQL server 2005/2008.
• Experience in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous Systems using SQL Server tools, including SQL Server Integration Services (SSIS), Data Transformation Services (DTS).
• Expertise in SQL server database tools SQL Server Management Studio, Enterprise Manager and SQL Server Business Intelligence Studio.
• Working experience in domains Medical, Banking, Insurance and Financial sectors.
• Excellent knowledge of Data Modeling Methodologies i.e. Normalization/De - Normalization.
• Extensive experience in designing complex Relational Database models and implementations as per business requirements.
• Expert in creating Stored Procedures, User Defined Functions and T-SQL batch scripts to accommodate complex business specifications.
• Created SSISpackages with error handling using various data transformations like conditional split, for each loop, multi cast,column conversion, script components for elimination of duplicate Data, Null values, and converting data into required formats.
• Experience in migrating data from external system including flat files, excel, MS Access and oracle into SQL Server using SSIS/DTS packages.
• Worked with OLAP, Data warehouse applications,dimensional models which include star and snowflakes schemastoimplement SSAS, SSRSfor supportinglarge Reporting needs.
• Experience in front end development tools like VB.net, c#.net, and HTML.
• Excellent task oriented team player with good written and verbal communication skills.

TECHNICAL SKILLS

Databases: MS SQL Server 2008/2005, Oracle 10g/9i, My SQL5.0/4.1,MS - Access 2007/2003.

Database Tools: Enterprise Manager, Query Analyzer, SSMS, SQL Profiler, Data Transformation Services (DTS), Business Intelligence Development Studio (BIDS).

Data Modeling: Dimensional Data Modeling, UML, Logical and Physical data modeling.

ETL Tools: SQL Server Integration Services (SSIS), SQL scripts, Data Junction.

Languages: C, C++, C#.net, Asp.net, T-SQL, PL/SQL, MDX, HTML, DHTML, XML, VBA.

Operating System: Windows XP/2000, Vista, UNIX, Windows Server 2003.

ERP Applications: SAP, PeopleSoft.

Models/Framework: OLAP, ROLAP, MOLAP, Star Schema.

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

PROFESSIONAL EXPERIENCE

Confidential, CT

MS SQL Server Developer

Responsibilities:

• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data into Data Warehouse and Data Mart.
• Involved in Extract, Transform and Load (ETL) process framework.
• Developed SSIS packages using different typesof Error Handling for various events.
• ETL development using T-SQL programming, scripts, stored procedures, views.
• Experience with ER and Dimensional modeling.
• Worked on DTS Packages, Import and Export Wizard for transferring data from Heterogeneous Database (DB2, Text files and Excel files) to SQL Server.
• Involved in Performance tuning and Query Optimization.
• Developed complex queries using joins and sub-queries.
• Created multiple views and queries for complex SSRS reports.
• Developed SQL Scripts for creation of various Database Objects (Stored Procedures, Indexes, Triggers, and User Defined Functions.
• Created Clustered index and Non-clustered for increasing performance.
• Experience in Designing and Building the Dimensions and Facts with star schema and snowflake schema using SQL Server Analysis Services (SSAS).
• Involved in user interface design and developed scripts to support client business needs.
• Perform data load into star schema and cube refresh (dimensions and measures).
• Worked with business analyst to understand business processes, gather and document project requirements and translate them into functional and non-functional specifications for BI reports and applications.

Environment: SQL Server 2008SR2, SQL BI Suite (SSIS, SSAS, SSRS), MS Visio2005/2008, XML, VB. NET, MSoffice 2007, MS Project, Windows Server 2003, Internet Information Server ( IIS) 6.0/7.0, My SQL, MS-Access, ASP.NET,MS Visual Studio 2005/2008, DTS, T-SQL, SQL Profiler, Power Builder, Management Studio, TOAD.

Confidential, Pittsburgh, PA

SQL Server SSIS Developer

Responsibilities:

• Created DTS and SSIS packages for the Data Flow.
• Good experience in working with Data Transformation tasks such as Conditional Split, row count, CopyColumn, DerivedColumn,look up, Merge and Merge Join tasks.
• Worked with different data sources like DB2, Oracle and Access.
• Created configuration files for Deployment of SSIS packages onto Different server.
• Developed T-SQL scripts to merge data into central repository.
• Developed Complex Stored Procedures and Functions for supporting efficient data storage and manipulation.
• Create User Defined Functions depending upon the requirements.
• Data loading into Tables using Stored Procedures and SSIS Packages.
• Created Views as required by front end developer for easier implementation on web pages, and triggers on those views to provide efficient data manipulation.
• Wrote SQL scripts to Insert, Update and Delete data in MS SQL database.
• Experience in Designing and Building the Dimensions and Facts with star schema and snowflake schema using SQL Server Analysis Services (SSAS).
• Involved in developing user controls and aspx pages.

Environment: SQL Server 2005, SQL Server 2000, VB 6, Transact-SQL, VBScript, Erwin, Crystal Reports, Microsoft Visio 2000, ASP.NET, MS Excel Windows 2003/2000/NT/XP.

Confidential, CT

MS SQL Developer/ETL Developer

Responsibilities:

• Designing and Developing the Data Transformation Services (DTS) packages to populate data from various data source.
• Experience in Error and Event Handling, Precedence Constraints, Break Points, Check Points, Logging.
• Designing, creation of tables, stored procedures with E-R diagrams with extensive use of Erwin 4.0.
• Writing the stored procedures, checking the code for efficiency. Routine backups and restoration.
• Data Transfers between various servers using BCP.
• Defining and creating indexes for query optimization and revising scripts for optimal performance.
• Testing the stored procedures performance and its path of execution by using SQL Profiler.
• Created new database objects like Procedures, Functions, Packages, Indexes, Views using T-SQL.
• Creation of user Databases and installation of MS SQL Server 2005.
• Working with various business groups while developing their applications, assisting in Database design, creating E-R diagrams, phasing from development to QA and to Production environment.

Environment: SQL Server 2005/2000, T-SQL, Data Transformation Services (DTS), SSIS, SSRS, SSAS, Windows2003, Query Analyzer, SQL Profiler.

Confidential, NY

MSSQL Developer

Responsibilities:

• Developed DTS packages for transferring the data between MS Excel, Flat Files and SQL Server.
• Extensively used DTS Import/Export Wizard, for performing the ETL operations.
• Involved in migration from MS SQL Server 2000/7.0 to MS SQL Server 2005, DTS to SSIS.
• Expert in writing and debugging complex stored procedures, Functions, Views and DML/DDL Triggers.
• Created stored procedures to retrieve the customer details, connection details, payment history by giving the related parameters.
• Wrote scripts for dropping and creating referential Integrity constraints to decrease load time.
• Problem identification, troubleshooting, and index tuning the databases.
• Developed and maintained historical data from various heterogeneous data sources (i.e. Excel, Access).
• Enforced the Business Rules by creating constraints

Environment: MS SQL Server 2000/2005, Windows NT, SQL Profiler, Access, Excel, Windows 2000,Query Analyzer, Enterprise Manager, Data Transformation Services (DTS).

Confidential

SQL Server Developer

Responsibilities:

• Designed DTS (Data Transformation Service) packages to transfer data between servers, load data into database, archive data file from different DBMS’s using SQL Enterprise Manager/SSMS on SQL Server 2000 environment and deploy the data.
• Worked on DTS Packages, DTS Import/Export Wizard for transferring data from different types of Databases to SQL Server.
• Designed ER diagrams and mapped the data into database objects.
• Good knowledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Triggers,Primary and Foreign Keys.
• Used DDL and DML commands for writing triggers, stored procedures, and data manipulation.
• Created joins and sub-queries for complex queries involving multiple tables.
• Involved in performance tuning of TSQL queries and Stored Procedures.
• Created Indexes for fast retrieval of the data.
• Worked on Exception Handling with @@error and Try/Catch blocks.
• Involved in developing user controls and aspx pages.

Environment: MS SQL Server 2000, Windows NT, SQL Profiler, Access, Excel, Windows 2000,Query Analyzer, Enterprise Manager, Data Transformation Services (DTS).