Project Data

Navaneeth M

Email: ************@*****.***

Mobile: +91 – 988-***-****

Career Objective

Seeking a challenging position in a professional organization that optimally utilizes my technical and communication skills on a mutually beneficial and long-term basis

Professional Experience

AXA group solutions: Working as Technology Specialists from Jan 2012 to till date.

Adobe India Pvt Ltd: Worked as Programmer - Informatica for Sunovaa Tech Pvt Ltd

( Adobe registered vendor) from Dec 2010 to Jan 2012.

IBM Global services : Worked as Senior Analyst for from June2008 to Nov 2010.

Accenture Services Ltd :Worked as ETL Developer from Feb 2005 to June2008

Skills

Business Intelligence Informatica 7.x/8.x/9.1/9.5, UNIX Shell scripting, Salesforce.com (SFDC)

Big Data ecosystem: Hadoop – HDFS, Map reduce, Hbase, Pig, Hive, Flume,HBase (NoSql)

Domain Banking, Investment Management and Health care

Database Oracle, Teradata, MS Sql server

Version Control PVCS, VSS and SVN (subversion)

Scheduling Autosys, Control - M

Job Functions Development, Requirement gathering, Design, Testing, Documentation, Maintenance and Application Support.

Profile:

10+ years of experience in Data Warehouse/Data Mart design/development, mapping, extraction, migration, data validation and administration of various Enterprise Solutions

DWBI Team set up and working with authority to align team for short term and long term plans.

Delivery responsibility in the early fast paced classified information

Worked on proof-of-concept to demonstrate effectiveness of Hadoop ecosystem / Big Data systems including descriptive and prescriptive analytic systems.

Expertise in data warehouse ETL Design and ETL process handling.

Involved in the complete project cycle which included Requirement gathering, Create functional specs, Develop detail design, Build Create Unit Test plan and test cases, Create deployment and Change control documents.

Hands on experience on Integrating Informatica with Salesforce data

Experienced in interacting with business users, business analysts, IT leads and developers in analyzing business requirements and translating requirements into functional and technical design specifications.

Experience in developing and tuning Informatica codes, writing PL/SQL codes like stored procedures, triggers, functions, using Oracle 11g new features like virtual columns, Index organized tables, developing UNIX scripts, and Trouble shooting.

Well versed with administration of Informatica 7.1 for production systems.

Exposed to working in Agile Methodologies, onsite-offshore structure and effectively coordinated tasks between onsite and offshore teams.

Professional Experience:

Project Name: CFS - AUM

Duration

Jan 2012 to Feb2015

Technology

Informatica 9.5, Oracle 11g and Unix Shell scripting

Project Abstract

Client : Leading Asset management company

Assets Under Management (AUM) of corporate financial system represents all managed and billable assets. The project involved supporting and maintaining various applications of AUM reporting group by migrating all the systems from legacy environment into ODS and thereby improve accuracy and completeness of AUM Reporting.

Role

ETL Lead

Responsibilities

Interact with client or stake holders to gather requirement.

Analyze, Design, develop and implementation of ETL codes designed for flexibility, expandability and ease of maintenance.

Was involved in developing strategies of porting data across platforms, integrating data from various applications.

Worked on improving the existing system by performance tuning ETL codes, tuning PL/SQL codes to alleviate performance problems caused by large volume of data

Was involved in writing various shell scripts to perform health check or validate data quality of the system post data load.

Project Name: Enterprise Lead to Order (ELO)

Duration

Dec 2010 to Jan 2012

Technology

Informatica 8.6, Oracle 10g, Salesforcedotcom (SFDC) and Unix Shell scripting,

Project Abstract

client : Adobe

The ELO program aimed to consolidate all the sales platforms into a unified instance. To accomplish this, data from various source systems like SAP SFA, Omniture (SFDC), Scene 7 (SFDC) platforms would be migrated to Adobe SFDC Corp instance using informatica Cloud services (ICS), Standardized and de duped using Data Service tool, Transformed using Informatica Power center and finally synchronized back to Salesforce.com using ICS.

Role

Senior ETL developer

Responsibilities

Co-ordinate with the BSA’s in gathering functional requirements.

Develop detail Design document with complete breakdown of ETL tasks

Develop mappings/mapplets/worklets/workflows.

Analyse the data quality by interacting with the reporting team.

Perform Unit Testing and SIT.

Deploy the codes from DEV to TEST.

Project Name: Enhancement Projects

Duration

March 2009 to Nov 2010

Technology

Informatica 8.6, Oracle 9i, Teradata, Salesforcedotcom (SFDC) and Unix Shell scripting,

Project Abstract

client : Pfizer

Worked on various small projects (New projects requirements) like

Salesforce Automation project (SFDC or Veeva):

Pfizer is planning to transform their US physician commercial

operating model to become more customers centric while increasing

Sales and marketing effectiveness. To accomplish this, Pfizer has

Replaced the existing sales force tool with VEEVA which is built on top of Sales Force Dot Com (SFDC) platform. This project involves data migration from existing SFA application to SFDC and from SFDC to different other applications

Massively Parallel Processing remediation :

Pfizer need to replace near ‘end of life’ infrastructure with the latest with state-of-the-art Massively Parallel Processing (MPP) technology.

The objective of this project is to migrate the US Commercial Pharmaceuticals Data Warehouse (DW), aka US Data Management (DM) DW environment, and its data, marts, and associated processes (i.e., ETL, reporting, etc.) from the current technology/platform (i.e., Solaris – Oracle) to the MPP (Teradata ) technology/platform

.

Role

Senior ETL developer

Responsibilities

Co-ordinate with the Business Analyst in gathering functional requirements.

Develop detail Application Design document.

Impact analysis, gap analysis and retro fitment.

Develop mappings/mapplets/worklets/workflows.

Scheduling jobs using Autosys tool.

Perform Unit Testing and SIT.

Deploy the codes from DEV to TEST.

Project Name: S4 Transformation

Duration

Aug 2008 to Feb 2009

Technology

Informatica 8.5, Oracle 9i and Unix Shell scripting,

Project Abstract

client : Pfizer

The project involved development and support for all the customer i.e. prescriber information with regards to their complete details and cross referencing the different source systems from where the prescriber details are being sourced.

Worked on prescriber interaction module and for a major architectural re alignment of territories in US.

Worked with various transformations such as Lookup, Aggregator, Joiner, Expression, Router, Filter, Update Strategy, Stored procedure.

Created and Scheduled Workflows based on demand, run on time, run only once using Informatica Workflow Manager.

Execute test cases against the code and document results

Create deployment and change control documents

Review the code against design checklist

Project Name: NILE GOLDEN GATE

Duration

February 2005 to March 2006

Technology

Informatica 8.5, Oracle 9i

Unix Shell scripting, Unix Environment

Project Abstract

client : WaMu ( Washigton Mutual card services)

Credit Card - Maintenance Project:

Project involved the maintenance of various data marts of the clients and also managing the data that comes from various vendors from where the everyday data file gets generated and sent to our servers through an automated process. The project also involves extracting the data from the OLTP systems and Loading the data on to the data warehouse for managerial analysis by the management with the transformations as required by the business.

Role

Production support specialist/Lead

Responsibilities

Production Support involved managing the day to day operations/activities in the production environment and to ensure that the production activities are performed and controlled as required working under fixed and critical time lines, ensuring we meet all the deadlines specified.

Handled team of 9 members for support team

DM Production Support Analysis Reports generation wherein I had to Coordinate and conduct bi-weekly meetings to discuss and analyze DM production issues. Create, maintain, and analyze trouble ticket reports utilizing resources from the CSC FE002 database

Perform ticket trend analysis and documentation

Sox Audit Task reports to Validate that the specified Sarbanes-Oxley documentation is sent to the designated recipient in a timely manner.

Sox Audit Logs and Core tables report (Daily)

Weekly Health Check Review document (Monday)

Periodically update Communications Website.

Tickets And SLA Documentation

Review Outstanding tickets and Logging appropriate Comments

Contact this candidate