SUMMARY

• Business/Systems Analysis Consultant for around 8+ years, working with the technical staff to implement management and staff's business requirements into the software application in retail, finance and e - commerce environments.
• Experienced in data mapping, data modeling, data analysis, and Business Intelligence solutions.
• Strong visual modeling and business process modeling skills with tools like MS Visio for developing Use Cases, Sequence Diagrams, Collaboration Diagrams, Activity Diagrams, Class Diagrams and UML Diagrams.
• Extensive experience with Data Warehousing, Extraction, Transformation.
• Enterprising and self-motivated personality with excellent communication, presentation and interpersonal skills.
• Hands-on experience with Project coordinating activities like Working closely with Business/Stakeholders for documenting Scope Document, Project Charter.
• Using SQL developed queries and extracting raw data.
• Designing, Testing, Documentation, and Presentation to clients and preparing customer specifications as part of software technical requirements and Customer support.
• Experience in process improvement process documentation SIPOC.

TECHNICAL SKILLS

Languages: UML, HTML, SQL

Methodologies: UML, SDLC, JAD, RAD, RUD, Agile (SCRUM), Six Sigma, Waterfall

Databases: Oracle, MS Access

Design: UML, Rational Rose, MS Visio.

Test Tool: HP Quality Center

OS: Windows 7/Vista/XP/2000/NT/98/95, DOS

Application: MS Office (Word, Excel, PowerPoint, Outlook) MS Project, VisioRequirement ManagementRational Suite (requisite Pro)

PROFESSIONAL EXPERIENCE

Confidential, San Antonio, TX

Development Product Owner / Scrum Master / Business Analyst

Responsibilities:

• Acts as a Liaison/communication channel between FASG (financial analysis and solution group), IT team, D&A (data & analytics) business team and IBM IT team for Cash Flow and FASG DW Modernization project by using SAFe (Scaled Agile Framework).
• Work with the business and technology partners to define, prioritize, and achieve short and long term objectives for data acquisitions
• Create Release plan, Iteration plan, and Stories including the DOD (Definition of Done)
• Manage workload of development teams proactively identifying and resolving issues that would present a risk to on-time delivery of the program/project.
• Performs Scrum Master’s duties in order to arrange and facilitates different Agile ceremonies (daily standups, sprint planning sessions, sprint review sessions, backlog grooming session, DPO level demo sessions and sponsor demo sessions)
• Work with other Scrum Masters to define, reinforce and maintain a consistent practice across the organization
• As Scrum Master empower the team to self-organize around achieving their commitments.
• As a DPO participates in participates in (SAFe) Scaled Agile ceremonies for both Cash Flow and DW Modernization projects.
• As Scrum Master Identify and remove any impediments/distractions that interfere with the team’s ability to deliver against their commitments.
• Play a major role in performance management. Develop, train, and coach team members. Promote effective teamwork.
• After every meeting creates minutes of meetings for all executives, project sponsors, stakeholders, SMEs and IT team (both Confidential /FASG and IBM)
• As a DPO / Scrum master guides team about the best practices of agile and project management.
• Support Confidential /FASG IT team and IBM team in order to implement Information Governance (into IGC tool), ETL (into IBM DataStage), and Data Modeling (into IBM IDA) for the enhancement of existing Data Architecture.
• As a Scrum Master make sure that the team reside within the boundaries of Scrum.
• As a DPO helps IBM team to create Use Cases, Epics, Features, User Stories and Tasks.
• Coach FASG IT team and IBM team about the best practices of agile and project management in order to deliver high quality deliverable according to the end user requirements.
• Crates and maintain the product backlog into IBM RTC (rational team concert)
• Develop the project Roadmap and Heat Map for all executives, project sponsors, stakeholders, SMEs and IT teams.
• Prioritizes and sequences the backlog according to business values or ROI for both projects.
• Convey the Vision and Goals at the beginning of every sprint release.
• Solves and escalates the impediments at appropriate level.
• Developed the scrum model in order to capture, maintain and improve the workflow of each sprint.
• Modify the existing FASG Heat Map in order to improve the scalability and accountability.
• Received appreciation remarks from my Director from Information Governance.
• Developed the detailed SIPOC and ASIS documents for IMCO Cash Flow Project.

Confidential, Austin, TX

Business Analyst

Responsibilities:

• Served as a liaison between various business units and information technology groups.
• Created Data Stage jobs to extract, transform and load data into data warehouses from various sources like relational databases, application systems, temp tables, flat files etc.
• Responsible for creating business work flows, explain processes by BPMN and creating management reports based on the business rules and the business case analysis
• Implemented data access, storage and validation routines on the database server using Structured Query Language (SQL).
• Support for an inventory management value assessment to improve financial performance, Compliance and the customer experience by reducing working capitals and supply chain costs, and improving on shelf availability.
• Collected logistic data, defined core problems of POS, recommended resolutions, and presented key information and thorough review of report data.
• Developed detailed BRD and FRD using various modeling tools and developed databases based on the system model following the techniques in SDLC (software development life cycle) in .Net Framework environment.
• XML order header and order detail data transfer; inventory/supply chain management modules and BPEL
• Used ERP business user information to create prototype business models and related business objects for Human Resources, Sales, Supply Chain and Finance which strongly supported ERP configuration using Business Process Modeling tool with UML.
• Performed Business Process Mapping and performed AS IS and TO BE analysis
• Worked together with other team members in interviewing various business groups and identifying and prioritizing business and functional requirements.
• Converted various SQL statements into stored procedures thereby reducing the Number of database accesses.
• Worked together with SMEs, architecture group and technical team leads to detail the interface, customized based on different user roles and functions.
• Mapped the current and proposed process and conducted thorough GAP analysis
• Generated Use Cases, Use Case Scenarios, Activity Diagrams and Data Flow Diagrams.
• Co-authored Functional Requirements and Specification Document.
• Worked with information architects and creative groups in detailing the wireframes and depicting GUI design.
• Assisted the database development team in data modeling, data structure and data table layouts required for consolidation of incongruent databases,
• Involved in writing test plan, test cases and test scripts for end-to-end testing.
• Reviewed test results and reported bugs/issues using Mercury Test Director.
• Assisted in UAT and end user training.
• Conducted process modeling technique under agile environment.
• Involved in various other enhancement initiatives to include new functionalities and redesign.

Environment: Windows, Oracle, SQL, MS Visio, MS Access, MS Project, MS SharePoint, UML, JAD, Requisite pro, Rational Clear Quest, .Net Framework.

Confidential, San Francisco, CA

Business Systems Analyst

Responsibilities:

• Established a Business Analysis methodology around the Rational Unified Process in .Net Framework.
• Interacted with Cash Management Division, Portfolio Management, Wealth Management and Compliance Office to review the AML (Anti Money Laundering) requirements and provide Positive Pay service to reduce check fraud.
• Read all the functional & non-functional documents to create Test Scripts & all the possible Test Scenarios to remove & fix the bugs if any.
• Applied Unified Modelling Language (UML) methodologies to design Communication Diagram, Use Case Diagrams, Activity Diagrams, Sequence Diagram, BPMN and ER diagrams.
• Extensively interacted with both user group and development team.
• Developed and Documented timelines for Project Delivery, and managed Projects and Resources to successful completion under micro strategy platform.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.
• Understand XML and BPMEL service orientated architecture.
• Managed and tracked change control process of requirements and design changes.
• Documented the changes, issues and their impact on the system design and delivery.
• Responsibility included modifications to a customer’s mainframe system to support new product features or regulatory requirements and, in some cases, involved a system upgrade
• Developing Test Plan with a Test Strategy for the System testing. Instrumental in creating design and frame work for automation.
• Extensively involved in the automation of Regression Test Cases by scripting.
• All the test scenarios, which have been satisfied with the functionality, are moved to automation testing using Quick Test Professional.
• Extensively used Test Director to store and execute the QTP Scripts and for defect tracking.
• Using Dimensional Modeling Techniques to create Dimensions, Cubes and Fact tables.
• Interacted with developers, Business & Management Teams and End Users.
• Performed numerous Ad-hoc requests, financial reports involving SQL scripts, UNIX.
• Verify & Validate the statements & transaction before & after the cycle is processed
• Verify & Validate the data-mapping by verifying various accounts details in various banking mainframe regions using test scripts in Quality Centre & filling defect logs if any.
• Revalidate the fixed defects & update the Quality Centre with the results.
• Conducted JAD sessions for communicating with Stakeholders and Project directors.
• Conducted process modeling technique under agile environment.
• Developed business requirement specification documents as well as high-level project plan.
• Assist the PM in setting realistic project expectations and in evaluating the impact of changes on the organization and plans accordingly and conducted project related presentations.
• Conducted benchmarking activities to identify best practices.

Environment: SQL,Rose, MS Word, MS Excel, MS Visio, LoadRunner, WinRunner

Confidential, Vienna, VA

Business Analyst

Responsibilities:

• Responsible for the gathering requirements.
• Responsible for keeping track of the daily requested data transfer jobs.
• Directly assist my project managers by working with the development teams to keep the current project moving.
• Used Agile Scrum as an SDLC methodology and BPMN
• Created complex spreadsheets in MS Excel using advanced formulas (V-lookups, IF statements; pivot tables; macros).
• Written User Stories, maintained Release Planning, Validated user Stories and maintained Burn-down charts.
• Completed end to end requirements analysis for fully customized application which stored data and automated calculations of telephone voice line data to determine capacity and utilization.
• Facilitated design sessions and maintained Agile Product Backlog and connected User Stories to Epics in the tool.
• Assisted the Product Owner/PM in developing comprehensive schedules, reflecting appropriate time-phased completion of projects and application of required resources utilizing MS Project.
• Managed and created all IT Team templates i.e. Project Plan, Business Case, Scope Definition document for PMO department.
• Prioritized and coordinated deliverables and inter-dependencies among the various IT Teams.
• Assisted the Project Manager in assembling project teams in a matrix environment, assign individual responsibilities, identify appropriate resources needed and develop high level and detailed schedules to ensure timely completion of projects.
• Maintained project SharePoint site by setting up project document repositories, modification and upload of documents, enabling user access and advising users on SharePoint access.
• Identified and defined business problems or opportunities, and evaluated potential solutions for consideration.
• Created all project artifacts (Business Case, Business/Functional/Non-Functional Requirements, User Stories/Use Cases, etc.).
• Ensure effective communication with the SharePoint team, business team and any other project teams associated with the initiative(s).

Confidential, Bridgewater, NJ

Business Analyst

Responsibilities:

• Was responsible for creating and reviewing business requirements, functional specifications, project schedules, documentation and test plans.
• Worked with production staff to identify and map detailed current processes, identify gaps and failure points, perform root cause analysis and develop functional requirements that supported overall strategy, goals and objectives.
• Assisted the Project Manager in setting realistic project expectations, portfolio management, in evaluating the impact of changes on the organization and plans accordingly, and conducted project related presentations.
• Acted as a liaison between the technical staff and the users (staff and management), also responsible for communications between Project Team and other related department.
• Lead client facilitation meetings to gather Requirements (Inception phase), there after assisted tech leads in Analysis & Design approach using UML & Rational Unified Process
• Conducting user interviews at both in-house and client locations, gathering and analyzing requirements using RequisitePro - RUP
• Designed and developed project document templates based on SDLC methodology
• Analyze and design Use Case diagrams, Class diagrams, sequence diagrams, and Visio to depict process flows and PowerPoint presentations.
• Created BPMN under .Net Framework
• Developed requirement reports for day-to-day trading management needs for opening new accounts, using RequisitePro.
• Used SQL queries to access the data needed for analysis. Created reports using MS Access and Excel for requirement and issue tracking.
• Laid out business structure to manage change control process using Rational ClearQuest.
• Assisted QA manager to develop test plan and test case
• Provided business support to conduct User Acceptance Test (UAT)
• Conducted benchmarking activities to identify the best practices.
• Participated in the logical and physical design sessions and developed design documents.
• Created test cases and scenarios for Unit, Regression, Integration as well as Back-end and Black box testing. Defects found in the application are entered in Quality Center.

Environment: MS Windows XP, MS Office 2003, Rational Suite (Requisite Pro, Clear Quest), SQL Server 2005/2000, HP (Quality Center 9.2, Quick Test Professional 8.2/9.2).

Confidential, Princeton NJ

Business analyst

Responsibilities:

• Responsible for creating, analyzing and reviewing business requirements, System specifications and project schedule documentation.
• Gathered user and business requirements through interviews, surveys, prototyping and worked with team to identify gaps and defects.
• Conducted User Stories Workshops.
• Analyzed, prioritized and managed the requirements using Rational Requisite Pro.
• Conducted JAD sessions with management, SME, users and other stakeholders for open and pending issues and participated in the identification, understanding and documentation of business requirements.
• Acted as a liaison between technical team, Compliance and business clients to accomplish application enhancement and production for mortgage and insurance landing.
• Participated and contributed in daily Scrums, Sprint meeting and Sprint review meetings
• Assisted the Project Manager in setting realistic expectations, in evaluating the impact of changes on the organization and plans accordingly and conducted project related presentations.
• Assisted in the development of test plans and test case.
• Used micro strategy platform.
• Conducted UAT (User Acceptance Testing) for validation of the application and used Unifi system.

Environment: Agile/ Scrum, Windows, MS Project, MS Visio, MS Office, Requisite Pro, Quality Center

Confidential, Los Angeles CA

Business Analyst

Responsibilities:

• Gathered requirements by interviewing the various business units involved.
• Created and developed new functionality in the application to meet mortgage and automobile loan needs, Compliance and Insurance landing.
• Designed and developed use cases, activity diagrams, sequence diagrams, using UML. Gathered and documented business requirements and utilized Unifi system.
• Analyzed existing systems logic difficulties and revised them as the needed.
• Established a business analysis methodology around the RUP (Rational Unified Process).
• Assisted in building a business analysis process model using Visio.
• Collaborated with the Project Manager to organize training material and write user manuals.

Environment: HTML, SQL, XML, MS Windows 2000, MS Office 2003, MS Visio.

Confidential

Jr. Business Analyst

Responsibilities:

• Responsible for creating, analyzing and reviewing business requirements, System specifications and project schedule documentation for SAP ERP ECC 6.0 (AS-IS and TO BE)
• Successfully transferred all process knowledge & reporting requirements to the ABAPERS for development.
• Conduct software compatibility tests with programs, hardware, operating systems, or network environments.
• Created or maintain databases of known test defects.
• Developed testing programs that address areas such as database impacts, software scenarios, regression testing, negative testing, error or bug retests, or usability.
• Trained end users about SAP functionality and help end users in UAT phase for all processes.