Angad Singh Email & Phone Number

Canada

Toronto, Ontario, Canada

Toronto, Ontario, Canada

Toronto, Canada Area

Payroll Anomaly Detection Implementation, Ontario's largest electricity transmission service provider: Designed and led the development of the Payroll Leakage Detection tool built on Tableau, SQL and Python to identify, cluster, track, and manage sources of payroll leakage for a client with 15k+ employees, quantifying anomalies in time reporting, duplicate payments, ghost employees, payroll misuse and fraud contributing to 1.5% of total Payroll. Patient Support Program Assessment (PSP) & Fraud Analytics and Drug Distribution Anomaly Detection, 5+ Pharmaceutical companies: Specialized in managing rules based PSP assessments to identify areas of high risk, loopholes in policy controls and potential frauds for pharma clients, successfully delivered 5+ engagements in 2020/21. Covid-19 Procurement analytics, Govt of Canada’s: Led the delivery team for the Govt of Canada’s Covid-19 procurement analytics project and developed the data strategy focused on cleansing, enriching, categorizing, risk profiling and triaging of supplier’s applications, enabling the govt to perform risk-based supplier screening to focus on priority applications.Purchase Order Anomaly Detection, Canada’s Largest Telco: Acted as a lead ODI / SQL developer to deliver a fully automated PO Anomaly detection tool leveraging SQL, Oracle Data integrator and Tableau, enabling the client to discover, quantify and recover 1.5% - 3% of PO excess payments identified as anomalies due to fraudulent contractor's timecard submissions, duplicate payments, systematic errors etc. Lease Accounting Software(CoStar) Implementation, Canadian Software Company and Canadian Telco: Acted as a PM on the CoStar Real Estate Manager Lease Accounting software implementation engagement and brought the project through the all SDLC phases such as requirements gathering, design, development, UAT and into Go-Live. Successfully migrated over 4000 leases leases worldwide that were subjected to the ASC 842/IFRS 16 standards

Greater New York City Area

C1- External Audit Support (PwC NY) - CAATs, Multiple Banking and Insurance Clients: Performed quarterly audit support analytics such as SAS99 Journal entry Testing, Premiums/Claims reconciliations, Contract analytics, Insurance’s reserve loss triangles reconciliations for over 20 financial services clients with multiple entities, providing over 100 + deliverables to audit teams on yearly basis.

Greater New York City Area

Greater New York City Area

• Performed Journal ledger role forwarding and SAS99 testing for several clients using ACL, Oracle and SQL. • Assisted senior associates, managers and directors during the walkthroughs to document business processes and requirements accurately.• Developed SQL scripts and macros to check data for integrity, validation, completeness and accuracy. • Designed complex monarch models and executed data conversions for unstructured data.• Extracted, transformed and loaded data to and from oracle SQL servers using batch files.• Conducted SAS99 and other CAAT tests as part of audit engagements. • Re-performed several policy re-calculations for insurance clients to provide reliable assurance around the policy calculations.

New Delhi Area, India

• Provided Tier I/Tier II IT Support for all users, board of directors and other executive staff by troubleshooting software, hardware, and networking issues.• Overseen office inventory for all equipment, including the storage and ordering of new devices (printers, faxes, workstations, VoIP Phones & mobile devices) & performed necessary upgrades to all software & hardware.• Supported AV conferencing calls on various AV systems like Polycom, Tandberg, Lifesize and codian.

New Delhi Area, India

• Managed critical clients like Providence Equity & Wolters Kluwer effectively that influenced clients to extend IT support contract duration to next 3 consecutive years, adding 30 % to the company`s revenues. • Supported operations like TCP/IP, Desktop Support, Software Upgrades, EPABX, Video Conferencing etc. • Provided IT support in domestic & global offices (UK, NY, Hong Kong, Providence, Beijing, Australia).

Master Of Science (Ms), Information System - Business Analytics, Gpa 3.958

Activities and Societies: • Founded Fordham Business Analytics Society and headed the club as the Vice President of Operations.

B.Tech, Information Technology

Diploma, Electronis And Telecommunication