Client: Coast Mountain Bus Company (Division of TransLink)Tools & Techniques:Azure Synapse Analytics, Power BI, Azure API, Azure Data Lake Storage, Azure Key Vault, Azure Delta Lakehouse, HASTUS (Bus Operations ERP Application), SQL Server, SQL Server Integration Services, Postman for REST APIResponsibilities - Data Architect/Team Lead/Lead DeveloperCreated current-state architecture for a highly fragmented Bus Operations Performance Application.Create future-state analytics… Show more Client: Coast Mountain Bus Company (Division of TransLink)Tools & Techniques:Azure Synapse Analytics, Power BI, Azure API, Azure Data Lake Storage, Azure Key Vault, Azure Delta Lakehouse, HASTUS (Bus Operations ERP Application), SQL Server, SQL Server Integration Services, Postman for REST APIResponsibilities - Data Architect/Team Lead/Lead DeveloperCreated current-state architecture for a highly fragmented Bus Operations Performance Application.Create future-state analytics roadmap using data from the new Bus Operations Application. Delivered target architecture framework that blends both legacy (DOMS) and new (HASTUS) data to a new Delta Lakehouse.Developed data maps and dimensional models for various data marts that trend Operator Regular Run Time, Overtime, Absence Time and Banked Days, Productivity Rate, Bus and Operator Availability and Pay Categories.Worked in collaboration with the Operations Analyst and Line of Business to develop functional specifications for data consolidated from 120 reports into 16 data marts.Designed and developed Azure Synapse data pipelines, data flows, data transforms, secured access to source using Azure Key Vault. Developed transforms to perform data lookups, data upserts, data loads using Pyspark/Databricks scripting in Synapse notebooks.Established integration to Azure data pipelines from data sources based on REST services, On-Prem database and cloud-based files using Azure API.Developed semantic models and datasets in Azure Synapse to External tables in the Data Lakehouse. Assisted operations analysts with creation of Power BI semantic models.Developed CI/CD pipelines in Azure DevOps. Developed CI/CD pipelines in Azure DevOps. Created an POC pipeline using YAML.Developed data extraction routines using the application's proprietary language similar to Python, named OIG. Utilized PowerShell to orchestrate and parameterize the source and target data file locations and environments. Show less

Company - Groundswell GroupClient - Financial Investment CompanyTools & Techniques - Microsoft SQL Server, SSIS, SSRS, Power BI, INCORTA, Oracle Golden GateResponsibilities - Data Governance ConsultingConducted workshops to interview diverse customer business groups to assess current state of analytics maturity. Delivered detailed gap analysis document.Conducted a multi-location feasibility study on effective Oracle GoldenGate real-time replication strategies and… Show more Company - Groundswell GroupClient - Financial Investment CompanyTools & Techniques - Microsoft SQL Server, SSIS, SSRS, Power BI, INCORTA, Oracle Golden GateResponsibilities - Data Governance ConsultingConducted workshops to interview diverse customer business groups to assess current state of analytics maturity. Delivered detailed gap analysis document.Conducted a multi-location feasibility study on effective Oracle GoldenGate real-time replication strategies and solutions.Perform data profiling tasks on source data. Identified gaps in data integrity and data completeness.Outlined a use case for the implementation of a Data Governance Framework within the Operations Team, detailing the roles of data stewards, data custodians, and data controls.ClientCertified Public Accountant (CPA)Responsibilities - Solutions ArchitectureProvided roadmap to transition from the current-state to the future-state analytics. Presented a summary of the Analytics Evolution to senior executives. Provided the target architecture framework to business teams.Strategized delivery of 10 Operational and Analytical Reports. Delivered detailed design for Data Ingestion and History TrackingArchitected data replication using change data capture approach in SQL Server and facilitated integration with an Operational Data StoreDeveloped in-house Proof of Value with data pipeline using Azure Cloud framework. Used Azure Data Factory to move data from SQL Server to Azure Synapse AnalyticsPresented reference data architecture to advance through the stages of the Analytics Maturity Model.Gained exposure to Continues Integration capabilities using Azure DevOps and Kubernetes Services Show less

Client - Claims Division, Pacific Blue CrossTools & Techniques:Microsoft SQL Server, SSIS, Oracle 11i, Oracle Cloud Infrastructure.Responsibilities - Data Migration Architecture:Used SAFe Agile methodologies for creating KPI design and development activities. Identified and mitigated risks associated with use of new data ingestion and reporting tools.Developed a framework to facilitate process workflow for migrating pension administration data from AS/400 to Oracle Cloud… Show more Client - Claims Division, Pacific Blue CrossTools & Techniques:Microsoft SQL Server, SSIS, Oracle 11i, Oracle Cloud Infrastructure.Responsibilities - Data Migration Architecture:Used SAFe Agile methodologies for creating KPI design and development activities. Identified and mitigated risks associated with use of new data ingestion and reporting tools.Developed a framework to facilitate process workflow for migrating pension administration data from AS/400 to Oracle Cloud platform.Conducted workshops to evaluate data migration strategiesCreating architectural artifacts for both – transitionary (one-time) migration process and persistent(ongoing) cloud solution for pension administration and reporting.Designed automation of data pipelines by integrating legacy Pension applications and Oracle Cloud platform using SQL Server Integration Services and Oracle OCI.Presented migration strategy to stakeholders from SMEs to Director of IT. Show less

Tools & TechniquesIBM Data Stage, IBM Framework Manager, IBM Infosphere Data Architect, IBM Cognos AnalyticsResponsibilities - Data ModelerProvided data mapping and functional specifications consistently to three IBM Datastage ETL developers, ensuring a three-week head start on an ongoing basis.Created a Data Governance deliverable to identify and document data lineageDeveloped normalized 3NF and 4NF models in ODS for Operational Reporting to support existing reporting… Show more Tools & TechniquesIBM Data Stage, IBM Framework Manager, IBM Infosphere Data Architect, IBM Cognos AnalyticsResponsibilities - Data ModelerProvided data mapping and functional specifications consistently to three IBM Datastage ETL developers, ensuring a three-week head start on an ongoing basis.Created a Data Governance deliverable to identify and document data lineageDeveloped normalized 3NF and 4NF models in ODS for Operational Reporting to support existing reporting framework.Served as the lead data modeler for the Fleet and Garage Reporting project, improving both transactional and multi-dimensional models to handle 100 GB of daily incremental data throughput for the Enterprise Data Warehouse.Mapped reporting KPIs to physical and logical analytical data modelsConducted design workshops with ETL developers to validate data mapping specification and delivered ETL process flow design document.Developed models and data maps for over 80 entities in Staging. Designed referential integrity in data modelProactively conducted and presented a risk assessment for the EDW platform, proposing both short-term and long-term remediation strategies. Show less

Tools & TechniquesIBM Cognos Analytics, IBM Data Manager, SQL ServerResponsibilities - Senior Data Analyst/ Team Lead:Led all phases in the SDLC for over 12 Enterprise Data Warehouse solutions for Casinos, Retail Lottery and Online Gaming channels.Led a team of up to 3 senior permanent and external contract resources in the development of BI solutions.Created functional specifications and mapped data from diverse sources to several target data marts. I also developed data… Show more Tools & TechniquesIBM Cognos Analytics, IBM Data Manager, SQL ServerResponsibilities - Senior Data Analyst/ Team Lead:Led all phases in the SDLC for over 12 Enterprise Data Warehouse solutions for Casinos, Retail Lottery and Online Gaming channels.Led a team of up to 3 senior permanent and external contract resources in the development of BI solutions.Created functional specifications and mapped data from diverse sources to several target data marts. I also developed data matrices and profiles to analyze and demonstrate the reasoning behind data modeling initiatives.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 including high volume and granular data marts (over 3 TB), high volume dimensions and aggregate data marts.Data was sourced through diverse interfacing techniques, including web services, which were implemented on scalable Enterprise Service Bus (ESB) tools adhering to Service-Oriented Architecture (SOA) principles.Developed ETL routines using IBM Data Manager and semantic models using IBM Framework Manager.Established compliance with Data Privacy policies by masking/locking sensitive data.Developed enterprise logical data models aligned with the information data management roadmap. Formulated subject area data models for Sales, Player Performance, and Loyalty Data Marts. Designed models for transactional analytics, point-in-time snapshots, and roll-up STAR schemas.Designed 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. Managed EDW incidences and request queue. Show less

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. Presented data strategy to propose buy-in for a $400,000 Business Intelligence greenfield endeavor to key stake holders including Chief Financial Officer and Chief Information… Show more 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. Presented data strategy to propose buy-in for a $400,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.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 40Worked with multi-location (Europe & India) software vendors to create a data integration strategy between from Travel Reservation System and ODS application.Established data governance practice for data in the BI domain. Maintain single source of truth approach to metric collection for passenger counts, package sales, booking turnaround times, etc. Metadata model were implemented for both the ODS and Data Marts using STAR schema groupings in Cognos Framework Manager to allow for efficient reporting.Mentored BI developers to author Executive Dashboards to monitor Sales with regards to 10 perspectives including Travel Packages, Sales Channels, Guest Demographics and Seasonality Show less