Project Management
Resume:
www.Sliqit.com
BHAVNA AGGARWAL
PROFESSIONAL SUMMARY:
Business Analyst with over six years of experience in diverse industry sectors including Retail and Financial Services.
Over 6 years of experience in mapping AS-IS processes, developing process solutions through brain storming sessions and designing TO-BE processes using UML diagrams such as Process-flow Diagrams, Activity Diagrams, Sequence Diagrams and Data-flow Diagrams
Strong Business Analysis skills and an understanding of the Software Development Life Cycle (SDLC) utilizing Rational Unified Process (RUP)
Skilled in gathering User Requirements, translating them into data, functional, quality, and usability requirements.
Experienced in requirements management, controlling change and preparing RTM (Requirement Traceability Matrix).
Extensive experience in Business writing skills in writing Business requirements document, Use Case Specifications, Functional Specifications, Systems Design Specification (SDS), Systems Requirements Specification (SRS), Data Dictionary, Requirements Traceability Matrix (RTM) across the Deliverables of a project.
Extensive Experience in UML and Process modeling using Use Cases, Use Case Diagrams, Activity Diagrams, Sequence Diagrams and Class Diagrams.
Worked with the team to implement an automated Identity and Access Management (IAM) solution to provide operational efficiencies by streamlining the current manual user access provisioning processes, minimizing the costs of managing and supporting user access provisioning and identity governance and improving overall user satisfaction with access fulfillment.
Adept with different Requirement Elicitation techniques like, JAD sessions, Document analysis, Prototyping, Market Survey, Interview, Brainstorming, Requirement workshop.
Experienced in determining task dependencies, identifying milestones & monitoring critical paths using Gantt charts, resource plans (schedule & allocations), network diagrams.
Reviewed the Test Cases for User Acceptance Test based on User centric design methodologies.
TECHNOLOGIES:
Operating Systems: Windows 95/98/NT/2000/XP, Unix
Languages: HTML, Java, XML and SQL
Tools: Rational Rose, Rational Requisite Pro, CaliberRM, MS SharePoint,
Database: MS SQL Server 2005, MS Access, DB2, Oracle, MS Word, Excel, PowerPoint,
Outlook, Visio, Project, Access
Reporting Tools: Business Objects, Crystal Reports, OBIEE, Tableau, Cognos
Testing Software: HP Quality Center, HP ALM, Clear Quest
Methodology: Scrum (Agile), Waterfall, XP
EDUCATION:
MBA in Financial Services Guru Nanak Dev University, Amritsar, India
ACHIEVEMENTS:
Distinction holder in both Graduation and Post-Graduation.
Top 3 candidates to intern with Citigroup in entire North India
PROFESSIONAL EXPERIENCE
Coach Inc, New York, NY Jan 2015 - Present
Business Analyst
The project was an update for the Coach and Coach Factory website for US, China and Japan; for an Ecommerce platform using Websphere. I worked on the projects for the Information Service and the Logistic Department for Coach and Coach Factory.
Responsibilities:
Contributed to the initial analysis of the project scope and definition document
Worked on Business Intelligence tools like Cognos, Business Objects
Experience in defining the as is business process and to be business process. Elicited, analysed, and documented user and system requirements for different functional areas.
GAP Analysis of As-Is business processes and define and design to be business processes.
Drafted Requirement Traceability Matrix (RTM) for traceability of requirements.
Created meeting templates for the JAD/JAR sessions, acted as facilitator to gather requirements and validated it with stakeholders/end-users/clients
Experience creating user experience deliverable including information architecture and Wire frames and work flows.
Authored functional specifications for existing web/mobile applications identified for technology migrations. Engaged meetings on web design, development, search on intranet best practices.
Designed Workflow diagrams, Use Case diagrams, Activity diagram using UML modelling tool Visio and documented the requirements using Business Requirement Document (BRD)
creating and transforming business requirements into system requirements/business rules and designing business models using UML diagrams -Context, Use Case, Sequence and Activity diagrams in Enterprise Architect, MS Visio, Rational Rose and Version 1.
Worked on a website design work-flow, web design based on HTML, XHTML and CSS.
Created and updated the XML schemas which act as middleware between the front end and back end systems.
Knowledge of Data modelling and working knowledge with Data flows. Experience with database management and fetching techniques in MS Excel. Database knowledge of design and development in SQL Server.
Performed UAT and Regression testing to estimate testing readiness of the build before every release.
Used Jira for Test Management activities along with Quality Centre for defect reporting and tracking purposes and to create, manage, run test suites, generate reports for percentage of failures, defect status etc.
Created a High level Test strategy document for the agile based project. Worked as an Interface between the users and the different teams involved in the application development for better understanding of the business and IT processes.
Environment: UML, SQL Server, Tableau, Business Objects, Scrum Agile Methodology, MS Visio.
MarketWatch.com, New York, NY Nov 2013 – Dec 2014
Business Analyst
The project is to provide research and outsight on the stocks, mutual funds and ETFs for the readers of the WSJ and provide data to the seekers such as the brokers and investment management companies
Responsibilities:
Gathered requirements from the SME’s (ETF, MF and equity experts, Content managers) on how to present the data and the new analysis tools to be employed.
Understood the exchange traded funds, mutual funds, stocks, bonds originating from the different companies
Prepared data feed specs from various rating agencies.
Prepared the UI wireframes inclusive of mouse over, clicks and double clicks etc.
Assisting the team on implementing Oracle IAM and IDM for Vendor and Internal systems provisioning and access control to provide for Enterprise SSO.
Managed and supervised a team of Business analyst and assigned various resources to different task.
Undertook project resource analysis, received status update from project managers which was used to calculate and estimate project resource percentage consumption.
Design various project financial data models used for tracking and estimating costs and expenses.
Undertook budgeting of projects, using WBS, estimation and actual to arrive at project cost variances.
Developed weekly reports that were used by management to assess the percentage of progress being made by the project team and compared it with hours burnt.
Worked with clients to have a better understanding of their needs and presented solutions using structured SDLC approach.
Gathered user and business requirements through open-ended discussions, brainstorming sessions and other requirement gathering strategies.
Documented the user requirements, analysed and prioritized them and converted them as system requirements that must be included while developing the software.
Developed source to target mapping document containing all the Business required fields along with the business rules, database and table names.
Created Mock-up forms in MS word for better visualization and understanding of the software solution.
Tracked change requests and monitored workload and schedule.
Facilitated JAD sessions with management, development team, users and other stakeholders to refine functional requirements.
Scheduled meetings with developers, System Analysts and testers to collaborate resource allocation and project completion.
Created and managed project templates, use case templates, requirement types and traceability matrix to map all requirements with their functional steps
Managed workload, schedules and coordinated status review meetings with project managers, business managers, cross block BAs and team members
Authored progress and completion reports which were submitted to project management on a weekly basis in MS project
Helped in creating end user manuals and procedure manuals
Environment: Rational Suite (Rational Rose, Rational Requisite Pro, Rational Clear Quest, Rational Clear Case) and Rational Unified Process, Agile Methodology (XP), Oracle IAM/IDM, Java, J2EE technology, Windows 2000 Advanced Server, UNIX / Oracle Platform, MS Visio, SQL server 2000, SQL server 2005,Microsoft Office suite.
UBS Financial, Houston TX Jan 2012 - Oct 2013
Business Analyst
Fixed Income Performance Attribution System (FIPA) was developed specifically to support Wealth Management Groups to provide most valuable advisory services to clients on Asset Projections, Executive stock option models, Portfolio Rebalancing, Investment Holdings, Liquidity needs and future goals. The system solution advised the clients on wealth management strategies, provided clear and complete picture of the client’s assets in position and those that are held by other providers. The system also provided full brokerage capabilities, access to IPO’s and other 3rd party products, research data, tax and insurance information.
Responsibilities:
Conducted user interviews at both in-house and client locations, gathered and analyzed requirements based on Waterfall SDLC methodology.
Designed and developed Use Cases, Activity Diagrams using UML in Enterprise Architect.
Identified, researched, Realized, investigated, analyzed, defined and documented business processes and Use Case Scenarios.
Performed Gap analysis by identifying existing technologies, documenting the enhancements to meet the end state requirements.
Conducted workflow, processed diagram and gap analyses to derive requirements for existing systems enhancements.
Assisted with user testing of systems (UAT), developed and maintained quality procedures, and ensured that appropriate documentation is in place.
Was Responsible for identifying and documenting business rules and creating detailed Use Cases.
Conducted User Acceptance Testing
Worked with development and testing teams to accomplish timely release objectives.
Used detailed knowledge of application features and functions assess scope and impact of business needs throughout analysis and completion of all enhancement specifications.
Acted as a resource in understanding how Information System carried out business functions and assisted in ensuring the timely and effective implementation.
Developed timelines for project delivery, and managed projects and resources to successful completion.
Liaised for projects with other corporate departments, including Executive, Legal and Information Services as well as vendor relationships.
Was responsible for all project documentations.
Extensively worked on Access, Excel, Word, PowerPoint, SQL, MS Project.
Environment: MS Office Suite, Waterfall SDLC Methodology, Enterprise Architect, MS Project, UML.
Signature Bank, New York, NY Feb 2011 -Dec 2011
Business Analyst
The project was to enhance the Centralized Enterprise Reporting System to support a wide spectrum of business reporting needs in Credit and Risk Management. As a Business Analyst, my responsibilities include conducting meetings with front and middle offices users, documenting the requirements gathered, assisting the technical lead to develop the functional specification document, assisting system testing and UAT testing, and providing user training.
Responsibilities:
Facilitated requirements meeting, JAD Sessions, group discussions & Interview with business users and Subject Matter Experts (SME) to elicit requirements.
Envisioned potential roadblocks and created mitigation strategies so that the project was proactive rather than reactive
Worked on Reserve Loss Forecasting Models of the Bank complying Sarbanes-Oxley Act (SOX Control) Procedures.
Worked closely with the business users to collect the reporting requirements. Built drilled down reports, Dashboard design and Wireframes.
Created reporting requirements, conducted peer review with Stake Holders and obtained agreement.
Utilized UML Notations to document activity, deployment and Workflow diagrams in MS Visio.
Identified Risk, Issues during each phase of the project and created Risk Mitigation activities working along with IT & Business Users.
Mapped the Identity and Access Requirements around defining the user roles to access the application.
Chaired Weekly Working Committee meetings with Business to discuss the status reports and issues and drive the project towards positive direction.
Created Process efficiencies by identifying and eliminating broken and dysfunctional processes
Environment: MS Office Suite, Waterfall SDLC Methodology, Enterprise Architect, MS Project, UML.
JC Penney, Plano, TX June 2010-Jan 2011
Business Analyst
Project included updating the ecommerce website (jcpenney.com), improve the checkout and order management system. Maintained up-to-date knowledge of store policies regarding payments, returns and exchanges.
Responsibilities:
Participated in website development from inception through implementation and maintenance; updated and optimized the online content to improve organic search indexing, rank and conversion.
Worked on integrating online store with OMS and warehouse/ Distribution channels.
Monitored and reported on multiple websites; established dashboards for various decision makers and developed, managed and provided analysis with recommendations using multivariate testing plans focused on optimizing landing pages.
Implemented IBMWCS e-commerce platform which supports faster and flexible site performance, more effective merchandising and easier management of multiple web sites.
The main focus of requirement gathering involved e-commerce transactions.
Conducted daily SCRUM meetings during the Sprint Development as a part of Agile Methodology.
Provide project management and business analyst support for the creation of a project tracking portal website exported from MS Access database using Ruby on Rails in an agile web development process.
Assisted in documenting requirements for "Mobile Application" version of the existing system.
Generated wireframes and prototype for the GUI. Created Mock-up forms in MS word for better visualization and understanding of the software solution
Validated all data sources and metrics for successful implementation of a procurement and spend analytics solution built on an Oracle Business Intelligence (OBIEE) platform.
Applied Agile software development life cycle methodology to gather business requirements and complete data mapping and ETL development to create business intelligence reports.
Conducted JAD sessions with various stakeholders to develop the Architecture of the application, that meets the business requirements, and to discuss open issues and resolve them and discuss change requests.
Performed Smoke testing after every incremental to ensure the system was running as per design and worked closely with the development team and the business users to make sure bug fixes have been fixed before communicating with the clients.
Responsible to make sure the team adheres to the defined SDLC process (Agile) in terms of defining standards, best practices and implementing methodologies and provide Performance.
Used business Tableau as business intelligence tool to transformation raw data into meaningful and useful information.
Created UML Diagrams including Use Case Diagram, Activity Diagram, and Sequence Diagram using MS-Visio.
Conducted walkthroughs with the Development and Test Team members to emphasis the main points of concern with the application.
Environment: Rational Rose, Requisite Pro, ClearCase, ClearQuest, MS Office Products, IBM WebSphere, XML, Java, J2EE, Oracle, MS Visio, DB2, SQL Server.
Citibank NA, SME Group, India Feb 2010- June 2010
Business Analyst Intern
The project was about developing end to end services with regards to opening and maintaining the Escrow accounts and developing strategies to provide competitive services and prices in various products as Equity Linked Debentures and commodity hedging (base metals).
Responsibilities
Understood the business and the process to be business process. Elicited, analysed, and documented user and system requirements for different functional areas.
Conducted user interviews at both in-house and client locations, gathered and analyzed requirements based on Waterfall SDLC methodology
Worked with Equity Linked Debentures team on developing new strategies for client’s assurance on transparency in the area of customized structured products.
Gathered requirements from the SME’s (Private Equity experts, Content managers) on how to present the data and the new analysis tools to be employed.
Understood the exchange traded funds, bonds originating from the different companies.
Prepared data feed specs from various rating agencies.
Designed Workflow diagrams, Use Case diagrams, Activity diagram using UML modelling tool Visio and documented the requirements using Business Requirement Document (BRD)
Performed the Feasibility and Risk Analysis to identify the business critical and high-risk areas of the application.
Worked closely with business, technical, design and customer service teams to exceed customer expectations.
Environment: MS Visio, MS SQL, Agile, UML, MS Office Suite.
Contact this candidate