Alpesh Shah

Client:

• Coast Mountain Bus Company

Tools & Techniques:

• Azure Synapse Analytics, Power BI, Azure API, Azure Lake Storage, Azure Key Vault, Azure Data Lake Storage, HASTUS (Bus Operations ERP Application), SQL Server, SQL Server Integration Services, Postman for REST API

Responsibilities

• Worked as a Data Architect cross-functionally with Operations Analysts, Financial Analysts, Enterprise Architects, Project Managers and BI developers.
• Created current-state architecture for a highly fragmented analytical solution for Operations Performance (DOMS – Legacy Application)
• Create future-state analytics roadmap using the new Bus Operations applications (HASTUS) as data source for Operations Performance. Delivered target architecture framework that blends both legacy (DOMS) and new (HASTUS) data to a new Delta Lakehouse.
• Oversaw and supported build of over 2 dozen data marts with over 12 years of data from inspection to deployment in 18 months.
• Developed data maps and dimensional models for various data marts to trend Operator Regular Run Time, Overtime, Absence Time and Banked Days, Productivity Rate, Bus and Operator Availability and Pay Trends to be uploaded to PeopleSoft.
• Collaborated with Operations Analyst & LOB to create report specifications for 93 reports that were consolidated into data from 2 dozen data marts .
• Designed and developed Azure Synapse data pipelines, data flows, data transforms, secured source data access using Azure Key Vault. Developed transforms and performed data upserts using Pyspark notebooks.
• Established data sources to data pipelines to REST services, On-Prem database and cloud-based data files
• Developed semantic models and datasets in Azure Synapse to External tables in the Data Lakehouse. Assisted Analysts with creation of Power BI semantic models.
• Exercised working supervision over 2 BI developers, conducted peer reviews and development of functional specifications for data pipelines.
• Worked with Azure DevOps Team to make solutions environment agnostic. Developed CI/CD pipelines in Azure DevOps
• Presented solutions for LOB supervisors for approval and review.

Client

• Financial Investment Company

Tools & Techniques:

• Microsoft SQL Server, SSIS, SSRS, Power BI, Incorta, Oracle Golden Gate

Responsibilities - Data Governance Consulting:

• Conducted workshops to interview a diverse customer business groups to assess current state of analytics maturity. Delivered detailed gap analysis document.
• Documented detailed operational reporting requirements. Evaluated legacy reports and developed business process workflow for relational data stores.
• Perform data profiling tasks on source data. Identified gaps in data integrity and data completeness.
• Performed multi-location feasibility studies of viable Oracle Golden Gate real-time replication strategies and solutions.
• Presented a use case for establishing a Data Governance Framework for Operations Team including identification of data stewards, data custodians and data controls

Client

• Certified Public Accountant (CPA)

Responsibilities - Solutions Architecture

• Provided paths from current-state to future-state analytics roadmap. Delivered summary of Analytics Evolution to senior executives. Delivered target architecture framework to business teams
• Strategize delivery of 10 Operational and Analytical Reports. Delivered architectural approach and detailed design for Data Ingestion and History Tracking
• Architect data replication using change data capture approach and facilitate integration with an Operational Data Store
• Developed in-house Proof of Value with data pipeline using Azure Cloud framework. Used Data Factory to move data from SQL Server to Azure Synapse Analytics
• Gained exposure to Continues Integration capabilities using Azure DevOps and Kubernetes

Tools & Techniques:

• Microsoft SQL Server, SSIS, Oracle 11i, Oracle Cloud Infrastructure,

Responsibilities - Data Migration Architecture:

• Used SAFe Agile methodologies to task KPI design and development. Identified and mitigated risks associated with use of new data ingestion and reporting tools
• Developed a framework to facilitate process workflow of pension administration data from AS/400 to Oracle Cloud platforms
• Presented migration strategy to stakeholders from SMEs to Director of IT
• Conducted workshops to evaluate migration strategies for performance and data mapping accuracies
• Lead in-house and vendor teams in creation of architectural artifacts for both – transitionary migration process and persistent cloud solution for pension administration and reporting.
• Developed data encryption framework conformance using 128-bit private and public key mechanism while move data files across

Tools & Techniques

• IBM Data Stage, IBM Infosphere Data Architect, Cognos Analytics

Responsibilities - Data Modeler

• Provided data mapping and functional specifications to 3 IBM Datastage ETL Developers with a 3-week head-start over development efforts.
• Participated in daily stand up scrums and Agile sprint planning and retrospect workshops. Used JIRA to create Agile epics, stories and tasks.
• Conducted workshop to reviews of data models, demonstrated validity of model with regards to source data and setup of data discovery environment
• Created data governance deliverable to identify and document data lineage
• Worked as primary data modeler for the Fleet and Garage Reporting project. Enhanced transactional and multi-dimensional models to process 1 Gb of daily incremental data throughput to the Enterprise Data Warehouse
• Mapped reporting KPIs to physical and logical analytical data models
• Conducted design workshops with ETL developers to validate flow of data mapping specification to data ingestion process. Delivered ETL process flow design document.
• Developed models and data maps for over 60 entities in Staging. Maintained parent child references established in source application. Designed referential integrity in data model
• Proactively identified and present risk assessment of EDW platform. Suggested short-term and long-term remedial approaches

Tools & Techniques

• IBM Cognos Analytics, IBM Data Manager, SQL Server

Responsibilities - Senior Data Analyst/ Team Lead:

• Led all phases in the SDLC of over 12 Enterprise Data Warehouse solutions for Casinos, Retail and Online Gaming channels.
• Led a team of up to 3 senior permanent and external contract resources in the development of BI solutions.
• Negotiated effort priorities, solution scope, service level agreements (SLA) and resource conflicts with business leads while managing projects, on-demand request items and application support issues.
• Developed functional requirements and specifications after interviewing cross-functional teams that consume analytical information for Online Gaming products.
• Designed and implemented over 20 Data Marts that that included highly voluminous and granular data marts (over 3 TB), high volume dimensions and rollup data marts.
• Sourced data using various interfacing techniques including web services implemented on scalable Enterprise Service Bus tools using SOA principles.
• Conducted design reviews of data models, data extraction and transformation routines and metadata models to ensure best practice approach are adhered to.
• Develop data reference architecture road maps and open data integration strategies to allow for plug and play approach using REST API interfaces.
• Created enterprise data models as part of information data management roadmap. Created subject area data models for Sales, Player Performance and Loyalty Data Marts. Created models for transactional analytics, point-in-time snapshots and roll-up STAR schemas.
• Designed reference data models using EDW conformed dimensions and MDM canonical constructs for consistent, accurate and shared use. Developed criteria for data matching and merging algorithms. Performed application support tasks to troubleshoot data anomalies, tuned poorly performing SQL routines, reports. Manage EDW/ I incidence and request queue.

Tools & Techniques:

• Microsoft SQL Server, SSIS, IBM Cognos Analytics

Responsibilities - BI Architect

• Conducted workshops for cross-functional business teams to formulate Business Intelligence requirements and functional specifications for over 7 projects
• Lead 4 BI specialist in the design of Operational and Analytical reporting solutions across 4 business lines Sales, Finance, Operations and Guest Services.
• Mentored BI developers to author Executive Dashboards to monitor Sales with regards to 10 perspectives including Travel Packages, Sales
• Presented BI strategy to propose buy-in for a $200,000 Business Intelligence greenfield endeavor to key stake holders including Chief Financial Officer and Chief Information Officer
• Designed and implemented an Operational Data Store using hybrid data model to support reporting for Trip Tickets, Trip Itineraries, Passenger Manifests and Sales Reporting. In-house design and development efforts resulted in savings of over $200,000 over 2 years. The ODS served as a single consistent data source for Data Marts and Operational Reports
• Designed and developed 4 data marts that were augmented with OLAP cubes for slice and dice reporting of Sales Trends, Budgets and Forecasts. All solution components were created in under 6 months and supported a user base of 40

Environment:

• Windows NT, HP UX 11.0, Servlet, JSDK 2.0, Visibroker for Java, JRun, Apache Web Server, HTML, JavaScript.

Responsibilities:

• Designed and developed a web interface to the Global Support Server, a CORBA object using Java Servlets.
• Used Visibroker ORB for communicating with the Entitlement CORBA object.
• Designed and developed servlets using JSDK 2.0.
• Incorporated a load balancing mechanism in the servlet for multiple instances of the Entitlement object in the network.
• Developed Web client using HTML, JavaScript.

Environment:

• ORACLE 7.1, Forms, Reports, HPUnix, IBM Compatibles.

Responsibilities:

• Analyzed, designed, developed, and supported Business Application Software.
• Created and maintained Data Models, tables, Stored procedures, triggers, and indexes.
• Tested, and fine-tuned SQL Queries, Stored procedures, and triggers.
• Documented Design Specifications, Program Specifications, Installation Procedures and Data Model.