Vaibhav Kumar

Data Engineer at Microsoft

Mindtree•  December 2017 - Present

Project Lead, client Microsoft, Redmond, WA Enabling Marketing Analytics platform: Building a scalable and extensible data platform to support and enable A/B testing of marketing campaign of 9 Microsoft products. • Perform detailed data analysis - to explore feasibility of business ask, identify existing & probable data issues, design data-model, data storage strategy, pipeline design, review it with architect and develop • Developed and led development of PowerBI reports, used by marketers and their leadership which measures performance of 100+ marketing campaigns for metrics like Open rate, Click through rate, increase in revenue, incremental trial activations etc. • Work in preparing platform’s road map for coming 2 fiscal quarters by getting clarity on criticality of ask and provide inputs on technical feasibility, estimated effort, challenges etc., and track them to completion • Proactively suggested data quality checks and implemented automation opportunities leading to ~50% reduction in testing, validation tasks thereby increasing delivery rate • Collaborate daily with 3 onsite and 5 offshore engineers to ensure high quality sprint deliverables (~3 to 4 business asks/ sprint, operations /support tasks, platform improvement engineering excellence items) • Technology, Tools etc.: COSMOS, Scope and iScope, PowerBI, DAX, PowerShell, Azure Data Bricks (just started), Azure Data Factory (ADF), Maestro Ensuring General Data Protection Regulation (GDPR) Compliance for reporting landscape Worked as the functional lead and project lead to ensure the big data BI platform of client was GDPR compliant • Collaborated with upstream teams to identify repetitive work, leading to scope reduction by more than 50% in effort and cost for the customer • Tracked the progress of project, explored and automated testing and validation part, leading to saving of 500+ hours which also ensured full landscape was GDPR compliant • To ensure continuing compliance, identified process changes to ensure platform is GDPR compliant by default in future and trained 4 teams to explain about GDPR and on changes needed to ensure compliance. • Technology, Tools etc.: Powershell, Kusto, Scope and iScope, SSIS, SQL, PowerBI

Senior Consultant

Infosys Limited•  August 2010 - November 2017

Senior Consultant, client *Microsoft * Redmond, WA Acting as reporting product owner, understood new business processes being designed for 2 functional tracks and led requirement gathering exercise for a fresh implementation project for order to cash business process. • Finalized reporting requirements for the minimal viable product (MVP) and identified the metrics to measure process performance, for personas from operations to leadership. • During as-is analysis, identified that ~1/3 of existing reports could be retired /merged in to-be world • Prepared and shared mockups of new reporting capabilities planned for MVP to proactively obtain feedback and incorporate them in product backlog • Led multiple meetings with end users to understand pain points of existing reports, incorporated them in MVP and product plan and educated end users about new metrics being enabled with new process changes Worked as the Lead Data Engineer to build and enhance the Data Warehouse (DW) having lead-to-order data. • Led a team and owned the design and development work of data marts, data-warehouse for nearly 5-6 business asks per sprint like new data-source onboarding, business rules update, year-end taxonomy changes. • Prepare excel based and PowerBI based reports to monitor the performance of presales pipeline. • Stakeholder management: Triaged multi-team open issues, shared update on in-progress items, obtained UAT signoffs and drove open items to closure and discussed new asks, their priority and delivery dates. • Technology, Tools etc.: SSMS, SSIS, SSAS, PowerBI, SQL, DAX, Report - prototyping

Assistant Manager

IDBI Bank•  July 2009 - August 2010

IDBI Limited Belgaum, Karnataka, India Assistant Manager 07/2009– 08/2010 Performed credit appraisal of fund based and non-fund-based credit applications of small medium enterprises • Appraised more than 75% of fresh credit application and renewal cases with high exposure (>10 million INR). • Proactively made easy to use repayment and analysis models in excel and shared in 4 branches for adoption and the model was very well received in the branches. • Performed Economy, Industry, and Company analysis, analyzed audited and projected financial statements, performed credit rating exercises to identify risk, mitigants and to decide the price of the credit facilities. • Travelled more than 1,000 miles in 1 year to visits clients to build relations, to validate correct funds use with clients and to periodically assess their business