Summary

• Information Technology specialist with Over 8years of experience in database design, database programming, ETL development, administration and testing of SQL server 7/2000/2005/2008 and implementation of data warehousing solutions.
• Domain Expertise in Banking, Financial and Nonprofit Organizations.
• Expertise in Database modeling and development of applications using SQL Server 2000/2005/2008, Reporting Services 2005 SSRS , Integration Services SSIS , Analysis Services SSAS , OLAP Cubes, Star and Snow flake schema.
• Experience in working withCRYSTAL REPORTS 9/X/XIR2/2008, Business Objects Enterprise XI R2/R3/6.5
• Expertise in Object Oriented Web applications, .NET Framework ASP.NET, C , VB.NET, ADO.NET and Visual Studio.NET.

OLTP Experience

• Involved in Designing numerous DB Objects .Extensive usage of Database diagrams and data modeling tools like Erwin in creating Logical and Physical models, establishing Entity Relations and forward/Reverse engineer to database systems
• Involved in writing Complex Stored procedures, Lengthy Queries, Batch Scripts, Triggers, Functions, cursors using T-SQL
• Expertise in maintaining backup and recovery strategies database maintenance and performance tuning Query tuning using Indexes, SQL Profiler, Execution Plans, DMV's, DMFs
• Experienced in routine database administration tasks like Backup, Restores, Data Refreshes, Deploy code across various SDLC Environments like TEST,UA/UT/Production

BI OLAP Experience

Integration Services DTS/SSIS

• Extensive knowledge in ETL Process Progressive knowledge in using DTS/SSIS utilities
• Experience in Extraction Migration of Data from heterogeneous data sources like Excel, MS Access, Oracle, DB2 to MS SQL Server by using Import Export Wizard, DTS SSIS, BCP Bulk Insert utilities
• Expertise in designing SQL Server SSIS packages to import and transform data between databases and external data sources. Involved in migration of DTS Packages 2000 to SSIS 2005 and troubleshoot migration issues.
• Involved in Logical Physical data modeling and forward engineering physicaldata models to the databases
• Experience in using MDX, global variables, expressions.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Experienced in Change Data Capture CDC for DML Activities on Designated tables
• Implemented the error threshold using Precedence Constraints and variables in SSIS Packages, using business rules as reference.
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Implemented data mart, facts, dimensions, star schema and OLAP cubes based on Kimball's dimensional modeling standards using SQL Server Analysis Service.
• Involved in planning, implementation and support of MS Performance Point and also experienced in creating and customization of dashboards, scorecards, reporting, and analytics
• Capable of forming and maintaining positive and productive working relationships in internal/external and team environments.

Crystal Reports 9/X/XIR2/2008

• Experience in development of different kinds of reports using BO Crystal Reports, viz..,Financial Reports like Profit-Loss, Income statement, expense charts etc..
• Experience in development of different kinds of other reports like Canned Reports, Statistical analysis reports, future forecast reports, summary reports etc..
• Extensively used Graphs, charts, demographic images, indicators, cross-tabs, parameters in reports
• Experience in using sub-reports to handle complex analysis scenarios within reports.
• Expert in designing drill-down, aggregated and roll-up reports.

Technical Skills:

Professional experience

Confidential

Role:SSIS Developer

Responsibilities:

• Worked with Business and technical teams to create and maintain SOP's, techno functional documentation etc.. Relative to the extracts
• Extensively used SSIS 2008 to create packages that generated flat files that were sent to vendors both external and state
• Have written several TSQL queries which worked efficiently in reading data and loading data while doing extracts.
• Extensively used FTP component to send files to vendor
• Have written c sharp scripts Script Task and created a framework component that generates output data string and that could be used in all flat file packages without defining column mappings each time.
• Used Event Handlers for sending notifications
• Used Control Flow and Data flow , SQL Query language to build efficient packages by distributing data flow logic appropriately inside and outside of SSIS when required
• Effectively used data staging techniques to help UAT testers.
• Created Configurations for packages in SQL Server and XML files and designed packages for one touch deployment
• Used various look up kinds like partially cached, full cached etc..
• Used SSIS variables and variable scoping effectively in SSIS Packages to automate tasks such as file writing path, driving parameters, looping etc..
• Used most of the available transformations in SSIS toolbox like Lookup, Merge,MergeJoin, Union, derived column,aggregation, Multi cast etc to the advantage of the extract I was working.
• Have helped my team to automate tasks like metadata generation and other in house problems
• Have worked with Oracle and SQL Server databases in this project.

Environment:SQL Server 2005/2008, SSIS 2005/2008, SSRS, Windows server OS.

Confidential

Role: MSBI Developer

Responsibilities:

• Gathered functional requirements of all their conversion requirements.
• Worked closely with Buyers to analyze, understand and deliver efficient BI solutions.
• Have developed approx. 132 packages all by myself
• Worked on different data integration scenarios posed by complexity in migration.
• Extensively used SSIS to develop majority of the packages, although a few were also delivered using plain T-SQL batch loads.
• Developed different kinds of packages using transformation like Data conversion, look up, merge join, multicast etc..
• Pulled data from different ODBC sources, FTP locations and transformed them to Target ERP tables.
• Extensively used formula writing, selection coding, staging tables, conditional re-direction, sub-packages and error handling concepts of SSIS.
• Extensively used T-SQL based stored procedures, queries behind the packages, used CTE's, recursive queries for factor based analysis, dummy columing etc...
• Extensively used break points in package debugging, error logs, for loop containers, precedence constraints, Data watchers etc.. to cleanse, slice and dice data to match target system.
• Have done admin tasks such as troubleshooting hosting environment, scheduling packages, maintenance of packages, adhoc querying and distribution etc...

Environment:, Windows XP/2003, SQL Server 2005/2008, Lawson M3 ERP , MS Office Suite, IE, SSIS, , T-SQL, , SSIS, Visual Studio

Confidential

Role:MSBI Developer

Responsibilities:

• Designed data models new implementations using Erwin.
• Migrated objects from SQL Server 2005 to SQL Server 2008
• Involved in implementing add-in services e.g. Reporting, Integration
• Written complex SQL Queries, Stored Procedures, Triggers, Cursors and User Defined Functions to implement the business logic.
• Design technical and functional documentation
• Collecting Requirements
• Extracted Data from Oracle using Data reader sources in SSIS Packages to the target database including SQL Server and used the data for Reporting purposes.
• Worked Extensively with SSIS to import, export and transform the data between data sources.
• Created SSIS Packages for daily Data Cleansing Process
• Transferred data from flat files, Excel spreadsheets and heterogeneous data to and from SQL Server using SSIS..
• Involved in Query Optimizations and performance tuning for the stored procedures
• Explored the use of User Defined Functions to encapsulate commonly used logic in the stored proc and maximized the readability of such Stored Procedures
• Performance tuning of SQL queries and stored procedures using SQL Profiler, Estimated Query Plan and Index Tuning Wizard

Environment : Windows server 2008 R2, SQL server 2005/2008, VS 2005/2008, TFS 2008, .net, Autosys, SSIS,SSRS etc..

Confidential

Role:BI Consultant

Responsibilities:

• Developed different kinds of packages using transformation like Data conversion, look up, merge join, multicast etc Pulled data from different OLTP sources, FTP locations and transformed them to Target Warehouse tables.
• Extensively used SSIS to develop majority of the packages, although a few were also delivered using plain T-SQL batch loads.
• Design technical and functional documentation
• Collecting Requirements
• Extensively used formula writing, selection coding, staging tables,conditional re-direction, sub-packages and error handling concepts of SSIS.Extensively used T-SQL based stored procedures, queries behind the packages, used CTE's, recursive queries for factor based analysis, dummy columing etc...

Environment : Windows server 2008 R2, SQL server 2005/2008, VS 2005/2008, TFS 2008, .net, Autosys, SSIS,SSRS etc..

Confidential

Role:MSBI Consultant

Responsibilities:

• Involved in gathering requirements from users to build a DSS
• Written Functional and technical documents related to SQL Server Data modeling and development
• Lead the team of offshore developers by delegating work from client
• Participated in development of SQL Server based application to report BP's important KPI Value at Risk VAR
• Written many SQL Server procedures, Materialized views, views ,CTE's .etc
• Created indexes and partitioning strategies to boost performance of overall system.
• Worked on Oracle 11g database to get and compare data between trading landscapes.

Environment: SQL Server 2008, Oracle 11g, Windows 7, Windows 2008 server, .net 4.0, VS2010, IBM Clear case source controller, Informatica ,Toad,Sql developer etc..

Confidential

Responsibilities:

• Worked closely with Users to analyze, understand and deliver efficient solutions.
• Written new and maintained many SQL server database objects
• Handled vast performance tuning of T-SQL Queries
• Assisted DBA setting up new installations of SQL Server and maintain existing ones.
• Have participated in planning and development of Transportation databases
• Have developed an handful of crystal reports directly out of sql server

Environment: Windows server 2008 R2, SQL server 2005/2008, VS 2005/2008, Crystal reports etc..

Confidential

Role: Associate Consultant

Responsibilities:

• Worked closely with Users to analyze, understand and deliver efficient BI solutions.
• Have developed numerous ETLpackages for data load into warehouse.
• Worked on different data integration scenarios posed by complexity in migration.
• Extensively used SSIS to develop majority of the packages, although a few were also delivered using plain T-SQL batch loads.
• Developed different kinds of packages using transformation like Data conversion, look up, merge join, multicast etc..Pulled data from different OLTP sources, FTP locations and transformed them to Target Warehouse tables.
• Extensively used formula writing, selection coding, staging tables,conditional re-direction, sub-packages and error handling concepts of SSIS.
• Extensively used T-SQL based stored procedures, queries behind the packages, used CTE's, recursive queries for factor based analysis, dummy columing etc...
• Have done work delegation to offshore and done onsite evaluation of offshore solutions before delivering them to client.
• Have done admin tasks such as troubleshooting hosting environment, scheduling packages, maintenance of packages etc..

Environment:, Windows server 2008/7, SQL Server 2008, SAP ERP , MS Office Suite, IE, SSIS, , T-SQL, SSIS, Visual Studio, BIDS, Autosys etc..