Candidates About

Information Technology professional with 10+ years of overall experience and experienced in Informatica 10.1 / Oracle / Denodo 6.0/ Teradata / J2EE

 

Hands-on, results-oriented professional with a pioneering career reflecting strong leadership skills coupled with Data ware Housing application and web application development and production Support, back end application development. Proven record in delivering simultaneous large-scale, mission critical Projects on time. Areas of expertise include:

 

Software development / Production Support / Team leadership /

Release Management / Process Improvement

 

 

v  Over 10+ years of total IT experience on Informatica Power Center 10.1, Data Virtualization tool: Denodo 5.5/6.0, Web-based applications on J2EE, Oracle 9i, Teradata 13.1, UNIX, Exadata.

v  5+ years of experience in Data Warehousing and ETL using Informatica Power Center 10.1(Workflow Designer, Workflow Manager, Workflow Monitor, Repository Manager, Informatica Metadata manager - IMM), Unix, Oracle , Teradata, Appworx.

v  3+ years of experience in J2EE (Casper, Struts, spring and Hibernate Frameworks) & Oracle.

v  3+years of experience in Denodo Data Virtualization 5.5,6.0  tool(Denodo VDP, Denodo Scheduler, JConsole, Diagnostic Monitoring tool)

v  Created Connections in Denodo VDP to connect to Oracle, Green plum, MS SQL, Excel Files.

v  Created Derived Views on top of the Base Views for the mentioned preceding Data Sources.

v  Implemented three layer architecture in Denodo as Connection, Combine& Integration and data consumption for downstream applications.

v  Created Denodo Cache for Derived views and refreshed the cache through Denodo Scheduler and trigger the mail communication for Success and Failure Notifications.

v  Implemented Full and Partial Cache in Denodo VDP using this cache for making joins and Unions as per downstream reporting requirement.

v  Created Derived Views on top of Base Views and accommodate the Business logics as per User requirement.

v  Implemented the Unions and Joins among the derived views to get the expected result.

v  Involved in Denodo Code deployment from Dev to QA and QA to Production.

v  Experience in working on different phases like Requirement Gathering, Development, Analysis, Documentation, Testing, Migration Project, Production and Post Production support.

v  Involved in preparation of Requirement Traceability Matrix (RTM), Defect Report, and Weekly Status Reports.

v  Worked closely with Clients, Business Analysts, Data architects, Database Administrators, Developers and BI Reporting teams to ensure the ETL solution meets business requirement.

v  Experience in developing and maintaining software applications in Domain areas of GE Manufacturing, Energy, capital & Treasury.

v  Expertise in Data Warehousing, ETL design and development process using Informatica Power Center (Source Analyzer, Data Warehousing Designer, Mapping Designer, Mapplet, Transformations).

v  Having knowledge on Dimension modeling Star/Snowflake schemas, Dimensional Data modeling, Fact & Dimension tables, Physical & logical data modeling, SCD.

v  Experience with Data Extraction, Transformation and Loading (ETL) from different data sources like Oracle, MS SQL, Teradata, File System (Text Files, XML files, .csv) into a common analytical data model using Informatica Power Center 9.5 and 10.1.

v  Experience in handling Performance improvement. Well versed with database partitioning and Informatica mappings performance improvement using partitioning. Processed large volumes of data and large files.

v  Expertise in error handling, debugging and problem fixing in Informatica.

v  Informatica upgrade from 9.5 to 10.1

 

 

 

 

v  Mahindra Satyam Excellence Award.

v  Tech Mahindra Grand Salute Award.

v  Tech Mahindra ACE (Associate Excellence Award) Award from last 5 years.

v  Pat on Back.

v  Kudos in every Project handled till date.

 

v  Microsoft Certified System Administrator (MCSA).

v  Oracle Certified Associate (OCA).

v  Sun Certified Java Professional 5 (SCJP).

 

v  M.C.A(Master of Computer Applications, Sikkim Manipal University)                                                                            

v  B.S.C (Bachelor of Electronics, Andhra University, India)                                                         

v  Junior Diploma in French (Andhra University, India)

 

v  Programming languages: C, C++, Java 5, R-3.4, Python   

v  Web Technologies:  XML, XSLT, JSP, Java Script, Servlets, HTML, Spring and Hibernate.      

v  Scripting Language: Unix Shell Scripting and Perl          

v  Databases: Oracle 10g, TERADATA 13, Greenplum, Exadata, Netezza.

v  Virtualization Tools: Denodo 5.0/5.5/6.0

v  Development/ETL Tools & Utilities: Informatica 10.1, Teradata SQL Assistant, Toad, PGAdmin, SQL Developer, MS Office, WinSCP, Putty, Support Central(GE Product), MES, Kronos, MS Office 2010, Jenkins, Tortoise SVN, uDeploy, Aginity, R Studio 1.0, Anaconda, Postman

v  Scheduling Tools: Appworx, Unix Cron Jobs

v  Business Support Process Management : ITIL Process : Incident, Problem, Change Request, Requests (Hewlett Packard Service Desk 2.0(HPSD), HP QC, GE Service Now, Rally)

v  Operating Systems : Unix, Linux, Windows NT/2010/XP/98/2000

v  Trainings Attended : DB2, Informix, Salesforce.com, OBIEE, Denodo 6.0, Hadoop Bigdata, Machine Learning in R, Python

 

Nationwide Insurance, Dublin, OH.                                                              

Role: Denodo – Tech Lead Developer– Onsite

Project Start & End Date: Feb 19^th 2018 to till date

 

Project Description:

Nationwide Insurance is one of the large U.S. insurance and financial services companies based in Columbus, OH. Nationwide ranked#68 in the most recent Fortune 500 companies. Nationwide Financial Services (NFS), a component of the group, was partially floated on the New York Stock Exchange prior to being repurchased by Nationwide Mutual in 2009. It had owned the majority of NFS common stock since it had gone public in 1997.Natiwide has dozens of affiliated companies like (ALLIED General Agency Company, AMCO Insurance Company, Depositors Insurance Company, Scottsdale Insurance Company etc..). Nationwide does business in different products like Life Insurance, Banking, Retirement and Investments to Customers all-round the US. As part of the Project data is sourced from UD and TPP which are part of internal Nationwide applications and then based on the Business requirement we build the Views in DB/Denodo level and integrate them at Denodo and further we publish them via Rest Web services in JSON format to the Nationwide consumer applications so that Business team uses it for their reporting.

 

Responsibilities:

·         Attending meetings with Requirement team to understand the Business requirements and walk through the Mapping document.

·         Attending Business meetings with Nationwide Managers/Business Stakeholder’s, Technical Architecture team and SME’s on Daily basis to discuss on Application defects/issues and providing the completion timelines for the reported issues.

·         Developing Denodo Views in Denodo.

·         Define workable security architectures in virtual data views that support consuming applications and protect sensitive data.

·         Implementing the software development using Agile methodologies.

·          Implementing the best practices for the Denodo Project.

·         Implementing the caching approaches.

·         Integrating the Oracle and Netezza databases using JDBC/ODBC data sources.

·         Colloborate with technical staff to understand and to develop new solutions or resolution of software problems.

·         Creating Denodo views& Denodo Jobs in Denodo using tool using Denodo VDP, Denodo Scheduler.

·         Created Derived Views on top of the Base Views for the mentioned preceding Data Sources.

·         Implemented three-layer architecture in Denodo as Connection, Combine& Integration and data feeding for downstream applications.

·         Involved in Denodo Code deployment from Dev to QA and QA to Production.

·         Acted as a Subject Matter expert on all aspects of Denodo.

 

 

GE Capital Treasury, Norwalk, CT.                                                              

Role: ETL Informatica/Denodo – Tech Lead – Onsite

Project Start & End Date: Aug 1^st 2014 to Feb 16^th 2018

 

Project Description:

GE Treasury is responsible for global funding, cash & foreign exchange management, and other treasury services for all of GE's worldwide operations. Almost all of GE's debt is issued through GE Capital to support its financial services businesses. GE Fund themselves through the issuance of long term debt, commercial paper, CDs & bank deposits, and other debt products as well. “GE Capital Treasury isn’t a P&L or a business unit. It's a function that funds the GE organization overall. Treasury customers are the GE businesses themselves. Treasury funding allows them to lend to their external customers and help them grow their businesses”. Treasury has additional functions, “manage risk in a way that keeps the company safe and secure to drive the overall technology strategy and manage the day-to-day operations of all our IT functions.” GE Corporate Treasury serves over 4,000 business units within the GE family of Companies, spanning some 20,000+ bank accounts with nearly 200 banks around the globe. As part of project architecture its extract data from different capital/financial systems like WSS, FXPress,GlobalBanks,BONY,TMS,DTA,MARS,GOLD,C-EDW,ATOM,SUMMIT,WEBCASH,CGL,MDM and starts loading to Stage, Integration Layer and EDW databases(Type -2 Facts and Dimension tables are involved)data i.e.., GE Treasury TDP DB. From TDP data it goes to different down streams like Risk Box, DTCC,CFTC, Bancware, TDP Access Layer, Sigma etc. via ESB(Enterprise Service BUS).

 

Responsibilities:

·         Interacting with the Clients on a regular basis to discuss day-to-day issues and enhancement tasks.

·         Providing Development & support for 800+ Informatica workflows/Mappings (developed using Informatica 9X) which are running into Production environment at client Location.

·         Providing Development & support for more than 100+ Denodo Jobs in Denodo 6.0  tool using Denodo VDP, Denodo Scheduler

·         Created Connections in Denodo VDP to connect to Oracle, Green plum, MS SQL , Excel Files.

·         Created Derived Views on top of the Base Views for the mentioned preceding Data Sources.

·         Implemented three layer architecture in Denodo as Connection, Combine& Integration and data feeding for downstream applications.

·         Created Denodo Cache for Derived views and refreshed the cache through Denodo Scheduler and trigger the mail communication for Success and Failure Notifications.

·         Implemented Full and Partial Cache in Denodo VDP using this cache for making joins and Unions as per downstream reporting requirement.

·         Created Derived Views on top of Base Views and accommodate the Business logics as per User requirement.

·         Implemented the Unions and Joins among the derived views to get the expected result.

·         Involved in Denodo Code deployment from Dev to QA and QA to Production.

·         Analyze the Informatica and Denodo Job failures and work with respective stakeholders for resolution and ensure they do the changes permanently.

·         Resolving the Incidents/Request/Problem with ITIL standards.

·         Involved in code & data analysis and handling the ad hoc requests by interacting with Business Analysts, Clients and Customers and resolve the issues as part of production support for Denodo, Informatica tools.

·         Reviewing Project tasks with offshore team and ensuring they complete on time.

·         Understand\Document the project requirement as per Business needs and convert the Project requirement to technical specification document.

 

 

 

 

GE CF-EDW Capital                                                       

Role: ETL Informatica Developer/Lead - Offshore

             Project Start & End Date: Jun 10^th 2012 thru Jul 20^th 2014

 

Project Description:

This project is mainly deal with building CCAR (Comprehensive capital analysis and review) data mart on top of EDW, EDW is GE Commercial finance Enterprise data warehouse is mainly deal with lending business of GE like HFS, FFS, CFS, ACBS.
The Comprehensive Capital Analysis and Review (CCAR) is the Federal Reserve’s primary supervisory mechanism for assessing the capital adequacy of large, complex BHCs. Following the adoption of the “capital plans rule” in November 2011, all U.S.-domiciled, top-tier BHCs with assets of $50 billion or more are required to develop and submit annual capital plans to the Federal Reserve.
The capital plans describe the processes used by these large BHCs to ensure that they have sufficient capital to continue to serve as credit intermediaries and to provide key financial services even under very adverse economic and financial market conditions.

 

Responsibilities:

·         Understanding the Business Requirement Document’s as well as technical aspects of the Project.

·         Involved in the low level designing of Commercial Finance EDW.

·         Involved in clarification calls on requirements with Business Analysts/Client and freeze the requirement for every sprint.

·         Involved in Scheduling calls, tracking and control.

·         Modifying the Teradata BTEQ scripts as per the requirement.

·         Creating and modifying the mappings and workflows as per the requirement.

·         Creating and modifying the chain in Appworx scheduler tool.

·         Preparing the test case documents for moving to Production environment.

·         Understanding the existing BTEQ scripts and Mappings.

 

 

GE EP6 Aviation EEDW.                                                     

Role: ETL Informatica Developer– Offshore

             Project Start & End Date: Dec 1^st 2011 thru Jun 5^th 2012

 

Project Description:

  Currently Data is scattered around different instances and due to this if a user needs a data he needs to reach to different team and lots of money is getting absorbed to avoid this they want to bring all the data into one system where in they can access it easily and also the money also gets saved. Due to this project GE has got a saving of half a million dollars. We have used Teradata as a Data Base as a target and sources as Oracle and other systems and Informatica is been used to load the data from sources to target Database. And the reports/data is being shown to users with the help of and Java application.

 

Responsibilities:

·         Collecting the requirements from the Client and understanding the Business Requirement and Functional Document’s as well as technical aspects of the Project.

·         Creating Low level and High level and technical design documents in Informatica.

·         Worked on Informatica Power Center Designer - Source analyzer, Mapping Designer and Transformation developer.

·         Used various Informatica transformations to load data in the data warehouse

·         Used Lookup, Sequence generator, Router and Update Strategy transformations to insert, delete, and update the records for Slowly Changing Dimension tables

·         Extensively used Mapplet’s and Reusable Transformations to prevent redundancy of            transformation usage and maintainability

·      Created database objects like tables, views, indexes, sequences and performing DML operations using insert, update and delete statements.

·      Involved in different phase of testing like User Acceptance Testing, Unit testing.

 

 

ISPT to Venture Migration                                    

Role: ETL Informatica Developer – Offshore

             Project Start & End Date: Mar 5^th 2010 thru Nov 1^st 2011

 

Project Description:

  The main objective of this project is to migrate the ISPT java based application to Venture application. ISPT is a web based portal which stores the information about the indirect sourcing details to GE. It takes data from 3 source systems E-auction details of projects are taking from web methods interface into ISPT staging area, Exception code workflow projects details are loaded by the respective team into ISPT staging area, third data source is SSP5 data mart. The ISPT application is moved to another similar kind of application called Venture, so the integrations has to pointed to new Venture Databases and Informatica mappings has to be pointed to load the Venture data bases. Also need to take the data from BTP data warehouse instead of SSP5 data mart.

 

Responsibilities:

·         Understanding the requirements as per the specification document.

·         Repointing the Source connections to new application.

·         Helping the dependent teams (WebMethods) to point their integrations to Venture application.

·         Creating the new Mappings for taking data from BTP instead of SSP5.

·         Loading the Legacy ISPT Data to Venture application.

·         Creating the workflows and scheduling them as per business requirement.

·         Used trigger based mechanism to handle dependencies.

·         Troubleshoot the errors during load.

 

 

GEFIN and GELINT (GE Finance and Ledge Integrations)                 

Role: ETL Informatica Developer – Offshore

             Project Start & End Date: Nov 1^st 2009 thru Mar 5^th 2010

 

Project Description:

  GEFIN stands for GE FINANCE and as per the word this project deals with the Finance related data. Initially the data is loaded in to GL instance and from there we pull the data into our FDM database. The data is pulled based on different conditions for which mappings are developed at Informatica. The loads run as per the oracle calendar and the same is intimated to users when the database is ready with the new data. Once the data is being loaded into the target database, users run the reports at their side using Hyperion tool.

The objective GLINT is to load the data from the Uniform instance (General Ledger) to nine different databases. GE energy services have various data warehouses and data marts for different product lines. As per the business logic, the data is pulled from the Uniform instance and loaded into different ERP’s and this is done through various mappings, sessions and workflows at Informatica.

 

Responsibilities:

·         Analysis of the specifications provided by the clients

·         Design to approach to integrate the Applications with IPS

·         Development – Creating Informatica Mappings to support the integration requirement.

·         Testing - unit testing & integration testing

·         Interacting with the client on a daily basis to update the project status.

·         Migration to QA and conduct UAT.

·         Production migration & Post Production Support for 15 days.

 

GE Parts – Atlanta