Resume

Sign in

Data Developer

Location:
Bloomington, Illinois, United States
Salary:
120000
Posted:
January 29, 2018

Contact this candidate

KUGAN

Informatica Administrator/ Senior Developer

Kugan. R has 12 plus years of experience in Information Technology. I have experience in the design, development and administration of applications using Informatica, UN IX\LINUX and Mainframe Technologies. Expertise in coordinating with onsite teams for analyzing Requirements, Development, Testing and preparing specifications.

Major Strengths:

Strong in Informatica Power Center v9.x / v10xSoftware Installation/Configuration & Unix/Linux

Coordinate/Plan & Execution activities related to platform maintenance, Disaster Recovery and Software release management

Configuration and tuning of production and lower-level environments

Perform Capacity & Stability monitoring

Contribute to definition, review, documentation & communication of standards and Informatica Best Practices

Working knowledge of Linux/Unix shell scripting.

Ability to analyze & communicate root cause and resolution steps. L3+ escalation for Platform Issue resolution, troubleshooting and root cause analysis

Working knowledge of the Informatica software security model and adaptability

Working knowledge of LDAP integration to Informatica Power Center v9.x/v10.x

Working knowledge of the key elements & differentiators of Power Center V10.x and v9.6

Familiarity with Kerberos v5.x configuration and integration to Informatica v10.x and v9.6

Developing new features with Informatica developer and Informatica IDQ tools.

Developing ETL process using Informatica, UNIX scripting and Perl.

Developing Data Quality flow using Informatica,UNIX,Perl,

Developing Self-service portal using JAVA, J2EE and STRUCTS supporting Informatica Administration jobs.

Performing code walk through and integration testing of the deliverables.

Developing new features using EPL/I,COBOL,SAS,DB2,Korn shell script

Experience in the Insurance and retail domain.

Strong at Team coordination, Team Management, Verbal & Written communication skills

Technical Skills:

Informatics Platform

Informatica V 9.0, 9.6, 10.1, Pro-active Monitoring, DVO, Power Exchange.

Languages

Korn shell scripting, Perl, EPL/I, COBOL, SAS, REXX, JCL,

Operating Systems

Z/OS, UNIX, MS Windows 2000/98/95/XP, LINUX

Databases and Languages

DB2, IMS/DB, VSAM, Teradata, Oracle, SQL Server, PLSQL

Intermediate Tools

XPEDITOR, SPUFI, FILE-AID, RMS, Service Manager, Control-M

Other Technologies

JAVA 1.7, J2EE, C++, HTML, XML, Oracle, STRUCTS framework

Project Experience:

Informatica administration, HTC Global Services

December 2011 to November 2017

Informatica Administration involves developing UNIX scripts to do the daily Administrator activities

Installation and upgrade new version software in informatica servers. Assisting application team and 2nd level support team in case of issue related to informatica Power center, Power exchange and Informatica Central admin tool (Statefarm specific).

As an Informatica Administrator, Kugan was involved in Informatica tool support

Involved in installation of Informatica client in Hadoop environment for supporting IDQ for data in HIVE and HDFS using informatica version 9.6.1. HF 3.

Involved in Informatica Power Center v9.x / v10xSoftware Installation/Configuration & Unix/Linux

Involved in migrating Informatica environments from physical and virtual.

Back-up and recovery of Informatica software, repository, and configurations

Monitoring the environments and suggesting improvements for stability and performance tuning

Define standards and implement best practices to manage and support the ETL environment

Involved in support and maintenance of Korn shell scripts for automation.

Involved in development and enhancement of Automation tool to support Administration jobs

Involved in Development/Modification of Korn shell scripts for informatica support service automation.

Involved in implementation of new changes in the informatica support service automation and Central Admin tool

Developed script for automated Installation/upgrade of Informatica versions 9.6.4, 10.1,10.1.1 using Linux/UNIX.

Coordinate/Plan & Execution activities related to platform maintenance, Disaster Recovery and Software release management

L3+ escalation for Platform Issue resolution, troubleshooting and root cause analysis

Involved in Configuration and tuning of production and lower-level environments

Perform Capacity & Stability monitoring

Contribute to definition, review, documentation & communication of standards and Informatica Best Practices

Ability to analyze & communicate root cause and resolution steps

Perform LDAP integration to Informatica Power Center v9.x/v10.x

Involved in automating Informatica Code deployment process across enterprise.

Enterprise Data Design on Customer Data, HTC Global Services

January 2012 to December 2015

Project is designed to provide enterprise Customer Date to Extract transform and load to the Data marts for reporting to find trends based on the customer query.

As a Senior developer, I was involved in the supporting the ETL part of the EDD for CD application.

Involved in Design and development of Customer experience warehouse database.

Involved in migraition of data from physical environment to virtual environment with high availability.

Involved in various data fix in CD data mart design.

Involved in Development/Modifiction of Korn shell scripts for loading data from LDAP to Wharehouse.

Involved in implementation of new changes in the CD ETL flow.

DIS – Captiva Application support, HTC Global Services

January 2012 to November 2013

Captiva application is designed to provide an enterprise imaging application for Central Imaging Operation and retrieval of digital image documents. The information about the scanning and indexing services are stored in Data warehouse in a daily bases through the ETL flow developed in Mainframe, Unix and Informatica . and this data will be used by the Bussiness partners for generating reports.

As a Senior developer, Kugan was involved in the supporting the ETL part of the CAPTIVA application.

Involved in support and maintenance of CAPTIVA application.

Involved in improving the performance of the ETL Captiva flow.

Involved in various data fix in captiva tables.

Involved in Development/Modifiction of Korn shell scripts.

Involved in implementation of new changes in the captiva ETL flow.

Environment: Informatica,UNIX,Mainframe

DIS – EA Dashboard, HTC Global Services

October 2012 to Present

Reporting & Analytics Team is wrapping up several months of work in which business processes & requirements, emerging Care Center technology direction, Enterprise performance & analytics plans was evaluated. These various inputs were melded to come to an agreement on a high level architectural approach to automate reporting & analytic requirements for selected Customer Care Centers (CCC).

As a Senior developer, Kugan was involved in the analysis, design, development, and Unit testing of the ETL Components developed in Informatica and unix..

Involved in Architectural design of the EA ETL system.

Creating component specification, mapping documents and Unit test case document.

Development of Informatica mapping and workflow as per the requirements.

Development of Korn shell scripts.

Involved in Unit testing the Korn shell scripts and informatica mappings and workflow

Creation the flow diagram for the scheduling team to load the jobs in Control-M.

Involved in peer code review for both Unix and informatica.

Environment: Informatica,UNIX

DIS – RSC Support, HTC Global Services

December 2011 to Present

RSC (Reusable component) support is a process to understand the common need in all the applications developed in BIRA and developing the reusable components. And for a new project we will be involved in project design meeting and we educated the team about the reusable components already developed.

As a senior developer, Kugan was involved in the analysis, design, development, and testing of the Reusable components And he also involved in assisting the project team in using the RSC.Creating Knowledge base about the reusable components and publishing them in the repository His responsibilities included:

Analyze and develop the reusable components.

Assisting the project team in using the reusable components.

Support the failures in the flow that involves RSC

Enhancing the RSC based on the requirement from the project team

Testing the reusable components

Create Component specification and test case document

Creating the Knowledge base with the usage information for the RSC.

Environment: Informatica,UNIX and mainframe technologies

DIS – 2nd Level Support, HTC Global Services

September 2010 to December 2011

DIS 2nd level support involves primary support for the Applications in BIRA. And getting Knowledge from the project team

As a Support Analyst, Kugan was involved in the Incident, Request and task management for the BIRA applications.

Support Applications developed in Informatica, UNIX and Mainframe jobs

Own the incidents created for the job failure and work in fixing the job failure.

Work with 3rd level team if the failure involves data issue.

Creating and publishing Knowledge item for the recurring problems.

Environment: Informatica,UNIX and mainframe technologies

DIS – Data Quality, HTC Global Services

April 2010 to December 2011

Data Quality is a process to validate incoming data from Host mainframe system to BIRA UNIX environment This breaks down into two major functions: Significant field compare and load balancing

And also Data Quality involves Data Profiling on the test data.

As a senior developer, Kugan was involved in the analysis, design, development, and testing of the Data Quality flow for various Data Movement applications developed in BIRA And he also involved in developing reports. His responsibilities included:

Developing Data Quality features using Informatica and UNIX

Performing peer code reviews and communicating with the Project team on a day-to-day basis

Creating component specification based on the requirement.

Fixing the defects reported during System testing.

Creating unit test case document.

Environment: Informatica,UNIX

CRI Infrastructure – Performance Enhancements, HTC Global Services

January 2010 to March 2010

Customer Rating Index (CRI) is a relatively new process within Auto Systems. CRI is the Four digit number calculated based on customer characteristics. The number is translated into a rating factor and used, along with other rating factors, to determine an Auto policies premium. Auto CRI values range from 1000 to 1999.

As a Senior Developer, Kugan is involved in the analysis, design, development, and testing of the various services and jobs that involved in Collection, calculation and counting data to create CRI. His responsibilities included:

Developing new features using EPL/I,DB2,IMS/DB and JCL

Performing peer code reviews and communicating with the Onsite coordinator on a day-to-day basis

Creating component specification based on the requirement.

Fixing the defects reported during System testing.

Creating unit test case document.

Involved in production support.

Environment: EPL/I, DB2, JCL, IMS/DB,SAS

DIS – DAS (Data acquisition System), HTC Global Services

March 2008 to December 2009

DAS is a process to validate incoming data and prepare it to be used in the warehouse. This breaks down into three major functions: Inventory, Balance, and Common Key Assignment.

As a senior developer, Kugan was involved in the analysis, design, development, and testing of the various Applications and jobs for AUTO, FIRE, LIFE, HEALTH, BANK, MUTUAL FUNDS. And he also involved in developing reports. His responsibilities included:

Developing new features using EPL/I,DB2,IMS/DB,SAS and JCL

Performing peer code reviews and communicating with the Onsite coordinator on a day-to-day basis

Creating component specification based on the requirement.

Fixing the defects reported during System testing.

Creating unit test case document.

Involved in production support for all the line of business.

Environment: COBOL, DB2, JCL, VSAM, SAS

AED – Auto Enhanced Data Capture, HTC Global Services

April 2007 to March 2008

AED is a process to capture data at different point of daily Auto business flow to avoid fabricating data for unit/system testing and AED provide the captured data to Auto System Analysts and Test analysts

As a developer, Kugan was involved in running the auto flow using a network JCL on the data loaded in the database. And capture data at required points. And he also involved in JCL change. His responsibilities included:

Changing the JCL as required

Loading reduced data onto an IMS test system.

Executing the business day’s auto processing.

Taking additional capture points that serve as replacements for reduced data.

Communicating with the Onsite coordinator on a day-to-day basis

Environment: EPL/I, COBOL, DB2, JCL, VSAM, IMS/DB

DISC Item pop, HTC Global Services

November 2006 to March 2007

Discontinued item pop is a project to handle the loss calculation based on the items that are damaged or expired.

As a Programmer Analyst Trainee, Kugan was involved in developing and testing various components (Programs & JCLs) based on component specification.

Developing new features using COBOL, DB2 and JCL

Fixing the defects reported during System testing.

Communicating with the Onsite coordinator on a day-to-day basis

Creating unit test case document.

Environment: COBOL, DB2, JCL, VSAM, Teradata

Jewelry commission, HTC Global Services

July 2006 to November 2006

Jewelry commission is a project involved in calculating the commission for the sales person in the Jewelry department based on the sales and return.

As a Programmer Analyst Trainee, Kugan was involved in developing and testing various components (Programs & JCLs) based on component specification.

Developing new features using COBOL, DB2 and JCL

Fixing the defects reported during System testing.

Communicating with the Onsite coordinator on a day-to-day basis

Creating unit test case document.

Environment: COBOL, DB2, JCL, VSAM, Teradata.

Education:

●Bachelor of Engineering in Computer Science, Madras University, India.



Contact this candidate