Tupakula, Jagadish.

Email : adip14@r.postjobfree.com

Mobile : +91-819*******

CAREER OBJECTIVE:

Energetic, composed, and motivated ETL Developer with a passion for innovation and learning, having around 4 years of experience in ETL methodology for data transformation using Informatica PowerCenter.

PROFESSIONAL EXPERIENCE:

Organization Tata Consultancy Services Limited

Designation Systems Engineer

Experience 3 year 10 Months (February 2017 – till date) TECHNICAL SKILLS:

ETL Tools Informatica PowerCenter, Informatica Cloud & IBM Datastage Operating Systems UNIX, Windows

Languages SQL

Databases

Oracle, SQL Server,DB2, Aurora, Netezza

Scheduling Tools Control-M, Autosys

PROJECTS:

LFSC-98 – MPMS (Marketing Performance Measurement System) Domain Insurance

Client LFSC-98

Role Developer

Project Description The primary objective of the project is to maintain ETL cycles of the MPMS application and also working on small mods and enhancements on the existing jobs as per the business requirements. MPMS system processes customer and product data and assign corporate Performance Reporting Business rule. This provides the performance statistics of particular product and helps in decision making process. Responsibilities Held ● Enhancing Informatica jobs according to business requirements

● Worked on scripts required for Control M Scheduling and triggering Informatica jobs

● Monitoring the Informatica jobs and fixing the issues. LFSC-98– C3I (Cross Channel Customer Interaction)

Domain Insurance

Client LFSC-98

Role Developer

Project Description Cross Channel Customer Interaction (C3I) Framework provides a central collection point for Customer Interaction Data from different sources like call, ivr etc. Raw data provided by the vendor is processed and all the required transformations are done using DataStage and the processed data is stored in different independent systems or databases.

Technical Skills DataStage, Hadoop, Unix, SQL, Control-M . Responsibilities Held ● Enhancing DataStage jobs according to client requirements.

● Interact with clients and ensure that the work products and deliverables are of the high caliber to ensure client satisfaction.

● Worked on Unix shell scripts for triggering Datastage jobs

● Monitoring the datastage and hadoop jobs in Control-M and fixing the issues if any

● Worked on migrating the hadoop jobs from Biginsights to Hortonworks

● We have worked on setup of the jobs in dev and test environments in hortonworks

● Have also worked on preparing the statistics of cycles' runtime for analysis purposes

LFSC-98– PCM (Pricing Competitive Measure)

Domain Insurance

Client LFSC-98

Role Developer

Project Description The PCM (Pricing Competitive Measure) process has grown in scope for a decade. In that time, the feature and requirements have changed, but only one thing has been consistent, it falls prey to many anti-patterns like design by committee, Hard-code, Premature optimization etc. which ended up with the need to optimize the existing process flow and automate few manual processes.

Technical Skills Informatica, Unix, SQL, Control-M . Responsibilities Held ● Enhancing Informatica jobs for better performance.

● Analyze the manual processes and come up with the design for IT supported solution

● Worked on setting up the Development environment for entire PCM process

● Monitoring the Informatica jobs in Control-M and fixing the issues if any

● Setting up the control-M for newly created processes AmFam – BIC-Redesign (Business Intelligence Center - Redesign) Domain Insurance

Client AmFam

Role Developer

Project Description Complexity of BIC environment is increasing day by day due to ongoing operational integration, reporting & analytic data requirements. This has impacted BIC ability to consistently meet SLA’s of financial reporting/extracts. Month end processing’s are taking 6-7 days in general. It is expected to grow with future state rollouts / data volume increase. These challenges have been considered as key driver for BIC redesign project. Technical Skills Informatica Cloud, Unix, Aurora DB, Amazon S3. Responsibilities Held ● Reducing the number of mappings required for new data flow as compared to the existing data flow by reusing the mappings/ business logic which are common to both

analytical and business users.

● Worked on creating mappings in Informatica cloud to load data from Aurora DB to Amazon S3 and Amazon S3 to

Greenplum Database.

● Worked on data validation of daily and monthly load jobs as well as earnings and premiums tables in different databases.

● Monitoring the Informatica cloud mappings in production environment.

Farmers Insurance Group –Data Migration

Domain Insurance

Client FIG

Role Developer

Project Description Unstructured Data is growing faster than expected. It's time to enhance our views on how we see and store data. Guidewire exists to deliver the software that property and casualty insurers need to adapt and prosper in a time of rapid industrial change. Guidewire provides a single control plane for more efficient, support and observability. So, Farmers Insurance have come up with the idea to migrate its data from a legacy application - Siebel to the latest trend in Insurance sector - Guidewire Application with a brilliant UI.

Technical Skills Informatica PowerCenter, Oracle, Guidewire Application. Responsibilities Held ● Validated if the business logic is properly implemented through-out the flow.

● Have enhanced few mappings in Informatica as per client requirements and the mappings ran successfully loading required data. They are validated and moved to higher environments as well.

● Worked on defect fixes.

● Worked on SQL procedure modifications.

● Identified claims which are no longer required and performed cleanup activities using a purging tool Soap UI.

● Making sure code is properly deployed to all non-prod environments in each migration.

STRENGTHS:

● Quick learner and ability to work in and as a team

● Good motivator, enthusiastic and open to learn new ideas

● Possess good verbal and written communication skills ACADEMIC PROFILE:

COURSE INSTITUTION YEAR OF PASSING

B. Tech. (Mechanical Engineering) Gurukul Kangri

Vishwavidyalaya, Haridwar.

2012-2016

PERSONAL DETAILS:

Full Name Jagadish Chandra Prasad Tupakula

Date of Birth 7-Jul-1995

Languages Telugu, English, Hindi

Contact this candidate