Sap Solutions Architect Resume Profile
Experience 2002 present VERTRON CORPORATION
- Management and High-Technology Consultant Consult and work as a Senior Information Architect, Solutions Architecture, Project Manager, and Business and Systems Analyst of Master Data Management MDM , Data Governance DG , Operational Data Stores ODS , Enterprise Services Bus ESB , Extract, Transform, and Load ETL Frameworks, Enterprise Data Warehousing EDW , Business Intelligence BI , Reporting Marts and Analytical Reporting Solutions.
- Have extensive hands-on software development life-cycle SDLC experience in IT planning, requirements gathering, object and data modeling, application and information design, development and release management.
Confidential
Company and Role: Enterprise Architect and SAP Solutions Architect
- Responsible for the leading the technical analysis of end-to-end information architecture, information movement and management, and data governance for an Enterprise Data Warehousing solution and an Enterprise Business Intelligence solution encompassing Loan Accounting, Capital Markets / Securitization, and Credit Policy.
- Recommended a Level 1, Level 2, and Level 3 Data Governance framework as information assets transitioned from various Loan Servicing Transaction Systems to the ODS, EDW, and Data Marts.
- Designed an Enterprise Canonical Data Model ESB Solution for publishing data from transactional systems into the ODS, and subscribing data to downstream system from the ODS.
- Designed an ETL Services Architecture for transitioning data from the ODS into the EDW, Archiving solutions, and the enterprise data mart to meet both functional and latency requirements.
- Designed a 3rd normal form ODS solution by subject area. Designed a star-schema solution for the EDW, and the Informatica ETL framework to convert the ODS Layer to the EDW Layer.
- Designed Fact and Dimension Tables for Loan Accounting and Securitization. Designed enterprise level conformed dimensions, and designed reporting marts specific to each business unit requirements.
- Designed SAP BI/BO Universes and an SAP HANA In-Memory Reporting Mart Solution.
- Led the design of the Master Data Management MDM Architecture for enterprise-wide information assets such as Party Business Organization , Borrower Person , and Loan Entity .
- Led the business intelligence solutions architecture to support Operational Reporting, Analytical Reporting, Ad-hoc Reporting, Dashboards, Visualization and Drill-down Reporting.
- Designed an end-to-end Financial Management Architecture to model loan servicing events and to map them into Accounting Events, and Journal Entry Activities for drill-up and drill-down reporting.
- Responsible for assessing and writing various Architecture Feasibility Reports, Solutions Architecture Requirements Documents, and Technical Design Documents suitable for implementation.
- Led weekly technical architecture and design sessions with both IBM and KPMG for constructing the logical and physical designs and for implementation of the ODS, EDW, and Reporting Data Marts.
Confidential
Company and Role: MDM and ODS Architect and SAP Solutions Consultant
- Lead Solutions Architect in the refactoring and migrating of their legacy Title, Alphas, Contracts Rights, and Performance data systems for Television, Movies, and Internet media into new architectures and design principles to support the rapidly changing needs of the digital entertainment industry.
- Led an enterprise-wide Data Governance and Data Stewardship process for define global, line of business, and application specific information architectures for implementing in the MDM.
- Designed and developed solutions multi-domain MDM for Party and Products to support Talent, Customers, Suppliers, Partners, and Data Domain Entities in both domestic and international markets.
- Designed a Digital Asset Management solution to support the packaging and encoding of digital assets across various production workflows. Mapped the solution to interface with EIDR and ISAN registries.
- Reviewed various Fuzzy Logic Pattern Matching and Percentile Matching algorithms to determine the best data matching algorithm suitable for creating a Title Matching golden record.
- Improved the data architectures, data management, and business analytics models across staging, transactions, data warehouse, and analytics reporting in Business Objects.
- Worked with Application Development to assess, design and integrate with SAP and 83 other legacy systems using a Standardized Electronic Service Bus ESB Architecture implemented in JBOSS.
- Defined and implemented an Information Hub and Integration Methodology and Workflow for handling ESB data synchronization, orchestration, subscription, and delivery services.
- Defined a data management lifecycle, methodology, and templates to maintain the integrity of MDM and ESB metadata and data models using Informatica Business Glossary and Metadata Manager.
- Recommended best practices and methodologies in the areas of Data Administration, Data Governance, Data Quality, and Data Stewardship authoring, subscribing, and publishing rules .
- Defined migration strategies, performing analysis, mapping, fuzzy logic matching, data interface changes, and modeling from a legacy state to an IBM Infosphere MDM Tool and ESB-based future state.
Confidential
Company and Role:, SAP Enterprise Architect and Technical Project Manager
- Retained to assist their client, The State of Confidential Office of Mental Health, in defining a Data Warehousing and Business Intelligence Strategy, a Master Data Management MDM strategy, a Key Performance Indicator KPI Model, and a cross entity ETL Framework using a hybrid of technologies across the enterprise..
- Reviewed data models from in-house applications, 3rd-party healthcare applications, and from their outpatient Medicaid feed and recommended a unified service delivery architecture for all of their 26 inpatient hospitals, its outpatient clinics, and their non-inpatient residential programs.
- Reviewed, modified, and validated their MDM and ESB services architecture, programs, and governance model to support their regulatory, care provisions, and their research activities.
- Provided guidelines and recommendations to ensure their MDM software had the ability
- to interface with existing legacy applications and with sister agencies for data sharing purposes.
- to create the user interfaces needed to support all the data stewardship processes, and
- to support record profiling, cleansing and matching for both automated and manual stewardship,
- to create and manage the information models from all content and application domains,
- Designed and implemented an IBM Initiate MDM Master Person / Party Indexes MPI to include all people identifiers. Examples include Person e.g. Patient, Practitioner, Employee, or User , Organization e.g. Agency, Program, or Facility . Extended the core MDM solution to include Master Indexes on locations and the cross-referenced hierarchical relationships among them.
- Reviewed SAP BI BO, IBM's Infosphere MDM and Netezza DW solution architectures and made Best Practices customization recommendations for integrating these solutions into the enterprise.
- Reviewed all decentralized Business Owner data warehousing and business intelligence applications and recommended a BI roll-up strategy for the centralized Data Warehousing IT Department.
- Led the design and development with both onshore and offshore technical resources.
Confidential
Company and Role: Solutions Architect and Technical Project Manager
- Reporting to the EVP and CTO, responsible for leading an enterprise-wide technology migration, business process re-engineering, and system enhancements of their master data management, data warehousing, and business intelligence systems to prepare for a 5-year plan of tremendous growth and expansion.
- Assessed their Corporate Finance, Accounting, and Tax requirements across their Triple NET Leases and their operational Medical Office Buildings LOBs to assess how JD Edwards could leverage to consolidate various Excel and 3rd Party software applications.
- Developed a JD Edwards Chart of Accounts structure and a financial processing model to support both their GAAP and Tax Revenue Recognition and related Financial Models.
- Assessed various source systems, including Excel, Argus, JD Edwards, Impak, Saleforce.com, Yardi, and Kardin and designed a JDE Enterprise One Master Data Management MDM to interoperate with a Financial data warehousing solution to consolidate these systems for centralize reporting and analysis.
- Designed and implemented an Informatica ETL Framework for moving transaction source data to the Data Warehousing environment. Completed performance tuning activities to achieve the desire SLA.
- Interviewed the business owners across Originations, Underwriting, Development, Accounting, Asset Management, Property Management, Capital Markets, Financial and Tax Reporting to understand their business requirements and architected a Master Data Management MDM solution to fit their needs.
- Designed and led the development of an enterprise-wide data warehousing solution consisting of Development, Landlord, Tenant, Tax, and Metrics Data Marts leveraging Information for ETL.
- Mapped their in-house custom reporting system and to a more scalable and commercial Business Objects Analytics Solution to support their Standard Corporate Reporting, Supplements, Tax Trial Balances, One Sheets, Dashboards, and various Ad-hoc Management Reports.
Confidential
Company and Role: COINSTAR, , Senior Solutions Architect and Program Manager
- Lead Solutions Architect and Developer in the design, development, and development of a Global Money Transfer Solution across several acquired companies with vastly different Money Transfer Solutions.
- Designed and developed various Federal, State, and company specific Anti-Money Laundering AML Alerts and Tracking for Daily, Weekly, Monthly, and Quarterly limits.
- Designed and Developed an Electronic Service Business ESB solution with orchestration layer services to support the integration of legacy money transfer applications with the Global MDM Solution.
- Designed and Developed an ESB SOA Solution that support Publisher and Subscriber Rules, Multi-Domain Master Data Access and Retrieval, Auditing, and Security Controls.
- Designed and developed solutions multi-domain MDM for Party and Products to identify the same customers across various companies and brands sending or receiving money internationally.
- Designed a proprietary fuzzy logic rules matching algorithm to identifying customer across systems.
- Designed and developed an MDM Agent Solution to identify the same Sending or Receiving Agent across various companies and brands sending or receiving money on the behalf of their customers.
- Designed and implemented a Data Governance and Stewardship Framework for non-deterministic transactions. Implemented a Review, Status Updating, and Denial and Approval workflow.
- Developed a Multi-Language MDM Solution for Customers matching names across various ISO Coding Conventions, and ASCII and Unicode Solution Sets.
- Recommended best practices and methodologies in the areas of Data Administration, Data Governance, Data Quality, and Data Stewardship authoring, subscribing, and publishing rules .
- Defined a data management lifecycle, methodology, and templates to maintain the quality and integrity of metadata and data models.
- Lead the development and selection of new technologies and application development tools.
- Prepared technical reviews, analysis, assessments and documented Technical Notes.
- Led both internal staff and offshore technical resources for the full SDLC.
Confidential
Company and Role: , Data Architect and Data Warehousing Consultant
- Retained to design a MDM framework and architecture for their Business Intelligence Reporting System for their SalesForce.com Referrals and Opportunities system and their banking operations across Commercial, Retail, Business, Treasury Management, Auto and Finance, and Commercial Real Estate Business Segments.
- Developed a MDM Architecture across all business segments for Profitability Analysis, Month-To-Date Sales, Weekly Sales, Accounts Summary and Detail, Major Change Alerts, Earnings Analysis, Trends Analysis, Revenue Contribution, Income Detail, and Balance Growth for the BI Reporting System.
- Developed a standardized dashboard and reporting framework for reporting key business performance metrics across Regions, Areas, Branches, Teams, Officers, Colleagues, Customers, and Products.
- Led the design and development of Data Stage queries to extract information objects from SalesForce.com
- Managed and led the development of an Informatica ETL Framework and Processing Environment to promote all staging data sources into the Enterprise Banking Data Warehouse.
- Managed and led the development of the Informatica ETL Business Glossary and Metadata Manager.
- Led the conversion of over legacy reports into the new MDM and the SAP BI BO Reporting Environment.
- Led the design of key business performance indicators BPIs into the MDM and into the executive level dashboards and operational alerts reporting.
- Responsible for the full SDLC technical project management process for all MDM, Data Warehousing, and Business Intelligence design, development, and deployment activities.
- Met with various banking business segment members on a weekly basis to discuss their reporting requirements, current reporting defects, and ideas for enhancing existing functionality.
- Led the design and development of the User Interface design of drill down dashboards for BI Reporting.
Confidential
Company and Role: SHARP Health Plans, Solutions Architect and Lead Developer
- As the lead solutions architect, designed, developed, and deployed an enterprise Master Data Management solution for patient, provider, and location domains integrating with the GE Centricity healthcare system.
- Designed an Enterprise-wide Corporate Taxonomy incorporating all of the GE Centricity Dictionaries.
- Implemented a Single Source of Truth issue for all of the GE Centricity Dictionaries across their entire network of Managed Care Plans, Medical Provider Networks, Primary and Specialty Care Groups, Hospitals, Pharmacies, and Laboratories.
- Designed all Logical and Physical data models, data marts, and end-user business universes to interface with Claims, Provider, Member/Subscriber, Plan, and Accounting Data Domains. Developed the Data Warehousing Technical, Workflow, and on-going maintenance methodologies.
- Developed an ETL Framework for extracting data from multiple GE Centricity systems into the data warehousing environment to meet security, data quality, and business intelligence confidence intervals.
- Implemented ODI integration technology for ETL processing of 3rd party data feeds to meet SLAs.
- Led a team in the development all ETL procedures and PL/SQL Stored Procedures to populate and refresh the data warehouse integrating with the MDM and to aggregate reporting tables.
- Responsible for defining system, security, and performance requirements, such disk space allocation, partitioning and indexing strategies and end-user access rights to reports.
- Interfaced with clinical staff and medical billing to understand and document their business intelligence analysis and reporting needs.
- Developed an overall ETL design, development, and migration project plan. Assign team members specific technical modules. Held code reviews to ensure coding was consistent with overall architecture.
- Designed and developed a KPI module for tracking cross channel quality of care and cost of care for physicians enrolled in multiple management care plans, provider networks, and care facilities.
Confidential
Company and Role: , Solutions Architect and Technical Project Manager
- Responsible for leading a team of business, systems, and technical analysts and developers in designing and upgrading an existing Loan Servicing System for improving their customer service and cash management.
- Researched and Gathered Requirements to understand the non-prime auto financing industry.
- Worked with the Sales Department to automate the Credit Report integration and Risk Assessment Models for determining the overall default risk and relative interest rate to Prime for an applicant.
- Developed an end-to-end solution from Applications, to Loan Determination, to Payment Processing and Account Management, to Defaults and Collections, and Collections and Recovery.
- Developed a Lettering System that would automatically generate correspondence to clients based on preset event or analytic triggers on their account.
- Developed a Business Objects business intelligence and information architecture for an enterprise data warehouse for their Loan Applications, Financing, and Collections business practices.
- Led team in designing and deploying an Enterprise Data Warehouse and Business Intelligence Reporting System for all Loans, Financing, and Collections departments.
- Led the project through the Full Software Development Life Cycle using an iterative Rapid Application Development Methodology.
- Designed and developed a business intelligence and reporting framework for end-user access including Security, Accessibility, Filters and Dashboard interactivity.
- Held weekly status meetings to understand and assist with any technical or business issues
- Devised Technical and Executive PowerPoint presentations and provided bimonthly status updates to management.
Confidential
Company and Role: , Enterprise Solutions Architect
- Responsible for leading a team of business, systems, and technical analysts and developers in building the next generation collections and recovery systems to improve the analytics of pricing for charged off accounts purchasing, and to streaming the collections and negotiations process for acquired accounts.
- Developed Project Plans based on Project Scope and assigned Technical Resources
- Developed or Validated Costs and Timeline estimates for implementation of business requirements
- Management Project from Discovery through Deployment. Escalated issues impacting the project beyond my control and reported on the status of various project milestones on a regular basis.
- Worked closely with the PreSales team to understand their risk management models around valuing charged off accounts to valuate thousands of client portfolios prior to bidding on the portfolio.
- Integrated 3rd party Credit Assessment and Job Security Score Technologies to assess account collections risk and to determine the overall value of a client portfolio of charged of accounts, and for loss mitigation.
- Implemented a Communications Management System to track all legal, written, and verbal communications with collection accounts and to continually update their risk profile.
- Implemented both Inbound and Outbound Call Metrics and Tracking Solutions to provide insight into the total costs of recovery and the engagement of progressive status of an account recovery.
- Led the design and development of both an Operational Data Store ODS and an Enterprise Data Warehouse EDW for real-time day to day account management and tracking, and for longer-term trends and analytics analysis.
- Implemented an Enterprise Data Dictionary of standardized business terms and information elements across various collections units and business department for implementation into the ODS and EDW.
Confidential
Company and Role: , Management Consultant and eBusiness Solutions Architect
- Reporting to the Vice-President of Strategy and Innovation, retained to review and assess their current Enterprise Resource Planning ERP Systems and their Financial Management Applications. Made recommendations to improve their end-to-end Supply Chain processes and their Invoice to Cash Life Cycle.
- Completed a business case identifying over 12 Million in savings by providing a unified sales support portal across all sales channels integrated with Salesforce.com and consolidating and integrating back-office technology components into one common SAP architecture and Business Intelligence Framework.
- Recommended an in-house versus an outsourcing strategy for the maintenance, operations, and hosting of major eCommerce and BI applications and technologies.
- Constructed an e-business strategy and BI implementation framework that was consistent with their business and product strategy, their pricing strategy, and their online promotions strategy.
- Completed an independent value, and ongoing costs assessment of all sales channels, including online commerce, EDI, Handheld and Mobile Devices, Telephone Dial-in, and Manual Call Center ordering, to identify any significant opportunities for cost reduction or service productivity improvement.
- Constructed an assessment framework and recommended a build versus buy for the development of major eCommerce and BI components.
Confidential
Company and Role: , Senior Technical Project Manager
- Worked with the Tax, Licensing, Customs, and Logistics Division to define, document, and enhance Regulatory and Financial Business Processes for Exporting and Importing Compliance Services, eProcurement Workflow, Purchasing, Invoicing, Payments, Adjustments, and Reporting.
- Contributed to the development and management of project and annual budgets in alignment with corporate financial goals. Participated in IT resource capacity planning.
- Led a team of over twenty technical architects, developers, and testers in the design, development, and deployment of a vendor inventory tracking and purchase management system for non-revenue shipments between external vendors and intra-company purchases.
- Provided project management recommendations to sponsors for planning and prioritization of various projects adhering to the company's PMO RUP, project methodology and quality assurance guidelines.
- Led or participated in various Quality and Compliance projects for internal process improvements.
- Managed groups of technical personnel to oversee all aspects of multiple concurrent projects to achieve expected results within the predetermined budget, schedule and level of defined quality.
- Developed and communicated alternatives to project sponsor to satisfy requested changes in scope and/or requirements, as well as, management and coordination of mitigation of risks.
Confidential
Company and Role Business Architect / Consultant
- Reporting the Director of Global Customer Services, responsible for working with the most senior levels of management in Information Technology, Confidential, and Emerging Markets Sales and Service Divisions, Marketing, Product Development, and Corporate to design and construct a deployment plan for a Global eBusiness Web Portal for all Philips Healthcare Key Markets around the world.
- Developed and presented a business case and financial model to the Executive Steering Committee outlining the investment costs, benefits, and ROI over a three to five year period.
- Reviewed the architectures of various independently developed customer-facing applications InCenter, eStore, NEPOS, eLearning, PSI Reporting, PMS, Asset Management to assess how to re-engineer and seamlessly integrate them into one customer-facing web portal.
- Developed a detailed GAP Analysis, Realization Plan, and Operational Impact plan for migration from the existing fragmented web portal environment to an enterprise global eBusiness environment.
Confidential
Medic Mate Technologies
As CTO and SVP, Product Development, of a medical healthcare software company responsible for research and development, innovation, design, and delivery one of the industry's first electronic medical records EMRS that fully integrated clinical treatment and care planning with financial and administrative billing system. Featured in PC Today Magazine for the innovation of our Medic-Mate and Medic-Link patient and provider management and administrative systems and technologies. Sold the company to a healthcare services provider.
Confidential
DIRECTOR
- Managed an annual budget of 50MM to 60MM per year. Supported eight 8 department heads - with a total human resource capital scope of over 300 people.
- Reported to AT T CFO Executive Board in developing a Mergers and Acquisition M A Architecture for integrating acquired companies and subsidiary business units ERP Systems into an enterprise-wide financial management architecture FMA .
- Led an overall organization change initiative a to enhance operational and financial integrity process, b to redefine key strategic roles to streamline operations and to increase overall accounting integrity and to reduce business and legal risks and c to define business and financial requirements for all in-house and 3rd party ERP Systems.
- Responsible for an enterprise-wide business and technological migration to transition all of AT T Business Units from the corporate mainframe financial system to various Business Unit specific Client-Server Financial Systems solutions.
- Supported a team in defining and documenting financial systems requirements for the internal development of an enterprise-wide Financial Management Architecture FMA across all of AT T client-service financial systems applications within each AT T Business Unit.
- Led a Task Force to reviewing corporate quality and regulatory compliance issues within each business unit to ensure all re-engineering efforts where with business policy
Confidential
DISTRICT MANAGER
- As Department Head FSG, supported twelve line managers, a department of over seventy employees, and an annual budget of over 20MM to lead the design, development, deployment, support and training of a Client-Server Financial Systems Application suitable to fit the unique needs and requirements of AT T.
- Conducted business case and cost benefit analysis on 'make vs. buy' decisions. Research 3rd-party solutions from a business requirements and Return on Investment ROI perspective. Participated in various due diligence meetings with vendor and development partners.
- Participated in select Discovery, Design, Architecture and Code Reviews to ensure the business, project management, and technical choices were best-in-class and were aligned with the goals of the department.
- Handled budgeting, project schedules, inter-project dependencies, critical success milestones, escalation and resolution of critical issues, hiring and replacing talent.
- Developed a transition and staging environment for trial balance reconciliation between the mainframe and the client-server environment.
- Negotiated Service-Level Agreements and Business Unit funding with each business unit.
- Established and negotiated joint development efforts with Oracle and other 3rd party solutions providers.
- Developed an internal Training, Customer Service, and Support Center for technical support and maintenance of the Financial Systems Application.
Confidential
CHIEF TECHNICAL ARCHITECT AREA 41 recruited the most recognized thought leaders in high technology to represent AT T within the American National Standards Institute ANSI and the National Institute of Standards and Technology NIST with the strategic intent of establishing AT T's technological intellectual property into national and international computing and communications standards. Elected as Chairperson in the International Standards Organization ISO for Transport Layer Testing and Certification Standards.