Senior Information Technology Manager with 15 years driving the integration of IT systems, the execution of data conversions, and the design of reporting solutions in the Financial and Government sectors. Hands-on project manager exercising a highly technical focus while stressing alignment to business processes, user functionality and skillfully managing client relationships at all levels of an organization. Versatile project lead adept at technical and business analysis, work stream, and bridging both technology and business audiences. Key roles performed as Program and Project Manager, Business Analyst, Data Architect, Database Administrator and Developer. Team leader and mentor with excellent communication skills adept at building high-performing teams, managing diverse geographic teams.

Areas of Expertise Include:

• Project Management
• Financial Systems Integration
• Resource Planning Management
• General Ledger Architecture
• Strategy Leadership
• Data Warehousing
• Business Data Analysis
• Application Integration
• Data Architecture
• Business Intelligence Reporting

PROFESSIONAL EXPERIENCE

Confidential

Key Project Deliveries:

• Defined the business requirements for the integration layer
• Built the logical and physical model for Oracle staging
• Built the logical and physical model for integration layer
• Designed OBIEE dashboards for GL extracts and ad hoc query
• Developed business requirements, functional and technical specifications and SIT plans for all conversions, 12 inbound and outbound interfaces, 35 reports, and 21 ledger extracts
• Built triggers, procedures, and scripts supporting custom BI-publisher reports
• Created and led demos and user training for GL and BI tools
• Directed a team of business analysts, EBS and OBI developers and interacted extensively with client base, PMO and sponsors to elicit and refine actionable requirements

Confidential

Program Manager for EAMS - Miami Dade County

• Evaluated all business processes related to the previously mentioned modules, conducted gap analysis and defined hardware needs
• Defined the business requirements and supervised the implementation of an EAMS mobile solution, empowering field workers to generate requests and quickly complete work orders using a Motorola or Panasonic mobile device
• Identified and inventoried over 400 county facilities, allowing FUMD to realign staff to meet actual needs
• Decentralized the preventive maintenance operations model, reducing turnover time for inspection reporting from 60 days to 5 days
• Automated tracking of over 50,000 annual work orders, reducing 'Open' status to an average of 1 day
• Integrated 10 trade storerooms into a centralized construction warehouse, reducing storeroom staffing by half
• Introduced parts barcoding, replacing infrequent, time-consuming full inventories with scheduled bin-range inventories
• Created 3 customer interfaces for caller requests, enabling facilities management to successfully land contracts for both Department of Human Services buildings and Fleet Management buildings
• Directed a team of 8 analysts and developers in Miami, New York City, and offshore in India
• Trained and mentored Miami Dade County both 3 system administrators and over 75 users resources
• Designed and created use cases, test scripts and training syllabi and manuals
• Devised implementation strategy and advised other county departments, including Aviation for facilities management, Water and Sewer for service requests , and Transit and Seaport for preventive maintenance

Points of Integration:

• Designed architecture for integration with 6 other County in house and 3rd party vendor systems, on multiple platforms, including mainframe, AS400, servers Unix, Linux, and Windows , and web-based. Strategies included web services, batch processing, Databridge asynchronous http protocol, and sqlloader. Integration points:
• Advanced Purchase Inventory Control system for commodities, contracts, blanket orders, purchasing and vendor reference data
• Financial Accounting management Information system for cost codes and COA
• DCS Online for employee service requests, reporting, and customer surveys
• Employee and Call Center reference data
• Legacy AS400 work order system for historical data
• In-house developed estimate application for customer approval of construction management budgets
• From a functional perspective:
• Produced functional specifications for Cognos based reports.
• Aligned data architecture to blend with existing tool set including Invoicing and Billing
• Added user defined tables, views, and application grids to the existing data model.
• Used PL/SQL to code packages, triggers, inbox entries, dataspies, and KPIs to support customizations.
• Designed and configured security to enable controlled access and collaboration for 250 users in 33 MRCs work groups in property management, utility, renovation trade, PM, architects, and engineers

Confidential

Senior Business Analyst and Project Manager

• The e-commerce department of Data Industries provided web-based applications and websites for government and small and medium-sized retail, wholesale, and service-sector businesses.
• Project Manager for business process review of Miami-Dade County GSA Property Management systems. Analyzed legacy AS400/DB2 work order system. Modeled and mapped data for migration to DataStream's Oracle asset management system. Devised strategies for collecting and cleansing legacy data and designed the end-state hierarchical structures.
• Project Manager for the Referral Processing System for Metropolitan Hospital. Wrote business specifications for web-based, HIPAA compliant system to track all referrals from external providers, through clinic appointments, to disposition of appointment results.

Confidential

Database Administration DBA and Data Analysis

Provided design as well as operational support for multiple strategic corporate and BI systems including CPP Data Warehouse a 1 TB, star schema design DW with 20K users worldwide , EMPort Expense Management Business Portal , ePayDirect Domestic T E system , AribaHub intermediate between Procurement AP systems , Premis ODS Calculation engine .

Confidential

Systems Analyst and Technical Lead

Supported and enhanced CIIS, an internally developed corporate data acquisition and integration layer that facilitated delivery and normalization of bank wide product system data to downstream financial and MIS environments including GL. Was also used to meet merger enabling and data bridging needs through several bank mergers.

TECHNICAL COMPETENCIES

• Hardware: UNIX Sun/Solaris, AIX, Linux Red Hat,Windows NT/XP, IBM 370
• Languages: SQL, PL/SQL, Shell ksh , Java, Cobol, Assembler, Perl, C
• Applications: Oracle EBS, Infor EAMS, OBIEE, Cognos, ESB
• Warehouse: FSDW, OBIA, DataStage, Ab-Initio
• Databases: Oracle, SQLServer
• Development Tools: Oracle SQL Developer, Toad, Microsoft Office suite