SUMMARY:

• Program Management and Knowledge Management
• Data Modeling Conceptual/Logical/Physical (Power Designer/Erwin/ER - Studio/Embarcadero)
• Development Environments: Agile and Waterfall. Scrum Master Certified (CSM) - Team Foundation Server
• Business Analysis; QA, documentation and streamlining processes to improve productivity
• Key focus areas: Data Governance, MDM, Metadata Management and Data Modeling; Data Conversion/Integration; Enterprise Security; Data Analytics and Business Intelligence, Quality Assurance.

TECHNICAL SKILLS:

Operating Systems: IBM z-Series, IBM 3090 and MQ Series, 4341, z/OS, OS/390, 370, 360; MVS/XA or ESAAnd Hardware: Windows XP/ME/2000/98/95, NT and UNIX

Languages: Java, C#, C, PL/SQL, SQL, VB.net/VB 6/5; ADO& ASP.net COBOL/COBOLII; X/HTML, XML, HTML, Java Script, VB Script, JSON, MySQL, JQuery, AJAX

Software: Rational Software Architect(RSA), Rational Functional Tester (RFT), Visual; Confidential Quality Center, Studio 2008/5/3, MS Project 2000, Power Designer, MS Office, Developer 2000Tools: HL7 EDI Protocol, BRIO, Clear Quest, Clear Case, Cognos, CICS, Crystal Reports, Designer 11i, ERWIN, IE, IIS, Changeman, Endeavor, Xpediter, InterTest, TSO, ISPF, Excelerator, Lotus Notes, QMF, SMUII, SMP/E, ACF/VTAM, ISOTRAIN, Maximo, OA/OOD, OMEGAMON, Trackwise, SQL/LIMS, CFR Part 11,, FrontPage, Dream Weaver, Mercury, Omegamon, MULTSESS, SPUFI, SQL*PLUS, Toad, Golden, Requisite Pro, SOA, SCRUM, UltraEdit, VISIO, TOGAF, WebSphere, XML Spy, BOI, MicroStrategy, TIBCO, Oracle Express, Toad for Oracle/DB2; ER Studio, Solution Architect; QlikView, WebEx; Sharepoint, Skype; Confluence; Team Foundation Server; REST API ; REGEX; Splunk, Hibernate

Databases: Oracle 12/11/10G/9i/8i/7; SQL Server 2000/3/5/7/8/10/12/14 , DB2 UDB9, ACCESS, IMS.DB/DC, Datacom DB, IDMS, Informatica, Netezza (appliance); Metadata Manager; Cassandra; Hbase, Hive,R ; MongoDB NOSQL

PROFESSIONAL EXPERIENCE:

Confidential

Knowledge Manager/Enterprise Data Architect

Responsibilities:

• Enterprise Wide MDM Solution, Design of Strategic Architectural Design Options to implement a SAS 9 MDM solution. Data Analysis, Data Mining, LIMS (Neomate/Specimen Gate), and CARES/PAIS HL7 / Confidential protocols followed for clinical data. (Medicare/Medicaid) DB Analysis/Data Analysis for the Confidential Systems and EFIS/GIS for Environmental side of the house.
• Metadata and Reference Data Management; Data Integration review/planning.
• Data Security: roles, access, PII, encryption/masking strategy and recommendation aligned with business process,
• Developed metrics to assess SLA performance and MDM improvement.
• Performed Vendor Product Review and created PowerPoint presentation of Architectural options for C-level executives.
• Conceptual/Logical Data modeling was performed to assist in discussions with SMEs during Requirements Gathering efforts.
• Documented/Reviewed Business Processes for Clinical applications as they related to MDM data requirements.
• Reviewed/Created Functional Requirements for the MDM Domains and directed staff in profiling and gap analysis
• Reviewed/Created Documentation for ILM content Gaps (creation, receipt, distribution, maintenance or disposition of data).

Confidential

Enterprise Data Architect/Data Modeler

Responsibilities:

• Logical and Physical Data Modeling ERWIN 9.5 for (SAP IQ) Sybase IQ; index recommendations based on Subject Area usage of Business User needs and Hyperion analysis of both Canadian and U.S. usage of reports.
• Business Objects/Universe Design - analysis of Hyperion Reports and their new fields/tables for input into the subject area data model as a result of merger activity and re-branding in a SQL/Server environment. Maintenance of SharePoint documents - in EXCEL containing View Analysis from DB Artisan and Data Provisioning progress from Sybase ASE to Sybase IQ. Coordinated with IBM’s DBA in Houston to ensure data availability.
• Daily scrum with entire team and BI Reporting Teams.
• Provided data provisioning updates and outstanding issues that affected the team. Webi, JSON; Efficiency aided via links to Sharepoint.

Confidential, Chicago, IL

Principal Data Architect /Data Modeler

Responsibilities:

• Led Data and Process Governance discovery efforts for development of Loss, Claims, Finance & Account Managements’ multi-dimensional vision, strategy, and roadmap. Provided WBS for individual project components.
• Provided project tasking and timeline in MS Project, sequencing tasks by priority and allocated resources to the tasks.
• Provided weekly report to management regarding task completion.
• Scrum Master for off-shore team(s) for Solution architecting and project coordination.
• Created/Reviewed/Coordinated Architectural client deliverable generation by 3 off-shore teams
• Delivered: Strategy, Roadmap and Implementation Plans for DG, Metadata Management and Master Data Management.
• Performed Business Analysis and Documentation gathering.
• Updated on-line data repository with Business Rules for Requirements Traceability by Subject Area business processes to ensure change management impact analysis capability.
• Developed Enterprise CDM and in Power Designer 16.5. HL7 format EDI data.
• PDW training. New data warehouse design in-line with Enterprise Data Strategy (EDS).
• Data integration review/planning, ETL or ELT. Business Rules, Process Flows, BPM, Data Lake research.
• Implementation planning; Data Mart Meetings and Strategy Sessions with SMEs.
• Understanding the data from a data supply chain perspective. WebSphere BPM, ESB.
• Adherence to ILM policies and procedures.
• Information asset management to align information with business process and owner
• Assigned SLAs and generated results oriented metrics to track performance.
• Deliverables reviewed for ILM content and Enterprise Data Strategy (EDS) strategy.

Confidential, NYC

Information/Data Architect/Data Modeler (MDM)/ Scrum Master

Responsibilities:

• End-to-End Project Delivery within budget and timeline.
• Project Initiation/Discovery sessions conducted with on-site staff to understand business drivers, pain points, scope of the project, conceptual and logical understanding of business processes.
• Performed Requirements Analysis and MDM Design: determined data ownership, CRUD management and data stewardship for data correction and decision management for golden record/single-point of truth from disparate source systems (customer).
• Conducted daily Scrum (stand-up) with staff to determine progress, next steps and any problems requiring resolution.
• Conducted weekly or bi-weekly meeting to show progress or proof-of-concept to the client.
• Collaborative GoToMeeting/Web-ex work sessions conducted with staff, weekly status meeting for progress on timelines.
• Collaboration with SMEs to determine Business Rules (BR).
• Planning and scheduling of project tasks and activities in accordance with client priorities.
• Ensured open communications with on and off-shore staff to ensure timely Solution Development.
• Led Data Analysis efforts to ensure: completeness, conformity, consistency, integrity, accuracy and de-duplication of data.
• Baseline Data Profiling metrics/results provided to establish the level of Data Quality
• Collaborated with SME to derive Business Rules for DQ improvement; communicated all changes to the team via Sharepoint and email to ensure receipt of all changes in a timely manner
• Metrics generated to demonstrate improvement from current state; process improvement.
• Generated business rules to: track the number and severity of changes made to data via scoring; parse, cleanse and transform data to a standard format; validate and verify data values using both internal reference and third-party data; and establish match/merge rules of survivorship in the MDM solution.
• Developed the Source, Logical and Master Data Models for the solution. Project delivered on-time and under budget.
• Developed customized training material and trained customer in the usage of the MDC/DQC toolsets, ETL/QA scripting. iWay product line included HL7 protocols for Confidential.

Confidential, Detroit

DW Data Architect/Analyst/Metadata Manager

Responsibilities:

• Database Design/Analysis, Metadata Management and Process Review; - DW Data Architect/Data Management Supporting Single-Source of Truth MDM efforts through data analysis/profiling 14TB Teradata
• Business Analysis and Data Analysis in support of Marketing Analytics and Sales
• Performed source to target data mapping and metadata management.
• Business Rule validation/verification of inconsistencies; such as allowed values, data layouts for flat files etc. Collaborated with Business Analysts, DBAs, and the ETL team(s). ETL process review - MDM, Staging, naming, domain usage.
• Performed Informatica data profiling for the entire EDW: Member, Claims, Provider, Pharmacy, Medicare (both Medicare Advantage claims vs. non-Medicare Advantage claims). HL7 protocols for Confidential (Healthcare Information Exchange)
• DW Support for Customer, Member, Medial Claims/Medicare Advantage, Provider, Pharmacy subject areas for EDW (SQL/Server, Oracle, Toad10g, Informatica, ERWIN, Solution Architect, Metadata Manager; BOI, Cognos)

Confidential, Columbia

Enterprise Data Architect/Data Modeler

Responsibilities:

• Team participant in the development of the Enterprise Architecture Roadmap
• Reverse Engineering of Existing Physical data models (ERWIN/Postgres SQL/ER Studio) to modify existing data models and to collect metadata for the metadata repository.
• Developed PII VB solution for identification of non-PII and Suspect PII and subsequent verification with SMEs to identify elements requiring masking/encryption.
• Vendor evaluation - (Global ID) for Metadata Repository management.
• SharePoint Team Site certified for Team Portal development/management
• Groups supported: CRM, SRM and DW/BI (ESB, PostgreSQL, Sharepoint, WebShere BPM; Oracle 11, Netezza, Qlikview)

Confidential

Business Process Leader/PM

Responsibilities:

• BPL responsible for ensuring on-going operations through usage of agile Scrum methodology, teleconferencing and messaging to coordinate activities of the team with other cross-functional areas distributed nationwide. BPM. Confidential Tools.

Confidential, Columbia, SC

Conversion Data Modeler/Analyst

Responsibilities:

• Confidential MDM utilized to ensure that the Enterprise Data Dictionary with its Business Rules is consistent across all counties.
• Data analysis, data mapping and translation, ERWIN data model review, SSIS application support, Business rule development, and DQ to ensure Data conversion/translations in accordance with agreed upon business rules.
• Logical data modeling (new tables/data elements as required). SharePoint, WebSphere.
• QA testing to ensure that the ETL of the intermediate databases met the expected result.
• Co-authored In-House procedural manual for business analyst procedures and testing methods. JAD Sessions with client for data gathering and business rule clarification. T-SQL queries and procedures are utilized for testing and data verification. ACCESS and EXCEL are heavily used during analysis. MS SQL Server 2008.

Confidential, Harrisburg, PA

Data Architect/Data Modeler/Data Analyst

Responsibilities:

• Requirements facilitator with stakeholder(s) - Identified and documented: data sources, business rule discovery sessions to determine base and derived data and data relationships (Created: conceptual, logical, and physical data models)
• Scrum certified/Agile team lead and project manager. (CSM)
• Developed CDM, LDM, PDM data models to support both OLTP and DW efforts.
• Broke out multi-use, embedded legacy fields to atomic level.
• Determined data required for strategic decision making (calculations, aggregations).
• Determination of Source of Truth for data, performance measures for data validity, and historical uses for data; and maintenance of enterprise data model with Power Designer.
• Performed data model and DW Data Mart review and presentations.
• ETL performed filtering, aggregation and summary of data for reporting and creation of metrics. WebSphere.
• Separated OLTP data from analytical processing to reduce impact of data analytics on performance; Improved response time for end-user reports through query tuning, indexing and end-user education in best practices.
• Performed capacity planning. Project plans Deliverables created/monitored for Full SDLC with Owner sign-off. Created/modified Business Rules, and disseminated the information to project personnel to ensure everyone is up-to-date with the requirements. Ensured traceability of requirements to test cases and design artifacts (RUP).
• Created functional and non-functional specifications from systems design to development of the modules.
• Created, documented and executed test plans (manual/automated) for QA of business rules and deliverables.
• Created and provided training and technical documentation for both on and off-site personnel
• Implemented User Interface during Legacy re-write of IMS/CICS and DB2 to J2EE/.Net framework utilizing Oracle and SQL Server databases (Web Service) and DB2 batch interfaces to legacy system
• Confidential /BMS Release Management. Management decision support included the creation of white papers on emerging technology. Pivot tables, cubes, dimensional data models and forecasting (predictive analytics) and performance metrics (Hyperion/Cognos/Excel) Oracle Data Model creation (conceptual/ logical/ physical)
• Web Project Management utilizing modified SCRUM, Performed a heavy amount of QA with 98-99% accuracy. Wrote PL/SQL and T-SQL triggers and scripts. Created testing scripts. Created procedures/operational documentation for usage of scripts.
• Utilized IBM Rational toolset (RSA, Requisite Pro, Clear Case, Clear Quest, WebSphere, Business Objects, Financial Reporting, J2EE, Oracle 10G, DB2 UDB9, SQL/Server 2005/8/10, MQ, SOA), TOAD, Crystal Reports Training. Microstrategy)

Confidential

Database Analyst/Modeler

Responsibilities:

• Review and approval of Logical/Physical Database Design in accordance with DG standards
• (EDW; OLAP, OLTP; Data Governance, MDM standards. HIPAA, SOX, Intranet/Portal Tools: AppSight, ERWIN, .NET 2008, Visual Studio 2008, SQL/Server 2008, Oracle 11, DB2 UDB9, XML/Spy, ERWIN, Excel and VB Scripting).
• Maintained metadata for data re-engineering/cleansing and evaluated data models (normalization, PK and FK)
• Data Dictionary creation and maintenance.
• Zachman framework principles to ensure scope is within enterprise context top-down conceptually and bottom-up with regard to data profiling to ensure domain values are complete, consistent for data quality and mapping.
• REVENUE - Created County Collection System (XML Schema). Financial Reporting. (DB29, Oracle 11, Java, MQ, SQL/Server 2008, Xml/Spy, SOA, DAMA/Scrum, Erwin Cognos).

Confidential

Oracle Data Modeler/Analyst

Responsibilities:

• Managed large DB migration: all database changes, triggers and stored procedures (T-SQL, PL/SQL, SQL), and batch programs from Dev. to system test and production. Maintained IS Training DB; Database Design/Analysis/Testing. QA Testing scripts. Operations scripts. Documented all scripts. QA of all Contract/Vendor deliverables.
• Performed conceptual, logical and physical database modeling and generated the DDL using Power Designer. Developed and maintained web sites for Contract Management System for statewide bid and response tracking (Heavy DBA work/QA); upgraded invoicing sub-system to migrate to Windows XP/MTS platform; wrote Visual Basic procedural Interface between Lotus Notes and DB2.
• Query performance tuning to resolve production resource issues; online and batch maintenance including but not limited to use of: Oracle, DB2, VB, COBOL, ASP, Java Script, VB Script, Lotus Notes, application security, Power Designer, PL/SQL and Sybase Info-Maker, Info Sphere, IBM Crystal Reports and Business Objects.
• Documented DB administration procedures for In-House use of Power Designer for routine data base administration tasks; including DB2 mainframe requirements. SAP Interface. PL/SQL and T-SQL script development.

Confidential

.NET Developer

Responsibilities:

• Analysis and development of WIC Store Application on SQL/Server 2003. IIS, ERWIN.
• Coordinated and interfaced with cross-departmental staff; Vendor and contract management.
• Performed Vendor review and recommendation:
• Budget generated for software and hardware solution(s) with GSA comparison, ROI, justification for 5 Year Plan/budget.
• Completed Microsoft NET course track and SQL/Server Database Administration coursework. (Intellimark)

Confidential, Marietta, PA

Sr. Engineer/ Oracle Data Modeler

Responsibilities:

• Functional requirements and data model for the document tracking system, consolidating departmental into plant-wide tracking. (Hyperion-BRIO, Oracle Financials, SCADA, Power Designer, SAP,UNIX) Performed database installation, creation, monitoring and backup recovery utilizing Oracle 8i, for 24X7 SCADA, and Intranet development systems reducing response time 1 hour to 60 seconds. Scripting and documentation.
• Budget and Resource management to accomplish training of site-wide IS courses; Schedule PM training.
• Vendor evaluation/selection and delivery in accordance with protocols, policy and RFP.
• SOP update and review for all SCADA systems and Oracle DB administration facilitated cross-training of personnel.
• Created Vendor protocol validation criteria for the SCADA system to meet sustainable compliance goals.
• Collaborated with Human Resources to create and implement a security procedure to deactivate or add new users implementing Novell Administration protocols increasing site security measures.
• Developed Intranet site for Plant-wide use with links to Corporate Web site
• Oracle Financials SAP support; Sarbanes Oxley

Confidential, York, PA

Systems Analyst (Oracle)

Responsibilities:

• Developed an online programming package for the cigarette program in Developer 2000, Designer 11i, Crystal Reports, VB, and Oracle Forms/Reports.
• Reducing redundancy, error and operating cost by API development and PL/SQL.
• Converted existing database to Oracle database structure; ERWIN
• Utilized SQL/Loader, performance tuning and APS. Legacy re-engineering. IMS to Oracle. Performed online/batch conversion and SIT/SAT. Team Lead; project coordinator for SIT/SAT problem resolution for application/database issues (18 months).
• SAP: Logistics; Financials; Materials Management.

Confidential

Project Manager/DB Consultant

Responsibilities:

• Analyzed and converted the AllFirst statement system for Dauphin Deposit merger.
• Managed: Unit Testing, QA, UAT, SIT/SAT, Mock1&2, and conversion turnover DB2 to Oracle

Confidential

Database Consultant

Responsibilities:

• Responsible for Oracle PL/SQL for Cornell Forecasting System; scripting/documentation.. Initial data warehousing efforts.