BHOOKYA NARESH

Phone: 810-***-****

Profile

I have a true passion for designing fitness and nutrition programs that maximize results and help clients develop a true sense of well-being. Bringing forth the ability to develop and implement winning business plans that lead to increased sales.

Total Years of Experience

4 Years 1 Month of Experience

Relevant Years of Experience in Informatica Power Center

4 Years 1 Month of Experience

Education

B. TECH, ACE ENGINEERING COLLEGE, GHATKESAR, TELANGANA

JUNE 2013 — MAY 2016

Graduated with 61.76% in ELECTRONICS AND COMMUNICATION ENGINEERING (ECE)

DIPLOMA.GOVT POLYTECHNIC COLLEGE, WARANGAL, TELANGANA

JUNE 2010 — APRIL 2013

Diploma with 73.13% in ELECTRONICS AND COMMUNICATION ENGINEERING (ECE)

Secondary Education, GOVT AIDED AVV HIGH SCHOOL, WARANGAL, TELANGANA

JUNE 2009 — MARCH 2010

Completed With 63.83%

Employment History

INFORMATICA DEVELOPER, SQL Server DBA

VALLEY INFOSYSTEMS PVT LTD

JULY 2019-PRESENT

Projects:

National Australia Bank:

National Australia Bank is one of the four largest financial institutions in Australia in terms of market capitalisation, earnings and customers. NAB was ranked 21st-largest bank in the world measured by market capitalisation and 52nd-largest bank in the world as measured by total assets in 2019. We have to load dimension tables from files that have got from the source system. We have loaded these files to the staging area, then to Dimension, and then to Fact Tables.

Roles and Responsibilities:

●Used Informatica PowerCenter 10.2.0 for extraction, transformation and load (ETL) of data in the data warehouse.

●Worked on Informatica Power Centre client tools like Source Analyser, Warehouse designer, Mapping designer, mapplet designer and Transformations Developer.

●Used Informatica PowerCenter Workflow manager to create sessions and workflows.

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

●Created various transformations such as Aggregator, Expression, Joiner, Filter, Router, Normalizer, Sequence Generator transformations.

●Creating workflows and sessions.

●Created mappings that involved implementation of Business Logic to load data into the staging area.

●Used Informatica Reusable concepts like Reusable Transformations, Mapplets, and Worklets at various levels of development.

●Experience in loading Various Dimension tables using SCD Type-1 & Type-2.

●Experience in Extracting the data using Incremental loading.

●Experience in working with Un-Connected lookups and Dynamic Lookups in Informatica

●Created Mapping parameters and variables using Informatica Parameterization.

●Tested the mapping to view data got populated according to specified logics in the technical specification document.

●To keep track of historical data slowly changing dimensions are implemented.

●Created and Monitored Batches and Sessions using Informatica Power Centre.

●Worked with Mapping Variables and Mapping Parameters.

●Checked the output according to the specifications

●Configured and ran the Debugger from within the Mapping Designer to troubleshoot the mapping before the normal run of the workflow.

●Experience in Dynamic File generation In Informatica

●Tuned several mappings for better performance and was involved in Performance Testing.

●Involved in Unit Testing.

●Worked on UNIX commands.

●Provide weekly status reports to the Project Manager and discuss issues related to quality and deadlines.

FarmFoods, UK

Farmfoods, a Scottish family business, has served Great Britain for over 60 years. From a butcher shop in Aberdeen, we have grown to more than 300 stores and four distribution centres nationwide. We work hard to bring you the best value on the food your family enjoys and on the household essentials your family needs. The objective of implementing the data warehouse is they want to analyse the business from 360-degree angles in the view of customer, claim and branch and seller, agent, etc.

Roles and Responsibilities:

●Created ETL mappings using Informatica PowerCenter to move Data from multiple sources like Flat files, Oracle into a common target area such as Staging, Data Warehouse and Data Marts.

●Developed different mappings by using different Transformations like Aggregator, Lookup, Expression, update Strategy, Joiner, Filter, Sorter, Union and Router etc. to load the data into staging tables and then to Dimension tables.

●Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent Sessions and scheduling them to run at specified time.

●Involved in performance tuning by optimizing the sources, targets, mappings and sessions.

●Created Mapplet and Re-usable Transformations for applying few logics.

●Created Connected, Un-Connected & Dynamic lookups (Cache).

●Worked on Versioning Concepts on Informatica PowerCenter.

●Implemented Incremental loading to from source to Stage.

●Implemented Scd Type-1 and Scd type-2 Mapping Logic to load to the dimension tables.

●Implanted Fact load Mapping.

●Testing of the existing Informatica workflows/mappings, Fix the bugs.

●Configuring the Databases connections in Informatica.

●Monitoring the Informatica jobs and Troubleshooting.

●Used Informatica Power Center Workflow manager to create sessions, Tasks and workflows.

●Verifying the data in target database after ETL process.

●Performed column data mapping between source & target database.

●Monitored transformation processes using Informatica Workflow monitor.

●Identified and fixed bottlenecks and tuned the complex Informatica mappings for better Performance.

●Used SQL tools like SQL Developer to run SQL queries and validate the data loaded into the target tables.

Extra-curricular activities

Reading Books

Film Making

Personal Details

Mother's Name: ERAMMA

Father's Name: SWAMY

Marital Status: Married

Details

ADDABATA THANDA, DEVUNITHANDA VILLEGE, NEKKONDA MANDAL, WARANGAL DIST,TELANGANA,506122, India

+91-810*******

ady90k@r.postjobfree.com

NATIONALITY

Indian

DATE OF BIRTH

15-DECEMBER-1994

Languages

Telugu

English

Hindi

Hobbies

Playing Cricket

Learning new skills

Contact this candidate