SUMMARY:

• Confidential is a seasoned ETL and DW professional with 10 years of experience primarily in Informatica, DataStage, Data Warehousing, Data Modelling, Data Quality, Oracle warehouse builder and Pervasive. In addition, Confidential possesses significant exposure to IBM Cognos reporting tool to implement complex drill down reports to enable business with better decision making. Industry experience spans across financial, leasing, transportation, retail and marketing domains. Key highlights of Confidential ’s experiences are -
• Expertise in creating and maintaining data model, ETL, data warehouse, database, BI solution and database programming for major multi-national companies.
• Excellent exposure to the entire Software development life cycle (SDLC) and quality management system (QMS) processes.
• Lead BI project from planning to project closure, which includes requirements gathering, creating WBS/work packages, facilitated quality team, identifying project risk, identifying change requests whenever there is a deviation from the plan.
• Expertise in developing applications using Informatica, Oracle warehouse builder, DataStage, Oracle APEX, Pervasive, Automate, CIS composite and Erwin Platinum
• Expertise with databases including Oracle 9i/10g, PL/SQL/IBM DB2 and MySql
• Have diverse exposure by working directly with clients across the globe at various client locations as BI consultant and project lead.
• Strong analytical skills with ability to quickly understand client’s business needs.
• Extensively designed, created UNIX scripts (AIX Korn shell /Linux Bash shell, Crontab scheduler) based on Business requirements and involved in job scheduling, monitoring and production support in 24/7 environments.
• Performed Performance tuning in RDBMS sources by implementing SQL query over rides in Source qualifier transformation which reduced unwanted data processing thereby improving performance.
• Applied other performance tuning techniques such as reducing the number of transformations used in the mapping, performing joins at the source level (homogenous sources) instead of Joiner transformation etc.
• Worked closely with the Business Analyst, Data Modellers and Data warehouse Architects in determining the exact business rules and functionalities required for the delivery of the work articles.
• Worked closely with Data Architect to review all the conceptual, logical and physical database design models with respect to functions, definition, maintenance review and support Data analysis, Data Quality and ETL design that feeds the logical data models.
• Experience in Informatica MDM - data cleansing, Address correction, trust and validation rules, match column, match rules, merge properties and batch group creation.
• Knowledge on implementing hierarchies, relationships types, packages and profiles for hierarchy management in MDM Hub implementation.
• Experience in Dimensional Data Modelling (Kimball, Star Schema, Snow -flake Schema, FACT and Dimension tables), Logical and Physical Data Modelling using Erwin 4.1/4.0/3.5 and Oracle Designer.
• Excellent communication, interpersonal, analytical and presentation skills. Flexible to adopt any working environment.
• Experience in comprehensive data Quality implementation using Informatica Data Quality (Informatica Developer and Informatica Analyst) through implementing Address Validation, Name Standardization, Model Profiling & Technical/Business Data Quality rules.
• BI and Analytics experience using IBM Cognos sBusiness Intelligence tool. Developed Reports (Interactive/Active), Dashboards in Reports Studio; Adhoc reporting and Data Discovery in Query/Analysis Studio.

TECHNICAL SKILLS:

ETL: Informatica PowerCenter 9.1/8.6 (Repository Manager, Designer, Server manager, Work Flow Monitor, Work Flow Manager), Informatica MDM, Data mart, ETL, OLTP, OLAP

EIM: Informatica Data Quality 9.x/Informatica Data Explorer, Informatica MDM 9.x

BI & Reporting: IBM Cognos 9.5, Cognos Analytics, CIS composite, Query Studio (Workspace Advanced)

Databases: Oracle 11g/10g/9i, IBM DB2, MS SQL Server 2012/ 2008/ 2005 SQL*Loader, Teradata, Quest TOAD.

Environment: Windows Server 2012/2008/2003 , Windows 7/8.1, AIX, Linux

Scheduling tools: Informatica Scheduler, Crontab, Automate

PROFESSIONAL EXPERIENCE:

Confidential

Project Lead

Responsibilities:

• Participate in requirement gathering and provide technical solutions for business need.
• Co-ordinate with business analysts to create work packages for various releases
• Ensured that all related projects cooperate and coordinate with the BI program team.
• Act as senior liaisons between the program and all potential business areas that may use the business intelligence.
• Coordinate development schedule, activities and staff across all project teams.
• Defines the organizational structure including roles, responsibilities, accountabilities and authorities.
• Direct and support the project teams in the use of the selected tools and architectures, providing continuity and consistency across projects.
• Allocate and re-direct resources.
• Prioritize BI releases.

Environment: Informatica 9.6, DB artisan, IBM DB2, CIS composite, unix, qlikview

Confidential

ETL Lead

Responsibilities:

• Participate in the full lifecycle of ETL software development - analysis, design, build, documentation and testing.
• Motivated and guided the team to attain project objectives and thereby achieving milestones.
• Develop technical designs, build Informatica/OWB workflows and create mappings, stored procedures, functions, materialized views, triggers and clearly document the process.
• Experience in Performance Tuning ETL processes with ability to maximize data flow and minimize time and hardware resources.
• Experience in database design, entity-relationship modelling and dimensional modelling.
• Develop and deploy ETL workflows and mappings with reliable error/exception handling and rollback framework
• Create and execute unit tests on all solutions, work with Data analysts and QA engineers to ensure product and integrations tests are complete.
• Work with both the project and support teams to understand existing systems and to help troubleshoot, optimize, and tune ETL processes as needed.
• Guide and mentor the team in technical areas, so as to help them in designing complex queries.
• Carry out and review important technical documents, designs, technical reviews of code and test plans created by team members.
• Worked with client to create technical design document and assisted them to get approval.
• Assist in UAT and production implementation.
• Share technical knowledge among the team and across the Business unit in the organization.
• Build strong relationships with the peers, analysts, technical and business leads through delivery, communication and development of domain knowledge
• Perform unit testing, system integration testing and assist the business analysts with user acceptance testing.
• Implement Informatica MDM workflow, including data profiling, configuration specification and coding, match rules tuning, migration
• Developed the mappings using various cleanse functions in the Hub and the address doctor to standardize the data
• Build out best practices regarding data staging, data cleansing, and data transformation routines within Informatica MDM solution
• Develop and in corporate ETL best practices and standards
• Take responsibility and ownership for the analysis, design, coding, testing and status reporting of a work product.
• Provide input on technical effort estimation to arrive at resourcing plans.
• Engage in peer reviews during design, coding and testing.
• Prepare implementation plans, delivery report and deployment checklist when moving code to production.
• Prepare defect correction plan by performing the defect causal analysis for every release, which has helped the team to deliver future releases with reduced defects.
• Prepare and track monthly metrics for BI team.
• Create various service improvement plan (SIP’s) which in turn generate additional revenue to the organization.
• Propose new areas for effective business which results in major CR’s thereby increasing team size.

Environment: Informatica 9.6, Toad, Oracle PL/SQL, Oracle Warehouse Builder 9i/10g, Oracle APEX.Java 6.

Confidential

ETL Lead

Responsibilities:

• Guided the team members to developed maps to perform ETL for stocks flow using data stage tool
• Reviewed and corrected the technical design document
• Created unit testing document to verify all transformations are developed as per technical design
• Created shell scripts to automate/schedule data stage jobs.
• Have done forward engineering to create tables in database required to develop the flow.

Environment: Datastage 11.0, SQL developer and Oracle PL/SQL.

Confidential

Module Lead / ETL Developer

Responsibilities:

• Reviewed the existing DW processes implemented for UCS and analysed the sources data to create requirement document to perform ETL.
• Reviewedthe business functionality of contracts module based on the functional specification document and explained the same to the team members.
• Involved in workshop for understanding the Full load and Partial load concepts for the existing UCS system.
• Have proposed changes to the existing design, identified the gaps in the existing system and provided relevant documentation to convince the design team to follow a simpler approach and a result oriented one.
• Created Mappings and process flows using Oracle Warehouse Builder (OWB) for loading the data into the staging area and perform cleansing of the data for further processing. Applied business logic for transformation of data.
• Was responsible for contracts and commission module which covers 80% of the complex business logic involved in CETELEM.
• Extensively involved during System Integration Testing (SIT).
• Created vigorous unit test cases to cover all the functionality involved in these two modules and ensured a successful UAT with no priority one defect.
• Involved in technical documentation of the entire process along with analysis and design of the functional specification documents.
• Engaged in peer reviews during design, coding and testing.

Environment: Oracle Warehouse Builder, SQL developer and Oracle PL/SQL

Confidential

PL/SQL Developer

Responsibilities:

• Involved in analysis of the source systems and proposing formats for source data.
• Developed PL/SQL procedures based on complex business logic for Data Migration.
• Extensively involved during System Integration Testing (SIT) and User Acceptance Testing (UAT) execution.
• Involved in analysing defects and provided data correction scripts if necessary.
• Leveraged performance tuning techniques such as cost based SQL tuning, dropped indexes and re-created them after loading data to targets and enhanced several Oracle database objects to use PL/SQL collections.
• Involved in Technical documentation of the entire process.
• Responsible for creating the execution check list for major modules.
• Analysis and Design of the Functional Specification Documents.
• Was responsible for setting up test environment and facilitating testing team for every build release.
• Worked closely with the client and resolved the queries raised by offshore team.
• Involved in the successful implementation of the entire data migration at the Client place.
• Provided direction to offshore team for post go live support.
• Coordinated with various vendors and execution managers during the go-live phase.

Environment: Oracle 9i, PL/SQL, Java 5

Confidential

ETL Developer

Responsibilities:

• Scheduled jobs in Automate tool to get the file from FTP and load them into appropriate servers.
• Mapped and populated data into staging, ODS and data marts using Pervasive tool.
• Created stored procedures, functions, packages and triggers to populate data into CDR.
• Prepared unit test cases to test mapping with complex business functionality.
• Configured runtime assistant manager to organize maps into appropriate modules and to run them in parallel and sequential order based on business requirement.
• Used the transformations like lookup, filter, aggregator, joiner, de-duplicator, splitter, merger, set operator, pre-map process, post-map process and expressions in the development of data stage jobs.
• Used runtime assistant manager for running, monitoring and scheduling the jobs.
• Performed troubleshooting and debugging of new and existing ETL solutions.
• Performed analysis, design, and implementation of new subject areas into the project environment.
• Complied with the development standards while performing complex system analysis and design.
• Created, reviewed, maintained and tested ETLs based on design document.
• Created effective error handling mechanism.
• Consistently delivered build without any schedule slippage.

Environment: Automate, Pervasive, Toad and Oracle PL/SQL

Confidential

Data Modeller

Responsibilities:

• Coordinated with the Business Analyst team and understand the application’s business requirement
• Created ER Model for various flows of the application using Erwin Platinum.
• Created Subject area to group the ER modal based on functionality.
• Reverse/forward engineered existing schemas and created new data models and schemas for Oracle 9i database
• Created various environments for development and testing team.
• Created macro in Erwin Platinum tool for maintaining the naming conventions, which was applied at the time of Forward Engineering process.
• Created Traceability Matrix to find whether the requirements were met.
• Facilitated the testing team with database issue for every build release.
• Created complex views, synonyms, sequence, stored procedure, functions and triggers based on business need.
• Designed audit tables for effective logging and capturing crucial change in data.

Environment: Erwin Platinum3.x and Oracle PL/SQL