SUMMARY:

• A diligent result - oriented facilitator between Business Systems and Information Technology with 8 years of experience in the field of business and data analysis and a proven track record in various finance areas such as financial mortgage, retail management. health care and mutual fund companies including big 4 consulting experience.
• Good knowledge of the Software Development Life Cycle (SDLC) and Iterative Software Development methodologies such as AGILE, WATERFALL, RUP (Rational Unified Process).
• Excellent Business skills in writing Business requirement document, Use Case Specifications, Functional Specifications, Systems Design Specification (SDS), Workflows and Unified Modeling Language (UML) diagrams such as Use Case diagrams, Activity diagrams, Class diagrams and Sequence diagrams.
• Good Team player with excellent trouble shooting and problem-solving skills.
• Ability to gather business and technical requirements from both formal and informal sessions utilizing a variety of software tools including, Use Cases and followed the Rational Unified Process
• Experienced in creating URS (User requirement Specification), FRS (Functional Requirement Specification) and business process flow system.
• Experienced in MS Office Suite, MS Project (for Project Plan), MS Visio, Rational Suite (Rational Rose, Rational Requisite Pro, Rational Software Modeler) and gathering user requirements and technical documentation.
• Specialized in Requirements Traceability Matrix (RTM), test plan and test procedure development and review, project customization and administration, defect management, configuration management and version control, and business documentation
• Created User Interface (UI) specifications, prototypes and wireframes using Axure Pro.
• Articulate in business values, managing user expectations and client satisfaction, and introducing innovation to business processes through technology.
• Excellent Analytical, Presentation, Communication and Interpersonal skills with proficiency in demonstration and highly adaptable to new technologies & business environment.
• Strong team builder with excellent analytical and communication skills with capability to handle new technologies and situations.
• Good understanding of QA Methodologies, Matrix and Process.
• Responsible for the planning and coordination of teams when scheduling and maintaining status of projects and assigned project deadlines.

SKILLS & TOOLS:

Industry Knowledge: Tax, Finance, Banking, Mutual Funds, Healthcare, Logistics, International Trade.

Business Skills: Business Definition Requirements, Business Process Analysis Data analysis & Research Use Case Modeling & Analysis

Software Tools: Rational Req Pro, MS Office Professional, Microsoft Sharepoint, MS Visio, MS Project, Tableau.

Programming Language: C# .net, Fundamentals of Java Programming, Oracle Finance.

Operating Systems: Windows 2000/XP/NT, DOS and Solaris (UNIX)

Databases: Oracle, SQL Server and MS Access

PROFESSIONAL EXPERIENCE:

Sr. Business Analyst

Confidential, Texas

Responsibilities:

• Responsible for ETL from a dedicated SAP and creating critical ad hoc SQL queries to satisfy stakeholder’s requirements
• Lead requirements gathering for effective logistics systems and architected scorecards with foremost business KPIs
• Collaborated with Transportation team, explored and implemented 3PL, and Transportation Management System
• Validated and presented planning tools to the top management, and received funding for implementation
• Responsible for product database tracking and creating Purchase orders(POs) and sales order(SOs) in NetSuite ERP
• Co-ordinated and validated with the customer relation(CRM) team for the enhancement of SAP PP and Red Prairie WMS
• Responsible for data analysis reporting for both production function and quality, such as quantitative approach for production function and qualitative approach for quality analysis of the business.
• Engaged in the SDLC throughout projects from inception to go-live and provided technical support and training for the AIM Inform platform
• Experience working with platform integration and e-commerce solutions in both Agile, Waterfall and hybrid environments
• Worked closely with end users and clients during user acceptance testing (UAT) to ensure all features and functionalities are developed as originally specified
• Served as a conduit between clients, internal stakeholders and technical teams
• Client relations, negotiation and conflict management
• Agile and Waterfall methodologies
• Project management tools: Microsoft Team Foundation Server, Jira, Confluence, Quality Center
• Outperformed the warehouse operations such as receiving, shipping and SKU tracking for different locations nation
• Collaborated with 14 international clients in Germany, Italy and Netherlands and analyzed CAPA for failed products
• Carried Out pricing elasticity analysis using a multiple regression model to arrive at an optimal price for abrasives products
• Performed deep dive analysis on company’s client performance and provided recommendations on effective budget use
• Architected Tableau dashboards for the whole company to generate insights and monitor business performance
• Worked Cross functionally across engineering and product management to build KPIs for product’s core features tracking

Environment: - MySQL, SAP EAM, MRP, Excel VBA Macros, Tableau, IBM Cognos Analytics and Power BI, Six Sigma, Lean, NetSuite ERP.

Sr. Business Analyst

Confidential, Milwaukee, Wisconsin

Responsibilities:

• Piloted a multimillion dollar effort to rewrite and redesign legacy credit enhancement project.
• Followed Agile SDLC methodology and part of the Advance scrum team.
• Participated and often led sprint planning to identify stories for Requirement Analysis from the sprint backlog.
• Work with internal and external stakeholders to develop Epics, User Stories etc. and prioritize them.
• As a Business Analyst heavily involved in the initial project planning, Epic refinement and review of L1 & L2 process flows.
• Conducted JAD sessions to reach consensus on system functionality, and formal walkthroughs on functional and system specifications.
• Followed Agile methodology on the project and participated in backlog grooming and showcase sessions.
• Involved in story acceptance.
• Conducted walkthrough sessions with the business, development, QA and end-users to review requirements.
• Maintained sprint tasks and build phase child stories in Rally.
• Adopted Gherkin format to write acceptance scenarios as basis for requirements.
• Coordinated development efforts and facilitated requirements acceptance.
• Created UI mockups for requirement validation with business and story walk through.
• Was involved in Enterprise Analysis reviewing available documents on various document repositories.
• Worked on the Functional Grid project to document the complete end to end functionality of the Credit Enhancement application.
• Work very closely with Scrum Master, Project Manager, Product Manager and the Scrum team to support seamless and efficient flow of work.
• Maintained requirements in DOORS requirements management tool.
• Increased accuracy in budgeting and forecasting (RMS) of group financial performance and profitability by providing comprehensive analysis of complex data sets throughout the group lifecycle.
• Responsible for managing Revenue Management Systems (RMS) for all the projects in the team, solely tracked revenue records for all the projects for the business analysis purpose
• Analyzed research on operational procedures and methods and recommend changes for improvement with an emphasis on automation and efficiency.
• Eliciting, documenting and managing business need, functional and non-functional requirements.
• Designed and implemented SQL queries using Embarcadero DB Artisan for QA Testing and Report / Data Validation.
• Performed manual testing to assess application’s overall functionality, performance and stability.
• Reviewed and ran test cases in the test lab using ALM.
• Reporting and presentation of key components and milestones to top management
• Responsible for preparing status and reports for senior management.
• Maintaining and sharing project documents via SharePoint, maintaining MS SharePoint site for project team.
• Facilitated the elicitation sessions with the Practice and the stakeholders and gathered the functional requirements.
• Post production release, involved in Agile / Scrum styled maintenance efforts to fix defect and roll out enhancements in a short cycle.
• Represented the BA team on daily Scrum stand up meetings to share the team’s status and planned our effort for each sprint.
• Manage pipeline of conventional & government loans.
• Evaluate loan documentation and clear conditions as per delegated authority.
• Maintain high level of customer service by being proactive in communicating with the loan originators.
• Take active role as an escalation point within the team based on experience and knowledge. Assist in training new hires.
• Responsibilities with respect to “Income Calculation” process of a borrower for a home loan:
• Evaluating the income statements of the borrower’s like Pay slips, tax returns and arrive at qualifying income of the borrower which needs to be considered while funding any loan.
• Providing consistent support to “Underwriters” who play a crucial role in determining borrower’s income and who make a final call to fund a loan to the borrower.
• Responsibilities with respect to “Closing & Funding” process:
• Reviewing all loan file documentation for authenticity
• Responsible for providing information to assist Risk Manager in making critical funding decisions.
• Worked hand in hand with title companies and brokers
• Provided clear understanding to title companies and brokers as to how to correctly complete final loan documentation
• Responsibilities with respect to Cancellation process where in a home loan is not funded to the borrower:
• Reviewing the documents provided by the borrowers with respect to his employment, assets, liabilities, income from other sources and the appraisal report of the property.
• Depending on various factors, make a call as to finance the loan or to reject the loan.
• Providing continuous assistance to the “Underwriter” in financing the loan or to reject the loan.

Environment: C-MAX, IBM mainframe, VB scripting, Excel VBA Macros, Tableau, IBM Cognos Analytics and Power BI, Six Sigma, Lean, NetSuite ERP, Rally, Jira, Doors, UML, SharePoint, ALM, Embarcadero DB Artisan, SQL, MS Outlook, MS Word, MS Excel, MS PowerPoint, MS Access, MS Visio and MS Project.