Data Warehouse Consultant Resume San Jose, CA - Hire IT People

SUMMARY

Twelve years of experience facilitating cutting - edge reporting solutions with a wide range of Enterprise BI platforms and technology skills.
Proven ability to leverage full-stack expertise to design and build platforms with interactive and user-centered reports, dashboards and visualizations to scale.
Extensive expertise in large system architecture development and administration, as well as network design and configuration.

Areas of Expertise

TECHNICAL SKILLS

BI Platforms: MicroStrategy | Tableau | QlikView |Power BI

PROFESSIONAL EXPERIENCE

Confidential | Irving, TX

Senior Developer Analyst

Responsibilities:

Lead Reporting project in BRMS (Business Rules Management System) team for CI (commercial Insurance) and CAV (Cost Avoidance) products.
In depth analysis of Health-claim data in Hadoop eco system to design and build dimension model for reporting.
Created Hive/Impala queries to extract and transform the data.
Developed batch process using Shell Scripting and Apache NiFi Data flow to integrate big data and traditional
RDBMS for developing insightful reports used by HMS Yield teams to make revenue generating business decisions.

Confidential | Austin, TX

Senior BI Developer / Systems Architect

Responsibilities:

Designed and implemented platform sizing and infrastructure based on the business needs within budget.
Serve as Tableau SME/Internal Consultant to drive adoption, steward best practices and provide expert service to users.
Participated with key management resources in the strategic analysis and planning requirements for Database design in relation to physical and logical data architecture.
Involved in the Database Design (Relational and Dimensional models) using ERwin.

Confidential | San Jose, CA

Senior BI Consultant

Responsibilities:

Lead Architect/SME for Confidential Enterprise BI Solutions.
Developed end-to-end automated solutions to reduce any manual effort/errors, which resulted in timesaving and good end user experience.
Created entity relationship diagrams and multidimensional data models, reports for FPTI (First Party Tracking Infrastructure) team.
Ensured data warehouse and data mart designs efficiently support BI tools and end user.
Designed systems to have failover capability, Load balancing, experience with network security, multiple hardware and software upgrades with minimum or no downtime
Authentications with Active Directory, SAML, Ping Identity, and LDAP with SSL enabled web applications. Working knowledge of HTML, CSS, JavaScript.
Technical BI lead for Confidential - Confidential separation project working as SME with many teams for need to build entirely new BI platforms on windows and Linux operating systems.

Confidential | San Jose, CA

Senior BI Architect

Responsibilities:

Conduct stakeholder meetings and interface with business owners to map business requirements into technical solutions using MicroStrategy with Vertica as source database.
Involved in data modeling, optimized data collection procedures and generated reports on weekly, monthly and quarterly basis.
Contributed as the sole BI developer in a fast-paced team environment.

Confidential | Los Angeles, CA

Senior BI Developer

Responsibilities:

Worked closely with IBM database admins and ETL developers for relevant source tables
Coordinate new data integration efforts with business as needed to ensure consistency and integration with existing enterprise data.
Extensive use of custom groups, consolidations, widgets, ApplySimple formulas in reports. Deployment and testing.

Confidential | Los Angeles, CA

Senior BI Developer, Lead Systems Admin

Responsibilities:

Original team member of BI team.
Developed complex queries and extensive use of predictive analysis feature in MicroStrategy to create models.
Experience with application/report performance monitoring, collecting table statistics and indexing
Email alerting based on thresholds, report distribution using narrowcast server, recursive data hierarchies, data and user security.
Working knowledge of MicroStrategy SDK platform to modify web application on tomcat to have a custom look and feel.

Confidential | San Jose, CA

Data Warehouse Consultant

Responsibilities:

Original team member of BI team.
Worked with large-scale BI environment involving 40+ servers with real-time monitoring of servers/Processes health.
Responsible with multiple MicroStrategy projects in business areas like Ads Analysis, CRM, Finance and HR.
Supplying qualitative and quantitative data to business verticals and liaising with end-users.