OBJECTIVE

Data Modeler

SUMMARY

Possesses over fifteen 15 years of as data modeler, data architect, business analyst, and other technology roles. Worked Wall Street, Silicon Valley, and global workplace for twelve 12 Fortune 500 and five 5 Dow 30 companies, including household names as, IBM, Cisco, AT T, AIG, Visa, Chase, Bank of America, Deutsche Bank, and Coach. Appointed Treasurer and Board Member of Data Administration and Management Association DAMA .

PROFESSIONAL EXPERIENCE

Confidential

As Consultant

• Assigned to company listed following. See related company entry in bio.
• MassMutual
• Cigna Health Insurance
• Frontier Communications
• Schneider National, Inc. SNI
• Tyco SimplexGrinnell
• DIRECTV

Confidential

• From the MassMutual Retirement Services Tech Strategy, formed a Data Strategy that includes policies, standards, and procedures for a Data Management Program DMPgm managed by a Data Management Office DMO patterned after the Project Management Office PMO mode. The DMPgm and DMO covers policies for Data Architecture Management, Data Development, Database Operations Management, Data Security Management, Reference and Master Data Management, Data Warehousing and Business Intelligence Management, Document and Content Management, Meta-Data Management, Data Quality Management, and Data Governance.. Scope of review includes technologies in SAP, Informatica and Metadata Manager, Teradata and Financial Services Logical Data Model FSLDM , Oracle, OBIEE CRM, DB2, and, SQL Server.
• Created plans, timelines, statement of work, technical questions, and use cases from business requirements for Proof of Concept, Pilot of Data Strategy, Data Management, Data Lineage, and Data Governance initiatives, programs, and projects
• Reviewed and evaluated data mapping and data modeling processes for feasibility, revamp, and process improvement
• Reviewed Informatica PowerCenter 9.0, 9.1., 9.5, and 9.6 versions, and recommended and implemented a Proof of Concept POC with Metadata Manager in collaboration with Informatica consultants as solution to interrelate enterprise Executive Leadership Initiative, Business Architecture, Business Model, Tech Strategy, Data Dictionary, Teradata Financial Services Logical Data Model FSLDM , ERWIN data models, and Informatica Business Glossaries and Repository objects including data mappings, mapplets, source, target, data integration services.
• Kicked off Data Strategy Pilot by creating ontology structure, and verified traceability using Teradata SQL Assistant, Informatica Power Center and Metadata Manager and SQL Server.
• Used Windows 8.1, Microsoft Office Suite 2013 with MS Excel advanced features including Pivot and Functions, Informatica PowerCenter 9.6 Business Glossary and Repository, Power Designer, CA All Fusion ERWIN 8.2 with Model Mart in Oracle, Teradata 13 SQL Assistant, Oracle 11.2 SQL Developer and PL/SQL, SQL Server, DB2, SharePoint, WebEx, Extended Markup Language XML .

Confidential

• Managed over 30 very large transactional and data warehouse data models and databases of up to 12,000 entities and tables and 110,000 attributes and columns and collaborated with enterprise data architecture of up to 250,000 entities and tables and 3.1 million attributes and columns., including, created audit triggers in conjunction with referential integrity and cascade rule actions.
• Collected and reported data asset and data model inventory, and determined that the scope of responsibility.
• Analyzed, collaborated, and implemented with managers, enterprise data architects, DBAs, analysts, and developers, and approved service request changes to Cigna and Intracorp Healthcare Integrated Care Management System ICMS and other data models and databases on application projects, such as, Health Insurance Exchange HIX , Diagnosis Related Groups DRG standards upgrades from International Classification of Disease Version 10 ICD-10 , Medicare, NY-DRG, NJ-DRG, WA-DRG, Milliman, and APR, Health Information Health Insurance Portability and Accountability Act HIPAA compliance, Winstrat to 3M Coding and Reimbursement System CRS replacement, and, Value Based Compensation and Reimbursement VBCR .
• Gathered records and documentation of historical changes to data models and data bases of past 20 years.
• Modified canned ERWIN reports using SAP Crystal Reports and Toad for Oracle to produce data dictionary and customized data model reports to publish in SharePoint as ready reference for managers, analysts, and application developers.
• Reverse-engineered Oracle and DB2 DBs and forward-engineered changes from service request tickets.
• Recovered and restored ERWUB Model Mart data models from software corruption
• Attended training and complied with HIPAA laws and guidelines
• Utilized MS Project, Microsoft Office Suite 2013, MS Outlook, MS Visio, MS Excel advanced features including Pivot and functions, and MS Word with macros, MS PowerPoint, CA All Fusion ERWIN 8.2 with Model Mart in Oracle, Oracle 11g, SQL Developer, PL/SQL with GROUP BY and SUBSELECT, SQL Plus, Quest Software Toad for Oracle Professional 10.1, SQL Server 2012 with T-SQL, SSAS, SSIS, SSRS, Data Quality Services DQS , and IBM DB2, SAP Crystal Reports 2011, SharePoint, WebEx, Extended Markup Language XML , LDAP, Lync 2010, HP Service Manager, Clarity timekeeper, PeopleSoft timekeeper

Confidential

• Reverse-engineered and analyzed current code and scripts for current state, designed future state of data requirements, and forward-engineered conceptual data models into logical, physical, and database tables and columns and XML WSDL data definitions.
• Led data modeling team in assessing work load, timeline, and deliverables. Also, gathered requirements and defined new tables and columns required to accommodate new use cases, methods, and processes.
• Collaborated and negotiated with concurrent development projects and initiatives.
• Coordinated with managers, recruiters, and contractor vendors on talent acquisition and onboarding requirements.
• Researched and prepared basic Android mobile device application development platform using Java and Eclipse.
• Apprised VPs and Directors about project plan and timelines, progress, status, and open issues. Situated staff facilities and development environment, such as laptops, desktops, cubicle assignments, desk phones, access to Concurrent Versions System CVS , network ID, LAN connectivity, and integration and system testing environments.
• Used ERWIN, MS Project, MS Visio, MS Office Suite, Java, Comergent Sterling CRM, Salesforce, and Eclipse.

Confidential

• Designed conceptual, logical, and physical data models and designed of Oracle target databases, and applied governance to corporate standards and industry best practices.
• Collaborated with project managers, developers, development team, and account for a several pilot projects as prelude to several years long program of forty 40 application retirement projects from mainframe into Solix managed Oracle databases.
• Managed efforts of and issue resolution in data modeling, data analysis, data migration, data architecture, data quality, and extract-transform-load ETL .
• Advised personnel onsite in WI and offsite in California and India with project, human resource, timesheet, and expense issues and management reports.
• Balanced and reported weekly the burn rate of provisioned contract hours and submitted change requests for more hours to completion.
• Used ERWIN, Oracle SQL Developer, DB Visualizer, SQL Server, MS Office Suite, MS Project, TSO, and other mainframe infrastructure software and tools.

Confidential

• Designed conceptual, logical, and physical data models and designed 2TB DB in SQL Server using fiscal date partitioning scheme across POC, Development, Test, and Production environments.
• Led a subproject under the Mainframe Elimination Customer Order Billing MFE COB project to migrate 400 million records from the mainframe to SQL Server and Oracle databases using Solix EDMS, Informatica, and Crystal Reports, in collaboration with Solix offshore, in-house development, and DBA teams.
• Coordinated and collaborated with a team of developers in a second subproject to migrate MFE COB Daily processes and data into SQL Server archive DB, using Informatica, SSIS, and Toad.
• Collaborated, and implemented the Grinnell Archive solution migrating AS/400 General Ledger chart of accounts, Accounts Receivable, Accounts Payable, Human Resources, and Payroll historical transactional data into SQL Server 2008R2 archive database.
• Designed, modeled, planned, deployed, tuned, and validated Grinnell Archive Solution conceptual data model, logical data model, physical data model, and databases onto local host, Development, Test, and Production environments.
• Used UML XML, Agile, logical, sequence, activity, state, collaboration, and class diagrams, ERWIN, MS Visio, MS Project, MS PowerPoint, MS SQL Server SSIS, DB2, Oracle, TSO/ISPF/JCL, Clarity ePlan

Confidential

• Successfully implemented into Production the Docketing Project for the Legal Department that installs Thomson Reuters Intellectual Property IP Manager as the replacement intellectual property IP software and converts patents, disclosures and trademark data into the IP Manager database. Moreover, the project includes installing and implementing specialized search engine tools from Xpriori that copies, annotates and catalogs relevant Legal Department electronic case materials and documents. Oversaw project managers from DIRECTV that manages the IT Infrastructure preparation of managerial and technical, hardware and software support, and, Thomson Reuters that execute the data conversion. Collaborated with several business units with various IP competencies.
• Successfully implemented into Production the Fraud Management System Countermeasures FMC project that includes an enterprise integration EI programmer via Oracle and Neural Technologies software solutions. FMC automates manual procedures that manage identified fraud subject accounts. This entailed overseeing an analyst programmer and collaborating with other IT hardware and software development teams.
• Wrote high level project definition report PDR document that includes project business objectives, key business assumptions and dependencies, make versus buy questionnaire, current and proposed business process flow, current and proposed system use case, current and proposed collaboration diagram, current and proposed high level design HLD , security impact, business data model, disaster recovery levels, user interface approach, potential systems solutions, data migration approach, test strategy, capital project appropriation, contact list, gap analysis, service level agreements, risk assessment, volume and growth estimates, functional requirements, usability questionnaire, reporting requirements, application interface diagram AID , standards compliance, technical and implementation standards, design approach, data conversion requirements, data retention requirements, business partner requirements, and project implementation plans , technical design specification TDS , and collaborated with IT Infrastructure, Thomson Reuters and Xpriori vendors to form a technical architecture diagram TAD . Interviewed and gathered requirements from business managers, software vendors and users. Completed Planview project portfolio requirements and documentation.
• Reverse-engineered and documented data models of Thomson Reuters IP Manager, PATS application, CPI, and other intellectual property databases.
• Wrote Crystal Reports Development Guide to assist the business in designing reports.
• Used UML XML, Agile, logical, sequence, activity, state, collaboration, and class diagrams, Crystal Reports 2008, MS Visio, MS Project, MS SQL Server 2005, Clarity ePlan, Planview Project Portfolio Management, Thomson Reuters IP Manager 2.1, Xpriori XCM, ERWIN 7.3, and Embarcadero ER/Studio 8.0.3.0.
• Confidential
• Designed data architecture for the Intelligence Creation and Distribution ICD data store and information flow.
• Implemented IntelliShield development program and projects for acquisition transition and integration into corporate standards, procedures and governance.
• Applied Six Sigma DMAIC and continuous process improvement CPI principles to fine-tune enterprise business processes and save millions of dollars in manual processing, software licensing and development costs.
• Designed data architecture for the Intelligence Creation and Distribution ICD data store and information flow.
• Wrote business requirements documentation BRD and functional specifications documentation FSD for the Cisco Security Center CSC program and projects, successfully released to public at RSA Conference.
• Used UML XML, Agile, logical, sequence, activity, state, collaboration, and class diagrams, MS Visio, MS Project, MS SQL Server 2005, MS Access, Clarity, Planview Project Portfolio Management, and ERWIN 7.3

Confidential

• Designed Program Management Office PMO process in collaboration with the CIO, SVP, VPs, and business analysts, which manages portfolios, programs, and projects from proposal, SOW, charter, prioritization, approval, budgeting, initiation, planning, execution, monitoring, closure, and project review.
• Implemented the Enterprise Data Model EDM of CTSC as a third party tax service startup. As CTSC prepares to be spun off in 2 years, designed the EDM to support the future CTSC business model and held JAD sessions with the President, CIO and top management. With the EDM split up into several subject areas, managed the Agency, Customer, Service Master, Delinquency, Procurement and Property Database Subject Areas with three people in the Logical Data Model LDM team: a subject matter expert SME and 2 system analysts. Wrote business process flowcharts, use cases, activity, state and lifecycle diagrams, using UML and Visio.
• Designed Program Management Office PMO process in collaboration with the CIO, VPs, and business analysts, which manages portfolios, programs, and projects from proposal, SOW, charter, prioritization, approval, budgeting, initiation, planning, execution, monitoring, closure, and project review.
• Implemented Business Intelligence solutions via the integrated company portal. This includes an Executive Dashboard of company performance metrics in online, real-time graphs and reports, Financials Data Warehouse, System Performance Data Warehouse, Database Management Data Warehouse and Data Model Data Warehouse. Used SQL Server Reporting Services, Analysis Services and Data Transformation Services, Share Point Services, FrontPage, Excel and ERWIN.
• Audit databases and data models for compliance to approved controls, standards and procedures.
• While implementing the Enterprise Architecture framework, as the Enterprise Data Architecture governor and member of the Architecture Design Board ADB and Architecture Review Board ARB , wrote up and enforced Data Architecture Standards Checklist, Reference Guide and CTSC Data Architecture documents. Provided data modeling, business analysis, database administration and business process modeling expertise to development projects and managers. Wrote and designed contextual models, conceptual models, semantic data models, logical data models, physical data models, as well as installed databases over several applications such as National Directory Repository NDR , Tax Sale Tracking TST , Tax Exception Processing TSEUP , Tax Bill Tracking TBT , Application Management System AMS , and other projects.
• Designed, implemented and published a Portal to display the Enterprise Data Dictionary using ERWIN, Microsoft SQL Server Reporting Services, Microsoft Share Point Services and Microsoft .NET Framework Visual Studio.
• Assisted in the formulation of plan to handle and satisfy Sarbanes-Oxley SOX requirements.
• As SQL Server 2000 Application Database Administrator DBA , created tables, performed DB maintenance, and fixed database program bugs.
• Used UML, XML, Agile, Zachman, Microsoft Data Architecture, Gartner Research and Troux Enterprise Architecture frameworks, All Fusion ERWIN data modeling tool, FASTER/SE like Six Sigma methodology, SQL Server Enterprise Manager, SQL Analyzer, TRANSACT-SQL and Reporting Services, AS/400 DB2 UDB, VISIO, Visual Studio, VSS, HTML in a .NET and Visual C environment, Lotus Notes Domino