We provide IT Staff Augmentation Services!

Data Architect Resume Profile

5.00/5 (Submit Your Rating)

Overview

  • Demonstrated 25 years of leading the vision, leadership, priority and focus over business and technology. Over 50 successful implementations have demanded multi-dimensional critical thinking, intense advanced technology problem solving, and coordination with various internal and external organizations. Approach application and systems security from the perspective of risk management. Accomplishments include project design and implementation leadership for an excess of 50 varied advanced technology projects. Projects often included reporting and analytics over enterprise critical systems for multiple Fortune 100 clients. Quality Assurance and analytical experience focused on critical and key performance metrics and service levels for multiple complex enterprise-critical technology and business problems using methodologies learned from working experiences with KPMG, E Y, Grant Thornton, and Deloitte Touch .
  • Demonstrated success in contributing to employer's financial growth and development by delivering an array of resourceful solutions. Successful experience includes:
  • Led a 47 member team and was personally answerable to city management for the scope, complete and concurrent implementation and integration of multiple ERP systems Managing schedule conflicts, set project quality/performance standards.
  • Directed a critical documentation team responsible for researching, documenting, and producing 19 O M digital system libraries for a 220 million power generation project. This intensely short-term technical documentation project demanded unconventional thinking to coordinate engineering, multiple stakeholders, external vendors, writers, editors, illustrating, document project change control, advanced software technology delivery system html, xml architecture and 38 documents.
  • Directed the technical management and direction of Advanced Technology workgroup of this Texas-world bank. This challenge required me to communicate and implement tactical directions and ensure consistent business objectives for 44 work-group and enterprise-wide solutions 17,500 users including PeopleSoft, Siebel, Electronic Commerce, Data Warehousing and Data Marts, Data conversion / migration, Database Administration, Data privacy/security and Systems Administration.
  • Directed the scheduling and tactical direction of a 12 Grant Thornton team in business process reengineering project to rescue a critically failing Telecom customer service platform. The project incorporated extensive stakeholder coordination as we dealt with the data conversion-migration and data application design, development, and implementation.

Soft Skill Summary .

  • Business Analysis Delivery: Managed and delivered components of client engagements that identify, design, and implement technology and value-based business solutions. Responsibilities include managing teams in the identification of business requirements, functional design, process design including scenario design, flow mapping , prototyping, testing, training, defining support procedures.
  • Business Development: Develop and maintain relationships with top decision makers at key clients organize and lead pursuit teams participate and lead aspects of the proposal development process contribute to the development of proposal pricing strategies.
  • Regulatory / Audit Security Risk Management and Compliance: Demonstrated experience with E Y, KPMG and 2nd tier audit firms performing business process audit, analysis and giving management assurance over compliance with SOX, HIPPA and other regulatory requirements over information, data privacy and technology.
  • IT Strategy Alignment Delivering practical IT Strategies and tactics. Drive both from a top down analysis starting with an articulated business strategy and a bottom up technology capability analysis. Use of multiple SDLC methodologies including Agile, waterfall.
  • IT Effectiveness Assisted clients in formalizing the tools and processes needed to understand the means and methods to create or maximize shareholder business value. Articulate leading business issues and trends, including the associated technology implications

Technologies

  • ERP: PeopleSoft, HRizon, EPM, HRMS, Oracle Financials. eProcurement, Tyler Incode, Munis, Incode, Sungard OSSI, JD Edwards, Maximo, MRP
  • Relational DBMS: Oracle, SQL Server, SQL, Access

Expertise

  • Technical Documentation
  • Business Process / Analyst
  • Quality Assurance, Change Management
  • System Development Lifecycle
  • Technology Audit, Security and
  • Compliance SOX, COSO,
  • CobIT, ISO, ITIL
  • IT Governance, security, Risk Mgt.
  • General / Application Computer
  • Risk and security Controls
  • Business Intelligence solutions
  • Financial Application implementation and audit SAP, Peoplesoft, Oracle Financials, Sungard, Tyler
  • Data Conversion / Migration, technology ETL and
  • business interfaces
  • IT Change / Defect Mgt.
  • ERP system administration
  • implementation
  • Industries
  • Manufacturing
  • Oil Gas
  • Energy Power
  • Healthcare Medical
  • Utilities water, power
  • Financial Services

INDUSTRY EXPERIENCE OVERVIEW:

Manufacturing Inventory Systems

Healthcare Medical

Petroleum

Accounting Business Administration

Banking / Mortgage / Finance

Utilities electric

ERP systems

Project Lead / Management

Energy Power Generation

Risk and Security Management

Confidential

Industrial Control Systems Cyber Security Analyst

  • KEY SUCCESS: translated security concepts into language that is meaningful to diverse audiences, including business and technical leaders and individual contributors.
  • FUNCTIONAL: Established a multinational cyber-security governance and risk framework with a clear structure, responsibilities and operating processes that enables the client to obtain measurable and actionable results over the architecture, operations, change management, deployment, and data standards.
  • FOCUSED on ensuring consistent standards, tools, and practices to measurably increase efficiency and effectiveness of team using process elements of ITIL and CobIT enabling this client to obtain measurable and actionable results over a Primary Homeland Security target.

Accomplishments include:

  • Assembled and cross referenced numerous complex risk and compliance requirements from OSA, NIST, CobIT, ITIL, SANS, NERC CIP, and ISO sources / standards.
  • Created the holistic security framework to manage risk from 31 process perspectives, including data privacy
  • ENGAGING: Designed and implementing a multi-level drill-down dashboard for management reporting. This custom on-demand solution empowers all staff, team leads, and management to engage, measure, track and trend the effective impact of summarized or successively detailed data. work efforts, vulnerabilities, priorities, risks, locations, systems, etc.
  • ENGAGING: Goals cascade down to individual contributors and managers using R.A.C.I.

Confidential

Governance / Business Team Lead

Established a program governance framework with a clear structure, responsibilities and operating processes that enables the client to obtain measurable and actionable results over the architecture, software design, deployment, and data standards over the full project lifecycle. Focused on ensuring consistent standards, tools, and agile practices are used to measurably increase efficiency and effectiveness of team using elements of ITIL and CobIT.

Accomplishments include:

Agile-based components

  • Planned and conducted business use, user requirement and analysis of multiple business processes and business problems
  • Prioritized and maintained an Agile product backlog, ensuring a prioritization of business requirements and user stories with all parties
  • Weekly status meetings included sprint planning by progressively decomposing user story requirements
  • Ensured customer needs are being met by being the voice of the customer to vendors in day to day efforts.
  • Actively monitored the adequacy of all testing, training and implementation of each user story for each go-live

Non-Agile elements

  • Evaluated and assisted in solving business challenges by preparing the framework to collect, review and analyze information that enables management to make informed decisions.
  • Use quantitative techniques to extract and analyze data from various operational/financial/sales systems.
  • Developed new and improved reporting especially in the area of Operational KPI's.

Confidential

Implementation Project Manager Consulting Engagement

Accountable as a facilitator over project planning, scheduling, monitoring, reporting, and implementing multiple projects in a PMO environment. Responsibilities addressed project planning and coordination of cross-functional team activities to manage and implement Oracle manufacturing MRP and Maximo Asset Management / Workflow solutions from requirements gathering to their operational stage. Accomplishments include:

Agile-based components

  • Planned and conducted business use, user requirement and analysis of multiple business processes and business problems
  • Prioritized and maintained the Agile product backlog on an ongoing basis, ensuring a prioritization of business requirements and user stories with all parties
  • Weekly status meetings included sprint planning by progressively decomposing user story requirements
  • Ensured customer needs are being met by being the voice of the customer to vendors in day to day efforts.

Non-Agile elements

  • Prioritized business requirements
  • Developed specific project deliverables, metrics, milestones and reporting systems.
  • Managing allocation, utilization, and direction of resources
  • Automated management Remedy break/fix status reporting using a user-driven drill down reporting. Reporting establishes numerous metrics for measuring key Program criteria
  • Created comprehensive Business Requirement Specification and User Acceptance Testing methodology and templates UAT .
  • Facilitated the creation of communication plans, ensuring that appropriate information is exchanged among key stakeholders.

Confidential

President Board of Directors

Accomplishments include: Oversight of 130 million tax base, 2.3 million in physical assets, and an annual budget of 700,000. Participated in writing multiple RFP and RFQ activities. Actively coordinating risk and working with State of Texas Parks Wildlife, community Business leaders, residents, and consultants in the acquisition and ultimate development of a public park and recreational facility estimated project cost 5-7 million.

Confidential

ERP Implementation Project Manager Consulting Engagement

Led a 47 member team and am personally answerable to city management for the scope, complete and concurrent implementation and integration of multiple ERP systems and disparate vendor, internal teams and project stakeholders. Solutions include:

Municipal court admin.

Jail Management

Accounts Payable

911 Emergency Response

Records Management

Procure-to-pay system

Fire Police dispatch / admin.

Public Works / work orders

Contract / Compliance

Facility Mgt / work orders

Finance / Accounting

Project Accounting

Human Resources

Fixed Assets

General Ledger

  • This Agile-featured implementation includes business process, technology, and organization change management. Accomplishments include:
  • Leading the full life cycle implementation of multiple vendors including Tyler Munis Incode Technologies, Sungard Public , conflicting demands, and strong personalities.

Agile-based components

  • Planned and conducted business use, user requirement and analysis of multiple business processes and business problems
  • Prioritized and maintained the Agile product backlog on an ongoing basis, ensuring a prioritization of business requirements and user stories with all parties
  • Weekly status meetings included sprint planning by progressively decomposing user story requirements
  • Ensured customer needs are being met by engaging Subject Matter Experts as the voice of the customer to development efforts.
  • Actively monitored the adequacy of all QA testing, training and implementation of each user story for each go-live .

Non-Agile elements

SECURITY RISK MANAGEMENT

  • Designed a practical vs academic security risk awareness and management control program to detect and prevent fraud and security risks that addresses application vulnerabilities, segregation of duty, data needs.
  • Communicate security awareness concepts into meaningful and practical language of ownership to different user and vendor audiences management, dispatch, individual contributors .
  • Ensured multiple business teams engage and collaborate to prioritize and remediate vulnerabilities throughout the various business cycles.

BUSINESS / PROJECT ANALYSIS PLANNING

  • Scoped, segment, planed and conducted analysis of business processes and business problems
  • Ensure Current and Future State analysis was documented and vetted by collaborators
  • Guided City Management in the scope and prioritization of business requirements
  • Translated business problems/requirements into technical specifications for configuration or development
  • Coordinate responses to change requests from original specifications
  • Mange project budget, invoice payments and schedule

SCHEDULING AND REPORTING

  • Identify and schedule project deliverables, milestones, and required tasks
  • Prepared/reviewed project personnel status reports
  • Collaborated with Subject Matter Experts and management to provide technical guidance, and issue resolution
  • Developed specific project deliverables, metrics, milestones and reporting systems
  • Managing scheduling, allocation, utilization, and direction of resources

TESTING, COMPLIANCE AND RISK-BASED QUALITY ASSURANCE

  • Ensure timely configuration, testing test plans/scripts , and training of various project deliverables with a focus on data privacy.
  • Conversion process incorporated numerous US federal and state mandated regulatory compliance risk assessments.
  • Identified and managed risk while giving extensive client value by ensuring extensive go-live testing, reconciling records, test scripts and governance over CAVR Completeness, Accuracy, Valuation, and Restriction of access
  • Designed / Implemented effective Change Release control model, test scripts, Go Live processes to ensure technical accuracy, completeness and empirical quality assurance of multiple vendor software releases

Confidential

Technical Documentation Project Manager Consulting Engagement

  • Directed a critical documentation team responsible for researching, documenting, producing and implementing 19 digital operating and maintenance system manuals for a 240 million power generation project. Accountable for the vision, design, and direction of a comprehensive documentation and change management process. Participated in writing multiple RFPs and vendor meetings.
  • This technical documentation project, demanded multi-dimensional critical thinking, intense multitask complex technical problem solving and coordination of 12 direct reports, multiple subject matter experts and 38 documents in English and Spanish 980,000 words over a fast-paced schedule. Identified and managed risk of inaccurate or incomplete updates using systematic SME reviews and a comprehensive digital search engine gave extensive client value by ensuring immediate information access and cross referencing.
  • Provided leadership, priority and focus in all aspects of scoping, segmenting, technical writing / editing, illustrating, document / project change control, translation and the advanced software technology delivery system html, xml architecture. Extensive and regular interaction with disparate engineering teams, executive management and team members demanded strong interpersonal, communication, presentation skills and multinational regulatory compliance.

Key success elements include:

  • Mapped complex and often disparate information to ensure the delivery of technically accurate, high quality, on-time deliverables based on their alignment with project scope commitments and client expectations.
  • Change Release Management was integrated into this process to ensure technical accuracy, completeness and empirical quality assurance of digital and hardcopy content.
  • Managed schedule conflicts, setting project quality/performance standards Monitored/provided status reporting Managed resource allocations using an Agile-featured implementation

Confidential

Sr. Governance, Risk, Compliance Team Lead Consulting Engagement

  • Reduced regulatory risk management costs. Designed, developed, and documented a single governance information system to connect and report all elements of a blend of ISO, CobIT, and ITIL management framework standards, processes, procedures, and project controls. Included, were areas of user access security issues, strategies.
  • Designed, developed, implemented various analytical tools to document and ensure Information Systems IS best practices resulted in a tangible and actionable transformation. Further, delivered actionable risk monitoring tools to management that aligns SDLC, data privacy and technology with business.
  • Provided leadership, priority and focus in all aspects of scoping, segmenting of application security, access controls and configuration hardening. Deliverables focus on defining and frequently implementing means, methods and tools that fundamentally create or maximize shareholder business value.

Accomplishments include:

SERVICE ORIENTED ARCHITECTURE

  • Ensured multiple business teams engage and collaborate to prioritize cross functional resources to organize and respond to security standards, policies, procedures for vendors. Efforts focused on delivering predictable and actionable value-based impact to stakeholders.
  • Complex business analysis requirements gathering, future state, GAP, disparate informational source data
  • Monitor, evaluate and report Key Performance Risk and Governance indicators metrics . Accomplished by defining, implementing rigorous change management resulting in measurable, actionable and continuous improvement.
  • Led the business impact assessment, gap analysis, requirements documentation and implementation of business and IT service continuity BCP and DRP policies, standards, methodology, and documentation.

SECURITY RISK MANAGEMENT

  • Designed a practical security risk awareness and management control program to detect and prevent fraud and security risks that addresses audit and compliance needs, application vulnerabilities, segregation of duty, and data risk needs.
  • Communicate security awareness concepts into meaningful and practical language of ownership to different user and vendor audiences management, dispatch, individual contributors .
  • Ensured multiple business teams engage and collaborate to prioritize and remediate vulnerabilities throughout the various business cycles.

Confidential

Change Release Implementation Management Lead

Ensured project effectiveness and alignment with business by defining and directing the tactical SDLC operations of a Change Release Management team. Scoped, segmented and directed the team of analysts to furnish actionable business assurance regarding the completeness, accuracy, validation and restricted access to this key Customer Care and Billing system. Effectiveness is determined by initially focusing efforts on evaluating all germane business processes that were key and had a high dependence on the software application. Additionally accountable for the vision, design, creation, and maintenance of a comprehensive release, defect tracking and change management process.

Accomplishments include:

  • Gave management assurance over system security fraud prevention and detection by collaborating with application development teams and business owners. Security focus was on development processes, application software, segregation of duties, and process controls that balance stringent security standards and meet the company's business needs.
  • Directing and coordinating multiple business analyst teams to ensure IT Effectiveness and business alignment had demonstrable and actionable results. Keen focus was made on future-state business processes with change management, testing, test scripting, schedules, and priorities using Agile-based practices.
  • Directed the prioritization, scheduling, and daily direction of Unit, System, Integration, and User Acceptance testing and documentation using the plans, tools, and scripts developed.
  • Specific attention was made regarding documenting internal project controls as related to the requirements of Sarbanes-Oxley COSO/CobIT systems and structures
  • Created implemented defect tracking dashboard to summarize and furnish drilldown reports to document and clearly communicate defect change metrics, status, and process information to management and team members testing results and releases for both project and production.

Confidential

Sr. IT Internal Audit Lead Consulting Engagement

Interviewed and collaborated with senior management and stakeholders to examine, evaluate and assess risk by documenting and testing the internal control design and operational effectiveness of multiple core financial reporting systems and general IT business processes including change management to assure management of regulatory compliance for Sarbanes Oxley.

Key accomplishments include:

  • Working closely with KPMG, I lead my team in the creation and execution of test plans, test cases, summary reports to document business processes, rules, roles, responsibilities, and controls. Work to resolve gaps and deficiencies.
  • Design, test, evaluate and report verifiable and evidential security findings each week to senior and executive management. Reporting focused on the core financial application and security controls for Design and Effectiveness for completeness, accuracy, valuation and relevancy fraud mitigation.
  • Extensive business process collaboration and daily working involvement with KPMG external auditor , technology process owners, control operators regarding security, change / configuration management control design, evaluation, documentation, remediation and monitoring issues in multiple enterprise-critical environments including Oracle and JD Edwards user security.
  • Documented, tested and evidenced key program, operation, and project change management, security detection and prevention controls for this client's IT business processes. Focus of attention was made for the detection and prevention controls for client's core financial reporting system. Examinations included lifecycle management, segregation of duties, data management, interface management, and user access and management authorizations.

Confidential

Sr. Regulatory Compliance Project Lead Consulting Engagement

  • Scoped, segmented and ensured regulatory compliance and information risk management implementation for a 139 million supply chain collection of IT and business development projects. These multiple SDLC projects are tasked to design / implement targeted and sustainable improvements in supply chain processes, technologies, and organization capabilities.
  • Designed and implemented a management assurance framework for internal and multiple domestic and international regulatory, security and compliance requirements including Contract Management, Sarbanes Oxley, CHPDP and 26 other business processes, standards, and internal project controls.

Accomplishments include:

  • Key attention was made on information risks and loss mitigation best practices by clearly coupling information technologies to business process.
  • Develop, maintain, execute compliance plans, inventories of assets, segregation of duty security matrix, risk assessment, identify gaps-exceptions to compliance, user access reviews, and provide oversight of audit remediation.
  • Ensured international project units secure information and application assets and comply with SOX, ISO 17799, Foreign Corruption Practices, data privacy, export and 'deemed export' control laws, internal design and management standards for governance, conflict of interest, antitrust, and export licensure.
  • Led the business impact assessment, gap analysis, requirements documentation and implementation of business and IT service continuity BCP and DRP policies, standards, methodology, and documentation.
  • Information business compliance extended to trade integration, product scheduling, demand forecasting, refinery blending / scheduling, information technology and architecture, procurement and vendor management, physical IT security, data sensitivity and criticality, disaster preparedness, transmission, network, and assorted other technical controls.
  • Defined, documented a Change Management program for IT infrastructure support whose focus centered on management authorization, detection and prevention controls for this significant project. Focused effort on business to technology integration and included lifecycle management, data management, interface management, and user access and management authorizations.

Confidential

General IT Controls Sarbanes Auditor Consulting Engagement

  • Reduced the cost of SOX IT audit by 45 by focused and simplified implementation of IT Risk Management. As the senior consultant, personal deliverables included establishing best-practice, standardized and reproducible IT Risk Management governance framework over internal controls. These business risk assessments carefully consider user security strategy and ERP implementation.
  • Provided added value by helping transition client SOX general IT control testing from CobIT version 3 into version 4. focus has remarkably shifted to governance-based policy procedure controls
  • Established standardized and reproducible general IT control tests and required evidence that address Risk Management and both the Test of Design and Test of Effectiveness.
  • Automated the Risk Control Matrix to greatly simplify and maintain SOX compliance within IT best practices.
  • Worked with design team to furnish standardized management compliance reporting

Confidential

Sr. Application Controls Sarbanes Auditor Consulting Engagement

  • Reduced the cost of current and future audits by 35 by designing a control management database to cross reference and identify duplicate audit efforts. Worked closely with Ernst Young, I lead a team of eight to assess and give management assurance over the efficacy of financial application embedded controls in conformity to Sarbanes Oxley rules. Accomplishments include:
  • Mapping processes, determining and assessing risks, identifying process control or process deficiencies and helping develop actionable process change.
  • Interviewed Subject Matter Experts cross-discipline personnel and management to document key business, security and organizational processes and procedures to evaluate the design of Risk Controls including data privacy
  • Evaluated, documented and tested the operational effectiveness of Application-Embedded financial reporting and regulatory compliance controls for SOX 404 for this SAP-based applications.
  • Control testing Test of Design, Test of Effectiveness had heavy involvement with business process owners, control operators regarding security risk management control design, evaluation, documentation, remediation and monitoring issues in multiple enterprise-critical environments e.g. Risk mgt, Confirmations, A/P, Marketing, Trading, I.T. .
  • Led the business impact assessment, gap analysis, requirements documentation and implementation of business and IT service continuity BCP and DRP policies, standards, methodology, and documentation.
  • Balanced personal initiative / organization with extensive team interaction regarding methodology, QA, schedules, interviews, problem solving
  • Began laying groundwork to transition client from manual detective / reactionary controls toward system-based, preventative sustainable focused compliance.

Confidential

General IT / Application Controls Sarbanes Auditor Consulting Engagement

  • Examined and analyzed IT records to determine the effectiveness of client's technology controls to detect and prevent technology fraud. The assessment conformed to the guidance mandated by the Sarbanes Oxley act rule 404 .
  • Working closely with Ernst Young, evaluated using a modified COSO/CobIT framework, obtained and documented sufficient competent evidence about the design Test of Design of all General IT internal controls and implementations.
  • Inspect and tested technology business elements that include IT Segregation of Duties, change / configuration management. Test focus on the adequacy of both design and effectiveness of operation.
  • Once documented, key controls were determined and tied to corporate policy documentation.

Confidential

General IT / Application Controls Sarbanes Auditor Consulting Engagement

  • Reduced the annual cost of SOX compliance by 350,000 by implementing a tiered approach to documentation. Working under the direction of a former Ernst Young partner, furnished management with compliance assurance of the completeness, accuracy, validation and restriction security of technology control that prevent and detect fraud.
  • Interviewed business stakeholders to document business process flows, write test scripts
  • Responsible for Test of Design and Operational Test of Effectiveness for IT General controls including Security Administration, System Performance, Physical Security, Oracle, and SQL Server.
  • Performed activities that include working with Process Owners to document / validate business processes, standards, and procedures. Heavy reliance on narratives and work paper evidence gathering.
  • Charged with understanding and documenting controls, mapping processes, determining and assessing risk management, identifying control or process deficiencies and helping develop process change
  • Balanced personal initiative / organization with extensive team interaction regarding methodology, QA, schedules, interviews, problem solving
  • Responsible for Test of Design and Operational Test of Effectiveness for IT General controls including Security Administration, System Performance and Physical Security

Confidential

General IT / Application Controls Sarbanes Auditor Consulting Engagement

  • Ensured client compliance with PCAOB, Audit Standard 2, Sarbanes-Oxley by obtaining and documenting sufficient competent evidence about the design and operating effectiveness of risk management controls over all General IT internal controls. Test of Design, Test of Effectiveness
  • Interviewed cross-discipline personnel and management to document key business and organizational processes and procedures to evaluate the design of Risk Controls.
  • Once documented, key controls were determined and subsequently tested, complete with documentation and evidence.
  • Worked with management in remediation of Change Control to ensure IT Segregation of Duties was SOX compliant

Confidential

General IT / Application Controls Sarbanes Auditor Consulting Engagement

  • Leveraging heavily from 14 years of personal, engaging IT business, technical knowledge and experience to detect and prevent control weaknesses in areas such as Change Management, Systems Lifecycle Management, Data Management, Interface Management, User Access Management, and General Security.
  • Daily engaged in audit methodologies of both Deloitte Touche and Ernst Young to interview business stakeholders. Interviews result in documented business process flows/walkthroughs.
  • Engaged in the writing of test scripts and testing the design and effectiveness of IT general controls that prevent and detect technology-based fraud.
  • Activities include working with business and technology stakeholders to document / validate business processes and IT events. Requesting evidence from process owner, and validating evidence to assess internal control adequacy of design and effectiveness.
  • Heavy reliance was made on advanced business analytic tools and methodologies: narratives, control matrices, gap logs, and work paper evidence gathering. Subject areas include database, server configuration, user access administration, change management, lifecycle management, data management including data reconciliations , interface and data ETL Extract Transform Load management, and general security.

Confidential

General IT / Application Controls Sarbanes Auditor Consulting Engagement

  • Under the daily direction and supervision of both Ernst Young and Deloitte Touch for two mutual clients: Duke Energy Field Services and Teppco. Examine, evaluate and assess risk by documenting and testing the internal control design and operational effectiveness of multiple core security, financial reporting systems and general IT business processes including change / configuration control management to assure management of consistent regulatory compliance for Sarbanes Oxley.
  • Identify / trace / document IT process controls and system interfaces affecting financial transactions per COSO-CobIT standards process flow, control matrix, gap analysis, narrative
  • Consulted with Internal Audit regarding COSO defined general controls infrastructure, security, software development / maintenance, etc system data interface verification and validation.
  • Responsible for documentation and validation of 24 enterprise-wide applications e.g. PeopleSoft and associated data interfaces and ETL solutions.
  • Tested, evidenced, and documented, key Change Management detection and prevention controls for this client's core financial reporting system. Considerations included lifecycle management, data management, interface management, and user access and management authorizations.

Confidential

Sr Business / Data Architect

  • Implemented 32 disparate feeder system interfaces to PowerPlant Peoplesoft G/L, HRMS and Peoplesoft EPM systems. Architected system interface control structures/processes EAI to comply with Sarbanes-Oxley and HIPAA requirements. Reverse engineered multiple Oracle and Peoplesoft-based feeder systems to identify and resolve critical interface Extract Transform and Loading issues.
  • Evaluated, designed, documented, and implemented security measures for systems and interfaces to Peoplesoft.
  • Actively working with Peoplesoft Consulting on EPM data cleansing issues, and Workforce Analytics/Rewards
  • Mentored key members of the client's IT team in Peoplesoft and data warehouse architecture and system maintenance that complies with FERC regulations.
  • Engagement focused heavily on business requirements and analysis.
  • Documented security and administration / internal controls application and general controls Sarbanes 404 Test of Design
  • Managed schedule conflicts, setting project quality/performance standards Monitored/provided status reporting Managed resource allocations

Confidential

Sr Business Analyst

  • Lead the client in HRizon ERP upgrade v. 8 to 2f , coordinated and consolidated the over 5,000 Compare Reports. Engagement focused on business control analytics / documentation and included Enterprise Architecture Integration skills.
  • Aided client in upgrade from version 8 to 2f by coordinating and consolidating the Compare Reports.
  • Identified customizations and facilitated meaningful dialog with end users to develop and implement requirements.
  • Installed and documented Oracle 8.1.7 and HRizon proprietary license from PeopleSoft ERP system architecture.
  • Evaluated, designed, documented security and administration / internal controls, procedures, configurations

Confidential

Sr Peoplesoft / Oracle DBA

  • Consulting to Waste Management, I mentored and coached other DBAs regularly engaged in resolution of numerous critical operation issues including disaster preparedness, business continuity, and Enterprise Architecture Integration EAI skills.
  • Actively involved in database/PeopleSoft General Controls application audit. Included performance tuning, system application and general control documentation, and creating operations-based Unix scripting.
  • Installed, configured PeopleSoft EPM 8.3 deployment on AIX with Oracle 8.1.7 8i . and Win2000 architecture.
  • Evaluated, designed, and documented security and administration / IT general internal controls, procedures, configurations, data interface validation / verifications

Confidential

Sr Peoplesoft / Oracle DBA

  • Installed, configured, documented PeopleSoft 8.0.4 eProcurement system controls and processes PTools 8.1.4.10 on Oracle 8i with the Requisite catalog system.
  • Installed, configured, documented PeopleSoft 8.0.3 sp3 EPM system risk controls and processes WebLogic interface .
  • Mentored existing DBAs in best practices. Authored multiple procedures methods.
  • Assisted in the operations support of HRMS / Financials systems upgrade from 7.5 to 8.
  • Actively involved in database/PeopleSoft General Controls application documentation. Documented security and administration, procedures, configurations, data interface validation / verifications

Confidential

Sr. DBA / Data Architect

  • Designed and implemented a critical financial and inventory interface between the three companies of Time Life, Lillian
  • Vernon and Mellon Bank. Data extraction, transfer, and loading was automated via data encryption methods using Unix shell script, Perl, and VB script. System was fully functional within 15 days.
  • Documented administration, general and application internal controls SOX Test of Design .
  • Evaluated, designed, implemented secure data system interfaces and automated controls.
  • Managed schedule conflicts, setting project quality/performance standards Monitored/provided status reporting Managed resource allocations

Confidential

Sr Oracle Financials DBA

  • Daily Operations: Configure, and document key risk controls over the processes, security and technical environment COBIT model , regular communication with internal technical, applications and operations staff to ensure integrity, security and availability of the multiple databases. Monitor various operations to ensure consistency, create/alter/replicate databases, backup, disaster recovery, synchronization of production and development ERP systems, databases, and environments for multi-versions of Oracle on five HP9000 systems and EMC MQ architectures. Authored substantial Unix Korn shell scripting to semi-automate and take proactive control over disparate systems. Generated substantive system documentation.
  • Developer Support: Heavily partnered with Oracle Consulting developers for design/debug of stored procedures/ triggers/ and constraints, change control system for code and database object promotion between Baseline, Test, Development, QA, and Production environments, Designed, implemented and documented various data ETL interfaces and controls, debug of system-based automated internal controls: constraints, stored procedures, triggers, proactive database monitoring reorganizations, capacity planning, optimizing performance and Enterprise Application Integration EAI methods.
  • Multiple 3rd party systems were actively being developed, deployed, integrated, and documented on the systems being managed. Such systems included SQL LIMS laboratory mgt , Oracle Financials 11.0.2, 11.5.3 / 11i G/L, A/P, A/R , Empac time , Curator doc mgt .
  • Oracle Financials Issues: distributed replication administration, limited table/index partitioning, patch application, backup/recovery, space, database tuning, database refresh / cloning, tuning, routine Oracle Financials work forms server, concurrent mgr, report viewer, Apache/web server, etc. . Deeply involved in supporting the 10.7 to 11i upgrade of Oracle Financials.
  • Documented security and administration / IT general internal risk controls, procedures, configurations, data interface validation / verifications

Confidential

Sr Peoplesoft / Oracle DBA

  • Worked cooperatively with Ernst Young. Actively engaged in business analysis and authored the Current State and Future State IT Requirements documents. Actively participating in mapping Business Process Internal controls to Application Controls resulting in a quicker ROI through early user adoption Actively engaged in Enterprise Application Integration EAI data sourcing, ETL extract, transform, and load from disparate locations.
  • Coached staff regarding all technical aspects of UNIX and PeopleSoft system design, implementation, controls, processes and ultimate maintenance including NT domain administration and documentation.
  • Installed, configured Oracle 8i, Net8, PeopleSoft 7.51 HRMS. first DBA in Houston to install PSoft 8.1
  • Performed PeopleSoft upgrade from 7.0 to 7.5 to 8.1
  • Created substantial Unix Korn shell scripting to prepare for go-live including disaster preparedness and business continuity. Project focus was to upgrade PeopleSoft 7.5 to v8 solution incorporates substantive eCommerce, B2B, and web enabled solutions to an estimated 10,000 users. This 4-tier system was deployed under AIX, UNIX, and NT.
  • Documented security and administration / automated internal controls, procedures, configurations

Confidential

Sr. Peoplesoft / Oracle DBA Technical Lead

  • DBA Technical Lead for PeopleSoft 7.05.10 Financials. Partnered with PriceWaterhouse to have a successful 18 state rollout utilizing 3 tier Tuxedo Application Server architecture on NT 4.0 / Oracle 7.3.3. Daily tasks required extensive interaction with other IT groups to define and assure technical standards, including server builds and domain administration.
  • PeopleSoft efforts include legacy conversion, installation, client and server configuration, EAI methodology, NT domain configuration, both server and database monitoring and tuning, development and implementation management, established process and methodology for numerous IT functions including disaster preparedness and business continuity.
  • Daily PeopleSoft effort required a knowledge mastery of PS Application Objects, PS Catalog, Upgrade / Fixes, Compare and Report, Customer Connection, 3-tier architecture Tuxedo , defined/ implemented testing environments and total system integration, SQR and Peoplecode debugging.
  • Defined, documented, implemented system security and administration / IT general and automated internal risk controls, procedures, configurations, data interface validation / verifications
  • Intimately involved in the business analysis, definition and engineered physical design and support systems on Oracle 8.1.5.
  • Designed / debugged automated system internal controls: constraints, stored procedures, triggers.
  • Further responsibilities include moving updates between development and production, evaluated Business Objects, proactive database monitoring reorganizations, capacity planning, optimizing performance .
  • Senior DBA for HRizon PeopleSoft 4.x HRMS system. Performed routine space, schema, and backup management, and tuning.
  • DataMart co-architect for a patient treatment and patient outcome data. This business intelligence initiative empowers my employer to make better and timely tactical and strategic business choices based on numerous analytics. This directly saved over 20M in annual drug and other costs in year one. The Board of Directors were given the opportunity to market this 'choice' data to pharmaceutical firms and generate > 100M

Confidential

Engagement Manager and Oracle DBA / Architect

Full technical and Business Analysis responsibility for MD Anderson Cancer Center project. Funded by the National Cancer Institute, this project team defined, architected, and built a Customer Relationship Management CRM Quality Assurance system utilizing Oracle 7.3 web architecture for the scientific and business management data analysis of 1,015 therapy institutions. Hands-on duties involve all aspects of full life-cycle methodology, JAD sessions, design including Oracle Database Designer CASE , implementation, scheduling, team development, user interface, budgets, all technical and non-technical aspects for Enterprise-wide intranet Oracle based system.

Confidential

Vice President, Advanced Technology

  • Devised and implemented the first Strategic Vision and Tactical Plan ever realized by this institution. This resulted in my appointment to the Chase Manhattan Information Technology Center of Excellence by Denis O'Leary Chase Manhattan CIO . Responsible for technical leadership and 4 million annual budget.
  • Coordinated multiple team efforts to design, implement, integrate and complete multiple project initiatives. Initiatives include: Customer Relationship Management CRM , Business Intelligence, Financial and Human Resource systems integrating multiple vendor solutions and consultants. Set deadlines, assigns responsibilities, ensured the quality of deliverables, monitored and summarized progress of the project.
  • Advanced technologies and enterprise-wide solutions 7,500 users included PeopleSoft, Siebel, Intranet / Extranet, Electronic Commerce, Data Warehousing and Data Marts.
  • Directed a 58 member enterprise-wide team 8 dbas, 40 programmers, 10 data analysts supported projects with Architecture / Design data modeling , Conversion / Migration, Database Administration, and Systems Administration.
  • Managed schedule conflicts, setting project quality/performance standards Monitored/provided status reporting Managed resource allocations
  • Present and future changes to business process were managed with an Organizational Change Management approach.
  • Heavily integrated Oracle solutions, tools, methodology, and regression testing with a focus on maintenance adjustments to business processes. Established a strong methodology path for Intranet and Extranet WEB solutions including disaster preparedness and business continuity

Confidential

Business Integration Analyst / Technical Lead

  • Accountable to Board of Directors for the coordination and completion of the Customer Service System initiative CRM . Reduced the cost of customer service delivery by 65 and empowered management with multiple expanded capabilities for long term satisfaction. Directed daily deadlines, assigned responsibilities, ensured the quality of deliverables, monitored and summarized progress of the project.
  • Worked extensively with Grant Thornton and their RAD Rapid Application Development methodology for Business Process Re-engineering.
  • Steered business process re-engineering teams for mission critical business processes, object oriented modeling, JAD, client/server design, and business rules integration.
  • Responsible for the hiring, discipline and performance reviews of subordinates. Oversaw regression testing with a focus on maintenance adjustments to business processes.
  • Managed schedule conflicts, setting project quality/performance standards Monitored/provided status reporting Managed resource allocations
  • Present and future changes to business process were managed with an Organizational Change Management approach.
  • Actively engaged in the conversion and migration of existing rdbms structures to SQL/Server 4 and later switched to Sybase 10. Methodology included data modeling EasyCase and ER/Win data modeling/case tools , and development of a normalized 2 3nf data model including database triggers, stored procedures, defaults to ensure referential integrity.

Confidential

Project Manager

Held P L responsibility for both of these fixed price projects. Held oversight and accountable for all project team deliverables. Performed extensive Business Analysis. Both projects began with User Requirement and design specifications stage. Further organized, scheduled, and budgeted human and financial resources to meet client requirements. Oversaw regression testing with a focus on maintenance adjustments to business processes. Methodology included data modeling EasyCase Responsible for the hiring, discipline and performance reviews of subordinates.

Confidential

Database / Business Analyst

  • Designed and implemented a critical business intelligence fraud information system that empowered this US federal agency to successfully liquidate over 4 billion of mortgage loans and capital assets.
  • Working with the US Attorney, I inspected and analyzed IT internal controls, procedures and business controls to validate and verify mortgage and institutional financial general ledger data. Further designed and implemented a database that accurately captures and correlates financial and other information from multiple banking institutions.
  • Personal audit and business analysis and reconciliation efforts using Oracle SQL report writing directly empowered the US Attorney's office to successfully prosecute more than 12 significant cases.
  • Extracted, converted, reconciled and data transformed several million mortgage data rows from disparate locations on multiple mainframe loan systems into Oracle using SQL.

Confidential

IS Director

  • Delivered the vision, leadership, priority and focus over information technology using venture capital techniques. Engaged in the definition and structure of a comprehensive corporate-wide IS strategy / operations plan based on business risk and impact. Initial initiative focused on a Service Oriented organization
  • Led the effort to define, implement, and coordinate matrix cross functional resources required to implement a Service Oriented Architecture.
  • Succeeded in delivering value to business stakeholders by organizing and inventorying technology standards, policies, procedures, vendor and internal service level agreements to focus on making organizational capabilities predictable and actionable.
  • Managed schedule conflicts, setting project quality/performance standards Monitored/provided status reporting Managed resource allocations
  • Ensured Change Management service follows a prescriptive process and includes engineering and business stakeholders.
  • Responsible for the hiring, promotion, discipline and performance review of MIS staff. Managed applications development, budgeting. Extensive plans fully address policies, standards, procedures including Disaster Recovery Plan , security, organization layout, responsibilities, objectives, personnel, budget, cost accounting, and other operational characteristics. Responsible for the hiring, discipline and performance reviews of subordinates.
  • Accountable to end-users and management for prompt resolution of business systems, access, and recovery systems. Responsible for the Requirements Specification for a corporate wide accounting system.

Confidential

Principal Partner

Provided extensive venture capital due diligence, business analysis, technical engineering, marketing, financial and business intelligence due diligence services for more than 40 various commercial real estate acquisitions and 100 million in various buyouts, acquisitions, first/second round financing, and commercial real estate.

Confidential

Senior Marketing Analyst

Was responsible as the Senior Marketing Analyst, for a 15 million leading edge microprocessor project. My leadership and project management skills successfully empowered corporate decision makers Board of Directors on business intelligence system strategic marketing, competitive pricing, and vertical market issues and solutions for the product family. Additionally responsible for conducting various confidential briefings, design, project, and proposals were generated and presented to various senior management teams. Responsible for the motivation, administration, training, promotion, discipline and performance of 12 subordinates.

Confidential

Strategic Marketing Manager

  • Successfully developed a strategic business plan that captured 15 million in syndicated venture capital. Accomplishments include:
  • Design-administer job cost accounting system, cost center budgeting and forecasting / performance,
  • Business Intelligence lead Strategic market definition of all products and pricing, cash flow analysis corporate and economic justification and feasibility studies for several clients including AT T, Southwestern Bell, Houston Lighting Power, Appalachian Light Power .
  • Responsible for the motivation, administration, training, promotion, discipline and performance of 4 subordinates.
  • Answerable for conducting various confidential briefings, design, project, and proposals were generated and presented to the Board of Directors.

Confidential

Assistant Strategy Manager

  • Directed special project management administrative services for the Board of Directors as an Assistant Strategy Manager P L responsibility . Leadership duties included the daily operations of a 100 member multinational staff London, Singapore, Dallas, Houston and a 14.5 million annual budget. Accomplishments include:
  • Coordinated, directed the profit impact of disparate development business and engineering teams from product inception through marketplace introduction.
  • Responsible for the motivation, administration, training, promotion, discipline and performance of subordinates.
  • Managed schedule conflicts, setting project quality/performance standards Monitored/provided status reporting Managed resource allocations
  • Leadership role in the Business and Competitive Intelligence strategic marketing definition, planning, preparation and tracking of financial cost accounting and statistical reports for senior management.

Confidential Project Administrator

Accountable for P L responsibility of the Technical Publications group. Responsibilities included planning, development, cost accounting, and coordination of all phases of production for more than 50 major writing and training projects. This equates to the control of a 3,000,000 budget and a 35 member staff. Personal writings have a combined circulation exceeding 125,000.

We'd love your feedback!