SUMMARY:

• 7 years of software development experience including System Analysis & Design, Development, Integration, Testing, Tuning, Implementation and Production Support.
• Extensive experience in data warehouse processes including, data mapping, data conversion and Extraction/Transformation/Loading using Pentaho and MS SSIS.
• Experience includes exposure to the ETL and Business Intelligence domain.
• Worked extensively in enhancing the production systems, production support and end to end maintenance activities of Data Warehousing System.
• Good experience in Pentaho, Oracle 11g PL\SQL, MS SQL Server 2008R2/2005 SSIS, SSAS and SSRS, SQL, Cognos 10, Panorama 5.0 tool and Actuate 9.
• Highly proficient in the use of T - SQL for developing complex stored procedures, DML triggers, tables, user functions, SQL joins and query writing.
• Experience in creating ETL transformations and jobs using SQL Server Integration Services.
• Well-versed in developing reports usingCognos 10 components like Report Studio, Framework Manager, Query Studio, Analysis Studio and Cognos Connection.
• Experience in developing, testing and deploying ColdFusion Web reports and Actuate reports.
• Extensively involved in fine tuning of SQL stored procedures and Query Optimization.
• Good experience in Performance Optimizationof SSAS cubes, OLAP cube partitioning and SQL table partitioning.
• Expert knowledge of data warehousing methodologies and concepts including star schemas, snowflakes, dimensional modeling, data integrity and reporting tools.
• Experience inError handlinganddebuggingissues and troubleshootproduction problems.
• Adept in identifying and analyzing data discrepancies and data quality issues and to ensure data consistency and integrity.
• Experience working with Microsoft Visio for several design documents.
• Excellent verbal and written communication presentation and inter personal skills.
• Strong analytical and problem-solving abilities. Steep learning curve for new technologies.

TECHNICAL SKILLS:

Technical skills: Data Warehouse ETL & BI Design and Development

ETL Tools: SQL Server 2008 R2/2005 SSIS, PentahoDMExpress Syncsort, SQL Server 2000 DTS

OLAP & Reporting Tools: SQL Server 2005 SSAS, ColdFusion, SSRSPanorama BA tool, Actuate 9, Cognos 10

Databases: SQL Server 2008 R2/2005, Oracle 11g, SQL Server 2000

Languages: C, SQL, T-SQL, Oracle 11g PL\SQL

Operating Systems: Unix, Windows 2000, Windows XP

PROFESSIONAL EXPERIENCE:

Confidential, Schaumburg, Illinois

ETL and BI Developer

Responsibilities:

• Designed ETL packages dealing with different data sources (SQL Server, Flat Files) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Involved in writing complex SQL queries to retrieve data from numerous tables and views involving multiple joins and grouping.
• Developed complex Stored Procedures to load reporting tables with more than 200 metrics.
• Developed SSIS package to load unzip a master file and load 28 XML files using various transformations and log table to track the status of files loading.
• Expert in writing Merge Statements to synchronize data between tables across environments.
• Writing T-SQL code, complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic.
• Interacted with different report users to understand their needs and develop reports based on that and have acquired lots of accolades for completing them on Confidential and with zero defects.
• Involved in Creating Web Reports using ColdFusion Markup Language.
• Creating complex views with multiple dimensions so that they can be used in different reports in order to improve the performance of the reporting.
• Fully responsible for Production Jobs and to maintain the Data Integrity throughout the System.
• Identified and listed out the potential duplicates along with the original records in the source system to the CRM Team in order to improve the accuracy of reporting.
• Involved in standardizing many manual tasks in the process of loading tables using SSIS packages and scheduled them in SQL Server Agent Jobs.
• Solely responsible for the Source System Migration project which involved change in almost every raw table in the Database.
• Worked on Daylight Savings project which adjusts the Confidential values in all the date Confidential fields in the database. The business data should be in CST whereas the source in GMT.
• Reported performance data of call center reps over Confidential using various metrics and multiple dimensions which helped the management to get a better idea on their activities.
• Involved in building history tables which helped to track the changes over Confidential .
• Improved the report quality by providing not just the Locked values but also the First and Current Values which helped the users to understand the flow better.
• Involved in fine tuning of various stored procedures and long running SQL queries.
• Analyzed and proposed actionable insight on marketing, media and operational performance to hospitals, corporate development, marketing, sales and call center leadership.

Environment: MS SQL Server 2008 R2 SSIS, SQL, T-SQL, Coldfusion, Microsoft Excel.

Confidential, Schaumburg, Illinois

ETL and BI Developer

Responsibilities:

• Responsible for getting, understanding the business requirements by client interactions.
• Understanding the functional work flow of information from source to destination systems.
• Creating, deploying and executing SSIS packages in both Dev and Prod environments.
• Involved in using various Transformations in SSIS Dataflow and Control Flow items.
• Involved in Error and Event Handling: Precedence Constraints, Break Points, Check Points and Logging.
• Created SSIS packages for Data Conversion using data conversion transformation.
• Configured the loading of data into Slowly Changing Dimensions using SCD wizard.
• Writing T-SQL code, complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic.
• Involved in Normalization and De-Normalization of existing tables and creating Clustered and Non-Clustered indexes on tables to faster retrieval of data for the Reports.
• Writing complex SQL queries using SQL Server Management Studio for data validation.
• Developing SSAS Cubes, Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models and Deploying and Processing SSAS objects.
• Responsible for interacting with different data publishing teams to understand the logic in calculation of the metrics/reports.
• Involved in Designing and Creating COGNOS reports and Dashboards based on requirement.
• Generated variousList Reports,Grouped Reports,Cross tab Reports,Chart Reports, Drill-Down andDrill-Through Reports.
• Fine Tuning the SQL for complicated reports and used Union/Join Objects in ReportStudio.
• Preparation of Unit Test Plan & Unit Test Cases.
• Fully responsible for System Integration and User Acceptance Testing.

Environment: Cognos10, MS SQL Server 2008 SSIS, SSAS, SQL, T-SQL, O/s: Windows 2007

Confidential, New York

ETL and Report Designer/Developer

Responsibilities:

• Played a major role in the study of old WH and actively involved in the creation of new Ad analytics warehouse tables and views.
• Involved with database design - creation of Tables and Indexes.
• Involved in writing PL\SQL scripts for porting data to the new WH tables.
• Quickly learned and delivered solutions in Open Source ETL tool Pentaho
• Actively involved in creating, modifying, debugging and testing the Pentaho transformations.
• Modifying the kettle.properties and shared.xml files across the servers as required.
• Creating Pentaho jobs and scheduling them using crontab.
• Developed complex SQL queries for validating data.
• Developed stored procedures, triggers to implement business logic.
• Actively involved in the data comparison and analysis of the existing WH and the newly built Data Warehouse.
• Identify and analyze data discrepancies and data quality issues and works to ensure data consistency and integrity.
• Involved in gathering the requirements from business users, developing Actuate reports using e-report designer professional and publishing the same in Actuate server.
• Providing access rights to the users for Actuate reports.
• Performed necessary changes and deployed java helper files for Actuate Reports.
• Involved in the performance tuning of the existing reports.
• Testing of the enhanced and developed actuate reports for requirement match, data check, look and feel part and to fix up issues if any.
• Solely involved in monitoring the Pentaho jobs in Production Server.

Environment: Pentaho 4.1, Oracle 11g PL\SQL, Actuate 9, Unix Server.

Confidential, New Jersey

ETL Developer

Responsibilities:

• Understanding the business requirements.
• Understanding the data extract requirements from Data Warehouse to Data Mart.
• Developing PL\SQL procedures.
• Creating DMExpress Jobs and tasks to load the transformed data into Data Mart
• Extensively supported and worked with the testing team.

Environment: Oracle 10g PL\SQL, DMExpress Syncsort.

Confidential, New Jersey

ETL and OLAP Developer

Responsibilities:

• Involved in designing the physical databases model onSQLServer2005 RDBMS using differentData DefinitionandData Manipulationlanguages (DML/DDL) implementing constraints and triggers for data integrity in development database for Warehouse system.
• CreatingDTS/SSISpackages andT-SQLstored procedures to transfer data fromOLTPdatabases to staging area and finally transfer into data marts.
• Involved in creating authentication modes, configuring permissions and assigning roles to users.
• Creating new briefing books and Multidimensional Panorama views.
• Migrating data from different sources includingflat files, MySQL, MS Access, Oracle 11g, and OLE DB sourcesto various Destinations by usingSSIS 2005.
• Deploying several SSIS packages using package configurations.
• Loading data into Dimensions and Fact tables using SSIS.
• Developing of Frame works, Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Used T-SQL(DDL & DML) in Creating & Updating tables, views, DevelopingStored Procedures,Triggers,Nested Queries, Joins, Cursors, Indexed Views, User Defined Functions,Indexes,User Profiles, CTE’s, Table Variables, Relational Database Models
• Checking the database consistency by executingDBCC Commands.
• Managed Slowly Changing Dimensions(SCD)and optimized fact table inserts.
• WritingT-SQL, working on DTS, Data Cleansing andData Migration.
• Involved inPerformance Optimizationof SSAS cubes.
• Writing MDX Queries and expressions in Cubes for use in front end BI applications.
• Performance Tuning in SSIS packages by using Row, Block and Unblock Transformations.
• Involved in creating Linked Servers for connecting servers at remote site locations like Oracle enterprise and retrieve that data using PLSQL.
• Creatingloggingfor ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Created various Actuate Reports involving variety of features likeReports, Charts, Filters, Sub-Reports, Drilldown, Drill-Through, Multi-valued parametersetc.
• Involved insorting the data, defining data sourceandsubtotals for the reports.
• Worked on querying data and creating on-demand reports usingReport BuilderinSSRS reportsand send thereports via email.
• Responsible for data processing across ODS to DW and develop custom audit process handles audit checks on source systems before processing data.
• Working with business analysts and quality analysts to make sure fulfill the business requirements.

Environment: SQL Server 2000 DTS, SQL Server 2005, SQL Server Integration Service (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), SQL Profiler, Microsoft Visio, T-SQL, Panorama 5.0, Actuate 9,Visual Source Safe 2005, MS Office.

Confidential

Responsibilities:

• Involved in developing DTS Packages (SQL Server 2000 DTS), SSIS Packages (SQL Server 2005) and MS OLAP (SQL Server 2005) cubes.
• Creating new briefing books and multidimensional views using Panorama 5.0.
• Developing complex SQL stored procedures, functions, triggers, cursors, tables, views, indexes, SQL queries and T-SQL code.
• Expert in designing and scheduling complex SSIS 2005 packages for transferring data manually from multiple data sources to SQL server.
• Involved in cube partitioning and SQL table partitioning.
• Checking the database consistency by executingDBCC Commands.
• Managed slowly Changing dimensions(SCD)and optimized fact table inserts.
• Using Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Involved inPerformance Optimizationof SSAS cubes.
• Writing MDX Queries and expressions in Cubes for use in front end BI applications.
• Creating reports(SSRS)inDrill modeusing tables,financialtables,crosstabsand charts.
• Design, deployment, and maintenance of variousSSRSReports inSQLServer2005
• Design and documented the integration and reporting test cases.
• Developed differentParameterized Reportswhich consist of report Criteria in various reports to make minimize the report execution Confidential and to limit the no of records required.
• Created ad-hoc queries and reports for unit team lead as requested and provide on-going analytical support for these requests.
• Scheduled the reports to run on daily and weekly basis in report manager and also email them to director and analysts to review in excel Sheet.
• Creatingloggingfor ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Identified outdated indexes with Tuning Advisor and replaced with more effective indexes.
• Identified long running stored procedures using Execution Plan and optimized queries for more effective data retrieval and SQL profiler to solve deadlocks.
• Involved in Test cases development and implementation for the enhancements.
• Involved in writing SQL scripts to validate database data.
• UsedVisual Source Safefor version control and configuration management.
• Engaged in defect tracking and automation activities.
• Involved in code migration and production support activities.

Environment: SQL Server 2000 DTS, SQL Server 2005, SQL Server Integration Service (SSIS), SQL Server Analysis Services (SSAS) and Reporting Services (SSRS), SQL Profiler, Microsoft Visio, T-SQL, Panorama 5.0, Visual Source Safe 2005, MS Office.