OBJECTIVE

Seeking Oracle technology driven project/operations management positions in dynamic cutting edge companies.

SUMMARY

• 16 plus years of experience in IT field, more than 14 years managing Oracle databases and applications.
• Startup, new technology, manufacturing, retail sector, financial services companies.
• Made critical contributions to design, development and support of new IT infrastructure - B2B and B2C, Web services, wireless networks, SAN, virtualization platforms.
• Designed, implemented and deployed database management systems and tools OLTP, OLAP, ERP Warehouse.
• Designed and implemented data architectures - conceptual model, logical design and physical structure. ERD Normalized, Star and SnowFlake Facts, Measures, Dimensions schemas, Query Models, Materialized Views, Report Templates.
• Designed and directed the implementation of Process Models Transaction processing, ETL into data warehouses and data marts, interface paths, and integration bridges using techniques like session management, serialization/parallelization/synchronization, exchange models, and product specific protocols.
• Implemented integration solutions to connect disparate systems like Oracle databases, ERP Systems, CRM systems, TIBCO, Web Servers, third party entities like VeriFone Payment System.
• Designed and implemented capacity plans, performance tuning programs, replication operations, backup and recovery strategies for database and ERP systems.
• Experienced in setting up control systems to meet security and compliance regulations.
• Experienced in negotiating with vendors pricing, support etc. Also, working with outsourcing partners.

SKILLS

Software, Tools Languages

Oracle 7.x, 8.x , 9i, 10G, SQL Server 2000, 2005, Progress, mySQL

Oracle Applications 11i, 11.03, 10.7 , Oracle Workflow 2.0.2, Oracle WebServer 2.1/3.0, Oracle 10G/9iAS, MS CRM, PeopleSoft, Retek Merchandising System, Retek Data Warehouse, AuditWorks, Kronos Timekeeper, DataGuard, Remedy, TIBCO, GenTran 3.0.1, Vantive, WebLogic, PeopleSoft HR , Ceridian Payroll, PropWorks, MP2, Ask ManMan

EMC, NetApp, Hitachi

Developer/2000, Designer/2000, PL/SQL 8.0/2.3, Forms 4.5/3.0, Reports 2.5/1.1, Business Objects, Informatica, Brio SQR, SQL Plus 8.0/3.3, iSQL, Enterprise Manager, EcoTools 3.x, SQL Backtrack, Nimbus Monitoring Probe

'C', Pro C, SQR, Perl, COBOL, FORTRAN, UNIX Shell Programming, C , PL/SQL, Java, XML

Hardware, Operating System Networking Solutions

SunSparc, HP, IBM AIX, Sequent, Pyramid, NCR

UNIX System V, Open BSD, Linux, UNIX BSD 4.3 , Windows NT, Windows 2000, Windows XP, VMWare

CISCO routers/switches, TCP/IP, NDS, Shiva VPN

EXPERIENCE

Senior Consultant

Confidential

• Responsible for implementation of new database infrastructure and maintaining existing Oracle/SQL server installations.
• Implemented migration of SAN solutions from EMC to Hitachi Applications: PeopleSoft, CRM, Wire Transfer GFX Physerv, eConnect customer banking services
• Configured and deployed Oracle Real Application Cluster technology for eConnect customer banking services platform migration from Windows to Linux environment.
• Deployed virtualization infrastructure VMWare for 90 of non-production database applications About 70 instances
• Implemented first phase of migration of Oracle databases to Linux from Microsoft platform.
• Implemented the strategy for converting and mapping the data for migration from Inverstran to Equitrak Fund Management System which involved in backend database reverse engineering and data mapping to the new system.
• Installed and configured data warehouse for BusinessObjects Full lifecycle BODI, BOXI. Source instances number currently 28. Additionally, facilitated data element mapping from few databases.
• Configured SQL Server database for Microsoft CRM new implementation. Maintained SQL Server databases for nearly 12 applications.
• Implemented new backup and recovery solutions utilizing CommVault technology.

Principal Oracle Technology Consultant

Confidential

• Worked on the strategy to upgrade the portal software which consisted of several custom applications written in house that use the Oracle Portal 10g software.
• Worked on the implementing the Single Sign On for all custom and packaged applications through the portal and Oracle Virtual Directory for external authentication in a heterogeneous environment of LDAP servers for all the company employees.
• Worked on redesigning the database for custom document management software with Workflow integrated into it DDCC .
• Worked on custom application and database design for GASGEN which stores the information related to gas generators for the Marine Systems accessed from several locations through out the US.
• Worked on requirements with HR and accounting for implementing the Timelink software to manage the timecards for manufacturing and fulltime employees with the custom rules defined by the HR.
• Worked on writing some custom procedures to migrate data from RDM document management software to Livelink.

Principal Oracle Technology Consultant

Confidential

• Designed capacity utilization of a new Sun SAN with 4 terabytes space. Also reorganized hardware distribution among existing database systems.
• Configured database Oracle 9i to support Retek Merchandising System. Work involved capacity planning on SAN, memory allocation, distribution of data files, table partitioning and index design strategies, backup and recovery procedures, performance analysis etc.
• Configured data warehouse system utilizing Retek Data Warehouse on a new SAN. Capacity is designed for 2 terabytes. Extraction procedures including data loading, transportable tablespace management, partitioning and index methodologies, materialized views, memory allocation etc were organized to leverage the features of Oracle database and Retek system.
• Upgrading Oracle Applications 11.5.4 to 11.5.9 on Sun Solaris.
• Implemented failover system using Veritas Cluster on Sun server for Oracle Applications, Retek systems and Kronos. Configured DataGuard as a standby database solution.
• Manage and maintain several databases for a variety of applications like AuditWorks on IBM AIX and Kronos TimeKeeper. Tasks include refreshes, cloning, patching, maintaining backup and performing recovery with Veritas BLI in addition to administration of database issues during relocation of office.
• Reviewed database operations and practices in order to implement a database control system to meet the requirements of Sarbanes-Oxley regulation. Performed in coordination with the IT team and Accounting/Auditing staff.

Oracle Database Consultant

Confidential

• Upgraded few product development databases from Oracle 8i to 9.2.0.4 version on Sun Solaris, Windows 2003 and Linux servers.
• Performed tuning operations on warehouse systems, which are using Oracle 8i and 9.2.0.4 and Brio SQR server. Tasks included redefinition of refresh methodologies of materialized views, new data extraction operation, and configuring Nimbus Monitoring Probe software to capture certain events.
• Performed tuning on systems running Oracle Applications 11.0.3 on Oracle 8i. Tasks included application of several patches, creating clones for a small test of upgrade process 11.5.9 , monitoring performance to identify and remove bottlenecks.
• Set up 2 more systems on standby architecture.
• Worked on the backup and recovery strategy for the large production databases on Netapp Storage and tape rotation/retention operations.

Principal Consultant Migrations/Upgrade

Confidential

• Diagnosing and resolving performance issues in Oracle Applications 10.7 on Windows NT. Issues related to database configuration, application configuration like concurrent processing, as well as hardware problems. Restructured database infrastructure, reconfigured concurrent processes, redesigned some database structures and tuned application code.
• In addition to addressing existing problems, implemented virtual infrastructure software for partitioning, consolidating and managing systems using VMWare ESX Server. It is yielding better hardware utilization and offers protection against non-hardware errors and single point of failure for higher availability.
• Migrated Oracle Applications 10.7 systems to newly configured Windows NT Servers.
• Resolved issues arising out of the interface between Oracle Applications and PropWorks, a comprehensive software program to manage the lease, property, and revenue information needed to operate the complicated businesses and transportation facilities of BAA Indianapolis.
• Enhanced the flow of data from MP2 Enterprise, an integrated asset management system into Oracle database for back office purposes.
• Investigated, analyzed and recommended the technology strategy that BAA Indianapolis can adopt to upgrade its IT technology architecture. Offered the roadmap for upgrading Oracle Applications from 10.7 to 11.5.9. and migrating from Windows NT server to Linux server.

Manager - Data Operations

Confidential

• Designed and led the implementation work on upgrading Oracle Applications from version 11.0.3 to 11.5.8. Modules include Oracle Financials General Ledger, Accounts Payable, Accounts Receivable, and Cash Management . Appropriate upgrades were done with custom made systems Cost of Goods, Order Tracking System as well as the Reporting system running on Business Objects. Current upgrades of few instances are to 11.5.9 version.
• Maintained Oracle databases and ERP applications Backup Recovery, Patch application, Custom modules management, Performance Tuning, Problem Resolution, Configuration Maintenance of Application tiers Forms, Reports, Web and other Servers.
• Implemented proxy and database server solutions to support mobile computing with Blazer browser. Work involved design and implementation of data capture, transformation and transmission.
• Planned and executed a set of backend data operations to deliver TIBCO driven enterprise application integration with partner mobile service providers. Solutions were required to enable protected exchange and authentication of Electronic Serial Numbers and Mobile Identification Numbers. Successfully integrated using individually customized packages with AT T Wireless, Cingular Wireless, Rogers AT T Wireless, Sprint PCS and T Mobile.
• Designed and implemented a range of security measures including encrypting sensitive data like credit card numbers, social security numbers with Oracle Encryption Toolkit, extending the encryption of data as it transits even behind the firewall, masking the identities of database servers behind the firewall.
• Maintained and enhanced the Electronic Data Interchange system, GenTran and tuned its integration with Oracle Financials and Order Tracking systems over Sterling Commerce VAN to bring about efficiencies in the way retail stores do business with HandSpring.
• Increased efficiency, responsiveness and accuracy in problem identification and resolution mechanism by enhancing the functionalities of the help desk system based on Remedy application solution.
• Designed and led the implementation work on upgrading several database systems to Oracle 9i.
• Enhanced and maintained customer relationship system, eSupport system based on Vantive and Human Resources system running on PeopleSoft using Web Logic server as the integration layer.
• Configured and maintained Ceridian Payroll with its integration with PeopleSoft HRMS.
• Maintained Equity Edge Stock Administration 4.1 and performed upgrade schedules to meet the SEC requirements. Also worked with the merger of the Handspring and Palm stocks into one system.
• Installed and deployed Oracle 9iAS for portal services.
• Responsible for multiple databases running on Oracle 8.x 9i and SQL Server. Designed backup and recovery solution using RMAN.
• Contributed to the design and implementation of data warehouse. Tasks included ETL SQL Loader, staging areas, and mapping, identification and creation of Dimensions, Facts, Hierarchies and Measures, creating and maintaining materialized views, incremental loading window of changed data from source to warehouse, configuration and deployment of adhoc queries and reports for Business Objects.
• Maintained data warehouse databases running on Oracle 8i with custom scripts for ETL. Merger with Palm required working with Informatica.

Technology Consultant

Confidential

• Worked on the database design for the backend integration of a web-based application for clinical trials of a pharmaceutical company for internal management of different phases of the clinical trials.
• Designed a test data warehouse system for maintaining clinical test trial process and operational information. Used custom ETL process, Star schema, Materialized Views and Discoverer for adhoc queries.
• Maintained and supported Oracle 8i databases and financial applications running on Sun Solaris.
• Responsibilities include support for development and maintenance of various applications and systems. Tasks included capacity planning, design, installation, configuration, tuning, backup, applying patches and 24x7 maintenance.
• Performance tuning tasks included databases, Forms server, Apache server, Discoverer, Reports Server, and application tuning with STATSPACK, TKPROF, Explain Plan and Gather Statistics.

Chief Architect/VP of Engineering

Confidential

• Full responsibility for WebCash's entire information architecture development. Led a team of 9 comprising of analysts, developers, and database administrators.
• Implemented and maintained Oracle Financials 11i application suite on HP-UX platform Modules are Accounts Payable, Accounts Receivable, General Ledger and Cash Management. Work involved installation, patch applications, bug resolution, performance tuning, backup plans and data loading and exporting.
• Responsible for all the database systems Oracle 8i on HP-UX and Sun Solaris development and production. Tasks included capacity planning, design, installation, configuration, backup, and 24x7 maintenance.
• Designed and supervised implementation of several integration strategies to connect the Global WebCash Payment system with back end systems like Oracle Financials ERP and home grown Customer Relationship Management system running on Sun Solaris and third party entities like VeriFone Integrated Payment System, and eFalcon Risk Management System.
• Directed data migration operation from the old system running on mySQL to Oracle 8i.
• Designed and configured data warehouse databases on Oracle 8i ETL process in multistage model with custom scripts, automated incremental load mechanisms, design of warehouse model Facts, Measures, Dimensions, Hierarchies, Indexes in SnowFlake schema, set up materialized views, designed and deployed customized business intelligence tools like adhoc queries, standard and dynamic report generators using Perl, CGI and XML with drilling and rollup mechanisms.
• Established security policies, system administration Solaris, HP-UX Oracle , performance tuning, compatibility issues, traffic analysis and optimization.
• Maintained backup recovery procedures, instance management, patch maintenance, application management.

Operations Manager

Confidential

• Implemented several company wide ERP solutions including Oracle Applications 11.03 Financials - Accounts Receivable, Accounts Payable, General Ledger and Order Entry and Manufacturing. Work involved database specification, hardware and software requirements, installation for test and development environments, application of patches and backup and performance tuning strategies.
• Directed and managed the design and implementation of Foresight Service Information System, a graphical and simulation tool for analysis and design of complex systems, in order to reduce system development time and cost. Involved interacting with Oracle database, positioning of Progress database as a middle layer and deployment of Veritas for hardware planning.
• Designed data exchange models for interaction with legacy system and supervised subsequent implementation activities. Data exchange was facilitated between Ask ManMan, a manufacturing resource planning system and Oracle databases by creating software programs in Warehouse's Taurus 4GL language. The databases functioned as the data warehouse for obtaining customized multi-dimensional reports.
• Administered several Oracle databases including large warehouse systems - capacity planning, performance tuning, patch installation, troubleshooting problems, backup plans and disaster recovery strategy.
• Organized testing strategies for ensuring excellent quality in software development. Deployed several test automation processes.