Summary

• Around 7 years of professional experience as Business Analyst in Education/Retail/Insurance/ Telecom.
• Expertise in using leading industry tools like MS Visio, MS Word, MS Excel, MS PowerPoint and Requisite Pro to develop various project deliverables.
• Expertise in content management that includes understanding the business needs, defining a creative and useful software solution to the management, implementing and training the application to the user community.
• Extensive experience in conducting Joint Application Development JAD sessions with end users to provide for accurate statement of system requirements and a better understanding of common goals.
• Identified the options for potential solutions assessed them for both technical and business suitability applied technical as well as organizational changes according to the new system.
• Exceptional ability to build productive relationships with colleagues, clients, and vendors across all functional and technical disciplines.
• Extensive experience in translating complex business needs into clear and concise Business requirements documents BRD .
• Skilled in implementing Data Warehousing and Business Intelligence solutions.
• Experience in data modeling concepts like STAR schema and snow flake schema
• Advanced analytical and project management skills
• Strong Understanding of various SDLC methodologies such as RUP, AGILE, Waterfall, documenting Functional and Non - Functional Requirements with hands on experience in them.
• Expertise in leading team at Onsite, Project Management, Task estimation and
• Delegation, Training, Budgeting, Cost Benefit Analysis, and Forecast and Planning

Work Experience

Confidential

Role- Technical Business Analyst

• Working as a Technical Business Analyst for ProQuest which is a product based Information Technology Company serving libraries, institutions, corporations, government organizations, and information users around the world
• Also hold the position of Vice President of Education for IIBA Chicagoland Chapter since March 2013.
• I was also one of the reviewers for upcoming release of business analysis guide BABOK V3.0

Project

The project is to incorporate different Business units into Big Data Platform to reduce customer churn by implementing a customizable, easy to use reporting tool that can provide companies' sales, customer service and product management teams with valuable insight into customer' and researchers' use across all ProQuest platforms, content and services. Project involves the second phase implementation of different business units along with the first release enhancements

Roles and Responsibilities-

• Worked on SCRUM Methodology to help the team in maximizing productivity
• Developed the best practices for the Sales Team to get clear insight for the frontend/Big Data Dashboard
• Gathered requirements for dashboard, Analytics and Reporting needs
• Designed the look and feel for the Dashboard for ProQuest's' business units
• Guided my offshore team and third party in understanding the correct requirement and helped in creating APIs for business units like BIP and SUMMON
• Extensive experience working with Business Intelligence data visualization tools with specialization on Tableau
• Developed and deployed reporting views and reports in Tableau
• Coordinated and performed tests, including end-user reviews, for modified and new processes/systems, and other post implementation
• Converted excel sheets, csv files into flat files and created views
• Developed dashboard in Tableau for different business units
• Worked on backlog requirements and bugs from phase 1 release and distributed the work among different teams accordingly
• Worked on bugs related queries with developers and helped them in testing and verifying them to close the issue on time per sprint
• Used Jira to create weekly sprint and wrote stories and sub tasks for onshore and offshore team with Scrum master
• Provided immediate solutions to the sales users, related with different business old portals and phase 1 release from Big Data
• Analyzed the source data and handled it efficiently by modifying the data types.
• Generated context filters and used performance actions while handling huge volume of data.
• Generated tableau dashboards for sales with forecast and reference lines.
• User Java Script API to customize the views, selects, filters, date and time.
• Generated tableau dashboards with combination charts for clear understanding
• Prepared Use cases and look and feel documents and got reviewed with end users
• Used filters, quick filters, sets, parameters and calculated fields on Tableau reports
• Created actual sales and target sales view with Trend lines, table calculations to see the difference between each quarter
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports using Tableau
• Extracted data from SQL Server 2008 into data marts, views workbook consumption using SQL/ PostgreSQL
• Designed and published visually rich and intuitively interactive Tableau workbooks and dashboards for executive decision making.
• Conducted User Acceptance Testing, gathered and documented User Manuals and Business Rules
• Conducted JAD sessions among team and did retrospective sessions to achieve the time lines

Work Experience

Confidential

Role- Lead Business Analyst

• Confidential Walgreen wanted to implement vendor multi-sourcing strategy for their items across all stores. It was a data-warehousing project. In this strategy there are multiple vendors that compete to get the orders for a single Walgreen item. Different vendors may offer different deals, discounts or bonuses to get the orders for the item. Walgreen would then choose the most profitable offer and the contract for supplying the item would go to the vendor giving the offer.
• In order to implement the strategy the functional processes creating order forecast for Walgreen items had to be changed. Concepts like MVS item, Bonus item, Active Sub, Corp view, Sub Distr, Purchase Sub had to be incorporated in the process. Forecasted orders that were earlier provided at the primary level had to be provided at the sub level to business users and vendors. CFP application had to be provided with the flexibility to view totals by Control WIC for all DCs or totals by WIC only for the DCs that WIC is supplied to. Users need to have multiple views to allow different roll-ups depending on how they intend to use CFP to work alerts, collaborate with a vendor or export data for analysis. VIF and EDI supply processes had to be changed to provide them the view of forecasted data and Item/Distr information at different levels. PMM data had to be interpreted and processed with the changing levels of Distr information.

Confidential

• Cloning process is a complex process that involves bringing a new item introduced in Walgreen stores into the forecasting process. The new item is associated with one of the similar items that already exist in the stores. Then for the coming few weeks portions of the Historical sales, promotions, billings, lost sales, etc. for the look a-like item is attached with the new item and forecasting is done based on that data. This attaching of data is called filling. Once clone stop date arrives for the new item, filling process is stopped for it and forecasting is done based on its own data.
• There were lots of discrepancy in the cloning process such as inappropriate clone stop dates, unused clones getting dropped out of the process, new stores to which item was subscribed after the first week were not taken into account, etc. Hence a project was initiated to revamp the weekly cloning process.

Roles and Responsibilities for Lead Business Analyst

• Conducted individual and group sessions with application users and other stake holders to gather business requirements
• Thoroughly studied the inherent systems to have a clear understanding of the business processes and associated system workflow
• Followed SCRUM, Created epics for each sprint
• Distributed stories within team according to the requirement
• Prioritized the requirements, conducted focus groups sessions
• Wrote SQL queries to perform Data Validation and Data Integrity testing
• Carried out detailed and comprehensive business analysis with the RUP methodology.
• Conducted JAD sessions for better understanding and refining of requirements in coordination with multiple teams.
• Created data models and data flow diagrams for the to-be process
• Experienced in Requirement Analysis, Test Design, Test Preparation, Test Execution, Defect Management, and Management Reporting
• Strong understanding of Data Modeling in data warehouse environment such as star schema and snow flake schema
• Suggested improvements in the existing data warehouse model to improve the query performance of the front end applications
• Defined, documented and published Functional Specifications and BRD-Business Requirements Documents.
• Designed mockup and wireframes to communicate visual data flow to the end users.
• Performed requirement walkthroughs with the Developer and QA teams with the aim to develop testing strategies and test plans such that test cases reflect user needs.
• Assisted QA team by Reviewing test cases and clarifying requirements to ensure complete coverage of requirements.
• Conducted UAT sessions to approval.
• Promote the business analysis profession through the development of educational publications, seminars, and workshops designed to enhance and expand the skills and knowledge of Business Analysts
• Contributes on new business researches
• Running LinkedIn group for Business Analyst Discussion Forum - mostRecent gid 5014758 trk my groups-tile-flipgrp
• Define standards for business analysis through the creation of a guide to the Business Analysis Body of Knowledge BABOK Guide, a summary of the knowledge within the BA profession, reflecting current accepted practices
• Conduct webinars on Business Analysis techniques, new releases, CBAP and CCBA exams and procedures, researches and different organizational issues. These sessions conducted by me are globally approved by IIBA
• Provide Business Analysis certificates of PDUs to all attendees of my sessions which are valid for tests like CBAP, CCBA, ITIL and PMP worldwide
• Participate in the Board's deliberations and decisions in the matters of policies, finance, programs and personnel advocacy
• Conduct Webinar Study Group sessions for CBAP/CCBA Preparations for IIBA Members Non- Members
• Participate in IIBA monthly meetings actively
• Develop interesting course plans to meet academic, intellectual and social needs of Webinar and Attendees
• Develop and implement interesting and interactive learning mediums to increase attendee's understanding of Business Analysis and its course materials.
• Use variety of teaching techniques to encourage attendee's BA, SA, PM critical thinking
• Design lesson plans focused on experience levels and positions of attendees

Confidential

Role- Business Analyst

Project

The project involves managing Online Banking module that had various online services such as Online Investments, Online Retirements, Online Trust, and Online Mortgages for all customers. The application has a web-based interface customers can access their Personal Accounts online, apply for loans, mortgages and pay bills online.

Roles and Responsibilities-

• Conducted Gap analysis to understand business model and additional functionalities to be incorporated into its system
• Produced deliverable that include but are not limited to, identifying the Root Cause of failed processes, documenting business requirements, process workflows, and technical details using tools such as Word, Excel, PowerPoint and Visio
• Prepared project plans by producing project work breakdown structures, project charter schedules and by ensuring implementation, contingency, risk management, communications, quality assurance staffing plans are completed
• Documented existing process, procedures and work flows and made recommendations for improvement
• Lead projects and create detailed implementation plans with the assistance of senior team members and management
• Reviewed, analyzed, and evaluated information technology systems
• Conducted JAD sessions for better understanding and refining of requirements in coordination with multiple teams. Led a cross-functional team of engineers, PMI group members and trainers to develop features and fix project issues
• Assessed customer needs to provide timely problem resolution and escalation
• Ability to determine through proper evaluation the best approach to resolve the customer's needs based on customer's input and feedback or the type of service request received
• Documented various documents like Stakeholder Register, Risk Assessment Chart, Assumption Register etc. to start our project with better understanding
• Conducted multiple interviews to clarify requirements in order to start our documentations
• Maintained in-depth knowledge of distribution platform guidelines and capabilities to guide other teams involved.
• Drafted a comprehensive roadmap to achieve targets
• Documented Business Requirements, User Requirements and Functional Requirements
• Maintained issue log and change log

Confidential

Role- Business Analyst

Project Details

• I worked as a Business Analyst for Quinn Insurance Group in Quinn Motor Insurance project that aimed to revive the insurance business rules to make it more customers friendly, attract new customers, retain existing customers and thereby increase company profits.
• The project was to build an online insurance handling application that would facilitate the users to find the right insurance for their individual needs.
• The application required the user to login with valid user id and password to authenticate the person. After authentication, they could learn about insurance, get a quote, retrieve a quote or buy an online vehicle insurance policy. They could also file a claim or pay their monthly payments online. QUINN Insurance has transformed the insurance market over the years. Since established in 1996, QUINN Insurance has driven down the cost of insurance in Ireland and has gained a reputation for value, customer service and innovation. QUINN-Insurance provides general insurance products including private motor insurance, home insurance and commercial vehicle insurance.
• Products were sold over the phone to customers and brokers from purpose built call centers in Ireland and the UK. Quinn Motor insurance not only covered liability to third parties but the vehicle was also covered for loss or damage caused by fire, self-ignition, lighting, explosion or by theft or attempted theft and accidental damage.

Roles and Responsibilities

• Facilitated meetings with Subject Matter Experts for Requirements Gathering and transforming them to functional specification.
• Participated in writing data mapping documents and performing gap analysis to verify the compatibility of existing system with new business requirements
• Further clarified and prioritized requirements by conducting brainstorming sessions with the stakeholders and SMEs.
• Involved in meetings, walkthroughs and created meeting minutes.
• Created and submitted weekly status report to the project manager.
• Documented various documents including the Business Requirements Document and the Use Case Specification Documents.
• Used Rational Requisite Pro as requirement gathering tool.
• Identified all use case components including basic, alternate and exception flows.
• Participated in various architectural development sessions to provide technical teams with a better understanding of the requirements.
• Coordinated UAT and executed environment build plans.
• Analyzed Requirements and created Use Cases, Use Case Diagrams, Activity Diagrams using MS Visio.
• Gathered business requirements and converted them into functional requirement specifications and user requirement specifications. Used Rational Requisite Pro for Requirement Document preparation.
• Carried out detailed and comprehensive business analysis with the RUP methodology.
• Prepared Business Process Models, which included modeling of all activities of the business from conceptual to procedural level.
• Participated in Change control meetings recommending appropriate action after analysis of changing requirements.
• Conducted multiple interviews to clarify requirements in order to identify use cases and documented them.
• Studied and analyzed the data warehouse model of the project applications
• Assisted team of developers to revisit and change the design for extraction process from the existing data warehouse model
• Assisted QA team by Reviewing test cases and clarifying requirements to ensure complete coverage of requirements.
• Provided project manager with regular status updates assisting the overall project management initiative.
• Performed requirement walkthroughs with the Developer and QA teams with the aim to develop testing strategies and test plans such that test cases reflect user needs.
• Conducted UAT sessions to approval.

Confidential

Role- Business Analyst

Project Details-

I worked as a Business Analyst for BT Global services BTGS in BT SOUK PM project that covered job acceptance, orderings, installations, inventories and final closure of job proceedings with its billing.

Roles and Responsibilities-

• Conducted detailed and comprehensive business analysis by working with the client IT staff, supervisors, and end-users in order to identify system and operational requirements and improvements
• Prepared PROP for the Kick Off call with the client PM to discuss the Project
• Gathered requirements for all the different phases of the project.
• Gathered and analyzed market information and used findings to define product strategy.
• Conducted individual and group sessions with sponsors and users to gather business requirements
• Developed strategic partnerships with the business unit to develop a solid knowledge base of the business line, including the business plan, products and processes.
• Documented the business requirements and helped the business to signoff the business requirements
• Analyzed key metrics to measure product effectiveness.
• Identified product problems and strengths and collected data on the customer experience.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD Object oriented Design using UML and Visio.
• Develop business and functional use cases, project plans and manage the project scope.
• Delivered presentations on Project Status and Current Open Issues Report to Users, Stakeholders and other involved groups
• Drafted user stories, use cases and functional specifications to support product development.
• Provided strategic support in development of detailed project plans, work assignments, target dates etc.
• Conducted gap analysis to identify the compatibility between the legacy system and the new business requirements
• Maintained issue log and change log
• Conducted weekly meetings with the development and testing team to relay any changed requirements and updates on the development and testing
• Guided the development team to create SQL scripts to extract, transform and integrate operational data into data warehouse
• Assisted development team to create prototype data warehouse with an OLAP front end to show the Drill Down and Roll ups
• Guided my team in End to End, functionality and Regression testing of various systems
• Managed and updated project/circuit delivery dates in related tools with my Support Team
• Guided my team to create the Network diagrams
• Guided my team in performing inventory cleanse- Check the circuit/CPE identifiers, SLAs, IP Addressing and site details and tallying it with customer requirement CAF Contract Amendment form/Contract etc.
• Coordinated with teams to create commissioning report for all the deliverables.
• Guided my team in Commissioning report check to confirm the no. of circuits and CPE delivered to match with the Contract requirement.
• Guided my team in Inventory Management: Performing the amendments in the BFG backend systems to ensure customer is billed for the correct product.
• Injected the Billing Start Date in different tools to enable successful start of billing for project
• Leveraged in-depth understanding of end-to-end customer experience to identify pain points and latent customer needs.
• Ran focus groups, surveys and experiments with real users in collaboration with the different department.

Confidential

Business Analyst

Project Details

• I worked as a Junior Business Analyst in WLR3 ISDN2 Service Assurance project. WLR3 products are the wholesale access products such as PSTN ISDN available for communications providers to offer their own branded services to consumers using the network shared by Openreach and BT Wholesale.
• Openreach provides the interface to communication providers to place request for new access products or service maintenance request of the products under the Equivalence of Input directive from Ofcom Office of Communication, Communication Regulatory Authority in UK to ensure all the Communication Providers receive equal opportunity in terms of price, service, maintenance and quality.
• BT Global Services provides networked information technology and communication services leasing few services from Openreach to meet the OfCom Undertakings. It provides VPN and IP services, outsourcing, CRM and contact centers, security and compliance services, trading systems, applications management and hosting services, mobility solutions, bandwidth and LAN/SAN extension services, media and broadcasting, telecom, and sustainability services, as well as offers voice, data, Internet, and video services. The company serves financial institutions, financial market traders, and various enterprises in the Asia Pacific, Belgium, Canada, Central and Eastern Europe, France, Germany, India, Ireland, Italy, Latin America, the Middle East and Africa, the Netherlands, Nordics, Portugal, Russia, Spain, Switzerland, and the United States. BT Global Services was formerly known as BT Ignite Solutions. The company was founded in 2000 and is based in London, the United Kingdom. BT Global Services is a subsidiary of BT Group plc.

Roles and Responsibilities :

• Analyzed business requirements, business process and system architecture/design.
• Responsible for defining, documenting and publishing Functional Specifications and BRD-Business Requirements Documents.
• Followed the UML based methods to create Sequence Diagrams, Collaboration Diagrams and Class Diagrams and Activity Diagrams.
• Worked in the RUP Framework involved in iterations at each phase of the software life cycle.
• Knowledge evocation through user interviews and JAD sessions and used work flow diagrams, Process flow diagrams and E-R diagrams
• Designed Use-Case Models after understanding scope of the project and the business model
• Delivered Service Levels in accordance with Client specifications with Optimization of Costs.
• Designed Circuits, CPEs through Internal/ External Teams using Manual Orders or through Expedio Automated
• Development of various modules in accordance with Methodology framework.
• Analyzed existing data warehouse Data Model that had atomic level data and the summarized data.
• Wrote SQL scripts for data extraction, analysis and profiling from the data warehouse
• Creation and implementation of new procedures and documentation standards.
• Co-coordinated and aligned with the other Internal/ External teams to deliver the On time Project
• Job closure after the final check of Network Diagram before billing is initiated as the final activity, taking into account the measured horizon activity

Confidential

Role- Software Development and Testing Engineer

Roles and Responsibilities-

• Analyzed and prepared testing strategy and plans
• Written Sanity Test Cases
• Troubleshot and resolved internet connectivity, general software and hardware issues
• Performed Functional Testing
• Performed Regression Testing
• Tracked and Logged the defects through the Bug Tracking Tool
• Analyzed Test Results and Created Bug Report
• About Program- Coursework in Advanced Business Analysis- this program covered the International Institute of Business Analysis's IIBA Body of Knowledge, supplemented with practical examples and resources. It aimed to teach the structure, policies and operations of an organization and the ability to recommend solutions to help the organization achieve its initiatives. It had sessions to create high impact marketing plans and programs, sessions to develop analytical skills to gain deeper business insight.
• Program provided a platform to learn about and discuss live scenarios with Business Analysts from different industries, to create and participate in new initiatives in the field of Business Analysis, to discuss advanced Business Analysis methods and techniques.

Confidential

• Designed a circuit on RFID based Attendance System
• RFID is used in educational institutions and applications where authentication is needed
• Required Circuit Components were RFID Reader, RFID Tags, LCD Displays and ATMEGA8 Microcontroller
• Radio frequency technology is used in many applications
• RFID tags are of two types Passive Tags and Active Tags
• This project used passive tag
• RFID reader contains a copper winding in it, this winding acts as an antenna
• When the tag is placed near the reader, due to the induced mutual inductance energy, data is transferred to reader
• Reader then transfers data to the Microcontroller. Microcontroller checks for the data continuously, if any data is received, microcontroller compares the data in database.
• If the tag is authenticated, microcontroller takes the attendance.