SUMMARY:

• Over 16 years’ of industry experience in complete IT Life cycle covering, software analysis, requirements gathering, design, development, testing& debugging, implementation, post implementation production / maintenance support.
• Experienced and Expertise in End to End Data ware housing and Data Migration project implementation covering ETL, Data Warehousing and OLAP.
• Expertise in wide range of Databases, DWH, ETL and OLAP Business Intelligence tools.
• Work experience in Retail, Banking, and Telecommunication& Transportation (Airlines) Industries.
• Global Working experience maintained good working/professional relationships with Industry majors such as Confidential.

TECHNICAL SKILLS:

ETL: Informatica 5.0, 6.2, 7.1&8, Oracle Warehouse Builder 9 & 10.2, Ascential DataStage 7.5.1. Confidential

OLAP: Business Objects 6.X & XiR2, Oracle Discoverer Plus 9 & 10.2

Exposure: BO Performance Management, Maestro scheduler, Erwin 3.5.2

Training on: Ab Initio, Microsoft Analysis Services and Microsoft Reporting Services

Operating Systems: Solaris UNIX, SCO UNIX, SunOS, Redhat Linux 6.1 & 6.2, Windows NT, 95, 98 & 2000, XP

Database: Oracle 8i, 9, 10g, Teradata V12.0

Languages: C, Pro*C, PL/SQL, SQLPLUS, HTML, Shell Scripts, Java, SQLJ, Pearl and COBOL

Domains: Retail, Banking, Transportation, Utility, Telecommunication, Risk Management

PROFESSIONAL EXPERIENCE:

Confidential

BI Architect

Responsibilities:

• Analysis, Preparation of FRD, Development and Testing of ETL code, Deploying in the different environments as per the specifications.
• Delivery of investigation files in the respective portals in order to facilitate the CITI customers in reconciliation.

Software: TALEND Integration Suite Enterprise Data Quality 4.1.3, Oracle 11g, ICG Recon Quick Rec (V13)

Confidential

Solution Architect

• Served as Confidential solution Architect for TEG-Technology Excellence Group responsible for defining technology architecture and framework for BI delivery.
• Prepared technical RFP and proposal for Sainsbury Ltd-UK, Bestbuy-Canada, PETCO, Phones4U-UK
• Responsible for providing hands on support to BI delivery teams for Solution, Technical and Data Architectures including platform selection, data modelling and ETL design.
• Responsible for Estimation, Tool selection for both ETL and OLAP technologies for the solution.
• Shared Implementation Methodology for Sainsbury team
• Trained TCS associates on Informatica 9 and shared technical solution

Confidential

Informatica 8 ETL Architect

• Served as an ETL Architect for Confidential client and designed and implemented data integration and data warehousing solution.
• Re-engineering of 100+ Datastage ETL components to Informatica 8.0 components
• Provided Data warehouse ETL Architecture, data model, prepared high level technical specifications, test specifications.
• Performed performance testing and defined Implementation methodology.
• Implemented successfully in the Client environment
• Prepared Requirement documents based on the clients interactions and end users feedback for GSM (General Store Merchandising) report development project.
• Leading BOXiR2 report team, created technical specification for BO Universe designing and reports, Use case for testing of reports in Teradata environment
• Reviewed deliverables from offshore developers, provided technical solutions to the development team as and when required.
• Coordinated with Client and Other support groups for the smooth execution of the project

Software: Informatica 8, Ascential Datastage 7.5.1, Oracle 10g Database, HP Load Runner 9.10 & HP Quality Center

Confidential

Datastage ETL Architect

• Served as an ETL Architect for Confidential . Designed and implemented massive 5TB data integration solution.
• Redesigned 350+ Informatica 5.0 ETL components to Datastage 7.5.1 components in Oracle 10g Environment
• Provided new ETL Architecture, data model, prepared high level technical specifications based on the older Informatica components
• Managed technically Confidential team of 16 associates
• Prepared and provided Checklist, Standards, and Templates for Datastage ETL Development.
• Provided technical solutions to the team, reviewed the deliverables, coordinated with clients, different support groups, stake holders and the development team
• Defined the implementation methodology for 250+ Datastage ETL components in production environment using phasewise implementation.
• Decommissioned the older environment without impacting the production environment
• This was much appreciated projects for smooth implementation as well as the Best performance implementation

Software: Ascential Datastage 7.5.1, Oracle 10g Database

Confidential

ETL Architect and Project Manager

• Served as an Architect for Reengineering of Assets Liability Tool Confidential TCS product. This tool was developed over Confidential span of 8 years with PL/SQL scripts for ETL and Oracle Express for Reporting in Oracle 8i environment. This was reengineered in Oracle Warehouse builder 10g for ETL and Oracle Discovered plus 10.2 for OLAP reports under Oracle 10g environment.
• Analysed the existing tool, designed and created Technical Specification document for the entire tool. Prepared high level design document for both ETL and OLAP reports.
• Reviewed ETL and OLAP Reports low level Technical Specifications, Reengineering Functional Specification, Unit Test specifications, Unit Test Results and Integration Test Results
• Coordinated Risk management Team, ETL and reporting development teams. Provided technical solutions to teams whenever issues raised
• Delivered 8 years old Tool in Confidential span of 6 months using Oracle development tool based package with very high performance.

Software : Oracle Warehouse Builder10.2, Oracle Discoverer Plus10.1.2, Analytical Workspace Manager10.2, Oracle10g

Informatica 6.0 ETL Technical Manager

• Served as Informatica Technical Manager for Confidential Integration Project. This project work involves integration of corporate data from CTD systems to ICW (Integrated Commercial Warehouse).
• Responsibility involves Analysis of CTD and ICW data warehouse corporate data, Design and development of Informatica 6.0 mappings in Oracle 9 environments.
• Review of the ETL mappings, Test results and specification deliverables.
• Coordination with Onsite and offshore teams for delivery and implementation in production environment within the schedule and quality

Software: Informatica 6.0, PL/SQL and Oracle 9

Confidential

Informatica 6.0 and Business Objects Reporting Technical Manager

• Served as Business Objects reporting Technical Manager for Confidential Global Distribution Systems Integration Project. The project work involves generation of Business Objects reports on Volume of Booking of chargeable segment status codes for Nine GDS, such as Abacus, Ameadus, Apollo, Galileo, Infini, Sabre, Worldspan, Axess and Topas from ICW WOMBAT system (Integrated Commercial Warehouse) which is in TERADATA Database
• Responsibility involves Analysis of Nine GDS systems, Design and development of Business Objects Reports in Oracle 9 environments.
• Also responsible for ETL designing and development using Informatica 6.0 for Mainframe elimination project for Bestbuy Client
• Review of the Informatica ETL mappings, BO Reports, Test results and specification deliverables.
• Coordination with Onsite and offshore teams for delivery and implementation in production environment within the schedule and quality

Software: Business Objects, BTEQ, Teradata, Informatica 6.0, Pro*C, K-Shell, Oracle

Informatica 6.0 ETL Testing Head

• Served as an Informatica ETL Testing team head for Confidential team of 6 for Confidential water billing System projects. The new water billing system was developed by integrating 10 disparate systems. The development team was managed by clients and the testing part was taken by my team,
• Responsibility involves Defining, Creating and Managing Test Data Configuring for different Testing
• Created Test specification for the entire testing cycles such as system, integration, stress and performance related tests. Created Test data also for the same.
• The testing environment was created and the tests were carried out for Informatica 6.0 ETL mappings.
• The tested informatica mappings were implemented successfully in the production environment.
• Also involved in Development of Informatica Mappings during the absence of few ETL developers.

Software: Informatica 6.0, PL/SQL& K-Shell scripts in SUN Solaris Operating System

Oracle Warehouse Builder (OWB 9) ETL Developer

• Responsibility involves Analysis of like Revenue, Usage Pattern, and Effectiveness of the introduced schemes in the TTL telecommunication channels.
• Based on the analysis varies reports needs to generated for different levels of management for analysis
• Designed and developed OWB mappings in Oracle environment taking data from different channels of communications in TTL to create TTL DWH systems.
• Developer 2000 tool was used to create static reports from the OWB DWH environments.
• Successfully implemented the DWH systems and created reports for analysis by managements.

Software: Oracle Warehouse Builder9, Developer 2000

Confidential

Informatica 5.0 ETL Developer and Technical Lead

• Served as Informatica ETL developer and then Technical Lead for team of 55 executing 11 BI projects simultaneously.
• In Bestbuy there were three major systems viz., RBPM (Retail Business Process Management Project), MLG (Music Land Group), and MLG score Card which Encompasses Data Warehouse. The entire project work involved, extraction of source data from different systems and load them in to these three main systems.
• Responsibility involves Analysis of different source systems, designing and development of Informatica ETL mappings for loading the data in the DWH environments
• Testing and implementing them in the production environments successfully.
• Managed 11 BI projects and prepared Technical specifications for all the ETL mappings, checklists, standards and shared to the development team
• Reviewed the deliverables such as ETL mappings, Test specification and results from the team of 55.
• Coordination with Onsite and offshore teams for delivery and implementation in production environment within the schedule and quality

Software: Informatica 5.0, Pro*C& K-Shell scripts, Oracle

Confidential

Project Leader

• Served as Confidential project leader for Retek Launchpad reports from Mainframe environment to Oracle environment, this project was executed using Developer 2000 and Oracle Reports 6i.
• Responsibility involves requirement collection, technical specification document preparation based on the functional requirements and data mapping
• Development / Generation of Reports using Reports 6I
• Preparation of Shell scripts and SQL scripts based on the requirement
• Review of low level technical Specification documents, Shell scripts and SQL scripts. Testing of Oracle reports
• Organizing weekly status meetings both with Clients and Internal TCS meeting
• Preparation of Process documents for Development of Reports
• Communicating with Clients, about the project status, issues and concerns and taking necessary actions in the project for smooth delivery

Software: Developer 2000, Oracle Reports 6i, Shell Scripts, PL/SQL, Shell scripts, Oracle

Module Leader

• Served as module leader for Confidential development of an automation tool for Confidential officers to collect debt from the defaulters through judicial procedure
• Responsibility involves requirement collection, technical specification document preparation based on the functional requirements and client feedback
• Visual Basic 6.0 was used for automation tool using DB2 database with MQSeries as Middleware.
• Preparation of Requirement documents, high level and low level design documents, quality documents such as standards, checklist and templates for development team
• Testing of the tool in production like environment and implementation of the product in client environment

Software: Visual Basic, DB2 & MQseries

Confidential

Module Leader& Programmer

• Served as module leader and developer for IMAP protocol for eServer product for Confidential client
• Responsibility involves Design and development of Internet Message Access Protocol to introduce Mail access facility using IMAP (Internet Message Access Protocol) with the existing eServer package in RedHat Linux O/S with Postgresql database
• Tools developed to Test Different Protocols (POP, IMAP, etc) using RFC 2060 standards
• Creation of HTML documents of eServer sources using DOXYGEN package
• Preparation of Test cases & Test data for testing eServer modules such as Web Server, Mail server, Fail over-Redundancy & Networking.

Software: Redhat Linux 6.1 using C and Postgresql Database

Programmer

• Programmer for development Online Transactions module and Data Transfer Module for backend processes of IBS used to update the day end batch programs which update the database daily automatically.
• Responsibility involves Design, development, testing of Data Transfer module using Pro*C and shell scripts using Oracle backend.
• Responsibility involves Design and development of Request Forwarding module for both online and offline mode.
• Responsibility involves Design and development Administration modules using PL/SQL.
• Tested and integrated the above mentioned modules to IBS tool and implemented successfully.

Software: Pro*C, PL/SQL, Shell Scripts, HTML and Java Scripts in Oracle 7.X database in Windows NT and Sun Solaris environment

Programmer& Analyst

• Programmer for development of Foreign Exchange System to automate all transaction Related to Funds transfer, Pipeline, Cash letter and Deposits of using foreign Currency.
• This automated tool development responsibility involves preparation of technical specification document, design, development and testing of Cash Letter Module and Pipeline Module modules under Remittance Category
• Customization of Remittance Module based on Client’s requirements

Software: Pro*C, PL/SQL, Forms 3.0 in Oracle 7.X database in Windows NT and Sun Solaris environment

Confidential

Programmer& Module Leader

• Programmer and module leader for TCS Product ISBS (Integrated Standard Banking System) used to automate all banking transactions starting from Opening, Different Accounts like Savings, Current, CCOD, Deposits, Loans, Fixed Deposits and Flexi Deposits.
• Responsibility includes Installation of ISBS Package, Maintenance, Client support, bug fixing, and Fixing Change request to different branches of the banks in Chennai. Nearly 150 branches were supported
• Installation of ISBS package to new branches and installation of add on modules to different branches in Chennai.
• HELPDESK - Client Support over phone using HELPDESK software and supported more than 150 bank branches.
• Fixing change request raised by client of different branches of banks
• Preparation of monthly report for both ISBS head and Resident Managerof TCS

Software: Pro*C, PL/SQL, Forms 3.0 in Oracle 7.X database in Windows NT and Sun Solaris environment

Programmer

• Programmer for development of testing tool for ANDT2001 - Windows based Non-destructive testing PC System developed by of M/S.Andrew NDT make California, USA. For material structural study.
• Responsibility includes Design, configuration, and development of testing tool for ANDT 2001 tool as per the different client requirements. Hence the tool was parameterised the input based on the different requirements and generated reports and graphs for material study and analysis.
• Also designed, developed and implemented Client management systems (CMS) using Developer 2000 for IQC Company. Which helped the management for better communications, contact details of different customers, details of various metallurgical testing carried out for each vendors, invoice preparation, new work request, billing details etc.

Software: Developer 2000, Oracle 7.x, Forms4.5

Confidential

Programmer

• Programmer for development of Confidential computational Model of Solidification Process for Titanium metals in welding using Numerical Technique
• Responsibility includes Analysis, Design, and development of module which takes care of finite element analysis of the problem by taking the data from an input file which contains parameters of various materials and provides results in numeric data as well as Confidential graphical output for Titanium Welding and surface Treatment.

Software: C in MS-DOS

Confidential

Programmer

Responsibilities:

• Programmer for development of Confidential computational Model of Heat transfer on different metals during different heat treatments
• Responsibility includes Analysis, Design, and development of module which used to measure the metal resistance quantitatively with various heat treatment test data and in evaluation of mechanical driving force using Heat transfer and mechanical computational Models

Software: C, shell scripts in UNIX environment