SUMMARY

• Over 6+ years of experience as a Senior Business Systems Analyst in Banking & Finance, Retail domains on various areas like wealth Management, Asset Management, Online Trading, Portfolio Management, Fixed Income, Financial
• Expertise in Software Development Life Cycle (SDLC) methodologies like Waterfall, Scrum - Waterfall Hybrid, Agile (Scrum, Kanban, Extreme programming) and Scaled Agile Framework (SAFE 4.0).
• Highly skilled in various requirements elicitation techniques and analysis such as Brainstorming, interviewing, requirements workshops, and Joint Application Session (JAD).
• Experience in developing and maintaining data conversion/integration between Oracle EBS and other non-Oracle Applications
• Created various artefacts including Business Requirement Document (BRD), Functional Requirements Document (FRD), Test Plan, Test Scenarios, and Test Cases and maintained Requirement traceability matrix.
• Handled Change Requests by taking upon the role of Change Owner, Interacted with Change representatives, CCAB to review Impact Analysis and documented Change Request Form.
• Experience working on AS-IS and TO-BE write up for claims auditing system.
• Ability to perform rudimentary SQL queries and be knowledgeable on Oracle data model/table structures
• Perform Customer (KYC), Basel II, US GAAP, IFRS, Dodd-Frank, SEC.
• Excellent analytical skills to understand the business processes, functionalities, requirements and translate them into Requirement Specifications and Managed requirements and tracking defects using HPQC AND HPALM.
• Assisted in performing Risk Analysis of the requirements to identify the key business risk for the project, prioritized the application development, and testing according to the prioritization.
• Expert in GAP analysis, Impact analysis, SWOT analysis, Cause & effect analysis, Cost benefit analysis, Feasibility analysis, Risk analysis, Net Present Value (NPV), Return on Investment (ROI).
• Very good experience in troubleshooting technical issues with various Hyperion products
• Assisted product owner in backlog refinement and acted as Proxy to product owner in planning meetings.
• Worked in agile environment in story writing session and written user stores according to (INVEST) criteria.
• Acquainted in UML Modelling and Business process modelling and notations (BPMN) like Activity Diagrams, Sequence Diagrams, use case Diagrams, Process work Flow Diagrams, created UI/UX wireframes, Mockup screens, and prototypes in MS Visio and Mockup Screens.
• Specialized in Design and Optimization of Essbase Applications.
• SharePoint Administration: User Setup, Security Permission, Site Configuration
• Experience with multiple implementations (preferably R12) of Oracle EBS applications
• Visualizing data in Power BI Desktop and deploying Dashboard in Power BI service.
• Extensive knowledge in Data Warehousing architecture, implementation approaches, schemas and dimensional modelling, Seasoned in Creating Data Models, such as Conceptual model and Logical model.
• Performed various SQL queries like SELECT, JOIN, VIEW for relevant data retrieval on Oracle database.
• Designed and implemented SQL queries using joins, unions, outer joins, group by and aggregate functions to extract data from different databases (Oracle, SQL Server) for timely reporting and Validation.
• Extensively used SQL queries for business analytics and analysis of data using data manipulation language.
• Skilled with Data Analysis concepts of Data Modelling, Data Dictionary and Normalization, Created Data Mapping Documents to transfer data from legacy to target system and to reduce data and duplication.
• Comprehensive understanding of Web-Services like XML and RESTFUL API using internet protocol suite like HTTP under Three-Tier Architecture, Service Oriented Architecture (SOA), AWS Platforms.
• Designed and produced API implementation documentation for system integration. Managed in finding on business objects in product research and offering technology-based solutions to the IT development team.
• Prepared the Requirement Traceability Matrix for Tracking, Documenting, Capturing, Managing and Communicating the Requirements.
• Extensive experience in Hyperion Planning, web forms, business rules, Hyperion Financial Reports, Analyzer/Web analysis.
• Experience in Essbase load rules, report scripts, integration tools and overall system architecture
• Expertise in developing Test Plan, Test Conditions, and Test Cases; ensuring adequate testing on software both before and after completion; conducting and documenting UAT
• Experience in writing queries for Data analysis using SQL
• Experience using MS Visio, MS Project and MS office tools like MS-Word, PowerPoint, Excel, and Access.
• Expertise in managing user request changes, and handling user conflicts
• Assist with research and development of new fraud and risk detection models
• Experienced conducting User Acceptance Testing (UAT) and documentation of test cases
• Expertise in creating dimensional models and creating ETL specifications.
• Extensive experience in Smoke Testing, Regression Testing, Functional Testing, Integration Testing, System testing, End to End testing, and User Acceptance Testing. Experience in Manual and Automated testing using HP QTP.
• Proficient in Technical and Business Writing, Business Process Flow, Business Process Modelling, Business Analysis and testing various methodologies.
• Excellent Written&verbal communication skills.

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/Drill Down.

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

Testing Tools: HQPC, Postman

Reporting/BI Tools: Tableau Desktop, IBM Cognos, Domo

Methodology Tools: JIRA, HP ALM, RALLY

Databases: MySQL, Oracle, ESSBase, MS Access, Hyperion

Languages: XML, SQL

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

PROFESSIONAL EXPERIENCE

Confidential

Senior Business System Analyst

Responsibilities:

• Interviewed SMEs and Stakeholders to gather Business Requirements, Functional Requirements, Non-Functional Requirements, Report Specifications, Data Requirements, Data Mappings and Data Flow Diagrams.
• Conducted JAD sessions with clients, 3rd party vendors, end users, developers and other team members to distinguish presented user requests from the underlying true needs, and distinguished solution ideas from requirements
• Documented process flows and developed requirements for functional improvements and enhancements using the UML (Unified Modelling Language) methodologies
• Involved in business modelling using swim lane diagrams in MS Visio, drawing layouts to explain process flows to the developers
• Designed, developed, and implemented Reporting System for the Financial Department using Essbase, planning.
• Performed testing on the Oracle and 3rd party applications that support the defined solutions
• Performed Gap analysis by identifying existing technologies and documenting to meet the end state requirements.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, and Class Diagrams.
• Ensured smooth transition from Waterfall to Agile by following team level Scrum adoption techniques like planning, training and coaching. Convinced management to understand the importance of adopting Agile best practices.
• Management of Enterprise Glossary through the review of common business terms and definitions.
• Collect data issues across the meta data ecosystem, work with business owners and data stewards to remediate issues
• Create a highly structured and comprehensive control environment to assure that content within the catalog is remains in high quality
• Define meta data processes and controls; work with appropriate stakeholders to implement solutions
• Development and configuration of Informatica EDC resources, data lineage, custom resources, custom data lineage, relationships, data domains, data domain groups and composite data domains.
• Develop AI powered data catalog and data lineages using various EDC tools such as Steerwise Data Semantic Analyzer and AXON for enterprise.
• Document and support MFT jobs for various applications like AXCIOM, CROWE, Wallstreet Suite and other data sources.
• Daily support of Oracle Finance by providing system administration and production support to for Oracle and various other financial systems
• Developed business value solution for customers using Hyperion Planning.
• Instrumental in user story management, issue tracking and requirement traceability using JIRA.
• Created RACI matrix to identify all relevant stakeholders in the project.
• Worked on Transaction Monitoring of Data Quality and Data Lineage of Key Data Elements from data source.
• Developed Planning dimensions and Essbase outline.
• Developed workflow diagrams, flow charts and Data Flow diagrams using MS Visio.
• Designed and deployed workflows, validation rules, Approval Processes and Auto-Response Rules for automating business logic with Sales and marketing cloud on salesforce.com
• Collaborated with ETL developers and assisted them to use Informatica MDM to perform data cleansing using the cleanse functions, applying match and merge, trust and validation rules to create a single version of truth.
• Assisted in development of ETL jobs in Informatica Power Center using various transformation such as Source Qualifier, Aggregator, Expression, Lookup, Filter, Sequence generator, Router, Union, Update strategy etc.
• Used Power BI and Excel (Pivot Tables, Lookup and Macros) for analysing and reporting capabilities.
• Assisted QA Team in testing requests to various REST APIs in Swagger UI and in documenting the requests and responses using Swagger editor.
• Defined and setup the application security in Hyperion Planning, Hyperion Essbase, and Essbase Integration Services.
• Wrote transformation rules, verified data through various data profiling techniques to cleanse during reporting.
• Created Test Plans, Test Cases, Test Scenarios and conducted Functional/Non-Functional Testing.

Environment: Agile-Scrum, MS Visio, Informatica, Power Center 9.5, Axon Informatica, MS SQL, Visual Studio, Excel, Share Point, Fiserv PEP, NACHA formats, Hyperion, MS-Office Suite, ServiceNow, Salesforce.com, HTML, XML, REST API,Oracle, LoadRunner v12.0, Power BI, Swagger

Confidential, San Francisco, CA

Senior Data Analyst/ Business Analyst

Responsibilities:

• Chaired Requirement Gathering Sessions (RGS), Joint Application Development (JAD) sessions and Joint Application Requirement (JAR) sessions.
• Gathered business and system requirements for developing application on handling debit card reconciliation.
• Conducted Gap Analysis and created an AS-IS workflow to better understand the mechanics of the existing system.
• Analyzed all the dimensions and members in the Essbase database using Essbase Administration Services.
• Generated reports as per Adhoc request from the client through Data extraction, Data mapping, Transformation, and loading through by using Informatica Tool.
• Used MS Access and EXCEL VBA modules to improve error-handling routines and streamline code using Access/Excel/VBA/ODBC/ADO/ActiveX and Win API tools.
• Worked closely with Client Services/Finance/Fraud & Risk team to gather requirements for designing the Data Warehouse model.
• Addressing the improvement of operational efficiencies with respect to the usage of the Oracle applications in order to add value and ROI
• Design and security planning for the Hyperion HFM Global deployment.
• Coordinated with Business stakeholders and UI team for developing User interface designs.
• Developed business value solution for customers using Hyperion Planning.
• Fine-tuned SQL Queries for maximum efficiency and performance.
• Defined and setup the application security in Hyperion Planning, Hyperion Essbase, and Essbase Integration Services.
• Designed and implemented data warehouse architecture for corporate circulation data warehouse. Subsequent data marts, extracts and reports were sourced from the architecture of conformed facts and dimensions
• Created Drill-down and Sub-Report using SSRS. Monitored the performance of the reports.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Delivered Data flow diagrams, Database normalization theory techniques.
• Coordinated with QA team for Test Planning and Design & creation of traceability matrix for ensuring the consistency of test cases with the business requirements.
• Defined and setup the application security in Hyperion Planning and Hyperion Essbase.
• Worked with Solution Architect team for establishing batch framework and scheduling.
• Delivered High-Level and Low-Level Requirements Documents, Functional specification Documents and Test Plans.
• Designed corporate banking process model with proficiency in Use Case development, UML Modelling with Sequence Diagrams, Activity Diagrams, & Workflow Analysis and data modelling using BPMN.
• Established Incident Reporting and Change Control procedures using JIRA.
• Created Requirements Traceability Matrix (RTM) using Quality JIRA.
• Involved in reviewing the cube design, Performance Monitoring and Performance Tuning of the Essbase server.
• Maintained version control for documents through SharePoint.
• Prepared GAP Analysis Document to display current and future business process with MS Visio.
• Handled SDLC lifecycle of the project in building applications i.e. Plan Driven and Change Driven Methodology including Sprint releases.
• Designed and developed all reports using Hyperion Reports.
• Developed BRD's for enhancement requests from internal stakeholders.

Environment: Agile, SharePoint, Oracle, MS Visio, Informatica, MS Project, Hyperion, Rational CQ, Salesforce.com, HP ALM, Postman,ESSBase,Tableau

Confidential, Washington, DC

Senior Business Analyst

Responsibilities:

• Created Business Requirements gathering sessions in the form of questionnaires and business scenarios with the end users, subject matter experts (SME) and the developers. Gathered user and business requirements through JAD Sessions, interviews, surveys, Process Analysis, document analysis and prototyping.
• Acted as primary liaison between the client departments and the Information systems IT department to perform analysis, review, and estimation of client requests, prepared and reviewed requirements and client documentation
• Performed actuarial calculations such as re-pricing of premium and profit test modelling using Prophet and Excel
• Established a RUP (Rational Unified Process) centric business analysis methodology.
• Collaborated in building a business analysis process model using Rational Rose, Requisite Pro, and Visio.
• Prepared AS-IS and TO-BE write up for claims auditing system.
• Issuing new business, endorsements, renewal review and assisting agents in quoting new business.
• Writing user stories for Business Process Flow, System Integration Testing based on the Configuration requirements
• Worked on conducting User Acceptance Testing (UAT) and documenting test cases
• Performed activities supporting the roll out e.g. the UAT template for Business User for QA, QA Action Item Register Template, and the User Sign Off, the Help Desk Script and Action Steps and Site Maintenance document.
• Worked directly with the PMO to contribute to the budget estimates for the programs. The budgets were project (for conversions) and operational
• Analysed scope of the Edge project was to create a Web-based application
• Coordinated Testing phase defect issues through internal system and managed them with applicable application developers for investigation
• Execute test scripts, coordinated & conducted UAT testing.
• Provided clear and concise documentation regarding requirements management plans, Functional Requirements, supplemental Requirements, Test Plans and Test Cases.
• Utilized corporation developed Agile SDLC methodology. Used Scrum Work Pro and Microsoft Office software to perform required job functions.
• Scrum Master towards improving the way they work
• Analytical skill with interpersonal, communication and self-organizing skills describing a committed Scrum Master
• Conducted mass user interviews with brokers, enterprise user representatives and SMEs.

Environment: Agile-Scrum, P&C, SDLC, PMS, Scrum, SDLC, Ms Office, UML, test plan, UAT, QA, Defect Tracking system