We provide IT Staff Augmentation Services!

Sr Mdm Architect Resume

Orlando, FL

SUMMARY:

  • With over twenty five plus years of hands on experience in Enterprise Architecture, BI Architecture, ERP Solutions, Software Design, Development, Integration, Implementation and Project Management, I offer exceptional skills and value to any role or organization.
  • Complex project and architecture management and Implementation Specialist, 100+ concurrent projects, 200+ near - shore and off-shore resources, $100MM+ budgets and managing local and outsourced reports using common project management methodologies like AGILE, SCRUM, RUP, WATERFALL etc.
  • Global governance procedures and creating a PMO/Project Management Office experience with demand and portfolio management. PMI /PMP Certified and SDLC expert.
  • Experience in various facets of Enterprise Architecture including business and Business Intelligence architecture, Solution Architecture, Application Architecture, Information and Data Architecture, security architecture, and service-oriented architecture (SOA) and acting as SME on any project or business
  • Experience in hands on use and Administration of popular and latest versions of ETL tools Informatica Big Data/Cloud/DIH editions, Informatica Power Center, Confidential Infosphere Data Stage and QualityStage Designer and Administrator, Confidential MQ, Confidential MDM CE Ab Initio, Informatica IDS services including data profiling, MDM, IDD, IDQ and Real Time data cleansing and integration, Oracle ODI, SSIS, Ab Initio and Confidential WebSphere and Legacy Systems conversions, B2B Data Exchange, B2B MFT, EDI and HIPPA, Websphere Message Broker and use of ACCORD xml standards.
  • Experienced in Data Profiling, Data Auditing and Data Analysis of structured and unstructured data, explicit and implicit data, content management, preparing and implementing technical roadmap and architecture to develop a Trusted Data Repository storing certified data, Dimensional and Subject Area Based Data Warehouse, developing a BI Architecture and integrating with consumer applications, reporting, data auditing and HIPPA compliance systems.
  • Ability to Identify, validate and implement appropriate data audit checks and error and exception checking. Persisting audits, data audit, metadata error and exception checks and results in the Trusted Data Repository so it is accessible. Using data and metadata error and exception check results for auditing and other purposes via reports and queries. Adding process tracking audit data elements identifying the ETL or Error and Exception process that created data in the Trusted Data Foundation or the Error and Exception Repository. Adding control data elements that distinguish one version of a data from another; ensuring that when multiple perspectives are required, the distinguishing data element is part of its identifier. Design of an interim "holding tank" to house data that is not ready for Trusted Data Repository.
  • Exceptional skills in identifying talent, vendor negotiations, and working directly with business users, bridging the distance between business users and technical staff to impart a clear and common understanding of project goals
  • Ability to build a Solid QA process to maintain consistency in service delivery, built to industry standards and using best practices.
  • Use a full range of quality methodologies to improve services and products. These include, but not limited to conducting peer reviews, performing functional and physical configuration audits, root cause analysis, sampling, and time series analysis to determine trends to monitor quality and performance in terms of reliability, dependability, and uptime and customer satisfaction.
  • Effective use of Confidential Rational Tools and Mercury Quality Center and Test Director tools for loading requirements, traceability metrics, creating test cases with execution steps, execution of test cases in Test Lab, Defect and bug tracking and creating Standard and Customized Reports.
  • Ability to train QA testing personnel in the effective execution of the entire Quality Assurance Process
  • OBIEE roadmap, Oracle ERP, DAC, Analytics, including Informatica IDS and ETL tools, deployment, configuration and testing, Enterprise and OBIEE Architecture/Administration, HR, Financial and Order management Fulfillment Analytics
  • Installation, configuration, deployment and setup for Confidential Project Server 2010, Confidential SharePoint 2010/2013 and Team Foundation Server 2010/2013 administration and integration of Confidential Project Server 2010/2013, Fast Search Server 2010 & 2013 (built in), collaboration, Dashboards, Business Intelligence, Visio Services and TFS ( Confidential Team Foundation Server) VSTS (Visual Studio Team System) using Agile development
  • ITG PPM modules expertise, Confidential SQA and Robot, Peregrine and Remedy for Change and Release Management.
  • Oversight and management of Design, Development, Deployment and operational phases of complex business critical and high availability solutions.
  • Crisis, risk mitigation, conflict and negotiation management.
  • Experienced with budget processes, and financial baskets.
  • Re-engineering complex systems, production system support and release management.
  • Customer-centric communicator, facilitator with ‘excellent’ communication skills and savvy BRM (Business Relationship Manager).
  • Knowledge in finance, financial services for large banks, ACH and AML transactions, Real estate and Mortgage business, IT auditing, insurance, workers comp, re-insurance, behavioral health, logistics, construction, use case analysis, regulatory reporting systems and elegant business solutions to complex, mission-critical, cross-functional, emergent or time-sensitive problems.

TECHNICAL EXPERIENCE:

TECHNICAL TOOLKIT (Sampling, comprehensive listing available at interview):

Applications Development & Coding: COBOL, CICS, PL/1, VBScript, ASP/JSP, JavaScript, PL SQL, Confidential .NET, MVC.NET, VB.NET, ASP.NET, Java, PHP, PERL, VB, C, C++, Oracle, Oracle Portal, LAMP

Business Intelligence, ETL, EDI, MDM, Data Quality, Virtual Data and Data Cloud: Oracle OBIEE Analytics and Informatica, Informatica IDQ, IDS including Data Profiling, Power Center, Power Exchange, B2B Data Exchange, Informatica MDM. DIH and Informatica Big Data and Real Time Transformations, Confidential MDM AE, Confidential MDM CE, Confidential Infosphere Data Stage, QualityStage Designer and Administrator, SAP Data Integration, Informatica Configuration and Administration, ODI, SSIS, SSRS, SSAS, Ab Initio, Websphere, Message Broker, Cognos, configuring Cognos CubesSAP Connectivity, Batch access, Real-time access, CDC access Integration Patterns, Operational and analytical data integration, Data quality, Virtualization and Cloud based integration Information Lifecycle Management, Manage Test Data, Protect Sensitive Data and Improve application performance

Confidential Products: Windows 2010 / MS Office Suite, IIS6, IIS7.5

Project Management, Architecture, Implementation and Administration: MS Project, Agile, Scrum, Project Server 2003, 2005 & MS Project Server 2010/2013, VS Team Foundation Server 2010/2013, SharePoint 2010/2013, PMP & PMI Certified, Mercury ITG PPM Tools Expert, SharePoint Migration, InfoPath

Change Management: Peregrine / Remedy

Data Modeling: ER Studio, ERWIN, Infosphere Data Architect, MySQL Workbench, PowerDesigner, Toad Data Modeler, OBIEE, MDM

Application Architecture and Technologies: SOA, AIA, SharePoint, MOSS, Biz-talk, EIA, CORBA, COM, DCOM,JBOSS, Oracle E-Business Suite R12, Oracle RAC, Oracle Data Guard, BEA WEBLOGIC installation, tuning and administration

Databases: Oracle 10g, 11g, Oracle EXADATA, RAC, DB2, UDB, Big Data, Netezza, Hadoop, Access, HP Solid, SQL Server 2013, 2010, VSAM

Security: LDAP, Active Directory Administration and setup, Confidential STS, Cisco PIX Firewalls, setup rules etc.

Automated Testing Tools: Mercury Test Director, HP Quality Center, Confidential SQA and Robot

Schedulers: Maestro, AutoSys

Platforms: VM / MVS / NT / UNIX/ LINUX / Sun Solaris, Windows 2003, 2008, 2012

Statistics: SAS / COM / DCOM / SOA, MTS

PROFESSIONAL EXPERIENCE:

Confidential, Orlando, FL

Sr MDM Architect

Responsibilities:

  • Working on a SQL Server database platform, SAP Business Objects ETL fed by JD Edwards Financials data sources, finally using Qlik Sense for Dashboards and Reporting.
  • Architected and led ETL and BI teams to rebuild BODS ETL code; improved ETL performance by over 80%.
  • Architected a brand new BI Platform and Data Warehouse and custom designed data marts for Qlik to consume. Upgraded to handle over 20,000 users worldwide.
  • Developed BI Environment for dashboard, executive and cross domain reporting.
  • Designed, Built and completed Performance Analysis Tools to provide performance statistics of ETL code, SQL Queries, BODS ETL providing much needed information into where developers need to focus efforts to improve code and queries.
  • Designed, Built and completed from scratch, Database Capacity Planning Tools providing continuous and insight into current and future SQL Server Database Storage Capacity requirements for Staging, Data Warehouse and BI databases.
  • Commenced design to convert SAP BODS ETL to Informatica, plus Meta Data and Master Data Management for Data Governance, while implementing Informatica IDQ for Data Quality.
  • The goal of this project is primarily to map and transform data from SAP DW platform into a SQL Server platform using QlikView and Qlik Sense for reporting.

Confidential, Charlotte, NC

Sr. Informatica Architect

Responsibilities:

  • As a lead architect I lead a team of senior and junior Informatica developers, developing projects for the wholesale customer due diligence system that accommodates multiple lines of business across global locations and satisfies multiple regulatory jurisdictions.
  • I designed advanced ETL architectures, hands on complex mappings, maplets, workflows, working with heterogeneous sources (SAP DW (HANA) source, flat files, xml, oracle, Teradata, sql server) using SOAP and REST services, Unix/Linux scripts, AutoSys job integration, created mappings and workflows with logs suitable for data analytics and reporting, automatic error handling and recovery.

Confidential

Sr. Enterprise & ETL Architect

Responsibilities:

  • Engaged to hands on architect, design and build, introduced Confidential UDMH model as base, a brand new Customized Enterprise Data Warehouse to suit client requirements and sources, Analytic and BI solution in Netezza appliance, designed and built Conceptual, Logical and Physical data models for the Enterprise Data Warehouse and BI Analytical Model including Medicaid and Medicare systems.
  • Data is being sourced from several SQL Server based applications, reporting systems and home grown data warehouses.
  • Improved relationships with C-Level, Business, Finance and IT resources for requirements/analysis and presenting a POC and final working solution using Agile Methodologies.
  • Exceptional expertise in developing and implementing Confidential DataStage and QualityStage ETL and EDI jobs and templates, Automation using Infosphere Information Services Director, debugging in Development, QA and migrating to production.
  • Confidential Infosphere DataStage, Confidential MDM Advanced Edition, QualityStage Designer, Confidential Infosphere DataStage, QualityStage, MDM Architect AE, Inforsphere Information Services Director, Embarcadero ER/Studio Data Architect XE7, Confidential UDMH Healthcare Atomic, Dimensional and Business Data Models, Netezza Appliance, EDI and HIPPA compliance

Confidential

Sr. Solutions Architect

Responsibilities:

  • Streamlined solutions architecture for a very large tactical and complex Confidential internal project.
  • Improved Technical architecture and process automation
  • Accelerated support to onshore and offshore development teams and architects.
  • Improved Business Intelligence solutions
  • Mastered Conceptual, Logic and Physical data models
  • Established SharePoint BI Solutions

Skills: Data Modeling, Big Data, ER Studio, SharePoint BI, Excel Cubes, SQLizer

Confidential

Sr. Informatica Architect

Responsibilities:

  • Sr. Architect and 'hands-on' lead for several Informatica IDQ 9.5.4 Analyst and Developer CRM, Investment, Data Warehouse and host of other projects for Data Cleansing, IDQ Data profiling, IDE Data Discovery, IDS for reporting, MDM Data Hub, ETL (Power Center) and Meta Data Manager, B2B Data Exchange and B2B MFT projects and other key regions, turning normally unreadable and corrupt data from sources including Flat Files, CSVs, XML, UDB, DB2, Oracle, Sequel Server, Big Data and Netezza, Hadoop sources into useful Enterprise level Data Assets. Improved data analysis, identifying and implementing data quality rules in IDQ and finally linking rules including Address Doctor to Power Center ETL processes and delivery to MDM Data Hub and other data consumers.
  • Streamlined Informatica Server configuration and administration, performance tuning, mentoring and training end users in user of IDQ, creating mappings, transformations and executing workflows, writing Linux Command Scripts and applications.
  • Exceeded expectations for generation of several million dollars of revenue not otherwise possible.
  • Led a team of onshore and offshore resources.

Confidential

Sr. Informatica Architect

Responsibilities:

  • Established changes identified during an assessment of MFS Informatica Data Services IDS implementation for Asset Management data sources, improved Informatica Configuration and effective use of Informatica IDQ, IDD, B2B Data Exchange, Data Profiling and sourcing for Informatica MDM. Improved and Maximized IDS performance by 58%.
  • Configuration and Tuning data sources, views, queries, refactoring Informatica transformations for performance improvements, improving Informatica IDS Virtual Data Environment and whatever it takes to derive maximum value and performance from the systems.

Confidential

Sr. Application Architect

Responsibilities:

  • Introduced organizational change and provide insight into data governance principles, complex project management and to provide insight into, create, define and help implement new requirements design, Enterprise Architecture and supporting Solution Architecture, improve data processing, testing and managing techniques.
  • Providing hands on support and guidance to improve data quality, built data audit checks and minimized data delivery times. HSBC Bank Mortgage Application Development Manager and Technical Architect for a large financial services Asset Management project for a HSBC Bank, managing ACH, AML Anti Money Laundering, use of Swift Codes, Fidelity Lender Processing Services data feeds, Loan Originations, Processing and Servicing Data Feeds involving Informatica IDS, Informatica Data Profiling and rule engine management, B2B Data Exchange, B2B MFT and ETL mapping & implementing Informatica MDM for multiple data feeds, Informatica IDQ, Informatica Data Profiling, error reporting and scheduling development and delivery through QA, SIT and UAT. Environment: SDLC waterfall and Agile methodologies, Oracle EXADATA implementation, Sybase, Informatica 8.6 and 9.5 including Informatica IDS, Informatica Configuration, Informatica Data Profiling and MDM Hub, Tivoli, Sequel Server, OBIEE and Hyperion BI Applications, Websphere Message Broker, Application Architecture, Database Architecture, BI Architecture and Integration Services

Sr. Application/SharePoint 2010 Architect

Confidential

Responsibilities:

  • Accomplished Enterprise SharePoint Architecture, Meta Data Model Design for Metadata driven Employee Performance Evaluation Forms (70-100), helped model data warehouse and implement data quality and data audit checks with error reporting, Created builds, wsp deployment in SharePoint 2010, assisting with design issues etc.
  • Evaluation Forms (120), integrating .net C#, creating builds, release management, Site Template Customized, content management, web parts, wsp deployment files, assisting with design issues etc.

Additional tools: InfoPath 2010, Visual Studio 2010, .Net C#, Telerik Controls, html to pdf converters for printing

Project Methodology: Agile

Confidential, New York, NY

Sr. Application/SharePoint 2010 Architect

Responsibilities:

  • Directed and integrated SharePoint 2010, Confidential Project Server 2010, Fast Search Server 2010, collaboration, dashboards, Business Intelligence, Visio Services and TFS ( Confidential Team Foundation Server) VSTS (Visual Studio Team Server) using Agile and SCRUM methodologies.
  • Created Web Pages, setup shared folders, created reports, dashboards and maintained security with LDAP.
  • Deployed from scratch, setup, configured and provided PMO support for Confidential Project Server 2010, Confidential SharePoint 2010 and Team Foundation Server 2010.
  • Hands on Manager of developers, SharePoint 2010, ETL and Application Design Architecture and delivered three Enterprise-wide Conversions of Legacy Application Projects
  • Converted DataEase applications and databases to Confidential .NET and MVC with data modeling in ERWIN and designing and implementing databases in SQL Server 2008 R2 with SSIS for ETL and SSRS for reporting
  • Provided direct support for 3 Timekeeping .NET applications and SME role

Confidential

Enterprise Architect

Responsibilities:

  • Global leader for creating mobile real estate applications for real estate professionals and consumers.
  • Brought structure and reliability to IT, ETL Data Acquisition and Support Processes and Data Warehouse.
  • Led iPhone, Palm, Android, Blackberry, Windows Mobile 7 and feature phone development team
  • Middleware Development, Data Architecture and data modeling for the Data Warehouse, ETL design and Enterprise architecture for over 175 individual data sources using Oracle ODI with data checks and error reporting systems
  • Technical and business SME for process and application design and deployment
  • Maintained SQL Server Databases for LDAP and Active Directory
  • Provided OBIEE and BI Applications configuration and administration, Dimensional and Relational Modeling development, Enterprise Architecture, Solution Architecture, Designing and creating Databases, Dashboards and Reporting environments
  • Led Disaster Recovery Planning, IT Infrastructure with hands on Cisco PIX firewall, Tape Backup, Active Directory management, VPN, Oracle Data Guard,
  • Recruiting and Interviewing, Capacity Planning, Project Planning, Implementation planning and advisory role to Senior Management. Environment is LAMP, Oracle 10G, Red Hat Linux, Brew, Objective C++, Java, J2EE, XML and custom protocols.
  • Used Agile and SCRUM methodologies for this group
  • Responsible for 24x7 Production up time

Confidential

Enterprise Data Architect and BI Contractor

Responsibilities:

  • Reconfigured and setup SharePoint Server, SQL Server 2008 with SSIS and helped complete a SharePoint Document Management project in record time and received an award (normally reserved for employees).
  • With an IT staff of at least 95, managing at least 100 concurrent projects, the year’s project portfolio was $39m.
  • Having set up a complete PMO in less than a month, led the Rational and Primavera teams to develop custom Project Planning Templates, Project Submission, Issue Management and Tracking tools.
  • Excellent communication skills resulted in an unequivocal acceptance of project management principles. As hands on PMO, my goals were to lead all IT projects to success with 100% successful delivery on time, under or within budget with zero failure rates. Used Primavera for Project Management and Rational CQ for Project Tracking and acted as personal mentor to all Project Management Directors, Project Mangers and Team Leads.
  • Technical and business SME for applications, BI systems, Oracle integration, application design and deployment
  • Developed Data Warehouse/Information Factory Project using ERWIN, Developed Meta Data Model, Informatica Configuration, Data Profiling, built data audits and checks with error reporting and handling systems, Power Center, Informatica/ODI for ETL and OBIEE, E-Business Suite R12 implementing HR, Oracle Financials and Oracle Order management and Fulfillment Analytics and Reporting on Oracle 10G.
  • As hands on OBIEE Architect and Developer, engaged in multiple OBIEE Installations and configurations, Requirements gathering, OBIEE Dimensional and Relational Modeling.
  • Defined Informatica ETL Specs and Mapping, Informatica Power Center, Informatica IDS Data Profiling and Real Time Transformations, Creating Physical, Business and Presentation Layers in OBIEE Repository, Answers, creating Custom and Complex Write back XML Templates.
  • Created reports and reporting cubes in OBIEE Answers, exceptional JavaScript and HTML functions for real time validation leading to fantastic OBIEE Dashboards and functionality.

Confidential, NJ

Senior Technical Project Manager

Responsibilities:

  • Delivered on time, under budget with 100% agreed functionality.
  • As technical manager of application development, also hands on supported existing systems, was engaged in the IT governance process, in hands on development and management of Ab Initio ETL, JAVA J2EE, WebSphere and Cognos reports and configuring Cognos Cubes, operations management, implementing data validation and data audit rules
  • Mainframe data conversion to Oracle and DB2; environment Cobol, CICS, VSAM, PL/1
  • Maintained weekly & monthly financials and status reports on Mercury ITG, was responsible for the review of vendors’ SOWS, contracts & invoices for 6 external and outsourced vendor groups.
  • Delivered weekly status reports for activities of all groups and monthly project and budget reports to PMO. Engaged in Strategic and resource planning.

Confidential, Philadelphia, PA

Technical Director

Responsibilities:

  • Deployed and maintained an effective project management process on Confidential Project Server 2003 and Confidential SharePoint 2003 and trained existing and new employees in effective use of the same.
  • Negotiated and managed vendor and software purchase contracts. Directly trained Six Sigma Black Belts in project management and tracking techniques. Managed smooth operations of production and mission critical systems.
  • Managed the implementation of XPEDION Platform using G-Log software a J2EE and Oracle based system.
  • ETL Architecture lead and implemented using ERWIN on Oracle and SQL Server databases
  • Technical and business SME for business applications, Global Data Hub design and Architecture
  • Introduced Siebel Analytics development and deployment of reports and dashboards
  • Successfully developed and implemented a dual global portal in Oracle 10g, merging and converting an acquired company’s systems with systems previously in Oracle 9i.
  • Successfully developed and implemented IT Request System: A complete IT solution to project management, prioritizing and tracking system reducing project count from 700 projects to a manageable 50, in less than three months.
  • Rebuilt and restructured a deteriorating vendor relationship affecting a major strategic and global IT project.
  • Developed best practices, techniques, and tools for project planning, execution, project management, ongoing milestone/deliverable tracking, communication, and key performance metrics.
  • CRM: Developed all internal and external IT communications tools and processes.
  • Managed system performance and automated tools testing team.
  • Oversight and management of the design, development, deployment and operational phases of complex business critical and high availability solutions.

Confidential, Philadelphia, PA

Director IT and Business Systems

Responsibilities:

  • Recruited to calm chaotic Property and Casualty IT development department in disarray due to 200-project backlog. Determined technology solutions in line with business needs and corporate long-term strategy.
  • Managed all aspects of disability management clinical cost management platform, HIPAA Compliance reporting, including management and development of application developer staff.
  • SME for healthcare bill review platform in J2EE environment
  • Executed P&L management of healthcare bill review platform, including budget planning, project and systems recommendations
  • Mainframe Legacy Applications and Data maintenance using Cobol, CICS, PL/1. Data on VSAM and DB2 databases
  • ETL, EDI, Data Warehouse and Reporting Architecture design using ERWIN and deployment
  • Successfully merged 2 bill review applications into single, unified application in J2EE, lowering costs by 50%.
  • Assumed project management of failing project <25% complete despite being in development for over 30 months. Brought project to 75% completion level within 3 months.
  • Initiated restructuring of new project management and prioritization process.

Hire Now