Digital Marketing Data

Sandeep Reddy Contact Info: +1-647-***-****

Sr. Business Analyst Permanent Resident

***.************@*****.*** Location: Toronto, Canada.

Summary:

Over 8 years of experience as an IT Business Analyst with expertise in Business Analysis, Joint Application Development, Business Process Analysis, Requirements gathering and management of documentation, Software Analysis and Modeling of web/enterprise wide client/server-based applications with strong understanding of Software Development Life Cycle.

Experience in all phases of the SDLC and QA Testing including requirements gathering, analysis, design, implementation, development, and User Acceptance Testing (UAT).

Exceptional Documentation and elicitation Skills for writing Use Cases and Functional Requirement Documents as well as for creating Use Case diagrams, Activity diagrams, State diagrams based on UML Methodology and business object modeling flow diagrams using MS Visio/Rational Rose.

Well versed in documentation of Business Requirements Documentation (BRD), Functional Specification Documentation (FSD), Context Diagrams, Current- and Future-State Process Models.

Excellent facilitation skills in conducting walkthroughs, surveys, questionnaires, interviews, brainstorming, Daily Scrum and Joint Application Development (JAD) sessions.

Expertise of UML in visualizing and documenting the artifacts using Use Cases, Use Case Diagrams.

Analyzed and defined business processes both “AS-IS” and “TOBE”.

Experienced in conducting GAP analysis, User Acceptance Testing (UAT), SWOT analysis, Cost benefit analysis and ROI analysis.

Excellent Business scripting skills & proficient in developing Use Case Models, Analysis Models, Design Models, Implementation Models, Use Case Diagrams, Context Diagrams, Dataflow Diagrams, State Transition Diagrams, Functional Story boards, Business Cases, Behavior Diagrams (sequence diagrams, and activity diagrams, Class Diagrams based on UML Methodology using MS Visio.

Strong understanding of the business process, Definition of the Scope of the Project, User and system requirements, and implementation to functional and technical specifications.

Experience in Test Planning, Test Preparation, Test Execution and Issue Resolution and Report Generation to assure that all aspects of a Project are in Compliance with the Business Requirements.

Involved in creating targeted questionnaires for SMEs, Clients and Users to gather requirements.

Knowledge in developing SQL and PL/SQL codes through various procedures, functions in Oracle.

Developed reports and visualizations using SSRS (SQL Server Reporting Services) to make key business decisions.

Coordinated BCP (Business Continuity Planning) efforts between project teams & infrastructure team to enable rapid WFH (work from home) adaption using MS Teams.

Excellent presentation combined with a proficiency in problem abstraction, business modeling, interpersonal, leadership skills, and ability to work in a cross functional team.

Excellent communication, analytical and presentation skills. Successful in meeting deadlines and handle pressure coordinating multiple tasks.

Conducted product demos for upper management and stake holders.

Technical Skills:

Domain: Financial & Credit Reporting, Insurance, Wealth Management, Banking, and Health care.

Methodologies: Kanban, WaterFall/Sequential Model, Agile Methodology, Scaled Agile framework

Productivity: MS Office 365 Suite – Word, Excel, PowerPoint, Outlook, OneNote, SharePoint

Tools: MS Visio, Rational Rose, UML, MS Excel, Trust, Wire Frames, draw.io

Bug Reporting: Test Director, Quality Center, Microsoft Test Manager 2010, Bugzilla, Jira.

Databases: Oracle, SQL, PL SQL Developer

Quality Standards: CMMI, ISO, Six Sigma

Others: HP ALM, Postman, SoapUI, LoadRunner, Rational Robot, Jenkins, Microsoft Visio.

Educational Qualifications:

Master’s in Electrical Engineering, University of Windsor, Canada. (2014-2015)

Bachelor’s in Electronics and Communication Engineering, JNTU, India. (2008-2012)

Work Experience:

Sr. Business Analyst - Matagora, Montreal, Canada. Feb 2019 – Till date

Description: The Matagora platform empowers online brands by allowing them to seamlessly access offline traffic which leads to an increase in their online sales & brand awareness. Through partnering with Matagora, client is able to capitalize in the omnichannel shopping experience. The project involved creating platforms for retail, small businesses and small-scale markets. Platforms are set for all kinds of digital markets to represent/display their inventory samples to make persistent customers.

•Analyzed client’s systems and business processes and prepared BRD’s with Functional Requirements from System Users that provided scope of work for Technical team to develop prototype and overall system.

•Implemented ITSM (Enterprise Service Management) in the organization.

•Utilized corporation developed Agile SDLC methodology.

•Used Scrum Work Pro and Microsoft Office software to perform required job functions.

•Extensive experience in Salesforce Sales Cloud, Service Cloud, Marketing Cloud, and APEX Programming.

•In-depth understanding of CRM business process that include Forecasting, Campaign Management, Lead Management, Order Management, Account Management, Case Management and Merging Management and translated business processes into CRM processes.

•Experience in Validation Rules, Work flow rules, Process builder, Flows, Workflow Alerts, and Approval Processes.

•Worked with External objects in Salesforce introduced with Lightning components.

•Associated with the Business Team to manage several third-party IT Vendor relationships & assisted in creating and reviewing SOW’s (Statement of Work).

•Experience in UAT testing and took signoff from the Commercial line of Property & Business users.

•Worked in a fast-paced atmosphere SCRUM and studied business processes, legacy application, and the corresponding Guidewire functionality and conducted requirements sessions.

•Analyzed standard industry practices of back office applications of Insurance Company, underwriting, billing, policy and claims administration with the help of Subject Matter Expert.

•Implemented Agile Methodology and involve in strategic management in interacting with stake- holder expectations and aspirations and engage in opportunities created by them.

•Experience in vendor governance and management, training users / peers, building consensus.

•Analyzing the business requirements and thereby preparing the master plan and detailed test plan.

•Participate in coordinating, communicating, and disseminating testing timelines, deliverables, and other information to QA Managers.

•Develop, create, modify, and execute test cases based upon business needs/requirements and associated user stories, epics, acceptance criteria, and assumptions.

•Prepared precise, high- quality internal and customer presentations.

Sr. Business Analyst - Torinit, Toronto, Ontario. July 2018 – Jan 2019

Description: Torinit develops the best digital products to help accelerate growth and increase market share through digital diagnosis, development, perfect product roadmap and user journey including feature improvement. The project involved building new platforms in digital marketing, managing the company’s websites, new Theme Integration with the mobile responsiveness and other modules such as integrating new plug-ins and custom requirements.

•Created best-practice SDLC artifacts, policies and procedures.

•Worked on HealthCare domain (Healthcare 365) for clinical trials and claims.

•Used QlikView to develop and deliver interactive guided analytics applications and dashboards.

•Responsible for creating Business needs for Mobile and Web Application development.

•Used tech specification to research, design and implement system functionality and configuration

•Work cross-functionally with logistic business teams, develop Oracle Enterprise Resource Planning (ERP) test scenarios, scheduling business owners and analyze the test results.

•Developed user documentation as well as scripts for functional usability testing and system training.

•Served as a technical point-of-contact for assigned functional areas and assists business subject matter experts with ensuring data integrity, system configuration, testing of system changes, report writing and analyzing data flows for process improvement opportunities.

•Used ServiceNow for all levels of IT Service management and IT operations.

•Worked with business subject matter experts (SMEs) to ensure Workday is optimally configured to support business needs.

•Built business processes to support identified business needs.

•Responsible for scheduling and troubleshooting of new system developments and modifications.

•Served as a technical key liaison between business stakeholders and IT teams.

•Provided assistance to business stakeholders in the effective use of applications and IT.

Sr. Business Analyst - Trustwave, Waterloo, Ontario. Mar 2017 – June 2018

Description: Trustwave is a leading cybersecurity and managed security services provider focused in threat detection and response. Project is to copy/move data from one source into a destination system/source (Data collection and data migration for internal stakeholders). The data could be same or different in a different context than the source.

Collaborate with business clients to gather and define business requirements and scope, explore viable options and facilitate solution design, implementation, and testing efforts.

Conducted detailed and comprehensive business analysis by working with the client IT staff, supervisors and end users in order to identify requirements and improvement.

Worked on Information Security software documentation.

Created documentation for Firewall protection system for a Banking project.

Worked with all security measures to protect the organizations computer networks and systems.

Aware of all kinds of cyber-attacks that could take place.

Knowledge in Fundamental Forensics skills.

Have an understanding of Hacking that were learnt during the project.

Captured business needs of the healthcare products to optimize risk systems and reporting.

Conducted ServiceNow reports during all stages of the project.

Ensured timely completion of project tasks and deliverables with a high degree of quality by prioritizing tasks appropriately and resolving issues along with the project manager.

Analyze data workflows and define procedures for change management and prepare business test cases during User Acceptance Testing stage.

Functional IT Business Analyst - Creative Realities, Windsor, Ontario. Oct 2015 – Mar 2017

Description: Creative Realities has a diverse mix of seasoned leadership with vast experience in strategic planning, digital design, CMS and custom software platform development, Operations and Field services. Data base retrieval system - User information shared among multiple databases for Health Insurance of clients (Data governance and data migration).

•Created requirements for the SSNRI Program which is the CMS mandate change of HICN for Medicare members.

•Business requirement defining how the MBI conversion file will be applied when it will be received in gateway and IKA claims.

•Created Business requirement document which define the use of crosswalk file alone with matching logic in gateway.

•Have conducted a full Impact Analysis, Assessment of changes to its systems and supporting processes to accommodate for HICN to MBI, including transition period where either number can be used interchangeably across transactions.

•Working with complex raw healthcare claims and clinical data (e.g., extracting data from Oracle and other environments), recognizing data patterns and potential issues, making recommendations (e.g., design, create and implement quality improvement projects).

•Performing statistical analyses to determine effectiveness of clinical programs (e.g., pre-post analysis, clinical trial results), followed by Performance tuning in the context of dimensional design by creating Mini Dimensions thus providing smaller entries into the Fact table. (Inpatient//Therapist data marts).

•Supported Senior Business Analyst with ITSM (Enterprise Service Management).

•Used Joins and subqueries for complex queries involving multiple tables from different databases and helped report developers in designing OLAP models for report applications.

•Involved in development as well as testing phases of SDLC by analyzing and testing the development and QA files.

•Building, publishing customized interactive reports and dashboards, report scheduling.

•Processing of New Business, Renewal, Cancellation, Reinstatement, Billing for various lines of business (Fire, Auto, and Commercial).

IT Business Analyst - ICICI Bank, Hyderabad, India July 2012 – July 2015

Description: ICICI Bank offers a wide range of banking products and financial services to corporate and retails customers through a variety of delivery channels and through its group companies. The project automated the process of the paper-based statements all across the world sent to the clientele, and trying to offer them e-statements which would lead us to save upon paper expense and most importantly, to establish a better, safe and convenient channel of communication with the clients in

every part of the world.

Worked as the Business analyst on reengineering and automation of an existing paper based

process of sending statements to the clients, through a web-based application named E-Delivery.

Elicited and gathered business requirements via Agile methodology and using Case Complete.

Created and monitored the project deliverables matrix to organize and identify the resources responsible for delivering the related materials.

As the part of the business team, involved in gathering, eliciting and documenting the information

from a variety of sources following agile methodology.

Organized the User Interface manual for the web users and ISA Guides for the security

administration based on the GUI (Graphical User Interface) functionality for Compliance dept.

Extensive knowledge of SWIFT messaging (MT103, 940 and 942).

Knowledge on XML and MT300 tools.

Conducted interviews and JAD sessions to develop the architectural solution, meeting the business requirements, resolve open issues, and change request.

Created and dealt with logical data migration, data modeling, workflow modeling, use case analysis, and business process modeling.

Regular discussions and reviews on the format and allocation of the data fields and the records, and to identify the issue/ gaps and the appropriate solutions with the stakeholder, business users and the Data warehouse team.

Worked with the data warehouse team for the integration of the data/ tables in the master

database for all the Delivery teams to have access to the data e.g. Region, Business, and Products.

Strengths & Accomplishments:

Enthusiastic & Creative with high level of motivation and team player.

Ability to achieve objectives within strict deadlines.

Highest level of Organizational & Communication Skills.

Volunteer Experience:

Conducted local workshops on Digital Transformation, Digital Marketing & Business Continuity Planning for small business owners. (July 2012 – July 2015)

Organized teaching sessions periodically at rural elementary schools in India that lacked proper infrastructure, faculty and support. (May 2008 – Current)

Contact this candidate