Alfredo Araiza

Alfredo Araiza Email and Phone Number

Data Solution Architect at Data View LLC Providing clients with Business Intelligence/ETL solutions @ Data View - LLC
Alfredo Araiza's Location
Kansas City, Missouri, United States, United States
Alfredo Araiza's Contact Details

Alfredo Araiza personal email

About Alfredo Araiza

Seasoned Solution Architect with expertise in a diverse range of technologies within multiple industry settings. Demonstrated success designing and implementing enterprise-level Business Intelligence solutions leveraging existing technology investments. Exceptional problem solving skills in complex highly integrated data environments.Core Competencies: Data Integration, Data Warehousing, Data VisualizationCore Technologies: MS SQL Server, Service Broker, TSQL, SSIS, SSAS, SSRS, Power Bi, Informatica, Python and XML.

Alfredo Araiza's Current Company Details
Data View - LLC

Data View - Llc

View
Data Solution Architect at Data View LLC Providing clients with Business Intelligence/ETL solutions
Alfredo Araiza Work Experience Details
  • Data View - Llc
    Owner / Data Solution Architect
    Data View - Llc Aug 2012 - Present
    Data View LLC is a Data Warehousing / Business Intelligence Professional Services provider.Core Specialty: Real-Time Mainframe BI Solutions using SQL Service BrokerAdditional Service Offerings: Full Data Solution Architecture and Implementationo Data Analysiso Database Design o Data Integration (ETL)o Data Validationo Data VisualizationBusiness Intelligence Solutions (SSAS,SSRS and Power Bi)Mainframe to Relational Database ConversionsETL Solution Conversions (Informatica to SSIS)SSIS generation with BIMLDatabase Query Performance TuningData Strategy
  • Umb Bank
    Business Intelligence Architect
    Umb Bank May 2011 - Aug 2012
    Kansas City, Mo, Us
    Partnered with a vendor to implement a customized solution of Oracle’s Business Intelligence Platform (OBIEE 11g and Informatica PowerCenter 9.0). Pioneered initiatives to develop low-cost Business Intelligence solutions using the Microsoft Technology Stack. • Designed and implemented the architecture for integrating custom data feeds for OBIEE’s Financials Package.• Designed and developed data validation processes • Architected and developed Dashboards to display key metrics as part of a corporate Data Quality initiative.• Architected and developed a prototype ODS for integrating and presenting data from multiple sources and formats (EBCDIC, ASCII) using MS 2008 R2 SSIS & SSRS.• Mentored peers in database design and development best practices
  • Atk
    Data Architect
    Atk Jan 2010 - May 2011
    Dulles, Virginia, Us
    Responsible for delivering a Kimball based BI Data Warehouse: integrating ERP, Accounting, Human Resources and Time & Attendance data. Developed and implemented a Business Intelligence delivery architecture (Informatica PowerCenter 8.6, MS SSRS 2008 R2, Oracle 10g).• Consolidated the repository of existing Source System operational reports with Strategic and Tactical reports sourced from the Data Warehouse into a single point of delivery.• Partnered with Business leadership and stakeholders to identify and deliver targeted and actionableReporting that supports strategic development and tactical execution and evaluation.• Achieved a cost savings of 200 man hours per week by automating Business Critical Reports• Re-architected weekly payroll process resulting in a 98% reduction in run time.
  • Summit Data Solutions Llc
    Owner / Principal Consultant
    Summit Data Solutions Llc Oct 2007 - May 2011
    Partnered with various clients in the capacity of ETL Developer and Data Analyst.
  • Assurant Employee Benefits
    Contract Datastage Etl Developer
    Assurant Employee Benefits Jul 2009 - Jan 2010
    Kansas City, Mo, Us
    • Developed robust ETL jobs to support the change data capture process for the Enterprise Data Warehouse (DataStage 7.5, Linux, Oracle 10g).
  • Blue Cross Blue Shield Of Kansas City
    Contract Datastage Etl Developer
    Blue Cross Blue Shield Of Kansas City Feb 2009 - Jul 2009
    Kansas City, Mo, Us
    • Created ETL jobs to extract data into complex XML formatted files. (DataStage 7.5, Unix Shell Scripting, SQL Server 2000)• Worked with 3rd party vendors to document requirements and create test plans.• Performed Data Mappings between legacy database structures and newly developed 3rd party application• T-SQL development to perform in depth data analysis
  • American Multi-Cinema
    Contract Data Analyst
    American Multi-Cinema Oct 2007 - Jan 2009
    • Analyzed and documented legacy data flow processes • Documented Data Mappings between legacy and replacement Point of Sale systems• Authored Technical Design Specifications and developed ETL processes to integrate source system data into the Data Warehouse• Designed Database objects using Embarcadero ER Studio
  • Novastar Financial
    Senior Business Intelligence Analyst
    Novastar Financial Sep 2006 - Oct 2007
    At NovaStar I was responsible for all Data Integration and Reporting related to Mortgage Servicing. • Provided Portfolio performance reports to external rating Agencies (Standard and Poor’s, Fitch and Moody’s) for the purpose of obtaining Servicer Ratings used by investors• Developed and maintained a repository of over 200 internal reports (MS Access, SSRS)• Developed complex T-SQL queries to satisfy ad-hoc data requests (MS SQL Server 2005)• Automated data feed to Deutsche Bank to reconcile weekly borrowing Base (C#, MS SQL Server 2005)
  • Novastar Financial
    Software Engineer
    Novastar Financial Apr 2002 - Sep 2006
  • Sprint
    Application Developer
    Sprint Jul 2000 - Nov 2001
    Overland Park, Kansas, Us
    • Developed and supported web applications used by the Small Business Sales Force (ASP / Oracle 8i)
  • Sprint
    Program Manager
    Sprint Jul 1999 - Jul 2000
    Overland Park, Kansas, Us
    • Supported the order entry systems for 6 Sprint Call Centers• Managed the procurement and integration of new equipment at multiple locations• Authored training materials for use by Call Center Analysts• Created Ad-Hoc reports to gauge Call Center Performance

Alfredo Araiza Skills

Data Warehousing Etl Business Intelligence Ssrs Ssis Microsoft Sql Server T Sql Databases Oracle Sdlc Erp Data Integration Informatica Sql .net Integration Data Quality Report Development Data Modeling Crystal Reports Architectures Software Documentation Data Integration And Presentation Informatica Powercenter 8.6 And 9.0 Business Analysis C# Xml Web Applications Data Architecture Performance Tuning Datastage 7.5 And 8.1 Access Agile Methodologies Vb.net Requirements Gathering Datatrac Service Broker Tableau Architecture Software Development Life Cycle Sql Server Reporting Services Transact Sql Sql Server Integration Services Data Analysis Power Bi Python Sql Azure

Alfredo Araiza Education Details

  • University Of Missouri-Kansas City
    University Of Missouri-Kansas City
    Computer Science
  • Oak Park High School
    Oak Park High School

Frequently Asked Questions about Alfredo Araiza

What company does Alfredo Araiza work for?

Alfredo Araiza works for Data View - Llc

What is Alfredo Araiza's role at the current company?

Alfredo Araiza's current role is Data Solution Architect at Data View LLC Providing clients with Business Intelligence/ETL solutions.

What is Alfredo Araiza's email address?

Alfredo Araiza's email address is aa****@****ail.com

What schools did Alfredo Araiza attend?

Alfredo Araiza attended University Of Missouri-Kansas City, Oak Park High School.

What skills is Alfredo Araiza known for?

Alfredo Araiza has skills like Data Warehousing, Etl, Business Intelligence, Ssrs, Ssis, Microsoft Sql Server, T Sql, Databases, Oracle, Sdlc, Erp, Data Integration.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.