SUMMARY

• PMP certified professional with 12+ years of experience in IT industry, specialized in Oracle development and database management, Project Management, Business Analysis, Oracle e - Business Suits, SDLC, Agile Methodology, Stock Exchange Software, Excellent Interpersonal skills and Oracle Database Management.

TECHNICAL SKILLS

• MS-Project
• Oracle Primavera P6
• IBM Lotus Notes
• Oracle Applications and Database
• Erwin
• TOAD
• SQL Server
• SAN
• NAS
• Cisco Routers
• Switches
• Juniper Firewall
• MS office
• Word
• Excel
• Power Point
• Visio
• Share Point
• Lync

PROFESSIONAL EXPERIENCE

Confidential, Bloomington, IL

Project Manager / Oracle Developer & DBA

Responsibilities:

• To manage projects using Water Fall or Agile methodologies depend on the nature of project.
• Conduct requirement & planning sessions, conduct weekly core team meetings for the status of the project.
• Proactively create a plan to mitigate the Risk impact, resolve issues, and manage dependencies in the project.
• Create Risk Breakdown Structure dictionary using Risk Estimation Tool (RET), which shows the level of risk.
• To manage Actual hours & projected remaining hours of each project resource.
• Create weekly project status report and SPP monthly dashboard report.
• To collect user requirement, analyze using Erwin ERD software & create prototype screen.
• SQL and database tuning & optimization and materialized view, roles, synonyms, grants, database links.
• Create, update or Drop database structure like table, views, sequences, and synonym, Database Trigger.
• Create programs, triggers, and stored procedures using PL/SQL.
• Create explicit cursors, materialized views, functions and procedures.
• Develop front end using Oracle Forms & create simple or complex reports using Oracle Reports tool.
• After development & testing, implement at end user and give user training & troubleshooting.
• Integrate customizations with Oracle Apps (E-Business Suite, HRMS/Payroll, Financial)
• Develop software using oracle forms and report builder, use Erwin for prototype.
• Oracle 12 c and 11 g database Backup and recovery and monitor and control the performance of database.
• Migrate different version of database to oracle 12 C. Data guard & VMware virtualization.
• Using Software Development Life cycle successfully run the project & achieve project objectives.
• Create & manage Oracle Database, performance and tuning Database, take Backup timely and manage recovery plan.
• Meeting with Project sponsor, program manager and monthly health meeting for the status of the project.
• Keep monitoring and control the overall project burn and labor burn report.
• Create and manage project Planning, Approach and strategy packages.
• Gather project requirement, project scope statement & create work breakdown structure (WBS).
• Create project scope, schedule, budget, Quality measures, and Resources availability.
• Monitor and control the project baseline, either project is behind the schedule, out of scope or budget & other related constraints.
• Gain formal acceptance from Authorized stakeholders and validate that all conditions of satisfaction have been met.
• Go through Project Closing Checklist and Authorized project Approval packages from Sponsor & create Final Dashboard report.
• Document lesson learned and archive all project document.
• Used Share Point to manage project reports, minutes of meetings, project documents, risk, issues and dependencies, also Enterprise Data Center Design department portal.

Confidential, Chicago, IL

Database Administrator

Responsibilities:

• To manage projects using Water Fall and Agile methodologies.
• Use Project management Processes Initiating, Planning, Executing, Monitoring & Controlling and Closing.
• Gather project requirement, project scope statement & create work breakdown structure (WBS).
• Create project scope, schedule, budget, Quality measures, Resources availability, Risk mitigation plan, and project Procurement.
• Monitor and control the project baseline, either project is behind the schedule, out of scope or budget & other related constraints.
• Create strategies for risk mitigation, contingency planning and workaround.
• Perform Quality Assurance, Project Process improvement Plan, Quality Audit and document all events during project.
• Communicate with the stakeholders, and keep them informed about the project status reports, issues and milestones.
• Gain formal acceptance and sign-off of the project by the sponsor or customer and validate that all conditions of satisfaction have been met and project is delivered as per defined in scope.
• Responsible for the security, integrity and performance of an Oracle databases.
• Oracle 12 c and 11 g database Backup and recovery and monitor and control the performance of database.
• Migrate different version of database to oracle 12 C. Data guard & VMware virtualization.
• Software Implementation of POMS net. (Material, equipment, order and work sheet Management utilities, Inventory).
• Software Implementation of EMPOWER for AD-HPLC testing, Perkin Elmore machines, Plate readers, Sample Proteins in Analytical Development Lab & QC Lab.
• Install and configure database management software, translate database design and diagnose database performance issues.

Confidential

Oracle Developer & Database Administrator

Responsibilities:

• To collect user requirement, analyze using Erwin ERD software & create prototype screen.
• Create, update or Drop database structure like table, views, sequences, and synonym, Database Trigger.
• To writes technical documents and testing assistance tools.
• Ability to trouble-shoot and solve configuration issues.
• Design and implement full solutions according to Business Requirements.
• Identify existing software defects and develop solutions.
• Excellent in analyzes, evaluates, tests, debugs, documents, and implements complex software apps.
• Uses coding methods in specific programming languages to initiate or enhance program execution and functionality.
• Participate in the evaluation, recommendation, and selection of hardware and software solutions.
• Create programs, triggers, and stored procedures using PL/SQL.
• Create explicit cursors, materialized views, functions and procedures.
• Develop front end using Oracle Forms & create simple or complex reports using Oracle Reports tool.
• After development & testing, implement at end user and give user training & troubleshooting.
• Integrate customizations with Oracle Apps (E-Business Suite, HRMS/Payroll, Financial)
• Develop software using oracle forms and report builder, use Erwin for prototype.
• Using Software Development Life cycle successfully run the project & achieve project objectives.
• Create & manage Oracle Database, performance and tuning Database, take Backup timely and manage recovery plan.

Confidential

Oracle Developer & Database Administrator

Responsibilities:

• Create programs, triggers, and stored procedures using PL/SQL.
• Develop front end using Oracle Forms & create simple or complex reports using Oracle Reports tool.
• Develop software using oracle forms and report builder, use Erwin for prototype.
• Using Software Development Life cycle successfully run the project & achieve project objectives.
• Create & manage Oracle Database, performance and tuning Database, take Backup timely and manage recovery plan.
• After development & testing, implement at end user and give user training & troubleshoot errors.