We provide IT Staff Augmentation Services!

Data & Data Warehouse Architect Resume

5.00/5 (Submit Your Rating)

NJ

PROFESSIONAL SUMMARY:

Performance - driven leader and Data Warehouse Architect with experience implementing Best Practices in Data Modeling, Architecture, Data Quality and Data Profiling with strong client needs assessment talents. A leader with mentoring capabilities for Data and Data Warehouse Architects, Data Modelers reinforcing a culture of treating data as an asset within the business, and for developing and embedding processes and controls for the data managed in the organization. Worked as IT Professional since 1985; Atalanta/Sosnoff, Prudential, Fleet Credit Card, Credit Suisse, Chubb Insurance, CitiGroup and JP Morgan Chase, MF Global, AIG and Confidential .

PROFESSIONAL EXPERIENCE:

Confidential, NJ

Data & Data Warehouse Architect

  • Help define and assume a leadership role in the Confidential Data CoE, as well as rationalization and road mapping of the current infrastructure footprint through business and technical analysis to efficiently organize, structure, cleanse and optimize both the infrastructure (cloud) footprint and delivery capabilities.
  • Develop a comprehensive roadmap to re-architecting existing data silos and transform data to accessible information via the use of BI and Big Data technologies.
  • Initiate/deliver technology evaluations, recommendations, and solutions in the Data/Infrastructure domains.
  • Evaluation of products for Secure Messaging and Visualization tools (Qlikview, Tableau, Birst, etc).
  • Tableau implementation and POC (Work-In-Progress)
  • Lead the technical effort to define the corporate data model, master data using MDS.
  • Participate in strategy development for new Data & Information products.
  • Work with a vendor as a lead architect for development of applications design.
  • Establish protocols, guidelines, and governance for best practices Data Governance.
  • Define and implement core data services.

Confidential, NJ

Lead Data Warehouse Architect/Data Architect

  • As a Lead Data Warehouse Architect,
  • Defined a data warehouse solutions for Operational Risk.
  • Translated operational requests into programming and data criteria and conduct systems and operational research in order to model results.
  • Developed a project plan for various subject areas of Operational Risk.
  • Designed a Data Mart Matrix and initiated the Data Mart Data Model for the Data Warehouse.

Confidential, NY

Senior Data Warehouse/Data Architect

  • As a Senior Data Warehouse Architect,
  • Worked with Data Stewardship team to define Master Data, Reference Data, KPIs, and perform data analysis, data profiling, data classification (demographic, financial, PII, etc.).
  • Worked with Data Governance team reconciling metadata, Logical and Physical Data Models.
  • Data Integration in HDFS for Data Lake in Azure environment.
  • Identified analytical reports for Investigation Services, Investments, PFS, Retirement Services, AUMs, participants, advisors activities & events, etc. using Qlikview.
  • Reduced redundancy of ad-hoc reports, and eliminated excel spreadsheets.
  • Provided analytical platform through Data Lake to support reporting of Insurance Fraud Detection, 401(k) Participant Terminations, 401(k) Plans-At-Risk, and High Income/Low Balance Clients and Prospects.

Confidential, NY

Manager, Data Architecture/Data Modeling

  • As a Manager, Data Architect and Data Modeling,
  • Recruited Data Modelers, Architects and SMEs; managed a team of 20-25.
  • Facilitated Data Governance committee; built relationships across senior management and key stakeholders to gain buy in and support for the Data Governance initiative Work with SMEs and Data Stewards for defining business rules for Data Quality & Profiling.
  • Defined the scope and priorities for developing, deploying and/or improving data management standards, policies, and processes to enhance the quality and completeness of the organization’s data.
  • Acted as business lead and SME for projects and programs which drive improvements in the data stewardship capabilities.
  • Eliminated needs for additional contractors by organizing work streams between team members.
  • Reduced workload for Data Architects/Modelers by implementing best practice, standards, and policies.
  • Restructured Business requirements to development process, including Data Architecture/Data Modeling.
  • Improved Data Quality by implementing Information Analyzer.
  • Spread awareness for Metadata by implementing Business Glossary and Metadata Workbench.
  • Initiated and implemented Reference Data Management.

Confidential, NY

Associate Director, DWBI Principal Architect & Technology Lead

  • As an Associate Director, collaborated closely with the Global teams to develop proposals, presentations, and SOWs. Played an advisory role to customers and prospects. Provided thought leadership & recommendations in various technology areas, analytics & Information Management spectrum. Worked with the identified key alliance partners and software vendors for evaluation of products and exploring opportunities for developing business.

Confidential, NY

BIDW Practice Lead

  • As a Practice Lead, engaged as a point person to work with the Data Managers to lead engagements in the areas of Data Warehouse strategy, Data Governance, Data Quality, and Data Analytics. Worked with Account/Sales teams to manage the pre-sales process with clients and provided the leadership throughout the sales-cycle from initial qualification to closure of the deal. Ensured effective deployment of business functional specific metadata.
  • As a Technology Lead, managed development and delivery of Business Intelligence Architects and Business Intelligence Engineers. Conducted gap analysis comparing the current and future state, assessing current client programs, carrying out research and data collection, interviewing client's employees, management team and other stakeholders. Defined scope, expectations, and project estimates, architecture designs including data models.

We'd love your feedback!