SUMMARY:

• An accomplished Confidential Technical Manager/Administrator/Team Leader/Oracle DBA with 15 years of multiple Confidential ERP Implementations/Maintenance experience with a proven track record of successfully designing and implementing solutions that improve business functionality, reduce costs, and increase performance.
• SQL, PL/SQL
• Data migration using SQL Loader
• Source Code management using Visual Source Safe/Subversion, CCC/Harvest/Mercurial/MS TFS
• Crystal Reports versions 8,9,10,11 and 2011
• ASP.Net using C# with Microsoft Visual Studio 2003, 2005, 2012
• Ruby On Rails and .Net Basic Web Applications To Run Custom Apps on Confidential System
• Integrate incoming and outgoing EDI Messages to Confidential System
• SQL Server, T - SQL, SSIS Integrations with Confidential
• Oracle Expertise
• Oracle 11g OCP April 2011
• Oracle Database 10g Administrator Certified Associate, May 15 th 2006
• Program with PL/SQL Oracle 9i - Certified, October 23 rd 2006
• Hands-on experience configuring and maintaining DR Solution for Confidential, including Manual Standby database
• Hands-on experience installing, configuring and maintaining Oracle databases (24*7) on Windows
• Hands-on experience implementing backup & recovery plan for a 24*7 production Oracle Database
• Hands-on experience on performance tuning at SGA, Instance Level and using Cost Based Optimizer
• Hands-on experience using Oracle Enterprise Manager(Grid Control) with Oracle Management Server and SQL Tuning tools such as Explain Plan, Autotrace, Statpack, AWR, ADDM
• Create and manage Users, Roles & Profiles
• Develop PL/SQL procedures, packages and triggers to implement business logic (Using TOAD and PL/SQL Developer).
• Hands-on experience installing and utilizing Oracle Connection Manager for External Web Applications
• Extensive knowledge of Export/Import, Offline and Online backups, Media Recoveries
• Java Stored Procedures in Oracle for Integrations to SQL Server Databases.
• Hyperion Star Schema Implementation to be used with Essbase Studio

Confidential, Tallahassee, FL

Solutions Architect/Oracle DBA

Database: Oracle 10g R2/Oracle 11gR2

Platform: Windows

Responsibilities:

• Essential Duties and Responsibilities
• Lead the Confidential Upgrade from App 7 to App 7.5 SP 7
• Evaluating App 8 Upgrade
• Lead the Oracle DB Upgrade 10g to 11gR2
• Lead architect in DR Implementation
• Lead Confidential Sales & Marketing Implementation.
• IEE Administration with Print Server/Print Agent/PDF Archiving/Crystal Web Services etc.
• Implement Backup and Recovery Plans for the Oracle Database
• Implement and Maintain Oracle Standby database manually
• Configure SAN/RAID storage for Oracle Database.
• Communicating with Software vendors and 3rd party consultants

Confidential, Houston, TX

Technical Project Manager

Database: Oracle 10g R2

Platform: Windows/Mac OSX

Responsibilities:

• Implemented Confidential in UK(Aberdeen), Malaysia, Brazil, Mexico, Norway
• Hands - on team lead over the Confidential Development/Implementation
• Lead Integration efforts to allow Confidential to communicate to other SQL Server Databases and exchange data seamlessly using Triggers and Java Stored Procedures.
• Implement Web Apps using Ruby on Rails to fill the gaps in Confidential Functionality Manipulating data in Confidential for Custom Requirements.
• Write T-SQL Code for Triggers and Procedures in SQL Server. Create and Schedule Jobs in SQL Server.
• Lead Confidential Mobile Client Implementation.
• Mentor, manage schedules and tasks as well as provide technical direction to PL/SQL developers to ensure high quality code is produced prior to deployment to production.
• Ensure efficient and consistent (best practices) are being followed across multiple projects and daily tasks.
• Develop the Star Schema for Hyperion Essbase Reporting
• Provide technical expertise to end users.

Confidential, Yonkers, NY

Oracle Database Administrator/Senior Systems Analyst

Database: Oracle 9i & 10g

Platform: Windows

Responsibilities:

• Hands - on team lead over three developers (C#, .NET, VB, PL/SQL, SQL and Crystal)
• Ensure all systems\applications (PL/SQL or SQL) that are in production fall in-line with the design document and on schedule.
• Rewrite or tune queries (PL/SQL) to run faster and more efficient.
• Rewrite and tune Batch Allocation process in a data warehouse environment (PL/SQL, runs every 30 minutes) to use less resources and enhance performance significantly.
• Led and manage full SDLC development project in PL/SQL within data warehouse environment to create Pick Ticket application for Back Orders.
• Led, manage and develop PL/SQL packages within a data warehouse environment utilizing REF Cursors for Crystal Reports to improve the speed of the results from queries significantly.
• Write and develop PL/SQL backend in a data warehouse environment for .NET program which creates distribution lists.
• Manage, support, and implement backup and disaster recovery strategies for Oracle 9i (production system).
• Led and manage data modelling for all application development at Confidential utilizing PL/SQL and SQL.
• Ensure all QA standards are being met by developers, tested according to client standards, well documented, and entered into Source Code Management system (Source Safe)
• Draw Business Flow Diagrams utilizing MS Visio

Confidential, Boston, MA

Technical Lead/Senior Software Engineer

Database: Oracle 9i

Platform: Windows

Responsibilities:

• Hands - on proven leader with experience managing a team of developers or can work independently with minimal supervision depending on the scope, budget, and duration of the various projects.
• Lead numerous full SDLC projects in which the scope of my responsibilities included (in addition to development) writing technical specifications in collaboration with Confidential Project Manager and Clients Project Manager.
• Developed numerous PL/SQL applications (Oracle 9i) for clientele that ran on the data warehouse environment.
• Lead and manage data modelling for all application development at Confidential utilizing PL/SQL and SQL.
• Ensure all QA standards are being met by developers, tested according to client standards, well documented, and entered into Source Code Management system (CCC/Harvest)
• Managed Source Code Management & Software programming
• Managed tasks, timelines, and resources with Microsoft Project.
• Managed technical issues for Clientele.
• Reviewed Project Plan for Technical Tasks
• Participated in Project Meetings as Technical Responsible from Confidential
• Management of development projects for customers.
• Programming of Modifications/Patches
• Assigning technical resources where needed.
• Conduct Confidential Technology classes for customers IT Departments.

Confidential

Project Manager/Team Leader

Responsibilities:

• Managed, lead, and mentored 15+ developers (PL/SQL and Centura) one Systems Analyst and one QA tester.
• Obtained and clarified functional specifications for all design documents.
• Managed, lead, created and implemented functional specification according to design specs outlined in the design document with development team.
• Estimated resources and requirements to complete the project and assembled a Project Team.
• Mentor, manage schedules and tasks as well as provide technical direction to developers to ensure high quality code is produced prior to deployment to production.
• Create the database environment, file structure, and, prepare groundwork for code management using CCC Harvest/Visual Source Safe
• Manage and monitor time schedules and progress of the project against the baseline plan; use the information obtained to adjust schedule problems before they become critical, and to identify additional resource requirements (if needed).
• Identified and solved problems immediately.
• Provided technical and functional support to team members.
• Reported directly to the Project Manager any information relevant to the project under his\her supervision.
• Weekly builds - sending of files to Sweden.
• Handle communication (file/e-mail/phone/fax) with Project Manager (in Sweden or elsewhere).
• Merge Bug Releases.
• Ensure all QA standards are being met by developers, tested according to client standards, well documented, and entered into Source Code Management system (CCC/Harvest)
• Test the software to see if it meets specifications.

Confidential

Software Engineer

Responsibilities:

• Design the data model using Rational Rose according to the Technical Specification
• Development of Business Logic using PL/SQL.
• Implement Packages, Triggers, Tables and Views
• Mentor and being mentored by other team members
• Write Test Scenario s and Unit test
• General Business Application Expertise