PROFESSIONAL SUMMARY:

• Over 8 years of extensive experience as a Business Analyst in business and functional requirements elicitation, analyzing requirements, statistical data analysis, data mapping, object - oriented designing, Design of Experiments, Regression and Response Surface analysis, Unified Modeling Language (UML), SDLC methodology (RUP, Agile, SCRUM, XP, Waterfall) and project management in finance and banking domain (Retail banking, Investment banking, Private banking).
• Excellent knowledge in Corporate Finance, Investment Banking, Credit tracking, Asset Management, Wealth Management, Derivative products such as Options and Futures, Swaps, Fixed Income, Trade Life Cycle, FIX protocol, Mortgage, Insurance, Bonds, Section 508, FASB, and GAAP.
• Good knowledge on different Relational databases like Teradata, Oracle and SQL Server.
• Very efficient at performing GAP analysis to check the compatibility of the existing system infrastructure with the new Business requirements and Best Practices, SWOT analysis, Business Rules Analysis, Impact Analysis (Business, Technical), Risk Analysis and Cost Benefit analysis.
• Good knowledge on latest BI Tools like Tableau
• Knowledge in understanding the data and designing/Implementing the enterprise platforms like Hadoop Data lake and Huge Data warehouses.
• Utilized MS Project and variance analysis to manage schedules, meet deadlines and plan resources in line with triple constraints. Followed up with weekly project status, organized task review meetings, conducted status meetings, managed deadlines, and facilitated prioritization discussions.
• Working knowledge of implementing Service Oriented Architecture involving Web services, Web methods, MT servers and Data mapping .
• Ability to produce high quality requirement specifications to support ERP functional design development.
• Efficient at conducting UAT (user acceptance testing), Functionality testing, Unit testing, Integration testing, System testing, Operation Readiness te0073ting and Regression testing.
• Extensive experience with Data Warehousing, Extraction, Transformation and Loading (ETL) and Business Intelligence (BI) tools.
• Proficient in producing documents like Business Requirements Document (BRD), Functional Requirement Specifications ( Confidential ), Software Requirement Specifications (SRS), Request for Proposals (RFP), and Requirements Traceability Matrix (RTM).
• Adept in creating Use Case diagrams, Activity diagrams, Sequence diagrams, Flowcharts, Key Performance Indicators (KPIs) and experienced in change management .

TECHNICAL SKILLS:

Business Tools: MS Project, Lucid chart, MS Visio, MS Excel, MS Word, MS PowerPoint MS Access, Oracle (ETL), Swim lane chart, SIPOC, Value Stream Mapping, Root Cause Analysis, QFD s, Failure Mode Effects Analysis (FMEA s), Minitab, Design Expert, JMP.

MS: SQL Server 2008/2005/2000 , Oracle 9i/8i/10i, MS Access, Mainframe, DB2.

Modeling/Requirements Management Tools: UML, Rational Software Architect, HP ALM, Ms Visio, Websphere Business Modeler

Change Management Tools: Remedy, JIRA.

Operating Systems: Windows 2003/2000/ XP, Solaris 8.0, LINUX 7.3, 8

Languages: C, C++, JAVA, JSP, SQL, HTML, CSS, XML, UML

Methodologies / Frameworks: Agile, SDLC / Waterfall, Scrum, XP, DSDM, RAD, MSF, DMAIC, DMADV, DFSS, Lean.

Content Management Tools: SharePoint, Documentum, TeamSite, DOORS, Rational Rose

ERP Tools: SAP, Oracle, PeopleSoft

QA Testing / Defect Tracking Tools: Rational Tools Suite, HP QC, QTP.

EXPERIENCE:

Confidential, IL

Senior Business Analyst

Responsibilities:

• Interacted with stakeholders and gathered requirements as per the business needs.
• Provided primary liaisons between business/operations/core processing technology team and external development team.
• Utilized Agile Scrum methodology and conducted Daily stand up meeting, Sprint Planning meeting, Sprint Review meeting, and Sprint Retrospective meeting.
• Conducted GAP analysis by understanding the AS-IS system and the TO-BE system requirements by having discussions with the SME’s.
• Maintained project documents to be used for collaboration with developers, QA, project manager, etc. on Confluence .
• Utilized UML for process modeling and created Use Cases, Activity diagrams and Sequence diagrams using Rational Rose and MS Visio.
• Analyzed and Developed bi-directional integration between Service Now and JIRA using Workato.
• Gathered UI requirements to build service now forms. Created Mock-up screens using Axure.
• Performed Admin responsibilities for JIRA and Confluence. Responsible for upgrading to new versions of JIRA.
• Responsible for creating Disaster Recovery Plans for over 80 applications handled by the team.
• Responsible for gathering requirements and documenting the functional and technical requirements for Computing labs in the cloud.
• Performed UAT and performance testing for application submission process at Yale school of Medicine.
• Monitored project status to ensure progress toward completion, required procedural steps are completed fully and timely, participants are informed of progress.
• Responsible for Risk Analysis to detect the risks associated with the development of the new system. Additionally, formulated a Mitigation Plan to remove or reduce risks of high severity and one that would have major financial impacts.
• Created UAT/QA test plans, strong manual, functional, system and regression testing in an agile development environment.
• Worked on Service Now and JIRA ticketing Tools.
• Developed Test Plan and Test cases based on the Use cases and Functional specifications.
• Performed functional testing, reviewed and approved test cases and test results.
• Recorded all the test scripts and test results in Zephyr testing which is an add-on for JIRA.
• Provided training to the testers, and helped them in using zephyr testing.
• Conducted meetings/calls and classified the bugs as functional or technical (low, medium, high).
• Tracked UAT (User Acceptance Testing) to verify the implementation against the requirements.
• Collaborated with DBAs to perform data mapping using MS Excel and executed complex SQL queries to filter data from the MS SQL database
• Provided live support and training for the end users.

Environment: AGILE SCRUM Methodology, HTML, JIRA, BPMN, SharePoint 2013, Oracle, SQL Server, MS Access, MS Excel and MS Project, Test Director, Confluence, Zephyr Testing.

Confidential, MN

Senior Business Analyst

Responsibilities:

• Interacted with client groups to determine user requirements and goals through interviews, surveys and questionnaires .
• Created Project Charter and Work Breakdown Structure.
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
• Performed Risk Analysis and Impact Analysis in order to be prepared for potential business and technical risks to the system.
• Prepared corresponding artifacts: FRD (Functional Requirements Document), BRD (Business Requirements Document) and SRS (System Requirements Specification).
• Created affiliate artifacts: Use Cases, Activity diagrams, Sequence diagrams and Interaction diagrams using MS Visio.
• Utilized web services and web methods by understanding the data input and flow of information through various web pages.
• Conduct requirements gathering sessions and document complex requirements, processes, features, and business needs specifically focused on web content management and portal applications
• Utilized Agile Scrum methodology and conducted Daily stand up meeting, Sprint Planning meeting, Sprint Review meeting, and Sprint Retrospective meeting.
• Determined the velocity of each sprint and created the Sprint burn down chart, storyboards and Product Backlog and managed Requirements churn.
• Hands on expertise in migrations from MS SQL Server 2000 to MS SQL Server 2005 to MS SQL Server 2008
• Developed user specifications, use case statements and diagrams and documents to produce a statement of work. All data modeling and user interfaces were prototyped using Microsoft Visio.
• Implemented the Incremental methodology of software development with its various workflows, artifacts and activities.
• Identified candidate business processes which leverage SharePoint tools to enhance day-to-day office functions using workflows, Info Path forms.
• Facilitated code review sessions by preparing minutes of the meeting and collecting feedback to prepare the code review document.
• Prepare comparison of expense to budget reports for executives on demand and on weekly, monthly and quarterly basis
• Designed and created Data Quality baseline flow diagram, which includes error handing and test plan flow data.
• Performed functional testing, reviewed and approved test cases and test results.
• Conducted triage calls and classified the bugs as functional or technical (low, medium, high).
• Tracked UAT (User Acceptance Testing) to verify the implementation against the requirements.
• Participated in facilitating the project implementation with the production team.

Environment: AGILE SCRUM Methodology, ASP.net, C#, JAVA, OLAP, JavaScript, HTML, SOAP, WSDL, XML, JIRA, BPMN, SharePoint 2013, Oracle, SQL Server, MS Access, MS Excel and MS Project, Test Director.

Confidential, Buffalo, NY

Senior Business Analyst

Responsibilities:

• Performed requirements gathering from the stakeholders while adhering to SDLC industry best practices.
• Used MS Project to create the project plan, allocate budget, resources and set milestones.
• Coordinated efforts with SAP ERP team regarding SAP Master Data Tables with the Enterprise MDM Solution.
• Used MS Excel to create a field-to-field data map from source to stage and stage to target mapping indicating the source tables, data types, column names and transformations required.
• Prepare comparison of expense to budget reports for executives on demand and on weekly, monthly and quarterly basis
• Created relevant artifacts: Interface Design Document, Detailed Design Document, Supplemental Document and Solution Specification Document.
• Expert in generating and analyzing custom reports and dashboard for management and various business unit personnel to provide detail information on key performance indicators
• Coordinated data migration from old to new system during Teradata system capacity expansion
• Developing a formal strategy for driving the efficiency and effectiveness of the ITIL process in complex business environment.
• Generated the Business Objects reports involving complex queries, sub queries, Unions and Intersection.
• Defined security models with row level data security, role based security etc in Business Objects Universes
• Performed Gap analysis and conducted business modeling by reviewing the existing business artifacts.
• Utilized UML for process modeling and created Use Cases, Activity diagrams and Sequence diagrams using Rational Rose and MS Visio.
• Maintained project documents to be used for collaboration with developers, QA, project manager, etc. on SharePoint.
• Implemented Agile Scrum methodology of application development and set the velocity for each sprint cycle.
• Conducted daily Scrum meeting, planning meeting, review meeting, retrospect meeting and created the Product backlog.
• Provided data modeling and migration data and developed user interface mocks using Microsoft Visio.
• Collaborated with DBAs to perform data mapping using MS Excel and executed complex SQL queries to filter data from the MS SQL database.
• Used HP Quality Center for loading the test scripts and logging defects.
• Collaborated with the production team by facilitating the implementation of the application, prepared production certification scripts and performed production certification.

Environment: AGILE Scrum methodology, ASP.net, C#, JAVA, OLAP, JavaScript, HTML, SOAP, WSDL, XML, JIRA, HP-QC, BPMN, SharePoint 2010, Oracle, SQL Server, MS Access, MS Excel, MS Project, and Test Director.

Confidential, Sacramento, CA

Business Analyst

Responsibilities:

• Interacted with stakeholders and gathered requirements as per the business needs.
• Implemented RUP methodology for iterative and incremental development of the system.
• I was involved in the planning of the RUP iterations and documenting of the artifacts throughout the various phases of the development process.
• Conducted GAP analysis by understanding the AS-IS system and the TO-BE system requirements by having discussions with the SME’s.
• Configured Reports for custom objects and associated them to Dashboard.
• Analyzed and repaired the setups for the Release 12 Oracle E-Business Suite for Cost Accounting, Inventory and WIP, for EAM and future requirements.
• Compiled the Vision Document and composed detailed Use Case Specification Documents in RationalRequisitePro .
• Identify PeopleSoft queries for re-creation within Workday for continued support of legacy processes.
• Responsible for validation of Position/Job, Compensation, Organizational, and other data elements in Workday Tenants.
• Used UML to perform Use-Case analysis to capture the dynamic aspect of the application.
• Ensured the accuracy and consistency of the data during the data loading process.
• Developed State Diagrams, Activity diagrams and Class Diagrams in MS Visio using UML for various modules of the project.
• Document all data mapping and transformation processes in the Functional Design documents based on the business requirements
• Experienced in developing Data Mapping, Performance Tuning and Identifying Bottlenecks of sources, mappings, targets and sessions.
• Created Process Flow Charts, Business Requirements Documents, Functional Specification Documents.
• Performed Data Analysis and Data validation by writing SQL queries.
• Was involved in managing the Daily Standup meetings and also ensured that quality standards were enforced as per the build-release schedule.
• Created data trace map and data quality mapping documents.
• Consolidated data from SAP and Oracle ERP systems into a single report to analyze supplier spend data in different regions
• Analyzed and implemented new flowcharts which streamlined vendor management processes in the Oracle system
• Performed Data Profiling and Data Quality.
• Developed Test Plan and Test cases based on the Use cases and Functional specifications and also performed manual testing of the functionality of the application by inserting varying data on different test runs.
• Developed Flowchart and process diagram using Microsoft Visio.
• I was in regular contact with Business partners on the status of issues, action plans and timeframe for resolution throughout the development cycle.
• Contributed in reviewing and editing of the test scripts.

Environment: Windows, MS Office (MS Word, MS Excel, MS PowerPoint, MS Visio), MS Access, MS Project, RationalRose, Community Manager, BPML, SQL, ClearCase, Agile

Confidential, Houston, TX

Business Analyst

Responsibilities:

• Implementation and modification of project charter as per project and stake holder requirement.
• Gather requirement by conducting meetings and brainstorming sessions with senior management and technical resources.
• Analyze the system for the effectiveness of the ecommerce operations.
• Extensively working on the use case development followed by the correction cycle.
• Extracted the Business Requirements from the end users keeping in mind their need for the application and prepared Business Requirement Documents (BRD) using Enterprise Architect.
• Created Process Flow diagrams, Use Case Diagrams, Class Diagrams and Interaction Diagrams using Microsoft Visio .
• Worked in broad range of technologies, including business process tools such as Microsoft Project, MS Excel, MS Access, MS Visio, technical assessment tools, Data Warehousing concepts and web design and development.
• Design workflows and allocated permissions within SharePoint 2010
• Prepared Demo on SharePoint 2010 for various Business to get new approvals.
• Test and analyze stored procedures and triggers using Toad, and other database tools resulting in accurate and efficient data processing.
• Conducted weekly meeting between the System Users, business users, technical team and Vendor to update the progress in the project and address issues encountered.
• Reverse engineered Oracle Application for service requests
• Analyzed data tables utilizing PL/SQL to populated Oracle forms.
• Kept a record of all the issues that were identified, resolved, open, status and future enhancements. This issues list was critical in the successful completion of the project.
• Have been working on exploring different software systems and databases in order to design a possible solution and identifying vital data points/elements.
• Created data flow diagrams, data mapping from Source to stage and Stage to Target mapping documents indicating the source tables, columns, data types, transformations required and business rules to be applied.
• Created UML models and visual artifacts like DFD, Flowchart, and Process Flow diagrams.
• Participated in the Logical and Physical Design sessions and developed Design Documents.
• Worked with developers to make sure that they understood the Use Cases.
• Designed and implemented basic SQL queries for QA Testing and Report / Data Validation.
• Partnered with the Technical Areas in the research and resolution of System and User Acceptance Testing.
• Worked with Quality Control Teams to develop Test Plan and Test Cases.
• Worked as a liaison between the Business and Technology Department.

Environment: Agile, Incremental, Microsoft Office Suite (2007), MS-Project, ASPs, C#, HP QC, Visio, HTML, SOAP, UML, Windows, IE, SharePoint 2010, Rational Rose and Requisite