Education Qualifications and Certifications:

• Post Graduate Diploma in Advance Computing
• Bachelor of Engineering (Electrical)

Profile and Experience:

Around 8.5 years of experience in Information Technology, including 7+ years in designing, developing and implementing ETL solutions using Informatica, Teradata, Oracle, UNIX, SQL.

• Managed 2 projects as PM successfully.
• Responsible for Project charter and roadmap ,Project Role Matrix, Status Reports and Project Schedule
• Experience in Estimation and Planning of Small to Mid size project.
• Experience in Managing the Onsite and Offshore team.
• Experience in working on Informatica Powercenter for Data Warehousing ETL design, development and implementation
• Expertise in ETL Mapping/Session/Worklet/Workflow Design and Development using Informatica PowerCenter 8.x/7.x
• Experience in using Teradata V2R5, V2R6, Oracle 9i for Enterprise Data warehouse application development
• Expertise in working on SUN Solaris systems (UNIX)
• Experience in writing and debugging SQL (including Teradata Advanced SQL)
• Experience in using Teradata loader utilities BTEQ, MLOAD (Multi Load), FLOAD (Fast Load), FastExport & TPUMP
• Experience in using TPT (Teradata Parallel Transporter) utility
• Expertise in writing and debugging UNIX Shell scripts
• Extensive knowledge of Relational & Dimensional Modelling, Entity Relationships, Relational Databases, 3NF, Star and Snow Flake schema, Active Data Warehousing, Active Enterprise Intelligence
• Expertise in code optimization for Informatica or SQL code.
• Experience in Data Modelling using ER Win 7.3.
• Experience on tools: Teradata SQL Assistant/Query Man, Teradata Administrator, TOAD, MS SQL Query Analyser, VSS, PVCS, Rational REQ-Pro Test Manager
• Experience in Creating Development standard Guidelines for the Informatica code .
• Experience of Code review and Design review process.

Awards and Recognitions:
"Above and Beyond" Award
Star performer of the month Award
Article published in an internal magazine Quoting "Shining Star of Wipro Technologies for Quarter"

Skill Sets:

Windows, Unix

ETL Tools and Scripting Languages:

Informatica (7.X, 8.X), SQL, Unix Shell Scripting, PHP,PERL scripts, BTEQ, MLOAD, FastLoad, FastExport, TPUMP, TPT (Teradata Parallel Transporter)

RDBMS:

Teradata, Oracle 9I, SQL Server 6.x

Data Modeling:

ERWin 7.3

Other Tools and Utilities:

Toad, Teradata SQL assistance

Other Languages/ Technologies / Platforms:

PHP Technology

Project experience:

Client : Confidential
Period : November 2009 to Present
Industry : Confidential
Project Name : MIC
Project Type : Development.
Environment : Informatica Power Center 8.6, Teradata
Role : ETL Lead

Responsible for:

• Requirement gathering and Business Analysis. Creating mitigation plans.
• Estimation and Creation of SOW and Project plan.
• Managed Offshore and Onsite team.
• Working on Data load strategy.
• Designed End to End ETL Process.
• Implemented A/B Switch so that Load can’t hamper performance.
• Worked on Project Charter and Scheduling of the assignment.
• Worked in integrated environment of Teradata and Informatica.
• Handled Loads using Teradata Load utilities from Informatica.
• Analyzed the functional specs provided by the data architect and created technical specs documents for all the mappings.
• Defined various facts and Dimensions in the data mart including Fact less Facts, Aggregate and Summary facts.
• Reviewed source systems and proposed data acquisition strategy.
• Designed and developed Informatica Mappings to load data from Source systems to ODS and then to Data Mart.
• Extensively used Power Center/Mart to design multiple mappings with embedded business logic.
• Creation of Transformations like Lookup, Joiner, Rank and Source Qualifier Transformations in the Informatica Designer.
• Created complex mappings using Unconnected Lookup, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations for populating target table in efficient manner.
• Created Mapplet and used them in different Mappings.
• Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process. Maintained the batch processes using Unix Shell Scripts.
• End-to-end ETL development.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Maintain Development, Test and Production mapping migration Using Repository Manager, also used Repository Manager to maintain the metadata, Security and Reporting.
• Implemented Push down optimization
• Done Code review for Offshore team.

Client : Confidential
Period : April 2009 to October 2009
Industry :Confidential
Project Name : PRM
Project Type : Development.
Environment : Informatica Power Center 8.1, Teradata
Role : Technical Consultant.

Responsible for:

• Interacted with Business Analysts and onsite counterpart for understanding the Technical Specification.
• Developed ETL Mappings and configured Workflows and Sessions using Informatica Powercenter 8.1 involving Flat File sources, Oracle sources and Teradata Targets.
• Developed mappings using PushDown Optimization.
• Worked with Flat file and relational Sources.

Client : Confidential
Period : Jan 2009 to Mar 2009.
Industry : Confidential
Project Name : Total Guest Worth
Project Type : Development
Environment : Informatica Power Center 8.6, Teradata.
Role : Technical Consultant.

Responsible for:

• Developed ETL Mappings and configured Workflows and Sessions using Informatica Powercenter 8.6 involving application sources and Teradata Targets.
• Written Script for Unit testing
• Documented specification changes as per design and actuals

Client : ConfidentialCA
Period : September 2006 to June 2008.
Industry :Confidential
Project Name : IDW
Project Type : Development and Maintenance.
Environment : Informatica Power Center 7.X, Teradata, UNIX.
Role : Technical Lead.

Responsible for:

• Responsible for the transition of the project from different vendors.
• Interacted with Business Analysts and onsite counterpart for understanding the Technical Specification.
• Developed ETL Mappings and configured Workflows and Sessions using Informatica Powercenter 7.1.3 involving Flat File sources and Teradata Targets.
• Developed SCD Type2 mappings for different subject areas.
• Developed mappings for migration project from Oracle to Teradata.
• Responsible for performance tuning of Jobs and data fix in production Env.
• Responsible for maintenance and enhancement of the existing code of the project.
• Responsible for handling change request.
• Written Script for Unit testing
• Responsible for leading the offshore Team.
• Worked at Onsite as Onsite coordinator.
• Key Role played in enhancing the existing process.
• Training of support team on ETL mappings Codes and walk thru the written documents.

Client : Confidential
Period : October 2005 August 2006.
Industry : Confidential
Project Name : BPCL Retail Automation
Project Type : Development
Environment : Informatica Power Center 7.X, Oracle
Role : ETL Developer

Responsible for:

• Interacted with Business Analysts and Team Lead to have a clear understanding of the Technical specifications for individual Interfaces to be integrated.
• Responsible for creating ETL Staging Loads and scheduling jobs for integrating Customer, Product, Sales and Inventory Interfaces.
• Developed ETL Mappings and configured Workflows and Sessions using Informatica Powercenter 7.1.1 involving Flat File sources and Oracle 9i Relational Targets.
• Created Mapplets and Reusable Transformations for Date conversions and routine sequence generation logic.
• Documented specification changes as per design and actuals, and reported them to Analysts and Team Lead as part of Technical Design Review.
• Developed Test scenarios in co-ordination with Business Analysts and wrote Test scripts to execute them.
• Create and maintain stored procedures, queries and reports to support standard and adhoc data requests.
• Responsible for Informatica Admin activity for Dev box.

Client : Confidential
Period : November 2004 to September 2005
Industry :Confidential
Project Name : BPCL IN & OUT.
Project Type : Development
Environment : Informatica Power Center 7.X, SQL Server
Role : ETL Developer

Responsible for:

• Prepare user requirement documentation for mapping and additional functionality.
• Used different Data Warehouse techniques like Star-Schema.
• Analyze and import the Source definitions, create target definitions and logical and physical.
• Working with various active & passive transformations within Informatica Like expression, lookup, filter, rank, aggregate, update strategy, joiner, Stored Procedure etc.
• The project called for extensive work using the Informatica tool involving - Source Analyzer, warehouse designer, Mapping designer & Mapplet and Transformations and Parameter Files.
• Worked with various tasks -Timer, Assignment, command and Event wait, Event Raise, etc.
• Developed Quality control process purely in PL/SQL that calculates all the financials using the business rules and checks those amounts with those coming out of informatica maps.
• Tested the target data against source system tables by talking a text file dump, compare and verified.
• Quality Analysis (QA) for informatica mappings developed by other developers which includes checking informatica standards, logic.

Client : Confidential
Period : January 2003 to October 2004.
Industry : Confidential
Project Name : Adstock Mist.
Project Type : Development.
Environment : PHP, JavaScript, MySQL, Linux
Role : programmer
Responsible for:

• Understanding Business Requirements, Document them and creating functional specification document.
• Database designing.
• Came out with project estimation.
• Coded and tested.
• Also involved in testing courses on different combinations of browser and OS
• User training.

Client : Confidential
Period : February 2002 to August 2002.
Industry : Confidential
Project Name : Ichap Survey and management package.
Project Type : Development.
Environment : PHP, JavaScript, MySQL, Linux
Role : programmer
Responsible for:

• Worked as Trainee Software Engineer.
• Understanding Business Requirements, Document them and creating functional specification document.
• Coding and testing.
• Also involved in testing courses on different combinations of browser and OS