Jaime Ballesteros Email & Phone Number

Home

Delivering Business Transformation for $20 MM Enterprise Asset Management System (EAMS)Enterprise architect for integrating EAMS into AgencyLeading technical architecture and design for implementation of Infor EAM solutionCreating the Data Mart/Data Warehousing Strategy for the AgencyProject Manager for several mission-critical system migrations and upgrades

San Francisco Bay Area

• Project Manager and Technical Strategist for the SFpark Parking Management system• Developed BI operational and predictive analytics, and Agency-specific software• Led the Agency overall design of a Data Warehouse, initially starting with 2-3 data marts• Planned, led and managed transition from pilot project to city-wide operational system.• Managing multiple vendors, contracts and supervised staff from contract programming staff, Oracle database software vendor, and various equipment suppliers. • Supervised/coordinated with MTA internal IT contributors.• Merging four independent plans, integrating deliverables and creating linkages where appropriate. Combined Agile iterative methods to manage Business Intelligence requirements gathering and implementation and integrate into overall PMBOK plan used to communicate to execs.• Delivered real-time XML/SOA-based database system, using Oracle servers (RDBMS, WebLogic, OSB message broker) and Oracle tools for report writing and BI such as OBIEE and ADF.• Created consistent "look and feel" for all business intelligence and information across the enterprise, including iOS and Android apps.

• Planned, managed and delivered PeopleSoft upgrades for large corporate systems.• Technical planning and delivery included the data migration of 19 Oracle 9i database instances from Solaris and Windows to newer Linux environments on VMware, Red Hat Enterprise Linux 4 and Oracle 11g.• Identified risks and issues with projects and informed stakeholders and management of any deviation to schedule. Coordinate the resolution of these identified issues.• Worked with internal customers, stakeholders to create business and technical requirements for system build-out. Tracked deliverables against the project schedule and timeline.

• Provided Project Management for Software Projects. Grew department from 15 to 30+.• Led data migration project from legacy systems to new systems for the City of Fresno.• Consulted about High Availability, Disaster Recovery and ITIL governance for IT departments. • Led client meetings to determine project objectives and scope, requirements, timelines and budgets. Identified and managed risks to product quality as well as project delivery.• Project Manager/Deployment Manager foro High Availability and Disaster Recovery Infrastructure implementation.o Application package deployment projects. o Software product development from business modeling, marketing requirements to programming, testing, deployment and change control.o Software product customization and development in .NET (C#, VB) using Oracle and Linux.

• Project managed the planning, evaluation and implementation of an Information Request Management System as well as Great Plains Dynamics accounting system based on SQL Server 2000.• Project managed technical and business processes for EventNet server and application deployment, including FDA validation.• Created Adverse Event reporting system based on FDA data.• “Hands on” installation of Oracle 8i, 9i and SQL Server 2000, implementing backups, migration to a larger server, PL/SQL and Brio reporting.

• Directed team, including UNIX & NT S/A, Oracle DBAs, Desktop Support and QA/Change Control for real estate/mortgage software system.• Project Manager for application and server installation and data migration from Windows/SQL Server to Solaris/Oracle.• Managed co-lo facilities, 24 X 7 operations and production support, storage vendor and internal IT. Created full backup, recovery and disaster recovery procedures and policies. Provided application maintenance and minor enhancement.• Responsible for all Budgetary and Capacity Planning as well as all hardware and software acquisition.

• Project Managed new product development and system installations. • Directed 10 person team, including software development, UNIX Oracle DBAs, Desktop and QA/Change Control for retail products (B2B & e-business).• Managed co-lo facilities, production support, and internal IT for all application upgrades. Created full backup, recovery and disaster recovery procedures and policies. Provided application maintenance and minor enhancement.• Responsible for all Budgetary and Capacity Planning; hardware and software acquisition.

• Clients include Novel, Intuit, San Francisco News Agency, SGI, Concentric and Webvan.• Infrastructure Project Management and lead DBA for both Novel and the San Francisco News Agency included Oracle Applications implementations.• Technical Project manager for Solaris upgrade and relocation from Tucson to San Diego. Diagnosed and solved OLTP interface problems between NT/SQL Server and Solaris/Oracle systems for Intuit.• Supported several 400+ GB OLTP Oracle Financials Instances, Oracle DBA for Challenge XL/Origin 2000/EMC array conversion team for SGI.• Project Manager/QA DBA for Webvan.

Houston, Texas Area And San Francisco Bay Area

• One-year assignment at Enron, Houston, TX. - 1995• Implemented High Availability and redundancy project for enterprise systems. Identified and resolved several critical system weak points.• One-year assignment at Pyramid Computers, San Jose, CA. - 1996• Project Managed 10-person Infrastructure Team for Oracle Applications Upgrade, including both Oracle upgrade and data migration.

• Lead DBA for large scale ERP system for newly emerging telesales organization for Compaq.• Managed change control for Oracle RDBMS, Oracle Financials.• Backup Sequent (UNIX) system admin.• Managed other Oracle financial instances in global environment (Ireland and Australia).• Technically managed change control team of 6-8 people.

Houston, Texas Area

• Corporate focal point for vendor relations, administered corporate contracts• Installed RDBMS products and tools, created large database instances• Administered network of 50+ instances, including monitoring, performance analysis, database tuning, and application tuning• Developed company-wide DBA and backup/recovery strategies and procedures• Provided consultation for DB design, application design and performance characteristics.