We provide IT Staff Augmentation Services!

Data Analytics Architect Resume

4.00/5 (Submit Your Rating)

Saint Louis, MO

SUMMARY

  • Constantly evolving Business Intelligence Architect and Data Engineer wif proven success in wide range of projects from high volume performance tuned Extraction, Transform and Load (ETL) processes to targeted departmental scorecard reporting.
  • Extensive experience in Business Intelligence / Data Warehouse environments and technologies in diverse industries such as; Health Care, Financial Services, Manufacturing and Consumer Goods.
  • Skilled in applying past expertise to new technologies and environments, quickly and accurately providing value and directly impacting project success. Focused on delivering customized results and known for ability to act as TEMPeffective team lead in ever changing environments.
  • Boomi Integration
  • R Programming and Azure Machine Learning Studio
  • Certificates in Microsoft Data Science and Microsoft Big Data
  • Certifications in Microsoft R (Revolutions R) and SQL Server Business Intelligence and Data Platform
  • Technical Team Lead for coordinating and overseeing Confidential / Wachovia merger UNIX workflow.
  • Project Lead managing offshore Anheuser Busch DataStage development of XML to Oracle Commodity Hedge system.
  • Authored Best Practices and Standards documentation for A.G. Edwards, Anheuser - Busch and Confidential .
  • Presented at various events on; Azure SSIS, Microsoft R, Azure Data Factory, Modern Data Warehouse: Azure Machine Learning Studio and IoT Streaming Analytics.
  • Conducted and facilitated Saint Louis User Group meetings (DataStage and Cognos) at A.G. Edwards and Mercantile Bank.
  • Led Quality Assurance, Code Review Walkthroughs and individual Mentoring sessions wif Departmental Developers at A.G. Edwards and Anheuser-Busch.

TECHNICAL SKILLS

Environment: s: Azure, Windows, UNIX

Databases: SQL Server, Azure SQL Database, Azure SQL Data Warehouse, Oracle, Teradata, DB2, Informix, MSAccess

Data Science: R, (R Studio/Visual Studio), Azure Machine Learning Studio, SQL Server Machine Learning Services

Data Modeling: Erwin, IEF (Coolgen)

Programming: R, T-SQL, Powershell, PL / SQL, BTEQ, Basic, awk, sed, UNIX scripting, C#

ETL: Boomi Integration, SSIS, Azure Data Factory, IBM DataStage, Informatica

Reporting: SSRS, Power BI, Cognos Impromptu, Business Objects, Excel

OLAP: Analysis Services: Tabular and Multi-dimensional, Cognos Powerplay

PROFESSIONAL EXPERIENCE

Confidential, Saint Louis, MO

Data Analytics Architect

Responsibilities:

  • Boomi Integration Data Engineer
  • Azure Enterprise data warehouse design & implementation
  • Azure Data Mart design & implementation
  • Azure Machine Learning Studio
  • SQL Server Machine Learning Services (Microsoft R, Revolutions R)
  • Azure Data Factory
  • Azure Streaming Analytics and IoT

Confidential, Saint Louis, MO

Senior Consultant - Business Intelligence

Responsibilities:

  • ETL SSIS Agile Team Member. Migrating AS400 to new Azure Data and Application Platform
  • SSAS Quality Assurance for Lumeris
  • Excel VBA Developer for Eastman (Solutia)

Confidential, Saint Louis, MO

Senior Business Intelligence Specialist

Responsibilities:

  • Microsoft BI toolset (2008 R2).
  • Developed Cloud based (Rackspace) SharePoint Reporting Solution and Departmental Scorecards.
  • Maintained SSAS Cube Analytic Solution for identifying High Risk Claims wif direct impact to Profit/Loss

Confidential, Saint Louis, MO

Technical Team Lead, Consultant

Responsibilities:

  • Developed Technical Execution Framework utilizing Microsoft (MS) Project and MS Access for Wachovia / Confidential Merger.
  • Designed and executed UNIX Scripted Delivery of data to BDW and ODS across multiple environments, merging and reconciling over $14B of assets from Wachovia into Confidential systems.

Confidential, Saint Louis, MO

Business Intelligence Data Integration and ETL Architect, Consultant

  • Architected, designed and managed several ETL DataStage On / Offshore projects consisting of EE RCP and XML processes loading into Teradata and Oracle.
  • Authored Best Practices and Standards, and Guidelines for IBM Websphere DataStage Enterprise Edition and ETL Resource estimation tool (spreadsheet), TEMPeffecting significant productivity improvements.
  • Developed audit, logging and error reporting UNIX scripts supporting various ETL processes, increasing ETL tool ROI.
  • Developed and maintained UNIX Scripting (AWK) collecting DataStage metadata, while importing into SAS.
  • Managed (PM) several highly successful projects throughout their entire SDLC Release cycles.
  • Delivered SDLC builds as ClearCase Buildmaster responsible for development through testing and into production, minimizing promotion related code defects.

We'd love your feedback!