Vaibhav Kumar Email & Phone Number

Bothell, Wa, Us

Plantation, Florida, Us

• Development and enhancements of ETL packages (1~2 stories per sprint), answering questions from business leaders to help in making data-based strategic decisions and provide new analytical capabilities to analysts/data scientists • Developed capability to identify CSRs abusing Chewy’s policies and causing revenue loss to Chewy, resulting in HR intervention for ~100+ CSRs• Working and leading DE activities to enhance data model, queries and jobs to support reporting asks after business expansion into a new country.• Own generation of business review reports - ~ 15 Key Metrics on weekly, monthly cadence used for review of business performance by the Senior leadership team including CXO. Providing prompt, accurate and precise responses to their querieso Started with a mostly manual process, have incrementally automated many steps saving nearly 6 hours per weeko Training team members, ensuring up-to-date documentation exists, resolving prod -issue typically in 1-2 days• Working with peers for code review, code optimization, mentoring of new resources and other team-level meetings/ initiatives.

Plantation, Florida, Us

• Data exploration, maintaining, enhancing, existing Tableau reports and developing new Tableau reports on Tableau Desktop and deployed on Tableau Server to support business asks.

Seattle, Wa, Us

• Learning new technology and the processes by participating in design review, code review, reading tech documentation etc. • End-to-end activities for project like data profiling, doing Proof of Concept, creating design documents, SQL development, code review, preparing deployment document and review of the artifacts of the team members • Supported Month close process which included monitoring jobs, ensuring daily flows complete on time, validating data quality, communicating status with downstream team and resolving end user issues, documenting and analysis of issues seen, solution / work around used etc.Technology: AWS , Athena, Glue , SQL , Glue, Distributed Job Scheduler, Hive, Spark

Bangalore, Karnataka, In

Project Lead, client Microsoft Redmond, WA• Enabling Marketing Analytics platform: Building a data platform to support Engagement Analytics and Outcome measurement and enable A/B testing of the marketing campaign of 9 products. • Perform detailed data analysis - to explore the feasibility of business ask, explore new insights from data and propose for evaluation to business, identify existing and probable data issues, mitigation approaches, develop solution approach, review with the architect, and develop• Proactively suggested data quality checks and implemented automation opportunities leading to ~50% reduction in testing, validation tasks thereby increasing delivery rate• Collaborate daily with onsite and offshore team to ensure high-quality sprint deliverables which include business asks/ sprint, operations /support tasks, platform improvement engineering excellence items.• Develop and enable PowerBI reports to measure the performance of marketing campaigns. • Work with stakeholders to create a platform road map for the coming calendar quarter.Ensuring General Data Protection Regulation (GDPR) Compliance for reporting landscape • Worked as the functional and project lead to ensure the big data BI platform of client was GDPR compliant

Bangalore, Karnataka, In

Worked as a Business Intelligence consultant at Microsoft in different roles like product manager, data engineer and onsite lead of data engineering track. • Worked on requirement gathering, understanding business processes, Identifying business requirements and documenting the BI asks based on interactions with end users and process owners • Worked on requirements like enhancements to the Data-warehouse and data-marts like on-boarding of data sources, migration of source system, updating of business rules, Year end taxonomy changes, triaging and resolving end user queries.

Bangalore, Karnataka, In

Worked as a Techno-functional consultant in SAP BI / BW project • Responsible for ensuring all the Business Intelligence reports of of SAP MM and FICO modules got refreshed as per SLA and had correct data and stakeholder management and communication. • Owned and led BI track for all phases of monthly enhancements releases and ensure full SOX compliance. This included:o Development - modification / enhancements of SAP-BW objects like Info-objects, DSO, Info-cubes, transformation mappings, modify ABAP transformation Routines, Start Routines, and Info-object routineso Development of BEX-Queries and user-friendly reports in BEx Query designer. • Performed start of month reconciliation (between SAP ECC data and BW report) to validate accuracy of reports. The proof of data reconciliation was an important artifact checked by external auditors.Tools / Technology: SAP BI/BW 7.3, Business Explorer (BEX), SAP ECC (Source system)

Bangalore, Karnataka, In

• Worked in different type of BI Projects for different clients at India and in USA on different types of Business Intelligence related projects like development project, upgrade project, maintenance and enhancement projects. • Had worked in different capacities as an individual contributor as well as had led teams.• Hands on development of ETL packages, SQL queries, modification of database elements, cubes etc.• Have worked as Pre-sales anchor for business intelligence related opportunities. Worked closely with Sales team to understand business requirement, and worked with SMEs to arrive at the best possible solution, calculate the bid value, estimated profit margin, obtained necessary internal approvals and provided any additional support the Sales team needed.

Mumbai, Maharashtra, In

Sourcing new business:o Contacting Small and Medium Enterprise (SME) business in need for fresh financial assistance (called green field loans, fresh loan) and approaching them to discuss their business in details and discussing with seniors regarding extension of credit facilities to them. o Pitching case of IDBI Bank before clients already availing Credit facilities from different financial institutions to source new business (called brown field loans/ loans takeover cases). • Doing Credit appraisal for request of fund based and Non fund based Credit facilities such as Term loans, Cash Credit, Bank Guarantee etc. • Conduct Pre-Sanction visit to get a holistic idea of the business of the client/applicant and identify risk and growth opportunities in the business. • Assessing a project’s viability, doing Economy, Industry & Company (EIC analysis), verifying and approving the financial projections. • Preparing the Credit Monitoring Arrangement (CMA), analysis of audited and provisional financial statements and preparing the Credit Appraisal report for the proposals.• Doing Credit Rating, identifying areas of risk & their possible mitigants, and using the credit score as input to decide the price of the credit facilities.• Finally giving the recommendation if financial assistance should be given, the extent of financial assistance and the price of Credit facilities and finalise terms on which Credit facility should be given. • Conduct post sanction visit of the business sites to ensure proper utilization of fund. These visits were also used for cross selling of other banking products and for deepening the relationship with the existing clients.• Did credit appraisal for customers in various business segments like cement, sugar, rice mills, gas-cylinder manufacturer, infrastructure development etc. Also did appraisal of many credit facilities to be financed under government schemes.

Bhubaneswar, Orissa, In

• Cleared 1st Level of CFA Exam• Awarded 2nd prize in Finshastra, a National Level paper writing contest conducted by XFIN, Finance association of XIMB. The paper was on “Foreign exchange market and government intervention”.• Got 98.94 percentile in XAT 2007.

Gurgaon, Haryana, In

Intra-day trading of Short Sterling (Interest rate derivative product based on LIBOR) on London International Financial Futures and Options Exchange (LIFFE)

Mumbai, Maharashtra, In

• Worked as a Software Engineer on .NET framework. • Did development work on C#, ASP.NET, SQL (writing stored procedures), HTML, Javascript.

Master Of Science - Ms, Information Science/Studies

B E, Electrical Engineering

Matriculation, N.A.

I. Sc., Maths, Science

Post Graduate Diploma In Management, Finance, General