Business Analyst Resume
Collegeville, PA
SUMMARY:
- Over all 10+ years of IT industry along with UiPath, Robotic Process Automation with OCR Tools.
- Developed end - to-end automation solutions involving process discovery, solution design, development, testing and deployment in UiPath
- Experience in automating Accounting, Mortgage and Financial clients
- Strong experience in UiPath to automate Web/Desktop/Native/Citrix applications, Excel Integration, PDF Integration, Image Recognition, OCR technologies (MODI, TESERRACT and ABBYY) and Python activities
- Experience working with VDIs in Azure environment
- Worked with solution architect to prepare Process Definition Document (PDD) and Solution Design Document (SDD) and trained SMEs to work with BOTS in Production
- Peer reviewed all the processes for day-to-day problem-solving issues when arises
- Used technologies such as PDF data handling, email automation, mainframe automation, web application and SAP
- Experience working on Waterfall and Agile Methodologies - Scrum executing through sprints
- Experience in developing Scope/Vision Documentation, Project Plan, tracking Project Process, and managing resources to ensure successful delivery
- Involved in the designing solutions utilizing RPA (Robotic Process Automation) software, maintain technical responsibility for project delivery as the technical resource on a project
- Expertise in Collection, Analyses, Documentation of User Requirements, as well as Organizing interviews, User meetings, Workshops and JAD sessions
- Expertise in the management of User Request Change, and handle User Conflicts
- Extensive experience in documentation of business requirements and functional specifications, including BRD, FRD
- Proficient in creating Use Cases, Use Case Diagrams, Class Diagrams, Sequence Diagrams and Activity Diagrams etc.
- Expertise in development of Conceptual design, Logical design and Physical design for Database, Data Warehousing.
- Excellent Communication and Presentation skills; Extensive working and presentation experience with business users, software developers, senior management as well as business leaders.
- Expert in various types of testing like Black Box, End-to-End, Functional, Regression, Integration, System, and User Acceptance. Proficient in working with test management and defect tracking tools to analyze and report information about test requirements, test plans, and tracking defects.
TECHNICAL EXPERTISE:
Tools: MS Visual Studio (2017, 2015, 2013), MS Tools, MS Visio (2016, 2013, 2010), Jira Server (Version 7.1.2), Confluence (5.9.5), HP ALM 11, Quality Center, SAP ERP (6.0), SQL (2016), Miro
Other tools: Microsoft Office Windows Applications (2016, 2013, 2010), Microsoft Outlook (2016, 2013, 2010), Adobe Reader. Tablaeu and Uipath, Work fusion, Unqork
Methodology: Agile Scrum, Waterfall
PROFESSIONAL EXPERIENCE
Confidential, Collegeville PA
Business Analyst
Responsibilities:
- Prepared documents for all stages of the project: Initiation, requirements gathering, Design, Construction, Testing, Implementation, Post Implementation, Audit and Transition to support.
- Gathered and analyzed business requirements through interviews, surveys and document analysis.
- Conducted JAD sessions to facilitate requirements gathering in coordination with multiple teams.
- As Scrum Master, was involved in maintaining the capacity plan, sprint backlog, velocity charts and burn down charts being a liaison between PMO and stakeholders.
- Analyzed data sets which included equities, interest rates, and currencies using SQL.
- Worked on PowerPoint presentations using Inserting pictures, graphs and diagrams, adding animation, hyperlinks, importing video files.
- Maintained Traceability Matrix for the current business processes and proposed changes.
- Documented test plans and test cases, and ensured that the module was linked to market and the securities were marked to market on report and presented Back End Testing scenarios by using SQL server.
- Conducted Regression Testing to ensure the generation of certain datasets regardless of parameter selection.
- Functioned as a prime brokerage relationship manager and handled field prime brokerage questions, all prime brokered accounts and filed investor inquiries.
- Provided technical and procedural support for User Acceptance Testing. Tracked testing issues, maintained test matrix.
- Developed finance forms Fee reversal/Credit and Beneficiary using Unqork RPA automation tool integrating with the client works.
- As Scrum Master, was involved in identifying and removing hurdles in the success of the sprint by working with every single team member.
- Automated the data transfers, including importing/exporting data between applications with APIs, Unqork and client works
- Involved in analyzing the automation feasibility of all processes and successfully delivered solutions for FRC, PCC and Beneficiary forms
- Prepared CPD - Current process document and HLPD - High level process documents
- Conducted Business Gap Analysis with respect to proposed enhancements and new requirements.
- Conducted feasibility study through mapping of AS-IS Business processes versus TO-BE business processes
- Interacted with SME’s in identifying and documenting business needs and created data flow, activity diagrams, and state transition diagrams using MS Visio, Miro and collaborated with production team to identify and map detailed existing processes, identify system gaps and developed functional requirement documentation/User stories that supported overall strategy, goals and objectives in Agile Scrum methodology
Tools & Technologies: Agile Scrum, MS Office Suite, Quality Center, UML, Net, Microsoft SQL Server 2016, Jira, Tableau, Unqork, Client works, Miro
Confidential, Mt Laurel Township, NJ
Business Analyst
Responsibilities:
- Understood the manual process of loan processing. Estimated the time taken by the loans processing personnel for processing manually and comparing with the time taken by the robot.
- Gathered customer’s business requirements and clearly documented them in order to RPA Consultant teams to deploy automation projects in an optimal manner
- Developed the objects and workflows as per client requirement in Encompass
- Worked with Business Teams to create PDD (Process Definition Document) and developed separate SDD (Solution Design Document)
- Involved in Logging into websites, searching websites, submitting web forms, or updating records on a website
- Created the robot using UiPath that is importing the files in a form of zip folder to the designated folder
- Utilized UiPath Orchestrator to deploy the robots into the real working environment
- Created the automation to capture various testing trials using performance testing, pilot testing, regression testing under UAT environments
- Worked with different teams in making changes in developed processes as per the Technical Design Document (TDD) to meet the defined requirements
Tools & Technologies:Agile Scrum, MS Office Suite (Word, Excel, PowerPoint, Access), MS Visio, UML, Quality Center, Encompass, SQL, Uipath RPA
Confidential, Columbus, OH
Business Analyst
Responsibilities:
- Responsible for requirement management, coordination of development tasks and system integration testing and UAT for Basel III and CCAR implementation.
- Prepared the documents on work of the existing (AS-IS) process for the reporting and proposed the (To-BE) reporting process using waterfall methodology.
- Responsible for data analysis, identifying gaps, and authoring data dictionaries, published end to end flow to position data into Basel III data warehouse.
- Facilitated data quality checks and ensured correction of data quality issues from source systems and improved reference data sourcing for facility, counter party and other relevant attributes.
- Coordinated with the CCAR capital planning team for identifying the different data attributes that are relevant for generating the monthly, quarterly and annual report projections.
- Understood the manual process of Excel reporting. Estimated the time taken by the front desk advisor for processing manually and comparing with the time taken by the robot.
- Gathered customer’s business requirements and clearly documented them in order to RPA Consultant teams to deploy automation projects in an optimal manner
- Developed the objects and workflows as per client requirements
- Worked with Business Teams to create PDD (Process Definition Document) and developed separate SDD (Solution Design Document)
- Involved in Logging into websites, searching websites, submitting web forms, or updating records on a website
- Created the robot using UiPath that is importing the files in a form of zip folder to the designated folder
- Utilized UiPath Orchestrator to deploy the robots into the real working environment
- Created the automation to capture various testing trials using performance testing, pilot testing, regression testing under UAT environments
- Worked with different teams in making changes in developed processes as per the Technical Design Document (TDD) to meet the defined requirements
Tool & Technologies: UiPath 2018.4.1, Orchestrator 2017.1, .Net Framework 4.7.2, SQL 2016, OCR tool, MS Word 2016, MS Excel 2016, MS Visio 2016, PDF
Confidential
Business Analyst
Responsibilities:
- Performed pre-analysis of the user requirements, assigned priorities, and translated the requirements to functional specifications and mapped the requirements to appropriate GAAP rules.
- Designed trade-related workflow for trading flow through to the settlement and accounting systems.
- Created the detailed requirements documentation for setting the structure of the statements.
- Mitigated extreme technology risk by removing unsupported features on the platform.
- Planning, updating and maintaining the project plans/charters and project progress reports.
- As a scrum master initiated and coordinated creating and prioritizing the Sprint Backlogs in JIRA, conducted Sprint Retrospectives and reviews, sharing metrics to identify and implement improvements.
- Involved in defining project scope, project plans and timelines & communicating the same to project and technical team members throughout the project life cycle.
- Managed the change requests and requirements successfully at all phases of the SDLC.
- Translated business requirements into Technical requirements and system specifications.
- Provided specifications for Data Modeling, including Conceptual models, Logical models and Physical models.
- Prepared data mapping documentation using SQL for the translation of foreign currency into US dollars and matching the securities’ value into their market value.
- Prepared activity diagrams and use case diagrams using Microsoft Visio according to UML in waterfall methodology.
- Maintained various versions of the documents generated during the project and managed them by incorporating the change request modifications.
- Extensively carried out User Acceptance testing (UAT) by actively working with users and developers.
- Involved in deployment and production testing.
- Prepared user training manuals and conducted user training sessions
Tool & Technologies:: Waterfall methodology, .Net Framework 4.5, MS Visio 2013, MS Visual Studio 2013, MS Outlook 2010, MS Word 2010, MS Excel 2010, MS Access 2010, Adobe Acrobat 11, Quality Center
Confidential
Information Technology Project Coordinator
Responsibilities:
- Infrastructure Operations Management
- Setting up and operating Remote Helpdesk for clients.
- ITIL practices implementation.
- Manage security and process audits conducted by KPMG
- Ensure contingency setup for all systems are workable.
- Ensure SLA compliance on all systems and processes.
- Maintenance Agreements and Software license management.
- Vendor Management. Overall supervision of the operations
- Managing a team of 12 Helpdesk Engineers
- Handling over 1600 calls per week
- Responsible for all Infrastructure Services to 2500 internal customers
- Preparing Status reports of the business unit
- Monitoring and notifying hardware usage and performances
- Responsible for keeping track of all hardware equipment, fixed assets
- Preparing MIS reports weekly/monthly/quarterly and annually
- Preparing annual budgets
- Documentation, preparing policies and procedures for the business unit
- Responsible for Business Continuity and Conducting periodic Disaster Recovery tests
- Responsible for evaluating performances of the Helpdesk Engineers
- Production Support for Pershing LLC
- Manage a team for supporting and monitoring of applications for a large production setup consisting of mainframes, Sun and Intel servers, spread across two data centers for parent companies in the US.
Tool & Technologies:: RAD methodology, MS Project 2000, MS Visio 2000, MS SharePoint 2000, MS Office XP, Adobe Acrobat, BMC Remedy version 3.0, 2.9 and 2.8.