SUMMARY

• I am an experienced Business Analyst who has led or participated in multiple projects involving process improvement (including those in regulated environments).
• Have strong experience working throughout the full SDLC and has experience working with both data analysis and UX/UI design.
• Have exceptionally strong knowledge with SharePoint and has Administration level capabilities and has been on multiple DW/RDBMS related projects and has strong knowledge of concepts/tools//etc.
• Expertise on Process Maps, Role Based Map, Decomposition, Business Scenarios, Traceability Matrix and Storyboards.
• Have a knowledge of Enterprise Data Management (EDM) as I have worked in the area of Data Governance, Data Quality, Data Migration, ITSM and other core related areas.
• Have exceptional analytical skills, great communication skills (both written & verbal), is local and can start immediately.

TECHNICAL SKILLS

Business Analysis: Requirement Analysis, Business Rules, Data Flow Diagrams, Flowcharts, Business Process Modeling & Improvement, Risk Analysis, Prototyping, Cause and Effect Analysis, BRD.

Software Packages: MS Office Suite (PowerPoint, Word, Excel, Access, Outlook), MS Project, MS SharePoint, MS Visio, Rational Rose, Requisite Pro, HP QTP, Rally, SAP, Informatica, Calypso, Murex, SAS Language, PowerShell, UMLv2, Business Objects, JD Edwards, Crystal Access, SharePoint 2010 & 2013, InfoPath, Caliber RM, Bill Trac Pro, Granite, Documentum, Filenet, Primavera, My SQL, IBM Cognos, Syspro, QlikView, IBM BPM 7.5, XML, Telco, Active Directory, File Server, Hyperion Financial Reporting 11x, Oracle 11g database, DB2 database, Oracle E - business.

Operating Systems: MS Windows (2000/XP)

Methodologies: Agile (Scrum, Lean & Kanban), Waterfall, RAD, JAD, RUP, UML, Use Case and Test Cases, Crystal Reports, Six Sigma, ITIL

PROFESSIONAL EXPERIENCE

Confidential, Madison, WI

Sr. Business Analyst/Project Manager

Responsibilities:

• Worked on a project related to the Transition plan from DB2 Warehouse to SQL Warehouse, investigated, designed and created the DB2 Warehouse.
• Worked as a Project Manager and used Hyperion Financial Planning, identifying business requirements and implementing impact solutions and followed the Agile/Waterfall Methodology throughout the lifecycle.
• Worked with Business Users (Accounting/Finance) to gather and document business/data requirements (General Ledger information) for new reports, as well as any changes or enhancements to existing reports, templates, dashboards, ad-hoc query tools, etc. to Hyperion Financial reporting tool.
• Working with various GL End user departments within the organization to ensure all requirements are met via the new reporting solution and data transition.
• Worked closely with the vendor and other project team members to ensure any issues identified during development or in regards to schedule are communicated on a timely basis for resolution.
• Conducted JAD sessions with the Development and Quality Assurance teams to deliver the requirements gathered and facilitated them in data transition, report creation, customization and unit, integration and regression testing were performed to validate the reporting capabilities.
• Ensured testing issues are identified, tracked, reported on and resolved in a timely manner.
• Coordinated monthly reporting, forecasting, and plan/budget development of the business.
• Involved in the creation of Project Charter and Project Plan and led complex projects from inception through completion, delivery projects on time.
• Created User Stories, Business requirement documents and Functional Requirements documents.
• Understood the technical and business implications of DB2 Warehouse and the usage of data by business stakeholders.
• Analysis of operational and performance data derived from various databases, systems and other information sources.
• Created processes for the transition plan by getting the complete knowledge with the technical and services departments and the OOAD approach for analysis and design.
• Analyze, create and maintain enterprise master data supporting quote to cash process. Communicate with internal & external customers to address issues and provide support on data quality and integrity improvements.
• Involved in designing physical data models of master data and have an understanding of DBMS and deployed concepts in creating database.
• Involved in researching and analyzing the DB2 Warehouse and different components of database residing in it mainly Claims, Premium, Settlements and Ratings (Property & Casualty, CD and CL).
• Performed the Audit of database reports in order to analyze the database/tables/fields being used by Business Group for reporting purposes.
• Involved in creating the Data Dictionary and Data Models for different databases (WHSEINTG and others) over the MS Visio.
• Act as a liaison between IT department and Business Stakeholders, gathered all the requirements, and validated it with different SMEs and worked with cross functional areas in order to make a transition from DB2 Warehouse to SQL Warehouse.
• Gathered all the information related to DB2 Warehouse i.e. List of Tables, Views, Columns and Business Users so as to get the complete picture of the Current State.
• Led JAR sessions and JAD sessions with QA and Dev teams ensuring that the reports which were being extracted fulfill all business needs.
• Created Data Models, Data Dictionary, Data Load Diagrams, Data Flow Diagrams, E-R Diagrams and Product Report Summary.
• Created High Level pictorial Warehouse Summary in which gathered all the information related to Visual containing a representation of the IG Warehouse, User Views, connections to BIDW (if needed); Current State Reporting Process (Canned Report Tools, End User Ad-Hoc Reports, etc.)
• Gathered the list of all current-state reporting methods including canned reports, tools, repeated manual reports, and ad-hoc report users with an aim to consolidate and eliminate redundant data and reports from the database and SAS Analytics for DATA mining and DATA categorization.
• Conducted Scrum sessions within the group to get the status updates and used JIRA for the prioritization of tasks, planning of each task, assigning and updating the list of tasks.
• Have worked in the area of IT Governance i.e. Strategic Alignment and Risk Management and used RASM for IT controls for compliance.
• Conducted sessions among different groups (Business stakeholders, IT Services and Technical) to bridge the gap and managed security and permissions on web applications.
• Designed the COST MODEL for storing data in the SQL WAREHOUSE.
• Created and compiled reports, developed cost and other models, performed data validation.
• Analyzed qualitative and quantitative data and provide recommendation to customers and business stakeholders.
• Involved in understanding the types of reports and their implications being used by Business Stakeholders so as to retire the tables/views/columns which are residing in the InterGroup Warehouse.
• Involved in writing test scripts for the QA team to find the Gaps in retrieving the reports from the SQL Warehouse.
• Conducted meetings with Business Stakeholders in regards to know the interaction with the InterGroup Warehouse and conducted the UAT testing for the final acceptance by Business Groups.
• Updated process documentation and used different methodologies (Six Sigma and Lean) to revamp the processes and aligned it with the new IT infrastructure.
• Involved in updating the process and procedure documentation, revamping them as per the changes made through the Change Management.
• Leaned different processes of retrieving the data from SQL Warehouse.
• Created complex queries and reports using MSSQLServer 2008 R2 and Excel 2010 and created tables, indexes and views in MSSQLServer 2008.
• Maintained and managed documents at SharePoint 2010 and gathered requirements for updating them.
• Prepared the unit, integration and acceptance testing by following the V-Model Software development Lifecycle.
• Worked on the project of Supply Chain Management to upgrade the inventory management requirements on SAP Supplier portal.
• Worked with SAP functional analysts and business users to gather custom interface requirements and support SAP/HR benefits module.
• Involved in technical areas of SAP to design, develop, test, and troubleshoot custom SAP solutions within our client.
• Maintained day-to-day operations of the Gentran Server for Windows system as well as work with customers, brokers, vendors, and other external partners to implement new EDI transaction sets.
• Worked on a project in which we enhanced and modified the productivity of the credit card production core application to reduce the cost of application maintenance and improve productivity.
• Update the application in order to meet the business requirements of the client, re-designed the core credit card production and billing application.

Confidential, Philadelphia, PA

Sr. Business Analyst/Project Manager

Responsibilities:

• Involved in the transition cycle of Insurance application (Property & Casualty) i.e. from APPS to GUIDEWIRE.
• Worked on the Transition Management Plan from APPS application to GUIDEWARE.
• Managed the project and was involved in creating the Due Diligence Plan.
• Managed meeting with the Business Stakeholders for the requirement gathering purposes.
• Involved in the creating, planning and implementing the Knowledge Acquisition Plan (KAP).
• Defined process for acquiring knowledge and understood how APPS support business and areas related to Application Inventory List (AIL).
• Created and mapped the Current state of APPS application and provided map for the transition to GUIDEWIRE.
• Experienced with rational unified process (RUP), agile (Scrum) software development, six sigma standards and UML and followed the Agile methodology throughout the project.
• Gathering the business info related to Billing, Claims and Loss Control so as to provide support to the APPS users and customers.
• Used Hyperion Financials Reporting to gather the information/data of all the Premiums paid by the customers and mining the data to get the report of the customers who have not paid the premiums.
• Have a good exposure to XML as I have used XML to extract data from FOOTPRINTS.
• Involved in defect management system and look at the various tickets for categorizing the tickets.
• Defined the types and symptoms of the tickets and writing Test Scripts for the Tickets need to be resolved.
• Build an application based on the API concepts.
• Involved in the credit risk assessment, auditing, SOX compliance and conducted interviews with Process Owners, Administrators and Functional Heads to gather audit-related information and facilitated meetings to explain the impacts and effects of SOX compliance.
• Have worked on Salesforce Management tools like TELEOPTI and Zoom in the insurance domain and Middleware to provide customer support.
• Have a knowledge and worked on Microsoft CRM to look at Sales, Leads and activities related to business customers.
• Performed the analysis of the types of reports extracted from the TELEOPTI and ZOOM.
• Performed on-going analysis of current procedures and recommendations for process improvements.
• Elevated and resolved disputes with the counterparty in a timely manner and organized and managed training programs for the end clients.
• Reviewed trade confirmations for OTC derivatives trades, including rates, credit, equity, commodity and FX derivatives.
• Managed and created outstanding trades and the firm’s trade documentation.

Confidential, Bloomington, IL

Business/Process Analyst

Responsibilities:

• Involved in BoSERC (Business of Systems Enterprise Release and Change Component) Triage for Awareness and Alignment purposes.
• Created the list of Change requests need to be escalated to the CAB (Change Advisory Board) and being a part of the CAB, performed an analysis over the issues and prioritized accordingly.
• Conducted impact assessment to determine the nature and extent of change to various Change request.
• Developed strategies and created plans for Change management programs. Engaged in on-going Production Support to stakeholders for Change request and programs.
• Involved in various components of Change Management Strategy i.e. Situational Awareness, Supporting Structure and Strategy Analysis.
• Conducted Risk Assessment for the Change Management, analyzed and documented the overall risk and risk factors.
• Facilitated the Change Management Plan and used Prosci’s change management methodology.
• Worked in the Content Management area as far as publishing, updating and managing of processes, procedures, and different other templates are concerned.
• Involved in data extraction, data mapping and data analysis for different Business departments (Bank, Health, Life, and Property & Casualty).
• Build an upgrade modules of Confidential Mobile Application and for which worked cross functionally to conduct meetings with business stakeholders and requirement gathering sessions.
• Worked within a complex Web environment encompassing Web Services and application programming interface (API).
• Involved with the API developer team to assist them to drive ongoing improvements in the application.
• Extracted data from multiple databases for report creation to provide support to Bank, Health & Life departments, expert in Extraction, Transforming and Loading (ETL) data flows using SSIS; creating mappings/workflows to extract data from Oracle, SQL Server and Flat File sources.
• For the data extraction purposes, used SQL to get tables and created views as well for multiple databases and with that used different other Web based sources to extract live data for analysis & reporting.
• Have used QlikView to reduce operational cost, streamline processes and financial reporting.
• Conducted JAD sessions with Business/Systems stakeholders to review and analyze current situations of processes.
• Involved in the alignment of Data Governance issues, policies and procedures with the Business Stakeholders.
• Involved in the authentication of the data (data reporting and structure) for the authentication purposes.
• Conducted Sprint sessions within the team to get the status the work effort being involved in different projects.
• Worked on creating the BPM Framework, i.e. created BPM Artifacts, BPM Charter, BPM Templates, BPM Repository, BPM reengineering of process and procedures through SPMP & PDP.
• Involved in the development of social media application built for the Confidential employees to share and exchange ideas and navigate in different communities and networks.
• Involved in the creation of Data flow diagrams, Swim Lane Diagrams and Data models.
• Involved in Business Process Modelling and its components i.e. Descriptive Modelling, Analytical Modelling and Executable Modelling.
• Used the IBM BPM 7.5 for successfully creating the processes by streamlining them and with that provided the visibility to interpret them easily to stakeholders.
• Used the Lean & Kanban approach to reduce the waste from the process flow and increase the performance of process.
• Used ORACLE (EBS) and COGNOS to create different financial reports.
• Extracted and created financial, operational and budgeting reports from Oracle Financial and manipulated on excel for analysis and provided recommendations to Business stakeholders.
• Created reports related to A/P, A/R, Cash Management and Purchases, and with that involved in the audit of confirming receipts related to A/P.
• Followed and implemented the Six Sigma and Lean concepts in the PDP (Process Development) and SPMP (Process Improvement) in the Auto Insurance, Health and Fire.
• Have used ITIL services to do the configuration management and maintained the Service Catalogue and Service Level Agreements.
• Involved in creating the Business Process Management Framework (BPM) and its elements. Conducted meetings with different groups for setting out the training plan of EOM concepts within the BPM Framework.
• Handled Active Directory and created folders on it and with that requested Administrator to delegate rights to different users.
• Managed SharePoint dashboards and other internal tools (SPA, Wiki, Lotus Notes, ICP Playbook)
• Used Visio extensively to create Swim lane diagrams for depicting processes flow and procedures associated to them and created Fishbone diagrams for the performance excellence.
• Used GRC Archer as I have worked in the area of aligning corporate policies and report compliance with internal control and regulatory requirements.

Confidential, Plano, TX

Financial/ Business Analyst/Project Manager

Responsibilities:

• Developed an application on the SharePoint as per the requirement by the internal Operations department.
• Worked as a Project Manager for one of the project related to Supply Chain Management.
• Managed the project of migration of VLS system (Inventory Management & Operational Application) to an automated application.
• Assisted in creating Project Plan, Road Map. Designed Requirements Planning and Management document.
• Identified subject-matter experts and drove the requirements gathering process through approval of the documents that convey their needs to management, developers, and quality assurance team.
• Have used Rally to continuously track and prioritize work according to its value and its ability to advance your strategy.
• Identified subject-matter experts and drove the requirements gathering process through approval of the documents that convey their needs to management, developers, and quality assurance team
• Have used Rally to continuously track and prioritize work according to its value and its ability to advance your strategy.
• Applied Supply Chain and logistics concepts to gather, interpret and document business and stakeholder requirements; map processes and performed systems analysis, data analysis, data modelling and gap analysis; developed functional requirements, technical requirements, test plans, user documentation, training materials and user acceptance criteria.
• Engaged and assisted clients to design and implement data driven processes that provide key metrics and benchmarking that improve supply chain reporting, planning and decision-making (including demand planning).
• Worked to improve the planning and schedule process on a regular basis and identified ways to improve customer service, inventory investment, and supply chain efficiency.
• Supported the planning for new product introductions through effective scheduling and procurement.
• Engaged and assisted clients to design, configure and implement processes.
• Engaged and worked closely with clients to drive supply chain integration and continuous improvement.
• Worked with clients to support supply chain best practices and coordinated and managed change solutions.
• Ordered, tracked, and monitored inventory of supplies and finished goods system-wide, ensuring freshness and proper handling of critical substances, and accuracy in billing and record keeping.
• Allocated and managed work resources as required for the deployment of project and coordinated with all the roles and activities to get the updates on a weekly basis.
• Allocated and managed work resources as required for the deployment of project.
• Gathered all the business requirements and coordinated with the stakeholders from time to time for the Mobile application development project.
• Performed the testing for the mobile application and its different features for the UAT.
• Provided training as well to the personnel to get the familiarity for navigating the application.
• Business Analyst with In-depth knowledge of AGILE/WATERFALL SDLC (Software Development Life Cycle) and development practices (ranging from traditional to Agile). Thorough understanding of RUP (Rational Unified Process) and the various stages.
• Translated business requirements into Functional/Non-Functional specifications for the BI/Data Warehouse.
• Analyzed existing business processes and logic in the various functional areas within purchasing / inventory / warehouse operations through personal observation and user interaction.
• Assisted in the maintenance, documentation, support and coordination of one or more Master Data items throughout their lifecycle.
• Performed analysis and recommended ways to manage Master data quality and improvement.
• Created and developed an application related to Inventory Management database.
• Skilled in gathering User Requirements, translating them into data, functional, quality, and usability requirements and created use cases on Visio.
• Extensively worked on Business Process Models with understanding of Business Process Modeling. Created new models and updated the existing models. Used tools like Rational Rose, MS Visio.
• Have working knowledge of SharePoint 2010, experience using InfoPath and Workflows.
• Developed forms, work through testing of automated forms, and promote InfoPath forms to the production environment, involved in storing the data in InfoPath in an XML format and used InfoPath fillers.
• Worked in the Content Management wherein I was responsible for creating, editing and managing content.
• Published the content to a repository SHAREPOINT to support access to the content.
• Strong experience in preparing Business Requirements Document (BRD), Use Case Specifications, Functional Specifications.
• Well acquainted with Workflows and UML (Unified Modeling Language) diagrams such as, Use Cases, and activity diagrams.
• Experienced in requirements management, controlling change and preparing RTM (Requirement Traceability Matrix).
• Created User stories, planned, scheduled and added Backlog for the prioritization process in Rally.
• Involved in Iterations/Sprint planning and assigned owners for each task in Iterations.
• Checked the progress (Rally) of the team members by overlooking the status of different tasks assigned to each owner.
• Worked in the area of Web services as involved in gathering business requirements for web services in a Service Oriented Architecture (SOA).
• Organized end-user training session after the successful UAT session and experience in coordinating with Off-shore Development & QA team.
• Worked on Hyperion Financial Reporting tool i.e. created and maintained ledger, planning, and reporting and Oracle EBS (A/P, Procurement and Sourcing)
• Prepared templates for achieving quarterly forecasts, annual budget, ad-hoc reporting and management reporting by working with the business managers.
• Developed a Capital Budgeting Analysis through NPV (Net Present Value) to determine yield returns of the prospective projects from AT&T and Ericsson.
• Calculated ROI and Payback Period for particular investments.
• Performed Variance Analysis for monitoring purpose against forecasted and budgeted budgets, SG&A Analysis and Revenue Analysis.
• Used DCF (Discounted Cash Flow) valuation methods to measure cash inflows and cash outflows of the project and in making business decisions.

Confidential, Chicago, IL

Business Analyst

Responsibilities:

• Requirement gathering, Business Process flow, Business Process Modeling and Business Analysis.
• Worked with the Business community, Tech Lead and 3rd party vendors in gathering their requirements and data transaction information related to OLTP, OLAP and ASP.
• Co-authored business requirements document with project teams. Extract, discuss, and refine business requirements from business users and team members.
• Facilitated and managed meeting sessions with committee of SME from various business areas including Mortgage Servicing, Loan Monitoring and Asset Management by following the OOAD approach.
• Lead Advantage Global accounting systems and trade/transaction commission conversion from a custodial system to middle and back office systems in CALYPSO. Handled the project from acceptance testing/signoff to the go live stage in. Products covered included Foreign Exchange (FX), Derivatives, Money market, Swaps and Debt.
• Led an IT team for the Calypso project and worked with front and middle office end users.
• Involved and tracked end of day positions fed in Calypso, mainly for VAR calculation & out of the box Calypso reporting.
• Configured Calypso for the conversion to handle the accounting systems conversion using my domain expertise in the said products.
• Helped with Data Mapping between the data mart and the Source Systems.
• Extensive work experience with Portfolio Managers, Experienced Traders, and Compliance Manager to configure the rule-based scenarios for capturing market and credit risk, general multi-factor sensitivity analyses, and P&L.
• Involved in providing Production Support/Trouble shooting during different phases of release.
• Developed and implemented processes and tools for requirements gathering, analysis, planning, tracking and delivery using Rational Rose requisite pro - RUP.
• Worked on resolving the issues and helped them adapt to the best practice for Calypso DTCC DS Match V12 SP2 module implementation.
• Performed Gap Analysis for new functionality requirements, as well as prioritized them based on actual business needs so as to align them with the product release roadmap.
• Designed and developed Use Cases and UML models using Microsoft Visio.
• Prepared and analyzed AS IS and TO BE in the existing architecture and performed Gap Analysis. Created workflow scenarios, designed new process flows and documented the Business Process and various Business Scenarios and activities of the Business from the conceptual to procedural level.
• Have a knowledge of File server and File Sharing and used AMAZON S3 for file sharing and network protocols.
• Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2000.

Confidential, Chicago, IL 

Business/Quality Analyst 

Responsibilities:

• Knowledge of Medicaid Drug Rebate Program which is a partnership between CMS, State Medicaid Agencies and participating drug manufacturers and with that have the knowledge of 340 Drug Pricing Program & Pharmacy Affairs.
• Coordinated the needs of functional departments and establishes priorities for LIMS requirements gathering, system design and implementation by following the AGILE/WATERFALL Methodology.
• Exposure in Serialization concepts as have used in in the storage and transfer of data.
• Responsible for LIMS documentation, including, converting User Requirement Specifications to a Detail Design Specification, writing Configuration Test Plans and summary reports.
• Worked with Validation and Quality Assurance departments to ensure LIMS is implemented following development life cycle approach.
• Implemented and understood the PBM (Pharmaceutical Benefits Management) role in the requirement gathering phase.
• Well experienced inEDIandHIPAAwith multiple transactions involvingclaims handlingand processing, with payerandprovider experience(270 & 271, 276 & 277, 837 P/I/D, 834, 835).
• Have worked on the Food and Drug Administration application for the compliance standards.
• Gathered all the requirements from SMEs of various areas to understand the compliance standards need to be implemented.
• Involved in facilitating the business process and change management to deliver expected outcomes.
• Have used HP QTP for the testing and assigning the task to different owners for single and regression testing.
• Designed and Implemented Control process and procedures for Support, sales and service towers.
• Hands on experience on SharePoint, have Designed and Monitored SharePoint as a data repository and data reporting tool.
• Gathered data in different formats i.e. MS Excel and MS Access to update into SharePoint.
• Maintained up to date and accurate Project wise updates in SharePoint based CR Tracking tool.
• Maintained the protocols of SharePoint architecture, permissions and hierarchies for each contributor.