Thursday 17 November 2011

Resume Format and Content for 3 years


UmaPrabhakar Panatula                                       Email:panatulaaprabhaakar@gmail.com
   Mob:  +91 – 9848642429
Professional Summary:

o     


 
Around 3.7 years of experience in IT industry as a Software Engineer in implementation of Data warehousing projects with Teradata as Developer.

In my tenure worked and working with various documents like Source Map, Source to Target, LLD, Change Request (CR), Unit Test and Defect Sheet docs according to the project.  Worked on various Teradata versions V2R5, V2R6 and TD12.

Created and modified many scripts of BTEQ,FAST LOAD,MULTI LOAD according to the
business demand with the given transformation or business logics.

Identifying long running queries, scripts, Spool space issues etc..., implementing appropriate tuning methods.

Observed the usage of SI, JI, HI, PPI, MPPI and compression on various tables.

Did data reconciliation across source systems ,tables and files by firing various queries
and by using different Unix commands(WC,LS,GREP,PS,CAT,VI,MV,CP,TEE,SHED,CUT etc).

Reporting errors in Error tables to client, rectifying known errors and running the scripts.

Following the given standard approaches while restarting and error handling.

Worked with Explain Command and identified Join strategies, issues  and bottlenecks.

Written Unit Testcases and submitted Unit test results as per the quality process.

Maintained versioning in VSS, and used various Configuration Files , Shell scripts while running scripts.

Knowledge on Teradata 13 architecture and components (Virtual Storage System, NOPI,
Temporal table, PERID data type, View Point features)

Little experience and good knowledge on FastExport, TPUMP, TPT (Teradata Parallel Transporter), OLELOAD etc...

Good understanding in Datawareshouse and Dimension modelling concepts (Star, Snow flake).


Professional Experience:

Period

Organization

Designation

Feb-07 to till date

Cognizant Technology Solutions. Chennai
Associate

Achievements:

  • Had got awarded with WAH points for the best performance in project.
  • Got promoted to Associate in 3 years of experience in cognizant.
  • Had trained other associates in Teradata at Cognizant Academy.

Certifications:

  • Teradata Certified Professional.
  • Brain Bench Certifications in Teradata and Datastage.

Other Technical Skills:


Areas of Expertise

ETL Tools

Datastage PX 7.5
Operating Systems
Windows,Unix
Secondary Skills    
Datastage, Oracle, Unix shell scripting


Educational Qualifications:

Title Of Course

University/Institution

Year

B.Tech – Electronics & Communication Engineering
J.N.T.UNIVERSITY, Hyderabad/ A.I.E.T
2007


PROFESSIONAL EXPERIENCE/ RECENT ACCOMPLISHMENTS:

Project
Mrdp Conversion
Role
Teradata Developer
Client
Hartford Life
Environment
Teradata12, Datastage 7.3 , Unix
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 involved in getting docs (which are kept in Sharepoint Server), understanding, analysing docs, writing scripts (BTEQ,FL,ML) and queries according to those.
·         In case of changes we follow CR document procedure of the client
·         I prepared several types of documents (Technical, Unit test) required for the project.
·         Different types of Data Loading (Direct, Incremental, SCD Type2  et...) implemented using scripts and used configuration files.
·         Handled, reported errors in error tables.
·         Observed the Execution plan and suggested Collecting statistics and various types of indexes (SI , JI).
·         Writing various queries (duplications, tops, aggregate operations etc...) as part of reconciliation and business logics Validation.
·         Executed utility scripts by keeping in shell scripts and used various commands (wc, ls, grep, ps, kill,$? etc..) during process.
·         Maintained versioning in PVCS with appropriate comments.
·         Performance tuning of scripts when necessary.
·         Woking experience with UltraEdit, Putty, Sql Assistant , PVCS, Sharepoint Server, RDC ,Citrix etc...

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 scripts and written many queries to load the ODS database.
·         Used to identify Multiple Open and Multiple Closed records , reporting, following the defined steps to eliminate.
·         Loading data to stage database by using FL.
·         Conducting Unit test cases according to unit test plan
·         Traced the error tables, unique violation tables, log tables, work tables to provided restart table.
·         Identifying long running queries, scripts and resolving bottlenecks.
·         Used Fast Export scripts for exporting to flat files.
·         Release meetings with Client’s CAB (Change Approval Board) to detail the changes going in to a release and get the approval for implementing the changes.
·         Co-ordinating with the business users to help them out in solving the skew problems, spool space problems and data issues.



                                                                                                                 (P.Uma Prabhakar)