SUMMARY:

Highly - effective professional with extensive, diverse experience developing software, including database modeling/design, ETL development and reporting. Strong individual contributor and team player. Excellent verbal and written communication skills at all levels.

OBJECTIVE:

Oracle PL/SQL - Informatica ETL- Developer /Analyst

TECHNICAL SKILLS:Hardware/Operating Systems :  HP UNIX (HP/UX v10.2), Linux v2.6.9, VAX/VMS, SUN OS (UNIX) /Solaris, MS-DOS,HP-9000, Windows, Window 95,Windows 2000, Windows NT /XP

Software: Oracle RDBMS v11g/10.2g/9i, Sybase RDBMS v12.5, NCR Teradata RDBMS, Rdb RDBMS, S-1032 RDBMS, ANSI SQL, RMS File structure and handling, CDD, CMS/MMS, DTR, UDMS, DecForms,

Editors:  Vi, EDT, LSE, EVE

Languages:  Major - COBOL, Pro*C, Pro*COBOL

Minor:  BASIC, C, FORTRAN, Pascal, Visual Basic 5.0

DB Tools: Informatica Powercenter 7.1/8.1/8.6/9. x, Oracle Developer 2000 - Oracle Forms 6i/5.0/4.5/4.0, Oracle Reports 3.0/2.5/2.0, Sql*Plus, Sql*Loader, PL/SQL, Oracle CASE 5.1, Discoverer 2000 v 4.1, Embarcadero Rapid Sql 7.3.1, Quest Toad v9.6, Cognos, Microsoft Project, DEFT CASE tools on MAC, Structured Design Methodology, PVCS Version Control, Dbase III Plus, CLIPPER etc,

Internet tools:  Microsoft FrontPage 97/ America On-line’s AOL press, HTML

Misc. Software:  Lotus Notes, Lotus sametime, CA Autosys Job scheduler, Windows Outlook Mail, Microsoft Office, Perforce /RCS Version control, Hummingbird/Putty connectivity tool etc

PROFESSIONAL EXPERIENCE:

Confidential, San Diego, CA 

Oracle PL/SQL Programmer/ETL Developer

Responsibilities:

• Gathered, analyzed and defined user requirements for enhancements/maintenance of the transactional database systems.
• Completed assigned technical tasks on time which included analysis (gap analysis, data mapping, data definition etc), designing which included documentation of transformation rules, data validation rules, business applicability rules etc, development, testing, implementation, monitoring, maintenance, production support, user training documentation etc.
• Worked on loading of the stock /client portfolio data into the LPL Uniform Model data warehouse’s data marts using Informatica ETL Powercenter tool . Data marts are based in Oracle database.
• Work with the Data Modeler to enhance the structure of the data marts to the requirements of the business community.
• Created and maintained PL/SQL stored procedures, functions and optimized queries for performance. Pl/Sql procedures are also used to transfer data from various Sql Server 8.0 database-based applications to Oracle 9i/10g/11g-based Commission and Registration system.
• Train new hires.
• The technical environment consists of HP/ UX Unix/Linux, Oracle v9i/10g/11g, Oracle Forms/Reports, Informatica ETL Powercenter v8.1/8.6/9.6, Quest’s Sql Navigator/Toad 9.7.2, MS Outlook email, HP Quality Center, Windows NT etc.

Confidential, Phoenix, AZ 

Oracle PL/SQL Informatica ETL - Developer/Analyst

Responsibilities:

• Completed assigned technical tasks on time which included analysis (gap analysis, data mapping, data definition etc), designing which included documentation of transformation rules, data validation rules, business applicability rules etc, development, testing, implementation, monitoring, maintenance, production support, user training documentation etc.
• Informatica Powercenter 8.1/8.6 ETL toolset is used to transfer data from various DB2 database based applications to Oracle 10.g-based data warehouse.
• Wrote UNIX scripts to automate the loading of the data into the multi-terabyte data warehouse thru Informatica toolset and Sql*Loader utility. Created and maintained PL/SQL stored procedures, functions and optimized queries for performance.
• Train new hires.
• The technical environment consists of HP/ UX Unix/Linux, Oracle v10g, Informatica ETL Powercenter v8.1/8.6, Quest’s Toad v9.6, Unix crontab job scheduler, MS Outlook email, MS Communicator, Clarity, Windows NT etc.

Confidential, Burbank, CA

Oracle PL/SQL /Sybase Informatica ETL Developer /Analyst

Responsibilities:

• Completed assigned technical tasks on time which included analysis, designing, development, testing, implementation, monitoring, maintenance, production support, documentation etc.
• Informatica Powercenter 7.1 ETL tool is used to transfer data/files from various applications to Sybase/Oracle-based data warehouse. Worked with the data modeler with the preparation of logical database design and also created physical database schema objects on Oracle 10g database.
• Wrote UNIX scripts to automate the loading of the data into the data warehouse. Created and maintained stored procedures using PL/SQL and used Sql*Loader to load data into oracle tables. Also used Sybase utilities like BCP in and BCP out for loading data into Sybase tables.
• Ensuring accuracy, integrity and completeness of the data in DW were part of my primary duties.
• Code, install and monitor intra-day and batch jobs running on CA Autosys job scheduling servers.
• Perform production support on-call duties.
• Also used Sql*Loader and PL/SQL to load data from the legacy system into the database.
• Provide Oracle, Sybase, and Powercenter training to the new hires.
• Provide Oracle Application DBA support on as-needed basis.
• The technical environment consists of HP/ UX unix, Oracle v10g, Sybase v12.5, Informatica ETL Powercenter v7.1, CA AutoSys Job Scheduler, Embarcadero Rapid Sql v7.3, Lotus Notes email, Perforce Version Control System, Windows NT etc.

Confidential, Irvine, CA 

Consultant/Sr. Database Programmer Analyst

Responsibilities:

• Wrote functional requirement documents, interfacing with the customers and IT teams. Customers included users from the Finance, Compliance, Internet Web Design teams. Prepared technical design documents for the design of the data marts. Prepared reports using Cognos BI reporting tools.
• Completed assigned technical tasks on time (e.g. analysis, designing, development, testing, implementation, monitoring, maintenance, production support, documentation etc). Wrote UNIX scripts to automate the validating, loading and monitoring of the data into the Data Warehouse. Ensuring accuracy, integrity and completeness of the data in DW were part of my primary duties.
• Resolved assigned Trouble Tickets within the established timeframes whole providing quality customer service.
• Performed problem analysis and resolution activities to provide effective system solutions.
• Occasionally led other Technical Support/ Support team members in selected project activities.
• Used Oracle tools such as SQL*Loader and PL/SQL to load data into Oracle Data Warehouse.
• Also wrote UNIX shell scripts to create/transfer files from Oracle database on VAX/VMS system to the Teradata database on NCR UNIX machine using standard ETL procedures.
• Used Control-M to schedule jobs.

Confidential, Burbank, CA

Programming Specialist

Responsibilities:

• Prepared the Entity Relationship diagrams using Designer 2000, prepared logical database design and also created physical database schema using Oracle 7.3. The client-server environment consists of Windows NT, Novell network.
• Prepared forms and reports using the Developer 2000 tools such as Form Builder and Report Builder.
• Also used Sql*Loader and PL/SQL to load data from the legacy system into the database.

Confidential, Huntington Beach, CA

Consultant/Computer Programmer/Analyst

Responsibilities:

• Prepared the Process Flow and Entity Relationship diagrams using Designer 2000, prepared logical database design and also created physical database schema using Oracle 8.0.3. The client-server environment consists of Windows NT, Novell network and unix (HP/UX 10.20).
• Prepared forms and reports using the Developer 2000 tools such as Form Builder and Report Builder.

Confidential, Anaheim, CA

Programming Consultant

Responsibilities:

• Used Oracle tools such as SQL*Loader and PL/SQL to load data into Oracle DB and Oracle Forms for online transaction processing.
• Designed the daily reporting batch procedures for the reports to run in the batch from a dedicated PC.

Confidential, Irvine, CA 

Consultant/Computer Programming Specialist

Responsibilities:

• Analyzed and defined requirements for a brand new oracle-based system to track equipment performance. The equipment is primarily used to manufacture modem chips.
• Designed the Original Equipment Effectiveness system using Designer 2000. Developed PL/SQL procedures and functions for the batch processing. Also designed forms to access data using the Developer 2000 tools such as Forms 4.5 tool and also created several reports using Reports 2.5.
• Designed the logical and physical database for the system to reside on the Oracle server using Oracle 7.3. Wrote PL/SQL procedures to convert the existing data to this system.
• Created HTML documents for hosting some of the oracle data on the company’s intranet server.

Confidential, Long Beach, CA

Computer Programmer

Responsibilities:

• Provided technical expertise to convert legacy data resident on IBM 3270 to an Oracle based manufacturing package resident on HP 9000. The client-server environment consists of Windows, Novell network and unix (HP/UX 10.20) with Oracle database servers.
• Also designed new reports and panels using Oracle Developer 2000 toolset, PL/SQL to interface with database.

Confidential, Los Angeles, CA

Computer Programming Consultant

Responsibilities:

• Provided on-going support to maintain Project Management Information Systems (PMIS) database consisting of 180 tables and over 400 users. The client-server environment consists of Windows NT, Banyan Vines network and unix (HP/UX 10.20) with Oracle database servers.
• Also analyzed, designed new sub-systems using Oracle Developer 2000 toolset, Pro* C, PL/SQL to interface with Oracle Financials and PeopleSoft databases.

Confidential, Orange, CA

Computer Programmer

Responsibilities:

• Gathering of system requirements, designing/coding of forms to access ORACLE tables using DEVELOPER 2000 tools such as ORACLE FORMS 4.5 and designing and programming reports using the ORACLE REPORTS V2.5/Impromptu report generator. Coded PL/SQL procedures to help convert the legacy data into Oracle tables.
• Worked in close interaction with other team members on the revamping of the legacy system into a GUI-based system using ORACLE RDBMS and ORACLE CASE in a Client Server environment using PCs and Sun Solaris servers/HP 9000 systems.