Data Informatica

Location:

Chapel Hill, NC

Posted:

October 25, 2019

Contact this candidate

Resume:

Balabharathi S

Chapel Hill, NC *****

An industrious person seeking a challenging role in a Data Warehousing environment which can provide opportunities for career improvement, by implementing my technical knowledge, analytical skills and experience and thereby contributing to the growth of the company.

TECHNICAL SKILLS

Primary Skills ETL and Data Warehousing

ETL Tools Informatica 8.X & 9.X & BODI, BODS XI 4.2

Reporting Tool Business Objects XI, 4.1, Microstrategy

Database Application Oracle 11g/10g/9i/8i/7i

Others UNIX, PL/SQL, SQL

EXPERIENCE SUMMARY

9+ years of experience as a Software professional with Data Warehousing skills

Sound Knowledge in the following Data Warehousing and Business Intelligence tools:

Informatica (ETL)

Business Objects (Reporting)

Business Objects Data Services (ETL)

Very Good experience in Oracle SQL queries and PL/SQL procedures

Experience in working on UNIX shell scripts

Strong expertise in trouble shooting and problem analysis

Hands-on experience on both development and support project environments

Worked in projects following Agile methodology and waterfall

Good team player with excellent communication and interpersonal skills. Possess strong analytical skills and good technical knowledge for problem solving.

Hard worker who can adapt quickly to different work environments and perform tasks in a well-organized manner.

PROJECT DETAILS

Adecco Staffing Services

Sr. ETL Informatica Developer June 2019 to Present

Responsibilities:

Responsible for developing ETL workflows and perform testing for quality assurance

Participate in design and analysis sessions with business analysts, source-system technical teams and end users.

Prepare technical documentation for both high level and low level design documents. Prepare test cases and sample test data to cover various test scenarios.

Designing, developing, maintaining and supporting Data Warehouse or OLTP processes via Extract, Transform and Load (ETL) software using Informatica, Shell Scripts and Autosys.

Understand and perform Data Analysis, requirement gathering and Design and Development

Involved in Performance tuning for sources, targets, mappings and sessions.

Translate business requirements into ETL and report specifications. Performed error handing using session logs.

Participates in scrum meetings to update the progress and understand the overall status of team in the Sprint.

Analyzed data using complex SQL queries, across various databases like Oracle

Responsible for handling the team by assigning ETL tasks based on priority and support the team with any technical difficulties encountered.

Involved in creating database objects like tables, views, procedures, triggers, and functions using Oracle to provide definition, structure and to maintain data efficiently.

Supported the BI team by extracting operational data from multiple sources, merging and transforming the data to facilitate enterprise-wide reporting and analysis and delivering the transformed data to coordinated data marts.

Environment: Informatica Power Center 9.6.1/10.1, Oracle 11g, Microstrategy 11.1, Autosys,SQL, PL/SQL, UNIX, Agile

Assistant Project Manager,

NTT Data. June 2006 – Feb 2016

ETL Data Migration Central Data Services Jan 2015 – Feb 2015

Client Honeywell

Database Oracle 9i

Tools Used Informatica 8.6

Team size 2(Onsite), 4(Offshore)

Location Chennai

Roles Undertaken Team Lead

Project Description:

This project deals with the migration of Honeywell’s legacy systems to SAP so that the future business process will be carried over in SAP. This includes conversion of data lying in heterogeneous legacy systems into format acceptable by SAP and satisfying the Business conditions provided by Honeywell. Informatica was used as an ETL tool for extracting data from flat file sources and generate target files based on the business logic provided.

Roles and Responsibilities:

Working on gathering and understanding the requirements from the BSAs of different deployments and preparing the Understanding documents based on them

Assigning the objects to the team members based on their complexity and work load on the team members

Developing ETL code in Informatica to generate the flat files of the format specified by the BSA using the various transformations available. Have used transformations like lookups, expression, joiner, router, filter, normalizer and Union.

Supporting the deployments in various mocks by doing file generations for the objects which have been already created, database activities like table creations or loading, analysis on some objects based on the inputs from BSAs.

Knowledge of ETL solutions in various subject areas like Aftermarket, Finance, Project systems, Order management, Manufacturing and Supply Chain.

Experience in handling master data such as Material Master, Customer master, Equipment master, Vendor master etc. and transactional data.

Provide technical support and help the team members to arriving at the solutions to complex requirements.

Use Informatica debugging techniques to debug the mappings and use session log files and bad files to trace errors that occur while loading.

Use Informatica Version Control for checking in all versions of the objects used in creating the mappings and workflows and to keep track of the changes in the development, testing and production environments.

Involved in project management activities like preparation of status reports, tracking the efforts of the team members and handling the internal/external audits

Financial Management Reporting Feb 2014 – Dec 2014

Client Honeywell

Database Oracle 11g

Tools Used BODS XI 4.2, BO XI 4.2

Team size 4(Offshore)

Location Chennai

Roles Undertaken Offshore Team Lead

Project Description:

The objective of the Aerospace Financial Management Reporting program is to implement a Management Reporting tool to consolidate SAP and legacy site data into a single data warehouse. The tool will provide reporting data along 5 dimensions: CBT, SBU, Revenue type, Product Line and Site. There are a large number of requirements for new reporting functionality as part of the Aerospace Financial Management Reporting project. The goal of this project is to solution and build those new requirements. The nature of these requirements requires a specialized skill-set and significant experience. The resources must be able to create solutions without significant guidance from the Honeywell IT team.

Roles and Responsibilities:

Worked on gathering and understanding the requirements from the business directly.

Analyze the business requirements and prepare understanding document with the technical details.

Worked directly with the Honeywell Build team to ensure projects have adequate coverage and are meeting the project milestones defined in the project plan itself, in order to meet the timeline and the go-live date projected.

Have meeting with team members to discuss about the objects which they are working to check whether the design is optimal and on how to achieve the requirements, as required.

Development of enhancements to the existing application, performance tuning when required.

Review code developed by other users, identify problem areas and suggest quick work around and solutions.

The application enhancement was developed based on the tickets or service requests received from the client / customer.

Experience in using HPQC to track changes and updating them on a regular basis.

Incorporated the changes and reverted to the business within the least possible turnaround time.

Solocup Support Jan 2012 – Dec 2013

Client Solocup (Dart)

Database Oracle 9i

Tools Used BODI 6.5, BODS 4.0

Team size 1(Onsite), 8(Offshore)

Location Chennai

Roles Undertaken BODS Consulant

Project Description:

Solo Cup Company is an American manufacturer of disposable consumer products including beverage cups, disposable plates and bowls. Solo Cup uses SAP’s Rapidmarts solution to fetch the ERP data from Oracle Apps and load them into Oracle database. The BO universe and Reports are built from the Rapidmarts. We undertook the implementation of the AP and Purchasing Rapidmarts and also to take care of the other BODI jobs related to various smaller data warehouse projects.

Roles and Responsibilities:

Responsible for the maintaining the BODI jobs in the production and the test environments and to fix any failures

Involved in successfully implementing the Accounts Payable Rapidmart job in Prod and the Purchase Rapidmart job in Test environments to extract data from the Oracle Apps System, by installing the jobs and making the custom modifications based on the requirements given by the users

Analyzing the data issues reported by the users and to make modifications to the existing BO DI 6.5 jobs based on their requirements

Responsible for maintaining the BODI 6.5 servers in Prod, Test and Dev environments

Responsible for gathering the requirements for the ETL conversions that involve BODS 4.0 for data migration from various legacy environments to SAP

Design and test the BODS jobs based on the requirements to extract and cleanse the data if required and to send the data directly from BODS to SAP using IDOCs or to provide the data files to the respective teams to load the data.

ETL Data Migration Jul 2010–Dec 2011

Client Honeywell

Database Oracle 9i

Tools Used Informatica 8.6

Team size 4(Onsite), 5(Offshore)

Location Chennai

Roles Undertaken Offshore Team Lead

Project Description:

Honeywell has taken up the activity of migration of its legacy systems to SAP so that the future business process will be carried over in SAP. This includes conversion of data lying in heterogeneous legacy systems into format acceptable by SAP and satisfying the Business conditions provided by Honeywell. The data from the legacy systems will be extracted and given as flat file input to the Keane Informatica Team. The data extraction is done subject area wise which should be Transformed and loaded into SAP through Informatica & LSMW. It will be a T& M project and as and when the FS will be given by Honeywell the estimates will be done for that and the normal phases of development cycle (design, development, testing and delivery) will be carried over for that FS. It will be treated as iteration.

Roles and Responsibilities:

Working on gathering and understanding the requirements from the BSAs of different deployments and preparing the Understanding documents based on them

Assigning the objects to the team members based on their complexity and work load on the team members

Provide technical support and help the team members to arriving at the solutions to complex requirements.

Involved in project management activities like preparation of status reports, tracking the efforts of the team members and handling the internal/external audits

Also manages another 2 small projects which use Informatica and Business Objects tools by helping the members of the teams in the reviews and identification of issues and other project management activities.

CSOW DWH Support Mar 2009 – Jun 2010

Client Honeywell

Database Oracle 10G

Tools Used Business Objects Data Integrator XI, Business Objects XI, Informatica 8.6

Scripts UNIX

Team size 6(Offshore), 11(Onsite)

Location Chennai

Roles Undertaken Offshore Team Lead

Project Description:

Honeywell has various reporting databases and Production systems like SAP Rapid Marts, Enterprise Data Warehouse (EDW), End User Reporting (EUR) Data Marts, Legacy Applications, CSDM applications, AeroPDM application and RCR which are fed by ETL loads scheduled. The ETL loads are scheduled mainly as Data Integrator jobs for EDW and EUR and the other application data loads are scheduled mainly in Informatica. The team provides the support for these Production systems which includes monitoring, correction of production jobs and related data and resolving the issues based on the priority. 24X7 monitoring will be done for these systems for the smooth running of the scheduled jobs. BO Reports are available for the End users for their business activities. The issues on BO reports will also be handled by the team.

Design, development and testing of ETL batch jobs using Data Integrator. Worked with relational and flat file sources and have used transforms like Query, Merge, SQL, Match_Merge and the various built-in functions like lookup, ifthenelse, lpad_ext, ltrim, rpad_ext, length, nvl etc.,

Worked on development and testing of Informatica workflows using various types of sources and targets. Have used Relational, Flat-file and SAP sources and Relational and flat-file targets. Worked with transformations like lookup, joiner, sorter, aggregator, expression, filter, router, Stored Procedure, union etc.,

Worked on UNIX scripts for automation of monitoring. Worked on developing scripts which would fetch the status of a job/workflow from a Meta data table and mail the support group based on the status updates.

Worked on the enhancements involving development and testing of PL/SQL, Business Objects and Informatica for Aero PDM application. Has worked on PL/SQL procedures, functions and Packages. Supported the Aero PDM application and handled production issues. Involved in the performance tuning of the production jobs of the Aero PDM application.

Fixed production support issues in Business Objects Reports which involves analysis of the SQL queries used in the reports, variables and formulas used in the report and analysis on the joins between the tables. Have also worked in scheduling the reports and universe changes.

Has also worked with the Business objects report users to provide them technical support by helping them to execute and schedule the reports and understood the issues stated by them and fixed them within SLA.

Has been the offshore team lead and helped the team members technically and has helped them in improving their knowledge and skills.

SAP ETL Migration Aug 2008 - Feb 2009

Client Honeywell

Database Oracle 9i

Tools Used Informatica 8.6

Team size 4(Onsite), 6(Offshore)

Location Tempe, AZ

Roles Undertaken Onsite Team Member

Project Description:

Roles and Responsibilities:

Worked in onsite (US), with customers and BSA to gather requirements on transformation of legacy data to ETL mappings using Informatica. Understood the requirements provided by the BSA and has developed mappings based on the requirements to transform the data from a flat file to the required format. Has used transformations like filter, router, normalizer, lookup etc.,

Fixed the issues on Informatica mappings during the mock loads and during the go-live and generated Target files using Informatica workflows

Worked on Oracle database maintenance related activities like creating lookup tables and providing the proper level of access to the various users of the tables, loading the data provided into the tables using toad or scripts etc.,

AeroPDM Data Warehouse Phase -2 Apr 2008 - Jul 2008

Client Honeywell

Database Oracle 10G

Tools Used Informatica 7.1, Business Objects XI R2

Team size 4(Offshore), 1(Onsite)

Location Chennai

Roles Undertaken Offshore Team Lead

Project Description:

This project is the Second phase of year 2007 AeroPDM Data Warehouse project. Aero PDM EDW is a project to deliver a new solution for Aero PDM adhoc reporting to enable robust reporting across Aero Space by moving existing PDM data to Aero Space EDW. The goal of Phase 1 was to develop QA installed application according to customer requirements. The goal of Phase 2 is to move the developed application to Production while improving its functionality by developing additional reports and modifying ETL design to meet performance requirements.

Roles and Responsibilities:

Worked on analysis, design, development and testing for PL/SQL procedures, Informatica mappings and workflows. Developed Informatica mappings which can execute the stored procedures and have developed the workflow to link the sessions based on dependency. Has worked with various workflow manager tasks like session, email task, command task and event wait task.

Has worked on PL/SQL procedures and was in the performance tuning of the PL/SQL procedures.

Developed a simple BO universe and has developed and tested BO WebI reports. Has worked on universe level hierarchies, derived tables in the universe and has created reports with sections and has implemented various business logic and calculations using the Business objects in built functions.

Customer Services Data Mart Apr 2007 - Mar 2008

Client Honeywell

Database Oracle 9i

Tools Used Informatica 7.1, Business Objects 6.5 and XI

Team size 2(Offshore), 1(Onsite)

Location Chennai

Roles Undertaken Offshore team member & Offshore Team Lead

Project Description:

Customer Services Data Mart serves as the maintenance bucket for maintaining the crucial data marts like the CSDM, IOS, GMS and the Repair and overhaul operational data stores of Honeywell Customer Service Division. It also provides maintenance and enhancements support for Reports derived from these systems.

Roles and Responsibilities:

Monitored and handled production support issues of the Informatica workflows and PL/SQL procedures. Has fixed the production workflow failures quickly and efficiently by analyzing the errors in session and workflow logs and taking the necessary actions which involves modifications to the procedures or simple fix to the source flat files.

Serviced maintenance and enhancement requests using Informatica and PL/SQL related to the different applications of the project. Analyzed on the issues reported by the customers in the related workflows or sessions and the procedures which executed through them and provided the solution to the issues.

Resolved production support issues related to the Business Objects thick client reports which involved the analysis of the SQL queries of the reports.

Has been a team lead and mentored the new team members on project and the work environment. Has also helped them to solve the technical issues faced in the project.

AIW Support Sep 2006 - Mar 2007

Client Honeywell

Database Oracle 9i

Tools Used Data Integrator XI, Business Objects XI, Informatica 7.1

Scripts UNIX

Team size 16(Offshore), 11(Onsite)

Location Chennai

Roles Undertaken Offshore team member

Project Description:

There are various reporting databases and Production systems like SAP Rapid Marts, Enterprise Data Warehouse (EDW), End User Reporting (EUR) Data Marts and Legacy Applications which are fed by ETL loads. The ETL loads are scheduled mainly as Data Integrator jobs for EDW and EUR and the other application data loads are scheduled mainly in Informatica. The team provides the support for these Production systems which includes monitoring, correction of production jobs and related data and resolving the issues based on the priority. 24X7 monitoring will be done for these systems for the smooth running of the scheduled jobs. BO Reports are available for the End users for their business activities. The issues on BO reports will also be handled by the team.

Roles and Responsibilities:

Worked in UNIX scripts and PL/SQL procedures for automating the monitoring activities. Has developed scripts and PL/SQL procedures to fetch the statuses of the jobs or workflows and to indicate the changes in their statuses like job failures or completion.

Worked on issues related to Business Objects Reports support. Fixed the issues in the Business objects WebI reports by analyzing the SQL queries of the reports and the joins in the Universe.

Production Support for the Rapid Mart Loads of AIW systems. Has monitored the productions loads using the Data Integrator Administrator tool.

ETL Data Migration Jul 2006 - Aug 2006

Client Honeywell

Database Oracle 9i

Tools Used Informatica 7.1

Team size 4(Onsite), 16(Offshore)

Location Chennai

Roles Undertaken Offshore Team Member

Project Description:

Roles and Responsibilities:

Worked on analysis and design of the Informatica mappings based on the requirements provided in the understanding document. Has also identified the various test scenarios to test the mappings and workflows based on the requirements.

Identified the various issues present in the understanding document and has worked with the onsite team members to get clarifications on the requirements.

Has developed the mappings and workflows as per the design document and tested them on the various test scenarios using the Test cases written. The mappings involved extraction of data from flat files and had simple transformation logics using filter, routers, expression and lookup.

EDUCATIONAL PARTICULARS

EXAMINATION

INSTITUTION

PERCENTAGE

YEAR

B.Tech (Electronics & Communication Engineering)

Pondicherry Engineering College, Pondicherry

78.7%

2006

Contact this candidate