SUMMARY:

• Over 6 years of IT experience as an Informatica Power Center, MS SQL Server 2012/2008R2/2008 Developer in various industries like Finance, Retail, Insurance and Health Care.
• Strong knowledge of Data Warehouse concepts and technologies such as ETL processes, dimensional modeling, Star and Snowflake Schemas, reporting tools and surrogate key generation.
• Strong Data Warehousing ETL experience of using Informatica PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools - Informatica Server, Repository Server manager.
• Expert in Logical and Physical Database design & development and Data modeling using the Erwin Data Modeler tool. Also performed consistency checks using DBCC utilities to ensure the physical consistency of the database and objects.
• Experienced in SharePoint 2010 Development, .NET Development, SharePoint 2010, web configuration and deployment.
• In-depth knowledge of Transact-SQL (DDL and DML). Proficient in creating Tables, Indexes, Joins, Triggers, Views, Stored Procedures, User Defined Data Types and Functions.
• Developed SSIS Packages to Extract, Transform and Load (ETL)/DTS data into the Data warehouse from Heterogeneous databases such as Oracle, DB2, Sybase and MS Access.
• Extensive experience in ETL design, development and maintenance using Oracle SQL, PL/SQL, SQL Loader, Informatica Power Center V8.x/9.x/10.x.
• Expertise in upgrading/migrating from DTS to SSIS packages. Experienced in resolving complex issues and error handling in SSIS 2012/2008R2/2008.
• Experienced in report generation using Crystal Reports, XML, MS Access and Excel.
• Proficient in creating Chart reports, Drill down and Drill through reports by passing parameters using SSRS 2012/2008R 2/2008/2005.
• Conversant with all phases of the Software Development Life Cycle (SDLC) involving business process analysis, requirements gathering and analysis, detailed design, development, testing and post implementation support.
• Developed and Deployed OLAP cubes, Facts and Dimension tables.
• Used MDX (Multi-dimensional Expressions) queries for calculated members of a cube and KPIs (Key Performance Indicators) in SSAS 2008R2/2008.
• Expert in Database Normalization, Optimization and Tuning, Backup/Restore, Data Import/Export and Troubleshooting.
• Expertise in using tools like the Index Tuning Wizard of the Database Engine and SQL Profiler for performance monitoring and tuning.
• Expertise in VBA macros and MS-Excel (VLOOKUP and Pivot).
• A motivated, highly organized individual and enthusiastic team player with excellent communication, analytical and problem-solving skills.

TECHNICAL SKILLS:

MS SQL Server 2012/2008R2/2008, MS SQL Server 2008R2/2008 Analysis Services (SSAS), MS SQL Server Integration Service (SSIS), MS SQL Server Reporting Services (SSRS), Informatica 9.6.1/9.5.1 /9.1/8.6.1/8.1, Microsoft Access 2010, ERWIN 9/8/7.2, Microsoft Visio 2016/2010, T-SQL, C#, VB.Net, HTML, XML, XSL, Oracle 12c/11g/10g/9i, Crystal Reports 8.5/9/10/11,TFS, MS Office 2016/2010, Windows 2008 Advanced Server/Professional, Windows NT 4.0 Server/Workstation, QlikView, VBScript, SharePoint 2012/2010, HP ALM 12.56.

PROFESSIONAL EXPERIENCE:

Confidential, Owings Mills, MD

Informatica/ETL Lead

Responsibilities:

• Analyzed the business requirements and functional specifications.
• Extracted data from oracle database and spreadsheets and staged into a single place and applied business logic to load them in the central oracle database.
• Used Informatica Power Center 9.6.1 for extraction, transformation and load (ETL) of data in the data warehouse.
• Extensively used Transformations like Router, Aggregator, Normalizer, Filter, Lookup, Joiner, Expression and Lookup, Update strategy and Sequence generator and Stored Procedure.
• Developed complex mappings in Informatica to load the data from various sources.
• Parameterized the mappings and i Confidential eased the re-usability.
• Applied slowly changing dimensions like Type 1 and 2 effectively to handle the delta Loads.
• Used Informatica PowerCenter Workflow manager to create sessions, workflows and batches to run with the logic embedded in the mappings.
• Created procedures to truncate data in the target before the session run.
• Created various tasks like Session, Command, Timer and Event wait.
• Modified several of the existing mappings based on the user requirements and maintained existing mappings, sessions and workflows.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Tuned the performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of workflows.
• Extensively used TOAD & Oracle SQL Developer for executing SQL scripts, develop queries and create procedures and packages in Oracle and worked on SQL for enhancing the performance of the conversion mapping.
• Used the PL/SQL procedures for Informatica mappings for truncating the data in target tables at run time.
• Worked extensively on PL/SQL as part of the process to develop several scripts to handle different scenarios.
• Wrote different PL/SQL procedures which can be called by the web services for any data extraction and updates into Facets Database.
• Extensively used Informatica debugger to figure out the problems in mapping. Also involved in troubleshooting existing ETL bugs.
• Created a list of the inconsistencies in the data load on the client side so as to review and correct the issues on their side.
• Created the ETL exception reports and validation reports after the data is loaded into the warehouse database.
• Written Software Design Specification(SDS) documentation to describe program development, logic, coding, testing, changes and corrections.
• Created Test cases for the mappings developed and then created integration Testing Document.
• Scheduled the Informatica jobs to run per pre-defined schedule using CA-7.
• Closely worked with the reporting team to ensure that correct data is presented in the reports.
• Interaction with the offshore team on a daily basis on the development activities.
• Followed Informatica recommendations, methodologies and best practices.
• Used HP Application Lifecycle Management(ALM) tool for defect assignment and management.
• Used Serena Business Manager(SBM) for all the New Work requests, Small enhancements, Task management and any other work assignments for different IT teams.

Tools & Technologies: Informatica Power Center 9.6.1/9.5.1, Oracle SQL Developer 4.2/4.1.1/4.0.1, Toad for Oracle 12.5, MS Office 2010/2016, PL/SQL, SharePoint, TortoiseSVN, HP ALM 12.53, Serena Business Manager, CA-7, FileZilla, PuTTY, Facets 5.40/5.3/4.8.

Confidential, Baltimore, MD

MS SQL/SSIS/BI Developer

Responsibilities:

• Developed complex T-SQL queries and designed SSIS packages to load the data into warehouse.
• Loaded historical data using full load and i Confidential emental load into SQL Server 2008 R2.
• Involved in creating multiple parameterized stored procedures which were used by the packages to get the data and to populate stage tables.
• Worked with SSIS script task, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts.
• Utilized several Transformations like For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Package Execution task to achieve business needs.
• Used different types of Transformations for Data Conversion, Sorting and data cleansing from different Sources into Company Formats.
• Developed complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the SQL Server database.
• Done Error Handling using Script components in SSIS.
• Implemented the custom logging feature in SSIS.
• Implemented business rules via stored procedures and T-SQL queries used in SSIS packages.
• Maintained all the project related documents on SharePoint Site.
• Kept the code versions maintained by using SVN repository.
• Verified the accuracy of data, and maintained and supported the data warehouse.
• Analyzed the query execution plan in SQL Server Management Studio & Created different types of Indexes accordingly on the table to make the query execution faster.
• Responsible for handling the table constraint properties and to make the changes to Data Model accordingly.
• Performed ETLs and validated results with Data governance team & business representatives.
• Facilitated requirements gathering using expert listening skills and developed unique simple solutions to meet the immediate and long-term needs of business customers.
• Worked with Data Governance team to fix the issues with Source-Target Mapping documents.
• Responsible for monitoring and tuning queries and data loads, addressing user questions concerning data integrity.
• Monitored performance and communicated functional and technical issues.
• Supported the development and validation required through the lifecycle of the DWH and Business Intelligence systems.

Tools & Technologies: SQL Server Management Studio 2008 R2, Microsoft Visual Studio 2010/2008, MS Server Integration services, MS Excel, T-SQL and Windows Server 2008, SVN, HP ALM.

Confidential, NYC, NY

MS SQL Server/SSIS/Informatica Lead

Responsibilities:

• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (CSV, Excel, Oracle db, and SQL 2005).
• Used Informatica Power Center Workflow manager to create sessions, workflows and batches to run with the logic embedded in the mappings.
• Extracted and Transformed data into Staging Servers for historical data and ODS Server for load i Confidential ement.
• Extensively used Informatica debugger to figure out the problems in mapping. Also involved in troubleshooting existing ETL bugs.
• 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 Custom Logging so user can know when a row is inserted in custom logging table by every SSIS package that executes.
• 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, Send Mail Task, Package Execution task to achieve business needs.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Created VB.Net Script for Data Flow and Error Handling using Script component in SSIS.
• Responsible for verifying accuracy of data, and maintaining and supporting the data warehouse.
• Responsible for creating database objects like Table, Store Procedure, Triggers, Functions etc. using T-SQL to provide structure to store data and to maintain database efficiently.
• Created star schema data models, performed ETLs and validated results with business representatives.
• Performed improvement of application by replacing the old cursor logic in various CTE by writing complex T-SQL queries.
• Supported and implemented BI solutions by monitoring and tuning queries and data loads, addressing user questions concerning data integrity.
• Supported the development and validation required through the lifecycle of the DWH and Business Intelligence systems.
• Facilitated requirements gathering using expert listening skills and developed unique simple solutions to meet the immediate and long-term needs of business customers.

Tools: & Technologies: SQL Server Management Studio 2014, Informatica Power Center 8.6.1, Microsoft Visual Studio, MS Server Integration services, SSIS, DTS, MS Excel, T-SQL and Windows Server 2008.

Confidential, Minneapolis, MN

ETL/Informatica/SSRS Developer

Responsibilities:

• Designed and developed ETL packages to validate, extract, transform and load data from OLTP system, Staging Database to data warehouse.
• Designed and created complex source to target mappings using various transformations inclusive of but not limited to Aggregator, Look Up, Joiner, Source Qualifier, Expression, Sequence Generator, and Router Transformations.
• Using Informatica PowerCenter Designer analyzed the source data to Extract & Transform from various source systems (oracle 10g, DB2, SQL server and flat files) by incorporating business rules using different objects and functions that the tool supports.
• Used various transformations like Source Qualifier, Joiner, Lookup, SQL, Router, Filter, Expression and Update Strategy.
• Using Informatica PowerCenter created mappings and mapplets to transform the data according to the business rules.
• Tuned the performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of workflows.
• Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks, used Informatica scheduler to schedule jobs.
• Documented Informatica mappings in Excel spread sheet.
• Worked with Tabular reports, Matrix reports, Gauges & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment using Sql Server Reporting Services(SSRS).
• Scheduled execution and delivery of end of the day report using SSRS.
• Participated in reviews of issues related to SSRS reports and work in troubleshooting those issues, fixing, testing and deploying them.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler and Database Engine Tuning Advisor.
• Optimized schema, performance and capacity planning of various data transformation processes related to the reports.

Tools: & Technologies: Informatica Power Center 8.1, MS SQL server 2012, Oracle 10g, SSRS, Profiler and Windows Server 2008, QlikView.

Confidential

MS SQL/SSRS/Informatica Developer

Responsibilities:

• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect
• Created logical and physical data models using Erwin for new requirements after discussion with technical team and application users.
• Created Informatica Mappings to build business rules to load data using transformations like Source Qualifier, Aggregator, Expression, Joiner, Connected and Unconnected lookups, Filters and Sequence, External Procedure, Router and Update strategy.
• Stored reform Confidential ed data from relational, flat file, XML files using Informatica (ETL).
• Created various batch Scripts for scheduling various data cleansing scripts and loading process.
• Extensively worked on Mapping Variables, Mapping Parameters and Session Parameters.
• Extensively used Joins, Triggers, Stored Procedures and Functions in Interaction with backend database using PL/SQL.
• Performance tuning by optimizing the sources targets mappings and sessions.
• Used QlikView Business Intelligence platform for turning data into knowledge.
• Generated reports using Global Variables, Expressions and Functions using MS SQL Server Reporting Services 2012.
• Identified the database tables for defining the queries and defined datasets for report generation.
• Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2012.
• Created parameterized, drill down and aggregation reports in MS SQL environment using SSRS 2012.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2012.
• Extensively used performance monitor/SQL profiler to solve dead locks/long running queries.
• Responsible for the Performance tuning of the SQL Commands and the troubleshooting of the technical problems in MS SQL Server 2012 with the use of the Query Analyzer and Database Engine Tuning Wizard.

Tools: & Technologies: Informatica 8.1, Oracle 9i, MS SQL Server 2012, T-SQL, SSIS, DTS, SSRS, Profiler and Windows Server 2008, QlikView.