Senior Data Engineer Resume
Saint Louis, MO
Objectives: A suitable position, where I can also effectively utilize my technical, personnel, communication and presentation skills.
SKILLS SUMMARY
Hardware : IBM-RS6000, Sun Blade 100/150, Sun Fire 480R
Operating Systems : Aix 5.3, HP-UX 11, Solaris 8.0, Windows NT/XP.
Storage Area Network : EMC Clarion – FC 4500.
Relation DB : Oracle 10g, Oracle 9i, MSAccess, SQLServer 2003.
SAP : SAP Business Warehouse.
EDUCATION AND CERTIFICATION SUMMARY
P.M.P – Project Management Practitioner from PMI
M.B.A – Masters in Business Administration, Webster University
M.C.A – Masters Computer Applications, India
O.C.P – Certified Oracle DBA 7.0, 7.3, 8.0, 8i, 9i
PROFESSIONAL ACCOMPLISHMENTS
Confidential Saint Louis, MO
Senior data Engineer Aug 08 – Mar 10
MasterCard Worldwide is a driving force at the heart of commerce, enabling global transactions and bringing insight into the payments process to make commerce faster, more secure, and more valuable to everyone involved. As a critical link among financial institutions and millions of businesses, cardholders and merchants worldwide, MasterCard provides services in more than 210 countries and territories.
- Plan, Manage, Install, configure and maintain OEM to support and monitor enterprise wide databases
- Install, configure and support Oracle Databases for IBM- Maximo/TADDM Applications.
- Create database objects and users with appropriate roles and levels of security
- Installed Physical/Logical Standby Databases using Data Guard.
- Provide technical expertise and recommendations for physical database design and architecture.
- Work closely with data modelers to design logical and physical databases, and install/configure Oracle products.
- Design, Implement, and Participate in the disaster recovery procedures, process and documentation.
- Perform backup and recovery for online transaction and Operational data store database environments.
- Support application development teams in tuning SQL.
- Monitor database performance issues using monitoring tools using OEM and TOAD.
- The AWR reports collected were consistently reviewed to improve database performance.
- Review and recommend changes in application code and adjust tuning parameters in the Oracle.
- Evaluated and tuned the SQL queries and physical database environments for efficient use.
- Install OEM Management Server, OEM Agents and developed Custom Reports for EOM.
- Worked with the application team with performance testing of Protegrity – Data Encryption software.
- Used OSWatcher and LTOM utility to gather statistics at the OS and DB Level to isolate performance issues.
- Calculate current database growth and plan for future requirements.
- Optimize Data Warehouse Applications and tune queries.
Confidential Saint Louis MO
Lead Oracle/Data Analyst Aug 05 – Jan 08
Mercy is the 26th largest among all healthcare systems in the United States based on net patient service revenue. The Sisters of Mercy Health System is one of the nations according to the results of the 2007 Most Wired Survey. It has been in this list for six years in a row.
- Lead Oracle DBA managing a group of nine system and application DBA's.
- Plan and Schedule activities for the team based on Management strategies and direction.
- Setup RMAN scripts to perform backup and recovery.
- Migrate and upgrade database across platforms and different versions of Oracle
- Installed and supported health care related applications and databases.
- Install, support and configure Embarcadero’s Performance Center to monitor databases.
- Setup RAC Installation for IBM’s Maximo ticketing product.
Confidential , Saint Louis MO
System Analyst & Oracle DBA Mar 02 – July 05
Cooper manufactures thousands of electrical products through its seven divisions, which generate over 80 percent of annual revenues, and two tool divisions, which produce power tool and hand tool lines. Headquartered in Houston, Texas, Cooper has annual revenues of approximately $4.1 billion, employs over 28,000 people and operates more than 100 manufacturing facilities around the world.
- Plan, Manage and implement the Oracle Business E-Suite upgrade from 11.5.3 to 11.5.7
- Plan, study risk involved moving applications/data across different OS platform from HP-UX to Sun Solaris.
- Cloned E-Suite Production Application to Test and Dev instances.
- Apply Oracle Application Patches, maintain and monitor Concurrent Managers.
- Designed and Implemented the Cooper Connect Online – Sales Reporting Application.
- Installed and Maintained i2 E-Source Application, i2 E-Procurement Application.
- Installed and Maintained Kaba Benzing AutoTime - Time and Attendance Software.
- Created Info Packages in SAP-BW to interact with Oracle Database to load the Sales Data into BW.
- Installed and Maintained the Sarbanes-Oxley Application for Auditors.
- Researched problems in Oracle’s Metalink and Oracle Support Services to resolve Oracle issues.
- Installed and managed iPlanet and Netscape enterprise servers and directory.
- Created materialized views to populate remote databases.
- Supported Application Developers and Ends users.
Confidential Dec 98 – Mar 02
System Analyst & Oracle DBA
Vertis Inc is a pioneer technical consulting Company in digital imaging, multimedia applications, Internet and hybrid technology applications. Vertis developed and maintains Caterpillar Media Management System - CMMS the Internet site for Caterpillar to provide product images and technical information for Caterpillar’s worldwide dealer network.
- Plan, Manage, Execute and Implement the CMMS project.
- Involved in all stages of the System Development Life Cycle in the CMMS project.
- Benchmark and identified suitable hardware and Software for the application.
- Designed ER Diagram using Relation, ERWin and MS Visio.
- Performed Normalization and De-Normalization on data to achieve high performance.
- Administered Users, Roles and Storage Management.
- Interfaced Oracle with telescope software to view and insert images in the database.