PROFESSIONAL SUMMARY:

• 7+ years of experience as a Business Analystand Scrum Master in Banking and Financial Industry with expertise in Business Requirements Gathering, Business Process Modeling Notation(BPMN), Business Analysis, Business Process Improvement, and Business Intelligence
• Experience in various fields like Federal Regulations, Capital Market, Trade Finance, Portfolio Management, Mortgage as well as Online Banking including financial and reporting experience with strong knowledge of Software Development Life Cycle (SDLC) and extensive knowledge of Agile methodologies like Scrum and Kanban, Waterfall, and Scrum - Waterfall hybrid methodologies.
• Strong finance & banking domain knowledge including accounting operations, banking processes & terminologies, and financial statements (Balance Sheet, Income Statement & Cash Flow Statement)
• Solid knowledge of Feature-driven Development (FDD), Behavior-driven Development (BDD) & Test-driven Development (TDD)
• Worked with PM resource management, Revenue Planning, Budget allocation, WBS, and Project Accounting and Reporting & Analysis.
• Created, structured content, designed sites and was a super user in SharePoint 2013
• Consulting of upgrading/additional technologies including Google Cloud, Tableau, and AWS .
• Proficient with Business Analysis tools such as designing wireframes (Balsamiq), JIRA, and GitHub
• Design and Implement end to end automation of provisioning of Virtual machines in the Azure Private cloud with the help of ServiceNow
• Responsible for Requirements Elicitation for new source engagement of MYBI. Identify the BI reporting tools like Tableau, MicroStrategy, Power BI . Understand the access and meta data availability needs, review the Environment mapping across the applications, frequency of data extraction from the source.
• Experienceincreationof MS Dynamics CRM plug-in/Workflows, custom application, CRM web API, CRM customization, SSRS Reports.
• Set up tableau data sources and refresh schedules in server.
• Familiar with Sharepoint and Workday .
• Responsible for onboarding applications to SailPoint IIQ in an agile environment with both on-site and offshore development teams from legacy Access Management (SUN IDM) and other source IAM systems.
• Coordinate Global Rollout of OBIEE, Oracle Data Visualization, IBM Cognos , SmartView, BIP Publisher.
• Global ownership of 12 integrations between ServiceMax and other GE systems including Oracle ERP.
• Radiate information and updates to project teams via project pages built within the Confluence tool.
• Writing change controls and documenting requirements in JIRA following the Agile process.
• I was their SharePoint Business analyst , PowerUser and Administrator.
• Created Use Cases to define the role of the users who receive claims, users who process claims, and users who adjudicate claims. Used MS Visio to develop Use Case Diagrams, Activity Diagrams.
• Assisted QA in the reviewing test cases and ensuring appropriate test coverage using Postman for simulation
• Designed Conceptual, Logical and Physical data flow diagrams for file transfers from ERP INFOR to the vendors and created Diplomat File transfers for the same.
• Translated Business processes into Informatica Mappings for building Data marts.
• Have good working knowledge in querying Salesforce .com database using SOQL SOSL queries using Force.com Explorer.
• Responsible for Workday HR Data Request of field mapping and values between PeopleSoftand Workday
• Created Requirements Traceability Matrix (RTM)to test all the requirements are tested using HP QC tool.
• Web service testing with SOAP and Postman .
• Experience working in RDBMS & Data Warehouse projects.
• Effectively utilized Tableau features like parameters, calculated fields, filters to provide efficient data visualization solutions to the customer.
• Proficient in assisting and conducting various enterprise analyses like GAP analysis of AS-IS and TO-BE systems, SWOT analysis, Impact analysis, Goal analysis, Feasibility analysis, and Risk analysis.
• Performed various accounting tasks such as counting down the registers, balancing the safe , and preparing.
• Create User Stories from stakeholders'requirements and translate those into a technical design document for the ServiceNow team to develop
• Created the SharePoint Sites, metadata, document hierarchy, taxonomy, and permissions.
• Working with implementation project to help end user to change their PeopleSoft system to Workday system.
• Promoting the rapid iterative development based on agile development and project management methodologies and introduced JIRA based reporting to track release progress. Fully set up an configured a new JIRA instance following the migration to AWS and split of two sister companies.
• Worked on Cucumber as agile project management software for automated testing.
• Involved in conducting different kinds of elicitation techniques like Joint Application Development (JAD) sessions, Brainstorming, Interviews, and Requirement Workshops with variety of business users (LOBs) & project stakeholders.
• Experience in using Salesforce .com Creating Roles, Profiles, Email Services, Page Layouts, Workflow Alerts, Actions and Approval Process.
• My dynamic IAM process & regression testing allowed segregation of duty requirements to be deployment in a next-generation privileged access tool
• Strong knowledge database and data manipulation skills using SQL. Worked in SQL Server and Salesforce database structure.
• Leverage use of excel, power BI and maintenance to Stryker global revenue/transactions
• Utilized Okta browser plugin for password storage and Identity Access Management (IAM) among applications.
• Knowledge of agile environment techniques like Planning Poker, T-Shirt sizing, and MOSCOW method.
• Proficient in generating use case, analyzing ER Diagrams and Data Flow Diagrams.
• Knowledge of Data Warehouse Architecture & concepts like data marts, data mapping, data modeling, fact table, dimension table, metadata, Conceptual, Logical & Physical Data Model, Star and Snowflake Schema.
• Excellent verbal/written communication skills and strong analytical abilities. Can perform well both independently and as a team player.

TECHNICAL SKILLS:

Modeling Tools: MS Visio, Mock: Up Screens, Rational Rose

SDLC Methodologies: Waterfall, Waterfall Scrum Hybrid, Scrum, Agile Scrum, Agile

Business Skills: Process Modeling, Change Management, GAP Analysis, Impact AnalysisSWOT Analysis, JAD Sessions, Project Scheduling, Project Budgeting

Data Warehousing: Data Modeling, Data Marts, OLTP, OLAP, Data Mining, Slicing/Dicing, Drill Up/DrillDown.

Requirement Management: JIRA, Rally, HP ALM, MS Office, Confluence, ClearQuest

Testing Tools: HQPC, Postman

Reporting/BITools: Tableau Desktop, IBM Cognos

Methodology Tools: JIRA, HP ALM, RALLY

Databases: MySQL, Oracle, MS Access

Languages: XML, SQL

Operating Systems: Windows XP/10, Linux, Mac OS

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Sr. Business Analyst/ Scrum Master

Responsibilities:

• Meet with decision makers, system owners, and end-users to define business and operations requirements and systems goals. Interpret issues and provide initial analysis towards resolution.
• Extracted the Business Requirements from the end users keeping in mind their need for the application and prepared Business Requirement Documents (BRD) and Functional Specifications Documentation (FSD) using Rational RequisitePro.
• Implemented a solution framework to host Web Services reading data from and writing to MS DynamicsCRM .
• In collaboration with business unit managers review and analyze the effectiveness and efficiency of existing systems and develop strategies for improving or further leveraging these systems.
• Translates business and user requirements into detailed system requirements, swimlanes, mock screens, data models and workflows for the ServiceNow technology organization
• Prepare and trigger builds for all environments using Jenkins and XL Release .
• Writing Cucumber Test Plan, Test Cases and Conduct unit, functional, Regression, performance Testing flex Rules of insurance.
• Organized JAD sessions to flush out requirements, performed Use Case and workflow analysis, outlined business rules, and developed domain object models.
• Documented common bugs and issues in Confluence
• Setup a Jenkins continuous integration server with custom integrations to meet the client’s need for builds, along with a Bitbucket code repository and a Jira ticket management system instance
• Maintenance and creation of Workday Supervisory Organizations, Locations, Positions, Cost centers, Cost Center hierarchies.
• Develop AEM templates and components leveraging current AEM software releases
• Adept at developing Test Plans, Test Estimation Document, and Test Reports, and Defect management for tracking defects via JIRA tool.
• Used Version Control Tool - GitHub to manage up-to-date codes and documentations.
• Worked with integrating various systems such as Salesforce, Servicemax , BPM software (Pega, Skelta, etc), Big Data, SCM (Supply Chain Management), SAP SD, SAP CRM, Lotus Notes, OMNI, etc
• Worked closely with external vendor teams and educated over SailPoint's scope and capability.
• Worked extensively in creating dashboards using Tableau Desktop and published them on Tableau Server.
• Identify PeopleSoft queries for re-creation within Workday for continued support of legacy processes
• Conducted Gap Analysis for different vendor systems by analyzing their Current state and future state to attain data transformation in ERP and for the implementation of Python.
• Experience with CRM systems in general ( SAP , Oracle , Siebel, Salesforce.com), ModelN
• Designed sites and created workflows, alerts, lists, libraries, and structured group permissions in SharePoint .
• Experienced in creating various Unified Modeling Language (UML) Diagrams using UML modeling tools such as MS Visio .
• Developed remote document retrieval system from an Azure file system.
• Assist in the planning, design, development, and deployment of new applications, and enhancements and upgrades to existing applications. Provide references for users by writing and maintaining documentation.
• Served as SFDC Subject Matter Expert (SME) for Salesforce Service Cloud Implementation
• Experience with JIRA, Slack, Postman API Testing
• Involved in Data Conversion and Data Migration from Legacy systems to PeopleSoft implementation.
• Experienced in Data Migration from other applications to Salesforce using Data Loader.
• Managed the integration of technologies such as Voice Biometrics authentication, Call Risk Scoring ( Pindrop ) and Virtual Assistant (Chat Bot) in Confidential contact centers
• Created ServiceNow reports, dashboards & homepages and use the data gathered to work with process owners to determine KPIs and room for improvement in the platform.
• Assisted data warehousing team in performing data modeling and data mapping activities like defining data source, data target & data transformation rules to set-up the data load process using Informatica as well as analyzing & designing the data elements.
• Coordinate and perform in-depth tests, including end-user reviews, for modified and new systems, and other post-implementation support.
• Used GitHub as a source repository system to share code within the office as well as with the teams in overseas.
• Modify existing HP QC Workflows (defects, reporting, and all others) and create new one as needed.
• Knowledge implementation of Power BI report server.
• Prepared GAP Analysis; identified and documented improving areas to meet capital markets requirement regulations.
• Provides asset management support.
• Created and managed off-site Azure VM and database for external client reporting system.
• Analyzed Business Process Model, Use Case model and test procedures based on agile methodology.
• Created AS-IS process workflow and TO-BE process workflow in MS Visio
• Involved in the team in requirement gathering and managing the requirements using JIRA, which included questionnaires, interviews, brainstorms and meetings with stakeholders, business users, and compliance department and SMEs.
• All aspects and phases of SDLC associated with vendor release builds and integration development initiatives for a key strategic Portfolio Management System/ OMS used by Asset Management's Municipals desk.
• Defining Software Development Lifecycle (SDLC) and planning the entire process using MS Project.
• Utilized statistical analysis tools (SAS, SPSS, R, and MS Excel) to develop accurate and concise analytical results to deliver strategic solutions and make decisions.
• Assisted in developing the test plan, test conditions and test cases to be used in testing based on business requirements, technical specifications and/or product knowledge
• Assisted in developing strategies with Quality Assurance group to implement Test Cases in Mercury Test Director for stress testing and UAT (User Acceptance Testing)

Environment: Agile-Scrum, Rational Enterprise Suite (Rose, ClearCase, ClearQuest), Github, Visual Basic, MS Project, SQL, SQL Server, Oracle, WebLogic, SailPoint, Salesforce, ServiceNow, Tableau,IAM, Asset management, IPFR MS Visio, Services, Dreamweaver, Power BI, Windows Forms, AEM 6.2, Oracle CPQ, Web Forms, ServiceMax, LoadRunner, Revenue cycle management, Accounting, WinRunner, DOORS, Project Management.

Confidential, New York, NY

Sr. Business Analyst/ Scrum Master

Responsibilities:

• Analyzed prior documentation and business processes for full understanding of the ongoing project. Interviewed SMEs, asking detailed questions and carefully recording the requirements.
• Functioned as a liaison between eight lines of business (LOBs) and the technical team.
• Assisted the project manager to organize meetings, prepare meeting minutes, and track the project risks/issues, resources, and budget of the project.
• Analyzed and Documented Business Requirement Document (BRD), Functional Specification Documentation (FSD), and System Requirement Documentation, using UML methodologies
• Creating various dashboards with Power BI desktop
• Solid Experience in developing Scope/Vision Documentation and Project Plan, as well as tracking Project Process, and manage resources to ensure successful delivery
• Created Automated Test Cases and Test Suites with Cucumber to test the insurance rules under different scenarios
• Worked closely with the IAM Provisioning team in understanding and documenting current provisioning standards for applications and translating/ grooming as required by SailPoint IIQ System.
• Co-Project managed Systems Integration (Salesforce.com, Oracle CPQ , SAP)
• Design and execute queries in various databases/systems: SAP , Oracle , LMS, PKMS, JDA, AS400
• Assisted in the development of Project Impact and Process Control Plan documents on Confluence
• Created release builds based on sprints using Jenkins , thoroughly testing the build for all tickets associated with the release
• Used MS Word, MS Excel, MS Access, MS Project, and MS Visio for documentation and analysis reports among other project management and reporting tools. Implemented SQL queries for QA testing and Report. Executed and managed tests in test lab using HP ALM tool.
• Authoring and automating critical reports used by Front, Middle, and Back office FI teams in Asset Management.
• Organized end to end system testing, system integration testing (across Salesforce, Servicemax , SAP, OMNI, BMI and other systems via interfaces), UAT
• Establish and deliver Continuous Integration/Delivery using tools such as Jenkins, SVN, Sonatype, Nexus, GIT, Ansible, Cloudbees , Cloudforms and SonarQube.
• Increased accuracy and reliability of financial and operational database by auditing 30 central office locations throughout North and South Carolina ensuring accurate tracking of $85M worth of network asset management.
• Extensive experience about the Workday eco-system and all aspects of Workday implementations.
• Handled the huge data volume by using Tableau extracts
• Design, develop and support AEM components, integrations and applications
• Used Advanced Find feature of MS Dynamics CRM and created multiple views of System entities.
• Tested inbound Interfaces to PeopleSoft to get data into in out of the system
• Experienced in the integration and testing of third party software.Documented the Requirement and Testing Trace-ability Matrix in JIRA .
• Scheduled data refresh on Tableau Server for daily and monthly increments
• Utilized and compiled sales data from both proprietary systems along with data programs IBM Cognos and Margin Minder
• Analyzed Supply Chain Management and Human Capital Management reports using Lawson ERP system by INFOR
• Participate with enterprise customers and internal leadership to provide feedback regarding product and upgrades. Train and onboard Pindrop client fraud teams in Pindrop's software to assist in utilizing the product appropriately to save millions in fraudulent activity. .
• Updated and maintained SharePoint site with monthly announcements, calendar, useful documents, and links.
• Assisted in coordination of the Agile/Scrum development process using Azure Dev Ops and JIRA
• Responsible for automating Identity and Access Management system and continues improvement in AWS
• Developed process flow diagrams (flow charts) using MS Visio in an effort to identify and analyze process flows in the RBC Safe Deposit Box system.
• Identified, planned and implemented new Salesforce .com features and functions (new screens, workflow, force.com objects, reports, apex code) in response to business needs in Sales Cloud.
• Prepared Detailed Design Document (DDD) for Business as Usual (BAU) processes for the project.
• Created separate project plans for each sub-project and tracked the progress of all the items in the project plans.
• Experience working on the ServiceNow and BMC-Remedy platforms
• Integrated Salesforce CRM with Siebel CRM explicitly using web services API.
• Worked closely with the IAM Provisioning team in understanding and documenting current provisioning standards for applications and translating/ grooming as required by SailPoint IIQ System.
• Prepared for GAP Analysis; identified and documented improving areas to meet capital requirement regulations.
• Responsible primarily for Cash Equities, Single Stock Flow Derivatives and Equity Capital Markets businesses
• Performed requirement gathering and knowledge extraction about the Capital markets using both formal and informal sessions through JAD sessions
• Worked with Business Rules, UI Policies, Data Policies, Widgets and Reports in Servicenow , for the client
• Involved in analyzing data generated the output and presented final report. Statistical packages used: R-studio, SAS, SPSS, Used SQL and Excel for data cleaning
• Learned the Agile methodology for the project guided the team to document epic and stories and requirement maintenance using tools like JIRA and Confluence.
• Created AS-IS process workflow and TO-BE process workflow in MS Visio and conducted GAP analysis for projects.
• Strong knowledge of Data Warehousing tools like SSIS, SSRS, Informatica and Cognos.

Environment: Agile-Scrum, Advance Plax, ServiceNow, Salesforce, GPP, AS/400, ServiceNow, Mainframe/DB2, J2EE, RUP, UML, Use Case diagrams, Microsoft Visio, CloudBees, MS Project, AEM 6.1, IAM, Asset management, Revenue cycle management, Accounting, Postman, HP QC, JIRA, Confluence, Tableau, SailPoint, Power BI.

Confidential, New York City, NY

Business Analyst

Responsibilities:

• Worked with Fixed Income, Bonds and Bond Trading Cycle, Bond Pricing, Equities, Trade Cycle, Derivatives (Options and Futures), Portfolio Management, Sales and Marketing.
• Responsible for maintaining accurate accounting records and preparing financial statements and reports, including B/S reconciliations for Wealth Management line of business.
• Provide quarterly regulatory reporting by updating standardized templates and tying out to financial statements and supporting documents for submission in a short timeframe.
• Experience in working with Test Management and defect tracking tools like HP ALM/Quality Center, IBM ClearQuest and JIRA.
• Gatheredrequirementsanddeveloped processes to on-board 300+ business applications into SailPoint IdentityIQ
• Workday Reporting Requirements, Report Testing & Validation
• Basic understanding and knowledge of Salesforce and content management tool - AEM (Adobe Experience Manager)
• Created PeopleSoft practice. Program Director responsibility to identify, source, pursue, win clients/projects, meet fiscal
• Analyzed Requirements and created Use Cases and Activity Diagrams using MS Visio .
• Extensively used Jira and Confluence to actively organize, maintain and keep track of dynamic user requirements as well as documented requirements, test plan, test cases, defects, and change controls.
• Managed priorities and requests in an organized manner using Scrum board on Azure DevOps
• Excellent skills in working with Microsoft Outlook, Word, SharePoint , Excel, database software and statistics
• Built Salesforce reports as requested by management, along with standard sales reports.
• Work experience with the enterprise IAM (Identity and Access Management).
• Used IBM Cognos v8.0 for reporting purposes
• Worked on the implementation of Incident Management, Problem Management, Change Management, Event Management, CMDB, Reporting, Service Catalog in ServiceNow .
• Developed dash boards with rich Graphic visualizations, Drill Down and Drop-down menu options, parameterized using Tableau .
• Experience working in reporting tools like Business Intelligence, Informatica , Cognos and Tableau.
• Performed data cleaning and exploratory data analysis tasks to summarize the key performance indicators of the data sets using tools like Power BI , Tableau to ensure intelligible data visualizations
• Collaborated in building a business analysis process model using Rational Rose, RequisitePro, and Visio.
• Responsible for business system analysis of customizing the BPS Risk Management product with involvement through the whole SDLC
• Gathered user and business requirements through interviews, surveys, prototyping and observing from Fixed Income Portfolio Managers/Advisors. Stored and modified requirements in MS Word.
• Facilitate JAD sessions involving the management, development and user teams for clarifying requirements and facilitating better communication.
• Performed data validation with data profiling and presented visualizations using Power BI and Tableau
• Good experience in performing (JAD) joint application development sessions, (JRS) joint requirement planning sessions, (RAD) Rapid Application Development, and communication interviews.
• Incorporated Agile methodology and SCRUM techniques to develop custom features.
• Design and Implement end to end automation of provisioning of Virtual machines in the Azure Private cloud with the help of ServiceNow
• Developed clutter free Tableau dashboards for various product lines and departments
• Played a key role in the planning, testing, and implementation of system enhancements and conversions
• Authored test plans, test cases for various test scenarios and helped testing team to better understand the test scripts.
• Performed analysis on enterprise data/report integration & provided functional specification to development team to build Enterprise Reporting Systems.

Environment: Waterfall -Scrum, Oracle, Service-oriented Architecture, JIRA, HPALM, Informatica, IBM Cognos, IBM Rational Rose, BPMN 2.0, Microsoft Visio, Azure, SharePoint 2013, MS Dynamics, Java/J2EE, JSON, Spring, JavaScript, HTTP, XML, Eclipse, Apache Tomcat.

Confidential

Business Analyst

Responsibilities:

• Lead Joint Application Design (JAD) sessions to gather business requirements and to identify data stewards.
• Served as a liaison between business team and the project team by assisting the business in identifying, understanding, and documenting their business needs.
• Worked with business users and analysts to understand the requirements for mastering the data obtained from various sources and loading the golden records to the target MDM database.
• Utilized previous experience and helped team in creation of Schema design in Erwin and implement in database and preparing the technical design document.
• Presented insights by creating visualization dashboards using Tableau, MicroStrategy and Power BI
• Experience in BI/DW solution (ETL, OLAP, Data mart), Informatica , BI Reporting tool like Tableau and QlikView and also experienced leading the team of application, ETL, BI developers, Testing team.
• Work experience with the enterprise IAM (Identity and Access Management) team to implement and automate processes.
• Translated the business needs into system requirements, communicating with the business on a non-technical level, and with the System Analyst on a more technical level.
• Assisted in performing Data mapping testing in Informatica Data quality at each step of ETL mapping to ensure correct data in flow and outflow.
• Provided support to troubleshoot Dashboards and generated reports using Crystal reports, Xcelcius and helped resolved the root cause of production issues and streamline the business intelligence processes
• Collaborated with team members and management to identify and solve data quality issues
• Documented and delivered Functional Specification Document to the project team.
• Assisted the PM in setting realistic project expectations and in evaluating the impact of changes accordingly.
• Conducted UAT to verify whether all the requirements were catered by new data warehouse.
• Provided technical assistance in identifying, evaluating, and developing systems and procedures that are cost effective and meet business requirements.

Environment: MS Project, MS Visio, Informatica MDM, Informatica Data Quality, SAP BO suit, Xcelcius, Crystal Reports, SQL, Oracle 10g, MS Office, MS Visio