| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Edison, New Jersey, United StatesPHONE NUMBER AVAILABLEEMAIL AVAILABLELINKEDIN LINK AVAILABLESUMMARYSenior BI & Reporting professional with 10+ years of experience in interpreting and analyzing complex data sets, data modeling, statistical analysis and data visualization. Skilled in using SAS, SQL, Python, ACL, Excel, Tableau and Power BI for data analysis and reporting. Strong worth ethic, adaptability and exceptional interpersonal skills. Adept at working effectively unsupervised and quickly mastering new skills. WORK EXPERIENCEOctober 2021-August 2023Business Decision Support Professional Level II - Supply ChainBC HydroVancouver, British Columbia, CanadaSupply Chain Analytics and Reporting End to end Project management as the SME - developed and implemented interactive Tableau Enterprise-wide dashboards and reports to provide real-time visibility into key performance indicators (KPIs) using the broad knowledge of enterprise reporting platforms and various data sources. Applied analytical skills on large volumes of datasets and transformed them into customized visual reports - ETL using SAP BW, SAP AFO, Base SAS, SAS EG, Tableau and Power BI to derive, interpret, visualize, and present insights from SAP BI reports. Conducted research, assessed data needs, collected data, and performed analysis to support Supply Chain function, procurement strategy development and execution to build KPI metrics Scorecard and Invoice payment cycle time reporting. Extensively used SAP AFO for data extraction, maintaining them on shared drive and refreshing daily to maintain master datasets. Building and continuously improving KPI metrics as the data and reporting expert to track Visibility & Financial Control, Organizational Productivity, Process Efficiencies and Material Management, for benefits realization of SCA program to be presented to Executives, Directors and Business Unit leads. Lead development of Supply Chain analytics projects while collaborating with cross-functional teams and stakeholder groups utilizing various methodologies to assess reporting and analytics requirements and ensure delivery of impactful visualizations to support business needs. Involved in translating business insights into strategic, actionable options by obtaining and organizing key business information from all main data sources and provide insights on Spend analytics, purchasing trends, cost savings opportunities, and supplier performance enabling informed decision-making. Rolling out the interactive Tableau scorecard and deep dives to different teams, gathering feedback and adding new features upon request. Occasionally worked as Business Analyst, discovered and gathered the reporting gaps, identified solution alternatives for Supply Chain reporting by facilitating walkthrough meetings with cross functional business groups (SC Policy and Financial Reporting) and maintained reporting requirements documentation. Planned, organized, and conducted data quality audits to identify gaps, data issues and implemented solutions. Extensive experience in JIRA testing, actively participating in various development releases. Proven track record of effectively collaborating with development teams, providing valuable user insights. Excellent documentation capability and ability to communicate technical advice and guidance to stakeholders on reporting and analytics solutions.December 2018-September 2021Senior ConsultantDeloitteVancouver, British Columbia, Canada Solid experience in developing custom analytical solutions for various fortune 500 clients implementing SAS99(Statement on Auditing Standards No. 99) routines on clients financial statements, fraud checks, regulatory compliance, internal controls testing, and risk management. Experience on various Canada based technology and financial services companies on regulatory compliance projects in terms of internal controls over technology, financial reporting, and corporate governance. Certified Information Systems Auditor (CISA) professional with years of experience in oversight of risks and controls; maintenance and oversight on the issues, Corrective Action Plans and Risk Exceptions; maintain risk and control and policy awareness within the supported teams. Worked as Senior IT Specialist on SOC 2 and SOX audits for latest and legacy systems with key responsibilities of performing walkthroughs with clients, developing in-depth understanding of the processes and systems, documenting the procedures, identifying key gaps in the process flow, and providing recommendations to the client. Key member of the IT Operational Risk team performing and overseeing General IT Controls testing for big accounts. Assisted Financial Audit teams in comprehending and auditing scripts such as Python, SQL and Shell, as well as the results obtained from clients via these scripted languages. Assisted clients in identification of data quality related issues and potential fraud in client financial statements using ACL. Collaborated with business heads to build customized solutions using advanced data analytic technique and Tableau dashboards to provide actionable insights to drive operational excellence for financial data as well as GITC data validation. Worked as RPA developer - configured bots using Blue Prism to automate manual fee follow up processes in SIS for a reputed College in Ontario region. Reducing turnaround time of 500 hours every year. Worked on Integrated Renewal Program Security for a University in BC involved in developing in-depth understanding of the processes that support the authentication and authorization activities as part of the security sustainment of Workday. Led Regional Analytics leader role in the firm overseeing SAP data extraction and processing with rich experience on SAP system. Key coordinator between Clients and oversees teams. June 2013-August 2018Team LeadDeloitte & Touche LLPGurgaon Sector 17, India Assisted clients in identification of data quality related issues and potential fraud in client financial statement. Strong experience in Computer Aided Audit Techniques (CAAT) using SAS, ACL, Tableau and Deloitte in-house tools. The key responsibilities involved data quality assessments and developing solutions to meet client's business requirements. Developing scripts in SAS and ACL to examine journal entries (including reconciliation on journal entries) and other adjustments for evidence of possible material misstatement complying with PCOAB audit guidelines and SAS99 issued by AICPA which covers the associated risk of management override of controls and fraud in financial statements. Reviewing accounting estimates for biases that could result in material misstatement due to fraud. Evaluating the business rationale for significant unusual transactions. Visualization and reporting of data trends and anomalies. Presentation to leaders and clients with actionable insights Ability to take ownership and work independently. Core member of Deloitte in-house tools testing team which automates fraud analysis on clients general ledger data, reducing overall turnaround time by over 50%. Collaborated with business heads to test customized solutions using advanced data analytic technique to provide actionable insights to drive operational excellence. Built reusable analytical solutions using SAS and Tableau in the areas of Accounts Payable, Accounts Receivable, General Ledger, GITC testing etc. The solution helped client identifying key deficiencies in Period closing and Accounts Review Process gaining in efficiency of over 20%. Tool Development: Worked on development and functional testing of General Ledger analytics ACL based tool which automates fraud analytics on clients journal entry data. Identified and fixed major bugs in the old tool. This tool is deployed on more than 200 audit clients annually, around 10,000 hr. Leadership & Training. Led 6 members, multi geographical team, driving the implementation of journal entry testing using Deloitte in-house tools on over 30 audit engagements. Managed portfolio of ~$2.5M revenue. Have worked with complex datasets to analyses, interpret and visualize providing actionable insights. Received 2 Client Appreciation Awards for tremendous value addition to the clients. Trained and mentored 30 new recruits in SAS, Tableau and ACL, around 200 hours of boot camp training. EDUCATION2009-2013Bachelors of TechnologyJNTU College of EngineeringHyderabad, India Technology, Electrical & ElectronicsSKILLSBusiness Intelligence Data Analysis Data Mining Data Modeling Database Extract Transform and Load (ETL) Data Quality Statistical Analysis System (SAS) SQL (Structured Query Language) Python Programming/Scripting Language Data Visualization Tableau Power BI SAP Decision Support Supply Chain Metrics CISA - Certified Information Systems Auditor Auditing Detail Oriented RPA Oracle Requirements Management Microsoft Excel Microsoft Access Database Microsoft Visio Microsoft Word Microsoft SharePoint Microsoft PowerPoint Automation Team Lead/Manager Statements on Auditing Standards (SAS) Sarbanes-Oxley Act (SOX) General Ledger Accounting Stakeholder & Project Management Reporting Dashboards Organizational Skills Reconciliation Financial Reporting Risk Management Financial Services Financial Audit Statistics Documentation Purchasing/Procurement Corporate Governance Process Flow Project/Program Management Communication Skills Corrective Action Regulatory Compliance Cross-Functional Business Support Business Strategy Scorecarding Business Analysis Financial Fraud Information Technology & Information Systems Scripting (Scripting Languages) Time Management Mentoring Computer Programming Interpersonal Skills Validation Testing Business Processes Team Player Vlookups SAP NetWeaver Business Warehouse Consulting Storytelling Supply Chain Analytics Team Building Executive Relationships Presentation/Verbal Skills Workflow Analysis Performance Metrics SAP BusinessObjects Business Intelligence (BI) Data Collection Analysis Skills Improvement Metrics Documentation Plan Data Sets Strategic PlanningCERTIFICATIONSSAS Certified Programmer SAS 9Certified Information Systems Auditor (CISA)LANGUAGESEnglish - Fluent Hindi - Fluent |
