VARUN KUMAR LEAD Business Analyst || B2B-ARU || Bajaj FinServ
https://www.linkedin.com/in/varunkumar4 [email protected]
91-7506112183
A Data Analyst with 9+ years of experience in information systems, delivering multiple responsibilities, combining
technology & management in the analytics product development in the Financial, Antifraud, Internal Audit, Supply
Chain and Software space. Expertise in creating ETL process flows (staging, facts, and dimensions), data analysis, data
warehousing, process validation and business needs analysis. As a data scientist, manage the processes & responsible
for accurate data collection, processing, modelling, and analysis for internal and external uses.
Highly responsible for maintaining, improving, cleaning, and manipulating of data in a business’s operational or
analytics data systems. Ability to see solutions in broad data sets and the business mindset to convert insights into
strategic opportunities and action for our customers. As an analytics Manager will work closely with leaders across
product, sales, and marketing to support and implement high-quality, data-driven decisions that deliver value to our
customers.
CORE COMPETENCIES:
Vendor Management, Data Visualization, Business Development, Business Analysis, Technical Support,
Database Management, Team Leadership, Data Analysis, FPNA
Skills:
SQL, Enterprise Data Warehouse (EDW), Business Intelligence, Automations, SDLC, Python, Jira, MS Excel, Audit
Analyst, Power BI, OBIEE, Tableau, ETL Process Flow, Data Lake
Career Growth
Bajaj FinServ Lead Business Analyst Pune May 2023- Current
• Created/Managed Projects, Database Views, Data Sources and Data Connections.
• Developed data visualization using Cross tabs, Whisker charts, Bar charts, Pie charts, Geographic map & density chart
• Communicate results and business impacts of insight initiatives to stakeholders within and outside of the company.
• Oversee the design and delivery of reports and insights that analyse customer data w.r.t ARU Urban.
• Designed & Build automated Business Intelligence frameworks and monitor seamless execution of the reports down the line.
• Fulfilled the Business data requirement with the help on historical data analysis.
• Data analysis and insight provided for ‘AOP’ and ‘Long Run Strategy (LRO)’.
• Provided Analyzed customer details where lock voucher use for giving the Reward to customer.
Home Credit India Finance Pvt Ltd Manager Gurgaon Jul’2019- May’2023
• Outsourcing and Vendor selection process. Tool's strategy, its vendor selection and implementation at Group level.
• Performed in-depth data analysis on data from various sources like internal production data also from database
• Preparing Dashboards/Reports for monthly business review calls with client.
• Analysing the data with respect to production & quality issues. Also, performance of the associates.
• Develop dashboards and visualizations that empower decision makers.
• Build, customize and publish interactive reports, visualizations, and dashboards.
• Data Loading, Cleaning & Pre-processing to visualize the data in effective way.
• Also creating graphs by using Measures & dimensions data from various databases by using data blending concept.
• Utilized Tableau server to publish & share the reports to the End/Business user.
• Work on all aspects of the engineering of the service, including such topics as performance, dashboard design & tuning.
• Demonstrated translate a question into a visualization which provides insight and answers the question.
• Interact directly with Audit Managers and their staffs, Business process owners, Finance, and IT to design and implement
data analysis solutions. Continually re-assess these solutions in efforts to make them more efficient and effective.
Imkemex Marketing Pvt Ltd Senior Analyst Mumbai Jun’2017 – Jul’2019
• Designed and developed customer contact system, customer complaint management system and Inventory management
systems for the stocks.
• Cost-Benefit Analysis for new systems to be presented to the senior management.
• Did Root cause Analysis of problems and suggesting improvements to product and operations based on insights
• Developed analytical models to assess the impact of changes to pricing and products on business profitability and scale
• Developed and monitored the SLAs for the vendor providing centre support.
• Review and produce weekly and monthly reports to the senior management to understand the purchase trends
• Worked and assisted CRM process owners and analysts in the regional sites for their reporting needs.
• Developed business process design, configuration, implementation, and documentation stages.
• Utilized Tableau server to publish & share the reports to the End/Business user.
• Communicate results and business impacts of insight initiatives to stakeholders within and outside of the company.
• Oversee the design and delivery of reports and insights that analyse customer data.
Alisail Logistics Pvt Ltd COO Mumbai May’2015 – Jun’ 2017
• Headed Profit and Loss for Alisail logistics with a team size of 200+ employee.
• Built Strategic Alliances by Onboarded 10 new vendors across E-commerce (Amazon, Flipkart, Mantra, koovs, Shopclues),
Courier (FedEx, Aramex, Bluedart), Cold Chain (Star Bazar, Cold Chain, yumlane) for their supply chain management.
• Coordinated with cross-functional teams to ensure achievement of key metrics (Data analysis, Key Account Management, SLA
adherence & performance matrix).
• Formulated SOPs for various logistic processes (First Mile, Last Mile, Reverse Process, Inventory etc.)
• Involved in Key decisions on deal plans, price points for promotions and aligning inventory process guideline
• Meet clients and designed solutions to meet their business requirements & implement processes for as per customer
requirement matrix.
• Structured concise reports with insights supported by solid analytics and logical thinking over daily deliveries.
• Involved in business development, marketing, BTL, quality standards, vendor development & management and customer
experience
• Created city level supply chain, managed vendor on-boarding, defined SLAs, pricing, tracked financial & qualitative
performance to achieve operational excellence.
• Developed and implemented end to end process for procurement, delivery, information flow and cash flow.
Cisco System India Software Engineer Bangalore May’2010- May’2013
• Automated testing & development process for one of the product features under the High Edge Routing Unit.
• Accumulated knowledge on the specifications of different features under qualification and indulged in reviews with functional
teams, formulated test cases and build customer topologies for testing.
• Designed and implemented automation solutions in Automation life cycle, which achieved cost savings of up to 20%.
• Developed and implemented end to end process for ASR-9K, delivery, information flow and testing life cycle flow.
• Enhanced and modified the existing business application of Router Network product named ‘R_7500- Series’
Godrej Consumer Product Ltd Internship Baddi (H.P) May’2014 – July’2014
Productivity Improvement of Godrej Soap Manufacturing Facility
Worked process improvement of daily operations in soap lifter to minimize soap material wastage. Productivity improvement through
reduction in wastage recycle soap materials & manufacturing.
Education & Certifications:
• MBA -Mumbai, General Management.
Completed two years General Management from Shailesh J Mehta School of Management, IIT BOMBAY.
• B. Tech – Computer Science & Engineering
Completed four years Degree in B. Tech, (Computer Science and Engineering), National Institute of
Technology, Tiruchchirappalli (NITT).
• Certified Google data Analytics by Coursera.
• Interconnecting Cisco network Device (ICND-1 & ICND-2).
• Lean Six Sigma Green Belt Certificate Holder.
• Won 1st Prize in Logistic Simulation Game at management Level competition Organized by Asian Paints.
• Won 1st Prize in Volleyball Tournament at different Level (Regional State Level, Corporate & College Level).
Brief About me: Am a good listener and quick learner too. Work smartly to reach the goals and target and Team
Player & Leader too. Always intends to learn more about new technologies and subjects. Thinking positively and
keeping Calm is my attitude.
Place: Pune VARUN KUMAR
