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. Confidential MDM AE, Confidential MQ, 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 SKILLS:

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, LAMPBusiness 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 Cubes

SAP 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

Ecommerce: Various implementations including Confidential Ecommerce

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 (Contractor)

Responsibilities:

• I'm engaged in hands on development and configuration of the Confidential MDM Collaborate Edition (MDM CE product), Confidential MQ and Confidential Ecommerce Deployments in Linux environments and SOA architecture. Directly engaged in gathering requirements, doing technical design and implementation and also making customized changes to MDM CE and enhancements to the product catalogue, API integrations that call into and out of various theme park applications, supporting both coasts and data centers. I'm also configuring MDM CE and MQ environments to support Confidential 's products that then integrate to a Web sphere Commerce product catalogue.

Confidential, Farmington, CT

Sr Business Intelligence, BI, ETL, Capacity Planning and Data Architect (Contractor)

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 (Contractor)

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 and SOA 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 (Contractor)

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

Sr. Solutions Architect (Contractor)

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

Confidential

Sr. Informatica Architect (Contractor)

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
• 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 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 (Contractor)

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 (Contractor)

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

Confidential

Sr. Application/SharePoint 2010 Architect (Contractor)

Responsibilities:

• 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 (Contractor)

Responsibilities:

• 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 (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 (Contractor)

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 IT and PMO(Contractor)

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 (Contractor)

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.

Confidential, Wyncote, PA

Director of Technology (Contractor)

Responsibilities:

• Managed software process and programmers in delivering projects unit tested to QA, and overhauled QA and test software test processes. Worked with customers to define customer requirements, translate requirements into a statement of work, prepare quotes and, secure contracts. Reported progress and status to CEO and VP of deliveries.
• Maintained 99.99% level of service across platform.
• Process 360: Defined software development life cycle and standards as applied to Confidential and implemented in development environment.
• Software Movement Process: Defined software movement processes and applied to production environment. Slashed failure rate to <5% in 2 months.

Confidential, Mount Laurel, NJ

Senior Technical Manager (Contractor)

Responsibilities:

• Recruited into critical, hands-on data modeler, application and ETL architect, program designer and coder role, responsible for managing teams of up to 50.
• Instrumental to generating over $8MM in revenue through contract negotiations.
• Energy Insurance Mutual: Developed enterprise architecture to implement a new property policy and financial reporting system for excess insurance liability carrier. .
• AIG NY (Reinsurance and Personal Lines Systems): Reengineered mainframe and Java-based loss management system to DB2 data architecture. Reinsurance Systems SME
• MIIX NJ (Medical Malpractice Insurance Systems): Developed new Enterprise Database and Application Architecture to manage Medical Malpractice Policy, Endorsement System, Policy DEC Forms and Reporting Systems using SQL Server Database and ERWIN for Data Modeling, EDI and HIPPA Compliance
• Prudential Insurance Company (Property and Casualty Insurance): Developed credit card and check payment processing systems integrated with COTS products.
• CIGNA P&C Insurance: Built reinsurance policy contract systems; performed Worker’s Compensation Claims feed analysis; designed/built claim data warehouse; and, designed/developed risk management system. Risk management systems SME. All conversion from Mainframe Legacy applications and DB2 and VSAM databases using Cobol, CICS, PL/1

Confidential

Technical Manager

Responsibilities:

• Reengineered and new projects in key business areas: life insurance systems, property and casualty, financial, healthcare and health insurance, policy, risk management and reporting systems, and fee-based worker’s compensation claims.

Environment: Cobol, CICS, SQLDS, DB2, DB2/2, VSAM, CMS, PL/1