SUMMARY

• Experienced IT professional with a unique blend of business, project management and technology skills with a good track record of successfully developing and supporting complex enterprise Oracle application projects in Canada.
• 12+ years in analysis, development and support of applications (both User Interface and database) in roles such as Oracle Developer, Database/Application Developer, Data Analyst, ETL Developer, System Analyst, BI/Report Developer etc.
• Worked in diverse sectors such as Engineering, Utilities, Oil and Gas, Energy, Government and Municipal in consulting as well as permanent roles.
• Experienced in all aspects of SDLC including business analysis, requirements, design, application development, data interfaces, report design and development, unit/functional/ integration testing, documentation, deployments, acceptance test support etc
• Strong skills in backend database development, SQL, PL/SQL, data fix scripts, queries, tuning, data models/PPDM, database objects, views, triggers, stored procedures, functions and packages to translate business requirements to code.
• Experienced in ETL, data extraction/conversion/transformation/migration/data loading from external sources, data mapping, data analysis, SQL Loader, data export/import interfaces, scripting, verification and reconciliation reporting.
• Skills in Oracle Development tools, Oracle Forms, TOAD, SQL Developer etc.
• BI/Report development in Oracle BI/XML Publisher, PL/SQL, Oracle Reports etc.
• Some exposure to Oracle JDeveloper/ADF/J2EE,Javacript based web development.
• Training and some knowledge of SAP BW and Business Objects.
• Manual, automated, unit, functional and integration testing.
• Excellent verbal and written communication and documentation skills.
• Good interpersonal skills and performs well in a team/collaborative environment.
• Keen interest in learning new skills and technologies and business processes.

TECHNICAL SKILLS

Programming: SQL, PL/SQL, JavaScript, Java, XML/XSLT.

Databases: Oracle 11g, 10g, 9i, 8i 8, 7.3

Front End/IDE: Oracle Developer Forms, Oracle JDeveloper/ADF, Eclipse/Servoy Developer, Visual Studio.

Operating systems: Windows, UNIX, DOS including scripting

Report Builders: Oracle Business Intelligence/XML Publisher, Oracle Reports, Oracle Discoverer BI, Jasper Reports, Crystal Reports.

Database Tools: SQL Plus, TOAD, SQL Developer/Data modeller, PL/SQL Developer.

Web application servers: Oracle/WebLogic Server, Servoy/Tomcat.

Version Control: Sub Version (SVN), CVS, Visual Source Safe (VSS), Star Team.

Defect tracking/Ticketing: Redmine, Mantis, Remedy, HP Test Director, Star Team, Support Magic.

Other: MS Office, Excel, Access, SharePoint.

PROFESSIONAL EXPERIENCE

Data Analyst/Oracle Developer

Confidential

Responsibilities:

• Analysed and gathered requirements from business analysts.
• Translated business requirements to code; database development, created DDL scripts, queries/views for dashboard panels, security views, database objects, data fix scripts, data validations, interfaces, handled LOB’s, APIs and batch/scheduled jobs/processes.
• Created backend PL/SQL functions, packages and triggers to enforce all business rules and data validations using metadata configuration.
• Used Oracle Advanced Queue (AQ) for SOA integration with other systems such as SharePoint and process inbound/outbound calls.
• Validations for Norms project and data integration with Primavera/P6 system.
• Implemented metadata for multi - language support.
• Troubleshooting, problem diagnosis, bug fixes and configuration changes.
• Supported/enhanced legacy Oracle Forms system running in parallel.
• Converted legacy reports and developed new reports in Oracle BI/XML Publisher and PL/SQL, designed data models, layouts using MS Word templates and XSL.
• Ad hoc reporting rewrote and optimized SQL/queries and PLSQL to be more efficient.
• Data analysis/developed data visualisation charts/graphs for Oracle ADF dashboard.
• Run process and XML parsing utility to merge metadata and validation/business rules to merge with ADF Entity Object source files.
• Create/modify ADF Entity and View Objects; modify JSF forms source code in XML.
• Checked in source code to SVN/RCS repository to comply with continuous delivery/release methodology.
• Created Java Junit tests for ADF data models and Selenium tests for user interfaces.
• Created process to measure performance of dashboard panel queries. Created ADF graphical interface to interpret results; options to improve dashboard performance.
• Technical documentation, task estimation; followed standard methodology.

Oracle Consultant

Confidential

Responsibilities:

• Application support as required.
• Developed PL/SQL enhancements for validation/transformation processes for data file loading (ETL) and reconciliation processes to identify and auto correct issues.
• Analysed/loaded Trans Alta data files to database using DOS, SQL Loader, UNIX shell scripts; resolved issues.
• Identified source/target data; data analysis/mapping between transactional database (Oracle) and corporate data warehouse (SQL Server); developed source views for DW extracts.
• Developed flexible reporting system for users to run ad hoc queries.
• Developed new reports with output in csv format.
• Created system, change request/implementation and user documentation;
• Coordinated production deployments with DBA and support groups in Toronto.
• Support as required for analysis, debugging, testing and fix PL/SQL processes for post load settlement system.
• Imported data structures from client, configure/set up database and data loader UNIX shell scripts and initial seeding of tables.
• Configured Web Logic server for deploying Java application including security.
• Developed scripts to generate data files from client database, load data files to internal database; resolve loading and data issues.
• Downloaded site catalog files from retailer sites and uploaded to database.
• Ran required processes to reconcile data.
• Deployed latest patches to synchronize with code deployment at client site.

Consultant/System Analyst/Developer

Confidential

Responsibilities:

• Obtained business requirements from users, business groups, analysts.
• Created data fix scripts, ad hoc queries, PL/SQL interfaces, batch process, data uploads and exports create and modify database objects and stored procedures.
• Independently reverse engineered entire database to develop physical data model using SQL Data Modeller to develop sub views for all application modules.
• Design/develop enhancements to critical reports, batch reports jobs run on UNIX.
• Developed customized user reports/queries using Oracle Discoverer.
• Performed peer code reviews and unit testing of enhancements and bug fixes.
• Technical documentation for system design, business requirements and processes.

Consultant/Sr. Solution Developer

Confidential

Responsibilities:

• Analyzed business solution requirements, discussed with business analysts and users/managers, for enhancements to the Land Asset Reconciliation project.
• Identified and documented technical/functional specifications, data sources, created database objects, views and PL/SQL stored procedures to translate business logic.
• Designed and developed reconciliation and other reports and interfaces.
• Developed ETL process for validating and loading Excel spreadsheets to database.
• Created status reports, test plans and technical documentation
• Presented prototype demos to users and managers.

Database/Software Developer

Confidential

Responsibilities:

• Analysed business problems/gathered requirements from users/client account managers.
• Primary developer/support analyst for flagship external client facing application and other internal Oracle Forms applications deployed in Calgary and Houston.
• Upgraded applications from client-server to Oracle web Server.
• Supported/enhanced multiple applications: Seismic Line Inventory Catalogue, Indexing/Inventory cataloging Tool, Monthly Billing reports, Business System Application.
• Integrated custom Java plug-ins/beans with Oracle Forms.
• Redesigned screens and libraries resulting in faster operator data entry and productivity and reduced reporting time for data managers.
• Created Oracle Metalink service requests and followed up with Oracle support.
• Rewrote core applications based on industry standard PPDM 3.8 data model using Web 2.0/AJAX technologies and GIS using agile methodology.
• Was on DBA team; diagnosed and resolved application issues related to database.
• Create database objects, functions, packages, views with instead-of triggers for DML,
• Data mapping, Data analysis and validation, PL/SQL scripting and ETL.
• Query performance tuning, extensively used PL/SQL libraries and stored procedures.
• Assisted in configuration of Oracle web Application Servers on Linux/Unix.
• Managed Servoy (Tomcat) Application Server on Linux, added users, deployments, upgrades and followed up with Servoy engineers on issues.
• Estimated task/development effort and schedule.
• Presented prototype demos to users.

Consultant/Sr. Oracle Developer

Confidential

Responsibilities:

• Created and modified user interface using Oracle forms using triggers, stored procedures and PL/SQL form libraries and key enhancements to trigger and post transactions.
• Developed customized summary and detail reports and modified Oracle reports.
• Project completed within tight deadlines and work highly appreciated by client.

Consultant/Oracle PL/SQL Developer

Confidential

Responsibilities:

• Developed routines for message handling and data archival.
• Developed reports using stored procedures and pipe lined functions.
• Created functions and procedures called from .NET front end.

Consultant/IT Specialist/Developer

Confidential

Responsibilities:

• Diagnosed and fixed application bugs.
• Upgraded application from client server to web.
• Assisted in configuring and troubleshooting Oracle report server issues.
• Created materialized views to populate data mart.
• Created PL/SQL and HTML scripts to populate driver database tables and generate public web pages.

Consultant/Oracle Developer

Confidential

Responsibilities:

• Analysis, data mapping and design, developed PL/SQL scripts for conversion,
• Data loading/migration (ETL) using SQL*Loader to transpose data from flat files to database tables; Db links and Oracle Transparent Gateway to connect to source.
• Tuned SQL scripts. Created common conversion utilities.
• Supported conversion volume test runs. Analyzed conversion errors logs and fixed code.
• Designed and developed conversion reconciliation reports and analyzed discrepancies.
• Developed Oracle Forms/Reports using PL/SQL ref cursors and transactional triggers.
• Developed data interfaces for export/import of data files with external partners such as Royal Bank, HRDC, Edulinx and BDP.

System Consultant

Confidential

Responsibilities:

• Worked on Application Development and Data Conversion/ETL
• Built search, display, edit screens including the key search forms driving the application, using PL/SQL stored packages and ref cursors and transactional triggers.
• Designed ETL/data conversion process, resolved data issues, loaded staging tables from flat files using SQL Loader, created PL/SQL scripts,
• Unit and system testing and documentation.
• Developed scripts for conversion/cleanup of address data