Current Location : In Singapore, On Social Visit Pass
EDUCATIONAL QUALIFICATION
Bachelor’s Degree in Mechanical Engineering 2005
SK University, Kurnool, India
TECHNICAL SKILLS
ETL Tools : Cognos8, Business Objects, DataStage 7.5.2 Enterprise Edition, DataStage 7.5 Server Edition
Reporting Tools : Cognos, Business Objects
Languages : C, C++, SQL, PL/SQL
Operating Systems : Win 95/98/NT/2000/XP, Unix
Databases : Oracle 8.i/9.i
Other Tools : TOAD
CERTIFICATIONS
- Quality Management Systems(QMS) Satyam Computer Services Pte Ltd, India
- SQL – OCA Oracle, India
TRAININGS
- Oracle, Unix Training at Satyam Computer Services.
- DataStage Training at IBM in April ‘07.
- Cognos and Business Objects Training at Satyam Computer Services in Feb’08
CAREER SUMMARY
- More than 2 yrs. of experience in Data Stage - ETL Developer and Cognos.
- Involved in Functional and Technical Systems Analysis & Design, Systems, Star Schema, Snowflake, changing dimension and Documentation.
- Developed server and parallel jobs using different types of stages such as Transformer stage, Lookup Stage, Join stage and created the Reports in Cognos according to the requirement.
- Implementation of ETL (Extraction, Transformation and Loading) methodology using DataStage.
- Integration of various Data Sources like Oracle and Flat files into the Staging Area.
- Good knowledge in Database Concepts.
- Strong knowledge in Data warehousing concepts and hands on experience in Data Stage and Cognos.
- Have Good Programming knowledge in SQL, PL/SQL.
- Strong Understanding of Software Lifecycle Methodology.
- Experience in functional analysis, establishing business rules and process flows.
- Excellent User interaction skills.
- Having Good Communication Skills, Can learn new Technologies and Tools quickly.
EXPERIENCE
Mar 06 – Till Date Satyam Computer Services, Hyderabad, India
Software Engineer
Oct 07 – Apr 08
Project 3 GNE (Gulf & Near East) – Secondary Sales Reporting System
Client GSK (Glaxo Smithkline), UK
Team Size 6
Environment Cognos 8, DataStage 7.5.1, Oracle 10g, TOAD, UNIX
Project Description
GNE – Secondary Sales Reporting system is to develop reporting solution for GSK Gulf and Near East (GNE) which would provide easy access and drilled-down capability to retailer level. This is expected to improve the decision making by providing data with multidimensional analysis. The Secondary Sales reporting system is to replace existing excel based reports and provide additional functionality to enhance analysis and reporting capabilities.
Responsibilities
- Designed and Created Reports in Cognos.
- Authored Report Specifications.
- Documented Package Configuration and System test case.
- Involved in Unit Testing and System Testing
Jun 06 – Sep 07
Project 2 DRSF (Data Reporting System Foundation)
Client GSK (Glaxo Smithkline), Ware, UK
Team Size 30
Environment DataStage 7.5 Enterprise Edition (Px), Oracle 10g, TOAD, UNIX
Project Description
GlaxoSmithKline (GSK) is a world leading research-based pharmaceutical company. The Data Reporting System Foundation (DRSF) will provide a system for automatically gathering information from a range of sources by automatic and manual means. This information will be stored, processed and presented to the users of the system in a form that they can readily analyze.
Responsibilities
- Analysis of the specifications provided by the client.
- Developed parallel jobs for extracting, Transforming and loading the required data into Foundation Layer.
- Used Datastage designer to create mappings (jobs) using different types of Stages such as Transformer stage, Lookup stage, Sequential file Stage, Sort stage, Join Stage etc.
- Developed jobs in the Local containers.
- Designed and developed job sequences for parallel jobs according to the requirement.
- Used DataStage director to validate, to test and to monitor the resulting executable jobs.
- Interaction with the onsite team.
- Involved in unit testing by authoring and executing the unit test cases
- Adhered to Quality procedures related to the project.
Jul 06 – Oct 06
Project 1 PMAR (Profit Management Analysis & Reporting)
Client GSK (Glaxo Smithkline), UK
Team Size 16
Environment DataStage 7.5.1, Cognos, Oracle 9i, TOAD, UNIX
Project Description
PMAR (Profit Management Analysis & Reporting) is used for analysis of profit & associated financial details of GSK. The Analysis is done for two establishments of GSK, namely GSKE (Glaxo & SmithKline Exports) and GSKTS (Glaxo & SmithKline Trading Services).
Responsibilities
- Preparing Unit Test Case Documents for Data Stage jobs.
- Preparing System Test Case Documents for Data Stage jobs.
- Reviewing SQL Queries using TOAD.
- Unit Testing for Data stage jobs.
- System Testing for Data Stage jobs.
- Created Simple jobs in Ascential Data Stage.
- Prepared documents for the UAT.
- Checked the Data Integrity in both JDE and Data Stage.
- Created Deployment Document for production support.
COMPENSATION DETAILS
- Currently on 4 Lakhs Indian Rupees per annum, plus Medical for self and parents, plus annual Leave Travel Allowance, and 15 – 25% annual Appraisal.
NOTICE PERIOD
- Available Immediately
