Objective

Seeking an Information Technology career under Data Integration or Data-warehousing space where my technical and analytical skills can be utilized to build or maintain information systems.

Experience Summary

Total IT Experience

51 Months

Total Non-IT Experience

57 Months

Previous Employment – I

Worked for Cognizant Technology Solutions, India

Period: From September 2009 – December 2013

Designation: Associate

CTC: 5.85L INR P.A

Previous Employment - II

Worked for a CFA of Nicholas Piramal India Limited, Pharmaceutical distribution company in EDP department, Bangalore, India

Period: From September 2001 - June 2006

Designation: EDP staff- Team Lead

Educational Qualification

Degree

Masters in Computer Science

University

Vellore Institute of Technology, Vellore, Tamil Nadu, India

Year of passing

2008

Grade

9.37/10.0 CGPA

Skill set

Technical – Primary Skill

Informatica (Versions - 8.1.1, 8.6.0, 9.0)

Technical – Secondary Skill

Oracle 10g SQL and PL/SQL

Scripting – Secondary Skill

Unix

Job Scheduling Tool – Tertiary Skill

Control-M

Other Secondary Skills

Team Handling

Project Management Activities

Client Interaction

Job Responsibilities Previous Experience–Cognizant Technology Solutions

ETL Activities:

Prepare an estimation document for the Business Request or Change Request.

Prepare a Plan and Business Request Analysis document and Interface Design Document.

Identify the Control-M or Tidal jobs that are needed to run the interface and accommodate them in the design document.

Review the design document with the on-site team and accommodate the review comments.

Develop Informatica mappings with respect to design document.

Develop Unix script coding for the input file validations.

Develop Unix Script to generate parameter file and call the workflow for execution.

Physical Database Table creation. Procedure/Function creation or alteration. Other database changes

Run unit & integration test-cases and capture logs for the developed objects.

Amend the code review comments and generate code quality report.

Preparing objects build for the higher environments.

Run smoke test-cases in QA.

Implementation of the Business or Change Request and support.

Project Documentation.

Project Management Activities:

Create the project package in Cognizant2.0 (Company Internal Tool).

Prepare/Create project plan.

Create Tasks for Team Members.

Track tasks and log defects and project risk.

Generate Project Progress report.

Attend periodic Project Audits.

Update audit results in Cognizant2.0 (Company Internal Tool).

Previous Project Experience – CTS - Project – III

Client

Blue Shield of California, USA

Domain

Healthcare

About the Client & Project

BSC is one of the leading Health Plan Provider Organization in the US.

This project is a development project where we developed different interfaces to extract data from the FACETS application, cleanse them through the ETL process and load them to flat files or tables for subsequent processing.

Duration

18 months

Role

Senior Developer

Key Achievements

Developed a mapping to split multi-valued attributes to separate rows.

Developed a mapping to remove duplicates from the input source file.

Previous Project Experience – CTS – Project II

Client

Penn National Gaming Inc, USA

Domain

Information Media and Entertainment

About the Client & Project

PNG is one of the leading gaming companies in the US. It owns casinos and race tracks in the US.

This is a development project where we integrated PNG’s new casinos into its operational data-warehouse.

This project extracts data from the MS SQL Server source with respect to gaming day and creates a flat file target. The data from the flat file is loaded to the stage, along with this data from the error table is loaded. Then the load continues to load the stage data to work table which is subsequently loaded to the target table.

Duration

6 months

Role

Developer

Key Achievements

Successfully Integrated the Kansas and Toledo Casinos into the existing Data-warehouse

Previous Project Experience – CTS – Project I

Client

Dun and Bradstreet Corporation, USA

Domain

Information Media and Entertainment

About the Client & Project

D & B is a US based information company. The merchants across US utilize the data-warehouse of D & B to make effective business decisions.

This project had a maintenance stream where we receive change requests from the business team.

This project also had a development stream where we integrated the Canada and Europe data into its existing data-warehouse which had US data alone.

Duration

24 months

Role

Developer

Key Achievements

Re-built an Oracle Stored Procedure with effective Performance Improvement compared to its previous version. This is a Team Work.

Design and Development work of Canada and Europe data.

Delivered objects well in-time and coordinated effectively with the teams.

Project Experience - CTS

Internal Training - CTS

3 months

Previous Experience

Company

CFA of Nicholas Piramal India Limited, Bangalore, India

Domain

Pharmaceutical Manufacturing and Marketing

Expertise In

SAP – ERP Package for Sales Order Processing.

Sales and Distribution module.

Duration

57 months

Role

EDP Staff – Team Lead

Job Responsibility

Process sales orders received from the distributors.

Issue goods return note for the expired and non-expired stocks returned by the distributors.

Make accounts payment inward from the distributors.

Make goods receipts inward from the manufacturing unit.

Make goods transfer note to other depots within the company.

Generate monthly reports for different sales regions and managers.

Managing the inventory.

Personal Information

Father’s Name

Raman. K

Residing Address

Apartment No:106, K & T SOBHA Nilayam, Bettadasanapura Road, Near Munieswaran Temple, Dodda Thogur, Electronics City, Bangalore-560100

Date of Birth

29-07-1980

Passport Information

Holding a valid Indian Passport. Valid till 2022.

Contact this candidate