Data Analyst

PINAKI DUTTA

Buffalo, NY • 848-***-**** • ********@*******.*** • https://www.linkedin.com/in/pinakid/ EDUCATION

UNIVERSITY AT BUFFALO, THE STATE UNIVERSITY OF NEW YORK Master of Business Administration Jun. 2023

Concentration: Finance, GPA: 3.751/4.00

SRM INSTITUTE OF SCIENCE AND TECHNOLOGY, CHENNAI, INDIA Bachelor of Technology, Civil Engineering May 2011 GPA: 3.76/4.00 (US Equivalent), Graduated First Class with Distinction EXPERIENCE

TATA CONSULTANCY SERVICES LIMITED Edison, NJ, USA

Data Team Lead May 2018-Aug. 2021

• Collaborated with the customer to transform business data requirements for IT Cost Transparency module in TBMS

• Acted as liaison between IT and Corporate Finance to address analytics queries and remove financial roadblocks

• Maintained efficiency in the RFP process by having a thorough understanding of all departmental information

• Coordinated with customers to review monthly billing worth $6M+ and processed those invoices in SAP Fieldglass

• Prioritized team activities to achieve and maintain a highly productive workforce in a deadline-driven environment TATA CONSULTANCY SERVICES LIMITED Chennai, India

Data Analyst Aug. 2016-Apr. 2018

• Streamlined data processing and established data transparency to provide team and data users with accessibility, consistency, and a transparent overview of 100+ data sets

• Automated end-to-end data processing for Bill of IT, reducing month-end close process from 5 weeks to 3 weeks

• Audited journal entries before being posted into SAP General ledger and reconciled IT accounts for corporate finance

• Developed strong relationships across the company and learned how IT and Finance departments work together by preparing analytical dashboards for the Business Relationship Managers TATA CONSULTANCY SERVICES LIMITED Chennai, India

Information Technology Financial Analyst Sep. 2011-Jul. 2016

• Managed IT Project Management Operations (PMO) with projects worth $5M+ and 400+ FTEs

• Coordinated with Business Relationship Managers in project planning activities, monitored and tracked actual revenue numbers, identified risks, and developed a mitigation plan to handle variance with the budgeted amount

• Assessed billing leakage trend and executed a plan to reduce it, resulting in a 2% increase in profitability every quarter ACADEMIC PROJECT EXPERIENCE

• Applied economic concepts to determine if Costco Wholesale Corporation should continue to grow or rather contract

• Assessed New Heritage Doll Company’s finances by calculating financial metrics - NPV, IRR, and Payback Period

• Developed Excel-Data model and performed multivariable sensitivity analysis for Eagle Airlines case study SKILLS

Advanced Excel – Data modeling, Microsoft Office suites (Excel, Outlook, PowerPoint, and Word), Apptio, Jira, SAP Fieldglass CERTIFICATIONS

Bloomberg Market Concepts (BMC), AZ-900: Azure Fundamentals, DP-900: Azure Data Fundamentals, APPTIO Elite TBMA, APPTIO Recognized TBMA, AINS 21

PROFESSIONAL DEVELOPMENT

• Member of ‘American Finance Association’

• Completed two online analytical courses on ‘Data Analysis and Financial Modeling’ and ‘Data Science’ using R & Excel ACTIVITIES

• Volunteered to create Inspirational Message for Covid-19 Healthcare Workers for White Plains Hospital, NY

• Earned the Performance-Based Scholarship Award for being a top 10% performer in SRM University

Contact this candidate