Post Job Free

Resume

Sign in

Manager Data

Location:
Brea, CA
Posted:
March 13, 2017

Contact this candidate

Resume:

Subba Rao K

E-Mail ID: acy9wt@r.postjobfree.com Mob: 443-***-****

Having 12+ years of IT experience in Analysis, Design, Development, Testing, Validation Lead Implementation and Support of Data Warehousing using Informatica Power Center.

Having 8 years of ETL Data warehousing experience using Informatica Power Center 9.x, 8.x, 7.x (Source Analyzer, Mapping Designer, Mapplet Designer, Transformations Designer, Warehouse Designer, Repository Manager, Workflow Manager and Workflow Monitor).

4 years of diversified experience in the Test/Validation Lead Platform level Regression Testing.

Test Estimation, Requirement Analysis, Test Approach design, Test Plan preparation, Review of Test Scenarios, Scripts, Traceability matrix and responsible for end to end test deliverables.

Proficiency in developing SQL with various relational databases like Oracle, SQL Server, DB2.

Worked on Full Life Cycle development of Data Warehousing.

Have extensively worked in developing ETL for supporting Data Extraction, transformations and loading using Informatica Power Center.

Knowledge on Erwin, Multi-Dimensional Database Schemas like Star schema and Snowflake schema (Fact Tables, Dimension Tables) and handling slowly Changing Dimensions.

Understand the business rules completely based on High Level document specifications and implements the data transformation methodologies.

Worked with documenting high level, low level design documents and worked very closely with the customers to collect the requirements and design functional and technical documents.

Extensively used informatica partitioning for the performance improvement of the sessions.

Created UNIX shell scripts to run the Informatica workflows and controlling the ETL flow.

Strong with relational database design concepts.

Extensively worked with Informatica performance tuning involving source level, target level, mapping and session level bottlenecks.

Metadata manager and repository queries for identifying the lineage analysis and object dependency analysis.

Code migration between the repositories.

Independently perform complex troubleshooting, root-cause analysis and solution development.

Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess good communication skills.

Team player, Motivated, able to grasp things quickly with analytical and problem solving skills.

Has extensive experience in Testing Web based and Client-Server Applications.

Comprehensive technical, oral, written and communicational skills.

Strong understanding in projects for banking and Finance, Insurance Surety, Sales Retail and Pharmatical domains.

TECHNICAL SKILLS:

ETL: Informatica Power Center 9.x,8.x,7.x Source Analyzer, Mapplet Designer, Mapping Designer, Workflow Manager, Workflow Monitor, Repository Manager, Metadata Manager.

Data modelling tools: Erwin 7.x, Microsoft Visio.

Types of Testing : Functional Testing, Validation Testing, Accessibility Testing.

Testing Tools : Quality Centre.

Operating Systems: Windows 2000/2003/NT/XP, UNIX (Sun Solaris, AIX).

Database: Oracle 11g/10g/9i, IBM DB2, SQL Server 2008/2005/2000.

Web Tools: Java, HTML, XML.

Languages: SQL, PL/SQL, C, C++.

Tools: TOAD, HPQC, Putty, SQL Developer and Edit Plus.

Certifications:

Internal

Certified from L&T Academy on Life Sciences, Validation and testing process.

Certified in banking domain level- 1.

External

Completed Certified Tester foundation Level ISTQB/BCS.

CONSULTING ASSIGNMENTS:

1. PROJECT NAME

WVO DBA Support. CA, USA, Dec 2015 to Present.

INDUSTRY

DATA WAREHOUSING

DOMAIN

T&H

CLIENT

WYNDHAM VACATION OWNERSHIP (WVO)

ROLE

ETL TECHNICAL CONSULTANT

PROJECT SPECIFIC SKILLS

INFORMATICA 9.X, UNIX, ORACLE 10G, SQL SERVER, TOAD, WINSCP.

DESCRIPTION:

Wyndham Vacation Ownership world’s largest developer and marketer of flexible, points-based vacation ownership products, WVO has developed or acquired more than 185 vacation ownership resorts throughout the United States, Canada, Mexico, the Caribbean and the South Pacific that represent more than 23,000 individual vacation ownership units WVO develops markets and sells vacation ownership interests and provides consumer financing to owners through its four primary consumer brands, CLUB WYNDHAM®, WorldMark by Wyndham, Wyndham Vacation Resorts Asia Pacific and Shell Vacations Club. As one of the world's largest hospitality companies, Wyndham offer individual consumers and business-to-business customers a broad suite of hospitality products and services across various accommodation alternatives and price ranges through their premier portfolio of world-renowned brands. Wyndham Worldwide is a leading provider of hospitality products and services across various accommodation alternatives and price ranges through its global portfolio of world-renowned brands.

ROLES AND RESPONSIBILITIES:

Used metadata Manager and Repository queries in identifying the data lineage flow and different informatica object dependencies and for efficient analysis of the existing tables and columns usage.

Identify the impacted Informatica code, Data base objects, Unix code and decommissioning them due to the application/feeds decommissioning.

Updating the schedule as per the coding changes due to application decommissioning.

Responsible for Identifying requirements, Analysis, Design, Development and Testing of power center Mappings and workflows.

Involved in performance tuning of mappings, transformations and sessions to optimize jobs/batch performance.

Identify the usage/transform logic of the columns in dropping them from the tables.

Involved in Fine tuning SQL overrides in Source Qualifier and Look-up SQL overrides for performance Enhancements.

Decommissioning the redundant data marts.

Decommissioning the data mart tables and replacing them with the views on the data warehouse table to optimize the batch load time and space.

Debugging and unit testing of mappings.

Support the code in the SIT and UAT environments for the different daily and monthly level scenarios.

Code migration from Dev to Test and Pre-prod environments.

Conducting Peer reviews.

Creating & Tracking reports related to all the Development, maintenance & Migration activities for the releases as per the release calendar.

Creating and Implementing the Change Requests for production code changes.

Coordinating and providing technical support to the team members.

2. PROJECT NAME

XA DW & ALGO Enhancements & Simplification, India, Nov 2013 to Dec 2015.

INDUSTRY

DATA WAREHOUSING

DOMAIN

INSURANCE – INVESTMENTS

CLIENT

ALLSTATE

ROLE

ETL TECHNICAL SPECIALIST

PROJECT SPECIFIC SKILLS

INFORMATICA 9X, TOAD, ORACLE 11G, UNIX.

DESCRIPTION:

The purpose of this project is to simplify the XA DW and ALGO by decommissioning (EOL) frond end investment interface applications and their interfaces. Involved in upgrading the Informatica, enterprise level OS upgrade (From UNIX to Linux) initiative. Also involved in new enhancements and maintenance requests to cater to changing needs of the business.

ROLES AND RESPONSIBILITIES:

Analyzing the existing data and its sources for the lineage analysis.

Analysis on the new feeds and existing ones in setting the data hierarchy in integrating the new source feeds into the DW.

Prepares the design documents from the business specifications.

Review the design documents.

Developed Complex mappings.

Debugging and unit testing of mappings.

Preparing Unit Test Plans for the tested mappings and support the code in the SIT and UAT environments for the different daily and monthly level scenarios.

Designing the stage tables for the new feeds.

Preparing the check in doc for code migration.

Conducting coding reviews and conform that they comply with the business rules.

Helps team in Analyzing and addressing the requirements.

Analysis on the existing mappings by analyzing the data flow, evaluating transformations and suggest the design changes to accommodate the new data feeds.

Used metadata Manager and Repository queries in identifying the data lineage flow and different informatica object dependencies and for efficient analysis of the existing tables and columns usage.

Changing the existing code to process the limited data by removing few types of data, since the new feeds will send the removed data types.

Analysis on the new feeds and existing ones in understanding and setting the batch dependencies in DW build process.

Coordinated and status calls with the Business teams, BSA’s and remote teams.

3. PROJECT NAME

United States Steel Corporation, India, May 2012 to Nov 2013.

INDUSTRY

DATA WAREHOUSING

DOMAIN

MANUFACTURING (EMS).

CLIENT

US STEEL.

ROLE

ETL CONSULTANT

PROJECT SPECIFIC SKILLS

INFORMATICA 9X, TOAD, ORACLE 10G, UNIX.

DESCRIPTION:

United States Steel Corporation is an integrated steel producer with major production operations in the United States, Canada and Central Europe and an annual raw steelmaking capability of 31.7 million net tons. The company manufactures a wide range of value-added steel sheet and tubular products for the automotive, appliance, container, industrial machinery, construction, and oil and gas industries.The Aim is to achieve the Ad Hoc querying capabilities that will be developed using the ETL tool by extracting the Source data from EBS (Oracle Apps), build the staging tables with the use of informatica Mappings and Load our DWH tables and build the reports as per the client requirements.

ROLES AND RESPONSIBILITIES:

Understood the existing Datawarehouse data flow in supporting the batch and in resolving the incidents.

Prompt in resolving the batch issues and incidents, to meet the defined SLA’s.

Preparing the required documentation for the existing code and processes.

Identify the issues in existing mappings by analyzing the data flow, evaluating transformations.

Identified the repeat incidents and provide the permanent fixes to these.

Created automated Data validation queries and exception reporting.

Used metadata Manager and Repository queries in identifying the data lineage flow and different Informatica object dependencies.

Used the debugger effectively in identifying the data flow issues in the mappings.

Preparing the SLA documents and status reports for the support and Enhancements activities.

Creates the design documents from the business specifications.

Review the design documents.

Designing the data models for new enhancements by confirming to the defined standards for the DW.

Developed Complex mappings for the Daily and Monthly loads of different data feeds.

Created Reusable transformations/process for identical data feeds/processes into the Datawarehouse.

Created reusable Transformations, Mapplets and Worklets for the code reusability.

Created the mapping and sessions and reused them for the similar data feeds to process the data into DW with help of Parameter files.

Created shared persistent lookup files for the better performance during the batch.

Used different performance improvement techniques for the reduction of the batch runtime.

Debugging and unit testing of mappings.

Preparing Unit Test Plans for the tested code and support the code in the SIT and UAT environments.

Created the Parallel/sequential workflows for the data process both for Intraday and nightly batch jobs.

Involved in performance tuning of mappings, transformations and sessions to optimize jobs performance.

Developed the Email tasks for the intraday jobs and batch status reporting notifications.

Code migration from Development to SIT, UAT and Pre prod environments.

Preparing the support documents and providing the Knowledge transition to the support team for the new enhancements and Work requests.

Preparing the check in doc for code migration.

Conducting coding reviews and conform that they comply with the business rules.

Using the repository metadata queries for easy and efficient analysis.

Coordinating and providing support to the offshore/Remote team.

4. PROJECT NAME

G&W Laboratories, India, Feb 2010 to Apr 2012.

INDUSTRY

DATA WAREHOUSING

DOMAIN

SALES

CLIENT

G&W.

ROLE

ETL DEVELOPER

PROJECT SPECIFIC SKILLS

INFORMATICA 8.X, ORACLE 10G, TOAD, UNIX

DESCRIPTION:

G&W Laboratories is implemented ETL to analyzer their Sales and Marketing Divisions to increase productivity, physician relationships, and decreased downtime and drive times, leading to higher employee and customer satisfaction and increased revenues. G&W Laboratory’s sales, marketing reporting and analysis activities are presently extracting data from several different systems.

ROLES AND RESPONSIBILITIES:

Used Oracle tables and Flat files as the targets, Source database is a combination of Flat files, Oracle tables.

Translated Business processes into Informatica mappings.

Developed Complex mappings and Mapplets to process the source data into the required Flat files in different hops.

Analyzing the existing mappings and incorporated the support changes in the development code as part of configuration management process for the releases.

Debugging and unit testing of mappings.

Preparing Unit Test Plans for the tested mappings.

Conducting Peer reviews.

Preparing the checkout doc for migration.

Used Informatica Workflow Manager for Creating the parallel/sequential flows, which will run in the batch at specified time or based on the dependencies.

Testing the data to check if they conform to the business rules.

Identified bugs in existing mappings by analyzing the data flow, evaluating transformations and fixing the bugs so that they conform to the business needs.

Coordinating and providing support to the offshore/Remote team.

5. PROJECT NAME

Osceola Sorter System, India. May 2009 to Feb 2010.

INDUSTRY

DATA WAREHOUSING

CLIENT

AMERICAN GREETINGS

ROLE

ETL DEVELOPER

PROJECT SPECIFIC SKILLS

INFORMATICA 7.1, UNIX, DB2, PUTTY, EDIT PLUS, WINSQL

DESCRIPTION:

American Greetings, Founded in 1906 is one of the world's largest publicly owned creator, manufacturer and distributor of social expression products. Headquartered in Cleveland, Ohio. American Greetings also manufactures and sells greeting cards, gift wrap, party goods, candles, balloons, stationery and giftware throughout the world, primarily in Canada, the United Kingdom, Mexico, Australia, New Zealand and South Africa American Greetings services approximately 70,000 retail stores in the United States and 125,000 worldwide.

The Osceola Sorter Automation Project will provide the capability to batch pick Seasonal counter cards by replacing the use of flow racks with sortation equipment for order filling. New applications and interfaces will be developed to manage DC (Distribution Center) Wave/Segment order filling information and communications with required sortation systems. It will introduce automated sortation technology that improves the performance of Osceola Distribution Center.

ROLES AND RESPONSIBILITIES:

Understanding the Business Processes

Analyzing the source data from DB2 and Flat Files.

Used DB2 as the target database, Source database is a combination of Flat files, DB2 tables.

Creating Move forms

Translated Business processes into Informatica mappings.

Developed mappings with Normalizer transformation for COBOL Sources.

Created and Scheduling Batches using workflow manager.

Debugging and unit testing of mappings.

Preparing Unit Test Plan, Unit Test Run and Checklist.

Conducting Peer reviews.

Testing the data to check if they conform to the business rules.

Providing Guidance to the team members.

6. PROJECT NAME

CNA Surety DW. India. Aug 2008 to May 2009.

INDUSTRY

DATA WAREHOUSING

DOMAIN

INSURANCE – SURETY

CLIENT

CNA SURETY

ROLE

ETL DEVELOPER

PROJECT SPECIFIC SKILLS

INFORMATICA 7.1, TOAD, UNIX, SQL SERVER, ORACLE 9I

DESCRIPTION:

CNA Surety – is a US based company, which is responsible for issuing surety bonds whereby, securing the public/government sectors from various risk factors. This company has various agencies tied up with them that will ask for bonds/securities for their clients. CNA Surety takes care of administration of bonds/securities on behalf of the public for a paid-up service.

CNA Surety’s DW and data Mart structures were optimized to address the business needs of modern financial institutions. The solution allowed organization to build data warehouse systems quickly, tailored to their individual requirements through the use of a tried and tested methodology. CNA Surety delivers an enterprise data warehouse in incremental steps driven by business requirements with each phase contributing visible business benefit.

ROLES AND RESPONSIBILITIES:

Understanding the Business Processes, transformation rules and design the mapping specifications.

Analyzing the source data from different databases.

Used Oracle 9i as the target database, Source database is a combination of Flat files, Oracle tables.

Translated Business processes into Informatica mappings.

Developed Complex mappings by extensively using Informatica.

Developed Informatica SCD type-I, Type-II mappings. Extensively used Expression, Aggregator, Sorter, Router, Filter, lookup, Stored Procedure, Update Strategy Transformations.

Developed Reusable Transformations and Mapplets.

Debugging and unit testing of mappings.

Creating Test cases and detailed documentation for Unit Test, System, Integration Test and UAT to check the data quality.

Developed Error handling by handling the data cleaning from the legacy sources.

Developed ODS with the most recent 3 months data for the reporting purpose.

Also developed PL/SQL to load the audit information of the Tables accessed.

Conducting Peer reviews using the code review check lists.

Created Email tasks to send the success/failure notifications.

7. PROJECT NAME

AZ Momentum, Mumbai, Feb 2007 to Jul- 2008.

INDUSTRY

QUALITY ENGINEERING ASSURANCE

DOMAIN

LIFE SCIENCES

CLIENT

ASTRA ZENECA

ROLE

SENIOR SOFTWARE ENGINEER

PROJECT SPECIFIC SKILLS

MANUAL.

DESCRIPTION:

Astra Zeneca is a world leading pharmaceutical company with a world-class biologics capability. They are active in over 100 countries with a growing presence in important emerging markets including China; corporate office in London, UK; major R&D sites in Sweden, the UK and the US. AZ Momentum is basically an Application Maintenance project that has three major support areas namely GDD, Dx and ISMO. Each area comprise of huge number of application, which mainly deals with drug discovery, pre-clinical trials, and marketing of drugs. Cognizant holds the responsibility of providing maintenance support (bug fixing, new enhancements etc.,) to all these applications.

ROLES AND RESPONSIBILITIES:

Involved in preparation of Test cases.

Involved in preparing Test data.

Performed Unit Testing

Coordinating the Onsite-Offshore interaction.

Defect logging and Tracking using the E-Tracker Tool.

Assure operational effectiveness through internal audits and reviews.

Manage quality and compliance risks and issues.

Validation Plan and Report preparation

Conduct reviews on deliverables ensuring adherence to the standards and procedures

Identify and implement improvements in Change Requests handling

Document Management and Archival

Ensure effective preparation for external and internal quality and compliance inspections.

Follow-ups on project tasks with offshore team/ project teams from validation deliverables

8. PROJECT NAME

Export Application Processing Tool, Mumbai, Jan 2006 to Feb 2007.

INDUSTRY

QUALITY ENGINEERING ASSURANCE

CLIENT

FREIGHT EXPEDITE COMPANY

ROLE

SOFTWARE ENGINEER

PROJECT SPECIFIC SKILLS

MANUAL

DESCRIPTION:

This project dealt with processing various applications and obtaining clearance from both Port as well as Customs for the export of the goods by an Exporter. The exporter needs to be authenticated by both Port and Customs. Various applications processed in for the smooth export of goods are Shipping Bill, Export Application and Export General Manifest.

ROLES AND RESPONSIBILITIES:

Active member in Build Acceptance testing Smoke Testing.

Drafting and executing Test Cases.

Assure operational effectiveness through internal audits and reviews.

Reviewing Test Cases written and Generated the Test Reports.

Active member in Regression Testing.

Ensure effective preparation for external and internal quality and compliance inspections.

Follow-ups on project tasks with offshore team/ project teams from validation deliverables.

9. PROJECT NAME

Minerva, Mumbai, Nov 2004 to Dec 2005.

INDUSTRY

QUALITY ENGINEERING ASSURANCE

CLIENT

GENERAL ELECTRONICS.

ROLE

SOFTWARE ENGINEER

PROJECT SPECIFIC SKILLS

MANUAL

DESCRIPTION:

Minerva is a Pan European initiative inside EEF to standardize the process of generating "Flow Deals". Flow deals covers 80% of the business inside EEF. In future Minerva will be used all across Europe for generating flow deals. A complete sale support system on the web that supports calculation, credit application, printing contract, portfolio information. Being a powerful enterprise application, Minerva performs multifarious functions, which range from: correct information about customers, precise calculations, and fast response to credit applications.

ROLES AND RESPONSIBILITIES:

Active member in Build Acceptance testing (Smoke Testing).

Drafting and executing Test Cases.

Manage quality and compliance risks and issues.

Reviewing Test Cases written and Generated the Test Reports

Responsible for logging defects in Test Director and verify them

As a Team lead responsible for Coordinating team, Preparing status report and Effort Estimation.

Prepared Communication plan and shared the same with client

Prepared daily, weekly status reports and Project metrics.

EDUCATION: Master of Science from Bharathidasan University, 2003, Tamilnadu.



Contact this candidate