SUMMARY

• Over 8 years of extensive experience as a Business Analyst in gathering and analyzing business and functional requirements, data analysis, data mapping, business process re - engineering, object-oriented designing, unified modeling language (UML), SDLC methodology (RUP, Agile, SCRUM, XP) and project management in cable communication, finance and investment banking domains
• Extensive knowledge in conducting joint application development (JAD) and Rapid application development (RAD) sessions.
• Extensive knowledge in Data Modeling, Data Analysis, GAP Analysis, Requirement Analysis, Business Modeling, Data Migration, Data profiling, and Dimensional Modeling.
• Proficient in the use of Excel functions, VLookup, and Pivot tables for data extraction, analysis, and presentation.
• Well-rounded knowledge of Financial Planning, Forecasting, Budgeting and utilization of variance analysis to manage project completion timely and within budget.
• Capable of creating and managing MS access and SQL server database for data entry, storage and generation of reports to facilitate management decision making processes.
• Extensive knowledge in UAT (User Acceptance Testing), Functionality Testing, Unit testing, System Testing, Integration Testing and Regression Testing.
• Excellent capabilities in implementing various negotiating strategies to gather resources for project development.
• Extensive understanding of Data Warehousing, Extraction, Transformation and Loading (ETL) and Business Intelligence (BI) tools.
• A Self-motivated individual with the ability to adapt to new environments and situations quickly with the ability to form and maintain positive and productive working relationships.
• Possess excellent verbal and written communication skills as well as interpersonal and conflict resolution skills with strong analytical skills.

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Business/Systems Analyst

Responsibilities:

• Working with Confidential and AMDOCs SMEs in implementing the conversion of the current DDP billing system to AMDOCS CES 7.5 software especially focusing on key areas like: Rating Logic Configuration, Enterprise Product Cataloging, Rating, and Invoicing.
• Regularly using DDP and CES 7.5 billing system software for monitoring the effects of billing system conversion on key customer metrics such as: correct cable service coding, taxation, invoicing, payments, and rating.
• Carrying out data analysis using tools like VLookup, SQL Server, Pivot Table, MS Access to extract and report data related to equipment and accounts converted to CES 7.5.
• Eliciting business and functional requirements from Confidential SMEs and developing requirement documents for the offshore programming team.
• Developing test plans to monitor the quality of system conversion by stress testing the system with various functional scenarios.
• Regularly leading system conversion meetings to ensure smooth transfer of knowledge and working concerns among business and development teams.
• Facilitating smooth communication, information exchange, and documentation of all conversion related activities by developing PowerPoint presentations, meeting minutes/agendas, and other related reports.
• Leading a team of 4 billings analysts responsible for Confidential subscriber bill auditing by working hands on with the DDP billing system software; and training the team in its operations.
• Extensively traveling to Confidential Central Region Division offices for monitoring data transfer from the DDP system to CES 7.5; and carrying out quality assurance by reviewing key metrics of the new bills produced with the regional teams.

Environment: MS Visio, MS Office Suite, MS Project, UML, AMDOCS-DDP & DDPF, Remedy, SQL Server 2008, MS Project.

Confidential, Phoenix, AZ

Sr. Business Analyst

Responsibilities:

• Utilized Rational Unified Process (RUP) and Agile methodologies to configure and develop process, standards, and procedures.
• Followed a structured approach to organize requirements into logical groupings of essential business processes, business rules, information needs and insured that critical requirements are not missed.
• Analyzed business requirements and segregated them into high level and low level Use Cases, Activity diagrams / State Chart Diagrams and Sequence Diagrams using Rational Rose/ MS Visio according to UML methodology thus defining the Data Process Models.
• Developed standard documentation package (Requirements, Specification, Design, Operations, and Quality Testing Plans).
• Wrote BRD, FRD, use cases, test scenarios, test cases for testing the functional and non-functional aspects of both ETL jobs and Reporting jobs.
• Performed requirement gathering & analysis by actively soliciting, analyzing and negotiating customer requirements and prepared the requirements specification document for the application.
• Assisted in developing test plan, test cases and test scenarios to be used in testing based on business requirements, technical specifications, and product knowledge.
• Identified use cases from the functionalrequirements and wrote use case specifications and created business process workflow diagrams (Activity diagrams, Sequence diagrams, Collaboration diagrams) in VISIO
• Conducted functional and user requirement specification reviews and walkthroughs with the designers, developers and stakeholders.
• Involved in performing User acceptance testing (UAT).
• Worked with Quality Assurance team to review the test scripts against the functional specification and helped them in creating scenarios that would test the system end to end.
• Worked closely with the data model team to review the data model and validate them.

Environment: Rational Requisite Pro, Rational Rose, Clear Quest, ClearCase, Rational Robot, Java, MS-Project, MS-Visio, MS-Office, UML

Confidential, Plano, TX

Sr. Business Analyst

Responsibilities:

• Consulted various project stakeholders including Subject matter experts (SME's) and product owner to elicit business and functional requirements.
• Worked with project managers, tech leads, external teams and vendors to set the estimates for all the functional areas getting impacted.
• Conducted JAD sessions to gather business requirements from stakeholders, business and external users.
• Followed Software Development Life Cycle using Agile Methodology for the project.
• Prepareduser stories for all the impacted functional areas and walkthroughs with the developers and stakeholders.
• Prepared high level scope document including the impact analysis.
• Participated in weekly status meetings with project manager, delivery manager and tech, leads to discuss and review the status of the projects.
• Preparedsource to target mapping document and reviewing it internally.
• Conducted bi-weekly meetings with external teams to discuss impacts, finalize time lines, and share development and test results.
• As needed, acted as a project manager to conduct standup meeting, retrospective meeting and updated that in sprint backlog.
• Participated in the daily off shore team meetings to have transition presentation to explain every functional area.
• Worked closely with QA lead to solve testing issues while conducting system and regression testing.
• Prepared UAT test scripts and plans for efficient user acceptance testing.
• Worked closely with QA lead and data stewards to conduct UAT testing.

Environment: MS Visio, MS Office Suite, MS Project, UML, ETL(abnitio), HP (Quality Center 9.2, QuickTest Professional 8.2/9.2), SQL Server 2008/2000, Oracle 9i/10g, Version1.

Confidential, Wilmington, DE

Business Analyst/ Accounting - Finance

Responsibilities:

• Performed project management functions including project planning, budgeting, business requirements, technical design, system specifications, and project deliverables
• Processed feedback from project employees and determined project completion date
• Documented and validated acceptance, integration, performance, and regression test plans
• Provided technical support for technical project staff and customers
• Continuously performed problem solving, problem analysis, and creativity functions using knowledge and logic intensively
• Acted as the communication bridge between technical and non-technical project staff
• Extensively worked with access and SQL databases while gathering the business requirements for the inbound data feeds and outbound data feeds for the finance department
• Worked with Data Warehouse for data mining, making consolidated reports and finding relationships & correlations
• Continuously documented business processes, operational processes and fulfilled test case and testing plans throughout the project
• Developed featured lists for the analysis of the players in the market, financial data and divided them into release plans
• Used product burn down charts to monitor the progress of the project
• Concluded product backlogs and divided them into different sprints
• Monitored and reported event activity and/or trends that occurred as a result of data load to the client counterpart
• Implemented reference data management and provided the required info for the main System
• Developed, managed and documented client data feed specifications, set the production schedule, and work with others to ensure the feeds were brought into production. Also had to monitor the process to ensure successful stabilization
• Processed and/or reviewed daily/weekly inbound data load files to include research and data resolution of load file errors
• Collected data on liquidity risks, analyzed regulatory reports and applied risk measurements
• Carried out researched and resolved assigned specific issues and general inquiries reported through issue tracking
• Analyzed trending activity related error reports including numbers, whether or not received, error type, percentage of total records, etc.
• Developed ad hoc reports requested by the client and/or internal staff
• Carried out testing of all phases of open enrollment/special projects including system functionality, forms, WEB and online screen functionality
• Created various reports and report formats from the General Ledger (GL), cash flow and P/L statements
• Used Excel Graphics, Pivot table reports and dynamic charts that had been created to develop automatic reports
• Used normalization to retrieve the data into different forms using ERWIN and generated tables in the access database.
• Extensively used Excel/Access and VBA for the ad hoc analysis of the data

Environment: Microsoft Visio 2007/2010, Microsoft Access 2007/2010, XML File, SQL Server, Rational Requisite Pro, Windows ME, UML, MS Office 2003/2007/2010 , and Rational Clear Quest 2002.

Confidential, Plymouth, MI

Business Analyst

Responsibilities:

• Established a RUP (Rational Unified Process) centric business analysis methodology.
• Collaborated in building a business analysis process model using Rational Rose, RequisitePro, and Visio.
• Responsible for business system analysis of customizing the BPS Risk Management product with involvement through the whole SDLC
• Provided key initiatives in working with users in defining project and system requirements.
• Provided inputs in the strategic development of detailed project plans, work assignments, target dates etc.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML
• Performed requirement analysis, went through all the use cases and issue logs.
• Developed strategic partnerships with the business unit to prepare a solid knowledge base of the business line, including the business plan, products, and process’ and revenue streams aimed towards problem solving.
• Developed Logical and Physical data models that capture current state/future state data elements and data flows using Erwin.
• Involved in data migration design so that the data can be exchanged from other systems in standard ACORD XMLife standards.
• Worked on data modeling and produced data mapping and data definition documentation
• Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project cycle. Worked with ODS and OLAP system. Worked with Data Extraction, Transformation and Loading. Metadata architecture was also provided, for the purposes of query enhancement and clarification of data relationships. Also built the foundation for process implementation in MS-SQL.
• Partnered with the technical areas in the research and resolution of system and process problems especially related to Power Builder platform.
• Played a key role in the planning, testing, and implementation of system enhancements and conversions
• Performed analysis on enterprise data/report integration & provided functional specification to development team to build Enterprise Reporting Systems.
• Guided development team in the Oracle 9i based database. Assisted in presenting reports and analysis to help guide the management.
• Organized cross training of team members and users to become more responsive.
• Assisted in development of training materials for new technology and process improvements

Environment: Windows, MS Office (MS Word, MS Excel, MS PowerPoint, MS Visio), .NET, Oracle, Crystal reports, IBM Mainframes, RUP, UML, SQL, SWOT analysis, GAP Analysis, Win Runner