Navaneeth M

16+ years of IT experience of designing, developing and implementing data solution for large scale business in the field of Business Intelligence. DWBI Team set up, plan and manage projects aligning business goals with technology solutions to drive process improvements, competitive advantage and bottom-line gains. Excellent communicator; leverage technical, business and financial acumen to communicate effectively with client executives and their respective teams.

Having knowledge in agile and waterfall project management methodologies. Known for ability to produce high-quality deliverables that meet timeline and budgetary targets. 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.

Associate Consultant - Tata Consultancy Services

(2016-05)

Technology Specialists - AXA group solutions

(2012-02 - 2016-03)

Programmer - Informatica - Adobe India Pvt Ltd

(2010-12 - 2012-01)

Adobe registered vendor Sunovaa Tech Pvt Ltd

Senior Analyst - IBM Global services

(2008-06 - 2010-11)

ETL Support Engineer - Accenture Services Ltd

(2005-02 - 2008-06)

ETL Designer / Business Analyst - LCH Clearnet

(2016-05)

Regulatory Reporting project. LCH were required to implement a suite of new regulatory requirements and apply to their National competent Authority for re authorization as an approved CCP. LCH group entities are regulated in a number of jurisdictions by a number of different regulators. EMIR and Dodd Frank are the primary regulations under which LCH operates.

• Liaise with business subject matter experts in analyzing business requirements and understand the various data sources.
• Map source data elements from various systems like T24, SWIFT and develop, test and support extraction, transformation and load processes.
• Apply business rules to the raw data and load it to the data repository.
• Design and develop the technical/functional specification for the ETL development and implement using Informatica. Analyze dependencies for workflow for various ETL processes, handle exception and maintain logs.
• Base lining different development, test environments, and come up with technical, low level design for the projects and coordinating with the other teams to collect design needs.
• Making specialized structured written papers based on the operative needs, able to identify gaps and introduce improvements to the processes in use by the team.
• Manage artifacts - versions, including code, documents, design models and test cases document.
• Responsible for the ETL architecture for the platform.
• Implement processes for project tracking and reporting, escalation, change control and quality management and documentations.
• Review the deliverables produced by the project team and secure acceptance from the clients.
• Preparation of the status reports to circulate to the various stake holders of the project

ETL Lead - Leading Asset management company

(2012-01 - 2015-02)

CFS - AUM project. 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.

• 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.

Senior ETL developer - Pfizer

(2008-03 - 2010-11)

Enhancement Projects. Worked on various small projects (New projects requirements) including Salesforce Automation project (SFDC or Veeva) where Pfizer transformed their US physician commercial operating model to become more customers centric while increasing Sales and marketing effectiveness, involving data migration from existing SFA application to SFDC and from SFDC to different other applications. Also worked on Massively Parallel Processing remediation project where Pfizer needed to replace near 'end of life' infrastructure with the latest with state-of-the-art Massively Parallel Processing (MPP) technology, involving migration of the US Commercial Pharmaceuticals Data Warehouse from the current technology/platform (Solaris – Oracle) to the MPP (Teradata) technology/platform.

• 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.
• 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

Production support specialist/Lead - WaMu (Washington Mutual card services)

(2005-02 - 2006-03)

NILE GOLDEN GATE project. 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 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.

• 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