PROFESSIONAL HIGHLIGHTS

• Over 9+ years of total IT experience on Informatica Power Center 10.1, Data Virtualization tool: Confidential 6.0, Web - based applications on J2EE, Oracle 9i, Teradata 13.1, Unix, Exadata.
• 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.
• 3+ years of experience in J2EE (Casper, Struts, Spring and Hibernate Frameworks) & Oracle.
• 3+years of experience in Confidential Data Virtualization 5.5,6.0 tool( Confidential VDP, Confidential Scheduler, JConsole, Diagnostic Monitoring tool)
• Created Connections in Confidential 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 Confidential as Connection, Combine& Integration and data consumption for downstream applications.
• Created Confidential Cache for Derived views and refreshed the cache through Confidential Scheduler and trigger the mail communication for Success and Failure Notifications.
• Implemented Full and Partial Cache in Confidential 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 Confidential Code deployment from Dev to QA and QA to Production.
• Experience in working on different phases like Requirement Gathering, Development, Analysis, Documentation, Testing, Migration Project, Production and Post Production support.
• Involved in preparation of Requirement Traceability Matrix (RTM), Defect Report, and Weekly Status Reports.
• Worked closely with Clients, Business Analysts, Data architects, Database Administrators, Developers and BI Reporting teams to ensure the ETL solution meets business requirement.
• Experience in developing and maintaining software applications in Domain areas of GE Manufacturing, Energy, capital & Treasury.
• Expertise in Data Warehousing, ETL design and development process using Informatica Power Center (Source Analyzer, Data Warehousing Designer, Mapping Designer, Mapplet, Transformations).
• Having knowledge on Dimension modeling Star/Snowflake schemas, Dimensional Data modeling, Fact & Dimension tables, Physical & logical data modeling, SCD.
• 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.
• 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.
• Expertise in error handling, debugging and problem fixing in Informatica.
• Informatica upgrade from 9.5 to 10.1

COMPUTER SKILLS

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

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

Scripting Language: Unix Shell Scripting and Perl

Database - RDBMS: Oracle 10g, TERADATA 13, Greenplum, Exadata.

Integration Tools: Confidential 6.0

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

Scheduling Tools: Appworx, Unix Cron Jobs

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

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

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

PROFESSIONAL EXPERIENCEGE

Confidential, Stamford, CT

ETL Informatica/ Confidential - Developer/Analyst

Responsibilities:

• Interacting with the Clients on a regular basis to discuss day-to-day issues and enhancement tasks.
• Providing support for 800+ Informatica workflows/Mappings (developed using Informatica 9X) which are running into Production environment at client
• Providing support for Confidential Jobs running in Production more than 150+ Jobs which runs on 24/7 schedule.
• Analyze the Informatica and Confidential 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 Confidential, Informatica tools.
• Reviewing Project tasks with offshore team and ensuring they complete on time.
• Providing On-call support as this is 24X7 application.
• Fixing Informatica and Confidential enhancement tasks as part of L3 Support.
• Understand\Document the project requirement as per Business needs and convert the Project requirement to technical specification document.

Confidential, Norwalk, CT.

ETL Informatica Developer/Lead

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 Confidential 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 Confidential scripts and Mappings.

Confidential, Atlanta, Georgia

ETL Informatica Developer/Java Developer/ Release Lead

Responsibilities:

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

Confidential, Atlanta, Georgia

ETL Informatica Developer

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.

Confidential

ETL Informatica Developer

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.

Confidential - Atlanta

Java Developer/Production Support

Responsibilities:

• Providing access to see the turbine information etc. using SAM tool to view in the CMF tool.
• Also looking into Parts Edge application Production issues.
• Making code changes at JSP/Java/Configuration files.
• Making required DB level changes in case any back end logic or query needs to be changed.
• Raising a Change Requests to Deployment team.
• Migrating the code from Dev to QA.

Confidential - Atlanta

Java Developer/Production Support

Responsibilities:

• Requirement gathering for the new Modules.
• Creating Workflows, Mappings in Informatica to load the data from one database to Confidential DB tables.
• Making code changes at JSP/Java/Configuration files.
• Making required DB level changes in case any back end logic or query needs to be changed.
• Raising a Change Requests to Deployment team.

Confidential - Atlanta

Support central developer

Responsibilities:

• Going through the existing design of the UI built on Visual basic.
• Attending the calls with the Client
• Undergone the training on Support central.
• Developed the Data Form and Workflows in Support central.