SUMMARY

• Business Analyst with over 9years of experience supporting business solution software and analyzing business operations. Aiming to utilize my strong prioritization skills and analytical ability to achieve the goals of your company.
• 9 + years of IT experience as a Business Analyst and Financial Analyst in deployment of web - based, Client-Server applications, developing business processes and system solutions for various projects from conceptualization to implementation.
• Extensive experience in Software Development Life Cycle (SDLC): analysis, design, development, testing, and implementation of projects for various Banking/Financial, Healthcare, Education, Mortgage Clients.
• Knowledge of Project Life Cycle, User Interface Designing, Testing, Quality Assurance, implementation and support within Agile/Scrum & Waterfall environments.
• Experience working in a Scrum team environment and participate in backlog review and Sprint planning sessions, following Agile methodology
• Experienced in Requirement Analysis, Test Design, Test Preparation, Test Execution, Defect Management, and Management Reporting.
• Experienced in developing Data Mapping, Performance Tuning and Identifying Bottlenecks of sources, mappings, targets and sessions.
• Strong understanding of Data Modeling in data warehouse environment such as star schema and snow flake schema.
• Coordinate with customers and staff and provide support to all data analysis. Perform data analysis on all results and prepare presentations for clients.
• Coordinate with various teams and ensure accuracy on all deliverables and prepare summaries.
• Competent in transforming Business Requirements into Functional Requirements and designing business models using UML diagrams - Use Case diagrams, Activity diagrams and Sequence diagrams.
• Conducting Gap Analysis and Documentation of Use Cases and User Stories.
• Interact globally and independently to execute a concerted business plan approach.
• Expert in writing, reviewing, executing Test cases and have exposure to all stages of SDLC and Agile/Scrum Methodology
• Experienced in BI Reporting tools such as Business Objects, OBIEE
• Experienced in development of ETL mapping and scripts.
• Excellent Practical exposure in UI/ Functional/ Regression/ Database/ User Acceptance/Browser/ Web Services testing
• Good knowledge of automation testing, automated testing tools
• Experience in transforming Users expectations of the system into Business Requirements and subsequently designing the solution.
• Interact globally and independently to execute a concerted business plan approach.
• Experience in interacting with QA / Dev teams in fixing errors, development of Test Plans & Test Cases and conducting User Acceptance Testing (UAT). Assisted the QA team in different phases of testing such as System testing, Functional testing, Regression testing and Integration testing for Quality Analysis.
• Traced requirements through the development process and verified adherence using the Requirements Traceability Matrix. Strong Documentation Skills- Process Flows, Use Cases, BRD, FRD, Technical Design Document, Project Plans.
• Good understanding of Data Analysis, Design, Data Modeling, Data Conversions and ERDs.
• Financial Strengths include: Financial Reporting & Analysis, Variance analysis, Portfolio Management Complex problem solving, Accurate forecasting, Financial reporting expert, Profit and Loss and balance sheet analysis.
• Strong analytic and problem-solving skills, excellent planning and multitasking abilities, with proven experience in utilizing people and process knowledge to help enterprise make critical decisions.
• Elicit and build requirements using interviews, document analysis, business need statements, use cases, business scenarios, task and work flow analysis and coordinate business sign off.
• Convert the business expectations (scope) into User Story document (BRD) covering all the requirements.
• Demonstrated experience with complex data analysis (data profiling)
• Strong IT BA background with proven ability to deliver on large complex projects that are highly interfaced
• Identify user requirements by working with a number of key individuals from the business and IT, producing high-level business requirements and liaising with development to take these through to a detailed functional specification.
• Contributed to projects being on schedule and meeting client needs.
• Knowledge of Team Center Software and Project Life-cycle Management
• Managed business testing through the quality assurance team for key projects.
• Partnered with business development to identify major account opportunities.
• Prepared reports to communicate investment assets, expenses, sales and mortality. Prepared monthly and quarterly Gains by Source (GBS) reports for executive management.
• Drafted quarterly variance analysis and presentation slides for executive board meetings.
• Effective Communicator with good Interpersonal and Customer Relational skills.

AREAS OF EXPERTISE

• Business Analysis
• Quality Analysis
• JAD Sessions
• Use Cases and User Stories
• UAT & Test Planning
• Change Management
• Team Center
• Project Life-cycle Management
• Data Mapping & Analysis
• Financial Accounting
• Documentation & Reporting
• Financial Analysis
• Business System Analyst
• Project Management
• Portfolio Management
• Requirement and Gap Analysis
• Client/Vendor Relations
• Data Flow & Process Mapping
• Technical Writing (Manuals/System Specs)
• Forecasting and Planning
• Financial Modeling
• Budgetary Monitoring
• Data Analyst
• SQL Queries & Data Modeling
• MS-Project
• MS ACCESS (up to Access 2010 with SharePoint)
• OBIEE 11.1.1.7.1 with patches,
• Oracle Applications (ERP) financial Modules (AR, AP & GL)
• Quality Center, SoapUI
• RDBMS

TECHNICAL SKILLS

Methodology Databases: SQL, Oracle

Operating Systems: Microsoft Windows XP, NT, 2000, 98, 95, UNIX, AS400

Software: Microsoft Project and Visio, Rational Rose, JIRA

Processes/Technologies: Rational Unified Process (RUP), SDLC, Waterfall, Agile/Scrum, Use Cases, Storyboards, Scenarios, UML, Joint Application Development (JAD)

Automation Tools: Quality Center, Share Point, Soup UI

System: Rx Claim, EMS

Tools: MS-Project, MS-office, MS Visio, MS (Excel, Word, PowerPoint), MS

Business Intelligence: OBIEE 11.1.1.7.1 with patches

Analytical Skills: Variance analysis, Complex problem solving, Accurate forecasting, Financial, reporting expert, Profit and Loss and balance sheet analysis, Business Analysis

PROFESSIONAL EXPERIENCE

Confidential, Detroit

SR Business Systems Analyst

Responsibilities:

• Developed project backlog and sprint backlog from requirements and run daily sprints. Tracked and monitored tasks and team collaboration using agile tool Jira and confluence for code collaboration.
• Produced sequence diagrams, business mappings, performed data analysis, UML diagrams for functional requirements documentations.
• Worked closely with PMO to produce daily executive reports, gather business intelligence and organize periodic checkpoint meeting involving key members of the organization and project team.
• Worked with NASCO applications such as EEC, HRBK (benefit file), HEHK (EEC application for claim processing and unit testing), HIQK (online inquiry), HRUK(ded max categories maintenance), HURK(Procedure file maintenance and specification, mnemonics.
• Transmitted data successfully between Confidential /NASCO, AccumTech and Ancillary Vendors using a standardized format with all necessary data.
• Supported the overall project goal to transition from EAV to AccumConnect and utilizing AccumTech’s ClaimGen system
• Worked with Standardization documentation side using Benefits tools.
• Worked with external vendors for Ancillary integration
• Performed analysis in Data Exchange and File Exchange daily
• Performed SIT testing in NASCO EEC Application.
• Responsible for executing Test cases in Unit Test Plan provided by NASCO Analyst.
• Interacted with Procedure File, Provider File, Diagnosis File, HIQK online screens as a part of Claim analysis.
• Worked with NASCO Customer Service Work Station(NCSW) and HCBO.
• Tested 837 professional and facility claim transactions
• Created both positive and negative test cases according to the Business Rules and Business Strategies.
• Developed procedure and Diagnosis tables for ICD 10 in benefit file.
• Followed the design and review process to move any changes to production
• Worked with Business and the claims production support team on the requirements provided for benefit coding.
• Implemented benefit file logic based upon benefit grids in Excel format.
• Gathered and documented business requirements from Trading Partners, user groups and Agents via workshops, interviews and surveys.
• Worked in close collaboration with the Project Manager and business users to gather, analyze and document the functional requirements for the project.
• Worked with NASCO NPS System and analyzed the business requirements for NASCO Benefits. Automation Process for Group Level as well as Member Level.
• Worked on Group Automation Process and generated Benefit books and NAEGS Forms
• Routed Columns / level number for New Groups based on the requirement.
• Worked on new change system requests (CSRs) for NASCO Benefits Automation Process
• Worked with Benefit file components using Benefit file Inquiry and Maintenance application.
• Worked on HIQK & NCSW CSR’S and current, Future State documents
• Worked on Project Documentation using MS Office and MS Project

Environment: NASCO NPS, IBM Mainframe, Cognos,JCL, COBOL, CICS, VSAM, ENDEVOR, Gentran Server, Manual Testing, TSO/ISPF, SQL Server 2005, Oracle 9i, DB2, MS Office, MS project, Unix, Windows 2000/XP

Confidential, Detroit, MI

OBIEE Business Analyst/OBIEE Consultant

Responsibilities:

• Gathered requirements, documented and delivered functional specification documents and configured CRM to meet requirement.
• Interacted with business representatives for gathering the Reports / Dashboards requirements and to define business and functional specifications.
• Created and Modified reports using RTF, XMLBI publisher
• Work in a Scrum team environment and participate in backlog review and Sprint planning sessions, following Agile methodology
• Design test cases and ensure the test cases trace back to the original business and technical requirement
• Validated technical design created by developers against functional specifications.
• Worked with QA team to design test plan for user Acceptance Testing (UAT)
• Wrote SQL queries for data manipulations.
• Provided formal project presentations to the client, executive management and line staff as required
• Conducted requirement workshops among all project stakeholders to verify and validate the business requirements
• Assisted in design review meetings making sure all the requirements are covered in the development project scope.
• Database queries and updates using My SQL in Oracle.
• Took part in the product management to roll out the planning, forecasting and marketing the product.
• Assisted in design review meetings making sure all the requirements are covered in the development project scope.
• Created Answers, Dashboards, as per user requirement.
• Develop Answers using advance scripting RTF, XML, XLS, XSLT Languages.
• Developed many Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular with global and local Filters) using Presentation Services.
• Generated Drill down Reports, Drill down Charts, Summary Reports, Navigational Reports, Sub reports, Linking Reports etc.
• Customized out Of Box Dashboards and Reports as per the User requirements given by the client.
• Actively involved in deployment and post release support.
• Trained the users on how to use the Dashboards and Answers and also modify the stored reports in Answers

Environment: OBIEE 10.1.3.4.1 , BI Publisher, Oracle 11g, SQL Developer, Window XP, Windows server 2008, Jira, Agile, BI publisher, MS office

Confidential, Pittsburgh

SR Business Analyst

Responsibilities:

• Performed Requirements Gathering and Analysis, interviewed business users to gather requirements and analyzed the feasibility of their needs by coordinating with the project manager and technical lead.
• Defined frameworks for Operational data system (ODS), Data warehouse (DW), and Data Quality (DQ) and created functional data requirement (FDR) and Master Test Strategy documents.
• Conducted workflow, process diagram and gap analyses to derive requirements for existing systems enhancements.
• Performed impact analysis for DB2 tables that needs to be compressed and archived to implement the lower cost storage mechanism.
• Defined target load order plan and constraint-based loading for loading data correctly into different target tables.
• Designed and created Data Quality baseline flow diagram, which includes error handing and test plan flow data.
• Gathered and documented business and technical requirements (BRD, FRD) from both formal and informal sessions and validate the needs of the business stakeholders.
• Work in a Scrum team environment and participate in backlog review and Sprint planning sessions, following Agile methodology
• Performed Gap Analysis to identify the deficiencies of the current system and to identify the requirements for the proposed system
• Identified, researched, investigated, analyzed, defined opportunities for business process improvement, documented business processes and initiated efforts to make improvements
• Conducted and participated in JAD sessions with stakeholders and system users to collect the software requirement specifications (SRS)
• Participated in and contributed to as-Is and To-Be Process Modeling Sessions, and build process models
• Worked on Requirements Traceability Matrix (RTM) which defines mapping between requirements in project and corresponding test cases
• Created use case models, activity diagrams and sequence diagrams using MS Visio
• Conducted highly interactive JAD sessions with project stakeholders, subject matter experts (SME’s), users, QA team and project management team for requirement gathering
• Worked with the Project Manager on various Project Management activities like keeping track of Project Status, Deadlines, Project estimation and Compliance Issues
• Used Share Point to store and track all the documents with different version of documents. Also used a Share Point to retrieve the document if needed
• Experienced with Change request (CR) process. Analyzed and documented the proposed changes as requested
• Reviewed the functional test plan prepared by Quality Assurance (QA) team and assisted QA team in preparing the test cases, test scripts, test plans and also in tracking the bugs using Quality Center
• Used Quality Center to create and Maintain Test requirements, for defect tracking, reporting and analysis.
• Worked on EDW (Enterprise Data Warehouse) Projects
• Was responsible for tracking issues that are detected and updating the status of existing issues based on the daily meetings with the off-shore team
• Identified user requirements by working with a number of key individuals from the business and IT, producing high-level business requirements and liaising with development to take these through to a detailed functional specification
• Prepared status report, allocation and management of technical and human resources using MS Excel and Project
• Created QA Test plans, Test Cases for Functional, Integration Testing and participated in UAT.
• Responsible for Database testing using SQL queries
• Used SOAP UI in analyzing the Request and Response as part of Defect Analysis
• Created a defect tracker log. And Provided clarifications and project updates to offshore
• Was responsible for tracking issues that are detected and updating the status of existing issues based on the daily meetings with the off-shore team
• Identified user requirements by working with a number of key individuals from the business and IT, producing high-level business requirements and liaising with development to take these through to a detailed functional specification
• Managed business testing through the quality assurance team for key projects
• Used AS400 SQL queries to extract/analyze the data from the database
• Used TOAD to connect the database and ran SQL queries to view data and analyses data for business Requirement

Environment: Windows XP, SDLC, MS Visio, Agile, HP Quality Center, SQL Server 2010, MS Office, MS Share point.

Confidential, Louisville

Business Analyst

Responsibilities:

• Involved in requirement gathering including interviews, brainstorms and meetings with stakeholders and created requirement specification
• Created data flow diagrams, data mapping from Source to stage and Stage to Target mapping documents indicating the source tables, columns, data types, transformations required and business rules to be applied.
• Documented the business requirements of the desired system in the Business Requirement Document using Rational Requisite Pro
• Created Functional Requirement and System Specification documents
• Involved in preparing Use Cases and Business flow diagrams for the applications using UML
• Worked in a Scrum team environment and participate in backlog review and Sprint planning sessions, following Agile methodology
• Involved in Writing technical documents using the functional specifications.
• Assisted Business Analyst in documenting business requirements, technical specifications and implementation of various ETL standards in the mappings
• Analyzed the business requirements and involved in writing Test Plans and Test Cases.
• Involved in the design of Data-warehouse using Star-Schema methodology and converted data from various sources to oracle tables.
• Developed views, functions, procedures, and packages using PL/SQL & SQL to transform data between source staging area to target staging area.
• Involved in Writing PL/SQL code using the technical and functional specifications.
• Prepared Business Process Models that includes modeling of all the activities of the business from the conceptual to procedural level. Followed top down, leveled technique for building Business Process Models
• Created Use-Case Models using Rational Rose to depict Actors and Use-Cases in various Business Processes and identification of Basic/Alternative flows and definition of preconditions and post conditions of the System.
• Implemented an integrated RUP solution with complete line of trace-ability for all the artifacts of web development projects.
• Verified the functional aspect as per the Business Process and validated the interfaces with the other systems and data conversion from the legacy system. Worked with the UI team to create the User interface screen-shots to be presented to the business.
• Interacted with developers and various members of the team to discuss and resolve technical issues
• Utilized MS Visio for creating functional flowchart and documented Business Deliverables.
• Involved in daily quick EOD Touch point Scrum sessions, any impediments, showstopper for the application process work flow.
• Assisted Developers with designing, building, testing and debugging workflows based on business and technical requirements.
• Acted as liaison between Requirement Management, Testing Team
• Created Business Rules Spread Sheet (BRS) as needed and Requirement Traceability Matrix (RTM) to track the requirements and link it to the test cases.
• Created QA Test plans, Test Cases for Functional, Integration Testing
• Developed User Accepting Testing (UAT) plans and test cases based on the business requirements.
• Defect tracking and management using QC
• Performed basic Sanity Testing via navigation and work flow of the Application

Environment: Windows XP NT/2000, UML, UNIX, Agile,Microsoft Change Management Software, Rational Rose, MS Visio, MS Word, Clear Quest, Weblogic, RUP, PL/SQL, Database, Quality Center, UAT

Confidential

Financial Business Analyst

Responsibilities:

• Worked closely with the development team to understand functionality, resolve issues and provide feedback from the UML diagrams.
• Review the loan documents to identify the triggers associated with the loan and performs the analysis based on the tests suggested under the document.
• Will be responsible for calculating and analyzing certain ratios regarding the performance of the commercial properties.
• Must be able to identify certain variances in the calculations and provide analysis comments regarding the property.
• Legal language interpretation and analysis.
• Interpret and clarify queries and disputes on documentation, legal language interpretation and analysis.
• Prepared monthly analysis of operational expenses against prior year and budget, providing explanations and business solutions to help mitigate the risks
• Established new forecasting tracking and management reporting system to improve availability and accuracy of financial data triggering 15% increase in accuracy
• Managed the operations of the treasury department, including the design of an organizational structure adequate for achieving the department's goals and objectives
• Defined business processes, identified gaps, evaluated requirements and managed Project scope.
• Conducted and participated in the JAD sessions for requirements gathering, analysis and design, time line and proposed alternate tasks.
• Interacted with the users for verifying user requirements, updating existing documentation.
• Actively involved in executing and coordinating functional and user acceptance testing (UAT).
• Conducted requirement workshops among all project stakeholders to verify and validate the business requirements
• Took part in the product management to roll out the planning, forecasting and marketing the product.
• Assisted in design review meetings making sure all the requirements are covered in the development project scope.
• Database queries and updates using My SQL in Oracle.
• Supplied necessary industry and market research to target new businesses.
• Took part in the product management to roll out the planning, forecasting and marketing the product.
• Assisted in design review meetings making sure all the requirements are covered in the development project scope.
• Used Excels financial functions and various other features like Pivot table, Pivot chart report for reconciling various reports.
• Used MS Office Suite (including MS Project) components for project tracking, documentation, and presentation to senior management
• Used Excels financial functions and various other features like Pivot table, Pivot chart report for reconciling various reports.
• Used MS Office Suite (including MS Project) components for project tracking, documentation, and presentation to senior management
• Analyzed user statement of requirements to develop new reports.
• Experience with report creation using SQL queries.
• Took active part in the customer support, answering queries of customers and also helped in configuring the VOIP devices

Environment: LAN, Agile,MS VISIO, MS Office suite, SQL server.

Confidential

Financial Business Analyst

Responsibilities:

• Worked in partnership with, departmental managers and others on critical strategic planning, organizational architecture, organizational development and process redesign
• As a Business Analyst worked on multiple projects
• Write business requirements and walk a project through all phases of SDLC lifecycle
• Participate UAT testing for the BASS (Benchmark Automation Syndication System-Application), created project documentation
• Interface with external counter parties to assist with trouble calls and support requests
• Ensure the development teams are practicing the core agile principles of collaboration, prioritization, team accountability, and visibility
• Work in a Scrum team environment and participate in backlog review and Sprint planning sessions, following Agile methodology
• Design test cases and ensure the test cases trace back to the original business and technical requirement
• Analyzed trends and provided with early warning guidance on potential risks and opportunities to global operating performance
• Assist in the review and analysis of capital spending requests to ensure appropriate financial justification for project. Monitor and report progress of capital spending to original plan
• Prepared reports to communicate investment assets, expenses, sales and mortality. Prepared monthly and quarterly Gains by Source (GBS) reports for executive management
• Drafted quarterly variance analysis and presentation slides for executive board meetings.
• Provide financial analysis as needed to support management in decision making process
• Supplied necessary industry and market research to target new businesses
• Took part in the product management to roll out the planning, forecasting and marketing the product
• Assisted in design review meetings making sure all the requirements are covered in the development project scope
• MS Access 2007 database development with ODBC connection to an Oracle database for analysis of printer usage, global asset tracking and asset labeling system, data imports from Excel and text delimited files
• Developed MS Access VBA code to export data to excel, Ad Hoc Access reports, Management Report
• Used Excels financial functions and various other features like Pivot table, Pivot chart report for reconciling various reports
• Used MS Office Suite (including MS Project) components for project tracking, documentation, and presentation to senior management

Environment: Windows XP, SDLC, MS Visio, HP Quality Center, Clear Quest, MS Office, MS Share Point