SUMMARY:

• Over 10 years of Industry experience as a Business Analyst with good understanding of Data warehousing, ETL, Source to target data mapping, Business Requirements Gathering, Evaluating Data Sources, Translating Requirements into Specifications, Application Design. Got an exposure to Enterprise Data Hub (EDH), multi - node Hadoop cluster to get an understanding of Big Data.
• Good experience with project management and facilitation. Expert in writing BA deliverables like use cases, user stories, business requirement document (BRD), Functional specification document (FSD), Use Cases, User Stories, Test Cases.
• Proficient in Technical and Business Writing, Business Process Flow, Business Process Modeling, Business Analysis and Testing various methodologies. Served as a liaison between Business and Technical Stakeholders. Served as one point of contact for business users and design and development teams in onsite and offshore setting.
• Proficient and discrete in capturing business requirements, user needs, and system requirements (functional and non-functional system requirements), reviewing work flow and process mapping, conducting high level feasibility studies to improve business processes, developing business testing strategies and working with project members to execute the test plan, recommending preferred solutions, and implementing recommendations.
• In depth knowledge Rational Unified Process (RUP) methodology, Use Cases, Software Development Life Cycle (SDLC) processes, Object Oriented Analysis and Design (OOA/D). Extensive experience in implementing Software Development Life Cycle (SDLC) principles and methodologies such as Agile, Rational Unified Process (RUP), and Waterfall Method in development.
• Extensive experience and knowledge of UML, BPMN, CMMi, and various types of modeling, Sequence Diagrams, Flow Diagrams and Activity Diagrams using tools such as Microsoft Visio and Rational Rose
• Experience in facilitating Joint Requirement Planning (JRP) sessions with Business User Groups, conducting Joint Application Development (JAD) sessions with IT Groups and Conflict Management with Project team members.
• Responsible to Track, Document, Capture, Manage and Communicate the Requirements using Requirement Traceability Matrix (RTM) which helped in controlling numerous artifacts produced by the teams across the deliverables for a project

TECHNICAL SKILLS:

Programming Languages: C,C++,C#,VC++,VB,VB.NET,C#.NET, ASP.NET, Java, SQL, PLSQL

Operating Systems: UNIX, Windows 95/98/NT/2000/XP, Linux.

Databases: MS-Access, MySQL, SQL Server, Oracle, Teradata, DB2, Sybase

Internet: HTML, XML, VBScript, ASP, JavaScript, JSP, J2EE.

Automation Tools: MS Visio, Rational Rose, Rational ClearCase, Rational RequisiteProDocumentum

Bug Tracking Tools: Mercury TestDirector, Rational ClearQuest

Utility Tools: MS Office Suite, MS Project, TOADData warehousing Tools: Informatica, Hyperion, Cognos, Erwin

Testing Tools: Quick TestPro (QTP), TestDirector, WinRunner, LoadRunner

PROFESSIONAL EXPERIENCE:

Confidential, Frederick, MD

Sr. Business Analyst

Responsibilities:

• Understanding of the business process areas and working with the business and technical teams to define business needs. The need was to enhance existing web App to accommodate new functionalities pertaining to the new initiative, On Demand. Build mobile apps both on Android and iOS.
• Conducted Business Requirements, Functional and Technical meetings with Business groups.
• Conducted Release planning meeting to develop feature list, prioritize stories based on business value, estimated story points and develop a release plan.
• Worked on both backend (databases) and Frontend (UI/UX), GUI, dashboards.
• Created project related documentation (project definition, test plans, requirements definition, Analytics etc.).
• Acted as a liaison between business and technical teams as well as testing and development teams. Triaged issues/defects raised by users and testers to define priorities to be assigned to development teams.
• Assisted the product owner from Business team in tracking defects and acted as a functional subject matter expert on the application’s functionality.
• Helped business in preparing material for chauffeurs, dispatchers, pricers and accounts and sales teams.
• Prepared presentations for On Demand workflow and gave demonstrations on OD functionality to executives and business users.
• Followed up with offshore and onsite teams to check status on defects and provide a report to the management during daily and weekly status update meetings.
• Created testing strategies in coordination with Functional testers and helped them conduct functional, system and regression testing.
• Laid out a plan for User acceptance testing and created UAT test scenarios to be executed by business users during Alpha and Beta testing.

Environment: JIRA, MS Visio, SQL Assistant, HTML, J2EE, Objective-C, USFT (United States Fleet Tracking), 2Lemetry (messaging, SMS and push notification service).

Confidential, Atlanta, GA

Sr. Business Analyst

Responsibilities:

• Understanding of the business process areas and working with the business and technical teams to define business needs. Create or providing input to project plans.
• Manage key projects and small projects in Business Intelligence service queue triage and project related documentation (project definition, test plans, requirements definition, etc.).
• Worked with distributed data sources and schemas on end to end creation of data marts and enhancements using Agile methodologies.
• Work with the Data warehouse Architect team for better ETL performance and reports and increase report functionalities
• Worked on Cognos 10 and Hyperion in collaboration with Reports Developer and BI Architects, involved in Metadata modelling and reports generation.
• Interacted with users for verifying User Requirements, managing Change Control Process, updating existing Documentation
• Assisted users in conducting UAT, getting accesses to databases and tables based on their roles and restrictions.
• Created relationships in Requirement Traceability Matrix linking Business Requirements to Functional requirements and Functional Requirements to Systems Requirements.
• Meeting with project teams regularly to review project deliverables and deadlines. Providing single point of contact for assigned projects.

Environment: Teradata, Oracle, DB2, SAP, RequisitePro, Rational Rose, MS Visio, SQL Assistant, Cognos, Hyperion.

Confidential, New York, NY

Business Analyst

Responsibilities:

• Interacted with business users to gain knowledge of the existing system and understand their needs
• Documented the As-Is processes and created MS Visio flows to depict and understand the current business processes
• Conducted Release planning meeting to develop feature list, prioritize stories based on business value, estimated story points and develop a release plan. Worked on both backend (databases) and Frontend (UI/UX), GUI, dashboards.
• Conducted iteration kick-off meetings with Business Users, Project Manager, Development and QA teams to document Product Backlog Items (PBI), high level business process models and high level architectural models
• Conducted SPRINT sessions with 2-week iterations using Agile, Scrum. Participated in Daily Stand-ups to update Story boards and develop User Stories.
• Reviewed user stories with stakeholders to get approval and gain agreement on direction of the technical solution
• Helped developer in unit testing, system integration testing; performed regression testing and User Acceptance Testing (UAT)
• Performed GUI testing to make sure that the final product were in line with the business needs and their requirements
• Effectively worked with technical teams to research and advise on alternative technical solutions to address critical business issues and opportunities
• Communicated with stakeholders to resolve issues relating to budget and deadlines

Environment: Visual Studio, TFS, MTM, MS Visio, SQL, Java, C#, Quality Centre.

Confidential, Long Island City, NY

Sr. Business Analyst

Responsibilities:

• Interviewed Business Users to gather Requirements and analyzed the feasibility of their needs by coordinating with the project manager and technical lead.
• Responsibilities included oversight of design, configuration, development, implementation, and test of all enhancements and updates to the legacy (IMS) mainframe platform (Sceptre) supporting Flight operations.
• Work with the Data warehouse Architect team for better ETL performance and reports and increase report functionalities. Worked on creation of Cognos 8 packages.
• Conducted extensive requirement analysis. Worked with Informatica developer to extract and transform data from various DB2 database to the data warehouse.
• Prepared Business Requirement Documents (BRD’s) after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype and overall system.
• Interacted with users for verifying User Requirements, managing Change Control Process, updating existing Documentation
• Created relationships in Requirement Traceability Matrix linking Business Requirements to Functional requirements and Functional Requirements to Systems Requirements.
• Performed Testing Life Cycle during the various phases of the application. Involved in converting manual test cases into automated scripts using TSL on Mercury Win runner, QTP.

Environment: Microsoft Office Suite, Casewise modeller, Unix, Documentum, Windows NT/XP, Oracle, SQL, SQL Server, Cognos, Sybase, J2EE, .NET, ASP.NET, Business Objects, Test Director, Load Runner, Rational Rose, Clear quest.

Confidential, Chicago, IL

Business Analyst

Responsibilities:

• Reviewed and analysed the business environment and identified process improvements.
• Interacted with Business Users to conduct thorough Requirements Analysis.
• Involved in interactions with the Subject Matter Expert, Project Manager, Developers, and the End-Users
• Development and design of Risk Data mart involving Informatica 8 and Business Objects 6.5/ Cognos 8
• Responsible for dimensional modeling of the data warehouse to design the business process.
• Coordinated activities with project manager and various other teams. Interacted with other Business Analysts for designing and implementation of Use Cases and Test Plans.
• Working on enhancements in Business Objects, Cognos and Informatica. Analysed specifications and identified source data needs to be moved to data warehouse.
• Responsible for collaborating with Team Leads to coordinate project schedules, budgets, request management, and work authorization

Environment: Microsoft Office Suite, MS Visio, Java, C, Cognos, Windows NT, JavaScript, UNIX, HTML, Oracle, SQL, Mercury Test Director, Mercury Load Runner

Confidential, Woodbury, MN

Sr. Business Analyst/ Product owner/ Scrum Master

Responsibilities:

• Visited and evaluated client’s environment and business processes to understand and take an overview of the business
• Conducted interviews and Joint Application Development (JAD) sessions to develop & agree upon a system with emphasis on the business requirements. Prepared functional document and software specification document.
• Also worked as an Enterprise Data Hub (EDH) Business Analyst and partnered with the EDH technical team and business partner teams in driving the requirements, design and development activities for several systems to be retired/archived within multi-node Hadoop cluster (aka EDH).
• Used various SDLC methods including Waterfall and Agile. Partnered with Database team in creating Source To Target Documents, learned writing XML and data mapping
• Coordinated with the development team, support teams to get the job done and changes implemented.
• Worked with technical team for integration testing, worked with business user for developing and executing UAT
• Prepared and provided detailed weekly progress report to Managers and the business stakeholders

Confidential, Bellevue, WA

Business Analyst/Data Analyst

Responsibilities:

• Responsible for gathering user requirements and specifications for designing a mortgage based loan system using and documenting the same
• Involved in dimensional modelling of the data warehouse to design the business process.
• Created context and workflow models, information and business rule models, Use Case and Object Models during the analysis using rational tools
• Lead multiple project teams of technical professionals through all phases of the SDLC using technologies including Oracle, Erwin, Data Stage, Data Warehousing, Web sphere and Cognos.
• Planned and defined system requirements to Wire Frame with Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modelling Language) methodologies
• Conducted Business Requirements, Functional and Technical meetings with Business groups.
• Served as a liaison between mortgage specialists and the project team.
• Extensively involved in maintaining requirements traceability and communicating any changes to these requirements to different business groups and programmers.
• Extracted the Business Requirements during various sessions with business leads and tagged all requirements in Requisite Pro, tracing them all the way to the stakeholder requirements

Environment: Rational Rose, Rational RequisitePro, RUP, Cognos, Win Runner, Load Runner, MSOffice2000, NET, ASP.NET.

Confidential, Golden, CO

Business Analyst

Responsibilities:

• Acted as a liaison between underwriters who have a business problem and developers to create automated solutions.
• Performed the business requirements gathering by questioners, Interview business area experts, surveys and JAD sessions
• Developed procedures to populate the customer data warehouse with transaction data, cycle and monthly summary data, and 36 months of historical data.
• Gathered, documented, and communicated business requirements into systems design documentation using Business-Modelling concepts. Conducting Review Requirements meetings to identify missing or incomplete requirements and to identify potential test cases.
• Conducted extensive requirement analysis using Rational requisite pro
• Contributed to the System Requirement Specification (SRS) Document and derived software models using UML for the System Design Specification (SDS) Document
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, and OOD

Environment: Java, J2EE technology, NET, Windows 2000 Advanced Server, UNIX / Oracle Platform, MS Visio, RUP, Rational Rose 2002, Rational Clear Quest, Cognos, Rational Clear Case, Rational requisite pro