PROFESSIONAL SUMMARY:

• Over 8+ years of demonstrated experience as Sr. Business Systems Analyst, Systems Analyst and Scrum Master implementing advanced analytical methods to resolve the business problems with solid understanding in Business and Functional Requirement gathering, Business Process Flow its modeling and Reporting activities.
• Exclusive experience working in Banking & Finance domains.
• Experience in working with business users and documenting and reviewing business documents such as Software Requirement Specifications (SRS), Business Requirements Document (BRD), Functional Specifications Document (FSD), Use Case Specifications, and Requirement Traceability Matrix (RTM), Product Backlogs.
• Extensive knowledge and hands on experience on Software Development Life Cycle methodologies like Waterfall, Agile (SCRUM, RUP, XP) and Hybrid (Waterfall - Agile) to extract the best possible output.
• Knowledge and experience in various Elicitation Techniques such as Personal interviews, Requirements Workshops, JAD Sessions, Prototyping, Document Analysis, Focus Groups, Surveys and Brainstorming.
• Participated in Business and Technical design sessions with multi-functional teams consisting of SMEs, Developers, and QA analysts and have experience in facilitating Joint Application Development (JAD) for it.
• Consistently performed GAP Analysis, SWOT Analysis, Risk Analysis, Impact Analysis and Cost/Benefit Analysis.
• Proficient in drafting Use Cases, Sequence Diagrams, Class Diagrams, and Activity Diagrams using MS-VISIO.
• Experience in breaking down the EPICS into Features, Features into User Stories and User Stories into User Tasks and very well versed in writing User Stories and proficient in estimation and prioritization techniques such as Kano Model, MoSCoW, Planning Poker, T-Shirt Sizing and Relative Mass validation techniques.
• Hands on experience in using the tools such as HP Agile Manager, Atlassian JIRA, Rally and Version One for requirement documentation, User Story tracking and generating various SCRUM Artifacts.
• Capture and review ITSM process requirements and translate them into user stories on ServiceNow agile development module
• Project scoping and business process knowledge of various versions of PeopleSoft
• Involved in facilitation and drafting Test Cases, Test Plans, Test Scenarios and involved in various types of testing such as Manual and automated testing, Smoke Testing, System Integration Testing, Regression Testing, User Acceptance Testing, and Beta Testing (Open Beta testing and Closed Beta Testing), Performance Testing.
• Experienced with HP Application Lifecycle Management (HPALM) and HP Quality Center (HPQC) to manage the requirement, track the defects perform Root Cause Analysis and bridge between project team and business.
• Help design and implement sustainable practices that provide governance and oversight for IAM (Identity Access Management).
• Design and deliver instructor led and recorded programs for tools including PeopleSoft, ImageNow, Workday, Essbase and SmartView.
• Experience with Identity and Access Management (IAM) to initiate, capture, record and manage user identities and their related access permissions in an automated fashion.
• Created and deployed several reports using Salesforce.com platform.
• Proficient in utilizing Salesforce out-of-box functionality for customizations and defining user security model
• Proficient in creating Profiles, Roles, Users, Tasks and actions, Dashboards, Reports, and Validation rules.
• Expert in successfully demonstrating the user requirements to the team working on the project by employing Unified Modeling Language (UML) and ER-Diagram using MS-Visio & Enterprise Architect.
• Involved in designing, developing and verifying Server Side Validation and Client Side Validation.
• Experience in Data Analysis, Data Mapping, Data Modeling, E-R Diagrams, Normalization. Have strong understanding of Legacy DBMS, Relational DBMS, Object Oriented DBMS, Multi-Dimensional DBMS.
• Actively involved during Dimensional Modeling Data Design and assisted the team in designing the On-Line Transaction Processing (OLTP) and Operational Data Store (ODS) to enhance the speed of the transaction.
• Experience in using Salesforce.com Creating Roles, Profiles, Email Services, Page Layouts, Workflow Alerts, Actions and Approval Process.
• Experience in drafting the Data Mapping Document and was involved in concatenating and parsing the text field, executing the related conditional logics, performing look-ups. Assisted the ETL Team in preparing the planning document and have extensive knowledge in SQL and various ETL Tools such as Informatica.
• Served as SFDC Subject Matter Expert (SME) for Salesforce Service Cloud Implementation.
• Have good knowledge of using the SQL Queries to verify the data integrity and data consistency after the completion of ETL process on the data which would be in readable format as per user requirements.
• Knowledge in designing the Web Services to support the application development that involved XML, XML Schemas and implement the associated Data Logic which makes it reusable and interoperable-loosely coupled.
• Extensive knowledge of Data Warehousing, Databases, Master Data Management, Data Marts, Dimensional modeling (Star schema, Snowflake Schema) and OLAP operations such as Roll-up, Drill-down, Slicing and Dicing

TECHNICAL SKILLS:

Waterfall, AgileScrum, Waterfall: Scrum Hybrid, Extreme Programming(XP), Spiral, SAFE, Kanban, Scrum-ban, Rational Unified Process (RUP).

Requirement Management Tools: JIRA, Rally, TFS, Version ONE, MS Project, Rational Requisite Pro, HP QC, HP ALM

Reporting Tools: IBM Cognos BI, MicroStrategy, Business Objects, Tableau, SQL Server Reporting Service, Microsoft Power BI, Spotfire, Alteryx.

Graphical & Modeling Tools: MS Visio, Balsamic, Rational Rose, UML, Mockup Screens.

Databases: MS Access, MYSQL, Microsoft SQL (T-SQL), Oracle 9i & 10g (PL/SQL).

ETL Tools: SQL Server Integration Services, Oracle Warehouse Builder, IBM Cognos Data Manager, Informatica Power Center, Oracle Data Integrator.

Testing Tools: HP QTP, LoadRunner, Bugzilla, Selenium, SOAP UI, Oracle Application Testing Suite (OATS)

Microsoft Tools: MS Office Tools (Word, PowerPoint, Excel) MS Access, MS SharePoint, Outlook 365

SQL, PL/SQL, T: SQL, HTML, XML, C, C++

Operating Systems: Windows XP, 7, 8, 10, Linux, Mac OS

Cloud Platforms: Salesforce, AWS & Azure

PROFESSIONAL EXPERIENCE:

Confidential, Wilmington, DE

Senior Business System Analyst

Responsibilities:

• Gained extensive knowledge on Mortgage Life Cycle starting from Loan origination to Closing.
• Got well-versed with different parameters including, delinquency, types of interest rates, types of loans, Loan to value ratio, Debt to Income ratio and amortization period.
• Developed thorough understanding of underwriting criteria and guidelines mentioned by Federal National Mortgage Association (FNMA) and Federal Home Loan Mortgage Corporation (FHLMC).
• Understood encompass SDK and APIs’ and analyzed data requirements necessary to be communicated between Encompass and Salesforce CRM.
• Worked on SOAP UI functional testing and Web service testing.
• Documented API requirements for credit reports, employment verification of the borrower, Loan Appraisal information and Title Search using external APIs’ like TransUnion, Equifax, USPS web tools and Zillow.
• Created As-Is and To-Be business models and Performed GAP and SWOT Analysis.
• Assisted Product Owner in breaking down Epics and Features into User Stories as per the INVSEST Criteria
• Facilitated Sprint Planning, Daily Scrum, Sprint Review, Sprint Retrospective and Backlog Grooming.
• Retrieved data from the Oracle RDBMS using SQL.
• Extensive experience on building dashboards in Tableau and involved in Performance Tuning of reports and resolving issues within Tableau Server and Reports.
• Experience gathering and documentation of requirements, acceptance criteria and other artifacts using the SDLC application in ServiceNow.
• Analyzed different business reports and guided the team on deployment and customization of those reports in Salesforce.
• Assisted the database team in creating Stored Procedures, functions, indexes, clusters, and partitioning the tables.
• Assisted team with configuration of user accounts, roles and different user profiles and set-up record level permissions in order to provide shared access among different users using SalesForce.com.
• Worked with Marketing, Sales and Service teams to elicit requirements on customer engagement, generating leads, customize dashboards and providing Service post sales.
• Experienced working on PeopleSoft Recruiting Solutions modules
• Communicated with the DevOps team with respect to JPA (Java persistence API) used to perform data access by using Object Relational Mapping (ORM).
• Responsible for creating, maintaining, and implementing IAM Governance processes such as audit issue management, facilitation of remediation plans to closure and evidence gathering.
• Analyses incoming work and IAM metrics/measures to drive improvements to the IAM program
• Developed Transform maps to map values between Import Set and ServiceNow tables for incoming data from external sources.
• Translate stakeholder requirements into various documentation deliverables such as functional specifications, use cases, user stories, workflow diagrams, data flow diagrams for ServiceNow implementation.
• Gathered requirements which pertained to accessing external Web-Services using JAX-RS (Java API for XML services).
• Worked with development team to understand the content and appearance of Web Pages according to the user request through use of Java Servlets using JSP (Java Server Page).
• Assisted in testing the consistency of data loads from external systems.
• Documented the Disaster Recovery Plan.
• Assisted operations team to design the specific data flow between production RDBMS to disaster recovery database using Oracle Data Guard.

Environment: Agile- Scrum, Salesforce, Servicenow, Oracle GlassFish v4.0, Java EE 6, XML, XSD, JSON, AJAX, HTML5, JSP, JIRA v6.3.3, Confluence v5.3,SharePoint 2013, Tableau, GitHub v2.3, IAM, MS Visio v15.0, MS, Oracle 11g, Jenkins v2.0, IBM Cognos, Apache Maven v3.0, Cucumber v2.3.3, Peoplesoft, Oracle Toad v12.8, Encompass, HP QC, Psotman.

Confidential, Charlotte, NC

Senior Business Analyst/ Scrum Master

Responsibilities:

• Effectively served as Business Data Analyst for Performance Measurement Audit and Capacity Tests; responsibilities included creating test cases, scripts, test execution schedule, coordinating data set up, managing resources, creating project task plans.
• Conducted formal interviews, Live Meetings and JAD sessions with business users Subject Matter Experts (SME's) for requirement gathering
• Prepared test Data sets and performed data testing using the PL/SQL scripts. Also used MS excel for data mining, data cleansing, data mapping, data dictionary and data analysis.
• Conducted user interviews, gather requirements, and analyze the requirements
• Analyzed the AS-IS and TO-BE processes to understand the key findings, the short term considerations, the long term considerations and its benefits
• Experience designing and creating User Records in ServiceNow for new users.
• Experience in migration project of Asset records from IBM Maximo to ServiceNow platform.
• Good Knowledge of Mortgage Process, Appraisals, Escrows
• Designed and developed different use cases, activity diagrams, sequence diagrams, Object Oriented model (class/object diagrams) using MS Visio and UML
• Performed Business data gathering and report generation for stock market and trading using Tableau.
• Created a Custom module Create-A-Record, for Taleo to PeopleSoft integration.
• Heavily conducted GAP analysis between legacy ITSM systems to ServiceNow.
• Conducting the system and user acceptance testing. Define the test plan, test cases and automation of the test scripts using Rational Suite Tools.
• Tasked with documenting the current state of resources that are targeted to be managed by the IAM program, business processes that relate to that resource usage, and key IAM capabilities that drive the approach to integrate the resource.
• Used Rational Rose to designed and develop Use Cases Scenarios, Use Cases Models, Activity Diagrams, Sequence Diagrams, State chart diagrams, OOAD using UML
• Using IAM in business meetings, working with technical stakeholders and business end-users to facilitate the development process
• Maintained Troubleshooting Guide for Salesforce issues to have immediate solutions.
• Responsible for creating, maintaining, and implementing IAM Governance processes such as audit issue management, facilitation of remediation plans to closure and evidence gathering.
• Devised and implemented pre and post implementation data courier environment strategies for IAM solution
• Assisted in developing the Business Flow Diagram using MS Visio
• Worked with cross-functional teams for building the use cases
• Worked with clients to implement of SalesForce's Wave Analytics program.
• Assisted in creating the project templates for Use case specification, Change request form, functional specification documents and Business Requirement documents and Defect status form
• Worked with the design team to assist them extensively in designing the database
• Assist end users and IT staff in the use of data to satisfy informational and reporting requirements using SQL and DBMS
• Conducted SOAD and OOAD analysis with business owners to ensure the roles and services defined matched to the defined technical specifications of the functionality.
• Preparing Implementation Plan for every release in ServiceNow and provide Walkthrough to the entire team to execute the steps.
• Escalated unresolved issues to Salesforce Premier Support and published ideas in Salesforce Ideas community.
• Used MS Visio and MS Excel extensively to develop the use cases
• Regularly interacted with onsite and offshore teams to communicate requirements and review test cases and test plans.
• Worked closely with the project manager in handling the whole project
• Used Data mapping to collect and show relations between data
• Assisted the technical team in defining the candidate system matrix and feasibility matrix
• Worked with the statistical models to determine the trend of the business over the course of years

Environment: Agile, MS Visio, MS Office Suite, Java, IAM (Identity Access Management), Azure, Salesforce, Oracle 9i, Test Director, .Net, VB, Client Server, AWS, UML, Postman, IAM, Windows XP, Alteryx, Test Director, MS Office suite, JIRA, Confluence, MS Visio, Sharepoint, GitHub, IBM Cognos.

Confidential, Pittsburg, PA

Business Systems Analyst

Responsibilities:

• Involved in execution and delivery of software development projects, and maintain responsibility for documenting business and functional requirements
• Identify and implement system configuration and scripting changes and proactively identify issues or contingency plans and ensure that the project team is in alignment with business objectives.
• Analyzed requirements into user stories by detailing in the functional and non-functional requirements based on interactions with the Product Managers and SME's who gave the customer's real-time feedback about the Financial Products Like Bonds, Equity, Mutual funds to evaluate risk exposure.
• Created and prioritized the Back Log, coordinated Planning Sessions and maintained User Stories and Acceptance Criteria
• Extensive experience in using Tableau for analyzing data sources from Excel/MySql, Oracle, SQL server
• Created views/reports in Tableau Desktop that were published for Data analysis on weekly, monthly, daily basis and were published to the server
• Created Ad-hoc charts like donut charts, Funnel charts, waterfall charts suiting the analytical models used for the Dashboard and modified existing Tableau workbook stories and added Action filters
• Modified existing tableau reports that are in place and collaborate with business to integrate new data points to streamline workflow and company processes
• Performed Data cleansing and normalization along with profiling to ensure Data Quality
• Gave permissions to specified Business users to access the Report using Tableau server
• Designed and Developed reports from multiple data sources by blending data on a single worksheet in Tableau Desktop
• Experience in creating various visualizations such as Scatter plots, box plots, Maps, dual axis charts, pie chart, trend lines
• Coordinated Phased Data Migration process to handle large and complex volumes of data and address dashboard reporting capabilities.
• For Data analytics, created performance matrix to evaluate the feedback from dashboard and calculate the accuracy rate and number of false positives
• Supervised and worked closely with data coordinators, and other team members to provide technical support and end user on the developed applications.
• Assist in creating and reviewing Quality assurance (QA), User acceptance testing (UAT) plans, as well as Test cases
• Facilitated requirements discussions with business and technology partners, and assisted the quality assurance department in their test efforts by clarifying requirements and addressing issues as detected.

Environment: MS SQL Server 2012, MySQL, Tableau Prep, Alteryx, Tableau 10.x/2018.x, Tableau Server, MS Excel, MS Access, MS Word, MS VISIO, JIRA, SCRUM, SPRINT

Confidential, Nashville, TN

Business Analyst

Responsibilities:

• Responsible for managing and directing the entire Software Development Lifecycle (SDLC) by coordinating with the project resources, business stakeholders, external vendors, suppliers, retailers, development team and testing team
• Drafted, documented and revised Project Charter after initiating Kick-off meetings, ensured follow-up and sign-off
• Determined the composition, roles and responsibilities and terms of for the project teams and resources
• Developed and maintained Project Plans including Work Breakdown Structures (WBS), Gantt Charts, Plans, other project related plans such as Communication, Quality, Risk Stakeholder, and Procurement Management Plans
• Defined and communicated strategies regarding client information delivery and handled daily task management
• Communicated and maintained project s and issues on regular Status Review Meetings
• Performed tasks associated in project coordinating and as Subject Matter Expert (SME) for Agile/Scrum best practices (User Stories and ATDDs), and to aid in demonstrating how Form Assembly and the transition to User Stories and ATDDs will works in tandem with Marking Cloud and Salesforce.
• Participated in biweekly analysis/review/audit of each projects’ charter, scope documents such as Statement of Work (SOW), and reports generated by Salesforce and Tableau
• Managed a highly experienced team of Business Analysts, ETL Developers, Data Architects and QA/Software Testers
• Extensively involved in Vendor Management and in the management of software tools evaluation and licensing
• Oversaw all UAT (User Acceptance Testing) activities prior to the implementation of the Data Warehouse
• Used ServiceNow’ s StartNow and JIRA tool to track the requirements; Rational Requisite pro to create the Requirements traceability Matrix (RTM); Created RAM (responsibility assignment matrix) / RACI (Responsible, Accountable, Consulted and Informed) Matrix and assessed business risks
• Extensively interacted with the designers, developers to ensure functional implementation of business requirements and QA Team in executing Test Plans, Test Scenarios and Test Cases
• Developed the schedules, user manuals and trained the business/end users

Environment: Agile, Salesforce, MS Visio, MS Excel, MS Word, MS Project, MS Access, StartNow, JIRA, Confluence, Informatica, Mockup screens, SharePoint 13, HP ALM, Selenium, SQL Developer, UML, Postman, Service Manager 9.32, ServiceNow, Fuji.

Confidential

Business Analyst

Responsibilities:

• Gathered requirements by facilitating Requirement Workshops, Interviews and Focus Group sessions involving SMEs and technical team leaders.
• Created BRD, worked closely and coordinated with the team members, including the development team to make important artifacts such as the FSD and SRS.
• Assisted in selecting the technology for the application based on Cost-Effectiveness, Cost-Benefit Analysis and Quality, while keeping in mind factors which could influence the application in future.
• Prepared Use Cases from the gathered requirements and created diagrams using Rational Rose.
• Developed PowerPoint presentations for monthly meetings with upper management executives.
• Teamed up with the credit allocation department to perform Market Survey and learned client requirements to assist the technical team with software development.
• Wrote SQL queries for joining different tables using Inner/Outer/Left Joins and Union/Intersect
• Developed and created the new database objects including Tables, Views, Indexes, Stored Procedures and Functions.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages.
• Tuned SQL statements and Stored Procedures.
• Assisted in preparation of UAT test plan, Test Cases, Testing Cycle Schedule, Test Scenarios and implemented them with the QA team.
• Used the Unified Change Management (UCM) tool and Rational ClearQuest to maintain and track the stakeholders requested enhancements and changes.

Environment: Waterfall, SQL Server, Rational ClearQuest, Rational Requisite Pro, Rational Rose, MS Office, MS Project, MySQL, SharePoint 2007

Confidential

Business Analyst

Responsibilities:

• Assisted Sr. Business Analyst, while facilitating Requirements Workshops, brainstorming sessions and conducting interviews to elicit requirements.
• Under the supervision, guidance and support of Sr. Business Analyst created the BRD, SRS, FSD, RFP, Use Cases, Use Case Diagrams and Activity Diagrams.
• Facilitated review sessions for validating requirements before base lining the BRD and FSD.
• Gathered requirements for the GUI and created UI prototypes using Mockup Screens.
• Prepared project related presentations to provide a clear view of the tasks to be performed and targets to be met within the time frame.
• Coordinated with Database team in creating ER Diagrams for data modeling.
• Identified Primary Keys, Composite Keys, Candidate Keys and Foreign Keys for the tables and assisted the Sr. PL/SQL Developer with creation of accurate relations for the RDBMS.
• Assisted the Sr. Business Analyst and BI team during the creation of several views and reports needed by the Audit team using IBM Cognos and SQL developer.
• Assisted Sr. PL/SQL Developer in creation of Stored Procedures, views, and tables
• Wrote SQL queries for CRUD operations to maintain database on MySQL 5.1.
• Assisted Sr. Business Analyst in preparing Test Cases, Test Plans and Test Scenarios.
• Supported QA team to trace bugs and complete the Bug Life Cycle for the best results.
• Documented changes in the Requirements Churn Artifact and updated Requirements Traceability Matrix.

Environment: Waterfall, MS Office (MS Excel, MS word, MS Power Point), Java script, JQuery, IBM Cognos, MS project, Mockup Screens, MS Visio, MySQL 5.1