OBJECTIVE:

To obtain a challenging position as a Sr .ETL Developer/Analyst, where I can utilize my skills and expertise that will enable business, add value and provide opportunities for professional growth

PROFESSIONAL SUMMARY:

• 13 years of solid experience with a wide repertoire of technical qualifications. Expertise in analysis, design, development and implementation of large Data Warehouse, BI and other DB applications in Financial and Manufacturing sectors.
• Expertise in ETL design and Application Database development using Informatica 8.x /7.x and Oracle10g /SQL server/Informix Databases as backend, Skilled in UNIX shell scripts, knowledge of CGI Perl and Java.
• Expert level skills in Oracle 11g/10g/9.i/8.i application development using SQL PLUS, PL/SQL Packages, Procedures, Functions, Triggers and Arrays.
• Expert level usage of various Informatica 8.6/8.5/8.1/7.1 ETL tool components Designer, Workflow Manager, Workflow Monitor, Repository Manager to Extract, Transform, and Load ETL the data into the data warehousing tables.
• Strong in Data Analysis, Data Modeling, Data Migration, Data Conversion, and other Data Integration tasks.
• Strong programming skills in UNIX and Perl scripts.
• Strong in Data Warehouse Architecture, and Business Intelligence BI solutions.
• Excellent Analytical skills with strong experience in data and Business analysis.

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Informatica Database Developer

• Project: Medicare total sales Solutions - Kaiser Permanente Age-In KPMAI program requires monthly data flow to generate prospect data in MTSS, Schedule outbound calls and initiate fulfillment of enrollment material, The overall goal is to process the prospect list generated by Campaign data operations, leads, enrollment, call scheduling and revenue generation from Medicare members.
• Analyze, Design, Develop and implement ETL interfaces using Informatica Designer and workflow and extract data from various interfaces and loads the data into either flat files or staging tables and further classified data into de-normalized form and make it available for the Reporting team.
• Technologies Used: Oracle Database 11g/10g , SQL Server 2008, Informatica - 8.6/8.1/7.0 Designer, Workflow Manager, Repository Manager, Deployment Groups , UNIX, SQL Plus, PL/SQL, TOAD 9.7

Confidential

Sr. ETL Developer

• Project: Enterprise Hyperion EHP - The Goal of the EHP project is to replace existing long range planning and reporting tools with the Enterprise Hyperion planning system, thus providing a standard, efficient, and effective planning and reporting system more closely integrated across the company.
• Analyze, Design, Develop and implement ETL interfaces through AGILE process which enables Hyperion Planning team to use the data against the planning and forecasting data for future businesses.
• Extract the data from multiple sources through GWX Gateway exchange , Load and Transform them through Informatica ETL process into the centralized data warehouse location and map the data against Hyperion Planning, Schedule jobs through Run books.
• Provide product support after implemented into the production and fix Bugs.
• Technologies Used: Oracle Database 11g/10g , Informatica - 8.6/8.1/7.0 Designer, Workflow Manager, Repository Manager, Deployment Groups ,Unix, SQL Plus, PL/SQL ,TOAD 9.7, HP Quality center tool, Enterprise Hyperion Essbase Admin services and Planning tool, smartview, Unity Shared Point
• Project: Transport Security Agency TSA - HRAccess Hiring Database IHS
• Role in this project is to extract source data from multiple hiring database interfaces and load the data through datastage into the RAW, STAGE and ODW Operational Data warehousing tables.
• Responsibilities also includes develop build scripts for the migration of code into the Development, Test and Production Environments.
• Technologies Used: Informatica 8.6/8.1, Oracle 10g, SQL PLUS, TOAD, PERL, clearquest and Linux
• Project: MS2/CFS/STS
• Role in this project was to support financial group of MS2/CFS/STS clients by studying their requirements, do analysis, design, develop ETL mappings, workflows using Informatica to load the data from SAP systems and various other interfaces in to the Staging and ODS layers of the Oracle data warehousing tables and make the data available for the reporting team.
• Responsibilities also include develop build and migration scripts to roll the code into the test and production environment as a part of SDLC process and support post production issues and enhancement of the end users.
• Technologies Used: Oracle Database 11g/10g , Informatica - 8.6/8.1/7.0 Designer, Workflow Manager, Repository Manager, Deployment Groups , UNIX, SQL Plus, PL/SQL, TOAD 9.7, BMC Remedy, SAP Front end

Confidential

Sr. Software Engineer

• Project: Internet Banking and Bill Pay
• The primary task of this project was to integrate the data stored in various physical infrastructure locations and bring the data into the centralized location of the data warehouse repository which enables the Business and Reporting team to access the data for their future forecast. Responsibilities include analyze user requirements, build star schema for the data warehousing RAW, STAGE, ODS targets. Design and Develop Informatica ETL mappings, workflows for loading data from various online banking and bill pay interface sources and load the data into the target layers of the data warehousing /data mart tables.
• Used reusable objects like maplets, transformations and several other complex transformations like Aggregate, Normalizer, Joiners and Lookups and tuned the Informatica caches to speed up the SQL queries.
• Developed required SQL scripts, Stored Procedures, Functions and triggers to apply in the transformations of the mappings.
• Perform QA and Code review for my code and other developer's code.
• Followed Agile SDLC process to roll the code into the Dev/Test/Prod environments.
• Technologies Used: Oracle 10g , Informatica - 8.6/8.1/7.0 Designer, Workflow Manager, Workflow Monitor, Repository Manager UNIX, PERL, SQL Plus, PL/SQL Packages, Stored procedures, Functions, Triggers TOAD 9.7
• Project: Home Banking and Lending Application
• Digital Insight Corporation is the leading online banking provider for financial institutions. Digital Insight enables banks and credit unions to become the trusted transaction hub for their retail and commercial customers. Digital Insight offers consumer and business Internet banking, online lending, electronic bill payment and presentment, check imaging, account-to-account transfers.
• Analyzing requirements, work with various groups of project and hold discussions in nailing down the various modules of the project, work with developers to integrate the various pieces of code.
• Implemented Object tree/XSL/XSQL /PLSQLDOM technology for XML parsing for the first time in Digital Insight.
• Developed PL/SQL Stored Procedure, Triggers, Packages, Functions and views, Created Object Types, Collection Types, Tables, and Indexes.
• Performed Application Tuning Analyze Statistics, Running Explain plan to check the optimization and tune the SQL queries .
• Used BLOB, CLOB, BFILE data types to retrieve and store the lending applicant data including other details that comes in the form of XML generated data
• Technologies Used: Oracle 10g , Informatica - 8.6/8.1/7.0 Designer, Workflow Manager, Workflow Monitor, Repository Manager UNIX, PERL, SQL Plus, PL/SQL Packages, Stored procedures, Functions, Triggers TOAD 9.7

Confidential

Software Engineer

Confidential

• Project: Brokerage Operations Support Schwab Revenue Sharing System
• Designed and developed UI /relevant Reports using PERL/CGI to enable the brokerage operations team to handle multiple deals and to perform various operations like buys, sell, deliver transfer, deliver out, etc. on behalf of investors who have invested in pre IPO companies looking for private funds
• Developed a suite of reports, stored procedures and views based on which, Member Relations can find the list of non-verified Schwab Members and get them verified, Brokerage Operations can look at the transactions made by these investors, and a summary, based on which Finance can make the payment.

Confidential

• Project: Engineering Failure Analysis EFA - EFA is a Web tool application for the Quality and Service department that enable online support to internal Cisco users and external Cisco customers on Failure Parts. EFA tool automatically queries and generates various online Web Reports and checklists to the quality engineers, support, maintenance and Cisco customers.
• Involved in Analysis, Design, Development, and implementation of EFA GUI System which includes development of table structures, stored procedures, functions and database triggers for the, above system.
• Supported the Maintenance Group

Confidential

• Project: Part Failure Analysis System - Part failure analysis system is a tracking of failure parts that arrives from different customers in different databases
• Responsible for design, development, testing and implementation.

Confidential

• Project: Drug testing lab Maintenance and Billing System
• Responsible for the development of the customer drug tracking system to keep track of various drug tests conducted for customers to ensure that the client is drug free and eligible to take job.
• Developed table structures, packages, stored procedures, functions, database triggers and responsible for backend connectivity using JDBC-ODBC Bridge.

Confidential

Software Engineer

• Project: Flexfield Accounting System
• Designed and developed table structures, LOV's and ER Diagrams using Designer 2000.
• Developed report, functions procedures, database triggers for the above module.

Confidential

Software Engineer

• Project: Object modeling Designer
• Involved in designing tables, backend stored procedures, functions and triggers for the GUI Data Model.
• Project: Material Management System MMS
• Involved in designing GUI, database tables, procedures, functions, forms, reports and database triggers for the above modules.
• Project: Bugs Tracking System
• Involved in designing database and structure for the database and developed user interface using forms 4.0 and forms 4.5.
• Used PL/SQL extensively in procedures, functions and form triggers.
• Project: Language Code Analyzer
• Analysis, Design and development and testing.
• Technologies Used: Oracle 7.1, Novell Netware 4.0, Forms 4.0/4.5, PL-SQL, SQL Plus, Reportwriter 2.0/2.5

TECHNICAL SKILLS:

• ETL: Informatica 8.6/8.5/8.1 and 7.1.4 , datastage 8.1, Oracle Hyperion Plugins
• Reporting Tool: Hyperion Planning and Hyperion Essbase
• Databases: Oracle 11g/10g/9.i/8.i , SQL Server 7.0/2000, Informix 7.x
• Tools Used: Erwin 4.1, Toad 9.7 Application Development Tool, BI Business Intelligence , Visio, Putty
• Languages: SQL, PL/SQL, C, Perl CGI 5.0, Java 2.0 /JDBC
• DB Tools: Oracle SQL Loader, SQL PLUS
• Shells: UNIX Scripting C, KORN, AWK, And BOURNE Java Tools: Eclipse
• Applications: MS-VISIO, MS-Office
• Configuration Management Tool: BMC Remedy, UNIX RCS, MS-SourceSafe, P4 Perforce , clearquest
• Platforms: AIX 5L Ver. 5.3 , Linux OS, Sun Solaris, WINDOWS XP/NT/2000 BMC Remedy
• Others: Basic Knowledge of SAP Front end, UltraEdit