SUMMARY:

Business Analyst with seven plus years of hands-on experience, with clear understanding of Business Process Flow and Business Analysis. A self starter, team player with excellent communication skills and ability to exhibit strong Analytical, problem solving and leadership skills. Extensive experience in all the stages of Software Development Life Cycle SDLC . Experience in Gathering, Analysis Management of Requirements, Business Reengineering, Business and Functional Analysis, Systems Analysis and Design, Quality Assurance, Gap analysis, Use case analysis and design, user support and documentation.

Professional Summary:

• Over seven years of experience as Business/Data analyst in Finance, Telecom, and Software industries.
• Thorough experience in iterative life cycle methodologies such as Agile as well as traditional waterfall.
• Extensive expertise in SDLC Software development life cycle , STLC Software testing life cycle , RUP Rational Unified Process and UML Unified Modeling Language .
• Adept with requirements engineering describing them in Hierarchical Task Analysis, Task Descriptions, Data Flow models Data Diagrams Class Diagrams .
• Efficient with scripting Business Requirement Documents BRDs , Functional Specifications Documents FSDs .
• Knowledge of Capital markets, securities valuation, derivatives Options , futures, Swaps.

• Proficient in creating Use Case diagrams, Class diagrams and Behavior Diagrams Sequence diagrams, Collaboration Diagrams and Activity diagrams , with expertise in Object Oriented Analysis Design OOAD methodology.
• Good knowledge of Business Process Modeling and Business Re-Engineering

• Created Dataflow analysis using use cases, dataflow diagrams, state diagrams, activity diagrams, class diagrams and collaboration diagrams.
• Extensive knowledge of financial statements, Derivatives, Capital Management, Portfolio Analysis, Amortization and Budgeting.
• Facilitating Joint Application Development JAD Sessions for requirements gathering and business area analysis to identify business needs and technological improvements.
• Understanding and Defining Business Process, Defining Project Scope, and Gathering and Understanding of User Requirements through extensive interactions with users, developers, and other stakeholders.
• Expertise in all Rational tools including Rational Rose, Rational Clear Quest, Rational RequisitePro, Rational Clear Case.
• Documented Business Requirement, Use Case Specification, Functional and Non-functional Specification, System Requirement Specification, UML diagrams Use Case, Class and Sequence , Traceability Matrix, Project Estimate, Change-Version Control, Training and User Manuals, Master Test Plan Review Integration, System and Acceptance .
• Extensive experience in Project Management Planning, Resource Allocation, Task Allocation and Monitoring of Tasks using MS Project.

• Expert in GAP Analysis and transformation planning from current AS-IS situations to target TO-BE situations.
• Expertise in tracking changing requirements using requirements management tools like Rational RequisitePro.
• Expertise in using version management tool like Clear-case and change management tool clear-quest
• Expert level skills in MS Office products MS Word, MS Excel, MS PowerPoint, MS Frontpage, MS Excel. Also proficient with MS Project.
• Strong inter-personal and Presentation Skills to communicate effectively with developers, project managers, subject-matter experts SME , stakeholders, system implementers, and application end users.

COMPUTER SKILLS:

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Technical Business Analyst

Responsibilities:

• Microsoft has implemented the MiSiS application from ground-up for its client, Los Angeles Unified School District LAUSD - nation's second largest school district with over half a million students and 30,000 teachers. My Integrated Student Information System MiSiS represents the next generation of the District's solution for entering, managing, analyzing, and reporting all data connected to students and staff.
• Apart from everything else this project involved decommissioning of more than 16 legacy systems that were serving the District's needs. I was involved in writing business/technical specifications for data interfaces ETL , reports, screens for web based application and data cleansing.

ETL Integration, Data Cleansing

1. Gathered, analyzed and documented business requirements and technical specifications for data Integration from disparate sources ETL Packages both outbound and inbound .

2. Data mapping between source and destination including transformations that need to be applied before loading to destination tables.

3. First level of QA on the development before handing off for system testing.

4. Determining scheduling frequency of SSIS Packages as SQL Server Jobs for scheduled executions.

5. Adept at writing T-SQL queries for data sampling.

Reporting

• 1. Gathered business requirements from the SME's and business owners and analyzed the same for preparing requirement documentation business technical for the report developers.
• 2. Continuous interaction with the developers, QA business users during end-to-end development cycle of the report.
• 3. Worked on requirements for Ad-hoc reports from application, SSRS reports including sub-reports drill-down, Reports Subscriptions using SSRS
• 4. Analyzed data and documented specifications for district's State Reporting purposes Financial and Cost Reporting . Advised on report layouts to the top management for different types of financial analysis reports for e.g. cost-benefit analysis, variance analysis, forecasting etc. .

Business Analysis

• Facilitated meetings with the product owners, scrum master, project coordinator, SME's and development and testing team.
• Coordinated project scheduling as prioritized by the Application Development Manager. Effectively communicates project status and needs to manager in concise and efficient manner.
• Worked closely with the UI team to model screens, which met user, defined requirements and also company standards
• Helped with tailoring of the Agile process, defining story collection process, collecting completeness criteria for the stories.
• Used SharePoint and TFS to store documents. Also used TFS Team Foundation Server to manage requirements. In -depth knowledge of creating tasks on TFS and running queries using the Editor query tool.
• Acted as the Scrum Master for many Sprints. As the Scrum Master held daily Scrum meeting with emphasis on overcoming barriers . Also monitored tasks of the team on TFS.
• Extensively used Microsoft Excel for data analytics Pivot Tables, Vlookup, Sorting, Filtering etc .
• Conducted meetings with user groups and internal stake holders to gather, understand, and document product/service requirements. Developed acceptance criteria to test user stories in sprint planning meeting.
• Worked with the software developers to insure defined business and systems requirements are met by the software delivered to the business. Clarified functional and reporting needs to software developers as questions and/or issues arise.
• Suggested improvements to the business process to improve efficiency. Conducted process analysis in the Attendance and Scheduling area. Adept at Business Process Modeling Notation BPMN .
• Participated in daily scrum meetings and worked with the Scrum master to better align the development team with the Agile methodologies.
• Developed prototype on Balsamiq, of new information processing application. Conducted walkthroughs with development team and stakeholders.
• Used MS Visio/UML to model Use Case Diagrams, Activity Diagrams, business flow diagrams, work flow diagrams sequence diagrams for the applications design.
• Directed and managed the Change Control Process for the project as a whole by facilitating group meetings, one-on-one interviews and corresponding with work stream owners to discuss the impact of change request on the project.
• Worked as an interface between the users and the different teams involved in the application development for the better understanding of the business and IT processes.
• Created UAT cases and assisted SMEs in UAT execution. Also created test scripts.
• Performed regular status meetings and provided tasks assignment to the developers throughout development and the testing lifecycle to ensure final product meets requirements and expected outcomes.
• Coordinated work plan between project manager and client with Green hopper. Continuously looked for opportunities to increase user satisfaction and deepen stakeholder/partner relationships.
• Extensively worked with quality analysts to make sure that the functionality meets requirement. Track and maintain stakeholder requested enhancements and changes using Quality Center

Environment:

UML, Microsoft Access, .Net, T-SQL, MS Office Suite, scrum Agile implementation, IBM Rational Software Modeler, HTML, SQL server 2012, Oracle 11i, SharePoint , TFS, Visio.

Confidential

Sr. Business Analyst

My primary responsibility involved supporting the local and global business teams with their IT related needs. Analyzing business functional and system requirements for BI reporting systems for KPI's and MIS Management reporting systems focused on Sales and Finance data users. Requirement analysis for business reports to be extracted from the operational and transactional systems. Identifying gaps in current software and suggesting solutions to cover them for a complete process flow. My job responsibility also included coordination among the IT development teams as well as liaising with the Business users towards the successful exchange of requirement and delivery of IT product and functionality.

Responsibilities

• Requirement discovery, analysis and documentation for green-field and enhancement projects
• Process Flow analysis, Gap analysis, Solution definition, Cost-benefit analysis
• Project coordination for Business Intelligence project implemented via 3rd party vendor Infosys India and China Teams .
• Used Agile with scrum for the MCS-BI reporting and KPI dashboard project for higher management
• New business BI reporting and Dashboard platform requirement definition, creation and delivery to the business community
• Documented key business processes for the CRM Business Unit using process design methodology and mapping techniques resulting in optimized processes and cost savings. Identified disconnects and gaps, suggested performance metrics, provided analysis that served as a foundation for designing process improvements and share knowledge across the organization on how the processes work.
• Worked with business teams and development team towards defining and developing front-end UI design and usability experience UX .
• Used TFS and SharePoint to manage requirements and store documents. Linked Tasks TFS on daily basis.
• Served as the Scrum Master for many Sprints. Lead the daily Scrum meetings and also monitored Tasks enter by the Team TFS on daily basis.
• Used Visio to create detailed mockups to capture the usability requirement as define the business teams SME Hands and Motion expert
• Adept at Microsoft Excel data analytics Pivot Tables, Vlookup etc. .
• Conducted One on One requirement discovery interview sessions
• Conducted JAD sessions with representative form Technical and business teams.
• Creating SRS Writing presentational and functional Use Cases documents from the BRD.
• Breaking Business requirement in to functional, non-functional and system requirements
• Created test scripts and coordinated SIT and UAT activities towards product acceptance and GO-Live
• Creating functional and presentational Use-Cases, Business Process modeling, Activity diagrams, State diagrams
• Project Planning and timeline adherence and managing risks against triple constraints of scope, time and budget

Environment:

UML, IBM Web sphere Modeler, T-SQL, MS Office Suite, scrum Agile implementation, IBM Rational Software Modeler, .Net, HTML, SQL server 2000 SSRS, SSIS , Oracle 11i, SharePoint, Microsoft Access

Confidential

Business Analyst

Confidential is the one of the biggest logistics companies in USA and internationally. The main objective of the project was applying analytical methods to business related problems that were faced by the human resources team in tracking the performance, rewards and recognition, exit policies and Abacus data bases The stream lining and creation of these databases helped the firm to track employee productivity as well as manage all their data bases with updated and accurate information. This was assignment was an Agile based development project.

Responsibilities:

• Analyzed requirement document by identifying ambiguous, incomplete and incorrect requirements. Helped in developing attribute matrix and functionality traceability matrix.
• Conducted GAP analysis to gather new functionality requirements.
• Implemented Object oriented Analysis and design OOAD methodology to analyze the requirements.
• Worked on Agile and SCRUM methodologies for fast completion of projects.
• Created new, user-interface designs, mock-ups, wireframes and prototypes.
• Analyzed business requirements into high level and low level Use Cases, Activity Diagrams / Sate chart Diagrams using MS Visio following UML.
• Participated in QA testing UAT, Black Box, and Regression and deployment ensuring minimal defects.
• Facilitated discussions, presentations and preparation of the burn out charts and estimated the schedule of the project timelines.
• Adept at MS Excel data analytics Pivot Table, VLookup etc. .
• Used Sharepoint to store documents.
• Created Use Case Diagrams, Data Flow Diagrams, Activity Diagrams, Sequence Diagrams and Entity Relationship ER Diagrams in MS-Visio.
• Conducted JAD sessions with management, SME, vendors, user and external agencies and other stakeholders for open and pending issues.
• Scheduled meetings with developers, system analyst and testers to collaborate resource allocation and project completion using MS Project.
• Extensive use of MS- Access and SQL to analyze data scenarios and data mapping.
• Analyzed requirements and worked closely with the project manger to prepare documents such as Business Requirements Document BRD and System Requirements Document SRD .
• Aggregated and Analyzed test metrics weekly from the Clear Quest defects database that reflected the current status of the test execution and the state of the defects, and communicated weekly status report to Project Manager.
• Managed and controlled change requests/defects using Clear Quest and made sure members in the team followed the change guidelines.
• Involved in UAT session to test the system with stakeholders. Also created test cases and test scripts..

Environment:

UML, MS Access, MS Office Suite, scrum Agile implementation, IBM Rational Software Modeler, JAVA, J2EE, JSP, HTML, SQL server 2000, Oracle 11i, SharePoint Test Director.

Confidential

Business Analyst

Confidential is one of the largest providers of Broadband internet, home telephone services and cable television services. The project work involved the design of an online system for the customers to place product orders and a tool to assist the Tech support team to provide solution over the phone to the customers who call the helpline

Responsibilities:

• Accumulated system specifications from various departments like accounting, Finance and Front office through survey questionnaires and interviews.
• Developed detailed use case specifications, functional specifications, Technical Specifications and supplemental specifications. Created use cases diagram, activity diagrams and sequence diagrams using Microsoft Visio.
• Extracted data from SQL Server database for data validation and data analysis using SQL queries ran on SQL Query Analyzer. Also used PL/SQL stored Procedures and Triggers. Helped the testing team in tracing the requirements from Requirement Traceability Matrix and involved in the User Acceptance Testing
• Created and managed project templates, use case project templates, requirement types and traceability relationships in RequisitePro.
• Planned and defined system requirements to Use Case, Use Case Scenario and Use Case Narrative using the UML Unified Modeling Language , and OOAD methodology.
• Conducted JAD sessions with management, Subject Matter Experts, vendors, user and other stakeholders for gathering technical requirements.
• Conducted Joint Application Development JAD sessions with stakeholders throughout SDLC to resolve open issues.
• Actively managed change and defects with Clear Quest, and made sure it was communicated to the entire team.
• Assisted Users with UAT testing. Created test case and test scripts.
• Conducted workflow, process diagram and GAP analyses to derive requirements for existing systems enhancements.
• Provided key input in working with users in defining project and system requirements.
• Created documentation for training and Help Desk teams.

Environment:

RUP, UML, Gap Analysis, MS Office, Rational rose, MS Access, Rational Requisite Pro, Rational Clear Quest, IBM Mainframe, SQL Server.

Confidential

Business Analyst

Performance Calculation System was developed specifically to support A.G. Edwards to provide advisory services to their clients on Asset Projections, Portfolio Rebalancing measures and Investment Holdings depending upon their risk profile, liquidity needs and future goals. The system's solutions advises the clients on wealth management strategies, provides clear and complete picture of the clients assets in relation to those held by other providers. This project also enhances the Fixed Income trading to include the US treasury bonds being purchased in auction that supports the research- yield calculations YTM, YTC etc .

.Responsibilities:

• Work in collaboration with key business stakeholders from Field and Corporate to manage development of business requirement.
• Served as the primary contact for business concerns. Conducted Training Sessions educating team members on use of requirement/defect management tools. Implemented project milestones, and monitored timelines
• Developed baseline test cases in support of product/solution offerings based on specified business requirements .
• Knowledge on documentation of the process flow of Agile and various Scrum artifacts.
• Full lifecycle management of business requirements Initiation, development, review, sign-off
• Worked on the requirements deliverables which includes functional requirements, detailed use cases, process flow documentation and test cases to support the functional requirements.
• Documented FRS Functional Requirement Specifications and assisted Systems analyst to come up with SRS System Requirement Specifications .
• Used MS Excel for financial forecasting and also for data analysis. Prepared Pivot Charts, Graphs for the upper management.
• Applied Unified Modeling Language UML methodologies to design Use Cases, Use Case Diagrams, Activity Diagrams and Sequence Diagram.
• Prepared documents with Traceability matrix, and Change Request form
• Worked with Business Reporting Tools such as Crystal Reports, Excel
• Worked as a liaison between the Business User Groups and the IT Groups to ensure complete understanding of the system requirements, business impacts in Business Requirement Document.
• Translated the business needs into functional requirements and communicated the same to the business users, to baseline the initial high-level requirements.
• Prepared reports from data warehouse.

Environment:

UML, MS Access, IBM Rational Software Modeler, JAVA, J2EE, JSP, HTML, Agile, Scrum , SQL server 2000, Oracle 11i, Microsoft Office suite, SharePoint Test Director, Win Runner.