SUMMARY:

• As an Oracle Advanced PL/SQL Developer, seek a new challenge that can utilize my skillsets as an Oracle PL/SQL programmer, ETL, UNIX programmer.
• Experienced Oracle developer with lots of UNIX shell scripting experience.
• Skilled in Oracle performance tuning especially where Oracle SQL is concerned.
• Deep SQL, PL/SQL background.
• Worked as the supporting complex, mission - critical Oracle systems, doing both production support and development.
• Worked as an Oracle developer doing Forms, Reports, PL/SQL and UNIX
• Worked in a similar capacity to the above except with more responsibilities including but not limited to Oracle performance tuning and lead programmer analyst on mission-critical handheld system, which received daily, nationwide downloads from Oracle send uploaded business data (invoices) in xml format to the same Oracle database.
• Worked with multiples projects Traffic Management Systems and Money manager systems on Oracle database 11g on UNIX operating system.
• Designing and implementing stored procedures, views and other application database code objects.
• Worked with huge conversion and support application for a meter reading company.
• Worked on Oracle 10G database on merger project between two huge companies (AT&T and Bellsouth)
• Working on multiple projects such as Key Measure Indicators, Inventory Management System using Oracle 9(i),SQL, PL/SQL,forms6i, reports6i, Oracle portal30(Web Reports), SqlServer2000, Unix, ETL, Abinitio, Sql Navigator/Toad, VSS, PVCS. Toad/Sql Navigator.
• DSS Health applications using Oracle 9(I), Sun Solaris, MS Access, Windows 2000, Emberkadero, VSS.

TECHNICAL SKILLS:

Database Software: Oracle 7.x, 8.x, 9(I), 10G, SQL*Plus, PL/SQL, Forms 3.0/4.0/4.5/5.0/6 i (Developer/2000), Reports 2.0/3.0/6i (Developer/2000), SQR(PeopleSoft tool), SQL Navigator, Oracle Portals 3.0 in Web deployment, Oracle 9(I) Data warehousing, Decision Support Systems (DSS), Informatica/Abinitio, ETL, SQL Loader, ERWin3.0, Oracle Manufacturing and Financial Applications 10.6/10.7 - Purchasing Module, Concurrent Manager, Knowledge of Oracle DBA.

Windows Software: Visual Basic 6.0, ODBC, MS Access, Visual SourceSafe (VSS) in version control/configuration management, Microsoft Office products (Word, Excel, PowerPoint, Project).

Operating Systems: Sun Solaris 2.5.1, HP UNIX, AIX Ver 3.5.4, Windows NT 4.0, Windows 2000/3.11/95. Windows XP, Windows Vista.

Languages/Tools: C, UNIX Shell Scripts, TOAD, Visio, HTML, FrontPage, TCP/IP CHAMELEON

Reports Tools: Developer/2000 Reports 6(I), Crystal Reports, Business Objects 5.0, BRIO

Hardware: IBM RS-6000, HP-9000. PC, Sun Sparc Enterprise 5000server

Industries: Telecom, State Healthcare, Workers Comp, Manufacturing, Financials, Supply Chain, Key Measures

PROFESSIONAL EXPERIENCE:

Confidential, GA

Senior Oracle Database Developer III

Responsibilities:

• Working with multiples projects Traffic Management Systems and Money manager systems on Oracle database 11g on UNIX operating system.
• Receive data from multiple sources like AMS, Sprint MAF, and NDW and Amdocs systems and load them into destinations tables thru mapping the flat files to Oracle external tables and load data into destination tables using ETL process.
• These processes are being done thru massive PL/SQL stored procedures which are invoked in Perl/shell scripts which are scheduled thru cron jobs.
• Automated the table’s partitions using new feature of Oracle 11g.
• After data is loaded reports are generated on daily basis and mailed to appropriate users for billing.
• Resolve issues with Amdocs and other internal systems using Service Manager.

Environment: UNIX Sun Solaris operating system, SVN version control, Sql Developer and TOAD for Oracle Development

Senior Oracle Database Developer

Responsibilities:

• Worked with huge conversion and support application for a meter reading company.
• It is a re-write from Sql server database to Oracle 10G database with the .Net front application.
• Involves in understanding existing code of Sql server procedures and re-write them in PL/SQL, ETL of Sql server to Oracle database, Development, Unit testing, production move, and user interaction. Version control TFS.
• Application involves both OLTP OLAP.
• Implementing many features 10G. (SQL, PL/SQL).
• Used Informatica Power Center for (ETL) extraction, transformation and loading data from SQL Server source systems into oracle database.
• Created mappings using Designer and extracted data from various sources, transformed data according to the requirement.
• Involved in extracting the data from the Flat Files and Relational databases into staging area.
• OCDB Application: Do support and enhance OCDB applications with 10g/11g oracle for various utilities companies using lots of PL/SQL procedure, packages, functions, triggers and Oracle objects etc.
• Used bulk collect in procedure for DMLs.
• Process involves installing two way meters, integration of water/gas/electric meters together.
• Job also involves data read, data feed, transactional process and report generation using UNIX shell scripting.
• Did application tuning using explain plan and Tkprof.
• Created table partitioning.
• Using Agile Methodology and sprints for developing applications tasks.
• Used agile methodology with TFS.

Environment: Operating systems: UNIX Sun Solaris operating system, SVN and TFS version control, Sql Developer and TOAD for Oracle Development Jira Agile methodology.

Senior Oracle Database Developer

Responsibilities:

• Worked on Oracle 10G database on merger project between two huge companies (AT&T and Bellsouth).
• Worked with Oracle Database.
• Complex Sql, Pl/Sql, procedures, functions packages.
• Used bulk collect/merge features to process data into tables.
• Created partitions for the tables.
• Working on UNIX operating system.
• Wrote Shell scripts.
• Job involves loading the tables with huge data, using that to update the tables.
• Created Ssh keys to multiple UNIX boxes for input and output of the files.

Systems Analyst/Data Analyst

Responsibilities:

• Developed OLTP applications using SQL scripts, PL/SQL, Forms6i and Reports6i.
• Created partitions on tables for quick retrieval of data.
• Used bulk collections for fast processing of the data to databases.
• Gathered requirements, designed and developed Key Measure Indicators data models.
• Developed and supported ETL processes using SQL scripts, PL/SQL, Abinitio from to SAP to Oracle.
• Designed Star schema.
• Created Dashboard OLAP Oracle Portals reports using PL/SQL packages and procedures for Data warehousing.
• Developed and maintained DTS packages with embedded VBScripts and Store procedures in SqlServer2000 to handle multiple data files into different databases.
• Wrote huge UNIX interface (shell scripts) to process flat files and load into Oracle database with lot of gateways.
• Code promotions with SOX compliance.
• Mentored peers and business users.
• Used VSS and PVCS for version control.
• On Call Support.
• MSSQL Server Programming (T-SQL).

Senior Oracle Developer/Analyst/Business Objects Developer

Responsibilities:

• Developed OLAP reports writing complex SQL scripts, PL/SQL packages, procedures, functions for Business Objects reports on the operating system UNIX and Windows2000.
• Wrote Database triggers for business rules.
• Involved in data mapping for tables and columns in multiple databases for ETL transaction using Informatica.
• Used MS access for data checks before loading into destination tables.

Environment: DSS Health applications using Oracle 9(I), Sun Solaris, MS Access, Windows 2000, Emberkadero, VSS