We provide IT Staff Augmentation Services!

Oracle Developer Resume

2.00/5 (Submit Your Rating)
Hire Now

Education

Bachelor of Computer Science Engineering
Completed 4 year engineering degree course in May 2005

  • Overall aggregate of 70%

Won 1st prize in Intra College IT Crossword as well as in Intra College Website Designing Competition

Summary

  • Around 4.5 years of experience with designing and developing DW/BI applications
  • Good experience in all phases of SDLC from requirement gathering, code implementation to User Testing
  • Extensively worked on Informatica 8.6 and older versions, Cognos Reportnet 1.1 and Cognos 8.x
  • Design, develop and unit test ETLs and cognos reports
  • Experience in HPQC for documenting the test cases
  • Experience in troubleshooting and tuning ETLs
  • Good database and PL/SQL skills
  • Good mentoring and team handling skills
  • Good communication skills and experience in working in onshore/offshore model
  • Strong analytical and problem solving skills

Professional Experience
Confidential
Duration : May, 2007 – May,2010

Confidential
Duration : Mar, 2006 – May, 2007

Technologies

Operating Systems

UNIX, Windows XP

DW/BI Tools

Informatica 8.6 , Informatica 7.x, Cognos 8.4, Cognos Reportnet1.1

Databases

Oracle 9i, DB2 8, SQL server 2005

Development Tools

Source Control:
Maestro, HP Quality Center, MS-VSS 6, SSH
Database: TOAD, QUEST, AQT

Certifications

Informatica : N - PowerCenter 7 Mapping Design

E-Learnings & Trainings

DB2 Basics, Maestro, HP Quality Center, Cognos 8.4,Informatica 8.6

Work Experience

Company

Confidential

Client

Confidential. – USA

Project

CRM Data mart (Oct 08 – May 10)

Role

Senior Software Engineer

Description

This project aimed at developing a mart from the OLTP data from Onyx for sales in Hewitt. Onyx is a website tool wherein all the entire sales process exists. The information including opportunities and services details, customer interactions, information sharing etc. The mart aims at maintaining the history of the OLTP data.
The reports generated are used for sales forecast analysis, sales processing and competitor analysis for targeting new clients.

Solution Environment

Informatica 8.6 and 7.1.3
DB2
Cognos 8.4 and Cognos Reportnet 1.1
Unix
Consoleone

Tools

Maestro, HPQC, AQT, SSH

Highlights

  • Responsible for gathering the requirements.
  • Analysis and preparing High and low level designs
  • Mentoring the less experienced teammates
  • Coding and testing of the ETLs.
  • Creating and analyzing reports in Cognos Report studio.
  • Moving and testing the Code to newer version of Informatica and Cognos
  • Responsible for creating unix scripts
  • Responsible for coordinating with the production support team for running the streams
  • Interacted with client for gathering requirements and for User Acceptance Testing
  • Worked in consoleone and Ice for providing security for cognos users

Client

Confidential. – USA

Project

HR Data warehouse (May 07 – Sept 08)

Description

This project aimed at building a complete warehouse for Hewitt’s employees. This included three data marts - HR, recruitment and Learning Management. The frontend applications were peoplesoft HRMS, Taleo and sumtotal. The HR data mart is used for creating reports related to employees’ transactions, job details, and compensation. The recruitment data mart is used for creating reports related to requisitions and applicants and the Learning Management Mart tracks the associates’ learning and trainings.

Solution Environment

Informatica 7.1.3,
Informatica 8.6,
DB2,
Unix,
Cognos 8.2

Tools

Maestro, HP Quality Center, Quest, SSH

Highlights

  • Responsible for preparing High and low level designs for the team
  • Analysis, coding and testing of the ETLS.
  • Responsible for creating unix scripts
  • Moving the code to Cognos 8.2 from Cognos Reportnet 1.1
  • Responsible for coordinating with the production support team for running the streams
  • Responsible for monitoring and validating weekly and monthly jobs and cube.
  • Providing troubleshooting of the weekly jobs.
  • Responsible for client interaction for requirements and UAT
  • Involved in induction & training of new Team Members

Company

Confidential

Client

Confidential. – USA

Project

Customer Value Creation

Description

Time Warner Cable, as the 2nd largest multiple service provider, owns and manages advanced, well-clustered cable systems in the United States. Time Warner Cable offers cutting edge digital technology, a rich range of home entertainment and information choices for the whole family to enjoy, and superior service that demonstrates customer satisfaction is our number one priority.

This project aimed at re-engineering, maintenance/ development of the data warehouse. The project was about the sales forecast analysis, sales processing and competitor analysis for targeting new clients.

Solution Environment

Informatica 7.1.4,
Cognos 8.2,
Oracle 9i

Tools

MS-VSS, Toad

Highlights

  • Understood the user requirements and designed LLDs
  • Report generation and Analysis
  • Analyzed and re-engineered the ETLs
  • Created code flow documents.
  • Created and tested the ETLs, sessions and workflows.
  • User Support: Enhancements and Bug Fixing
  • Analyzed and tested the cognos reports

Client

Confidential. – USA

Project

CDHP –EDL

Description

WellPoint is the nation's leading health benefits company serving the needs of approximately 35 million medical members nationwide. WellPoint is included in the S&P 500 index. WellPoint is a Blue Cross or Blue Cross Blue Shield licensee in 14 states: California, Colorado, Connecticut, Georgia, Indiana, Kentucky, Maine, Missouri, Nevada, New Hampshire, New York, Ohio, Virginia, and Wisconsin.
The project aimed at developing a repository from the files coming from Lumenos CDHP Repository and moving it to EDL Report Repository. The end product of this data load was reports that helped the senior management to examine the performance of the CDHP products.

Solution Environment

Informatica 7.1.4,
Teradata,
Unix

Tools

MS-VSS, SQL Assitant 6.1

Highlights

  • Understood the user requirements and designed LLDs
  • Analyzed, coded and tested the ETLs
  • Developed unix shell scripts as per the requirement
  • Databalancing with the help of creating procedure in Teradata.
  • Praised by the Project Manager for the excellent work done during delivery phase
Training

Infosys Training

Description

Underwent training in various Software Technologies on Banking Domain on J2EE and HTML platform.

Trainings

  • Core Java, J2EE and JSP
  • Software Development Life Cycle (SDLC)
  • Software Quality
  • Oracle 9i, PL/SQL, HTML,XML, Unix

Interests

  • Taught underprivileged children in the slums in Delhi, India
  • Reading Books
  • Travelling to new places
  • Designing Outfits

Hire Now
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship