PROFESSIONAL SUMMARY:

• A team player with ability to form and maintain partnership with stakeholders and technical teams to create productive work environment.
• Excellent understanding of financial accounting including Reconciliations, AR, AP, Inventory, Auditing, Regulatory Reporting, Balance Sheet, Trial Balance, General Ledger, Profit & Loss and working knowledge in Oracle Finance and SAP FICO.
• Experience in creating and executing SQL queries across various RDBMS platforms for the purpose of data analysis.
• Provided daily client service assistance to human resources and associate inquiries regarding payroll and Actavis policies and procedures.
• Experience in documenting process flows with Team Foundation Server (TFS).
• Experience working on agile scrum methodology and project planning and tracking using JIRA
• Coached and guided team members on agile practices to create business value and benefit from self - organization.
• Experience in System Wide Analysis, Unit testing, Application Testing, System Integration Testing and UAT.
• Proven ability to converse, liaise, negotiate and relate with a wide range of personalities from diverse socio-economic and cultural backgrounds.
• In Depth understanding of the AS-IS and TO-BE business gaps processes and experience in converting these into detailed Business and Functional requirements with use case modeling wherever applicable.
• Experience in requirements elicitation, Gap Analysis, Risk Analysis, Stakeholders Meetings and JRP sessions.
• Experience in developing UML use case diagrams, work flow diagrams, data flow diagrams, flowcharts, screen mockups and report prototypes using dynamic UI with HTML, MS VISIO.
• Excellent skills in Change Management, Business Analysis, Requirement Analysis, Cost Benefit Analysis and ROI.
• Experience in understanding complex financial products, financial and management reporting and month end closing process.
• Created Product Backlog, Sprint Backlog and managed User stories.
• Experience in development of web based portfolio management system, asset management, wealth management and financial software applications.
• Excellent documentation skills in creating BRD, Use Case Specifications, SRS, FRD and Minutes of Meeting.
• Experience in SQL including writing Views & Joins
• Proficient in MS Office 365 - Excel (VLOOKUP, Cell References, Macros), Word, PowerPoint.
• Assisted in scripting business logic in the web methods of Web Services and documenting the Web Service Level Agreements through XML into the business engine rule of the system.

TECHNICAL SKILLS:

SDLC Methodologies: Waterfall, Agile - Scrum.

Business Modelling Tools: MS VISIO, Balsamiq, Rational Rose

Project Management Tools: Rally, JIRA, SharePoint, TFS, HP ALM

ETL Tools: Oracle DB, MS Access, SQL Server 2000, Informatica-Power Center, SSIS, Sequel Pro, Erwin.

Reporting/ BI Tools: Crystal Reports / Crystal Dashboards, Tableau, SAP BI, R Studio.

Defect Tracking/ Testing Tools: HP QC, Test Director, Soap UI, Rational Clear Quest.

Databases: SQL, MS Access, Informix, Oracle (PL/SQL), TERADATA SQL, SSIS, SSRS, SSAS

PROFESSIONAL EXPERIENCE:

Confidential, Illinois

Business Analyst

Responsibilities:

• Facilitated Scrum of Scrums for onshore and offshore testing teams. Provided daily client service assistance to human resources and associate inquiries regarding payroll and Actavis policies and procedures.
• Managed triage calls involving dev teams, testers and business users
• Completed requirements analysis for Loan Origination System (LOS) project and Compliance Engine project. Documented the same in the form of Requirements documents and Use Cases.
• Identified critical activities and suggested improvements in current practices.
• Created SQL queries from scratch to query database for data validation of test scenarios in the banking applications
• Interacted with business stakeholders from multiple departments including: Card Finance, Accounting, Third Party Investor Reporting and Capital Market and led meetings and interviews.
• Designed Project Documentation such as Project Charter, Process Flows, Business Systems Design Report, Release Notes, meeting minutes, End User Training Materials using MS Word, MS Visio.
• Worked with QA team in UAT planning and execution. Worked on data migration rules, business rules and data definitions
• Designed and developed Use Cases Scenarios, Use Cases Models, Activity Diagrams, and Sequence Diagrams using UML.
• Used MS Excel Spreadsheet, V-Lookup, Pivot Table for requirement gathering and visualizing the data.
• Used Requirements Traceability Matrix (RTM) for end-to-end mapping of system specifications and test cases ensuring full coverage.
• Designed test cases, test steps, requirements, test scripts and performed testing using HP ALM.
• Scheduled meetings with developers and testers to identify resource allocation and project completion using MS Project.

Environment: Microsoft Office Suite, Microsoft Visio, HPALM, SQL, ISAM, SharePoint, JDMS

Confidential

Scrum Master/ Business Analyst

Responsibilities:

• Facilitated Daily scrum meetings, Sprint planning, Sprint review, and Sprint retrospective. 
• Created Product Backlog, Sprint Backlog and managed User stories.
• Documented user manuals and training materials.
• Used MS PowerPoint, MS Visio, Erwin and Excel for Presentations, documentation of the data.
• Performed various SQL queries like joins and unions to validate data sources.
• Created UAT/QA test plans, strong manual, functional, system Integration and regression testing in an agile development environment for different business users and product owner within the organization.
• Gathered business requirements by facilitating JRP sessions, interviewing business users and stakeholders, conducting one to one sessions and consulting existing system documents.
• Performed GAP Analysis to identify the deficiencies of the current system and to identify the requirements for the enhancement in the proposed system.
• Publicized the team's progress and successes to make sure they are highly visible to product owner/ stakeholders. 
• Facilitated JAD sessions with stakeholders, end-users, SME’s and QA/Development lead to generate business requirements document (BRD) & functional requirements documents.

Environment: Agile methodology, Kanban, Microsoft Office 365 Suite, Microsoft Visio, JIRA, Microsoft Project, SQL