SUMMARY:

• 10 years of software engineering experience in application and data architecture, design and implementation of software solutions, products and tools based on Oracle, C/C++, Java, SQL Server and Microsoft .Net technologies. Functional domains include Banking, Credit Cards, Insurance, Manufacturing and Entertainment.
• 7 years of leading development teams on architecture and design, development and implementation of several full lifecycle projects, data conversions, system upgrades, integration and legacy modernization.
• Proven track record of successful decision making with respect to technology, architecture and processes, and astutely employing industry standard CASE tools, conventional and agile methodologies. Always exceeded expectations on end product, delivery and quality while driving up productivity.
• Outstanding communication, personal effectiveness and collaboration skills. Innovative, goal driven and detail oriented. Astute problem solver with breadth of perspective and exceptional analytical abilities.
• Database Design and Implementation Relational and Dimensional Data Modeling
• Advanced PL/SQL Programming Advanced SQL OLAP/OLTP Oracle Extensibility Architecture
• Electronic Data Interchange Change Data Capture Server - Side Scripting and Development Oracle XMLDB
• SQL and PLSQL Performance Tuning Data Replication Data Partitioning Data Warehousing Business Intelligence Application Architecture and Design Design Patterns Data Structures & Algorithms

TECHNICAL SKILLS:

Database Systems: Oracle 11g/10g/9i/8i, SQL Server 2003, DB2, MS Access, FoxPro, DBase 3 Plus

Programming: SQL, PL/SQL, C/C++, Pro*C, VB.Net, Java, HTML, XML, Java Script, PERL, UNIX Shell

Development Tools: Oracle Forms/Reports 10g/6i, Workflow Builder 2.6, Discoverer 4.0, SQL* Loader, Toad

Performance Tuning: Explain Plan, SQL Trace, TKPROF, CBO trace (event 10053), Hints, profilers, CBO Statistics

Applications: MS Office/Projects, PVCS Version Manager/Tracker, Remedy v4/v7, Rational Clear-Quest

Concepts/Processes: Use-Case/ER modeling, Unified process, Agile development, RAD, Design Patterns, SOA

CASE Tools: UML, Oracle Designer, SQL Developer, Erwin, Visio

PROFESSIONAL EXPERIENCE:

Confidential

Sr Oracle Developer / Application Architect

Responsibilities:

• Performed system architecture, data modeling, UI design and development for system enhancements, integration, data conversions and projects. Analyzed and tuned SQL and PL/SQL for performance. Replaced procedural iterations with astute algorithm driven highly scalable solutions.
• Developed formatted reports in Excel format using the Java API’s of the Apache POI project; developed XML reports using XMLDB; Developed reports with Hyperion SQR and Oracle reports.
• Simplified complex SQL functionality with SQL Types, Analytic functions, SQL MODEL, recursive sub-query factoring, PIVOT, Instead-Of triggers for views and compound triggers specifically with merge operations.
• Developed several PL/SQL components including triggers and Object types, Unix shell scripts, PERL programs, AWK programs for implementing database and server-side functionality, file formatting, job scheduling, tracking and mailing.
• Involved in analysis and designing solutions to upgrade SQR to version 11g and the Database from 9i to 11gR2.

Environment: Oracle 9i/11g, 11gAS, PL/SQL, Forms/Reports 9i//11g, PERL, Unix/Linux, Java

Confidential

Sr Oracle Developer / Application Architect

Responsibilities:

• Developed several packages, procedure, functions and triggers with bulk processing, debugging and exception handling capabilities. Built scalable interfaces and completely autonomous components with collections and types.
• Modified existing and developed new Oracle Forms and Reports for enhancements, projects and upgrades. Modified Pro*C and Java programs for maintenance and defect fixes. Maintained legacy SQR reports.
• Resolved production issues related to application, data and performance. Developed complex SQL using analytical functions, hierarchical SQL and sub-query factoring to efficiently analyze and resolve data issues and Ad-hoc reports.
• Led efforts on Data Conversions, legacy upgrades and system integrations - developed efficient code for staging, mapping, processing, validating, translating, and loading multiple targets. Used SQL*loader, external tables & import/export utilities; Forms Reports upgrade to 11g - built C based tools using forms API’s for upgrade related changes to the forms code.
• Developed server-side program with the Unix Shell, PERL, AWK to enable jobs processing, monitoring, data file processing and extraction, automation, file transfers and emailing. Configured jobs in AUTOSYS, incoming and outgoing data feeds in RAFT.
• Integrated internal applications with third party EDM solutions. Developed code to process XML data feeds with XMLDB features, generate XML based acknowledgements and reverse feeds and generate summary reports.
• Developed solution architecture and design prototypes for EDI based benefit enrollment (ANSI-834); Designed a programmatic tool to identify function points and extract business rules from the source code; Designed a programmatic interface to Remedy data with API’s to retrieve raw data for advanced analysis and reporting.

Environment: Oracle 9i/11g, 11gAS, PL/SQL, Forms/Reports 9i/10g/11g, PERL, Unix Shell, C/C++, Pro*C, Java, Linux

Confidential

SYSTEMS ANALYST - ORACLE DEVELOPER

Responsibilities:

• Developed efficient PL/SQL procedures to convert GL entries, customer data, purchase orders, on-hand quantities and items using open interfaces and APIs. Created and loaded staging tables, mapped and validated data elements.
• Customized forms with CUSTOM.PLL; Modified and built complex reports; Developed PL/SQL based reports for Year-To-Date and Month-To-Date Summary reporting. Customized workflows - Enhanced the purchasing approval work flow for additional notifications and processes.

Environment: Oracle Apps 11i, Database 9i, Forms/Reports 6i/9i, PL/SQL, Workflows 2.6, JSP, Linux & SQL* Loader

Confidential

SYSTEMS ANALYST

Responsibilities:

• Designed and developed configurable tools to mine and extract data items from text documents and convert them into Excel format with formatting and summary options. Implemented with C++ and OLE.
• Mapped the data Model of the CQ database, put together ER diagrams. Developed interfaces to directly query data from CQ, manipulate data and generate advanced statistics. Integrated legacy defect management systems with CQ.

Environment: SQL Server 2003, VB.Net 2003, C, Visual C++, PERL, IBM Clear Quest, Crystal Reports

Confidential

SYSTEMS ENGINEER

Responsibilities:

• Designed and developed PL/SQL, Pro*C and Java programs for maintenance and implementing major projects on CITI-Alert Charging; Birthday Wish Alert; Account Mini-statement Alerts; On-line Rewards Redemption and Pocket Money Card modules. Converted Forms 3.0 to Pro*C. Accurately converted rules, program flow, UI, validations and navigations
• Tuned SQL; Optimized Pro*C with structure pointers, linked lists and hashes. Developed astute solutions to reduce job failures with automated diagnosis of data and integrity issues. Provided 24/7 production and system support.

Environment: Forms 3.0, Oracle 8i, C, C++, Pro*C, Oracle 8/8i, UNIX, Shell Scripts, PERL, TOAD and SQL Loader