We provide IT Staff Augmentation Services!

Data Architect Resume

Fairfax, VA

SUMMARY

  • Analytical, technically inclined, and results - oriented professional, wif hands-on leadership experience in business intelligence systems, data architecture, data visualization, data analysis, data governance and testing.
  • Vast experience in managing cross-functional teams in all aspects of project plan development, problem solving, analysis, risk and issue management, project communication, reporting, and team member training. Enthusiastic to apply thought leadership and strategic planning to increase value through teh organization.

TECHNICAL SKILLS

Applications: Microsoft Office Suite, MS SharePoint, Visio Pro, Power BI and MS Project; Cognos 10.2.2, Tableau Desktop 2019, Tableau Server, SSRS, SSIS and Hyperion Essbase 11.1; SAS Info Map, HP ALM 12.01, Jira; SQL Server Management Studio, Qliksense Enterprise

Databases: Oracle 11G, Teradata 15.10, Redshift, Google Big Query, Snowflake, SQL Server

Languages: SQL, JavaScript

Operating Systems: Windows 7, 10

Other: Google Cloud Platform, TOAD 9.x, 9.6, SQL*Plus, Teradata fast load/export, Atom

PROFESSIONAL EXPERIENCE

Confidential, FAIRFAX, VA

Data Architect

Responsibilities:

  • Co-creator of logical data models analyzing matured business processes, defining entities, attributes and data dictionary. Evaluated data modeler’s products and communicated feedback for improvements.
  • Analyzed business processes and derived key performance indicators which measured velocity quantity and cost. Conceived story and layout for dashboards, authored in Power BI, for future tracking by component.

Confidential, ROCKVILLE, MD

Senior Consultant

Responsibilities:

  • Builder of CSOD, MTM survey and Guest Speaker applications wif Qliksense/SQL Server Management Studio. Co-head for requirements gathering, transformation, visualization and data validation processes. Applications enhanced salience for course instructor achievement and halped improve decision making.
  • Explored third party Qliksense applications to halp improve teh agency's Data Governance policy. Presented alternatives to executives for review and assisted in teh app's data validation processes.
  • Designed data warehouse application to show relationship between load group files and scheduled Qliksense jobs. Visualizations displayed status of job execution for current day and historical time periods. Efforts improved team’s ability to troubleshoot issues and monitor overall performance.

Confidential, HOUSTON, TX

Data Engineer

Responsibilities:

  • Developer and project lead for Google Analytics. Submitted data models for a fact and summary table containing GA 360 and GA Legacy data. Researched and created extraction query for Big Query’s export table, assisted in ETL design and report data source in AWS. Tableau visualizations halped provide insights on traffic data.
  • Project lead for Abuv data integration project. Originated plan for data extraction from Abuv's MYSQL database and migration to AWS's S3 and Redshift database. Teh effort allowed business users access to historical data and improved analytics.
  • Devised recommendations on teh company’s data governance policy for data quality. Selected specific quantitative measures and examples of use cases done on teh data warehouse ETL load.

Confidential, BOCA RATON, FL

Business Intelligence Manager

Responsibilities:

  • Created new logical reporting models in Teradata as data sources for Tableau dashboards which improved user access and decision making. These include Campaign, Customer and Local Marketing areas.
  • Submitted presentation outlining main components, vision, and functionality of teh marketing department’s portal system which includes data warehouse meta data and enterprise report catalog modules.
  • Conduct groundwork, ad-hoc analysis and formulate stories to answer business questions for mid and senior level administrators.
  • Co-leader for Customer Capabilities project. Participated in requirements gathering and buildout sessions to consolidate customer related attributes into a single database schema. Assisted in creating data models and data profiling to improve data accessibility and user reporting wifin Teradata.
  • Research and identified bugs in teh Marketing Teradata ETL production processes which includes key campaign tables. Worked wif IT on a solution which improved data quality.
  • Product Owner for Cognos Analytics upgrade project. Worked wif IT on prioritizing items in teh product backlog during sprint planning meetings. Assisted wif report migration strategy for supply chain dept.

Confidential, MIAMI, FL

Senior Business Intelligence Analyst

Responsibilities:

  • Designed and developed logical and physical data models for Retail Fulfillment project. Provided specifications for ETL to retrieve data from source systems and load to data warehouse. Prepared custom views in SQL as teh primary report data sources.
  • Study, prepare, and present reports detailing inventory flow between order entry system and warehouse, as well as spoilage and substituted or cancelled items. Outcome aided retail department’s ability to analyze inventory more holistically.
  • Co-TEMPprincipal for data visualization tool proof of concept. Leveraged both Power BI and QlikView to generate dashboards from Carnival’s data warehouse. Exhibited strengths and weaknesses of each tool and presented to department heads.
  • Investigated and generated ad-hoc analysis to answer business questions from Carnival’s management team.

Confidential, MIAMI, FL

Decision Support Analyst II

Responsibilities:

  • Performed important role in advancing Revenue Management’s Data Configuration tool. Captured requirements for different modules to be implemented by teh lead programmer. Turn out monthly status reports during teh project’s life cycle.
  • Project manager for teh Executive Dashboard project. Made a presentation on dashboard concepts and presented to top administrators in teh department. Organized meetings wif personnel to identify metrics and implementation to dashboard applications.
  • Completed presentations to halp educate mid and upper-level leaders on business intelligence concepts and status of major project initiatives.
  • Authored reporting solutions utilizing Hyperion System 9.0 and Oracle SQL, improving analyst decision making and financial achievement.

Hire Now