PROFESSIONAL SUMMARY:

• Over 9+ years of professional experience in development, implementation and administration of database systems using MS - SQL Server 2012/2008R 2/2008/2005/2000 for both OLTP & Data Warehousing Systems applications.
• Experienced in complete Software Development Life Cycle (SDLC) processes including Analysis, Design, Programming, Testing and Documentation.
• Well-developed skills in SQL Server Integration Services 2005/2008/2012 for data extraction, transformation and loading using different heterogeneous source systems like flat files, Excel, SQL Server.
• Strong knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools.
• Adept in RDBMS concepts and constructs along with Objects creation such as Database, Table, Normalization, UDF, User Defined Data Type, Indexes, Stored Procedures, Views, Cursors and Triggers.
• Extensively used SSIS, SSAS & SSRS for various BI requirements.
• Expert in designing high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Extensive experience in Data Extraction and Transforming and Loading (ETL) using DTS package in MS SQL Server and SQL Server Integration Services (SSIS) in MS SQL Server with .NET, Import/Export data, Bulk insert and BCP.
• Expert in SSIS script transformations and scheduling complex SSIS Packages for transferring data automatically from multiple data sources to SQL server.
• Expert in Database Normalization, Optimization and Tuning, Backup/Restore, Data Import/Export, Troubleshooting, and Database Objects authorization.
• Strong experience in creating various reports like Drill through, Drill down and Ad-hoc according to the user requirement using SQL Server Reporting Services (SSRS).
• Possess detailed knowledge of aggregation using OLAP analysis services cube.
• Experienced in developing Logical and Physical data models using data modeling tools such as Erwin and MS Visio.
• Expertise in generating reports using SQL Server Reporting Services, Crystal Reports and MS Excel spreadsheets.
• Knowledge of developing cubes in SSAS and Analyzing Dimensions and Measures.
• Worked on SharePoint development and scheduling reports using it.
• Expert in automation of creating jobs, error reporting using Alerts, SQL Mail Agent.
• Experience in Interacting with Business users to analyze the business process and transforming requirements into screens, performing ETL, documenting and rolling out.
• Ability to quickly adapt to new environment and work with variety of people at various levels.
• Ability to work in environments with fluctuating priorities and deadlines, foresight to handle upcoming issues and dedication to solve complex problems with experience and research.
• Excellent communication skills, bridging Client Interaction and Team player.
• Organized professional with excellent oral and written communication skills, excellent presentation and interpersonal skills, problem solving skills, and a fast learner who also adapts quickly to new technologies with the ability to take new roles in minimum time with little .

SKILL SET:

• SQL Server 2000/2005/2008/2008 R2/2012
• MS Access
• C
• VB.NET
• C#
• VB
• ASP.NET
• Java
• Java Script
• T-SQL
• PL/SQL
• PHP
• HTML
• XML
• DTS
• SQL Server Integration Services (SSIS)
• Business Intelligence Development Studio (BIDS)
• SQL Profiler
• SQL Query Analyzer
• SQL Server Management Studio
• SQL Server data tools (SSDT)
• SQL Server Enterprise Manager
• SQL Server Management Studio
• Query Analyzer
• SQL Profiler
• Data Transformation Services(DTS)
• ETL
• Query Builder
• BCP
• Bulk Insert
• SSIS
• SSAS
• SSRS
• BIDS
• VSS
• Crystal Reports
• ERWIN
• SQL Server Reporting Services (SSRS)
• Crystal Reports
• Windows NT/ 98/2000/2003/ windows 7/Vista/ Windows 8
• UNIX
• MS Office 2010/2007/2003
• MS Excel 2010/2007/2003
• MS Outlook 2010/2007/2003
• MS Visio
• SharePoint Server.

PROJECTS SUMMARY:

Confidential, Columbus, OH

SQL/SSIS Developer

Responsibilities:

• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (CSV, FTP Server, Excel, DB2 and SQL 2012).
• Actively participate in the Design, Build, Test, and Deploy phases of Siebel UCM implementations for Oracle customers.
• Project-manage Oracle MDM implementations for Oracle customers.
• Set Customer best practices expectations revolving around MDM.
• Advise Oracle MDM usage and design to best fit customer business process requirements
• Developed Custom Logging so user can know when a row is inserted in custom logging table by every SSIS package that executes, if SSIS packages extract row from DB2 to CDC DB, or any insert, update or delete rows in dimension or fact tables in DW.
• Filtered data from Transient Stage to EDW by using Complex T-SQL statements in Execute SQL Query Task and in Transformations and implemented various Constraints and Triggers for data consistency and to preserve data integrity.
• Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Variables, Send Mail Task, FTP Task Package Execution task to achieve business needs.
• Created SSIS packages to Extract, Transform and load data using different transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all.
• Developed SSIS Packages to move data from one database of a server (Partner) to another (CRM) using Web Services Call.
• Wrote and modified various Stored Procedures used in the application using T-SQL.
• Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent.
• Responsible for creating partition function and schema for the table partitioning.
• Involved in creating counter logs and trace logs for advanced performance analysis and data logging over a period of time.
• Created SSIS 2012 Packages to perform filtering operations and to import the data on daily basis from the OLTP system, DSR to SQL server.
• Developed complex Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports, Matrix reports and linked reports using SSRS.
• Created various jobs using SQL Server Agent.
• Used SQL Server Profiler to trace the slow running queries and the server activity.
• Actively participated in review meetings with Project Manager to ensure that the development of projects meet business and system requirements.
• Documented the project work and process.

Project Environment: Microsoft SQL Server 2012, T-SQL, SQL Server Integration Services(SSIS), SQL Server Reporting Services(SSRS), SQL Server Analysis Services(SSAS) Visual Studio 2010/2008, SQL Server Agent, Windows server 2008, Erwin 7.2, Visual Source Safe 2005, C#, SQL Profiler, Microsoft SharePoint 2010

Confidential & Confidential, Columbus, OH

MS SQL Server Developer/SSRS Lead/ ETL/SSIS

Responsibilities:

• Created technical documents for data mapping and database migration.
• Developed and designed the whole process to load data into Data Warehouse (DWH).
• Involved in designing the data model for the Data warehouse tables.
• Involved in creating partition function and schema for the table partitioning.
• Responsible for creating SSIS packages to load the data into Type 1 and Type 2 dimension tables and created SSIS packages to load the data into Fact tables after transformation.
• Created the Date Dim to keep the track of Start Date and End Date.
• Used script task to update row counts and insert row counts for the Type 2 Dimension tables.
• Wrote C# scripts in the script task to calculate the final update and insert row counts for the table. Used XML Configuration to make the package dynamics.
• Used SQL server table for logging of the SSIS packages and maintain the details of the run time and rows affected and update row counts and insert row counts.
• Implement Event Handlers and Error Handling in SSIS packages and notify process results to various user communities.
• Test, Clean and Standardize data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.
• Used MS Excel (Pivot Table), Reporting Services as Front Viewer and OLAP cube as backend and provided integration between MS Excel/SSRS and SSAS.
• Extensively involved in the SSAS storage and partitions, Aggregations, calculation of queries with MDX, Data Mining Models and developing reports using MDX and SQL in SSAS 2008.
• Convert Actuate reports to SSRS reports using SQL Server Reporting Services.
• Applied various features in SSRS to get the same reports as Actuate reports.
• Maintained the documentation for the all reports to keep track of users of the reports and to get sign off from them to move the developed reports to Production.
• Perform quality assurance checks and update databases to ensure data integrity.
• Performance optimization of the data warehouse by identifying and assisting in BI performance bottlenecks and debug database, application or data content related issues.
• Actively participate in review meetings with Project Manager to ensure that the development of projects meet business and system requirements.

Project Environment: Microsoft SQL Server 2008R2, Visual Studio 2010, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), C#, Microsoft Visio 2007, MS Access, Excel.

Confidential, Madison, WI

MS Database/BI Developer

Responsibilities:

• Responsible for gathering requirements for the database designing for the middle office with the Data Architect. Involved in understanding the current system and analyzed the overall compatibility of the all systems with the proposed Middle Office Database design.
• Created new database schema and tables for the Middle Office.
• Involved in creating new and modifying the existing stored procedures and functions.
• Cleaned the data using SQL Server Integration Services (SSIS).
• Created reports using SQL Server Reporting Services (SSRS) as per user requirements.
• Deployed reports and configured security and subscriptions for the reports.
• Populated data store with CRM Data (Oracle) using Integration Services (SSIS) as catalyst for ETL process.
• Created User Defined Tables (UDT’s) and used for the creation of stored procedures.
• Involved in creating Indexes and tuned the performance of SQL Queries.
• Used various SSIS transformations for loading the data into the Middle Office tables.
• Created table driven configuration for SQL Server Integration Services (SSIS) packages.
• Designed various reports like chart, drilldown, drill through and matrix reports based in the user requirements using SQL Server Reporting Services (SSRS).
• Developed reports in SSRS 2008 R2 and deployed reports into SharePoint Server 2010.
• Modified the Existing SSIS Packages and added more audits and alerts in case of package failure.
• Followed agile methodology and delivering fast iterations to the users.
• Used Visual Source Safe (VSS) to check in the project work to maintain the version control.
• Created various jobs using SQL Server Agent.
• Generating ad-hoc reports using MS-Excel and Crystal Reports.
• Extensively used SQL Server Profiler to trace the slow running queries and the server activity.
• Actively participated in review meetings with Project Manager to ensure that the development of projects meet business and system requirements.
• Created OLAP cubes on top of the data warehouse basing various fact and dimension tables for analysis purposes using SQL Server Analysis Services (SSAS) 2005/2008.
• Created reports using SSRS from OLTP and OLAP data sources and deployed on report Server.
• Automated and updated daily tasks on IT Service Management System (ITSM).
• Documented the project work and process.

Project Environment: Microsoft SQL Server 2008R2, SQL Server2008,T-SQL, SSIS, SSRS, Embarcadero, Visual Studio 2008, SQL Server Agent, Windows server 2008, Visual Source Safe 8.0, SQL Profiler, SharePoint 2010, Team Foundation Server(TFS), ITSM 6.3.4, C#, Erwin, MS Access.

Confidential, Harrisburg, PA

MS SQL /BI Developer

Responsibilities:

• Responsible for Deploying the SSIS packages and scheduling the package, setting the Configuration files which is done in the specified tables and created technical specs documents for all the enhancements.
• Deploy SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Imported data from text files and excel spread sheets intoSQL Server2008 using SSIS package.
• Designed data models using Erwin. Developed physical data models and created DDL scripts to create database schema and database objects
• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures
• Used Script task for Data Flow and Error Handling in SSIS.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Created/Updated database objects like tables, views, stored procedures, function, packages,
• Involved in creating views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Generated Drill down, Drill through, Ad-hoc, Matrix Reports, parameterized reports using SSRS.
• Designed and developed monthly, quarterly and yearly reports.
• Involved in table and index partitioning for performance and Manageability.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Created several Dashboards and Scorecards with Key Performance Indicators (KPIs) in
• SQL Server 2005 Analysis Services (SSAS) using ProClarity and published via Windows
• Share Point Services.
• Monitored the overall performance of the database to recommend and initiate actions to improve/optimize Performance.
• Used SQL Server Profiler to trace the slow running queries and the server activity.
• Automated and enhanced daily administrative tasks including database backup and recovery.
• Involved in setting up SQL Server Agent Jobs for periodic Backups with backup devices, database maintenance plans and recovery.

Project Environment: Microsoft SQL Server 2005/2008, T-SQL, SSIS, SSRS, SSAS, Erwin, and Windows server 2008, Microsoft Office Share Point Server, Visual Source Safe, SQL Profiler, and Visual Studio 2008.

Confidential, Chicago, IL

SQL/SSIS Developer

Responsibilities:

• Involved in gathering and analysis of Business Requirements by interacting with end users.
• Front End was designed using VB 6.0.
• Managing all stages of the application from design, development and testing on both development & production environments.
• Involved in creating of T-SQL Stored Procedures, Triggers, View.
• Create joins and sub-queries for complex queries involving multiple tables.
• Developed complex stored procedures to create various reports.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Create documentation as required.
• Performance tuning and testing on stored procedures, indexes and triggers.
• Various Reports were generated including the Purchase Order Form. UsedSQL ServerAnalysis Services 2005 for interaction between client application and instance of Analysis Services.
• Involved in Planning and Monitoring and creating reports in Performance Point Server.
• Involved in writing MDX queries for cubes and Performance optimization of MDX queries.
• Actively participated in review meetings with Project Manager to ensure that the development of projects meet business and system requirements.

Project Environment:SQL Server2005 Enterprise Edition,SSIS, T-SQL, SSRS, Windows Server 2003, Oracle 9i, Performance Point Server 2005.