MS EXCEL
Deepak Sharma
Accounts Payable Analyst
Gurgaon
Summary
Detail-oriented Accounts Payable Analyst specializing in utility invoice processing, vendor reconciliation, and financial reporting. Managed high-volume Electricity, Water, and Natural Gas invoices through SAP Ariba and SAP ERP, ensuring payment accuracy and compliance, while delivering analytical reports and dashboards that support ESG and sustainability initiatives. Contributed to process improvements and enhanced operational efficiency through collaboration with international clients and stakeholders.
Overview
3
3
Languages
2
2
Certifications
2
2
years of professional experience
Work History
Analyst
Jones Lang LaSalle, JLL
12.2023 - Current
- Process and validate utility invoices (electricity, water, and natural gas) through SAP Ariba, ensuring accurate and timely payment processing.
- Managed end-to-end accounts payable activities for IBM utility accounts across United States and Canada, ensuring accuracy and compliance throughout the process.
- Review, verify, and reconcile vendor invoices while ensuring compliance with financial controls and company policies.
- Perform vendor reconciliations, and resolve invoice discrepancies, payment issues, and billing exceptions.
- Generate and analyze Missing Bills Reports to identify outstanding invoices, and ensure complete utility expense reporting.
- Process utility invoices for IBM Canada through the APU system, in accordance with regional payment procedures.
- Utilize SAP ERP transaction codes, including FB01, FB60, FV60, FB08, FBV0, FBL1N, and FBL3N, for invoice processing, account analysis, document management, and reconciliations.
- Developed and maintained Power BI dashboards to monitor vendor performance and invoice status, enhancing visibility into utility spend and operational KPIs.
- Prepare and deliver utility consumption, financial, and vendor reports to clients, stakeholders, and management teams.
- Support IBM's sustainability and ESG initiatives by managing utility and environmental data within the Envizi platform.
- Collaborate with cross-functional teams to improve invoice processing efficiency, reporting accuracy, and process compliance.
- Engage directly with international clients and stakeholders across North America, facilitating effective communication, issue resolution, and business relationship management.
- Conduct stakeholder meetings, and provide operational updates, reporting insights, and process recommendations to client teams.
- Coordinate with vendors, utility providers, and global stakeholders to resolve billing disputes and payment-related inquiries.
- Ensure data accuracy, audit readiness, and compliance with organizational and client requirements.
- Analyzed utility spending trends and provided data-driven insights that supported business and sustainability objectives, informing strategic decision-making.
- Utilize advanced Microsoft Excel functions, including XLOOKUP, VLOOKUP, INDEX-MATCH, SUMIF, Pivot Tables, Power Query, and Macros, for financial analysis, reconciliations, and reporting.
- Create automated reports and dashboards using Excel and Power BI to enhance operational efficiency and decision-making.
- Perform large-volume data analysis, validation, and reconciliation using advanced Excel techniques.
- Leverage advanced Excel keyboard shortcuts and productivity tools to improve reporting efficiency and data management.
- Improved internal knowledge sharing by developing comprehensive documentation outlining standard operating procedures for various tasks.
- Enhanced team collaboration by providing clear communication of complex findings through visualizations and reports.
- Collaborated with cross-functional teams to identify opportunities for process improvement and increased efficiency.
- Implemented predictive analytics techniques that enabled proactive adjustments to business strategies based on emerging trends.
- Increased efficiency by streamlining data analysis processes and implementing automation tools.
- Enhanced report accuracy, conducting thorough data audits on a regular basis.
- Reduced errors in data entry, instituting rigorous quality control checks.
- Optimized operational efficiency by redesigning workflow processes.
- Facilitated workshops on data visualization tools, enhancing team's reporting capabilities.
Education
High School Diploma -
Saini Sr. Sec. School
Rohtak, India 04.2001 -
GED -
Maharishi Dayanand University
Rohtak, India 04.2001 -
Skills
Data analysis
Data visualization
Statistical analysis
Data interpretation
Excel
Excel proficiency
Microsoft Office
Analytical thinking
Critical thinking
Process improvements
Time management
Accomplishments
• Received Recognition Certificate from U.S.-based stakeholders for consistently delivering accurate utility data, maintaining high-quality standards, and ensuring exceptional accuracy in reporting and invoice processing.
• Earned Lean Certification from the Continuous Improvement Team for developing and implementing a Power BI/PO Dashboard solution that improved data visibility, reporting efficiency, and operational tracking.
• Recognized by the organization for outstanding performance, commitment to operational excellence, and consistent contribution to team objectives and business goals.
• Successfully collaborated with international clients and stakeholders across North America, building strong relationships through effective communication, problem-solving, and reliable service delivery.
Software
Power BI
Envizi
Schnedier Cass
Capturis Utility Bill Processor
SAP
Certification
SAP ERP
Interests
Singing
Gymming
Travelling
Spirituality
Philosophy
Timeline
Analyst
Jones Lang LaSalle, JLL
12.2023 - Current
SAP ERP
05-2023
Harton Diploma
11-2022
High School Diploma -
Saini Sr. Sec. School
04.2001 -
GED -
Maharishi Dayanand University
04.2001 -