PROFESSIONAL SUMMARY:

• Around 7+ years of IT experience in Microsoft Business Intelligence technologies like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS).
• Knowledge in Property and Causality insurance types.
• Extensive knowledge and Experience in dealing with Relational Database Management Systems including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors .
• Experience in dealing with high volume transactional data in SQL.
• Strong experience in SQL Development, ETL development using Microsoft SQL Server Integration Services(SSIS), Business Intelligence delivery using Microsoft SQL Server Analysis Services (SSAS) and Reporting solutions using Microsoft SQL Server Reporting Services (SSRS) .
• Good understanding and experience in SQL 2008 new features like Change Data Capture (CDC).
• Very good experience in Creating, deploying SSIS Packages and migrating DTS Packages from 2000 to 2005 / 2008 .
• Experience in migration of SSRS reports from SQL 2000 to SQL 2005 and SQL 2008 and SQL 2008 R2 .
• Extensive experience in writing Distributed Queries between SQL Servers by creating link servers.
• Experience in troubleshooting SQL issues by using SQL Tools , execution plans, trace, statistics, and index tuning wizard.
• Extensive experience in delivering OLAP solutions by developing Corporate Dashboard Reports using SQL Server Reporting Services (SSRS), Report Model and Ad Hoc Reporting using Report Builder functionality.
• Experience in Performance Tuning and Query Optimization .
• Extensive experience in using SQL Server Profiler to monitor the SQL server for deadlocks, long running queries and tunes the same to improve performance.
• Developed ETL process using SSIS with Various Control Flow , Data Flow tasks and Store Procedures for Work Order Validation process.
• Experience in creating and managing fragmentation of Indexes to achieve better query performance.
• Experience in creating Data Driven, Drill Through, Drill Down, Tabular, Matrix reports & created charts, graphs using SQL Server 2005 Reporting Services (SSRS).
• Expert in using tools like Bulk Copy (BCP), Data Transformation Services (DTS) and SSIS.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MSOLAP/ Analysis Server (SSAS).
• Experience in creating reports through PROCLARITY . Used PROCLARITY for accessing and analyzing cubes and dimensions.
• Experience in developing Custom Report and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business Intelligence Development Studio (BIDS).
• Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possess strong analytical skills.
• Self - motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills. Team-oriented, technically motivated and creative. User oriented with a desire to learn client's business requirements.

TECHNICAL SKILLS:

Languages:: Transact SQL, C, Visual Basic 6.0, VB.Net, C#, .NET, ASP.NET, HTML.

Databases:: SQL Server 2012/2008R 2/2008/2005/2000 , MS Access, TFS, Oracle

ETL Tools: DTS, SSIS, Data Stage

Data Modeling Tools: Erwin, Visio

Other Software: MS Office- 2007/2003/2000

Operating Systems: Windows / 98/2000/2003/ XP/Vista

Database Tools: SQL Query Analyzer, SQL Enterprise Manager, Management Studio, Analysis Manager, Reporting Server

PROFESSIONAL EXPERIENCE:

Confidential, Schaumburg, IL

ETL/BI Developer

Responsibilities:

• As a key member of BI team, delivered the best results to the development needs, accomplished successful outcomes by working with SSIS, SSAS and SSRS.
• Supported the Project Manager in leading multi-functional project teams in implementing data conversion strategies and communicating essential information to team members.
• Trained/guided new or junior developers in certain development areas helped them to understand better the project process.
• Designed and developed various SSIS packages (ETL) to extract and transform data and involved in Scheduling SSIS Packages.
• Performed SSIS Development and support, developed ETL solutions for integrating data from multiple sources like Flat Files (delimited, fixed width), Excel, SQL Server, Raw File, and DB2 into the data warehouse.
• Created the optimal logics to load the data that business rules were based on flat file names or ragged hierarchy.
• Regularly worked/used TFS and did Incremental Load using Foreach Loop, Sequence containers, Script Task, Conditional split, Data Conversation, Derived Column, Lookup, Merge/Merge Join, Union all and so on in Visual Studio 2008r2/2012.
• Identify and resolve problems encountered during both development and release of the SSIS code.
• Debugging and troubleshooting the technical issues while implementing the applications.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Created packages in SSIS with error handling and worked with different methods of logging in SSIS
• Developed, Maintained, and Monitored all import/export and Data Transformation into the Staging and Production environments.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing complex transformations using SSIS/DTS packages.
• Worked on QNXT claims and Conversion of Interface Programs from Legacy to QNXT.
• Used ETL to implement Slowly Changing Dimension to maintain historical data in Data Warehouse.
• Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages and Updating and maintaining Visual Source Safe.
• Created complex Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.
• Responsible for data analysis, loading data from Data feed to Data Warehouse tables.
• Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.
• Created views to display required information on user interface, and triggers to validate consistent data entry into the database.
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like Tabular, Matrix, Drill Down, Drill Through and web reporting by customizing URL Access.
• Designed different kinds of reports from scratch depending upon the requirements of the markets, vendors, providers and scanners.
• Documented all the work and all the process of integration and reporting services for further references
• Worked extensively on system analysis, design, development, testing and implementation of projects (Complete SDLC).

Environment: MS SQL Server 2005/2008 R2/ SQL Server 2012/2014, SQL server Reporting Services 2008, SQL Integration Services 2008,SQL server Analysis Services 2008, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL,ERWIN.

Confidential, Columbus, OH

SQL BI SSRS, SSIS, SSAS Developer

Responsibilities:

• Creation, Development and Maintenance of SSIS Packages and SSRS Reports.
• Responsible for designing and managing project specific ETL codes using SSIS and SQL Server 2008, 2008 R2,2012 and Oracle - fetching data across various source systems into Client specific Enterprise Data Warehouse.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, Oracle DB etc).
• Loaded the data into destination tables: both full and incremental load, by performing different kinds of transformations like row count, Look-up, derived column, merge, script task using SSIS packages and also performed with truncating, modifying and creating tables in data base as per requirements.
• Designed databases to feed the data from monthly flat file data and automated the data load process.
• Created SSIS packages for File Transfer from one location to the other using FTP task with Master SSIS Package to run all other packages.
• Extensively used Joins and CTE'S for complex queries involving multiple tables from different databases.
• Worked with configuring checkpoints, package logging, error logging and event handling to redirect error rows and fix the errors in SSIS.
• Developed SSIS template framework which can be used to develop SSIS packages in such a way that they can be dynamically deployed into Dev, UAT and production environments.
• Involved in Deployment and Administration of SSIS packages with Business Intelligence development studio.
• Automated execution process, scheduling, deploying of packages using SQL Server Agent by creating jobs and error reports using Alerts, SQL Mail Agent and FTP and Used SQL Profiler to optimize Stored Procedures.
• Loaded fact and dimension tables as part of modified data warehouse solution.
• Deployed SSIS packages with minimal changes using XML configuration file.
• Worked extensively with SSIS to import, export and transform the data from xml and text files.
• Used Execution Plan, SQL SERVER Profiler to trace the slow running queries and tried to optimize SQL queries for improved performance and availability.
• Created SQL scripts for tuning and scheduling. Performed data conversion from flat file into normalized data structure.
• Written with Complex Queries, stored procedures, Batch Scripts, Triggers, indexes and Functions using T-SQL for SQL Server 2012.
• Used DDL and DML for writing triggers, stored procedures to check the Pre-ETL conditions and reconciliation of data.
• Part of the Production Support team, providing simple yet construct solution to the problems and issues identified by the Business Users.
• Created SSRS Reports: involving variety of features like Charts, Filters, Sub-Reports, Drill Down, Drill-Through, Multi-valued parameters Tablix control and also involved in Dashboard reporting, Share Point with Power View tool, TFS etc.
• Worked very closely with Business Customers, End Users and resolved any business process related issues.

Environment: Microsoft SQL Server 2012/2008 R2/2008, SSMS, SSIS, SSRS, SSAS, Visual Studio 2010/2008, SQL SERVER AGENT, SQL PROFILER, C#, ERWIN7.2, TFS, Windows 2008, ORACLE, MS-OFFICE.

Confidential, Overland Park, KS

ETL/SQL Developer

Responsibilities:

• Implemented Complex business logic with User-Defined-Functions, Index Views and also created User defined Data type, Clustered & Non-clustered Indexes
• Installed and configure servers and clients using SQL Server 2008,Upgraded SQL databases
• Engaged in designing and developing test cases, error control routines, data validation, load processes, audit and log controls using PL/SQL, SQL.
• Created database maintenance planner for the performance of SQL Server, which covers Database integrity checks, update Database statistics and re-indexing
• Created complex Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards
• Managed indexes, statistics and tuned queries by using execution plan for optimizing the performance of the databases
• Query optimizations (T SQL or Query Analyzer) using query analyzer and Index tuning wizards
• Used Data Modification Language (DML) to insert and update data, satisfying the referential integrity constraints and ACID properties
• Knowledge of Database Performance monitoring tools
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs
• Created packages in SSIS with error handling and worked with different methods of logging in SSIS
• Created ETL SSIS packages both design and code to process data to target databases
• Created SSIS packages to retrieve data from Legacy sources and also to retrieve user data from the Flat files on monthly and weekly basis
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation. Developed, monitored and deployed SSIS packages
• Managed SQL user logins, database user accounts, server roles, database roles and its permissions.
• Created jobs to collect status information from various servers and feed them to the Master Server
• Maintained the physical database by monitoring and optimizing performance, data integrity and SQL queries for maximum efficiency using SQL Profiler
• Monitor SQL Error Logs /Schedule Tasks/database activity/eliminate Blocking & deadlocks user counts and connections/locks etc.
• Implement automated Index Maintenance strategy run as SQL Job on a daily basis
• Created Snapshots, Subscriptions and Transactions using Replication services
• Worked on Transactional Replication and replicated thousands of tables from various Databases to different production Server
• Resolving any dead locks issues with the Databases/Servers on a real-time basis.
• Worked on development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS and DTS
• Designed and developed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet and flat files into SQL server 2005 for further
• Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into UL Database and DB2 Billing Systems
• Migrated SQL server 2000 DTS packages to SQL Server 2008 SSIS packages using SQL Server 2008 Upgrade Advisor
• Responsible for the design of the SSIS package for updating the data mart from OLTP database and validation of the aggregate data from the ODS and the OLTP Database.

Environment: MS SQL Server2012/ 2008, MS SQL Server Master Data Services 2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), MS Visual Studio.NET# 2008, SAP Business Objects, BI Extractor, Microsoft Excel, Add-In Excel with Master data.

Confidential, Auburn Hills, MI

ETL DEVELOPER

Responsibilities:

• Involved in gathering and analyzing the requirements and preparing business rules.
• Gathered information from source system, Business Documents and prepared the Data conversion and migration technical design document.
• Designed and developed complex mappings by using lookup, expression, update, sequence generator, aggregator, router, stored procedure, etc., transformations to implement complex logics while coding a mapping.
• Worked in requirement analysis, ETL design and development for extracting data from the Mainframes..
• Developed and maintained ETL (extract, transformation and loading) mappings to extract the data from multiple source systems like oracle, SQL server and flat files and loaded into oracle.
• Wrote Stored Procedures and Functions for better performance and flexibility.
• Deployed SSIS packages into various Environments (Development, Test and PROD) using Deployment Utility.
• Coordinated with Users in different testing phases.
• Created SQL Server jobs and scheduled them to load data periodically using SQL server Agent.
• Extracted data from different databases like oracle and external source systems like flat files using ETL tool.
• Extracted data from sources like SQL server, and fixed width and delimited flat files. Transformed the data according to the business requirement and then loaded.
• Extract Transform and Load (ETL) source data into respective target tables to build the required data marts.
• Generated queries using SQL to check for consistency of the data in the tables and to update the tables as per the business requirements.
• Involved in Dimensional Data Modeling and Cube partitioning in SSAS.
• Worked on the Reports module of the project as a developer on MS SQL Server 2008 (using SSRS, T-SQL, scripts, stored procedures and views).
• Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS Developed Multidimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
• Designed Dimensional modeling using SSAS cubes for End-User. Created Hierarchies in Dimensional Modeling.
• Developed Aggregations, partitions and calculated members for cube as per business requirements.
• Coordinated testing of all components developed for the upgrade and downstream impacts in a controlled test or model office environment by end user personal with assistance by the project team.
• Good understanding of source to target data mapping and business rules associated with the ETL processes.
• Documented ETL test plans, test cases, test scripts, test procedures, assumptions, and validations based on design specifications for unit testing, system testing, expected results, preparing test data and loading for testing, error handling and analysis.

Environment: MS SQL Server2012/ 2008, MS SQL Server Master Data Services 2012, SQL Server Integration Services (SSIS), SQL Server Integration Services (SSIS), IBM DataStage 8.0, Erwin7.1, Oracle 10g, SQL Server 2008, DB2, Toad, Sun Solaris, Windows XP, Test Director PL/SQL, WINCVS, Unix Shell scripts.