SUMMARY

• Senior Business/Data Analyst wif over 10+ years of experience in developing, implementing, and managing complex projects in Financial, Mortgage, Healthcare and, pharmaceutical domains.
• As a Business/Data Analyst and a Certified Scrum Master I has focused on various SDLC’s including Agile, SAFe and Scrum Methodologies.
• Expertise in requirements management, data analysis, data visualization dashboards and reports, and supporting QA project activities.
• Excellent team player wif superior analytical, negotiation and problem - solving skills wif experience in leading teams of diverse backgrounds to make sound business decisions based on analysis of short-term and long-term business needs.
• Possess strong Mortgage industry institutional knowledge including various types of loan products, Conventional, FHFA, USDA and end to end loan life cycle
• Excellent understanding of loan life cycle data starting wif loan origination process to settlement and bond execution (GSE’s)
• Strong experience wif providing metrics on mortgage data including Commitments, Deal, Loan, Bonds, Forbearance, and Liquidation
• Possess strong financial institution knowledge including Front office, Back office, and legal and compliance processes
• Proficient in preparing Business Requirement Document (BRD), Software Requirement Specification (SRS), System Design Specification (SDS) and Functional Specifications
• Experience wif supporting enterprise level projects in Waterfall & various Agile methodologies
• Experience in creating/conducting brainstorming sessions, workshops, Joint Application Development (JAD) sessions, White Board Sessions wif end-users
• Proficient in gathering and converting User Requirements into Business Requirements and Functional Requirement Specifications (FRS)
• Proficient in performing and documentation of GAP analysis, Feasibility study, SWOT analysis, Risk analysis, and ROI analysis.
• Proficient in elaborating & consolidating the business requirements into Epics, Features, User Stories, Acceptance Criteria and User Story Mapping and maintaining them in JIRA, Rally and Azure boards
• Experience in Conducting Sprint Planning, Sprint Retrospective, Backlog Refinements and Daily standups as part of Agile ceremonies
• Experience in using JIRA, Rally, Azure board, Team Foundation Server (TFS), HP Agile General Manager (AGM) and other Agile-Scrum reporting tools.
• Experience working wif REST API’s using API collaboration tools to develop API requirements and conduct data analysis
• Experience in providing data sets to internal consumers via API’s
• Experience wif data warehouse concepts including Snowflake and Star schema
• Experience in performing data profiling and data analysis to understand and validate data integrity across multiple data sources
• Experience in writing complex SQL/PL SQL/MySQL queries to perform data analysis and to build reports
• Experience in developing Alteryx workflows to automate the manual process of data validations across multiple systems
• Proficient in analyzing the metrics using Tableau, Adobe Analytics and Qlik Sense to identify the bottle necks and derive business justifications
• Experience in Developing dashboards and reports dat adhere to the visualization best practices and communicate a story
• Excellent understanding of Data services, ETL, Teradata, Big Data, Oracle, MySQL and MS Access
• Experience wif developing data dictionaries, performing data profiling, data lineage, and using data management tools like Collibra which enable self-service data utilization
• Experience in creating Graphical User Interface (GUI) designs, Functional Flow charts wire frames, prototypes and screen mock-ups
• Knowledge of cloud-based technologies Amazon Web Services (AWS) and Azure Cloud
• Proficient in content authoring and publishing through Adobe Experience Manager (AEM) V5.6 & 6.2 and Web Experience Manager
• Experience in performing system testing and automated testing as part of Quality Testing
• Proficient in Creating and Maintaining Requirement Traceability Matrix (RTM) to track change requests
• Expert in using Microsoft Office applications for day-to-day activities - Microsoft Word for documentation, Microsoft PowerPoint for presentation, Microsoft Excel Pivot Tables, Macros for data analysis and presentations, Microsoft Project and SharePoint for prioritizing and managing individual tasks.
• Ability to handle multiple projects in a fast paced, team oriented and collaborative environments.

TECHNICAL SKILLS

Business Management Tools: MS Visio, UML, Rational Requisite Pro, RTM, Caliber RM, Team Forge

Methodologies: Waterfall, Agile-Scrum, SAFe

Application Packages: MS Office 2003/2007/2010 , MS Project, MS Visio, PeopleSoft, MS Dynamics, Salesforce, Teradata SQL Assistant, DB Visualizer Pro, TOAD Data Point

Process/Technologies: Quick Test Pro, AEM, JIRA, RALLY, Azure Board, VersionOne, HP ALM, HP AGM, TFS, API’s, JAVA

Operating Systems: Windows 95/98/2000/XP/Vista

Databases: MS Access, SQL, Oracle, DB2, Teradata, Big Data, NoSQL, MySQL

Reporting Tools: Tableau, Alteryx, Adobe Analytics, Qlik Sense, SharePoint, SSRS

PROFESSIONAL EXPERIENCE

Confidential, Washington, DC

Sr. Business/Data Analyst

Responsibilities:

• Design and develop confluence web pages to maintain and store necessary project architecture
• Conduct business requirements gathering sessions to understand and create user stories in Jira board
• Work wif internal teams who handles the commitments, deals, Loan on-boarding, Bonds and Liquidation processes as part of requirements gathering sessions
• Work wif data modelling team to design the data model using Snowflake schema
• Work wif cross functional teams to perform ETL using Informatica 9.6 from multiple legacy sources to RAD reporting layer database and ensure derivation logics are implemented accurately
• Maintain product backlog to drive the scrum team on focusing the high priority items as per business need
• Develop source to target mapping (STTM) document to determine data lineage and mapping from source to governed target state data attributes
• Develop data dictionary or data glossary for dashboards or reports developed using Target state data structures
• Use SQL to extract data from Data Vending Hub (DVH) and identify the key data attributes required to suffice consumer needs
• Perform data profiling as part of data quality checks to ensure data from source systems match wif RAD on-prem and AWS Cloud
• Extract and analyze large volumes of data from various data sources by writing complex SQL and PL/SQL queries to identify data variances, quality and consistency across multiple systems
• Perform root cause analysis using TOAD Data Point 4.2 to debug the errors resulting in data variances and resolve it appropriately
• Develop and execute complex PL/SQL queries to create weekly and monthly summary views to assess data integrity, accuracy and overall data quality
• Develop and validate dashboards & reports in Tableau 2019.1 using RAD data to ensure it reconciles to historically published metrics
• Develop calculated fields, combine fields, geo-coding, and scorecards to include them in custom Tableau Dashboards
• Develop REST APIs to provide consumers wif necessary data to develop dashboards and reports
• Develop and execute a test plan to perform data validation to ensure target state data meets Confidential data governance standards and consumer reporting needs as well
• Develop Alteryx workflows to automate data validation processes in AWS Cloud
• Develop and document the complex calculations and business derivation logics in SQL to derive necessary data attributes for reporting purposes

ENVIRONMENT: Toad Data Point 4.2, AWS, Tableau 2019.1, Alteryx, Informatica 9.6, SQL, PLSQL, MS Web Technologies, Scrum AGILE, Confluence, Azure board, MS Office Tools

Confidential, Owings Mills, MD

Sr. Business Analyst/Scrum Master

Responsibilities:

• Conduct Business interviews, requirements gathering sessions to understand and capture the bottle necks and business needs
• Capture and Document current state workflow diagrams and Use case diagrams to understand the scope of the project
• Work wif the team and Project manager to translate the scope of the project into Minimum Viable Product (MVP’s) to plan for incremental releases
• Translate the business requirements into Features, User stories and Acceptance Criteria and work wif Architecture team to design a feasible solution to meet the business needs
• Develop Key Performance Indicators (KPI’s) to report the metrics using Qlik Sense on monthly basis and utilized Microsoft Excel Pivot Tables, v-lookup functions and Macros for analysis
• Conducted Backlog grooming sessions wif business stakeholders and team to refine and align the User stories according to business priority for future sprints
• Monitor batch processes using Splunk Dashboard to ensure scheduled jobs are running successfully
• Develop and Execute MySQL queries to generate KPI reports on a monthly basis
• Perform data analysis on daily trades and positions data from Investment Data Warehouse (IDW) and Charles River Database (CRD) using DbVisualizer Pro and Excel functions
• Develop requirements to translate Trades, Positions and Orders data from IDW and CRD into a consumable format by Trading Hub
• Extract data from external REST API’s using Postman to perform data analysis
• Develop XML templates using .XSD file provided by FINRA as part of firm wide filing on quarterly and annual basis
• Develop and create a rules engine to define the data type, attributes etc. to assist the business stakeholders wif performing the data input
• Work Peer to Peer wif the Legal business stakeholders to perform the necessary data input in the XML templates
• Validate XML files using XML Notepad to ensure data type and data formats aligns wif the XSD Schema validation rules
• Debug any issues encountered in the XML files to find out the cause of errors and work wif corresponding teams to resolve the issues
• Execute a Java batch process manually to stitch multiple XML files together using command prompt to create a consolidated XML file
• Execute test scenarios and test cases to validate automated workflow build in Salesforce
• Update custom templates in Salesforce to resolve any issues discovered during testing
• Coordinate User Acceptance Testing (UAT) wif business stakeholders to gather user’s feedback
• Create Job Aids and other documentation to help business stakeholders for utilizing the solution TEMPeffectively as part of Training
• Work wif third party vendors to implement or enhance the necessary features as per the business need
• Conducted Sprint Planning, Sprint Retrospective, Daily standups and Sprint Demo’s as part of Agile ceremonies
• Provide ongoing maintenance, support and enhancements in existing systems and platforms.

ENVIRONMENT: MySQL, DbVisualizer Pro, Salesforce, API’s, Agile Scrum, Jira Board, ServiceNow, MS Office Tools, XML Notepad, UML, MS Visio

Confidential, Collierville, TN

Sr. Business Analyst/Product Owner

Responsibilities:

• Analyze and document Business Requirements in Team Forge and socialized the documents wif the impacted application teams
• Define Ideal state Scenarios, Customer Journey Maps and Forward-looking Position Statements to socialize the Business requirements in Epic Summits
• Document Epics and Features in HP Agile Manager (AGM) and assisted the teams in writing the User Stories and Acceptance Criteria and ensured Acceptance Criteria meets the business needs
• Analyze 8.5M FDM customers data using Adobe Analytics to determine the potential areas and the enhancements needed for FDM growth
• Utilize Adobe Analytics to create metric-based and item-based reports on usage and performance of FDM
• Create Ad-hoc Dashboards and Reports using APIs to measure the performance of FDM on Desktop, Mobile and tablet web pages
• Collaborate wif Marketing teams in identifying the potential users to perform the Email Marketing Campaigns through Adobe Analytics
• Design and develop a prototype data model using snowflake schema to verify the feasibility of model against KPI’s
• Extract data from Enterprise Data Warehouse using SQL through Teradata SQL Assistant
• Work wif Third-Party vendor and teams to determine the Knowledge Based Assessment (KBA) Verification process to prevent fraud registrations for FDM
• Document Test Scenarios, Test plans and Test cases by ensuring all the business lines of requirements are covered
• Prepare User Acceptance Testing (UAT) scenarios to assist the Business users in performing thorough validation
• Perform Pre-Production and Post-Production validations along wif team to make sure the MVPs are working as expected.

ENVIRONMENT: Team Forge, Teradata, Teradata SQL Assistant, SQL, Adobe Analytics, HP Agile Manager (HP AGM), HP Quality Center (HP QC), SAFe, Windows, MS Office Suite

Confidential, Owings Mills, MD

Sr. Business Analyst

Responsibilities:

• Design and develop project document templates based on AGILE methodology
• Create user stories and acceptance criteria as per Agile standard format, and work wif product owner to prioritize accordingly
• Utilize JIRA and RALLY tools for maintaining the user stories and acceptance criteria and tracking down the progress and project milestones
• Perform regression and integration testing to ensure developed user stories meets acceptance criteria
• Develop test cases and test scripts for user acceptance testing (UAT) to help business partners in performing the UAT.
• Utilize data analysis techniques to validate business rules and identify low quality missing data in the existing application.
• Worked on creating and developing the web pages by utilizing the templates in Adobe Experience Manager as per the business requirement
• Worked on migration of internal and external websites from AEM 5.6 to AEM 6.2 and ensured the business lines are met and functionality is working as expected.
• Utilize Adobe Experience Manager (AEM) for content authoring, web pages creation & publishing across the websites and Mobile apps
• Collaborate wif the QA team to ensure adequate testing both before and after completion, maintained quality procedures, and ensured dat appropriate documentation is in place.

ENVIRONMENT: MS Web Technologies, AGILE, JIRA, RALLY, HP ALM, Adobe Experience Manager (AEM), Windows, UML, MS Visio, MS Excel VBA.

Confidential, Timonium, MD

Sr. Business System Analyst

Responsibilities:

• Analyze and Document Business Requirement Document (BRD), Functional Specification Document, and System Requirement Document
• Develop entity-relationship diagrams, functional decomposition diagrams and data flow diagrams
• Utilize Team Foundation Server (TFS) for maintaining user stories, acceptance criteria and testing.
• Conduct working sessions wif various groups, including business owners, SMEs (subject matter experts) and marketing team, for requirements gathering in definition Stage.
• Worked wif the project manager to determine Level of Effort (LOE) and other project tracking activities
• Developfunctional prototypesforUI teambased on user requirements and presenting thosewire framesto the development and test team for their understanding during the review meetings.
• Involved in maintaining and managing different versions of Documents using Rational ClearCase.
• Implemented the Rational Unified Process (RUP) methodology of application development wif its various workflows, artifacts and activities.
• Assisted the QA personnel in the creation of Test Cases using Rational Test Manager.
• Engaged in system testing during User Acceptance Testing (UAT) and Quick Test Pro

ENVIRONMENT: MS Web Technologies, PeopleSoft, AGILE, SQL, No SQL, Windows, IE, Rational Unified Process (RUP), Rational ClearCase, TFS, Rational Unified Process, UML, Quick Test Pro.

Confidential, Basking Ridge, NJ

Sr. Business Analyst

Responsibilities:

• Define scope of the project created project plan and the WBS according to the Scrum methodology.
• Develop integration requirements as per the business needs to connect wif the existing legacy system
• Conduct GAP analysis of 4010 and 5010 EDI transaction using implementation guide to identify the changes in the segments and data elements.
• Utilize mapping tools to map 4010 and 5010 transactions along wif ICD 9 and ICD 10 codes and validated the HIPAA Syntax.
• Utilized BI reporting tools like SharePoint and Microsoft Dynamics CRM for decision analysis
• Collaborate wif the QA team to ensure adequate testing of software both before and after completion, maintained quality procedures, and ensured dat appropriate documentation is in place.
• Develop web forms using HTML and other web services for new EMR system.
• Conduct UAT (User Acceptance Testing) and Quality Testing prior to production release

ENVIRONMENT: Agile Scrum, RUP, Rational Requisite Pro, SQL Server, XML, MS Project, MS Visio.

Confidential, San Francisco, CA

Business Analyst

Responsibilities:

• Perform integration requirement analysis, impact analysis and document Business Requirements Document (BRD) and Functional Specification Document (FSD) using Rational Requisite Pro.
• Document Traceability Matrix for tracing the Test Cases and requirements related to them
• Process claims for all lines of business including but not limited to HMO, PPO, POS, TPA and Medicaid/Medicaid.
• Perform data analysis on existing policy comparison to determine the impact on current policies from future system
• Analyze business processes, requirements, and data necessary to provide detailed logic for ETL development.
• Validate current policies as part of requirement analysis and for integration wif future system
• Validated the changes made to existing policies to ensure the policies which are out of scope are not impacted
• Develop UML diagrams- Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Visio.
• Support development of UAT cycle test scripts, Review User Acceptance Test Plan (UAT)
• Manage planning / test process for Medicare Part D Pharmacy Claims (PBM).

ENVIRONMENT: MS PowerPoint, Requisite Pro, XML, TFS, MS Visio, MS Excel, MS Access, Oracle, Waterfall SDLC.

Confidential, Raleigh, NC

Business Analyst

Responsibilities:

• Involved in requirement gathering session wif Business Analystand Architect for building Data warehouse as part of ODS (Operational Data Store) project.
• Elicit businessrequirements and business needs into user stories and acceptance criteria performed story mapping as part of an Agile Scrum team and manage it by using the Team Foundation Server (TFS).
• Work on gathering requirement for the monitoring/ support system for the ODS
• Helped in designing the dashboard/ UI for monitoring the data-warehouse.
• Involved in designing and developing ETL (SSIS) processes & implementing Logging strategies when loading data into data warehouses and data marts.
• Work wif developer in creating Reports in SSRS wif different type of properties like Chart controls, filters, Interactive sorting, SQL parameters etc.
• Prepare test cases and automate them wif using Microsoft Test Manager and Quick Test Pro.
• Worked on Security Test plan for the data warehouse according to HIPAA compliance.
• Attended daily meetings and dealt wif day-to-day deadlines.

ENVIRONMENT: MS Office, Agile, MS VISIO, SharePoint, TFS, Microsoft Test Manager, Quick Test Pro