SUMMARY:

• Experienced Oracle PL/SQL Developer/Application DBA as well as SQL Developer/Data Analyst
• Worked as an Application DBA in many projects supporting developers and DBA’s in writing stored procedures, triggers, creating tables, indexes and working hand in hand with development teams to define database requirements.
• Designed Developed, Coded, Tested and maintained objects such as: Packages, Procedures, Functions, Triggers, Views, Sequences, PL/SQL Collections, etc.
• Worked as a Business Analyst/Database Developer supporting end - user community and UAT team in evaluating business requirements and creating stored procedures, triggers, ad-hoc reports and SQL code to correct the issue.
• Worked as a SQL Developer/Data Analyst in the most recent project in the Card Services Account Corrections functional area to correct and identify customer impact caused by a business process or operational break. Within this function, I was responsible to correct impacted accounts via recalculating and/or crediting finance charges, fees, and rewards balances, correcting finance charge and fee structures, initiating customer communications, etc.

TECHNICAL SKILLS:

Databases and Tools: Oracle 7.x-11g, Teradata, Teradata SQL Assistant, Hyperion, Advanced Query Tool (AQT), SQL Developer, SQL*Loader, SQL* Plus, Explain Plan, Developer 2000, Oracle Forms 5/6.0/6i/10g/11g,DB2,Toad, Oracle SQL Developer 4.0, PL/SQL DeveloperVersion 1.1.1,Rational Team Concert (RTC), Toad for Data Analysts 3.0

Programming Languages: PL/SQL,SQL, COBOL, JAVA,Dynamic SQL,SQL*Plus,SQL*Loader

Operating Systems: Windows 2000, Windows XP, Windows 8, Windows NT,UNIX, z/OS, Putty, MS Office (Excel, Word),Sun Solaris

PROFESSIONAL EXPERIENCE:

Confidential, WILLMINGTON, DE

SQL Developer/ Data Analyst

Responsibilities:

• Develop SQL code to ensure it is meeting functional and business requirements to perform complex data queries, aggregation of data, data analytics.
• Used inner-join, outer-join, group-by, case. Union, decode and other statements to run against Oracle and Teradata.
• Developed numerous ad-hoc programs to create summaries and listings.
• Involved in calculating complex financial statements, recalculating finance charges over a period of months or years.
• Worked on Source and Target Metadata creation and developed many jobs to load data from source into target.
• Involved in Creating, Appending, Updating table columns and views as well as creating indexes for optimization.
• Validate and test all code for accuracy and efficiency.
• Created output files to defined specifications for downstream systems, and ultimately executing the code and output files.
• Assist in development of the specification by recommending alternative solutions to technical problems.
• Provide programming support of ad-hoc requests and special projects as assigned.
• Extensively used UNIX commands for fetching and checking files.
• Liaised with Project Managers, Business Analyst, Business Stakeholders and other cross-functional groups to resolve business queries, defects, and mitigate escalations

Confidential, Newark, DE

Oracle Application DBA /Application Developer

Responsibilities:

• Designed Developed, Coded, Tested and maintained objects such as: Packages, Procedures, Functions, Triggers, Views, Sequences, PL/SQL Collections, etc.
• Analyzed business requirements and created SQL code to run against Oracle database.
• Performance testing and optimization of code developed.
• Used inner-join, outer-join, group-by, case. Union, decode and other statements.
• Agile development.
• Working with the offshore resources on the consistent basis.
• Liaised with programmers, applications/operational staff, IT project managers and other technical staff.
• Database Object Creation (Tables /Indexes/Views/ Triggers).
• Solid Experience in SQL, PL/SQL and UNIX shell scripts.

Confidential, Philadelphia, PA

Oracle Application Developer

Responsibilities:

• Designed Developed, Coded, Tested and maintained objects such as: Packages, Procedures, Functions, Triggers, Views, Sequences, PL/SQL Collections, etc.
• Analyzed existing Oracle Forms(10g) to extract business rules and replace with PL/SQL and JAVA.
• Created DB link, connecting Legacy system and a new ( Confidential ) system, allowing two systems to communicate with each other, created DB views on the legacy system pointing to the new system ( Confidential ), fooling the legacy system, until the new system will be ready to implement.
• Created more than 80 DB triggers and 80 DB tables for Auditing. Triggers were created After Insert, Update and Delete.

Confidential, West Chester, PA

Oracle Application Developer

Responsibilities:

• Implemented and supported numerous DB IT projects for DB2 and Oracle Databases.
• Developed PL/SQL procedures, triggers, Functions and Packages on Oracle Database.
• Created ad-hoc reports for users on as needed basis using SQL for DB2 and Oracle Databases.
• Met with the data modelers and developers to discuss a data model for the new project.
• Helped with data modeling and implemented database design to support the project planning process.
• Managed database objects: schemas, views, tables, stored procedures and triggers.
• Performed SQL tuning for the SQL code sent to the DBA group for review.
• Loaded data into Oracle Tables using SQL Loader.
• Created Shell Scripts for invoking SQL scripts.
• Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.
• Provided exceptional customer service, responding to inquiries in a timely manner.
• Liaised with programmers, applications/operational staff, IT project managers and other technical staff.
• Loaded and Unloaded data from external files into Oracle and DB2 Databases onas needed basis.

SQR Report Developer

Confidential

Responsibilities:

• Interacted with Business Analysts to gather user requirements and create legacy reports using Hyperion Reporting Environment. Developed report design and specifications based on requirements gathered from various business areas.
• Created 30-40 reports for Tax and Procurement.
• Developed strong expertise with SQL on both DB2 and Oracle Databases.
• Supervised off-shore Team when development of Hyperion was outsourced.

Data Warehouse Developer

Confidential

Responsibilities:

• Produced aggregate reports for Executives and Research Analytical team that provided summarized data by day, week, month sales and other important statistics. This information was used by management to evaluate profitability and identify trends, which aided decision making.
• Assured all SLA requirements were met on a daily basis .
• Supported 24*7 hour on-call rotation.
• Used SQL Loader to load data from external files into Oracle Database.
• Designed PL/SQL code for client’s business process functionality.
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Strong experience in Data warehouse concepts, ETL and UNIX shell scripts.

Confidential, Great Valley, PA

Oracle Forms Developer

Responsibilities:

• Developed and modified existing application forms for the Educational Banner System.
• Interacted with Business Analysts to gather user requirements.
• Created screens for different complexities using Oracle forms 3.0 to 6.0.
• Developed database objects like Stored Procedures, Functions and Packages, Triggers using Oracle 7 Database.