SUMMARY:

• 11 years of Programming experience in Oracle and Web development.
• OCP, OCA and CCNA Certifications.
• Expertise in Oracle Database 11i, SQL, PL/SQL programming, Performance tuning, Data Import/Export, Fusion Middleware FMW, OAS, Data warehousing, OLAP, OLTP, Forms, Reports, Discoverer, Oracle Web toolkit, Javascript, HTML, UNIX shell scripting.
• Experience in a variety of industries: Government, Manufacturing and Banking.
• Experience in Full SDLC. Followed CMMI Standards and Protocols. System Requirements, HLD, LLD, Coding, Implementation, Integration, Unit testing, Peer reviews, Version Manager tools, Bug tracking system tools, Test cases, Test data, Test Plan, Alpha testing instructions, Beta testing instructions, Change Requests, Risk Management, Metrics and Production support.
• Proven track record in development, performance and troubleshooting of very large and complex Oracle 11g/10g environments.
• Extensive experience in Data Warehousing and Business Intelligence, Interfaces to Legacy systems, Data conversion exercises and System upgrades.
• Designing and Development of GUI applications using SQL, PL/SQL, Web toolkit, HTML, Javascript. Involved in the Deployment and Maintenance of applications on the OAS and managing SSO. Creating users and granting access to Dev, Test and Production applications.
• Experience with SQL Navigator, TOAD, SQL Loader, Erwin Data Modeller, Telnet, Serena TeamTrack, PVCS Version Manager, Lotus Notes, MS Outlook, Visio.
• Ability to work both independently and in a team comprising the Client, Users, Management, DBAs, System Administrators, Test team, Process Management team.
• Strong written and verbal communication skills.

PROFESSIONAL EXPERIENCE:

Position: Oracle Applications Developer

Environment: Oracle e-Business suite 11g, Oracle Financials GL, AP, AR, Oracle 11g, Oracle 10gAS, Fusion Middleware, Linux, TOAD, Visio, Oracle Reports, Data Warehousing, Data Mart, MS Outlook, Data Architecture, PVCS Version Manager.

• Responsible for working within a Development team to design, develop, implement and optimize MasterCard Data Warehousing system underlying Oracle Financials Application GL, AP, AR. Monitoring of Weekly archiving and purge of the GL, AP, AR transactions OLTP to LOAP data warehousing database.
• Primary responsibilities included design of OLAP system, architecture, performing source-to-target mapping and creating Oracle database objects, development of custom ETL framework using Oracle Export and Import utilities.
• Create Entity and Dimension tables, Star schema, de-normalization of tables, Data mart, data structures, ER diagrams, Data modelling, SQL, PL/SQL programming, diagnosing and resolving problems affecting query performance and providing recommendations as necessary.
• Weekly monitoring of the database objects for maintenance tasks and to find the issues related to performance like index rebuilding and partitioning.
• Worked on Business Intelligence, using Oracle Reports to develop business reporting off the data warehouse. Worked with logical and physical data models using Erwin Data modeler.
• Customization of Oracle Financials apps, Triggers, Forms and Reports. Forms server and Reports server configuration, reports and forms deployment.
• Performed SQL tuning using indexes, function based indexes, index organized table and table partitions.
• Resolving High Severity Production Issues in time and meeting the SLA.
• Followed CMMI standards and Protocols which included HLD, LLD, Specifications, Code Peer review, Unit testing, Version Manager, Deployment documentation, Risk Management, Development release, Test release and Production support.

Position: Oracle Developer Analyst

Environment: Oracle 11g, Oracle 10gAS, Fusion Middleware, Sun Solaris 10, Linux, Telnet, ssh, XTerm, Oracle Developer Suite Forms and Reports, SQL Developer, TOAD, Serena TeamTrack, PVCS Version Manager, Lotus Notes.

• Job responsibilities included requirement analysis, HLD, giving input to LLD, SQL, PL/SQL coding, unit testing, integration and deployment and documentation.
• The deployment of the agency census Data Warehouse in order to make easier access of census data, provide analytics, trending and comparisons, reporting and exporting capabilities that support the business needs, but most of all increase data utilization, and improve customer services and productivity.
• Worked on multiple applications for the DSCMO Department.
• Worked on UCM Project, which is an extensive Data Warehousing project. Worked as a verify developer on several modules of UCM 2010. Finished parallel programming and unit testing of several products on time, as per the schedule. In addition to the above modules worked on additional tasks assigned by the client. Worked on the Volume test shell script to import large amounts of data into the UCM tables. Worked with the UCM team and the DBAs, in the planning of partitions and indexes of UCM tables. Suggested creation of Local prefixed indexes on the partitioned tables and wrote the script for it. Wrote shell scripts to perform additional validation checks on Label files, Supplabel files and UECTs. Worked closely with the client and the primary developer to clarify the requirements, created test data where needed, did several rounds of testing on development and test environments to ensure thorough testing. Coordinated with the primary developer to document the beta form, deployment instructions and testing instructions. Interacted with the client and the UCM team on a regular basis to know the status of production runs and attended meetings to understand the business flow.
• Developed web pages using Oracle web toolkit, HTML, Javascript, SQL, PL/SQL packages, procedures, functions and triggers.
• Worked on Full Count Review System, an intranet GUI interface for the Census Bureau. Developed application which included several data entry forms, search engine and reports display in various formats such as HTML, PDF, EXCEL, ARC GIS Maps and graphs.
• Worked on EDIT project which is a huge multistep data processing system. Performed Bulk Collect, Bulk load of data, Partitioning of tables to improve performance. Loaded flat files data into the Oracle database using SQL loader, import, export and data dump scripts.
• Integration with ArGIS maps database.
• Worked with the DBAs, in the planning of partitions, tablespaces and indexes of tables.
• Documented deployment instructions for alpha, beta and production environments. Created beta form, test data and testing instructions.
• Worked on recommendations to improve performance and security of data and the GUI application.
• Followed CMMI standards and Protocols which included HLD, LLD, Specifications, Peer reviews, Demos, Unit testing, Version Manager, Deployment documentation, Risk Management, Development release, Test release and Production support.

Position: Oracle Developer

• Environment: Oracle 9i, Oracle Developer Suite, 9i Forms and Reports, Discoverer, PL/SQL, SQL, Sun Solaris, Telnet, MS Outlook, SQL Navigator, TOAD.
• Worked on Aircraft Engineering and Maintenance Management Application called 'MES2000' MES2K .
• Interacted with the users to gather the business requirements, and production of bugs.
• Worked extensively on 6i and 9i Forms and Reports. Created complex stacked forms in modal and modeless windows.
• Wrote packages, procedures, triggers, functions..
• Added calendar LOV, created timers, menus, popup menus, invoking of Techsmith camtasia player to play video clips.
• Wrote DOS batch files to run executables
• Created complex reports, drill down reports.
• Created SQL loader scripts, control file and data files.
• Created test plans and test cases.
• Experience in Full Software Developement life cycle.