Data Project

PROFESSIONAL SUMMARY:

**.* years of experience in Analysis, Design, Development and Implementation of DW applications using Informatica, Oracle 11g/10g- SQL and PL/SQL Level, and Unix & Perl Shell Scripting.

Experience in Amazon Web Services like Amazon Lambda, Amazon S3, Amazon RedShift, Athena and Amazon EMR to achieve file processing automation

Extensive experience in Java-JEE Modelling and Design of High Availability – High Throughput systems.

Experience in leading Onsite/Offshore team, as an Onsite ETL Lead/Solution Architect, providing ETL Solutions for new projects and BAU (Business As Usual) project.

Interfacing with business customers, gathering requirements and developing new datasets in data platform

Experience in developing, maintaining and enhancing ETL code for Data Mart with heterogeneous sources

Worked on various designs and architectures and determined the best technologies and frameworks available for the accomplishment of the program.

Mentor junior developers and team members on the application framework and design.

Experience in using various Tuning techniques to improve performance in Mappings, Sessions, Workflows

Experience in working with various types of source/targets, flat files like fixed width, CSV, and relational types like SQL Server & Oracle database tables, XML Files, Parquet Files, GSRL and JSON.

Extensively worked on various scheduling tools like Tivoli and Control M Scheduler

Quick turnaround on providing solutions and workarounds for Production job failures in Informatica & Oracle Procedures and provides workarounds in quick turnaround to avoid user impacts.

Experience in automating ETL process, file transfers and calling stored procedures using Shell scripts.

Experience in using issue tracking and ticketing tools like Peregrine & HP Quality Center for UAT & Production Implementations

Performed overall project status & issue tracking, analysis, architecture, design, development, testing (Unit testing/System Integration testing/User Acceptance testing/ Regression testing) and implementation of data warehousing initiatives.

Experience in developing Stored Procedures, Functions, Sequences, views and extensive knowledge in Database objects like Indexes.

Ability to work collaboratively in a team environment and has the ability to handle multiple tasks under pressure

Worked on data warehousing projects from inception to implementation and delivered high quality solutions in a timely manner meeting and exceeding the business requirements. This involved working with the top management executives, business sponsors and Corporate Real Estate department.

EDUCATION:

Title of the Degree with Branch

College/University

Year of Passing

Master of Computer Applications

SRM University, Chennai

2007

Bachelor of Computer Applications

Kanchi Shri Krishna College of Arts & Science/University of Madras

2004

TECHNICAL SKILLS:

Databases: MySQL, Oracle 12c, DB2, SQL Server, Sybase IQ

Languages: SQL, PL/SQL, UNIX, Java Spring

ETL Tool: Informatica 10.1, Informatica Cloud, Informatica Developer Tool

Services: Amazon Web Services (AWS) EMR, AWS Lambda, AWS S3, Athena, Amazon RedShift, SNS, Jenkins.

Processes: Agile Methodologies

PROFESSIONAL EXPERIENCE

Project #1

Title US Trade Credit

Client Dun & Bradstreet, Center Valley, PA

Tools AWS EMR, AWS S3, Lambda, SNS, Athena, Informatica Developer Tool

Database MySql

Language Java, Spring, PL/SQL

Team Size 8

Role Team Member

Period Apr 2017 – Till date

Location Center Valley, PA

Project Description

US Trade Credit

The goal of the Trade Credit Supply Chain program is to transform and standardize data coming from various sources and deliver the best view of the company data in the desired formats to various products like DirectPlus (D+), Direct2.0, and emerging API product lines.

The source data coming from various sources is cleansed and transformed using different business rules and data is extracted and sent to different systems.

The application processes huge sets of data in the cloud in a time and cost-effective way using cloud services like Amazon Web Services and distribute frameworks like Apache Spark. Informatica is used to profile the results to analyze various market data.

Client Description

The D&B Corporation (NYSE: DNB) is the most trusted source of information that companies need to make their business a success. Often called D&B, it is perhaps best known for its D-U-N-S (Data Universal Numbering System) identifiers assigned to over 100 million global companies. D&B is the world's leading provider of business-to-business credit, marketing and purchasing information. It also provides receivables management services. Companies of all sizes use D&B data to evaluate business opportunities with confidence and execute transactions at the speed of e-business.

Role and Responsibilities

Involved in Requirements gathering & Analysis from Business Users

Project Planning and Estimation, designing Application Architecture, prepare detailed design models.

Work with Project Management to help develop project plans and meet schedules

Worked on various designs and architectures and determined the best technologies and frameworks available for the accomplishment of the program

Configured S3 buckets with various life cycle policies and notifications to archive the infrequently accessed data to storage classes based on requirement.

Worked on Amazon Lambda, Amazon S3 and Amazon EMR to achieve file processing automation. Mentor junior developers and team members on the application framework and design.

Profile the data using Informatica IDQ for business review and improvements.

Project #2

Title SBRI – Small Business Risk Insight

Client Dun & Bradstreet, Parsippany, NJ

Tools Informatica 9.6, UNIX, IDQ

Database Oracle 11g, Sybase 15.3, DB2 10

Team Size 5

Role Team Member

Period Jan 2014 – Mar 2017

Location Short Hills, NJ

Project Description

Small Business Risk Insight (SBRI) & MWOB

Small Business Risk Insight (SBRI) is a D&B product offering, which addresses the needs of financial institutions extending credit to small businesses. The SBRI project involves integrating the data on the loans provided by different banks into one database. Banks data are to be cleaned and enriched with DUNS number and be made available for the banks to gather more information on their customers.

The D&B SBRI system extracts the data from mainframe files and converts the data from various banks/institutions into a standard file format with appropriate validation and transformation. A 9-digit Global Business identification number called Duns Universal Numbering system will be obtained from the Acxiom process. Scores will be calculated based on the credit information and processed to the Data mart region.

Role and Responsibilities

Providing on Call Production Support for SBRI applications

Lights-on maintenance and support of SBRI Application.

Requirements gathering from Business Users and stake holders

Translating functional requirements to technical requirements.

Enhancements to the SBRI application to fulfill Business needs.

Designing the requirement and share with Offshore team

Working on SBRI Enhancements (Coordinating and implementing) requested by Business Users.

Involved in performance tuning of application by identifying the bottle neck areas.

Optimization of the environment by conducting periodic performance tuning activities, streamlining of processes etc.

Involved in addressing the questionnaires raised by the business and in resolving the priority tickets

Project #3

Title ODS/EDW Support.

Client Charter Communications

Tools Informatica 9.0.1, UNIX

Database Oracle 10g, Terradata

Team Size 6

Role Team Member

Period July 2013 – Dec 2013

Location St. Louis, MO

Project Description

ODS/EDW Support

CSG is the source of customer’s billing and service related Information to the Operation Data Store (ODS) and then processed to the Enterprise Data Warehouse (EDW) for meeting analytical reporting needs. Allant is another source which provides Demography information to the ODS and EDW Account Hierarchy ADS, Avaya, Engineering eQA, Budget Khalix, Aurora/Sigma, Org Hierarchy and Data Standards are the other internal source system which contributes minimal source information to these operational systems. Customer Care, Technical Operations, Field Operations, Financial Operations, Product Support, Marketing are the key business user groups which are using Enterprise Data Warehouse generated reports for internal planning and analysis.

Client Description

Charter Communications, Inc. is a Fortune 500 company and the fourth-largest cable operator in the United States. Charter provides advanced video, high-speed Internet, and telephone services to approximately 5.8 million residential and business customers in 29 states. With more than 1.8 million telephone customers, Charter is the 10th largest provider of landline telephone service in the nation. Charter Telephone® product offers exceptional sound quality and reliability, as well as popular calling features.

Role and Responsibilities

Providing on Call Production Support for the Charter ODS/EDW Environment

Lights-on maintenance and support of EDW Application.

Requirements gathering from Business Users and stake holders

Working on EDW Enhancements (Coordinating and implementing) requested by Business Users.

Translating functional requirements to technical requirements.

Enhancements to the EDW application to fulfill Business needs.

Designing the requirement and share with Offshore team

Involved in performance tuning of application by identifying the bottle neck areas.

Project #4

Title MaxCV Trade ETL Support.

Client Dun and Bradstreet

Operating System Windows XP

Tools Informatica 8.6.0, UNIX

Database Oracle 11g

Team Size 5

Role Team Member

Period March 2013 – Jul 2013

Location Chennai - India

Project Description

MaxCV DSC Program – Trade

MaxCV DSC Program is a development project which is to establish one global trade environment by leveraging the current Trade Warehouse and process flows. The new Trade repository will cover US, Canada, and Europe* and will support legacy product views and enable rapid new products & services using the details. The ultimate goal is to reduce the time taken to process the data and to deliver the reports in time, sync the database available around, reduce the redundant data.

Role and Responsibilities

Involved in the production support activities

Involved in performance tuning of application by identifying the bottle neck areas

Created some value-added scripts to automate the process to avoid the manual intervention

Involved in addressing the questionnaires raised by the business and in resolving the priority tickets

Involved in unit and integration test case execution for the change requests

Project #5

Title MaxCV Trade ETL Development.

Client Dun and Bradstreet

Operating System Windows XP

Tools Informatica 8.6.0, UNIX

Database Oracle 11g

Team Size 5

Role Team Member

Period Jan 2011 – Feb 2013

Location Chennai - India

Project Description

MaxCV will maximize customer value through the most useful, complete business information available through the most innovative products, delivered on the most flexible technology. The new Global Data Supply Chain will transform the way D&B collects and processes commercial data and makes it available to customers. It will replace the multiple data supply chains that currently operate at D&B with a single enterprise-wide data supply chain that will replace, adapt, decommission existing technology assets, whilst adhering to an aligned architecture and set of design principles, which will take the best from D&B’s existing intellectual property and combine it with industry leading concepts and strategies. The Global Data Supply Chain will be the single source of truth for all D&B’s global POA product platforms will effectively interface with parallel MaxCV work streams to provide world class data quality and accessibility to our customers.

Role and Responsibilities

Lead R1, R2 team during development phase

Involved in all Phases of the development project in R1 & R2

Trained the new team members with Trade Knowledge

Proposed new logics to handle the business requirements

Coordinated with team to deploy the deliverables in estimated duration

Prepared estimates for new projects

Prepared SoW for the projects

Involved in reviews

Involved in the development of complex modules

Involved in developing various reusable components for the application

Project #6

Title HR Data Warehouse (ODS) and downstream systems

Client Merck

Operating System Windows XP

Tools Informatica 8.1, UNIX

Database Oracle 10g

Team Size 5

Role Team Member

Period Dec 2008 – Dec 2010

Location Chennai - India

Project Description

Informatica is being utilized to transfer data from the external sources to the Staging Area and then into the Operational Data Store (ODS). External sources include the other PeopleSoft instances (Latin America/Asia Pacific/United States, Canada, and EMEA) and flat files (i.e. Looking Glass, CAPS, Tesseract). The ODS is refreshed every weeknight, with additional processing on Saturdays. The Post process starts automatically when ODS data refresh completes. Downstream systems start automatically when the ODS Audits complete successfully. On the weekend, the VC_Award process, Corp Init process will start automatically when the Post Process is complete on the weekend HR Decision Support Reporting Tool Data Mart process will start automatically when the ODS Audits complete successfully. Data Marts are the data elements containing information pertaining to headcount, actions, service, diversity, compensation, and education for Merck employees worldwide.

Client Description

Merck is a global pharmaceutical and chemical enterprise with around 40,000 employees in 67 countries. With the acquisition of Millipore in July 2010, a global leader in the life science tools market, revenues totaled around EUR 9.3 billion in 2010.

The Pharmaceuticals business sector comprises innovative prescription drugs as well as over-the-counter products. The Chemicals business sector offers specialty products for the electronics, printing, coatings, cosmetics, food, pharmaceutical and biotech industries.

The operational business is managed under the umbrella of Merck KGaA headquartered in Darmstadt (Germany). Around 30% of the company’s total capital is publicly traded, while the Merck family owns an interest of about 70% via the general partner E. Merck KG.

Merck is the world’s oldest pharmaceutical and chemical company – its roots date back to 1668.

Role and Responsibilities

Requirement Analysis.

Involved in developing various reusable components for the application.

Involved in application performance tuning and memory management.

Involved in unit and integration test case execution.

Involved in Client Interaction, implementation and Production support.

Project #7

Title Training Information System (TIS)

Client Merck

Operating System Windows XP

Tools Informatica 8.1, UNIX

Database Oracle 10g

Team Size 4

Role Team Member

Period Jul 2007 – Nov 2008

Location Chennai - India

Project Description

The System is meant for automating and standardizing the operations of Training Integration System (TIS) component of the Human Resources Global Data Warehouse. PeopleSoft's ERP system provides an effective means for global data collection. The ERP system’s Training module gathers information about Merck's training details with information pertaining to courses, sessions, vendors, instructors, programs, training attendance and session-instructor related details. It then provides users with powerful multidimensional reporting capability through the various reporting tools. This project is an add-on to the existing system and will serve as the source for TIS reporting.

Client Description

Merck is a global pharmaceutical and chemical enterprise with around 40,000 employees in 67 countries. With the acquisition of Millipore in July 2010, a global leader in the life science tools market, revenues totaled around EUR 9.3 billion in 2010.

The Pharmaceuticals business sector comprises innovative prescription drugs as well as over-the-counter products. The Chemicals business sector offers specialty products for the electronics, printing, coatings, cosmetics, food, pharmaceutical and biotech industries.

The operational business is managed under the umbrella of Merck KGaA headquartered in Darmstadt (Germany). Around 30% of the company’s total capital is publicly traded, while the Merck family owns an interest of about 70% via the general partner E. Merck KG.

Merck is the world’s oldest pharmaceutical and chemical company – its roots date back to 1668.

Role and Responsibilities

Requirement Analysis.

Involved in developing various reusable components for the application.

Involved in unit and integration test case execution.

Involved in Client Interaction, implementation and Production support.

Involved in the work load estimation of all the change on requests.

Mobile: +1-314-***-****

Karthikeyan Vellaisamy

Lead Technical Engineer – DW&BI

E-Mail: *******.****@*****.***

Contact this candidate