Mayur Patel Email & Phone Number

United States

Tempe, Az, Us

Tempe, Az, Us

1. Developed an insight platform for over 50% internal personas, enhancing the experience for 21 million customers globally through the strategic application of the Generative AI framework.2. Led the technical transition from traditional BI to generative BI, reducing the overall time to insights for internal user personas.3. Advised and collaborated with the principal user community to drive innovation, leveraging AWS services to build a robust data engineering infrastructure, fostering excellence across the organization.4. Building solutions to modernize Call Center analytics on AWS tech stack to reduce external vendor footprint and build solutions with enterprise thinking to scale with generative AI

Tempe, Az, Us

New York, Ny, Us

1. Spearheaded the development of end-to-end technology roadmaps for analytical products, driving growth and enabling swift business decisions while facilitating the adoption of reusable components within the developer community.2. Established data engineering operational excellence mechanisms, enhancing data governance, boosting efficiency, and elevating developer experience.3. Governed over 10TB of data with transparent lineage, fostering trust in governed data and KPIs through reusable frameworks like SLA tracking, data trending, verification, and quality assurance for analytical products.4. Led solutioning efforts for key initiatives such as the Accounts Payable Insights program, SPENDIQ, GCP internal insights on Tableau, and sales incentives automation on IBM Incentive Compensation Management using big data technologies.5. Guided the MARVEL program's transformation journey into innovative technologies, resulting in a $750,000 incremental CV and recognition with the EPG Award for Innovation.6. Collaborated cross-functionally with GCP stakeholders, Field Enablement, Technologies, and Big Data Platform teams to develop and promote best-in-class business intelligence, sales incentives, and data solutions.7. Directed the implementation of Global Corporate Payments big data capabilities, driving $10 billion in new Charge Volume and $5 billion in Charge Volume retention, while reducing technology operating costs by 80%.8. Actively engaged as a mentor within the network, providing guidance and support to new interns and professionals navigating the Information Technology landscape.9. Managed a team of 10 Engineers, overseeing the development of various products and proof of concepts for the Engineering team.

Troy, Michigan, Us

Troy, Michigan, Us

Project Description: Being part of the VIZCOE team, I have not only got experience on advanced Visualization reports but also got the experience to work on different data from data lake with an understanding of different business domains and provide solution/end product quickly via rapid BI tools like tableau, Data Discovery through Platfora, In memory Solution though Kognitio and Talend on big data with traditional programming on Pig, Hive. As part of this we got engaged with Travel Business units, Consumer side campaigns, Email Marketing Campaigns, Telemarketing Campaigns, Leadership reporting, and show the effectiveness of large investment in form of visualization graphs with storytelling dashboards.Responsibilities: Responsible for providing solution architecture of different use cases after analyzing the scope Work with the tech team and understand the data and then come up with a plan for the Aggregation layer Conduct storyboarding sessions with End users to understand the objective of reporting Work with stakeholders closely on the need and come up with an execution approach with the delivery of 3-4 weeks for each use cases Hands-on experience of creating structures in the hive and reducing the size of data drastically by come-up with an optimized aggregation layer to achieve 3-5 seconds rendering time on the dashboard. Create/enable a solution for business to create their own reports via the self-service BI model Worked in the iterative delivery model for report design and finalize report structure within 1-2 weeks and implement in production and improvise it based on the further requirements

Troy, Michigan, Us

GMM is to measure campaign performance across all channels (Digital and Conventional) and to deliver key marketing insights in support of strategic pay-for-performance objectives for 12 million merchants across United States and Global. Whereas ERC (Enhanced Responder Capability) has historically been used to measure DM and EM campaigns via canned reports, GMM provides the next generation of capabilities that include the sourcing of social media, exposure, offer, and impression data, as well as the establishment of a common aggregates & services layer with advanced visualization.Responsibilities: Understand Business Objective and draw solution plan to achieve highly visible business need Define engagement model for Campaign reporting to segregate data structures more aligned with solution architecture Come-up with data Quality rules with solid governance framework to ingest data in EDW and create golden copy of the data which can be leveraged for Analytics Highly optimized aggregates structure to fulfill performance requirements for advance visualization dashboard Creating a robust solution for data which can be further scalable to expand the scope of the project to extend reporting to different business units Creation of Next generation Advance visualization dashboard/reports to slice and dice the data based on Card member level and help marketing managers to show effectiveness of Campaign performance to merchants Aggregation on Huge volume of data(Impression/Enrollment & Redemption) and creating a solution in ETL to meet defined SLAs by Business Enabling Security filters for different end users to meet compliance requirements on sensitive data Created different reporting layers for different business units in terms of developing visualization for decision support, Analytics & measurement Dashboards to show effectiveness of campaigns by showing the overall revenue strategy due to marketing planner

Troy, Michigan, Us

 Responsible for the requirements study, by interacting with the business, to gather the requirement for the Enhancements/New Development. Performed Effort Estimation for the project. Co-ordinate with business to find governed attributes from portfolio based on criticality of reporting needs. Provided training to Tech and Business on Metadata Workbench tool for Data Lineage, Business Lineage and Impact Analysis reports. Created a user Manual and best practice documents for tech for development. Testing support for business for all Metadata Workbench projects. Business glossary maintenance on enterprise level with help business governance team. Created E2E reports for Lineage and provided Demo to technology group. Followed an Agile method for E2E project execution for GCS.

Troy, Michigan, Us

Project Description: The primary objective of Global Merchant Analytics and Reporting (GMAR) is to enable access to the merchant information across all locations of American Express. It provides an effective decision support system to answer key business questions efficiently. This program seeks to improve analytics by addressing the business need to access globally consistent key metrics, integrated with the merchant information needed for their core business decision making.Responsibilities: Interacting with Business Users for the business flows. Creation of ETL design specifications.  Assisting in planning the ETL flow of the Data warehouse design. Coordinate with Offshore team on Day to Day deliverables. Train the offshore team on Metadata Workbench and Business Glossary tools. Created the Best practice documents to apply the best design in Datastage. Development of Data stage Parallel jobs, Sequences to Facts, and dimensions. Converted very Complex Requirement into SIMPLE solution by Designing a Generic framework for any Data stage project in American Express Technology Involved in administering, upgrading, and migrating Data Stage/ETL environments SME guidance to developers and support teams on ETL job design and optimization Involved in Creating Hierarchical Structure to load the data into the target Played a vital role in resolving the team issues and effective coordinated with external teams in streamlining the process Involved in periodic Profiling activities using Information analyzer of information Server Suite Developed Process Flows, Logical and Physical Data models for GMAR & New BNC System Prepared Project Scope document, Project Plan document, Functional Specification document, and Technical Design Document to incorporate Balancing and Control for Financial Data into Existing GMAR System

Schaumburg, Il, Us

Responsibilities:  Responsible for the requirements study, by interacting with the business, to gather the requirement for the Enhancements/New Development. Performed Effort Estimation for the project. Used Data Stage 8.0 PX as ETL tool to extract data from source systems such as Flat files (sequential files), File Sets, and data sets to the target system. Review of code to maintain proper logic implementation/quality standards in the code. Created Quality Stage jobs using Information Server 8.0 Performed Parsing, Analyzing, Organizing the patterns of the data integrity Developed Quality Stage applications for quality data integration Used Quality Stage to performed Investigation, Standardization, Matching, and Survivorship on the data Experience in Parallel Extender (DS-PX) developing Parallel jobs using various stages including Lookup, Aggregator, Join, Transformer, Sort, Merge, Filter, Compare, Funnel, Remove Duplicates, Change Data Capture, Peek, Head, Tail, Copy, Row Generator, and Column Generator. Used Hashed file Stage as a reference table based on a single key. Developed Data Stage jobs using Data Stage Designer and Data Stage Manager. In-depth experience in dealing with different stages including Hash Lookup, Inter-Process, Link Collector, and Link Partitioning. Used Data Stage Designer to develop jobs for extracting, cleansing, transforming, integrating, and loading data into the data warehouse database Worked with production support, ETL Issues, and Performance tuning Monitored resolution of data quality issues Developed Technical Design Documents/Design Specification Documents, Mapping Specification Documents, ETL Component Specification Documents, and ETL Derivation specifications. Developed several transformations in the process of building DW  Achieved true end-to-end enterprise metadata integration via metadata sharing among systems data modeling, data integration, and business intelligence tools and standards

Yerevan, Am

Responsibilities:  Worked on analyzing the systems and gathering of requirements Work with the project and business teams to understand the business processes involved in the solution Involved in designing and development of data warehouse environment. Extensively interacted with business Analysts for design of Dimensions and facts tables for data warehouse using Star Schema Extensively used Ascential Data Stage Manager, Designer, Administrator, Director, and Integrity for creating and implementing jobs Used Data Stage Designer to extract, cleanse, transform, integrate, and load data into the data mart Extracting data from Oracle, SQL Server and Flat File sources. Cleansing, transforming and loading data into the target database using Data Stage Designer Used Data Stage Manager for importing & creating metadata definitions from repository, view and edit the contents of the repository. Worked with Profile Stage for profiling the source data Designed and developed Quality Stage jobs using Quality Stage 7.0 Used Data Stage Director and its run-time engine to schedule, run, and test and debug its components, and monitor the resulting executable versions (on an ad hoc or scheduled basis). Used UNIX shell scripts to automate the Data Load processes to the target Data warehouse, to concatenate files before loading data into target tables. Used Data Stage Designer to extract, cleanse, transform, integrate, and load data into the data mart. Fine tuned Data Stage jobs and routines for optimal performance. Extensively tested Data Stage jobs for data integrity using debugger. Used Data Stage sequencer jobs extensively to control fine grain Data Stage jobs. Made the user resources more flexible as per the business requirements by exporting Universe & BO reports.

Responsibilities:  Prepared GUI Design for Client Application Developed a database for an application in MS Access Worked in Team and co-ordinate with senior developer  Used web services concepts to develop and application Used Photo Editing software for web site design Used ASP.Net as a Front End and MS Access as a Back end Developed VB script code for web site design

Masters Of Computer Science, Computer Science (Bigdata + Ml + Blockchain)

B.E., Information Technology

Diploma, Computer Engineering