SUMMARY:

• Business System Analyst with diversified experience of 3+ years in Business strategies, Planning, Design, Data Analysis and Testing in IT and Finance domain.
• Demonstrated strong business acumen with technical, project management and analytical skills.
• Designed & developed interactive visualizations & dashboards using Tableau as a business intelligence software for reporting to the C - level management
• Expertise in gathering Functional & Technical Business requirements from various sponsors and stakeholders by understanding business goals and priority through various elicitation techniques like Brainstorming, Interview and breakout sessions, JAD sessions, Document Analysis and Focus group interactions
• Experienced in working in environments like Waterfall, Agile & Scrum with cross functional teams
• Integrating case studies for Legal & Compliance department
• Well versed in all the Scrum Ceremonies & acting as a Scrum Master
• Performed gap analysis to identify the enhancements, differences & opportunities between the current & the expected future system
• Developed User Story, User Requirements Specifications (URS), Functional Requirements Specifications (FRS), Business Requirements Document (BRD).
• Expertise in the roles as a Business Analyst in both functional & technical aspect as well as Scrum master duties
• Worked on JIRA for requirement management, writing User stories and assisted PO in the grooming of Product backlog items using vertical slicing, estimation and Prioritizing the Product Backlog
• Create User Guides to train stakeholders & end users about application under development
• Experience with Salesforce, PeopleSoft financials, Oracle E- Business Suite, JIRA, Trello, Slack, Toad, QuickBooks, MYSQL, Tableau, SharePoint 2013 & 2016, Microsoft Office Products
• Working knowledge of GAAP/IFRS accounting principles
• Designed Mockup screens using Balsamiq to assist the development team for better clarity of the requirement

SKILL:

Business intelligence & data analysis software: Tableau, Microsoft Excel Power Query

Databases: Oracle E-Business Suite, MS Access, SQL, Bloomberg, Salesforce.com, ADP, JIRA, TOAD

Domain Knowledge: Banking, Finance, Healthcare, E-commerce

Languages: C, C++, MYSQL

Operating Systems: UNIX, Windows, Linux

Methodologies: Waterfall, Agile, Scrum

PROFESSIONAL EXPERIENCE:

Confidential, Boston, MA

Business System Analyst

Responsibilities:

• Work with external stakeholders, product owners, finance and IT development to gather and document business and functional requirements and share with developers and business architects
• Create very basic dashboards to very complex dashboards using DAX
• Handle data from different data sources in Tableau
• Work as the Scrum Master to ensure deadlines are met and all issues/roadblocks are solved
• Participate in various scrum ceremonies as Grooming Session, Sprint Planning, daily stand up, Sprint review, Sprint Retrospective meetings for the system development
• Worked with the legal and compliance team to ensure all contracts signed off abide by Industry Standard
• Ensuring the legal and compliance in the development specifications of the application
• Create weekly status report to communicate team’s progress for stakeholders, product owner and C-level executives
• Work with project manager to plan analysis work and highlight risks and issues and report to C-level management as needed
• Contributed 55% towards documenting functional requirements for a complex large- scale global project
• Contributed 90% towards development of materials for enhanced platform solution
• Perform requirements gathering and analysis to provide high quality and detailed requirements, ensuring the closest involvement with, and agreement from the user community
• Ran TOAD queries using Oracle E-Business Suite data for Testing developed enhancements both for current and new system
• Review test cases and scenarios and identify appropriate teams to execute on test cases and scenarios; identify data requirements for testing
• Work with technical business analyst to perform user acceptance testing
• Work with developers to perform API testing

Environment: Oracle E-Business Suite, JIRA, TOAD, MYSQL, Trello, Microsoft Excel, Microsoft PowerPoint, Tableau, Slack, Tableau, Microsoft SharePoint 2013, Postman

Confidential, MA

Business Analyst

Responsibilities:

• Outlined to project features on the basis of user necessities and enhancements by having thorough discussions with the user groups
• Documented the requirements with approvals from the Project Management Office to take care of any scope creek
• Evaluated the requirement development cost as per the vendor to accommodate the project requirements based on the priority levels and to keep the budget within limited tolerance level
• Worked with the users to see that vendor billing is legitimate for the effort level and also to plan the activities carefully so that we don’t use the vendor time on minor issues, therefore reducing the vendor billing costs
• Tracked and documented the budget expenditures to present the same to the PMO (project management office) for approval and estimated the next periods expenditures based on the activities due for the project
• Made use of SharePoint for managing content, creating sites, subsites & business processes, sharing information, enabling better-informed decisions
• Performed GAAP analysis to compare the existing system with the proposed system and documented new requirements and features
• Facilitated JAD sessions between the business users and the Subject Matter Experts
• Used Tableau for data analysis and developed budget forecasting dashboards converting critical business data into actionable insights.
• Used Tableau to manipulate data and perform critical analysis to show important data points
• Developed a formal report and presentation using Tableau with business and technical recommendations
• Prepared daily and weekly reports to the stakeholders and product owner to provide high level information regarding the work in progress
• Have experience executing queries against a database, retrieving data, manipulating data, inserting records, updating records, create new databases, create new tables and set permissions on tables, procedures and views using MYSQL
• Provided recommendations on product development and features
• Conducted sessions for stakeholders, product owners and end users

Environment: PeopleSoft, MYSQL, Microsoft Excel, Microsoft PowerPoint, Tableau, Salesforce.com, SharePoint 2013

Confidential, Sommerville, MA

Treasury Analyst

Responsibilities:

• Created financial reports & prepared monthly budget & expense reports for all the departments within Confidential using Tableau
• Used Microsoft Excel Power Query & advanced pivot table features to extract, transform & load (ETL) data from salesforce & Bank of America CashPro platform to develop reports.
• Liaised with University departments as a Single Point of Contact (SPOC) for Treasury Operations & worked closely with Internal & external partners to answer treasury & finance related questions by researching & interpreting data.
• Assisted Treasury Manager in creating documentation for all treasury & finance related operations & procedures.
• Worked along with the senior treasury analyst in the monthly closing & account reconciliation procedures for the 17 bank accounts operated & owned by Confidential
• Responsible for treasury related activities including processing wire transfers, ACH, daily cash applications, recording transactions & updating data in Salesforce

Environment: PeopleSoft, Microsoft Excel, Microsoft PowerPoint, MYSQL, Tableau, Salesforce.com, ADP

Confidential

Finance Intern

Responsibilities:

• Executed SQL queries, to retrieve data from different databases, for data validation & analysis, researching underlying data errors, and generating reports
• Used MS Excel- power pivot tables for taking enormous amounts of data and summarizing that data into useful reports
• Maintained grant budgets & tracked expenses for the Department of Medicine
• Used MS Excel power query to clean raw data & use the cleaned data to create visualizations & dashboards in Tableau
• Performed intermediate & advanced accounting tasks
• Maintained monthly cash balances, reconciled monthly invoices activities & prepared monthly reconciliations & kept a record of the grants received by doctors for their research projects

Environment: Oracle E-Business Suite, Microsoft Access, Microsoft Excel, QuickBooks, SharePoint 2013

Confidential

Junior Analyst

Responsibilities:

• Analyzed company's financial & operational data to prepare profit & loss reports, customer profitability reports, sales analysis dashboard & financial forecast report
• Identified credit issues early in the underwriting process & recommending ways to reduce exposure
• Updated project documentation using clear, concise language, consistent with the appropriate methodologies
• Partnered with relationship managers to structure multi-million-dollar transactions
• Prepared annual company financial reviews & underwriting memos focused on a company's leverage, key risk factors, repayment sources, cash flow, and ability to service debt
• Assessed the client's ability to repay debt and comply with financial covenants
• Participated in web & classroom-based to train & enhance knowledge in the areas of credit & lending skills to new on boarded employees at Confidential