Sign in

Project Sales

Bengaluru, Karnataka, India
May 30, 2018

Contact this candidate



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


Masters in Computer Science


Vellore Institute of Technology, Vellore, Tamil Nadu, India

Year of passing



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


Job Scheduling Tool – Tertiary Skill


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


Blue Shield of California, USA



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.


18 months


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


Penn National Gaming Inc, USA


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.


6 months



Key Achievements

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

Previous Project Experience – CTS – Project I


Dun and Bradstreet Corporation, USA


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.


24 months



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


CFA of Nicholas Piramal India Limited, Bangalore, India


Pharmaceutical Manufacturing and Marketing

Expertise In

SAP – ERP Package for Sales Order Processing.

Sales and Distribution module.


57 months


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


Passport Information

Holding a valid Indian Passport. Valid till 2022.

Contact this candidate