SUMMARY

• Over 8 years of proactive IT experience as Business Analyst in various industries like Finance and Accounting sectors working with complete Software Development Life Cycle such as Agile (Scrum), RUP and Waterfall which included Business Process Documentation, Business Process Management, and Business Process Modeling.
• Excellent Performance on fixed asset, general ledger, inventory and inventory reserve accounting for different client’s locations.
• Ability to coordinate reconciliation of sub ledger accounts and general ledger based on GAAP and IFRS rules and regulations.
• Adept in Verify, allocate, post and reconcile transactions related to intercompany accounts, analyze financial information and summarize financial status as required.
• Prepare financial statements and produce budget according to budget planning procedure.
• Ability to perform month - end and year-end closing procedures.
• Well-versed in conducting and documenting GAP analysis by analyzing AS-IS versus TO-BE process.
• Excellent documentation skills in creating Software Requirement Specifications (SRS), Business requirements document (BRD), Use Case Specifications, Functional Design Document (FDD), Systems Design Specification (SDS), Requirement Traceability Matrix (RTM).
• Extensive experience in creating UML diagrams such as Activity diagram, Use Case diagram, Sequence, class and Data Flow diagram.
• Extensive experience with Data Warehousing environment, Business Intelligence Reporting, and Web based projects.
• Highly proficient in facilitating and coordinating various project driving techniques such as JAD sessions, & walk-through
• Well-versed with SQL queries using MS SQL Server, Teradata & Oracle
• Highly experienced in end-to-end ETL process including Data Extraction, Transformation and Loading from source systems to target and developing Data mapping documents
• Adept in developing Test plan, Test cases, defect tracking and performing User Acceptance Testing (UAT)
• Expertise in preparing Data Modeling documents for creating Conceptual, Logical & Physical Data Models
• Proficient in working with various Data quality processes such as Data mapping, Data validation, Data mining etc.
• Well-versed with Enterprise Data Dictionary and Data Governance principles
• Excellent Communication skills, Team Participation skills, Leadership qualities, Analytical skills and Problem Solving skills

TECHNICAL SKILLS

• Leadership/Supervision
• Team Building
• Time Management
• Office Management
• Problem Solving
• Critical Problem Analysis/Resolution
• Data analysis
• Financial Reporting
• Presentation
• Investment analysis and recommendation
• Stock/Proprietary/Currency trading
• RUP
• Six Sigma
• Waterfall
• Agile
• UML
• Rational RequisitePro
• Rational Clear Case
• Clear Quest
• Agile
• Rally
• MS Project
• UML
• JAD
• RUP
• C
• C++
• SQL
• PL/SQL
• UML
• .Net
• JAVA
• Oracle 8i/9i
• MS Access
• SQL Server 2008
• MS Windows XP/NT/2000
• 98
• Sun Solaris
• Unix
• MS Office Suite Word
• Excel
• Project
• Visio
• PowerPoint
• Adobe Acrobat Suite.

PROFESSIONAL EXPERIENCE

Confidential, RI

Sr. Business Analyst/Scrum Master

Responsibilities:

• Created Functional Requirement Specification from the Business Requirement Document generated by the business team
• Analyzed and created the process flow diagrams for the Accounting group
• Ensured that the reconciliation of the funds positions/securities to outside sources were correct
• Researched internal differences between the accounting and trade entry systems
• Analyzed funds’ performance on a daily and monthly basis
• Collaborated closely with investment risk, asset management, actuarial, Treasurer's and finance to deploy comprehensive asset-liability risk models (ALM) for use in analysis of investment strategies.
• Responsible for designing the various financial reports in General Ledger using Financial Statement Generator (FSG) so as to match closely with the required information in the reports.
• Defined the reconciliation process - process bank statements and perform reconciliation accounting transactions and generate appropriate reports
• Performed setups for Cash Forecasting and Cash Positioning within Oracle Cash Management module.
• As a Scrum Master conducted the scrum meetings and participating on prioritizing the product backlogs and execution of all sprints with the project team.
• Participated in JAD sessions with the business, developers and other stakeholders.
• Facilitated and managed meeting sessions with committee of SMEs from various business areas including the accounting, operations, IT, and reporting teams.
• Designed Use Case Diagrams and wrote specifications in the Use Case Specification documents based on requirements gathered
• Derived Functional Requirement Specifications (FRS) based on User Requirements Specification (URS).
• Prepared testing data for the User Acceptance Testing as well as guided the business testers during UAT
• Actively participated in daily bug triage meetings, reviews and walkthroughs and interacted with developers to ensure high quality software.
• Communicated the project plan tasks, accomplishments and status to Project/Program Management on a weekly basis.
• Used MS Office Suite including Word, Excel, Access, PowerPoint and Visio for analysis, presentation and documentation.
• Conducted Data validation using SQL Queries and statements

Environment: Microsoft Office including (Project, Word, Excel and Visio), UML, Rally, Agile Scrum, Windows, C#, Oracle, SQL Server 2008, SSIS

Confidential, Richmond, VA

Sr. Business Analyst / Scrum Master

Responsibilities:

• Involved in requirement gathering process by interviews, brainstorms and meetings with stakeholders and SMEs.
• Conducted JAD sessions to allow different stakeholders to communicate their perspectives with each other, resolve any issues and come to an agreement quickly.
• Detailed design of some of the key aspects of the accounting application like Deals management, Revaluation, Accruals, Journals, Cash Positioning, Treasury and Cash management Reconciliation, Cash leveling.
• Identified and created all necessary Business Use Cases from requirements, created UML Diagrams including Use Cases Diagrams, Activity Diagrams and Sequence Diagrams using Microsoft Visio.
• Involved in Performance Management, Asset Management, Credit Management, Client Reporting and implementing its benefits.
• As Scrum Master involved in Sprint estimation and Sprint planning meetings and participating on retrospective meetings at the final stages each sprints.
• Participated in Bug-Review meetings with software developers, QA engineers, managers and suggested enhancements to the existed application from business perspectives, provided solutions to existing bugs.
• Maintained and kept track of stakeholder’s requests for enhancements and changes.
• Worked on a project for the integration of data feeds between the Trade Execution, Custody and Accounting Systems; created the data mapping document and business logic to be used for integration
• Managed the data flow process from transaction systems to back-office accounting systems in Oracle and Access for reporting purposes
• Ensured correct presentation via web reporting of monthly financials, quarterly forecasts, and annual budgets.
• Understood the business logic, User Requirements and test-objectives to develop test plans, test cases, and test case execution using Test Director.
• Created test scripts, test cases and test logs; conducted testing in the DEV and QC environments.
• Ensured that the profit and loss statements were correctly formatted and sent out on a daily basis
• Designed functional specifications for custom interfaces and reports
• Co-ordinated with the business, PM, developers and testers from offshore as well as onshore team, during the testing iterations
• Acted as an SME for the developers as well as the testing team
• Assisted in Conducting UAT (User Acceptance Testing) to make sure that all the user requirements are catered by the application.
• Involved in preparing a simple and detailed User manual for the application, for an intended novice user

Environment: Agile Scrum Methodology, UML,Rally, Java, J2EE technology, Windows 2000 Advanced Server, UNIX, MS Visio, SQL server 2008, Microsoft Office suite.

Confidential, Buffalo, NY

Sr. Business Analyst

Responsibilities:

• Created the GL mapping sheet to ensure proper migration of accounts within the general ledger via account codes to meet GAAP standards
• Involved as a SME in the design of the combined general ledger and the database used to verify the posting process.
• Analyzed thebusinessprocess and confirmed the setups needed to reflect thebusinessprocess using RUP (Rational Unified Process) methodology for its SDLC.
• Involved in requirement gathering process using Rational Requisite Pro, which included interviews, brainstorms and meetings with stakeholders.
• Identified the current business process, documented the workflow and improved the efficiency of the current business process in the Accounting department.
• Understand of Posting, Check payment, Lockbox, Fraud and Exceptions.
• Conducted JAD sessions to allow different stakeholders to communicate their perspectives with each other and resolve any outstanding issues
• Identified and created all necessary Business Use Cases from requirements, created UML Diagrams including Use Cases Diagrams, Activity Diagrams, Sequence Diagrams, and Class Diagrams using Microsoft Visio 2007.
• Involved in the writing the SQL queries and managing the Oracle database for the Posting process.
• Maintained and kept track of stakeholders’ requests for enhancements and changes using Rational Clear Quest.
• Understood the business logic, User requirements and test-objectives to develop test plans, test cases, and test case execution using Test Director.
• Tested the application manually by executing Test Cases prior to Automation.
• Involved in automating test cases using QTP and Load Runner.
• Participated in Bug-Review meetings with software developers, QA engineers, managers and suggested enhancements to the existed application from business perspectives, provided solutions to existing bugs.
• Conducted UAT (User Acceptance Testing) to make sure that all the user requirements are catered by the application.
• Involved in preparing a simple and detailed User manual for the application, for the intended users.
• Provided training to the Users and explaining them the Business as well as the Technical side of the Provident Bank of Maryland system.

Environment: RUP, Erwin, Microsoft Office 2007 (Word, PowerPoint, Access, Excel Macros and Pivot, Outlook, Project, Visio), Rational Requisite pro, Rational Clear Quest, QTP, Load Runner, Mercury Quality Centre, SQL, Oracle 10g Java, SQL Server Reporting Services SSRS.

Confidential, Pittsburgh, PA

Business Analyst

Responsibilities:

• Assumed a lead position in multiple projects and lead a team of analysts in various project efforts, as per the client's request. Delegated responsibilities, created timelines and milestones for project deliverables, and supervised and peer reviewed the documentation and artifacts created for the projects.
• Was involved in all phases of Software Development Life Cycle (SDLC) for Java based Web Sphere applications.
• Facilitated and participated in (JAD) Joint Application Development sessions and analysis sessions with project stakeholders to gather, capture, and document requirements.
• Involved in creating multiple project based technical work products such as Business Process Description (BPD), Project Scope Agreement (PSA), Detailed Functional Requirements (DFR), Use Cases, Systems Development Plan (SDP), and other ad-hoc project related documents.
• Conducted functional walkthroughs, User Acceptance Testing (UAT) sessions, and assisted the development of User Guides and Manuals for customers.
• Created UML diagrams, mainly process flows, activity and use case diagrams. Participated in various client-based meetings and contributed to the meeting discussions, documented Meeting Minutes, maintained Action Items, Decision logs etc.
• Created lessons-learnt documents, Status Reports, mentored and assisted the new team members within the task and at the client location.
• Project tracking and Status Reporting to business users/management.

Environment: MS Office, Waterfall, UML, SQL, SQL server, Quality center, Oracle, UNIX, Java.

Confidential, Addis Ababa Ethiopia

Business Analyst/Financial Application Consultant

Responsibilities:

• Assist clients with implementation and training on AGRESSO Business Software.
• Implement and configure ERP application consulting customers.
• Train end users in specific modules of ERP application.
• Provide post-sales support as needed.
• Gathering requirements, analyze business transactions and execute and process workshops.
• Interact with teams of developers, offshore teams then monitor and tune performances.
• Identify, develop and integrate Oracle ERP solution to meet predefined requirements interacting with clients, sales and technical consultants.
• Participate in all ERP implementation steps as assigned.
• Consult client to collect all relevant data for implementation.
• Prepare necessary project documentations associated with implementation like manuals, customer query data, issue logs and their resolution.
• Identify and develop business processes and demonstrate good report writing skills.
• Implement AGRESSO Confidential .
• Develop and enforce collaborative working relationships with customers.
• Lead process reviews and application configuration discussions with clients.
• Assist clients with implementation and training of AGRESSO ERP application software.

Environment: MS Office, AGRESSO, UML, SQL, SQL server, Oracle, UNIX, Java.

Confidential, Addis Ababa Ethiopia

Lead Accountant

Responsibilities:

• Preparing Monthly inventory analysis reports and preparation of reorder levels for the month based on the requirements.
• Labeling (Tagging) of fixed assets if it’s purchased during the reporting period.
• Check and process all check disbursements, petty cash replenishment and prepare Cash payment vouchers; Check all collections made by cash receipt slip and ensure that it is deposited to the appropriate bank account; prepare receipt memo voucher; Maintain employees’ medical and personal ledgers and prepare necessary journal entries;
• Prepare monthly payroll for all staff and make necessary vouchers for payment;
• Update finance and accounting guidelines, policies, principles and procedures in line with the country’s legal perspective;
• Prepare monthly bank reconciliation for available bank accounts;
• Prepare monthly, quarterly and annual financial reports such as Trial balance, Balance sheet, cashbook, Account schedule, Transaction list and Income statement as per stated rules and regulations;
• Prepare monthly, quarterly and annual budget plans and revisions as per stated rules and regulations;
• Monitor each budget through specific activity plans as per stated rules and regulations;
• Prepare both financial and accounting reports for concerned internal and external parties;
• Conduct periodic overall project monitoring activities;

Environment: SCALA, MS Office, SQL, Oracle, UNIX