SUMMARY:

• Specializing in data analysis, data architecture, design, development, performance tuning, implementation, customization and re - engineering of Oracle-based systems and processes
• Over 18 years of focus on Oracle Technology. Over 25 years of IT experience in all phases of SDLC. Over 14 years of North-American Oracle-focused consulting experience. Incorporated in Canada
• Strong ability to combine analytical skills with technical competence
• Technical expertise includes: design and development of database applications; SQL and application tuning; data modeling; data analysis, data migration, data mapping; database design for OLTP systems, development of OLTP (Web-based and Client-Server) systems; systems analysis; process reengineering; impact analysis; database design and development of Operational Data Stores (ODS), Data Marts, and Data Warehouses; design and development of ETL processes; ERP implementation and customization (Oracle Applications and SunGard/Ellucian Confidential Banner); custom ERP design and development; Business Intelligence (BI); design and development of Oracle Forms and Reports; database development for .Net, Java SE/EE, WPF, SOA and SOAP based systems; Fast response and high concurrency data driven systems; production support; knowledge transfer; database administration (development environments); effective program change control; evaluation and estimation of technical options; code review; computer simulation models; data mining; wide range of Oracle utilities and supplied packages; onsite and remote consulting
• Proven result-oriented approach with on-time product delivery. Ability to work on multiple tasks under time pressure
• Excellent facilitation skills to resolve project issues. Ability to work both independently and in a team environment
• Led highly productive teams of three to six IT professionals in full life cycle of mission critical applications
• Strong ability to translate user requirements into technical specifications
• Expert in SQL and PL/SQL tuning and writing code for-performance
• Heavy customer facing skills and proven ability of building strong professional relations with clients resulting in repeating business
• Strong ability to deliver stable and high quality solutions with low TCO in timely manner.
• Excellent attention to details, self-starter. Highly self-motivated with a confident “Do the Right Thing” attitude
• Extensive Data Modeling experience of OLTP and Data Warehouse/Mart databases. Proven experience designing data architecture for performance and scalability
• Experience and expertise in the following industries:, HR and Payroll, Benefits Administration, Finance and Banking, Supply chain, Order Management, RFID integration, ERP and CRM implementation and customization
• Extensive experience in number of Software/System Development Methodologies including Agile (Scrum and XP), RAD, and Waterfall
• Deep knowledge of Anti Money Laundering (AML) requirements of FINTRAC/FINCEN and real-time AML-CTF and anti fraud transaction monitoring and risk assessment techniques applicable for an Money Service Business

TECHNICAL SKILLS:

Hardware: Servers HP, Sun, IBM; PCs

OS: UNIX (HP-UX, Solaris/Sun OS, AIX), Linux (RH5/4/3/Oracle Linux), Windows 7/XP/NT/ 2000/98/95/3.11

Databases: Oracle 11g/10g/9i/8i/8.x/7.x, SQL Server, DB2, Clipper, dBase III Plus

Languages: SQL, PL/SQL, PRO*C, C, C++, UNIX Shell Scripting (Korn, Bourne), HTML, XML, UML, Java, Perl, JavaScript, Object Pascal, Delphi, FORTRAN IV/77, COBOL, PL/1, Modula

ERP: Confidential Banner SunGard- Ellucian (Student, Finance, HR, General, Self-Service), Oracle Applications (Financials, HRMS/ Payroll, Supply Chain)

Development/design tools, frameworks, packages, utilities, servers and communication protocols: Oracle Developer 10g/9i/6i/2000 (Client/Server and Web Forms, Reports); Oracle APEX (HTML DB); PL/SQL Web Toolkit; SQL*Plus;

Oracle utilities and supplied packages: SQL*Loader; Oracle Import/Export; Oracle Text; Oracle CDC (Change Data Capture); Oracle UTL­, DBMS and OWA packages; SMTP; TKPROF, Oracle Enterprise Manager, project/development DBA functions; SAP BI Business Objects; Oracle JDBC; Oracle analytic functions; Oracle Designer, Erwin, TOAD Data Modeler, Visio; OWB; IDEs TOAD, PL/SQL Developer, SQL Navigator, SQL Developer, JDeveloper, NetBeans; vi Editor; Software versioning and version control ALLFusion Change Manager, MS VSS, CVS Mercury; Oracle Reports, Crystal Reports, SSRS; Oracle 10g/9i AS; Tomcat; Apache; Oracle

Web Application Server: 4.x/3.x; X-Window systems Exceed and Xming; Communication Protocols HTTP, SOAP, TCP/IP, FTP

Development Methodologies: RAD, Waterfall, Agile (Scrum and XP methods); Project Management and Collaboration Mingle, MS Project, TestTrack (SeaPine); Microsoft Office

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Systems-Business Analyst, Data Analyst

Platform: Oracle 11g, J2EE, Oracle Linux x86-64 (6.u.3), RH Linux 6.3, Windows 7, Apache Tomcat 6.0, JVM, JDBC, Erwin, Oracle SQL Developer Data Modeler, PLSQL Developer IDE, CVS, MS Office

Responsibilities:

• Analysing business requirements for design and development of the company’s real-time Transaction Monitoring System.

Confidential

Sr. Oracle Developer-Analyst, Data Analyst, PO Technical Team Lead

Platform: Oracle 11g/10g, Linux (RH 4), Oracle 10g AS, Oracle Forms, Oracle Reports, Oracle Financials 11i, Windows 7/XP, TOAD IDE, .Net, WPF, SOA, SSRS, XML, SAP BI BusinessObjects, MS Visio, Mingle, MS Visual SourceSafe, Agile (Scrum method)

Responsibilities:

• Developed SQL and PL/SQL code for-performance, supporting high-volume real time transactions and data change in Quotes, Sales, and Purchasing modules of custom ERP system.
• Led team of four Oracle developers-consultants.
• Performed SQL and PL/SQL code-review and tuning in DB packages, procedures, functions, triggers, Forms, Reports and batch processes.
• Recommended the best design and development practices and standards to ensure the high performance, availability and stable run of the system under a very high volume of concurrent requests.
• Developed APIs to push data from transactional system to Oracle Financials (GL, AP, and AR).
• Performed Technical Analysis of new business requirements.
• Worked close with teams of system architects and business analysts.
• Developed TRDs (Technical Requirement Documents) for new modules and for changes applied to existing modules.
• Designed and developed database packages, procedures, functions, and triggers to extend and enhance existing systems.
• Documented existing data models creating new and adjusting existing ERDs.
• Developed new Oracle Forms and Reports and applied changes to existing forms and reports.
• Wrote complex SQL queries for the .Net/SSRS - based reporting system, to avoid a need for existing heavy and slow running pre and post-query data processing.
• Implemented it as callable by the client procedure returning or ref-cursor or ready to publish XML document.
• Helped with Data Modelling, design of Data Warehouse. Developed SQL queries for ETL processes.
• Took part in data analysis for design of BusinessObjects universes; applied power of Oracle’s SQL analytic functions;
• Re-engineered the Purchase Order Module implemented in Oracle Forms and Forms Libraries to the database packaged procedures and functions callable by .Net/WPF-based client.
• Performed following activities of a non-production DBA: defined structure, created and managed database tables, indexes, data types and objects, referential integrity constraints, naming conventions, database triggers, packages, stored procedures and functions, views, materialized views, sequences, data archiving/ purging/auditing.
• Recommended to production DBAs performance-driven changes to database initialization/configuration parameters.

Confidential

Systems Architect, Data Architect, Database Developer, Team Lead

Platform: HP, Oracle 10g (10.2.0.1), J2EE, Oracle Linux 86-64 (4.u.5), Apache-Tomcat 5.5.25, JVM, JDBC, SOAP, Crystal Reports 10, Windows XP, TOAD Data Modeller, PLSQL Developer IDE, CVS, Beanstalk, EPC, UPC

Responsibilities:

• Led team of four consultants - two Java Developers, one Oracle DBA and one Networking/Hardware specialist.
• Designed logical and physical Data Models. Designed RFID-based Order Fulfilment Process (Gen2 tags, RFID Printers and Readers) and its integration with OMS.
• Designed and developed all back-send (Oracle) logic as database stored packages fulfilling business logic and feeding J2EE-built user interface with data.
• Designed and developed SQL and PL/SQL code for performance, supporting high-volume real time transactions.
• Designed and developed database objects for J2EE-based application. Designed and developed reports.

Confidential

Oracle Banner Development Team Lead

Platform: HP UNIX, Sun Solaris, Linux, Windows XP; Oracle 10g/9i; Oracle Web Application server 10g/9i AS, Oracle PL/SQL Web Toolkit; JVM, JDBC, Javascript, Oracle Forms Oracle/Reports (10g/9i/6i), Pro*C, EDIs: PLSQL Developer and TOAD, MS Visual SourceSafe, CVS, Mercury, Cisco VPN client, Remote Desktop, ETL (based PL/SQL and Unix scripts), ODS, Data Warehouse database; SQL*Plus; SQL Loader; OWA, UTIL, DBMS packages

Responsibilities:

• Led team of three consultants Developers/Analysts.
• Defined the Development Standards.
• Created detail technical specifications defining and describing program functionality, and step-by-step development requirements.
• Analysed existing processes and base-line functionality of Confidential Banner system to evaluate effectiveness and develop new systems to improve production or workflow as required. Performed SQL and PL/SQL code review and tuning.
• Provided impact and gap analysis, defined scope of new development and required changes of existing code.
• Defined Migration Strategy and mapping of data from SIS system to the SCT-Banner.
• Designed database objects and UI (User Interfaces) for custom additions (bolt-on) to Confidential Banner system.
• Designed and developed database packages, procedures, functions, triggers.
• Customized base-line Oracle Forms 6i/9i.
• Analysed base-line changes of SCT-Banner 7 and their impact on custom additions made in version 6.
• Prepared development plan for the code upgrade.
• Among other processes designed and developed following critical for the Student module processes
• Holds process; Queries for Letter Generation; Fee Assessment process; Calculation of Student Attributes; Time Status calculation process; TPHi custom implementation; a process to seamlessly capture the changes made in pre-production instance and apply the changes to production DB utilizing CDC (Change Data Capture of Oracle). Took part in integration of Banner Student module and Java-based Luminis portal
• Worked with and helped DBA group to resolve performance issues.
• Guided developers and analysts from the college’s IT staff. Developed ETL processes for ODS.
• Performed project/development DBA activities in development environments.
• Performed following activities of a non-production DBA: defined structure, created and managed database tables, indexes, data types and objects, referential integrity constraints, naming conventions, database triggers, packages, stored procedures and functions, views, materialized views, sequences, data archiving/ purging/auditing.
• Recommended to production DBAs performance-driven changes to database initialization/configuration parameters.
• Defined the Upgrade Strategy for all database objects of the Student Web Self Services system.
• Ensured custom code is in compliance with Banner 8 requirements and API changes.
• Made code changes to ensure correct and stable behaviour of FTWR system within Banner 8 environment.

Confidential

Sr. IT Consultant - Oracle Database Developer, Data Analyst

Platform: IBM AIX Unix, Oracle 10g/9i, Oracle 10g/9iAS, Windows XP, Oracle Forms 10g/6i/4.5/6i, Reports 10g/6i/2.5; PLSQL Developer IDE; Oracle Web Toolkit; JVM, JDBC, J2EE, Cisco VPN client, Remote Desktop

Responsibilities:

• In this massive upgrade of client-server based Confidential Banner ERP to a web based version I was involved in systems analysis and defining requirements.
• Provided impact and gap analysis and defined code Conversion Strategy for Oracle Forms, Reports, Packages and Shell Scripts.
• Tuned existing SQL and PL/SQL code. Modified and converted existing Oracle Forms 4.5 and Reports 2.5 to Oracle Forms and Reports 6i. As a senior database developer performed following activities of a non-production DBA: defined structure, created and managed database tables, indexes, data types and objects, referential integrity constraints, naming conventions, database triggers, packages, stored procedures and functions, views, materialized views, sequences, data archiving/ purging/auditing.
• Recommended to production DBAs performance-driven changes to database initialization/configuration parameters.
• Identified gaps between the third-party implementation of the Academic Interface (AI) with the APIs and database objects in the new version of the Confidential Banner ERP. Provided core IT team with the detailed report and recommendations of what needs to be done to make the AI interface compliant with Banner 8.
• Helped to define the overall upgrade strategy for the custom code and database objects