RUPINDER PAL SINGH
MOBILE: +91-9176338989
EMAIL :
saini.rpsingh@gmail.com
CAREER OBJECTIVE
To raise my ability to implement Data Warehouse Design and Solutions that decrease effort, Maximize
Usage that positively affects the Clients Performance.
PROFESSIONAL SUMMARY
Working as Programmer Analyst with Cognizant Technology Solutions from 11 March 2015 to till date.
Worked as Programmer Analyst Trainee with Cognizant Technology Solutions from 10 March 2014 to
10 March 2015.
Worked as Software Trainee with BytesBrick Systems Private Limited from 1 Feb 2013 to 10 Feb 2014.
Total 3 years of IT exposure.
2 years experience in ETL Development, Support and Enhancement.
Proficient in Data warehousing Technologies.
Knowledge in Healthcare Sector.
Good in Analytics, Programming and Debugging.
Proactive approach to E2E Data Warehouse Life Cycle.
Involved in implementing the end to end ETL Life Cycle.
Worked in all the Phases of SDLC including Development, Testing, Support and Enhancement.
Cleared Level-I & Level-II of Oracle Enablement under Cognizant Internal Certifications
A good team player with Excellent Communication Skill and has an ability to work in a Team and
individual environment
TECHNICAL SKILL SET
Programming Languages - Java, Oracle PL/SQL.
ETL Tools - Informatica Power Center, Informatica Developer
Databases - Oracle SQL Developer, Microsoft SQL Server.
Operating Systems and File Systems - Windows, UNIX
EDUCATION
B.Tech (Information Technology) from PTU , 2008-2012 (CTINSTITUTE OF TECHNOLOGY)
10+2 from CBSE, 2008 (S.S. MOTA SINGH SR. SEC. MODEL SCHOOL, NEW DELHI)
10th from CBSE, 2006 (S.S. MOTA SINGH SR. SEC. MODEL SCHOOL, NEW DELHI)
ACADEMIC SUMMARY
B.TECH pass out with zeal to grow in the field of software development
Good knowledge of programming in C++ and core Java
Attended ORACLE WORKFORCE DEVELOPMENT PROGRAM Introduction to oracle 9i
Actively took part in Technical Fest and been part of Organization Team
Good in Athletics and represented in the college Basketball Team.
Self-motivated professional with strong communication skills and an ability to learn new things quickly
PROJECT DETAIL
PROJECT : 1 (C URRENT PROJECT)
C LIENT: DENTAQUEST
30
Team Size :
PROJECT TITLE : WW to D2I Data Migration
The vision is to upgrade the current infrastructure (Stored procedures to Informatica), enhance data
management and warehousing capabilities, to support the current and future analytical & reporting needs
for the business. Centralized data warehouse and BI platform can potentially cater to all of the
organizations analytical needs
ROLES & RESPONSIBILITIES
Involved in implementing the end to end ETL Life Cycle.
Understanding the requirements from Customer.
Translating the requirements into High Level and Low Level Designs.
Created Source to Target mapping sheets as per the Design Documents
Preparing Migration Documents.
Performed the sanity check after Migrations.
Involved in code peer review.
Unit testing of all the ETL Components.
Validation of data both pre and post load.
Coordinated with the ETL testing and development team to fix the issues.
ENVIRONMENT
Informatica 9.6.1 ETL Tool
SQL SERVER 2012
PROJECT : 2
YEAR : 2014-2015
C LIENT: HORIZON BCBSNJ
20
Team Size :
PROJECT TITLE : IDS Support
The IDS Support is to make sure that the daily jobs are processed and ran on the said timelines, analyze the
occurring issues and identify their root cause. This project is to implement CRs on existing modules.
ROLES & RESPONSIBILITIES
Monitoring of production loads
Resolution of production issues in a limited time
Root cause analysis of repeated issues and providing the resolution for the same
Development activities which involves creation of temporary mapping to remediate large no
of records
Maintaining of IM Tracker to track Effort, SLA, Root Cause, Categorization of issues,
Generating reports, etc.
Review of every code which is going to be migrated to production
Performance tuning if any loads are taking more time than expected
ENVIRONMENT
Informatica 9.1 ETL Tool
Oracle SQL Developer
Core FTP (UNIX)
PROJECT : 3
YEAR : 2013-2014
C LIENT: Mega Telematics Pvt. Ltd
Team Size : 4
PROJECT TITLE : www.Megatracker.co.in
Morning SMS Reporting Cron: This Listener reports each user for their Vehicle's location fitted with
GPS device.
Daily Summary Reporting Cron: This Listener reports each user for their Vehicle's Daily Summary
including full detail like Total Km Travelled, Start point , End point and number of parkings etc.
Expiry Handler Cron: This cron is responsible for finding those users whose account is going to
expire soon. And notify via SMS and Email.
ROLES & RESPONSIBILITIES
Designing the approach.
Development activities using NetBeans IDE tool.
Self Review of Code and Testing with bug fixes.
ENVIRONMENT
NetBeans IDE 7.1
Oracle SQL Developer
STRENGTH
Active and Quick Leaner
Practical
PERSONAL INFORMATION
NAME
DATE OF BIRTH
NATIONALITY
GENDER
LANGUAGE PROFICIENCY
Rupinder Pal Singh
6th March 1990
Indian
Male
English, Hindi, Punjabi
DECLARATION
I hereby declare that the above-mentioned information is correct up to my knowledge and I bear the
responsibility for the correctness of the above-mentioned particulars
DATE :
(Rupinder Pal Singh)
