Senior Software Engineer
Mastech
Total years of experience :16 years, 6 Months
• Creation of mapping specifications in Informatica Analyst 9.6.1
• Development of ETL using Informatica Power Center 9.6.1
• Informatica Metadata Manager 9.6.1 resource setup
• Designing validation scripts and ETL for automating the data validation process
• Building SSAS cubes for analytical reporting
Installation and configuration of Finance, Projects, Human Resources, Procurement and Spend Analytics 7.9.6.4 OBIA modules
Create detail design, work on development and perform code reviews, implement validation and support activities in line with architecture requirements
Participate in detail requirement analysis and knowledge management activities with the objective of ensuring the highest levels of service offerings to customers
This project is an extension to the Oracle R12 transformation happening at JCP. The finance data from Oracle Applications is extracted, transformed and loaded to the financial data warehouse residing in DB2 using Informatica 9.1 which is organized, managed and monitored with a centralized console, DAC (Data Warehouse Administration Console).
Responsibilities: Onsite offshore coordination
Development and testing on DAC for Financial Analytics, Project Analytics and
Procurement & Spend Analytics
Environment: Informatica 9.1.0, Data Warehouse
Administration Console (DAC) 10.1.3.4.1,
OBIEE, Oracle 11g, DB2 v9.7, AIX 6.1, WinScp, Putty
The project was implemented in order to migrate accounts and customers of Applied Biosystems to Life Technologies from SAP to JD Edwards after its merger with Invitrogen.
Responsibilities : Onsite offshore coordination
Requirements gathering
High level design
Production implementation
JD Edwards Enterprise One table conversion
Environment : Informatica 8.6.1, Oracle 10g, WinScp, Putty
The project was implemented to migrate the database from Oracle to Netezza in order to make reporting database available earlier and response faster.
Responsibilities: Analysis of dependencies and replicating the data model in Netezza
Environment: Informatica 8.1.1, 8.6.1, Oracle 10g, Netezza, Business Objects, WinScp, Putty, Toad
The client was sponsoring the reality show "X-Factor" and offering free votes to its customers on a weekly basis. The customer details and voting details from various source systems were captured and reports generated for identifying the customers who exceeded the limit of free votes.
Responsibilities: Design, Development, testing and implementation of the project
Environment: Informatica 8.1.1, Oracle 10g, WinScp, Putty, Business Objects
The project was implemented to optimize the database by eliminating redundant data and database Tuning.
Responsibilities : Analysis of Teradata BTEQ scripts and implementation of solution for eliminating redundant data as well as handling rejections of data at database
Environment : Teradata, Datastage, WinScp, Putty
Campaign management was delivered to each of the European markets, enabling campaign execution, tracking and reporting through a single tool Epiphany. The project was to be executed in 3 different phases under different subtitles. The requirement involved redesigning a data mart called SCV (single customer view).
Prospect Countries and Company - The objective of the phase was to store prospect information into epiphany and upstream systems after de duplication for seven different countries.
Network Data Load - This project aimed at capturing the network data from third party vendors and processing the information to a central repository.
Upload of Cleansed Data - The objective of this project was to cleanse the data for four different countries which in turn would be reflected in downstream systems.
Responsibilities : Design, Development, testing and implementation of the project
Environment : Informatica 8.1.1, Oracle 10g, WinScp, Putty, Epiphany
Bachelor of Technology in Electrical & Electronics Engineering from Mahatma Gandhi University, Kerala, India (Year 2007)