Data Manager

Ranjith Pulluri

Mobile: +91-917******* Email: ****************@*****.***

Seeking a position as Informatica Professional in a reputed organization

Synopsis

Engineering Professional with 5 years of experience in Development, Maintenance and Production support in Informatica.

Currently working with United Health group of India Pvt ltd., as software engineer.

Working directly with the Clients regarding critical requirements.

An Out-of-the-Box Thinker, working towards continuous improvement in processes.

Worked independently on Many applications and provided many bright ideas to improve the system efficiency.

Excellent written & oral communication, inter-personal, and problem solving skills

Having experienced in working with informatica powercenter9.x and 10.x versions.

Experienced in informatica Advanced transformations like webservice transformation,XML Generator,Parser Transformation,MQ Transformation.

Having Experience in IBM Datastage 8.7 tool and able to do basic design and can understand the Code level in Datastage.

Technical Skill Set

Operating System : UNIX, Windows XP/7.

RDBMS : Oracle,DB2

ETL Tool : Informatica Power Center 9.x,10.x,Datastage

Monitoring Tool : TWS workload broker.

Career Highlights

Proficiency Forte

Extensively worked on data extraction, Transformation and loading data from various sources like DB2,Oracle and Flat files & Targes like Webservice Target,MQ Targets.

Strong skills in Data Requirement Analysis and Data Mapping for ETL processes.

Strong Data warehousing experience using Informatica Power Center 9x & 10.x.

Well versed in developing the SQL queries, unions and multiple table joins.

Well versed with UNIX Commands & able to write shell scripts and developed few scripts to reduce the manual intervention as part of Job Monitoring Automation Process .

Attainments

Received many awards in various recognition Programs for Excellence in Delivering High Quality work and commitment.

Received Monetary awards twice from senior management for proactive learning.

Received client appreciations for the deliverables delivered.

Project Details

Project : ICUE ETL - Integrated Clinical User Experience

Environment : Informatica 9.x & 10.x,Datastage, Oracle, UNIX, TWS (Batch). XL Deploy,

ITG Deployment Tool.

Period : Nov 2016 – Till Date.

Description:

ICUE is a collection of tools and capabilities, used by our internal clinical staff, which provides a consistent, intuitive, and flexible Integrated Clinical User Experience in the delivery of services for our members. We have many complex mappings here out of which few are Inbound jobs and few are Outbound jobs. Inbound job means it will take the file from many sources like ( Evisor,CDB,GOvtref,Cosmos etc.) and load them into MQ for further processing. ICUE Application is a java application and Java rules will read the data from MQ and load them into HSR tables.

Few jobs will act as Outbound jobs and they will extract the data from ICUE Application and transfer the files to the Downstreams.

Scope: Developed Informatica data feeds to pull the data from Flat files and Oracle tables coming from ICUE Application and store them into MQ,ICUE DB and into Files. Through Electronic customer Gateway, the files will be transferred to Downstreams.

Roles & Responsibilities:

Analyzed the Existing Datastage job design and Developed them into Informatica 10.1.1. This is Project is Completely Migration Project i.e from Datastage 8.7 Version to Informatica 10.1.1.

Having Good knowledge in Datastage also. Worked on few enhancements in Datastage and Deployed them into Production.

Worked with Power Center Designer tools in developing mappings and Mapplets to extract and load the data from flat files, Oracle (source) and loaded into target.

Used Informatica Power Center 9.x & 10.x for extraction, transformation and load (ETL) of data in the data warehouse.

Developed complex mappings in Informatica to load the data from various sources.

Developed few mappings with Webservice Transformation and loaded the flat file records into MQ through Webservice transformation and XML Generator Transformation.

Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.

Parameterized the mappings and increased the re-usability.

Used Informatica Power Center Workflow manager to create sessions, workflows and run with the logic embedded in the mappings.

Extensively used Informatica debugger to figure out the problems in mapping. Also involved in troubleshooting existing ETL bugs.

Created the ETL exception reports and validation reports after the data is loaded into the warehouse database.

Written documentation to describe program development, logic, coding, testing, changes and corrections.

Created Test cases for the mappings developed

Created reusable transformations and Mapplets and used them in complex mappings.

Analyzed Session log files to resolve errors in mapping and managed session configuration.

Involved in migrating the ETL mappings from development environment to testing environment.

Project : ECODS- Integrated Clinical User Experience

Environment : Informatica 9.x & 10.x, Oracle, UNIX, TWS (Batch).

Period : Feb 2016 – Till Date.

Description:

ICUE is a collection of tools and capabilities, used by our internal clinical staff, which provides a consistent, intuitive, and flexible Integrated Clinical User Experience in the delivery of services for our members. Source is ICUE web portal and we load data from web portal to STG_HSR and reporting team will pull data from there. Data for Government use will be loaded into TRE and data for commercial use will be loaded into ECODS.

We get some flat files as well where we create referral for them and send them back to ICUE and also load the data into temp tables.

Scope: Developed Informatica data feeds to pull the data from FLAT files and Oracle tables coming from ICUE Application and store them in ICUE DB and ECODS ICUE Application will pull the data from icue db.

Roles & Responsibilities:

Analyzed the business requirements and functional specifications.

Worked with Power Center Designer tools in developing mappings and Mapplets to extract and load the data from flat files, Oracle (source) and loaded into target.

Used Informatica Power Center 9.x & 10.x for extraction, transformation and load (ETL) of data in the data warehouse.

Developed complex mappings in Informatica to load the data from various sources.

Developed few mappings with Webservice Transformation and loaded the flat file records into MQ through Webservice transformation and XML Generator Transformation.

Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.

Parameterized the mappings and increased the re-usability.

Used Informatica Power Center Workflow manager to create sessions, workflows and run with the logic embedded in the mappings.

Extensively used Informatica debugger to figure out the problems in mapping. Also involved in troubleshooting existing ETL bugs.

Created the ETL exception reports and validation reports after the data is loaded into the warehouse database.

Written documentation to describe program development, logic, coding, testing, changes and corrections.

Created Test cases for the mappings developed

Created reusable transformations and Mapplets and used them in complex mappings.

Analyzed Session log files to resolve errors in mapping and managed session configuration.

Involved in migrating the ETL mappings from development environment to testing environment.

Project : BPS Advantage

Client : Edward Jones US, Edward Jones CA, Scotia, Credit Sussie, Cetera, Safra.

Environment : Informatica, DB2, UNIX, UC4 (Batch).

Period : APR 2013 – Jan 2016.

Description:

Project includes FBI (Frontend backend Integration) functionality, ANNUITY and GPS processing for clients RBC, WELLS, Edward Jones and ten more clients. This is the last and final and last downstream for all products which included in stocks and opted for it based on the CUSIP’s. Functionality includes both batch and real time processing and data will be transmitted through FBI to get it formatted into a client desired format and loaded into DB2 database servers.

Scope: Developed Informatica data feeds to pull the data from FLAT files and DB2 tables coming from many products such as TLE, DIVIDENDS, CAGE, PNS and Money manage Systems to DB2 server data store.

Roles & Responsibilities:

Analyzed the business requirements and functional specifications.

Worked with Power Center Designer tools in developing mappings and Mapplets to extract and load the data from flat files, DB2 (source) and loaded into target.

Used Informatica Power Center 9 for extraction, transformation and load (ETL) of data in the data warehouse.

Developed complex mappings in Informatica to load the data from various sources.

Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.

Parameterized the mappings and increased the re-usability.

Used Informatica Power Center Workflow manager to create sessions, workflows and run with the logic embedded in the mappings.

Extensively used Informatica debugger to figure out the problems in mapping. Also involved in troubleshooting existing ETL bugs.

Created the ETL exception reports and validation reports after the data is loaded into the warehouse database.

Written documentation to describe program development, logic, coding, testing, changes and corrections.

Created Test cases for the mappings developed

Created reusable transformations and Mapplets and used them in complex mappings.

Analyzed Session log files to resolve errors in mapping and managed session configuration.

Involved in migrating the ETL mappings from development environment to testing environment.

Academia

Completed B.Tech from Balaji Institute of Technology and Science, JNTU Hyderabad (Session: 2008-2012 with 80 %)

Completed Intermediate (12th) with 96 % marks in the year 2008.

Completed Matriculation (S.S.C Board) with 91 % marks in the year 2006

Personal Information

Name : Ranjith kumar Pulluri

Sex : male

Date of Birth : 10th Dec 1990

Nationality : Indian

Permanent Address : Flat No: 14-1-201/2, parvathnagar, borabonda

Borabanda – 500018.

I confirm that the information provided by me is truth to the best of my knowledge and belief.

Place: Hyderabad Ranjith Pulluri

Contact this candidate