SUMMARY:

• A Professional in Information Technology is interested in working for a stable Organization.
• IT professional with over 10 years of experience in Database application development, Data Management, business intelligence and technical support and leadership.
• Over 10 years experience in relational Database environments, with extensive experience in Oracle DBA and PL/SQL. Strong SQL skills.
• Over 4 year in ETL, using in house tools.
• Over 4.5 year on Data Warehouse projects
• Experience in Business Intelligence.
• In depth experience with UNIX.
• Strong communication skills.

TECHNICAL SKILLS:

• Leadership
• ETL, OWB (Oracle Warehouse Builder)
• Oracle - PL/SQL
• Oracle 9i - 11g IAS Upgrade & Apps Migration
• SQL*Loader
• UML
• Unix - Shell Scripts ( HP/ Sun Solaris)
• CRM, Fixed Asset, FMIS, ADW
• Data migration
• LDAP (Lightweight Directory Access Protocol)
• Oracle - APPS DBA
• Visio 6.x
• Siebel Enterprise Integration Manager
• BIAP Reports.
• QTP, Quality Center background, strong in SQL queries, CRM applications and Documentum.

PROFESSIONAL EXPERIENCE:

Confidential, King of Prussia, PA

• As a Database Developer for the Operations Metrics Portal, OMP, I provided high quality technology Solutions that address business needs by developing feature enhancements to the OMP Portal, i.e. Operations Metrics Portal. l delivered strong object-oriented design skills and strong analytical capabilities. Especially in the Area of distributed computed infrastructures. My other strengths would include experience with TDD/Agile development methodologies and other programming languages. My financial background and knowledge was a great help in creating feature enhancements.
• As an Application Developer in Oracle 11g, l participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed IT solution. l participated in design reviews and provided input to the design recommendations; incorporated security requirements into design; and provided input to information/data flow and generally was involved in the full Project Life Cycle. Additionally, l documented the detailed application specifications, translated technical requirements into programmed application modules and developed/enhanced software application modules in Oracle.

Confidential

ETL/Oracle Database Developer

• Created PL/SQL packages and UNIX Scripts. Extensive experience with UNIX technologies.
• As an Oracle database developer/analyst, developed PL/SQL and UNIX Procedures, functions and Packages.
• Worked in Production Support, and adding new Product Releases. Also worked on additions to the Healthcare Management system, with Oracle database and PL/SQL in a Data Warehouse environment.
• Release management of products on Bi-Weekly basis using Source Code management tools i.e. subversion.
• Strong Agile Methodology on a Bi-Weekly basis in software and business systems design, analysis, and development.

Confidential, Havertown, PA

ETL/Oracle Database Developer

• Responsible for the Migration and Upgrade of multiple databases. Requirements Gathering, Design, Implementation, Training/Testing of Software Development for Remediation efforts.
• Developed numerous Oracle IAS reports and SQL*Plus to summarize monthly and weekly accounts receivable data.
• Created PL/SQL packages and UNIX Scripts. Extensive experience with UNIX technologies.
• As an Oracle database developer/analyst, developed PL/SQL and UNIX Procedures, functions and Packages.
• Performance Optimization. Employed Explain Plan and SQL*Trace to analyze query path and performance. Tuned SQL scripts statements for their optimum performance.
• Created PL/SQL code as required to support Daily, Weekly Batch Processes. Additional Qualifications:

Confidential, Havertown, PA

ETL / Oracle Database Developer

• Responsible for the ESA (Enterprise Sys Arch.) Requirements Gathering, Design, Implementation, Training/Testing of Software Development for Employee Management System (EIMS) Remediation effort.
• Developed numerous Oracle IAS reports and SQL*Plus to summarize monthly and weekly accounts receivable data.
• Created PL/SQL packages and UNIX Scripts. Extensive experience with UNIX technologies.
• Performance Optimization. Employed Explain Plan and SQL*Trace to analyze query path and performance. Tuned SQL scripts statements for their optimum performance.
• Created PL/SQL code as required to support Daily, Weekly Batch Processes. Additional Qualifications:

Confidential, Philadelphia, PA

ETL / Oracle Database Integration Specialist

• Served as the Technical Lead during testing phases of Territory & Portfolio Indexing Project. ETL tool was in house product and was very similar to Data migration .
• Offshore project requirements definition and Implementation, on a daily basis, managing the compliance of the program with its initial requirements, and the translation of Business needs to programmers and developers.
• Offshore project training: Trained an offshore team to support the production system and to enhance the related documentation for solving problems, and solving issues in the database.
• Created PL/SQL and UNIX Scripts for and supported the Prescriber to Territory relationships. In addition to strong experience in CRM applications Data migration Visio 6.0 and Documentum.
• Designed and developed reports for applications. The interface from the applications will publish all the reports to the web.
• This also includes ‘Future Territories’ which denotes that this may not be the Current Alignment but will be Current by the time this Month/Quarter’s Account Targeting data is loaded to SFA (Sales Force Automation DWT Team).
• Modify PL/SQL code for batch processes and perform unit testing in the development environment
• Experience architecting, designing, and deployment environments for global web-based systems

  Extensive experience with UNIX technologies.

Confidential, Plymouth Meeting, PA

ETL / Oracle Database Developer:

• The IMS Healthcare Relational Spheres (HCR) is developing GMR Data Migration operations in the ETL healthcare sector.
• As an Oracle database developer/analyst, developed PL/SQL and UNIX Procedures and Packages for MII core database based on the views in the MII Core database.
• Wrote PL/SQL scripts and packages to validate and analyze the data architecture, and Data Sources.
• The views were designed to map the required fields in the MII Core tables to corresponding fields in the tables in the Data Warehouse.
• Maintained Metrics log information of the extracts in the metrics log table.
• Separate special onetime processing was scripted to load the history data into HCRS Data Warehouse.

Confidential, Collegeville, PA

ETL / Oracle Database Developer / Analyst

• Responsible for the development, maintenance and support of the PL/SQL Functions and Packages in Oracle 9i, and UNIX interfaces used in the ETL Sampling process. ETL tool was developed in house.
• Created interfaces in PL/SQL and UNIX Scripts supporting Inbound Sampling to Outbound Sampling.
• Also worked on Disbursement, Contact Management, Integrated Customer View (ICV), and Invoice generation. Some interfaces touched third party applications such as SAMSYS and Sample Guardian (SG).
• The front end was developed in Siebel 2000, with a backend in Oracle.
• The technical architecture for the production system consisted of remote clients, and connected clients. These clients interface to the Confidential LAN.
• A Complex e-commerce application that contains two web applications and uses multiple Java EE 6 APIs:
• Java Server (Tomcat and Apache) Faces technology.
• Contexts and Dependency Injection for the Java EE Platform (CDI)
• Java API for XML Web Services (JAX-WS)
• Java API for restful Web Services (JAX-RS)
• Java Persistence API (JPA)
• Java API for JavaBeans Validation (Bean Validation)
• Enterprise JavaBeans (EJB) technology
• The application consists of the following projects:
• Store: A web application that has a product catalog, customer self-registration, and a shopping cart.
• It also has an administration interface for product, category, and user management. The project name is d-store.
• Shipment: A web application interface for order shipment management. The project name is d-shipment.
• Payment: A web service application that has a JAX-WS service for order payment. The project name is d-payment.
• Resources: A simple Java archive project that contains all resources used by the web projects.
• It includes messages CSS style sheets, images, JavaScript files, and Java Server Faces composite components.
• The project name is d-resources.
• Entities: A simple Java archive project that contains all JPA entities.
• This project is shared among other projects that use the entities. The project name is entities.
• Events: A simple Java archive project used as a CDI event. The project name is events.

Confidential, Mt. Laurel, NJ

Assistant Project Manager

• Technical Support in Global Directory System (GDS) and LDAP. Involved in building miniQA servers, and PoC servers. Used eTrust Directory to store and maintain secured customer data.
• Deployed configuration updates and changes in the (Bishops Gate/Pre Production Test) environment
• Built GDS (Global Directory System) servers for miniQA labs
• Built a stand-alone GDS server in Sustain Engineering lab
• Assisted in performance testing in the PoC (Proof of Concept), BG/PPT environment

Confidential, Philadelphia, PA

ETL / Database conversion and loading Analyst

• Wrote database-stored procedures using PL/SQL 9i in both ETL Data Migration (staging area) and ETL OPS databases.
• Wrote SQL*Loader scripts to load various vendor feeds into Data architecture, and Migration database.
• Wrote SQL code to do batch/ business validations at the Data Migration level. The validations involve lookup, error logging and code translation.
• Scheduling and monitoring various Up loaders and Exporters.
• Developed PL/SQL Procedures (Packages), and UNIX shell scripts. To validate and cleanse the data (related to Security Master, Security Cross Reference, Account Master and Performance) coming from the IBM mainframe legacy system.
• Done Performance Tuning using Explain Plan, SQL Hints and various other features of Oracle tools.
• Packaged new database objects into PVCS version control system and coordinated with UAT/QA team

Confidential, Atlantic City, NJ

Database Developer

• Fulfill data requests using a variety of applications and tools including SQL, Oracle PL/SQL, SQL Plus and Pro C using SQL Navigator.
• Worked in Financial production support systems with mid to large-scale application development in a 3-tier client server environment. Redesigned UNIX shell scripts, SQL and PL/SQL on UNIX platforms programs for EDI and OPS data loading to Data Warehouses (Bit Map vs. B-Trees).

Confidential, Allentown, PA

Database Developer

• Identified and supported customer requirements by recommending and implementing effective solutions for a Telemarketing Maintenance System
• Developed technical design specifications and database design using UNIX shell scripting in a network environment.
• Wrote SQL code in UNIX (HP-UX) to do basic business validations at the Data Migration level. The validations involve lookup, error logging and code translation.
• Designed and developed data request programs using a variety of tools including Visual Basic 6.0, Access 2000, Oracle and PL/SQL, SQL Navigator, OMS, Forms, Report, and DBA Studio.

Confidential, Moorestown, NJ

Database Programmer

• Data Conversion and Loading: Developed programs for business requirements, implemented solutions for JCALS System in accordance with departments standards and methodologies.
• Implemented in Pro*C, C (embedded), PL/SQL procedures, SQL*Loader (Oracle) in UNIX / AIX O.S.
• Interfaced four different systems and merged them into one complete system

Confidential, Philadelphia, PA 8

Database Programmer

• Support and identify customer requirements, recommend and implement effective solutions in accordance with HIPAA departmental standards and methodologies.
• Interface claims, enrollment and fee scheduling processes to corporate repository.
• Used SQL Server to write stored procedures and DTS packages.
• The environment is developed in, PL/SQL procedures (Oracle) in UNIX/AIX operating system.
• Implementation of procedures and functions and Oracle PL/SQL Packages and Scripts to implement the functionality and business requirements between the client and the server.

Confidential

ETL

• Developed database-stored procedures using PL/SQL 8i, and 9i in both Data Migration (staging area) and OPS databases.
• Wrote Pro*C code to do basic business validations at the Data Migration level. The validations involve lookup, error logging and code translation.
• Performed scheduling and monitoring of various Up loaders and Exporters.
• Developed complex SQL stored procedures to validate and cleanse the data (related to Security Master, Security Cross Reference, Account Master and Performance) coming from the IBM mainframe system.
• Performed Tuning using Explain Plan, SQL and various other features of Oracle tools.
• Packaged new database objects into SCCS version control system and coordinated with UAT/QA team