We provide IT Staff Augmentation Services!

Data Architect/technical Program Manager Resume

3.00/5 (Submit Your Rating)

SUMMARY:

  • Data Architect/Modeler with several years of experience in hi - tech, retail, insurance and finance industries.
  • Proven technical and leadership abilities in data warehousing and data management environments, and a passion for data analytics.
  • Extensive qualifications in partnering with business, leadership, and teams to define needs, evaluate risks and issues, and implement architecture, tools, and best practices to enhance decision-making and drive competitive growth.
  • Well versed in presenting to executive staff and at driving cross-functional collaboration across varied organizational sub-cultures, and global teams. Key skills include:
  • Data Modeling Metadata Management Program/Project Management
  • Data Architecture Data Governance Client Engagement
  • Data Warehousing Data Analytics Vendor Management technical Skills

TECHNICAL SKILLS:

Data Modeling: Logical/Physical Data Modeling (LDM/PDM), Dimensional Data ModelingER-Studio, Erwin, Popkins System Architect, Oracle Designer, Visio

Databases: Postgres, Teradata, Oracle, MS SQL Server, SAP Hana, DB2

Data Warehousing/ ETL: Informatica, Ascential DataStage, ODI, SQL*Loader, DTS

Business Intelligence: Business Objects, Siebel Analytics/OBIEE, Tableau

Programming Languages: SQL, PL/SQL, Python, R, VBA, JSON, SAX Basic, Unix Shell ScriptingASP.NET, C#.NET, ASP, HTML, DHTML, XML, XSLT, Java, C, COBOL

WORK EXPERIENCE:

Data Architect/Technical Program Manager

Confidential

Responsibilities:

  • Established data architecture and drove cross-functional collaboration on SAP Hana projects with the various project teams.
  • Improved visibility of the content in Hana, and enabled Hana data models to scale up by documenting data requirements in an integrated logical data model in ER-Studio.
  • Reduced the time spent upfront on map gap analysis by documenting the enterprise bus matrix for business processes and dimensions in Hana, and involving the Teradata subject matter experts in the process.
  • Streamlined data architecture processes with enabling the automated generation of SAP Hana data models from the data models already built for the Teradata data sources in ER-Studio.
  • Optimized efficient use of the Hana platform by ensuring that use cases and Hana artifacts were reviewed, and necessary steps taken to fix any discrepancies.
  • Streamlined existing processes by driving various initiatives such as implementing user security, change management, Hana deployment automation etc.
  • Reduced delays in project deliverables by improving communications between the project, data platforms and Hana operations teams, by establishing an appropriate operating model.
  • Improved awareness of the data platforms and technologies available within Confidential by assessing the needs of each Confidential customer, and conducting customized training sessions.

Metadata Catalog Program Manager

Confidential

Responsibilities:

  • Improved overall productivity in the enterprise data warehouse environment by 40%, by enabling end-to-end data lineage, root cause analysis and a business glossary.

­­­­­­­­­­

  • Enabled self-service, and reduced time spent on impact analysis for changes to the enterprise data warehouse, from three weeks to a day, by driving an enterprise metadata catalog program using Rochade.
  • Increased catalog usability by influencing the vendor product roadmap to enable various customized features such as enabling column-level lineage, and simplifying the gigantic lineage diagrams.
  • Improved user adoption of the metadata catalog by 60%, by educating business and technical users about the catalog, articulating the benefits of a metadata catalog, implementing feedback about catalog usability.
  • Raised the quality of development objects in the metadata sources, by driving cross-functional collaboration and influencing the Data Governance, Data Integration, BI Delivery, and Data Modeling teams.

Sr. Logical Data Modeler

Confidential

Responsibilities:

  • Improved data integrity and reduced redundancy of data in the Enterprise Data Warehouse (EDW), and other non-EDW systems, by building third normal form logical data models using ER-Studio and Erwin.
  • Increased productivity of the modeling team, by 30% by automating several tasks via ER-Studio macros.
  • Enabled data lineage from the Oracle EDW to the Teradata EDW, by building a metadata catalog in Oracle.

Senior Business Systems Analyst/Data Modeler

Confidential

Responsibilities:

  • Lead the initiative to build the first ever Confidential at Confidential, for the Sales organization. The Confidential was implemented in Oracle, and OBIEE was leveraged for the Dashboards.
  • Collected business requirements, conducted source system analysis, built ELT mapping documents.
  • Built Logical/Physical 3NF Data Models, Dimensional Data Models/Star Schemas for the Sales Confidential .

We'd love your feedback!