SUMMARY:

• Sixteen years of diversified experience in System Analysis, Design, Development, Implementation and testing of Data warehouse and Data Mart applications in Finance, Telecommunication and Manufacturing Industry domains.
• Extensive experience in Oracle8i/9i, UNIX and Data Warehouse/Datamart development, extract, transform and Load data using ETL tool Informatica Power Center 6.2 and 7.1.2, 8.1.6, OLAP tools and Database Design tool Erwin.
• Expertise in Design and Develop Real Time ETL Process using MQ and XML Messages.
• Expertise in creating Technical Design document (TDD).
• Implementing complex business requirements by creating re - usable transformations and mappings/mapplets.
• Informatica Developer - Mapping Designer, Mapplets, Workflows/Worklets, Transformations.
• Good in gathering Business Requirements, Analysis, Design and Writing Technical Specs, Coding, SQL performance tuning.
• Writing and Analyzing Data Extraction, Transform and Load scripts.
• Writing Dynamic SQL, PL/SQL, Package, Function and Triggers, Materialized Views.
• Developed UNIX Shell Scripting, Awk, Perl Programming and Corn Jobs.
• Requirement Analysis Design to complete implementation. SLDC CMM Level-2
• Business Process Modeling (Functional requirement definition).
• Data Modeling (Conceptual Design, Logical and Physical Database Design).
• Database Administration, Database and Application Performance Tuning & Optimization, Data Definition Creation.
• Application Development, Data Conversion & Migration.

TECHNICAL SKILLS:

RDBMS: Oracle 7.1.2 to 10gUnify - Forms, RPT, Accell 4GL language.INFORMIX V2.1Access

Operating Systems: UNIX (SVR4.0, HP-UX, SunOS 5.6), Windows NT.

Hardware: Sun Fire 480, SUN4U Sparc SUNW Ultra, HP, IBM PC, NELCO F-20 Mini Computer, ORG Supermax R4000 (Risc based), HCL-HP.

Languages: PL/SQL, Shell Scripting (Ksh), AWK, Perl, Pro*C, COBOL,and SQR

Other Tools/Software s: Erwin. Visio 6.0FTP, PVCS (Version Control), Aldea (Error Tracking System)Toad, SQL*Navigator, Teradata SQL Assistant 7.2Ms-Project.Informatica Power Center 7.1.2 to 8.6.0.

PROFESSIONAL EXPERIENCE:

Confidential

ETL Architect

Responsibilities:

• Create Technical Design Document (TDD) for CDI.
• Design the data model for stage and Preload CDI tables.
• Understand the data requirement from target system (MDM) and set up an automated feed from source to target.
• Design and Develop XML mappings using XML generator to create the Customer (participant) and Account (Contract) files.
• Design and Develop transformations for Error handling and mappings for source/target record count capture.

Environment: UNIX, Oracle 10g, Informatica Integration server 8.6.0, PL/SQL- Package, Procedure/Functions, Shell Scripting, FTP, TOAD, Altova XMLSpy, Autosys.

Confidential

Senior Team member

Responsibilities:

• Create Technical Design Document (TDD) for OLAP Data Feed for RTD.
• Understand the Data requirement from the RTD team and prepare the data profiling document.
• Developed the Informatica mappings to bring the required data elements from the Siebel OLAP system.

Environment: Informatica Integration server 8.6.0, Teradata SQL Assistant 7.2, Toad.

Confidential

Senior ETL Consultant

Responsibilities:

• Understand the business requirement document and set up common objects in Informatica.
• POC for the new transformations and messaging functionality, design ETL model.
• Read, transaction, party data from MQ message queue and load into ODS and RDW.
• Desing and Develop Real-time mapping/workflow feed to ODS and RDW using MQ message queue.
• Mentor and Lead Informatica developer team.

Environment: Red hat Linux AS4 64 bit Oracle 10g, Informatica Integration server 8.1.1, PL/SQL- Package, Procedure/Functions, Shell Scripting, FTP, TOAD, Exceed, Appwatch, Altova XMLSpy

Confidential

Senior ETL Consultant

Responsibilities:

• Informatica Power Center Administration, Upgrades, Setting up Web Services to provide data to SalesForce .com
• Design end-to-end ETL Architecture.
• Integrating FirstLogic-Informatica software with Power Center Design and Implement House Holding rules and process.
• Mentor and Lead Informatica/Oracle developer team.

Environment: Sun Fire™ 480, SUNOS 5.8, Oracle 10g, Informatica PowerCenter Designer 7.1.2 Repository/Workflow Manager, Workflow Monitor, PL/SQL- Package, Procedure/Functions, Perl, Shell, Awk Scripting, FTP, SQL*Navigator, Exceed, Erwin 4.1, VISIO, Third party Vendor software MANTAS, LDAP, FirstLogic, Informatica Web Services.

Confidential

Responsibilities:

• Architect the ETL Process and Implement in production.
• Load the data into Staging area, Creating Informatica Mappings, Workflows and Worklets.
• Creating the DIS files for Mantas Application and run the data process and data load utility (DP/DL) to verify the results.
• Apply the hot fixes to the Mantas system and all
• PowerCenter/Powermart. Full implementations of ETL Source to Target solution.
• Detail Analysis, Design and implementation of entire data flow processes, data validation and error handling.
• Created the entire job scheduling solution using the shell scripts and oracle objects, The Job scheduler runs around 250 jobs every business day to extract, transform and load the data into BSDW.
• Written Dynamic SQL, Stored Procedure (PL/SQL), Package, functions, Created Materialized Views, Table Partitions, Indexes.
• Created Unit Test Cases and Results to verify the process, Created pocess flow diagram using VISIO, used VSS to manage change control for all the code.

Environment: Sun Fire™ 480, SUNOS 5.8, Oracle 9i, Informatica PowerCenter Designer 7.1.2 Repository/Workflow Manager, Workflow Monitor, PL/SQL- Package, Procedure/Functions, Perl, Shell, Awk Scripting, FTP, SQL*Navigator, Exceed, Erwin 4.1, VISIO, Third party Vendor software MANTAS 4.1.1, LDAP.

Confidential

Senior Software Specialist

Responsibilities:

• Involved in Designing of multidimensional Star Schema data mart to hold the billed and unbilled revenue data.
• Writing Materialized Views, Procedures, Functions, Triggers and Shell Scripts to automate the process.
• Informatica PowerCenter/Powermart. Full implementations of ETL Source/Target mappings, Mapplets, Transformation, design strategies, data validation and error handling.
• Detail Analysis, Design and Technical specification writing.
• Analyzing current process flow and validating the upstream and downstream business requirement.
• Created partition table to improve performance.
• Determination of required changes to database and application code.
• Production extract and load support. Created the high level process flow using visio.
• CMM level -2 documentation process Creating UTC/UTR, UTP and process documentation used PVCS to manage change control for all the code.

Environment: SUNOS 5.4, Oracle 9i, Erwin, Visio, BRIO Query, PL/SQL, Shell Scripting, FTP, Toad, Informatica PowerCenter 6.2

Confidential

Responsibilities:

• Writing Pl/sql, Functions, Triggers and Shell/Awk Scripts to automate the load and Extract process.
• Designed and Developed the Star Schema data mart.
• Detail Analysis and Design, Logical and physical database design.
• Determination of required changes to database and application code.
• Developed complex and dynamic commissioning PL/SQL package to apply various commissioning business rules. Created event based process to automate the load process.
• Developed Company Billing system migration process.
• Created the table partition for the performance improvement.

Environment: SUNOS 5.4, Oracle 8i, Erwin, ETL, PL/SQL, Materialized Views, Shell Scripting, FTP, Actuate Report, Informatica.

Confidential, NJ

Responsibilities:

• Writing Pl/sql, Functions, Triggers and Shell/Awk Scripts to automate the load and Extract process.
• Detail Analysis and Design, Logical and physical database design.
• Using remote database link extracted the data in the flat file.
• Developed Process flow diagram.
• Developed Control files to load the data into Data mart.
• Developed various Sales and Financial forecasting reports, Yearly revenue location wise sales report, Current, Previous and future year sales report, Yearly sales growth report, Sales milestones report, General ledger code wise report, Yearly revenue trend report.
• Extensively worked in Oracle Backend Objects like Procedures, functions, triggers and Views.
• Developed process to read and write from flat file.
• Production Support to PCCT systems.

Environment: SUN4d, SUNOS 5.4, Oracle 7.3, FORMS 4.5, PL/SQL 2.3, SQL*Loader, SQR, KSH.

Confidential

Programmer Analyst

Responsibilities:

• As part of the SLDC involved in Analysis, development and implementation using Oracle Forms and SQL*Report Writer. Used Pro*C to print complex reports.

Environment: UNIX, Shell Scripts, Oracle 7.0, SQL*Forms 3.0, PL/SQL, SQL*Report writer, Pro*C.

Confidential

Responsibilities:

• As a Senior Programmer involved in total system life cycle activities of On-Line FAS. This system consists of data entry module, Ledger Process and Balance sheet.
• Developed 15 data entry forms using the SQL*forms 3.0, Written Database Triggers, Stored Procedures for updating -ve balances. Developed reports using SQL*Report Writer, Pro*C i.e. Supplier outstanding, Account Payable, Account Receivable, Trial Balance, General Ledger, Personal Ledger, P&L Account, Balance sheet.

Environment: Oracle 7.0, SQL*Forms 3.0, PL/SQL, SQL*Report writer, Pro*C, SQL*Menu, Accell, Unify.