Data Analyst with 14 years’ expertise in interpreting data and turning it into actionable insights enabling business improvement
Industry Exposure: Banking, Transportation, Shipping and Logistics
Demonstrated history of driving results, customer focus and managing data complexity
Strong in designing and maintaining data systems and databases; knowledge of database languages such as SQL, R and Python; spreadsheet tools such as Advanced Microsoft Excel; and data visualization software such as Tableau, Power BI & QlikView
Well-developed interpersonal skills and excellent written and oral communication skills
Outstanding customer service demeanor and excellent interpersonal skills.
MS in Data Analytics (Currently Pursuing) from Southern New Hampshire University, New York (GPA: 3.83)
Awards Won:
o Silver Shield Award (September 2018) for providing exceptional logistics and data support for a high-volume client
o Best in US Awards (January 2017) for delivering data insights leading to substantial client saving.
o Exceptional Award for Q4 2016 (April & May) for surpassing district customer service target.
-
Experience
CORE SKILLS
Functional: Data Management | Data Extraction | Data Cleaning | Data Processing | Data Analysis | Data Visualization | Reporting | Dashboard Management | Process Enhancement | Team Training
Technical:
Tools : Adv. Excel (Pivot tables, Power Pivot, Arrays) Power BI, Tableau, QlikView, RStudio, Rattle, Microsoft Visio, Microsoft Project
Database : SQL, Access, Oracle
Programming Language : R, Python
Machine Learning : K-Mean Clustering, Linear Regression, Logistics Regression,
Predictive Modeling, Decision Tree, Random Forest
EMPLOYMENT DETAILS
PACCAR Inc., Bellevue, Washington | Since July 2019 | Data & Reporting Specialist
Fortune 500, largest producer of medium & heavy-duty commercial vehicles and provider of transportation data services
As Data Reporting Specialist, primary responsibility is to
o Extract , transform and load financial data of the franchise
o Generate insights based on assessment and interpretation of the collected information using statistical techniques
o Reporting through Tableau dashboard with focus on financial and sales data
Highlights
Significant contribution in developing supplier programs which streamlined data management process and assisted in management decision making, leveraging financial and sales data
Developed reports using Advanced Excel, Access, SQL Database to extract, clean, merge, transform, compile and load franchise financial data, vehicle information and other relevant indicators for the franchise operations department
Implemented new reporting Tableau dashboards framework
Developed, and published financial reports and franchise profiles in the Area Operations Managers SharePoint
Worked on six sigma projects; promoted innovation and continuous improvement initiatives to analyze data and support conclusions using Lean techniques.
Developed a new reporting tool with the development team to reduce the manual processing time of reports (70 hours to 3 hours)
U.S BANK (GLOBAL DOCUMENTARY SERVICES), Washington | Sep’16-Jul’19 |Compliance Data Specialist
An American multinational banking and financial services holding company
Designed and managed data systems and database; managed Data Processing involving recording information, Maintain and align data in various systems of record; reconcile and validate for data consistency between systems. Utilized statistical tools (Excel & SQL) to interpret data sets, understood the trends and patterns and reported the same to the management team. Prepare reports and monitor exposure related to transactional activity; utilize Excel, Access, SharePoint, and SQL queries
Ensured adherence to the Data Compliance, maintained the confidentiality of the information. Collaborate with internal business line partners to ensure compliance with service standards and deadlines. Lead and execute daily workflow; ensure daily transaction workflow operations are accurate, timely, and efficient
Trained new joiners on Documentary Compliance Checks OFAC, Anti Money Laundering and Anti-Boycott clause on every transaction processed in the systems database
Highlights
Developed new training program with 94% reviews compared to 35% of the previous version (2018)
EDUCATION: MS in Data Analytics (Currently Pursuing) from Southern New Hampshire University, New York (GPA: 3.81) Master’s in Accounting from University of Pune, India (Completed)