SUMMARY:

• Manage projects and project manager for both Agile and Waterfall projects.
• Over 10 years of management experience in data related areas.
• Improved retail order entry system efficiency by 300% at Confidential.
• Reorganized and rebuilt a DBA team in 30 days after major management shake - up.
• Helped convert the largest DB2 system in the US to run on UNIX under Oracle.
• Proven record of taking of implementing projects with low probability of success and short turnaround.

TECHNICAL EXPERTISE:

• Experienced in Agile project management; proponent of action-oriented, solution-focused approach.
• Participated in Agile and Waterfall projects.
• Managed major DB2 conversions to and from VSAM, IDMS, DATACOM, Oracle, DB2 LUW, and IMS.
• Authored feasibility study to convert production DB2 for z/OS to DB2 LUW running on Linux.
• Authored query, DBA, and performance monitoring software (X-tools, On-Line Software, and IBM).
• Performed production troubleshooting, physical database design, implementation, & release management, administration automation development, disaster, recovery design and testing.
• Detailed knowledge of financial systems (banking, brokerage, and insurance), utility (nuclear, electric, and gas), oil (distribution and geophysical), and retail.
• Installed numerous mainframe operating systems software, program products, 3rd party and desktop tools.

PROFESSIONAL EXPERIENCE:

Confidential

Senior DB2 Support Specialist

Responsibilities:

• Oversaw database portion during data center relocation of 17 data centers from around the world to GM’s Detroit location.
• Eliminated $5M+/month losses by catching up on contract delays and completing project early.
• Moved 48 DB2s, ensuring all were up and running correctly, and authored a 175 documentation report.
• Facilitated critical path application changes that resulted in 75% savings.
• Provided recommendations that reduced 3 batch job durations from 4+ hours to 60-90 minutes.
• Evaluated VISA production system in preparation for the 2015 holiday season.
• Delivered a 75 page EXCEL/PowerPoint presentation detailing recommendations for handling the increased holiday season volume.
• Completed a project slated for a 6-month timeframe within 6 weeks.
• Reduced resource consumption across entire database system in order to delay costly hardware upgrade by 18 months.
• Improved efficiency, allowing system to handle 300 concurrent threads instead of 50.
• Provide client with SAS analytics to determine impact of software changes on the performance of mainframe and Unix/Linux servers; mined data using SAS (and EXCEL) to help client determine the effectiveness of business promotions.
• Avoided complete system shutdown by creating solution and project plan to circumvent a database software problem.

Confidential, Smithfield, RI

Director of Database Administration

Responsibilities:

• Oversaw architecture of all main database applications and implemented new database technology.
• Managed several software upgrade projects, application design, budgets and capacity planning.
• Reduced resource consumption to improve performance, designing custom tools for environment support technicians. Participated in vendor negotiations.
• Generated and monitored plan to shorten certain processes from hours to minutes and reduce others by 30-40%.
• Composed and presented 12 popular workshops for developers, DBAs and data analysts, with an average audience of 100 (and as many as 200 attendees) per session.
• Represented Fidelity at yearly IBM briefings in San Jose; served as department representative to Gartner Group meetings and DB2 representative for Mainframe CPU Reduction Project.
• Authored step-by-step mainframe to UNIX conversion plan, including capacity and hardware.
• Utilized SAS analytics to assess impact of Fidelity programs and offers on institutional business sales, determine impact of software changes on mainframe performance, and model critical applications.
• Served as the project lead for the database area on several Agile projects. Served as a project manager on major software upgrades.
• Participated in analytics development for anti-fraud and Homeland Security early warning systems.
• Helped developers with client statistics and analytics.
• Increased team productivity by mending rocky relationship between database group and developers.
• Set standards for DB2 database and application design for online, batch and distributed access; coordinated onsite and offshore resources.
• Managed several Agile and Waterfall projects and project managers.
• Managed both onshore and offshore resources.

Confidential, San Francisco, CA

DB2 Systems Database Administrator

Responsibilities:

• Converted data from an in-house developed billing system to a vendor product, and improved vendor’s rough beta billing system to ensure good performance; oversaw systems programming and database administration, including DB2 and 3rd party product installation.
• Implemented data conversion for largest DB2 system in the U.S. at the time to run on Oracle/UNIX, reformatting several 500+ billion row tables to Oracle load files, and helped Oracle DBAs load data into new Oracle images, ultimately converting 3 Terabytes of compressed data and loading it into Oracle in a single weekend.

Confidential, San Francisco, CA

DB2 Technical Director, DB2 Performance Analyst, DB2 Systems Programmer

Responsibilities:

• Initially arrived as consultant, but was soon hired and quickly promoted to Director following data-sharing project success.
• Oversaw technical management, DB2 Systems Programming application design, budgets, and capacity planning.
• Managed conversion of older IDMS application to DB2.
• Transitioned single-image DB2s to data sharing.
• Designed and maintained DB2 disaster recovery automation.
• Implemented and supervised databases used by trading and record-keeping apps.
• Directed a joint Schwab/IBM data-sharing project, overseeing 23 technicians.
• Relieved capacity problem following dot-com bubble burst, allowing Schwab to continue doing business, by successfully implementing first 15-way production data-sharing group using new, previously untested technology slated for a future release.
• Led technical teams to successfully implement high-risk, low-probability hardware implementation project, completing a project slated for 18 months in just over 5 months, thereby scaling database capacity 10-fold and reducing data center costs.
• Converted high volume IDMS transaction system to DB2 resulting in far better performance, achieving a 10% reduction in overhead and a 5% reduction in transaction elapsed time.
• Utilized SAS to model and plan for expected increases in future capacity, determine the success of retail offers for the brokerage, and mine data for possible future offerings.
• Worked with business to mine and analyze market data for the trading floor.

Confidential, Columbus, Ohio

Senior Manager of Database Administration

Responsibilities:

• Hired as a performance analyst but was quickly promoted to manager due to successful problem-solving.
• Resolved performance issues that prevented phone center from operating at full capacity in less than 30 days.
• Managed a team of 5.
• Solved application and database problems that forced phone bank with 1000 positions to send 50% of reps home every day due to system lockup.
• After first two weeks on the job, phone bank was able to add 25% more phone reps and was running at 100% capacity within 30 days.
• Reduced lock contention by more than 75% in less than 2 weeks. Cut elapsed time of order entry transactions by more than 60%.
• Achieved a 99% sub second transaction rate by the end of 60 days.
• Tuned retail order entry system for 300% improvement after IBM failed to fix it.
• Worked with business to provide routine and ad hoc analytics.

Confidential, Dallas, Texas

Consultant Manager

Responsibilities:

• Successfully reorganized a DBA team that had gone through disruptive management changes.
• Interviewed, hired and on-boarded new manager to take over the role.
• Was offered the position on multiple occasions.
• Effectively restructured database group in 30 days after major management shakeup, and fully rebuilt DBA team in 3 months, by identifying areas where existing staff could provide greatest value.