SUMMARY:

• Over 7 years of IT experience in Business Intelligence space; managing Database Designs, Development and support of enterprise level projects in Retail and Insurance domain.
• Proficient in gathering requirements from business stakeholders, analyzing System Requirement specification SRS, Functional Design specification FDS and preparing project estimates HLE/FPQ, High level and Detailed level design documents HLD & DLD .
• Experience in moderating Checkpoint Meetings, Seminars, Conference, Review Meetings and Brainstorming sessions.
• Experience in leading the team technically to deliver the solutions in agile/waterfall methodology.
• Excellent knowledge of Software Development Life Cycle (SDLC), Data Warehouse Life Cycle (DWLC).
• Worked on IBM Infosphere Data Architect for data modelling; for developing logical and physical data models.
• Extensive expertise in designing and developing business intelligence solutions using Informatica PowerCenter 9.5.1/8.6 sourcing data from heterogeneous systems to enterprise data warehouse for strategic analytics, visualization and decision making.
• Hands on experience in using various Active and Passive Transformations in the mappings.
• Extensively worked on Informatica Powercenter transformations such as Source Qualifier, Lookup, Update Strategy, Filter, Expression, Router, Joiner, Aggregator, Sorter, and Sequence Generator.
• Experience in debugging mappings using Powercenter debugger and executing Performance tuning of Informatica Sources, Targets, Mappings, Transformations and Sessions.
• Good experience in dynamic parameter files generation.
• Expertise in managing the deployments - creating static as well as dynamic deployment groups, labels, queries and deploying the components using Informatica Repository Manager.
• Experience in Configuration and Management of Users/Groups/Roles in Powercenter Admin console.
• Strong experience in MS SQL Server, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS).
• Proficient in developing Custom/parameterized reports, 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)/SSDT)
• Expert in designing & building the dimensions, creating SSAS tabular cube with star schema and creating reports from cube through SSRS.
• Extensive experience in working with Netezza, Teradata, Oracle, MS SQL, IBM DB2 databases.
• Have proficient working knowledge in UNIX shell scripting and Data Analysis Expression (DAX) queries.
• Highly proficient in creating Tables, Views, Indexes (DDL, DML), complex Stored Procedures, Triggers, Functions and writing SQL queries with various joins, unions etc. Extensively used diverse SQL functions as necessary.
• Expert in developing T-SQL Data Integrity constraints, Performance Tuning, Query Optimization and Data Validation.
• Instrumental in setting up standard ETL naming conventions & BEST Practices throughout the ETL process (Transformations, sessions, maps, workflow names, log files, bad files, input, variable, output ports).
• Good understating of Ralph Kimball's strategies in approach to design large data warehouses.
• Awareness in data warehousing concepts of Star Schema modelling and Snowflake Schema modelling, facts and Dimensions, Slowly Changing Dimensions.
• Extensive exposure to various reporting and visualization tools like BO 6.5, Cognos 10.1.0 and Power BI.
• Astute learner with excellent analytical and troubleshooting skills, ability to work independently or as a part of team and capable of picking up new skills quickly.
• Excellent mentor; takes up responsibility and ownership of work. Team player with commendable communication skills. Played the role of Knowledge Management anchor of the team.
• Received Certificate of Appreciation, “BRAVO” award for always being prompt with the deliverables and maintaining great quality.
• Earned goodwill of client and team managers for meeting strict deadlines and quality of deliverables.

WORK EXPERIENCE:

Informatica 9.5.1/MSBI - (SSIS/SSRS/SSAS)/ Netezza - Developer/ Technology Lead

Confidential, Milwaukee

Responsibilities:

• Designed and developed the centralized ODS system, which acts as the central data repository for Human Resource division across the organization.
• Developed ETL solutions using Informatica to load the data from heterogeneous sources to the new centralized ODS.
• Applied various business rules, data validations and data cleansing on the raw data extracted from multiple external data sources - Netezza/SQL tables for certain applications, .csv data feeds from online applications.
• Implemented auto file-watcher for data feeds received through SFTP to the Unix file location and process the files as and when they arrive.
• Migrated the ETL solution through various Dev and Test environments and deployed them into production environment in multiple sprints.
• Automated the ETL load process with effective error handling techniques to ensure data integrity and consistency.
• Implemented automated alert mechanism to notify various stake holders and support teams in the event of any delays or failures that may occur in the system.
• Applied data masking at various levels to ensure extra level of data security for sensitive data.
• Designed and developed various executive and summary reports using SSRS.
• Developed SSAS Tabular cube for interactive and detailed data analysis.
• Used DAX queries to extract data from the SSAS Tabular cube for creating interactive Excel reports.

Environment: Informatica Power Center 9.5.1, Netezza, Unix

Informatica 9.5.1/Oracle - Developer/ Technology Analyst

Confidential, Plano, Texas

Responsibilities:

• Worked with Senior BAs to understand the business requirement, analyse and propose the implementation plan for approval.
• Created the high level design after the analysis, incorporating the gathered requirements and validations proposed on the source data.
• Developed the ETL solutions using Informatica 9.5.1 to migrate the data from legacy system to the new environment applying the business rules for conversion.
• Developed UNIX shell scripts for file archiving and purging.
• Involved in performance tuning of the ETL processes. Configured and scheduled Pre and Post Session commands.
• Prepared test cases and performed unit testing as well as integration testing of Informatica Sessions, Batches and the Target Data.
• Developed an ETL solution to create a report consolidating all the records which failed the business rule validations during an integrated execution.
• Implemented email notifications to clients with the reports which would help them analyze the data and take necessary actions.
• Co-ordinated with the downstream mainframe team during all phases of the DWLC.
• Investigate, Analyze and document all conversion process and reported defects.
• Guided the ETL team on code review and release related activities.
• Deployed the code to multiple servers specific to the client using dynamic deployment feature through Informatica repository manager and provided warranty support.

Environment: Informatica Power Center 9.5.1, Oracle, Unix

Informatica 8.6/Oracle,Netezza - Developer/ Senior Systems Engineer

Confidential

Various Projects

Responsibilities:

• Played a major role in multiple major as well as minor ETL solutions and enhancements in different areas of the Insurance/Retail/telecoms data warehouse of the client.
• Worked closely with Senior Solution Architect to gather requirements from the client for a project wherein feeds with sales revenue data were demanded. Also assisted in the preparation of functional design specification document.
• Active member in the designers team and is responsible for preparing high level design documents with respect to the analysis done on the problem statement.
• Designed and developed the automation of generating monthly financial audit reports using ETL components.
• Played a major role in the migration of data and ETL components used to load the Insurance data warehouse of the client from Oracle to Netezza. This involved preparation of detailed design documents, conversion of ETL components, data migration, BO universe amendments.
• The BO universes which where hosted in Oracle where identified, analyzed and where amended to point to the newly built Netezza Insurance DWH.
• Recreated the lookup/transformation queries and scripts to make them migration environment compatible.
• Was part of the team to develop ETL components for building Insurance DWH for one of CPW’s client - Royal Bank of Scotland.
• Earned appreciation for accurate analysis and high level design document during the HLD review meeting with the client.
• Actively participated in Designer’s Huddle, a bi- weekly meeting conducted by the designers within the project.
• Prepared test cases and performed quality unit testing and integration testing.
• Involved in setting up standard ETL Naming standards & BEST Practices throughout the ETL process (Transformations, sessions, maps, workflow names, log files, bad files, input, variable, output ports).
• Was part of the panel assigned to prepare the code review checklist.
• Good experience in pre-release activities and RFC Request for Change creation to track and implement the change.
• Extensively worked on Informatica Powercenter transformations such as Source Qualifier, Lookup, Update Strategy, Filter, Expression, Router, Joiner, Aggregator, Sorter, and Sequence Generator.
• Developed complex Oracle and Netezza SQL queries wherever necessary. Created database DML and DDL scripts required for implementation.
• Worked in UNIX shell scripting.
• Worked on major enhancements in BO 6.5 reports to analyze various subscriber movements for effective decision making.
• Working experience of CONNX tool which was used in one of the tracks to read large Open VMS source files as tables.
• Deployed Informatica objects from one server to another server using Informatica repository manager.
• Performed smoke test post deployment and provided warranty support for all the projects deployed- static deployment feature.
• Scheduled the deployed ETL jobs to run as per requirements.
• Involved in identifying bottlenecks in source, target, mappings and sessions and resolved the bottlenecks by provided data loading, monitoring, system support and general trouble shooting necessary for all the workflows involved in the application during its production support phase.
• Played a role of Knowledge management anchor of the team. Co-ordinated and kept track of the KM activities within the team and mentored the junior resources.

Environment: Informatica Powercenter 8.6, Oracle, Netezza, Unix

Informatica 9.5.1/Oracle - Developer/ Senior Systems Engineer

Confidential, Seattle

Responsibilities:

• Worked with senior BA to analyse and discuss on the multiple channels through which the customer preference could be generated.
• Prepared detailed design documents for the problem statements.
• Prepared logical and physical model of the proposed solutions/data flow using Microsoft Visio.
• Developed mappings, sessions and workflows using Informatica PowerCenter 9.5.1
• Created SQL queries to handle certain business rules.
• Worked with Web Service transformations in most of the mappings where the WSDL for the specific function was provided by the senior BA.
• Prepared test cases for Unit testing and Integration testing.
• Closely worked and co-ordinated with the web service functions developing team and testing team.
• Used SOAP UI to debug the web service oriented application during unit testing.
• Deployed the code from development environment to test and production environment.
• Was involved in smoke testing the deployed ETL solutions and providing warranty support.

Environment: Informatica Powercenter 9.5.1, WinSCP, SOAP UI

SSIS, SSRS, SSAS/MS SQL Server - Developer/Systems Engineer

Confidential

Responsibilities:

• Created SSIS Packages to pull the data from different source systems.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task, Send Mail task etc.
• Create and maintain SQL stored procedures, views, triggers, scheduled jobs and DDL scripts.
• Defined Query for generating drill down/drill through reports in SSRS 2008 and designed stylish report layout.
• Created SSAS Cubes with Facts, Measure Groups and dimensions for analysis purpose.

Environment: SQL Server 2008, SQL Server Integration Services, SQL Server Reporting Services, SQL Server Analysis Services