Kumar Gaurav Email & Phone Number

Kirkland, Wa, Us

Seattle, Wa, Us

Seattle, Wa, Us

Seattle, Wa, Us

Phoenix, Arizona, Us

Phoenix, Arizona, Us

• Gather requirements, analyze, pre-process, and aggregate data to be consumed by Data Scientist.• Write Sqoop jobs, Databricks jobs and schedule using CRON to operationalize customer lifetime value predictive models.• Develop and maintain data pipelines to ETL required aggregated and raw data from Netezza and other data sources to Azure Data Lake.• Create NLP models for processing text data and build multiclassification model to help internal team to predict incidents.• Create Hive tables on ADLS files and Hbase (HDInsight cluster) to perform calculations, manipulations using SPARKSQL.• Utilize Databricks notebook (Apache Spark) to run compute intensive calculation for Machine learning algorithms. • Perform analysis using SQL on Netezza based on ad-hoc request from customers and marketing team and utilize AZ CLI and NZSQL to generate files and transfer data to required location.• Parse XML blobs using PYTHON AND SPARKSQL to extract and segment product data to be modified by web team and serve as input data to SAP systems.• Perform Google image processing to extract labels from image and extract json data to be parsed into tables for Business to use.

Dallas, Texas, Us

 Driving risk analytics and managing Key Risk Indicators and Dashboard reporting, highlighting key areas of concern. Developing risk model on R and Excel to analyze customers behavior and suggest measure to reduce customers churn rate. Making sure that the company is compliant with rules and regulations like CAN-SPAM , TCPA among others. Implementing SalesIQ to manage leads in real time and perform what-if analysis and trend analysis to boost the sales by converting them to potentials.

Dallas, Texas, Us

CRM data analytics team. Facilitated scrum team events, team coaching, and metrics reporting. Extensively used Trello and Slack. Analyze Google analytics data from multiple sources on Zoho for reporting and analyzing lead conversion Improved business operations by collaborating with Sales and Marketing executives, identified and resolved issues faced which improved sales by 20%. Automated the workflows and integrated Apps, resulting in cost and time saving up to 40%. Worked with end user (Sales team), analyzed business requirements, created acceptance criteria’s and designed prototype Created rules and workflows on ZOHO to automate the process of Lead, Contacts and Account updates. Presented reports to executive management, sales, and marketing teams Enabled target marketing based on customer/ user behavior analysis using Google Analytics, HOTJAR and ZOHO Campaign Created reports scheduler for automatic report generation and sent to responsible person Performed advanced CRM analytics on Zoho, predicting sales performance by creating sales funnel and dashboards

Southlake, Texas, Us

 Performed GAP analysis for DB migration, conducted 23 user interviews, elicited requirements and created user stories for MIDT modernization on Hadoop system showcasing data ingestion process Data analysis on Teradata and Hadoop using SQL and HIVE QL to verify the logic for O&D (Origin and Destination) identification - one of the complex issue faced by almost all the GDS. Created dimensional models, designed and implemented on Qlikview. Prepared Business Requirement Document (BRD) for MIDT modernization project. Implemented SOX compliance on airline data as a part of Enterprise Data Analytics team for MIDT modernization Performed feasibility analysis for Sabre Marketplace Analytics product using Hive QL on Hadoop user interface. Demonstrated visualization expertise using Cognos 11 for creating shopping page for SMA agency product. Performed Big Data - ETL jobs on Talend, integrated with different data sources such as SharePoint, Excel among others.

Dublin 2, Ie

•Created Metrics reports and other financial reports for Clients and for internal purpose.•Creating project plans on MSPS and aligning the resources for a specific task as communicated during the project approval.•Prepared Functional Requirement Document (FRD) for Clients Internal CRM. Prepare Functional Requirement Document (FRD) for Clients Internal CRM. Query data using SQL from Oracle database.Work closely with clients, suggested improvements for their internal CRM systems and won new project for our team.•Worked closely with clients, suggested improvements for their internal CRM systems and won new project for our team•Worked with multiple clients, understood the requirement, refined and transformed it into technical form for developers. Query data using SQL from Oracle database•Liaised with clients and initiating the invoicing process for more than 80 contracts.•Reporting revenue generated by projects and working on forecasting models to understand the flow and expected revenues.•Created reusable automated files for the complex revenue recognition and other critical reports using Macros and increased the efficiency by 75%.•Created Financial Model on Excel with what if scenarios for budgeting decision and strategic planning for Pharma project •Worked on a pharma project with over 1900 resources, tracking resources and initiating the Roll-On and Roll-Off process, and assuring that the project was compliant.•Working on IBM RTC(Rational Team Concert) a lifecycle management tool, and Accenture Capacity Planning for Resource Management (ACPRM).•Managing budget and resources details on VPMi, a cloud based suite for Portfolio Management•Updating demand and supply and ensuring that resources with relevant skills are identified from the existing resource pool for the project.•Prepare and review monthly invoices and financial progress reports ensuring compliance with deliverable deadlines

Dublin 2, Ie

Gained significant experience within different Project Management areas- Project Initiation, Monitoring & Controlling and Change Control ManagementRoles and Responsibilities:•Managing Change request, service request, SLA`s (Service Level Agreement) and KPI (Key Performance Indicator) reports to help in representing the current health of the project.•Responsible for preparing DART report, a critical report which provides project’s overall status.•Creating project management templates which are used by project managers across various projects•Prepare and publish daily, weekly and ,monthly reports indicating the status and progress of the project, highlighting issues to senior management.•Prepare action issue report for BI and Service Operations Team.•Prepare L3 and L4 meeting decks for Client meetings.•Automated 13 reports using Advanced Excel formulas and Macros which reduced the time consumption by 64%.•Data extraction , Cleansing and report preparation using SMS and BMC REMEDY for Problem Tickets and Change Requests.•Event management for Project Internal Audit and Client visits

High School

Executive Certificate, Artificial Intelligence

Senior Diploma In Vocals, Vocal

Master'S Degree, Information Technology And Management

Bachelor Of Technology (Btech), Electrical And Electronics Engineering