OBJECTIVE

Data Architect

SUMMARY

Possesses over fifteen 15 years of as Data Architect, Data Modeler, Business Analyst, and other roles. Worked in Wall Street, Silicon Valley, and global workplace for twelve 12 Fortune 500 and five 5 Dow 30 companies, including IBM, Cisco, AT T, MassMutual, Cigna, AIG, Visa, Chase, Bank of America, Deutsche Bank, and Coach.

PROFESSIONAL EXPERIENCE

Confidential

Data Architect

As Employee

Developed business plans, forecasted cash flow and return on investment schedules, traveled and researched in overseas to collaborate and interview business partners and vendors, and granted pro-bono consulting to nonprofits across USA, Europe, Asia, and Africa.

As Consultant

Confidential as Data Architect, Data Strategist

• 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 model. 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 SOW , 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 , as Data Architect

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. Attended training and complied with HIPAA laws and guidelines. Used Microsoft Office Suite 2013, CA All Fusion ERWIN 8.2 with Model Mart in Oracle, Oracle 11.2, SQL Developer, PL/SQL with GROUP BY and SUBSELECT, SQL Plus, Quest Software Toad for Oracle Professional 10.1, IBM DB2, SAP Crystal Reports 2011, SharePoint, WebEx, and MS Excel advanced features including Pivot and functions, Extended Markup Language XML , LDAP, Lync 2010, HP Service Manager, Clarity timekeeper, PeopleSoft timekeeper.

Confidential , as Data Architect

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. 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. Collaborated and negotiated with concurrent development projects and initiatives. Coordinated with managers, recruiters, and contractor vendors on talent acquisition and onboarding requirements. Used ERWIN, MS Project, MS Visio, MS Office Suite, Java, Comergent Sterling CRM, Salesforce, and Eclipse.

Confidential , as Data Architect, Solutions Architect

Designed and implemented conceptual, logical, and physical data models and designed of Oracle target databases, and applied governance to corporate standards and industry best practices. Managed efforts of and issue resolution in data modeling, data analysis, data migration, data architecture, data quality, and extract-transform-load ETL . Integrated, conformed, and cleansed data from over forty data sources from Oracle, SQL Server, DB2, Teradata, VSAM, ISAM, sequential flat files, GDG, obsolete software databases via a portfolio of forty projects and programs to target databases for archival, data warehousing, and business intelligence. Balanced and reported weekly the burn rate of provisioned contract hours and submitted change requests for more hours to completion. Reverse-engineered via ETL tools such as Informatica, SQL SSIS, mainframe extraction and reporting tools and utilities, obsolescent software database management utilities, and, Oracle, Siebel, and Teradata utilities. the DB2, VSAM, ISAM, and COBOL copybooks and other legacy data structures, and consequently define data model and data mapping for archival, data warehouse, and business intelligence databases. Executed ETL procedures to migrate data sources into flat files, Oracle, and SQL Server databases fir archival, data warehouse, and business intelligence databases. Designed data analysis, data warehouse, and business intelligence star and snowflake data models and databases. Used ERWIN, Oracle SQL Developer, DB Visualizer, SQL Server, MS Office Suite, MS Project, Informatica, TSO, and other mainframe infrastructure software and tools.

Confidential as Data architect, Solutions Architect

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. As SQL Server Architect, 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. Reverse-engineered via ETL tools such as Informatica, SQL SSIS, mainframe extraction and reporting tools and utilities, obsolescent software database management utilities, and, Oracle, Siebel, and Teradata utilities. the DB2, VSAM, ISAM, and COBOL copybooks and other legacy data structures, and consequently define data model and data mapping for archival, data warehouse, and business intelligence databases. Executed ETL procedures to migrate data sources into flat files, Oracle, and SQL Server databases fir archival, data warehouse, and business intelligence databases. Designed data analysis, data warehouse, and business intelligence star and snowflake data models and databases for Cognos analysis. Integrated, conformed, and cleansed data from data sources from SQL Server, DB2, Teradata, GDG, VSAM, ISAM, and flat files to target databases for archival, data warehousing, and business intelligence. Used UML logical, sequence, activity, state, collaboration, and class diagrams, MS Visio, MS Project, MS PowerPoint, MS SQL Server SSIS, Informatica, DB2, Oracle, TSO/ISPF/JCL, Clarity ePlan.

Confidential as Data Architect

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. Designed data analysis, data warehouse, and business intelligence star and snowflake data models and databases for Cognos analysis. Integrated, conformed, and cleansed data from data sources of SQL Server, MS Access, obsolete software databases, and flat files to target databases for archival, data warehousing, and business intelligence. Used UML 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.

Confidential, as Data Architect, Business Process Architect

• Designed data architecture for the Intelligence Creation and Distribution ICD data store and information flow. 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. 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.
• Designed data architecture for the Intelligence Creation and Distribution ICD data store and information flow.
• Used UML 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 as Enterprise Data Architect, Data Strategist

• 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 and maintained 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, 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.
• Designed data analysis, data warehouse, and business intelligence star and snowflake data models and databases for Cognos analysis and SharePoint publication.
• Used UML, 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.