RITISH SADANA

647-***-**** ac84zl@r.postjobfree.com

SUMMARY

Business Analyst with 5 years of experience in technical and operational aspects of financial services industry with proven skills in business and functional requirement gathering, analysing requirements, documentation, business process re- engineering, and project management in public domain.

Experienced in all phases of the Product Development Life Cycle: Business Analysis, GAP analysis, Product & Feature Roadmap, Measuring KPI’s and Project Management across Analysis, Design, Development, Testing and Delivery.

Highly proficient in data analysis and BI tools such as SQL and Power BI with advance/expert level skills in MS Excel, MS Access and project management software such as MS Project for prioritizing and managing business tasks.

Skilled in writing documents like BRDs, FRDs, User epics & stories, Use Cases, Scope and Project Plan Documents.

Exceptional understanding of information security concepts, simulation and modelling as well as database management techniques using different software and tools like Arena, Access and SQL.

Strong understanding of various SDLC methodologies (Waterfall, Agile-Scrum) along with ITIL framework & ITSM processes.

Self-motivated, highly creative individual possessing a keen attention to detail and dependable with excellent analytical and presentation skills.

Very good communication and interpersonal skills with comprehensive knowledge of system and presentation software applications and adept at working on various operating systems and platforms.

Strong leadership skills and experienced in working efficiently in teams or otherwise. TECHNICAL EXPERTISE

Operating System: Windows (all versions), Mac OS

Methodologies: SDLC, Agile-SCRUM, SWOT, Cost/Benefit Analysis Utilities: MS Word, Excel (VBA, Macros, PowerPivot, Nested IF, VLOOKUP), Access, PowerPoint, Lync, Visio, SharePoint, Project Database: MS Access, Apache Hadoop, SQL Server (SSAS, SSRS, SSIS), MySQL, PostgreSQL 9.6.5, Oracle, SPSS Reporting & BI Tools: Tableau, Power BI, QlikView, IBM Cognos, Crystal Reports 9.0, Sarview Reports Miscellaneous Tools: SAP FICO, SAP BW-HANA, SAP BP&C, SAP Concur, EDMS, Datamart, Focus, Broker PLUS, Jira/Confluence, GENIUS Subscribe, DIVA, XUBER, Dashboard, EPIC, Applied Rating Services, Trello. PROFESSIONAL EXPERIENCE

SENIOR SYSTEMS ANALYST– ALLSTATE INSURANCE COMPANY OF CANADA February 2018 – March 2019

• Project: Allstate Benefits – Replacement of TPA February 2018 – March 2019 DESCRIPTION: Led the team of Junior & Intermediate System Analysts to successfully replace Third Party Administrator for Allstate US subsidiary Allstate Benefits Canada without impacting business continuity in an Agile environment.

• Created data flow diagrams for AICC Finance – Financial Reporting, Taxation, Banking, and Expense Planning to determine current (as-is) and future state (to-be) of flow of information from TPA to insurance carrier.

• Developed Requirement Traceability Matrix (RTM) to effectively outline all project requirements based on type, complexity, priority and timeline for referencing requirement identifiers and mapping test cases to each.

• Drafted change process document to track all changes in order to manage change requests so that approved changes will be controlled, ensuring the project remains on schedule, within budget and provides the agreed deliverables.

• Built and managed team link (share point) community to update latest developments in the project along with tracking outstanding items and issues, store relevant project documents and manage communication flow.

• Prepared test plans and test cases to validate the quality of data transmission from TPA to insurance carrier via SFTP in order to ensure the system is working as intended when the process goes live.

• Created and sent dashboards (status reports) that includes business-critical efforts, progress and risks to send to Allstate Canada Leadership team and stakeholders on bi-weekly basis in order to uncover issues, mitigate risks and create accountability & ownership.

• Facilitated various Agile ceremonies such as Sprint Planning, Daily Scrums, monitoring and controlling burn-down chart and Sprint Retrospective meetings.

• Responsible for overall project delivery. Managed Requirements gathering, delivery of Project scope, project schedules, resource plan, KPIs, Service levels, Change management, Support and Onboarding, managing Budgets, Test strategy, Milestones, Entry/Exit criteria and reporting to leadership.

• Project: SAP two-factor & Single Sign-on (Business Analyst) June 2018 – August 2018 DESCRIPTION: Successfully implemented multi-factor security & single sign-on for SAP Production Financials environment within Allstate Canada.

ENABLEMENT

• Identified SAP roles that requires users to input two factor security code along with users who access those transaction codes.

• Analyzed user requirements and work with project team for developing functions or enhancements to existing systems for fulfillment of business objectives.

• Created functional specifications, business requirements analysis, flowcharts and process maps using Microsoft Visio to help developers understand the changes required to the system.

• Recommended & updated controls to SAP user ID to match ACG network ID for single sign on (SSO) usage.

• Updated PRMS in SAP to reflect updated user ID along with two factor Symantec Credential ID. COMMUNICATION

• Involved Corporate Relations department to create a Bulletin on Allstate’s private portal named SOURCE.

• Created Help Desk Q&A to assist users on steps of installing smartphone application and using SAP two factor for the same.

• Update note on SAP sign in for Canada’s effective implementation date along with SAP splash page. Ongoing Maintenance System Support

• Provided General ledger system ‘OneRecon’ support in SAP – Set up OneRecon accounts, Create OM positions, Change Master Account Data, Add Buckets/ICR, extract journal voucher reports, test data upload in accounts, update tax rate change & maintain Visio charts of reconciling accounts.

• Created and ran queries to extract year end reports to identify total expenses for AICC in respect to wireless, cellular and mileage in SAP Business Warehouse HANA.

• Synchronized broker commissions from an in-house software BCS to SAP. Created and ran payment jobs in SAP to validate successful monthly commissions to AICC broker partners.

• Assist stakeholders to close any open SOX items to ensure that processes are established and maintained as per compliance for accurate reconciling of accounts.

• Identified potential IT impacts to AICC Finance applications and created test cases to ensure minimal disruption to business in times of server upgrades/patches.

• Diagnosed missing claims or EFT file from the application and taking appropriate actions to rectify such errors within the system architecture for successful job runs within SAP.

• Led annual Canada SAP Disaster Recovery Testing and Support Stack Testing to transfer system to backup server in order to ensure system accessibility.

• Acted as a Security Coordinator for AICC Finance and provide new & existing users access to different Finance applications such as SAP, Archer, Datamart, Focus, PLUS, Team link sites etc.

• Acting security admin for AICC Compliance software named Ethidex – create/delete users, assign OEA and Self Assessor roles to control modules, assign Finance compliance complaints to appropriate analysts.

• Provided post implementation support for SAP CONCUR to Canada wide Allstate employees.

• Responsible for providing appropriate network and application access to external (Deloitte) and internal (Northbrook) auditors.

FUNCTIONAL/PROCESS ANALYST – AON RISK SOLUTIONS April 2017 – January 2018

• Project: My Driving Discount App April 2017 – January 2018 DESCRIPTION: Strengthen the performance of My Driving Discount mobile application of client with respect to the rating

& discount system applied while tracking driving behavior.

• Collect and report telematics information of driver’s behavior such as braking, speed and driving time of day from the smartphone application and finding trends using data tools to improve app performance.

• Requirement elicitation by conducting “as-is analysis” & “gap analysis” and analyzing such requirements using visual models.

• Conducted JAD sessions/meetings with different people including the Client Partner, Project Manager, and Subject Matter Expert for requirement gathering purposes to improve the overall quality of the app.

• Design new application programs/functions by analyzing requirements gathered, constructing workflow charts and diagrams, studying system capabilities, writing specifications.

• Defining project requirements by identifying project milestones and monitor project progress by tracking activity.

• Improve systems by studying current practices; designing modifications and recommending controls by identifying problems; writing improved procedures.

• Support data analytics team to draw conclusions for managerial action and strategy. Provide guidance on multiple engagements to ensure successful delivery while balancing internal initiatives.

• Collaborated with business stakeholders, product engineers and system architects to understand current system functionality, new functional objectives to create business requirement and functional requirement documents.

• Implemented JIRA to create and manage user epics, stories and other requirement artifacts, escalate issues to project stakeholders for defect management purposes.

• Maintain system protocols; provide references for users via documentation and prepare technical reports by collecting, analyzing and summarizing information and trends. PROCESS SPECIALIST: BUSINESS ANALYST – XL CATLIN INSURANCE June 2013 – December 2014

• Managed huge client base of Marine insureds by calculating appropriate risk profitability, economic analysis, and sound financial analysis and fulfilling their business needs by providing excellent customer service with the help of XL’s internal tool GENIUS.

• Worked closely with client management to identify and specify complex business requirements and processes.

• Expert in Unified Modeling Language with hands-on expertise in creating Use Cases, Activity Diagrams and Sequence Diagrams.

• Reviewed and analyzed data of new insurance proposals in XL’s XUBER tool to determine the viability of the risk with regards to current standards.

• Designed, compiled and identified key risks and build effective primary controls while performing control monitoring evaluations for Marine Performing Servicing Operations.

• Reviewed and utilized process maps, publish procedures/reports and management reviews to design a control structure that ensures key risks are identified, documented and properly controlled.

• Developed advanced analytics dashboards, visualizations, and KPI reports using BI Tools. Formulating customer retention

(renewal) and sales strategies in collaboration with team supervisors by using such KPI reports.

• Acted as Subject Matter Expert (SME) for Marine policies to handle large complex accounts independently or with directions from seniors.

PROCESS ASSOCIATE: TECHNICAL ANALYST - GENPACT INDIA PVT. LTD. July 2012– June 2013

• Created database objects such as tables, views, stored procedures and triggers etc.

• Wrote SQL queries and co-ordinate creation of queries with other technical resources.

• Serve as a subject matter expert for the internal team and provide input into other deliverables as appropriate.

• Performed business and system analysis and prepared initial Business requirements (BRD) and Solution Requirements Specification (SRS)

• Responsible for converting the MS access modules into highly performance tuned jobs.

• Timey and effectively meet SLA requirements in processing service requests with 100% accuracy. EDUCATION

Master of Business Administration (MBA) Jan 2015 - Jan 2017

Brock University, St. Catharines, Ontario, Canada

BBA, B&I (Finance) Aug 2009 – Aug 2012

Indraprastha University, Delhi, India

CERTIFICATIONS

• Google Analytics Individual Qualification Certification – Reporting and Analysis 2017

• Certification in Complete SQL Bootcamp 2017

PostgreSQL

• Certified Advance MS Excel User 2017

PROVE IT TEST SCORE: MS EXCEL-98%

Contact this candidate