Pankaj Sehgal
Faridabad
Summary
Driven Senior Consultant with 15 years' experience in the Finance consulting field. Adept in collaborative problem solving, risk management and creative solutions. Passionate about bringing changes in businesses. Proficient in conducting primary and secondary research.
Thorough Senior Consultant professional with competency in developing project and implementation plans. Gifted with strong analytical and project management skills. Successful in meeting new challenges and finding effective solutions.
As an expert in Power platform, designed interactive dashboards, APPs and flows that transform raw data into actionable insights, proficient in creating resource-efficient ETL using Python, Data flows and Datasets, ensuring data flows smoothly from source, successfully overhauled legacy SQL databases, optimizing query performance. Always ensure data integrity, consistency, and efficient retrieval. As an Excel aficionado, manipulate data, create complex formulas, and visualize trends. Automating tasks using VBA, enhancing productivity across teams. Continuous learning which expanded skills in Python toolkit. Embarking on an exciting journey into the world of artificial intelligence, I'm eager to explore its applications. Adept at bridging technical and non-technical communication gaps, excelled in stakeholder engagement. Collaborative relationships are key to successful projects. Experienced in leading teams, refining agile processes, and ensuring project efficiency. Meticulous documentation ensures knowledge transfer and best practices. In summary, thrive on solving complex challenges, transforming data into actionable insights, and driving organizational success.
Overview
17
17
years of professional experience
1
1
Certification
Work History
Sr. Consultant BI
Hitachi Vantara
Pune
11.2022 - Current
- Senior BI Consultant, specializing in Power BI development, crafting comprehensive dashboards, apps, and flows integrating diverse data sources including SQL Server, Enterprise Data Platforms (EDP), and Excel.
- Mentored junior consultants, helping them enhance their skills and contribute more effectively to projects.
- Delivered high-quality solutions for clients through comprehensive research and analysis of industry trends.
- Presented findings and recommendations to executive-level stakeholders, effectively communicating key insights and action plans.
Group Manager WFM
WNS Global Services
Gurugram
06.2022 - 11.2022
- Reporting and Analytics for workforce management, optimizing customer interactions across the Manila market in a high-pressure, fast-paced setting.
- Optimized resource allocation by identifying underutilized assets and reallocating them effectively within the organization.
- Drove organizational change initiatives that resulted in streamlined operations, improved employee morale, and increased efficiencies throughout the group.
- Led cross-functional teams and to achieve project milestones, ensuring timely completion and adherence to budget constraints.
- Monitored team performance to identify productivity improvement opportunities.
Lead Business Analyst
AMERICAN EXPRESS
Gurugram
07.2019 - 06.2022
- Spearheaded Reporting and Analytics for regulatory compliance across 24+ markets, ensuring swift execution in high-stakes environments.
Assistant Manager RPA
WNS Global Services
Gurugram
04.2017 - 06.2019
- Automation of Reports, Applications (Main Frame, Web and Windows) & Process steps which includes requirement gathering, validations of specification and test cases for converting requirements into technical specifications.
- Developed strong working relationships with staff, fostering a positive work environment.
- Mentored junior staff members in their professional development by offering guidance/support in their assigned roles.
- Facilitated clear communication between employees and upper management through regular meetings and updates.
- Planned, created, tested and deployed system life cycle methodology to produce high quality systems to meet and exceed customer expectations.
Data Processing Lead
Eli Research
Faridabad
10.2015 - 03.2017
- Lead team of 10 members and manage all processes.
- Maintained and referenced training documentation for entry process.
- Quickly learned new processes and systems and kept current with procedural enhancements.
- Completed time-sensitive data entry requests.
- Created detailed reports on key metrics and KPIs, informing stakeholders of progress towards organizational goals.
- Trained team members on best practices for data processing, improving overall productivity and efficiency within the department resulting 60 percent downfall in errors.
Sr. Executive MIS
WNS Global Services
Gurugram
06.2013 - 07.2015
- Automation of Reports/Dashboards & client's process as per clients request which includes requirement gathering, specification of validations and test cases for converting requirements into technical specifications.
- Spearheaded development of innovative products, positioning the teams as a leader in its segment.
- Managed large-scale projects with budgets exceeding $1 million, ensuring completion within specified timeframes while adhering to strict quality standards.
- Participated in Lean Six Sigma initiatives, contributing to continuous improvement efforts within the organization. Leading to improved workflows and reduced $30K costing.
E-marketing/MIS Executive
TOURAM-IT
Noida
08.2007 - 07.2013
- Developed various reports for MIS purposes through coding of various universes and Business Objects.
- Improved data accuracy by streamlining the collection, analysis, and reporting of critical business metrics.
- Generated reports each month covering sales data.
Education
1 Year Diploma in DDNTR2- Software Development - Computer Software (Csharp)
NIIT
Faridabad01.2013
Bachelor of Commerce - Commerce
Delhi University
New Delhi01.2011
Skills
- Power BI / Tableau (Business Intelligence Software)
- Python (Programming Language)
- Visual Basic For Applications
- SQL (Programming Language)
- Team Management
- Data Processing, Mining, Quality
- Digital Transformation
- Teamwork Mindset
- Data Analytics Finance
- Client Engagement
- Analytical Thinking
Languages
Hindi
English
Jobtitle
Sr. Consultant BI
Certification
Microsoft Office Specialist Master
BluePrism Accrediated
Timeline
Sr. Consultant BI
Hitachi Vantara
11.2022 - Current
Group Manager WFM
WNS Global Services
06.2022 - 11.2022
Lead Business Analyst
AMERICAN EXPRESS
07.2019 - 06.2022
Assistant Manager RPA
WNS Global Services
04.2017 - 06.2019
Data Processing Lead
Eli Research
10.2015 - 03.2017
Sr. Executive MIS
WNS Global Services
06.2013 - 07.2015
E-marketing/MIS Executive
TOURAM-IT
08.2007 - 07.2013
1 Year Diploma in DDNTR2- Software Development - Computer Software (Csharp)
NIIT
Bachelor of Commerce - Commerce
Delhi University