CAREER SUMMARY

 
• Over 11 years of experience in designing,       developing and maintaining IT applications.

 
• Having 8 years of overall Data warehousing experience       in which 7 years of extensive experience in architecting the load and       maintenance of Data Warehouses in Teradata and Oracle

 
• Extensively used tools of MLoad , BTeq , FastExport       and FastLoad to design       and develop dataflow paths for loading transforming and maintaining data       warehouse.

 
• Have strong understanding of Data Warehouse       concepts and well versed with Bill Inmon's 3NF modeling and Ralph Kimball's Dimensional modeling, with Erwin skills.

 
• Proficient in data warehousing techniques for       data cleaning, Slowly Changing Dimension phenomenon, surrogate key       assignment and CDC (change data capture), Audit table, Error Handling       Techniques for ETL process.

 
• Strong expertise in physical modeling with       knowledge to use Primary ,Secondary       , PPI and join Index.

 
• Strong experience in allotting work, guiding and       leading team of developers in on site offshore model

 
• Expertise in building Enterprise Data Warehouse from wide variety of source systems       and Data Marts sourced from       EDW.

 
• Experience in working full SDLC of EDW data warehouses .

 
• Expertise in ETL processes using Informatica and       DataStage.

 
• Expertise in working with various operational       sources like Oracle, SAP and Mainframe.

 
• Strong working experience in planning and       carrying Data Warehousing, MPP and Large-Scale Database Management

 
• Experienced in data modeling in Star schema and 3NF using Erwin.

 
• Through knowledge in Teradata and Oracle RDBMS       Architecture.

 
• Experienced in troubleshooting Teradata scripts , fixing bugs and addressing       production issues and performance tuning

 
• Experienced in developing OLAP reports using       Business Objects.

 
• Extensive experience in loading high volume data, requirements gathering, analysis,       design, development, test and implementation.

 
• Exceptional verbal       and written communication skills, excellent team player.

TECHNICAL  SKILLS

RDBMS: Teradata R13, R12,v2R6, v2R5,  Oracle 8i, 9i, 10g, 11g

  ETL Tools:Informatica 9.0,8.6,8.1, 7.1 DataStage 7.5

  Query tool: BTeq, Queryman

  Load & Export: FastLoad,  MLoad, FastExport

  Database tools: SQL, PL/SQL

  Unix: Shell scripting,  shell commads

  Mainframe TSON , JCL

  BI  Tools:Cognos 8,  , Business Objects 6.0, XI R2 ,SAS 9.0

  Data modeling tool: Erwin, MS Visio

  Automation tools: Control M, Autosys, Tivoli and WLM (IBM)

  Languages: Java,  C, C++, XML, xalan

  Internet technologies: Web services , AXIS2

  Messaging  MQ Series

  IDE/GUI Toad,  Eclipse

  Operating System: HP UNIX, AIX , VAX, VMS, IBM Mainframes, Win  XP, 2000, NT

EDUCATION

Bachelor of  Technology

CERTIFICATIONS AND TRAINING

 
• Teradata Certified Professional ( ID : SR1657423 )
 
• SAS 9 partner's  training

 
• Unix and C  

Client: Confidential, New Hampshire Jan 2011 to  Till date

    Project: EDW (Enterprise Data Warehouse)

    Role: Teradata Data Warehouse Architect

   

   The business division of Personal Market in Liberty  Mutual has its own Enterprise Data Warehouse. Extracted data loaded into  staging server through fast export, later which is been cleansed transformed,  integrated and loaded into EDW database through, mload and Bteq.

   The objective of work is to augment EDW with business  requirements from changing business and source.

 
• Worked on  requirements gathering, architecting the ETL lifecycle and creating design  specifications, ETL design documents.

 
• Architected and developed Fast Load and MLoad scripts in control file ,  developed BTEQ scripts to process the data in staging server.

 
• Through explain  plan, analyzed and modified indexes and modified queries with derived or  temporary tables to improve the performance. Also utilized Teradata viewpoint.

 
• Analyzed and  designed USI and NUSI based on the columns used in joins during data  retrieval.

 
• Used BTEQ and SQL Assistant (Query man) front-end  tools to issue SQL commands matching the business requirements to Teradata  RDBMS.

 
• Designed and  developed physical models with appropriate Primary,  Secondary , PPI and Join Index taking  into consideration of both planned access of data and even distribution of data  across all the available AMPs.

 
• Designed and  developed workflows and automated with UNIX shell scripts and ESP. Created  shell scripts to drop and re-create indexes to load data efficiently and  decrease load time.

 
• Actively involved  in the data modeling and design of the data warehouse with Data  Architect, Designed and Implemented star  schema models, Identified and built Facts,  Dimensions, Aggregate tables to support the reporting needs and  requirements of the users.

 
• Was part of ETL  production support team and was on weekly on-call rotation and provided on-call  support for the projects in production during the warranty period.

 
• Performed Unit,  Integration and system testing and provided UAT support to business partners.

 
• Guided the new  team members to observe the development methodologies and architecture.

 
• Handled  production issues by co-coordinating between client and development team.

Environment : Teradata R13, Informatica 9.0, Oracle 10g, AIX , shell scripting ,  SQL Assistant, Microstrategy 9 , Windows  Vista, Erwin, ESP

Client: Confidential, California  and Texas Nov 2009 to Dec  2010

    Project: EDW

    Role: Teradata Lead Consultant

   

   Confidential, one of the enterprise level data warehouse.

   The scope of this work is to develop and implement for new  business requirements and maintain exiting application. In EDW data received in unix as flat files and in  Oracle. Then data processed using Informatica and the Load Ready Files are  transferred to mainframe where Teradata mload utility is used to load data into Teradata  tables .The scheduling of jobs were done with ESP ( a mainframe based scheduler  ).

Responsibilities

 
• Actively involved  in requirements gathering, creating design specifications and ETL design  documents.

 
• Designed and  developed physical models with appropriate Primary, Secondary , PPI and Join  Index taking into consideration of both planned access of data and even  distribution of data across all the available AMPs.

 
• Lead team of  developers , allotted work, resolved  issues, was an active bridge between data modeler business users and  developers in both offshore and onsite. Trained new members to bring up speed

 
• Architected and developed Fast Load and MLoad scripts in control file ,  developed BTEQ scripts to process the data in staging server.

 
• Through explain  plan, analyzed and modified indexes and modified queries with derived or  temporary tables to improve the performance. Also utilized Teradata viewpoint.

 
• Worked with SET  and MULTISET tables for performance evaluation of the scripts.

 
• Analyzed and  designed USI and NUSI based on the columns used in joins during data  retrieval.

 
• Used BTEQ and SQL Assistant (Query man) front-end  tools to issue SQL commands matching the business requirements to Teradata  RDBMS.

 
• Involved in identifying  the performance bottlenecks and optimizing respective databases and processes  for performance improvement.

 
• Wrote shell scripts with the requirements  from Automation team to execute the extract and load process.

 
• Handled  production issues by co-coordinating between client and development team.

Environment : Teradata R12 ,Informatica 8.6, NCR's  Unix Servers ,Teradata SQL  Assistant, Fast Load, BTEQ, MLOAD , Viewpoint ,Business Objects , Shell  Scripts, HP unix , Windows XP, Erwin, ESP

Client: Confidential, Ohio  May 2009 to Oct 2009

    Project: RM (Revenue Mart)

    Role: Teradata Lead Consultant

   

   Confidential, revenue connection, a strong team to prepare  and present reports to the enterprise about  agents spread across the country. To analyze claims and policies with key metrics, Policies in force, Direct  written premium etc.

   The purpose of this work is to augment data mart with the  data from direct channel. Data loaded into staging server through fastload from  flat files, the data processed in staging server through SQL scripts ran  through Bteq, finally insert or updated into the Revenue mart using mload. Scheduling the scripts to run were done  through UNIX scripting.

 

  Responsibilities

 
• Actively involved  in requirements gathering, creating design specifications and ETL design  documents.

 
• Architected and developed Fast Load and MLoad scripts in control file , developed  BTEQ  scripts to process the data in staging server.

 
• Designed and  developed physical models with appropriate Primary, Secondary , PPI and Join  Index taking into consideration of both planned access of data and even  distribution of data across all the available AMPs.

 
• Designed and  created join indexes for the aggregate  data.

 
• Through explain  plan, analyzed and modified indexes and modified queries with derived or  temporary tables to improve the performance. Also utilized Teradata viewpoint.

 
• Worked with SET  and MULTISET tables for performance evaluation of the scripts.

 
• Used BTEQ and SQL Assistant (Query man) front-end  tools to issue SQL commands matching the business requirements to Teradata  RDBMS.

 
• Involved in identifying  the performance bottlenecks and optimizing respective databases and processes  for performance improvement.

 
• Wrote shell scripts with the requirements  from Automation team to execute the extract and load process.

 
• Lead team of  developers , allotted work, resolved  issues, was an active bridge between data modeler business users and  developers in offshore and onsite. Trained new members to bring up speed

 
• Handled  production issues by co-coordinating between client and development team.

Environment : Teradata R12 ,Informatica 8.1, NCR's  Unix Servers ,Teradata SQL  Assistant, Fast Load, BTEQ, MLOAD , Viewpoint , Cognos 8, Shell Scripts, Solaris, Windows XP, Erwin, Tivoli

Client: Confidential, Indiana Oct 2008 to Apr  2009

    Project: EPD (Enterprise Pricing Data)

    Role: Teradata Lead Developer

   

   Confidential, Actuary team wanted a platform to process  their pricing data at enterprise level, the objective of this project is to  extract data from Wellpoint's regional data warehouses and load into EPD  system.

   Data extracted and loaded into staging server through  macros, fast export exports data into UNIX server, from where data is combined  with files from all other non Teradata data  sources and molded into EPD system.

 

  Responsibilities

 
• Actively involved  in requirements gathering, creating design specifications and ETL design  documents.

 
• Actively involved  in the data modeling and design of the data warehouse.

 
• Architected and developed Fast Export and MLoad scripts in control  file,developed macros and Stored procedure to extract data, BTEQ  scripts to take the date range from the database to extract data.

 
• Worked with SET  and MULTISET tables for performance evaluation of the scripts.

 
• Created tables  with appropriate UPI and PI taking into consideration of both  planned access of data and even distribution of data across all the available  AMPS.

 
• Analyzed and  designed USI and NUSI based on the columns used in joins during data retrieval.

 
• Used BTEQ and SQL Assistant (Query man) front-end  tools to issue SQL commands matching the business requirements to Teradata  RDBMS.

 
• Involved in identifying  the performance bottlenecks and optimizing respective databases and processes  for performance improvement.

 
• Wrote shell scripts with the requirements from Automation team to  execute the extract and load process.

 
• Lead team of  developers , allotted work, resolved  issues, was an active bridge between data modeler business users and  developers in offshore and onsite. Trained new members to bring up speed

 
• Provided project  estimates, coordinated the development efforts and discussions with the  business partners, updated status reports and handled logistics to enable  smooth functioning of the project and meet all the deadlines.

 
• Handled  production issues by co-coordinating between client and development team.

Environment : Teradata R12 ,Informatica 8.1,  SAS 9.0, NCR's Unix Servers 5100 ,Teradata SQL  Assistant, BTEQ, MLOAD ,Shell Scripts, AIX, Windows XP, Erwin, WLM , Cognos 8

Client: Confidential, Ohio   Aug 2007 to Aug 2008

    Project: EDW (Enterprise Data Warehouse)

    Role: Senior Teradata Consultant

   

   Being a leading back office partner to top finance  companies, FirstData's integrated data source is its Enterprise Data ware House  (EDW), which provides single source of information which is presented to all  business units through Business Presentation Layer.

  According to the architecture of this project, data  extracted from source is loaded into Teradata staging database through MLOAD  scripts. Change detection and Surrogate Key Generation is done by BTEQ scripts.  Informatica is used to transform and clean the changed data files. MLoad loads  the processed data into target tables with history.

  Responsibilities

 
• Investigated data  quality issues by data profiling on the source system

 
• Extracted data  from various sources such as DB2,  Oracle, Teradata fixed width and de-limited flat files, cleansed and loaded  data into Teradata and Flat file targets using Informatica and PL/SQL.

 
• Architected and developed Fast Export and MLoad scripts in control file,  developed macros and Stored procedure to extract data, BTEQ  scripts to take the date range from the database to extract data.

 
• Worked with SET  and MULTISET tables for performance evaluation of the scripts.

 
• Created tables  with appropriate UPI and PI taking into consideration of both  planned access of data and even distribution of data across all the available  AMPS.

 
• Analyzed and  designed USI and NUSI based on the columns used in joins during data retrieval.

 
• Used BTEQ and SQL Assistant (Query man) front-end  tools to issue SQL commands matching the business requirements to Teradata  RDBMS.

 
• Performed Unit,  Integration and system testing and provided UAT support to business partners.

 
• Worked with the  Business objects users to create and modify WEBI reports and validate data.

Environment : Teradata v2R6 ,Informatica 8.1, NCR's Unix Servers 5100 ,Teradata  SQL Assistant, BTEQ, MLOAD ,Shell Scripts, AIX, Windows XP, Erwin, Tivoli  ,Business Objects XI R2

Client: Confidential, Kentucky  Sep 2006 to Jul 2007

    Project: EDW Augmentation (Enterprise Data Warehouse)

    Role: Senior Teradata Consultant

   

    Client: Confidential, Ohio May 2005 to Aug 2006

    Project: IRS (Inventory Reporting System)

    Role: Senior Teradata Consultant

Client: Confidential, Newyork Mar 2004 to Apr 2005

    Project: EDW (Enterprise Data Warehouse)

    Role: Teradata Consultant

   

    Client: Confidential, Singapore  Aug  2002 to Jan 2004

    Project: GDW (Global Data Warehouse)

    Role: Teradata Developer

   

    Client: Confidential, Singapore Feb 2002 to  Jul 2002

    Project: MRS (Management Reporting System)

    Role: Business Objects Developer

   

    Client:   Confidential, Chennai  Mar 1999 to  Nov 2001

    Project:  Selectica Foundation Services , ACE  Pricer 1.0

    Role:  Developer of Admin Module , JSP  Developer