Resume

Developer Designer

Location:

Pune, Maharashtra, India

Salary:

1400000

Posted:

March 28, 2020

Contact this candidate

Resume:

Harinandan Prasad Mailto: adcht4@r.postjobfree.com

Informatica Developer Phone: +91-886*******

TCS- Pune Address: Ganga Constella Apartment

www.linkedin.com/in/harinandan-prasad-9a506737 Kharadi, Pune-411014, Maharastra

Professional Summary:

Over 9+ years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).

Worked on Informatica Power Center tool 10.1.1, Data warehousing designer, Mapping & Mapplet Designer and Transformation Designer.

Performed the performance and tuning at source, Target levels using Indexes, Hints and Partitioning in ORACLE and Informatica.

Converted the PL/SQL Procedures to Informatica mappings and at the same time created procedures in the database level for optimum performance of the mappings.

Investigating and fixing the bugs occurred in the production environment and providing the on-call support.

Parsing high-level design specification to simple ETL coding along with mapping standards.

Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.

Created Shell Scripts for invoking SQL scripts and scheduled them using Control M tool.

Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

Technical Skills:

ETL Tool

Informatica PowerCenter 10.1.1, SSIS

Data Modeling

Physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snow-Flake, FACT, Dimensions), Entities, Attributes, Cardinality, ER Diagrams, OLTP, OLAP.

Databases

Oracle 11g/10g/9i/8i, MS SQL Server 2008/7.0

Languages

SQL, PL/SQL, Unix shell scripts, MDX

Job Scheduling

Control M

Environment

UNIX (HP-UX, AIX), Windows

Others

JIRA Tool, Service Now, BMC Remedy Tool, SSIS, SSAS, SSRS, WinScp, Beyond Compare, IBMOnDemand, Assentis, Temenos 24

Functional Knowledge

Banking & Finance, Utility, retail, manufacturing

Professional Experience:

Project Name: Credit Suisse, Saudi

Role: ETL Developer

Domain: Banking & Finance

Duration: 03/09/2019 to Present

Role & Responsibility:

Design, Develop and Test ETL Mappings, Mapplets, Workflows, Worklets using Informatica PowerCenter 10.1.1

Work in a fast paced environment, under minimal supervision providing technical guidance to the team members.

Working closely with Onshore and offshore application development leads.

Perform end to end Dress Rehearsal (DR) activity.

Working with SQL, PL/SQL procedures and functions, stored procedures and packages within the mappings.

Tuned Informatica mappings and sessions for optimum performance.

Tools using in current Project: Informatica Power Center 10x, Oracle 11g, SVN, Unix, WinScp, IBMoD, Assentis, Beyond Compare, Control M, T24, WM.

Project Name: EDF Energy, UK

Role: Technical Lead

Domain: Energy and Utilities

Duration: 01/04/2017 to 31/08/2019

Role & Responsibility:

Responsible for the day-to-day maintenance of the application systems in operation, including tasks related to identifying and troubleshooting application issues and issues resolution or escalation.

I have excellent skills in ITIL Processes and Functions. Good Knowledge on Incident, Problem, knowledge and Project Management. Thoroughly experienced in Team coordination, Customer interaction, Business Analysis, Asset Creation and Process improvement.

Effective reporting and presentation skills. SLA/KPI preparation and presentation .

Good Business analysis skills in both functional and domain knowledge analysis.

Responsibilities also include root cause analysis, management communication and client relationship management in partnership with Infrastructure Service Support team members.

Ensures all production changes are made in accordance with life-cycle methodology and risk guidelines.

Responsible for coaching and mentoring less experienced team members and or acting as a subject matter expert.

In depth Functional knowledge of the application(s) supported and inter-dependencies.

Tool/software used in this project are:-

Oracle and Sql/Server database

Proclarity for Cube reporting tool

UNIX, WinScp

Toad for Oracle

Control-M tool for job monitoring.

RDBMS, Data modeling (Fact/Dimension)

SQL, PL/SQL

Project Name: General Electric, USA

Role: ETL Developer

Domain: Energy and Utilities

Duration: 01/04/2013 to 31/03/2017

Role Responsibilities

Worked on Informatica Power Center tool, Data warehousing designer, Mapping & Mapplet Designer and Transformation Designer.

Responsible for all activities related to the development, implementation and support of ETL processes for large scale data warehouses using Informatica Power Center.

Extensively worked on data extraction, Transformation and loading data from various sources.

Worked with SQL, PL/SQL procedures and functions, stored procedures and packages within the mappings.

Tuned Informatica mappings and sessions for optimum performance.

Developed mappings that perform Extraction, Transformation and load of source data into Derived Masters schema using various power center transformations like Source Qualifier, Aggregator, Filter, Router, Sequence Generator, look up, Rank, Joiner, Expression, Stored Procedure, SQL, Normalizer and update strategy to meet business logic in the mappings.

Applied slowly changing dimensions like Type 1 and 2 effectively to handle the delta Loads.

Coordinated with testing team to make testing team understand Business and transformation rules being used throughout ETL process.

Project Name: Corus Group PLC

Role: ETL Developer

Domain: Industry

Duration: 20/12/2010 to 31/03/2013

Role Responsibilities

Prepared technical design/specifications for data Extraction, Transformation and Loading.

Worked on Informatica Utilities Source Analyzer, warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.

Used various transformations like Stored Procedure, Connected and Unconnected lookups, Update Strategy, Filter transformation, Joiner transformations to implement complex business logic.

Created Informatica Mappings to build business rules to load data using transformations like Source Qualifier, Aggregator, Expression, Joiner, Connected and Unconnected lookups, Filters and Sequence, External Procedure, Router and Update strategy.

Involved in debugging Informatica mappings, testing of Stored Procedures and Functions, Performance and Unit testing of Informatica Sessions, Batches and Target Data.

Good understanding of source to target data mapping and Business rules associated with the ETL processes.

Total IT Experience Details

TCS Experience

9 YEAR(S), 01 MONTH(S)

Prev. Experience

0 YEAR(S), 00 MONTH(S)

Total Experience

9 YEAR(S), 01 MONTH(S)

Education Summary

Degree

Subject

Score

Year

BTECH

ECE

78 %

2010

12th

Science

72 %

2005

10th

General

85 %

2003

Certifications

Title

Version

Acquired On

Expires On

Lean Six Sigma Green Belt

1.0

30/01/2014

Award Details

Title