We provide IT Staff Augmentation Services!

Principal Data Architect Resume

SUMMARY:

  • To attain a technology - based career within a progressive organization; I prefer an environment that will allow opportunities for growth, education and advancement in my field.
  • I have a Masters in Information Systems and I am an advocate for lifelong learning.
  • My focus is to form systems solutions based on business needs and system/environment abilities and constrictions.

EXPERIENCE:

Confidential

Principal Data Architect

Responsibilities:

  • Lead green field efforts to create a data warehouse solution for existing reporting efforts on the cloud.
  • Apply better integration from multiple sources and data modeling tactics to support intra-day and daily updates to underlying data.
  • Building a data mart that will be functionally fast and apply business logic in a data rebuild/handling process.
  • Retrofit and enhance existing Power BI reports as well as creating new reports.
  • Providing user education and handoff to allow customer to maintain their Power BI instance.

Technologies Used: SQL Server suite, Visual Studio Team Server, Visual Studio, Azure, Azure DW, Azure SQL DB, Data Factory, Power BI, Visio, etc.

Confidential

Principal Data Architect

Responsibilities:

  • Lead green-field efforts to re-establish and application database for MS Startups and Product Offers.
  • Lead initiation and development of a BI data warehouse to house Startup accounts, product and subscription offers and extenuating related data from Marketplace and Hadoop.

Technologies Used: SQL Server suite, Visual Studio Team Server, Visual Studio, Azure, Azure DW, Azure SQL DB, Data Factory, Power BI, Visio, etc.

Confidential

Principal Systems Architect

Responsibilities:

  • Assist in establishing network and systems standards with a focus on evolving the current infrastructure towards a consolidated, scalable, reliable, and cost effective network.
  • Leading roadmap discussions to assist in managerial decision making.
  • Create and maintain automated ETL/ELT via stored procedures in lieu of a purchased solution.
  • Create and maintain a common data lake and mart in SQL Azure for all related enterprise data warehouse needs into a scalable cloud platform.

Technologies Used: SQL Server suite, Visual Studio, Azure, Azure SQL DB, Data Factory, Redshift (AWS), Power BI, Tableau, Visio, etc.

Confidential

Sr. Data Architect

Responsibilities:

  • Assist offshore with Next Generation Volume License User Story details from end users, design and quasi-SQL to assist in development efforts.
  • Remodel the existing data warehouse, apply ETL standards for tolerance and data quality alerts, and source new bedrock data.
  • Create and maintain a common data store in SQL Azure for all related data warehouse information to consolidate resources into a scalable cloud platform setup.
  • Technologies Used: SQL Server suite, Visual Studio, Azure, Azure SQL DB, Data Factory, Power BI, ER Studio, Visio, etc.

Confidential

Sr. Systems Architect

Responsibilities:

  • Outline and develop data warehouse architecture integration and data mart solutions for ad hoc, SAS and Business Object utilization with security focused architecture modeling for HIPPA and SPII restrictions and encryption.
  • Utilize integration and snowflake modeling to support BO and SAS reporting tool suites for all Pharmacy Claims users.
  • Create and maintain mapping spreadsheets, metadata management and data modeling to support productionalization and sourcing of BI data structures for dimensional modeling.

Technologies Used: Teradata, Sybase, Informatica, WhereScape, SQL Server suite, Business Objects, Erwin, Visio, etc.

Confidential

Data Architect

Responsibilities:

  • Create or change needed data elements in a Logical Data Model (LDM) to allow Premier discoverability.
  • Added new taxonomy tables and Taxonomy site update for updated and new master referential data code, descriptions and use cases.
  • Short-term and long-term solution(s) include crosswalk tables to map related Products and enhance the initial effort by making a consolidated list of Products/Services and position Type-2 hierarchy controlled by a fast Governance process.

Technologies Used: Taxonomy site, SQL Server suite, ER Studio, Azure Marketplace, Visio, etc.

Confidential

Data Architect

Responsibilities:

  • Analyze source systems to better assist design and requirement accommodations.
  • Design and develop a new data warehouse solution for finance and product play events to support analytical, statistical and operational reporting.
  • Establish architectural and development methods for new archive operational and analytical standards to assist in residual support of an established DW.
  • Design data vault, 3NF/5NF, denormalization/integration, and star data mart layer DW modeling.
  • Design processes needed for automated reporting that will be maintainable with minimal updates to a reusable process that passes variables from a metadata table.
  • Assist in realigning data warehouse resources (personnel) to adopt new processes and support requirements for operational readiness.
  • Follow TOGAF standards for project and living documentation need to support a new team structure, new and updated processes and support requirements for new and existing IT personnel.

Technologies Used: Hadoop, Hive, MS APS, AWS, HD Insight, SQL Server suite, Power BI, Tableau, ER Studio, Visio, etc.

Confidential

Data Engineer

Responsibilities:

  • Outline and develop data warehouse solutions for reporting integration, sourcing and hosting.
  • Follow and enhance established architectural and development methods with regulatory compliance restrictions utilizing data integration tactics and snowflake modeling in a VIRT (sandbox).
  • Transition existing sourcing methods to sustainable lean performance tuned solutions.
  • Update SQL query and automated extract sourcing of Tier 1 systems and the data warehouse into a Tier 3 sandbox solution.
  • Deprecate Access DB and Excel resources while relocating processing requirements into the new VIRT for automated processing to support routine reporting activities.

Technologies Used: Oracle, DataNet, Redshift (AWS), Access DB, Visio, etc.

Confidential

Sr. Systems Architect

Responsibilities:

  • Analyze and implement performance tuning over long running processes that noticeably affect DW processing.
  • Outline and develop data warehouse architecture integration and data mart solutions for ad hoc, SAS and Business Object utilization with security focused architecture modeling for HIPPA and SPII restrictions and encryption.
  • Utilize integration, canonical and snowflake modeling to support BO and SAS reporting tool suites as well as ad hoc users.
  • Create and maintain mapping spreadsheets, metadata management and data modeling to support productionalization and sourcing of BI data structures for dimensional modeling.
  • Reestablished the domain modeling structure that should be in place for an MPP solution.
  • Establish Architectural “guardrails” to assist new and existing resources to better manage the Health Care Model in an MPP solution and continue development that are performance tuned.
  • Deprecate original DW sourcing on Sybase and Datacom systems to a newer MPP DW platform.

Technologies Used: Teradata, Sybase, Datacom, SQL Server suite, Business Objects, Erwin, Visio, etc.

Confidential

BI Senior Systems Architect

Responsibilities:

  • Awarded the BI System Architect of the Year award for the 2012 calendar year.
  • Integrated security architecture and database user security SME. Outline architecture solutions in projects over BI systems.
  • Create and maintain logical and business conceptual data modeling to support new or additional sourcing into BI systems. Additionally model landing zone, 3NF and integration layers in the DW to support sourcing.
  • Administered metadata and business glossary governance and management.
  • Sandbox governance forum management and sandbox capacity planning. Security focused data verification for compliance in all BI solutions.
  • Investigating and providing solutions for user questions over data lineage, data transformations and ETL processes.
  • Support post-sales operations and supply chain management conversion projects to support business objectives for warranty exchange programs.
  • Create sustainable processes and introduced code reuse for reverse logistics statistical and analytical reporting.

Technologies Used: Teradata, Greenplum, Netezza, Oracle, SQL Server suite, Visual Studio, SAP BW, SAP HANA, SAP PA, Cloudera, AccuRev, Business Objects, Tableau, Erwin, Visio, etc.

Confidential

Senior Systems Analyst & Developer

Responsibilities:

  • Report system modeling and stored procedure creation for XBOX Zune player streaming video content delivery services.
  • Provide ongoing concise BI reporting for data analysis and issue identification.
  • Analyze and form suggestions for data quality issue resolution and capacity planning of streaming video systems.

Technologies Used: Oracle, SQL Server suite, Azure, Dynamics CRM, Product Studio, Project Server, SharePoint Server, Visual Studio, Visio, etc.

Confidential

CRM Engineer and BI Analytics SME

Responsibilities:

  • Talisma CRM support engineer and Talisma Analytics SME.
  • Provide customized analytical reports and campaign workflow solutions to support CRM requirements.
  • Customers advocate leading project management with a focus on business analysis with an emphasis on customer satisfaction and issue resolution.

Technologies Used: Oracle, SQL Server suite, Talisma CRM, SiteScope, Citrix, Visio, etc.

Confidential

Senior Systems Analyst/Developer

Responsibilities:

  • Release support and code troubleshooting with a specialty in identifying and resolving application and website issues.
  • Create and maintain analytics reports to gauge queue response and duration as well as system performance and website uptime.

Technologies Used: Oracle, SQL Server suite, CodeSign site, Visio, etc.

Analyst

Confidential

Responsibilities:

  • Wireless network throughput testing.
  • Network device audit and maintenance.
  • Data warehouse design and development for performance tuning.

Technologies Used: Talisma CRM, MySQL, Visio, etc.

Hire Now