|PROFESSIONAL SUMMARY: |
• Over all 3 Plus years of experience in data warehousing project using of datastage, quality stage and oracle.
|KEY SKILLS: |
• Experience working with Data Stage 7.x/8.x (Parallel Extender) as an ETL to Experience in design & development of Decision Support Systems (DSS).
• Involved in designing, developing, performance tuning, debugging, troubleshooting, and monitoring ETL jobs using DataStage Designer, Director, and Manager.
• Good understanding on SDLC’s of datawarehousing project.
• Have good knowledge on understanding the requirements,S-T mappings and Technical design Documents.
• Involved in Peer reviews, test case preparation-execution and proactively initiated brain storming sessions to produce the best solutions.
• Very much experienced in developing Datastage Jobs for various complex scenarios from source to till warehouse with best throughput performance.
• Experience in developing custom routines/scripts to simplify the determination of data output paths for complex business logic.
• Ability to work in team as well as independently.
• Knowledge on tuning Datastage parallel stage like source,sort,join,lookup..etc
The Essay on System Elements-Data Roles In System Development
The design of a system varies in response to the expected audience for the perticulare application. Some systems are intended for back rooms, some for the front office, and some are for the general public. They are designed for technical users, others for end users. Some are intended to work standalone in real-time control applications, others for an environment of timesharing and pervasive ...
• Good understanding on Unix commands and using them in DWH solutions.
|PROFESSIONAL EXPERIENCE: |
Working as Software Engineer for ELVIS SOFT from jan-2008 to till date.
|TECHNICAL CAPABILITY: |
|ETL Tools |DataStage 7.x/8.x (Parallel Extender) |
|Databases |Oracle 10g/9i, SQL Server 2000 |
|Languages |SQL, PL/SQL, UNIX |
|Operating System |UNIX AIX, Windows |
|Other Tools |TOAD, SQL Developer, SQL *Plus, Autosys, Control-M |
|EDUCATION DETIALS : |
• Bachelor of Science (Computer Science) from Andhra University of Vishakhapatnam.
|PROJECTS SUMMARY : |
|Project 1 |Citi bank |
|Client |Citi Bank |
|Organization |Virtusa |
|Duration |May ’10 to Till date |
|Environment |Data stage 8X, Oracle, Windows XP, unix |
The Term Paper on Data flow diagram 2
Note: For multiple-choice questions, select the best answer. Incorrect answers will be marked as zero. No marks will be awarded for any explanations you may offer. Multiple choice (2 marks each) a. Under what condition would you be more likely to recommend a prototyping approach to systems development as opposed to a waterfall approach? 1. For a large system with multiple integration points to ...
Description:
Citi Bank is a leading bank in US having more than 120 local offices. They have number of Customers operating in various parts of the country. Like every (international) fast growing bank. The development of data warehouse is linked to the business needs of an enterprise. The bank has a need for analytical data warehouse to improve the decision-making. Currently we have been involved in this project, with consolidating the company’s data from different operational sources, data marts and then transforming and loading it into a centralized data warehouse for various business reports.
Responsibilities:
• Involved in Data Extraction, Staging, Transformation and Loading
• Developed the ETL logic using Data Stage to enable initial load and incremental processing and exception handling, restart ability and recovery, data cleanup, validation and monitoring.
• Captured Data from variety of sources including sequential file.
• Used Sequential / Datasets Stages depending on the requirement and layout for parallelism of data.
• Used Join/Merge/Lookup Stages to replicate integration logic based on the volumes of the data.
• Used Most of the Other Parallel Stages like Row Generator, Column Generator, Modify, Funnel, Filter, Switch, Aggregator, Remove Duplicates and Transformer Stages etc extensively.
• Import metadata from various sources like flat files, Databases.
• Extensively used Datastage Director utility Monitor and debug Datastage code.
• Prepared unit test, integration test, and performance test plan documents. Performed unit test, integration test, and performance test and documented test results.
|Project 2 |Ford Motor Company |
|Client |Dearborn, MI |
The Term Paper on Big Data in Companies
Big data (also spelled Big Data) is a general term used to describe the voluminous amount of unstructured and semi-structured data a company creates — data that would take too much time and cost too much money to load into a relational database for analysis. Although Big data doesn’t refer to any specific quantity, the term is often used when speaking about petabytes and exabytes of ...
|Organization |virtusa |
|Duration |Jan ’09 to April ’10 |
|Environment |Data stage 8X, Oracle, Windows XP, unix |
Description:
F@ST (Finance @ Speed of Thought) project in Ford Motor Company is a warehousing of financial related data. The primary objective of the project is to develop Decision Support System (DSS) system making extensive use of Data marts. The objective is to pull Vehicle related financial data based on unique vehicle identification number (VIN) from different sources and load into oracle DS and then into data warehouse..
Responsibilities
• Developed the ETL logic using Data Stage to enable initial load and incremental processing and exception handling, restart ability and recovery, data cleanup, validation and monitoring.
• Captured Data from variety of sources including sequential file.
• Used Flat File, Datasets Stages depending on the requirement and layout for parallelism of data.
• Used Join/Merge/Lookup Stages to replicate integration logic based on the volumes of the data.
• Used Most of the Other Parallel Stages like Row Generator, Column Generator, Modify, Funnel, Filter, Switch, Aggregator, Remove Duplicates and Transformer Stages etc extensively.
• Import metadata from various sources like flat files, Databases.
• Extensively used Datastage Director utility Monitor and debug Datastage code.
• Prepared unit test, integration test, and performance test plan documents. Performed unit test, integration test, and performance test and documented test results.
|Project 3 |TCOMS (Total Circuit and Order Management System) |
|Client |Verizon, Ashburn, VA |
|Organization |ELVIS SOFT |
The Essay on Team Data Collection
BIMS, Ballard Integrated Managed Services, Inc. is a corporation specializes in the services of food and housekeeping to corporations and institutions. The general manager, Barbara Tucker, has noticed that over the last four months the turnover rate has shot up to 64%. Not only is the turnover rate higher than usual, but also employees seemed unmotivated to do their job. There are more employees ...
|Duration |Jan ’08 to Dec ’08 |
|Environment |Data stage 7X, Oracle, Windows XP, unix |
Description:
TCOMS is the local provisioning order database used to enter provision and track customer orders to completion. TCOMS allows the user to access all information relating to customer orders for local circuits. This information can be accessed by several search types and is able to provide a wide variety of information, even when only one piece of reference data is available.
Responsibilities
• Developed the ETL logic using Data Stage to enable initial load and incremental processing and exception handling, restart ability and recovery, data cleanup, validation and monitoring.
• Captured Data from variety of sources including sequential file.
• Used Flat File, Datasets Stages depending on the requirement and layout for parallelism of data.
• Used Join/Merge/Lookup Stages to replicate integration logic based on the volumes of the data.
• Used Most of the Other Parallel Stages like Row Generator, Column Generator, Modify, Funnel, Filter, Switch, Aggregator, Remove Duplicates and Transformer Stages etc extensively.
• Import metadata from various sources like flat files, Databases.
• Extensively used Datastage Director utility Monitor and debug Datastage code.
• Prepared unit test, integration test, and performance test plan documents. Performed unit test, integration test, and performance test and documented test results
(Srinivas Rao)