Manager Data

SUMMARY:

*.* Years of experience into DWH/Business Analytics Solutions and optimization space on Pre and Post Sales of Storage/Back up Applications and Devices.

Experience in Business Analytics of Professional Services, Product, Services, Sales Booking, Enterprise Booking, ERP Booking, Invoice, Shipment and Revenue of Storage devices / Storage,Back up Applications.

Experience in Commission Extract.

Over 6 years of experience with ETL tool Informatica PowerCenter 8.6/7.2,Oracle,MQC.

Extensive working experience on RPD development Physical Layer/Business Model and presentation layers.

Experience in interacting with Business Users / Business System Analysts to understand the business requirements and transform the business requirements into technical requirements.

Experienced in creation of high level design, detail design, unit test documents, and traceability matrix based on business/technical requirements.

Proficient in QA Methodologies different phases of Testing like, Integration Testing, System Testing.

Experienced in Technical & Managerial aspects like preparation of Project Related documents like Test plan, Test Approach Document, Test Exit Report, DSR(Daily Status Report),DTER(Daily Test Execution Report),CR (change Request) status Reports and providing Test Estimation for the projects

Creation and execution of detailed test cases to verify software functionality and adherence to business requirements.

Expertise in Backend Database testing of Oracle using SQL.

Excellent interpersonal, project management, communication and documentation skills

As a QA Analyst, proven analytical and problem-solving skills

Good exposure of Quality Centre(MQC)

Proficient in the development of ETL (Extract, Transform, Load) processes with a good understanding of source to target data mapping, ability to define, capture Meta data and Business rules.

Familiar with relational and dimensional modelling.

Well versed with star and snow flake schemas.

Experience in Performance Tuning and Debugging of existing ETL processes.

Experience in developing Test Plans, Test Strategies and Test Cases for Data Warehousing projects ensuring the data meets the business requirements.

Involved in knowledge sharing and knowledge transfer to the new members of the project & Preparation of knowledge transfer documents.

Team player, motivated and dynamic with excellent oral and written communication skills.

EDUCATION:

Bachelor of Technology (Computer Science and Information Technology) from JNTUniversity, Hyderabad.

PROFESSIONAL EXPERIENCE:

HCL TECHNOLOGIES LTD Feb’2014 –Till Date.

SYNOVA INNOVATIVE TECHNOLOGIES Nov 2009-Feb 2014.

HCL TECHNOLOGIES LTD Dec 06 THRU Jul 08.

NetApp (Nov’09 –Feb’14)

Sunny Vale, United States

ETL Testing

NetApp creates products and services that store, manage, and retain electronic data. NetApp has different business verticals like Sales, Marketing and Finance. Sales data exists in different source systems like Siebel, ERP and Oracle. The main object of this project is to extract the data from these source systems and load into Enterprise Data Warehouse and updating commission extract.

Technical Task:

PM/BI Project Requirement Analysis & Knowledge gathering

SQL preparation for PM/BI projects

Preparing the test data to enter into the source database(Oracle)

To run the workflow from Workflow manager and ensure that target data is getting loaded properly in desired target database(Oracle)

Validation of Historical/Initial/Incremental load and Business Objects reports

Database validation in Oracle using SQL queries

Knowledge Sharing Sessions on DWH/SQL Concepts

Attended meetings with the SME and Development team to gather and discuss the functional and system requirements

Reporting Task:

QA Effort estimations issued based on requirement Analysis from Business Requirements & High Level Design.

Interaction with Client on regular Deliverables & Status update on QA activities.

Designing Test Approach for BI & finalizing the Test Design Techniques. Also co-ordination for Test Data Setup.

Review of Test Design, SQL Queries & Test Results performed by Team on BI & PM

Supporting Team in building complex queries & clarifying on Requirements & Design Specs.

Status Calls with Client & Onsite Team

Handling Dev-Test call to detail about the Test Approach followed to satisfy requirements.

Environment Data stage, Oracle 9i, OBIEE, Windows XP, QUEST Toad, MQC

DSG INTERNATIONAL PLC (Jul’07 - Aug’08)

UNITED KINGDOM

ETL Developer

DSG INTERNATIONAL PLC has implemented a centralized data warehouse (CDW) on Oracle 9i, from different source systems. The bank has taken an initiative to finish the loads within the window time so that data will be available within time in Data marts for analysis and decision-making purposes. The data warehouse built will serve as a firm foundation for Business Intelligence and Data Analytics subsequently.

Responsibilities:

Extensively used Informatica Client Tools -- Source Analyzer, Warehouse Designer, Transformation Developer, Mapping Designer, and Mapplet Designer to develop mappings.

Used designer debugger to test the data flow and fix the mappings.

Performed Data Extractions, Data Transformations, Data Loading, Data Conversions and Data Analysis.

Creating batches and sessions and optimizing the loading process with partitioning and caching.

Developed workflows and tasks using Informatica PowerCenter Work flow Manager.

Documented the purpose of mapping so as to facilitate the personnel to understand the process and incorporate the changes when necessary.

Used Informatica Version Control for checking in all versions of the objects used in creating the mappings, workflows to keep track of the changes in the development, test and production environment.

BRITISH TELECOM (Dec ’06 – Jul 07)

UNITED KINGDOM

ETL Developer

BRITISH TELECOM is one of the largest telecommunications companies in the world. They offer communications products and services ranging from high speed Internet access, wireless, advanced IP and networking solutions, home entertainment and local and long distance service. BRITISH TELECOM has many accounts in which BPAS is one of the accounts. BPAS has many business requirements for both external and internal data feeds.

I was working in Data Mart Team of the BRITISH TELECOM project as an ETL developer. Data Mart team generates report about total number of subscribers, How many cancel, disconnect happened and many more.

Responsibilities:

Understanding the SR and BR and Preparing the LLD based on JIA.

Designing the LLD ETL Design spec.

Developed Informatica Power Center mappings using transformations such as the Source qualifier, Aggregator, Expression, lookup, Filter, Router, Rank, Sequence Generator, and Update Strategy.

Developed complex mappings to implement type 2 slowly changing dimensions using transformations such as the Source qualifier, Joiner, Aggregator, Expression, Connected Lookup, Unconnected Lookup, Filter, Router, Union, Normalizer, Sequence Generator, and Update Strategy.

Developed Informatica workflows and sessions associated with the mappings using Workflow Manager.

Creating .Job files using UNIX scripting for all the workflows.

Carry out Review and Unit testing for the mappings developed.

Fixing the defect from UAT and production, if any.

Giving support to the production team on deployment of new code in production.

Performance Testing.

Checking In the code into harvest whenever code has to move from Dev. to test/Pre-Prod/Prod for versioning.

Creation of weekly status report.

Environment: Informatica Power Center 7.2 (Designer, Workflow Manager, Workflow Monitor), Oracle 9i, Windows XP, UNIX, Toad 8.6.

Environment: Informatica Power Center 7.2 (Designer, Workflow Manager, Workflow Monitor, Repository Manager), Informatica Power Connect, Oracle 8i, UNIX, TOAD (Tool for Oracle Application Developer).

Contact this candidate