Rupesh Madhabhakthula Email: raj0734@gmail.com
Mob: +91 – 9652189312
Objective: |
To pursue a responsible and challenging career as professional in a reputed organization where I can contribute for the development of the organization and also to improve my skills.
Professional Summary: |
o | Having 3.4 years of experience in IT industry as a Software Engineer in implementation of Data warehousing projects as Datastage Developer. |
Provided great contribution in all the offshore projects, and provided great assistance to onsite. | |
Designed the jobs to load the data into the target based on primary, foreign key relationship(incremental load is used). | |
Designed the jobs to implement the incremental load. | |
Designed a job to parse xmls from a stage using xml parser stage. | |
Involved in Unit Testing of jobs. | |
Involved in developing the system test cases for system testing. | |
Strong ability to work individually and constantly in challenging environment. | |
Ability to lead and problem solving the team towards to achieve project targets. | |
Ability to produce high quality work at high professional level and complete tasks accurately on schedule. | |
Self - motivated team player capable of quickly learning and delivering solutions with strong technical and analytical skills and attention to detail. |
Certifications |
Web Sphere IIS DataStage Enterprise Edition V7.5 Teradata Basics V2R5 NR0-011 |
Professional Experience:
Period | Organization | Designation |
Feb-07 to till date | Cognizant Technology Solutions. Chennai | Associate |
Technical Skills:
Areas of Expertise | |
ETL Tools | Datastage PX 7.5 |
OLAP | Hyperion Financial Reporting |
Operating Systems | Win95/98/NT/2000,Unix |
Secondary Skills | Oracle, Teradata, Unix shell scripting |
Trainings |
|
Educational Qualifications:
Title Of Course | University/Institution | Percentage |
B.Tech – Electronics & Communication Engineering | ||
Intermediate | ||
SSC |
Achievements: |
|
PROFESSIONAL EXPERIENCE:
Project | Mrdp Conversion |
Role | ETL Developer |
Client | Hartford Life |
Environment | Datastage Parallel Extender Version 7.5.3, SqlPlus |
Description | · The existing MRDP reports generation by oracle reports is to be replaced by the datastage jobs. There are several translations that should be set for each customer based on the customer id assigned to each customer. The translation files are created from EMS process, which has also the schedule job master file created. Totally there 60 reports that needed to be created by this process. The process runs on a daily basis. |
Responsibilities: | · As an Associate I developed several datastage jobs to load the ODS database. · I produced both high-level and detailed business requirements for work/project requests, develop test plans, and research issues. · I prepared several types of documents required for the project. · Used stages like Oracle, lookup, joins, sequential files, datasets, sort, etc · The source system is DMP database, which is an oracle database · Used small reusable routines for the jobs. · Performance tuning of Datastage jobs when necessary. |
Project Name | Reinsurance |
Role | ETL Developer |
Client | Travelers Insurance |
Technology | Datastage Parallel Extender Version 7.5.2, Oracle |
Description | · The existing mainframe systems are to be replaced by the Datastage jobs. These Datastage jobs will migrate the data from different databases DB2,ODS(refernces) to ODS business areas. The load is an incremental load process. The process runs on a daily basis. |
Responsibilities: | · I developed several datastage jobs to load the ODS database. · I produced both high-level and detailed business requirements for work/project requests, develop test plans, and research issues. · I prepared QA move and other documents required for the project · Used stages like Oracle, lookup, joins, sequential files, datasets, sort, etc · Conducted Unit testing. · Performance tuning of Datastage jobs when necessary. |
Project Name | Hyperion Conversion |
Role | Developer |
Client | HanOver Insurance Group |
Environment | Hyperion Financial Reporting |
Description | The purpose of this project is to migrate the existing BO reports to hyperion, by making a few changes and also to create 2 new reports in Hyperion. These reports are to created in Hyperion Financial Reporting studio and should be accessible through Workspace in PDF. Different versions of reports should be formed as books. |
Responsibilities: | · As an associate I produced both high-level and detailed business requirements for work/project requests, develop test plans, and research issues. |
Project Name | AllStatePwxml |
Role | Developer |
Client | CCC Insurance |
Environment | Data stage Parallel edition 6, UNIX |
Description | · AllstatePwxml project is about receiving the xmls from MQ stage and then processing it through the datastage jobs. The primary challenge in this project is to receive the xmls with modified header, and then parse the xmls and write the data to different files. The files are then loaded into different dimensional tables in RedBrick database using TMUs. The process runs on a daily basis. |
Responsibilities | · As a developer I designed jobs to load the RedBrick database from the Xmls. · A few scripts are also created to load the tables. · Used stages like Oracle, lookup, joins, sequential files, datasets, sort, xml parser stage etc · Here the structure is a snowflake schema. · Performance tuning of Datastage jobs when necessary. |
Project Name | STA - Claims MI Development |
Role | Developer |
Client | Travelers Insurance |
Environment | Data stage parallel edition 7.5.2, Teradata, Unix, DB2 |
Description | · The purpose of this project is to load the Oracle tables from the existing DB2 tables. This is a weekly load process. There is also some historical data which needs to be load at an instance(one time process). The process runs on a daily basis. |
Responsibilities | · As a Developer, I designed jobs to load the Oracle database from the DB2 tables. · I also gave the idea of the design to the junior members of the team, so that they could also develop the required jobs. · Used stages like Oracle, lookup, joins, sequential files, datasets, sort, xml parser stage etc · Performance tuning of Datastage jobs when necessary. |
Project Name | STA - Claims OPMI to Teradata |
Role | Developer |
Client | Travelers Insurance |
Environment | Data stage parallel edition 7.5.2, Teradata, Unix |
Description | The purpose of this project is to migrate the Claim Operational Management Information (OPMI) database and its supporting near real time ETL processes from the Microsoft .Net/SQL Server database platform to the DataStage/Teradata platform. Also the existing data from SQL Server database must be loaded into the Teradata database. |
Responsibilities | · I analysed the existing system for implementing the same in our new process. · As a developer I developed Preload jobs to load data into the OPMI5 Teradata database tables by extracting the data from SQL Server tables. · I also developed ETL jobs to load data into the OPMI5 Teradata database tables by processing the host MQ messages. For ETL load jobs, the process in general mimics the data processing logic of already existing .Net based refresh utility and SQL Server stored procedures into Data Stage ETL process. · Involved in handling change requests and enhancement of the existing ETL change for version changes. · I have become a critical resource in the project in no time, actively contributing all the above mentioned activities like design, development, peer reviews and unit testing. · Used stages like Oracle, lookup, joins, sequential files, datasets, sort, column import & Export , filter , copy etc · Performance tuning of Datastage jobs when necessary. |
(M.Rajesh)
No comments:
Post a Comment