Sunil Khokhar
Noida
Summary
Seasoned BI Consultant with 16 years of experience in data analysis, MIS reporting, and business intelligence solutions using Tableau. Proficient in leveraging data-driven insights to drive strategic decision-making and optimize business processes. Adept at translating complex data sets into clear and actionable visualizations. Strong problem-solving abilities and a deep understanding of data modeling and database management. Seeking to utilize my expertise to deliver valuable business insights and drive continuous improvement.
Overview
17
17
years of professional experience
Work History
Senior Consultant – Business Intelligence
EXL Services India Private Limited
Noida
09.2015 - 08.2023
- Maximized performance by monitoring daily activities and mentoring team members
- Extracted, transformed, and loaded (ETL) data from various sources to create comprehensive datasets for analysis and reporting
- Created and optimized SQL queries to extract and analyze data from databases
- Conducted data cleaning, transformation, and validation on large datasets to ensure data integrity and accuracy
- Designed and implemented data models for data warehousing, enabling efficient data storage and retrieval
- Used industry expertise, customer service skills, and analytical nature to resolve customer concerns and promote loyalty
- Collaborated with cross-functional teams to define key performance indicators (KPIs) and create interactive dashboards using Tableau, enabling stakeholders to make data-driven decisions
- Accomplished multiple tasks within established timeframes
- Cross-trained existing employees to maximize team agility and performance
- Launched quality assurance practices for each phase of development
- Conducted thorough data analysis to identify trends, patterns, and opportunities for business improvement
- Developed and maintained interactive MIS dashboards and reports using Tableau to facilitate data visualization and analysis
- Presented findings and recommendations to executive management and key stakeholders
- Oversaw data visualization projects for Insurance and Banking clients, delivering comprehensible and invaluable visuals for presentation to audiences of different technical understanding
- Participated in BI tool evaluation and selection processes to improve data analysis capabilities.
Assistant Manager –MI
Steria India Private Limited
Noida
03.2014 - 09.2015
- Responsible for project initiation activities including the initial setup and project kick-off
- Automated existing reports in Tableau and VBA
- Shared reports with top management as per the agreed SLA
- Sent reports to the project managers along with portfolio managers, which give the status of tasks and projects under a portfolio
- Resolved support/operational issues in liaison with project managers & business groups
- Consolidated weekly status updates from streams and issued weekly status reports
- Managed work order management closely monitoring the work package status and the finances incurred against each work order
- Sent Timesheets failure report through Navigator to relevant project and portfolio managers to ensure no non-compliance of timesheets.
Software Engineer
Brightleaf India Private Limited
New Delhi
02.2012 - 03.2014
- Worked with software development and testing team members to design and develop robust solutions to meet client requirements for functionality, scalability, and performance
- Installed and configured software applications and tested solutions for functionality
- Reviewed project specifications and designed technology solutions that met or exceeded performance expectations
- Coordinated with other engineers to evaluate and improve software and hardware interfaces
- Wrote highly maintainable, solid code in VBA for software system, forming core framework and earning consistent praise from subsequent developers since initial version
- Adjusted design parameters to boost performance and incorporate new features
- Gathered and defined customer requirements to develop clear specifications for project plans
- Checked client code for bugs and weaknesses using approved troubleshooting methods
- Revised, modularized, and updated old code bases to modern development standards, reducing operating costs and improving functionality.
Analyst - Sales Operations
COLT Technologies India Pvt. Ltd
Gurugram
12.2010 - 07.2011
- Automated the existing reports using VBA/SQL
- Validated results and performed quality assurance to assess accuracy of data
- Queried databases for information needed for report processing
- Documented procedures and business processes and shared information with appropriate stakeholders
- Researched and recommended process improvements designed to mitigate operational and financial risk
- Ensured that the processes and supporting procedures are accurate and that the integrity of the data is maintained in the COLT systems
- Generated regular reports for the sales community
- Reconciled commission's payouts with company P&L figures
- Coordinated with Sales Ops and account executives to resolve queries on monthly commission payout figures
- Provided ad hoc reports to business as per the requirements.
Senior Analyst – MIS
Patni Computers Systems Ltd.
Noida
01.2007 - 12.2010
- Oversaw installation of software programs and hardware systems to meet requirements
- Did the coding for the assigned part of the project in VBA
- Prepared daily, weekly, and monthly key performance measurements (KPIs) reports of the process, which include different parameters like ACV, CSAT, SLA, AHT, and Quality parameters
- Gathered the raw data of the process and made the summary of reports for particular teams and members
- Ensured data management and MIS preparation for middle and top management
- Created/design reports for new/existing clients as per need
- Prepared project documentation and information.
Education
MCA: Computer Applications -
BSAITM (MDU Rohtak)
01.2005
Bachelor of Science: Science -
S D College(KUK)
01.2001
Skills
- Tableau
- SQL
- Power BI
- Excel VBA
- Python
- SAS
- SAP BO
- Azure
Timeline
Senior Consultant – Business Intelligence
EXL Services India Private Limited
09.2015 - 08.2023
Assistant Manager –MI
Steria India Private Limited
03.2014 - 09.2015
Software Engineer
Brightleaf India Private Limited
02.2012 - 03.2014
Analyst - Sales Operations
COLT Technologies India Pvt. Ltd
12.2010 - 07.2011
Senior Analyst – MIS
Patni Computers Systems Ltd.
01.2007 - 12.2010
MCA: Computer Applications -
BSAITM (MDU Rohtak)
Bachelor of Science: Science -
S D College(KUK)
Similar Profiles
Mayank HajelaMayank Hajela
Manager, Band C1 at EXL Services (India) Private LimitedManager, Band C1 at EXL Services (India) Private Limited
Shubham KumarShubham Kumar
FRAUD RISK INVESTIGATOR FRENCH SPECIALIST ACCOUNTS at Amazon Development Center India Pvt. LtdFRAUD RISK INVESTIGATOR FRENCH SPECIALIST ACCOUNTS at Amazon Development Center India Pvt. Ltd
Pradeep SharmaPradeep Sharma
Senior Manager - Finance (FP&A) at Genpact India Pvt Ltd.Senior Manager - Finance (FP&A) at Genpact India Pvt Ltd.