SUMMARY

• Over 8+ years of experience as a Business Analyst in credit industry, commercial banking, and investments.
• Expertise at noledge of Capital Markets, Initial Public Offering (IPO), Fixed Income Securities, Equity Securities, Derivatives.
• Experience with investment banking regulatory/compliance reporting regulations like Basel II and III Accord.
• Provide domain expertise on lending (retail and commercial) to some key technology initiatives at Bank.
• Engage with Business & write requirements for technology projects.
• Experience in conducting Gap analysis, User Acceptance Testing (UAT), SWOT analysis, Cost benefit analysis and ROI analysis.
• Deep technical background and solid working noledge of SQL Server Data warehouse systems.
• Experience with COTS (Commercial off - the-shelf) and ERP (Enterprise Resource Planning) that are PeopleSoft and Microsoft Dynamics.
• In-depth noledge of Rational Unified Process (RUP) risk engineering; data modeling and mapping; and design using UML, Rational Rose, Visio and other related tools.
• Demonstrated ability to work actively in different phases of SDLC, Agile/Scrum in teams, fostered cooperation and collaboration among individuals in the work unit and halped team resolve conflicts constructively.
• Extensive experience in Banking Industry group including Credit, Risk, Investment and Operational Risk Banking that involve noledge in CCAR, Basel II, Basel III, Dodd Frank and Charles River.
• Worked with SME's to collect Business process requirements, documented them in Business Requirement Document (BRD) and performed Business Process Re-engineering, product support.
• Proficient in creating BRD (Business Requirement Document), TRD (Technical Requirement Document), FSD (Functional Specification Document) and UAT Documents, Use Case Narrative &Use Case Diagram.
• Expert noledge in with various capital market instruments and securities including Equities, Fixed Income Instruments, Risk Management (Credit and Market Risk).
• Expert at Risk Management by Risk Identification, Impact Assessment, Prioritization Analysis, Risk Tracking and Mitigation with monitoring of whole.
• Experience in various modules of AML such as KYC, Entity Resolution, Compliance Reporting, and Transaction Monitoring.
• Lead JAD sessions with corporate tax department and all source system SME's and prepared FRS for FATCA reporting project.
• Comprehensive understanding and experience of SDLC and project life cycle methodologies such as Water fall, Agile, Rapid Application Development (RAD), and Rational Unified Process (RUP).
• Strong experience in testing using HP Quality Center.
• Experience in Automation tools like Rational Requisite Pro and Quick TestPro.
• Expertise in Database Administration of Test Environment Databases, Data Pools and identifying performance issues due to inefficient Database Administration.
• Solid Experience in developing Scope/Vision Documentation and Project Plan.
• Excellent writing skills in generating, Project Charter, Project Plan, Business Requirements documents, Use Case Specifications Test Plan, Credit Risk Management Plan Liquidity risk assessment, and Publishing Regular Reports with status and metrics.
• Expertise in Database Querying and writing T-SQL Queries
• Well experienced in Excel functions such as VLOOKUP and Pivot Tables.

TECHNICAL SKILLS

Project Methodologies / Frameworks: SDLC, Waterfall, Agile-Scrum, Scrum-Waterfall Hybrid.

Business Modeling Tools: MS Visio, MockUps, Wireframes (Balsamiq), Lucid-chart, draw.io

Project Management: Rally, JIRA, TFS, HP ALM, Confluence

Operating Systems: Windows, Linux, Unix

Application/Web Servers: Oracle Web-Logic, SAP Net-Weaver, Apache Tomcat, Red Hat JBoss

Database & Tools: Oracle 9i, 10g, 11g, MS SQL Server 2000, MS Access, Oracle SQL Developer, Toad, Win-SCP, Putty.

Programming Languages: C, C++, Java, Java Script, SQL, XML, JSON, R, SAS, HTML

Data Warehousing & Tools: Data Modeling, Data Marts, OLTP, OLAP, Data Mining, Slicing/Dicing, Roll Up/Drill Down, Pivot & Informatica ETL, SAP BODS, SAP Business Objects Lumira

Reporting/BI: Tableau, IBM Cognos, Microsoft Power BI, QlikView

Defect Tracking / Testing Tools: HP QTP, UFT, ALM, Load-Runner, Junit, Cucumber, Soap-UI, Postman Rest Client, Swagger, JIRA.

PROFESSIONAL EXPERIENCE

Confidential, Cleveland, Ohio

Business Analyst

Responsibilities:

• Conducted detailed assessments of operational workflows and internal procedures to improve efficiency and efficacy
• Evaluated approaches for integration of cloud applications into other enterprise systems and applications
• Written user stories that are precise and testable
• Interviewed several candidates for Business Analyst positions, part of resource management and resource allocations for each phase and iteration(s) of the project
• Created complex SQL queries. Applied extensive understanding of database tables, relations, data types and values
• Created visually impactful dashboards in Excel and Tableau for data reporting by using pivot tables and VLOOKUP. Extracted, interpreted and analyzed data to identify key metrics and transform raw data into meaningful, actionable information.
• Performed GAP and Risk analysis of existing system and evaluated benefits of new system
• Determined user/business/functional requirements. Created vision, scope, and use case documents; business process models, use case diagrams, activity diagrams, and state chart diagrams using MS Visio
• Assisted in process modeling, conducted and participated in JAD sessions with system users
• Gatheird requirements from users across the enterprise, liaised with the development team and completed the implementation of Core Analytics dashboard within 12 months
• Participated in requirements prioritization sessions with high-end stakeholders while using MOSCOW technique
• Provided user interface design for Guided recommendation engine of e-Enrollment module
• Conducted user research through interviews and usability testing before and after the re-design
• Responsible for understanding business logic, designing requirements, assisting other business analysts in generating Functional Requirement specifications (FRS) and User Requirements Specifications (URS)
• Created Requirements Traceability Matrix to keep the stakeholders informed of the progress of the project
• Conducted user acceptance testing and data validation of enrollment systems used to present benefit information
• Conducted Gap analysis to assess the e-Enrollment module requirements and accommodate those for customization
• Provided system documentation, researched system requirements, participated in system testing and verification for HIPAA implementation
• Performed Vulnerability Analysis and Deep Dive analysis of the enrollment system to identify vulnerable areas and to strengtan them by offering solutions
• Created User stories in Rally, uploaded the test cases, necessary documents & approvals for each sprint along with next sprint's planning& grooming.
• Responsible for conducting Knowledge Transfer Sessions among onsite/offshore users for technical support and enhancements of the application & also mentored new members to speed with various aspects of the project.
• Documented/updated various artifacts like test strategy, user manuals, SOP (Standard Operating Procedure), traceability matrix & Impact analysis documents, operations manual.
• Trained employees on how to use the enrollment system module and its subsequent ones
• Provided post implementation support and performed root cause analysis and fixed post implementation issues

Environment: Microsoft SharePoint, Jira, Rally, SQL Server, MS Office, MS excel, Tableau, MS Visio, MS-Project, Agile Methodology.

Confidential, California

Business Analyst

Responsibilities:

• Perused and finalized the readiness of Request for Proposals (RPF) and assisted the Project Management Team in creating Response Documentation, Project Charters.
• Facilitated JAD sessions as Moderator and conducted interviews, focus groups with various Subject Matter Experts (SMEs) and stakeholders, process reviews and policy & procedure reviews to elicit requirements.
• Proactively participated in LAND SCAPE Analysis to identify the GAP between the current and expected system.
• Prepared Business Requirement Document (BRD/HLD) and assisted preparation of System Requirement Specification (SRS). Further Analyzed modified and validated requirement artifacts.
• Used Reverse-Engineering techniques to be identified the missing sources and attributes.
• Created Business Use Cases and built Use Case Diagram and Activity Diagram using Smart Draw.
• Collaborated with the Data Architects in Designing & Modeling the Targeted Data Bases.
• Highly involved in Dimensional Analysis, Meta Data Analysis, and System Catalog Analysis and created Data Dictionaries.
• Assisted Data modeling process by creating conceptual and logical ER diagrams and designing database schemas to halp development of an accurate Data Warehouse Structure.
• Assisted in Source Data Analysis and Extraction Strategy using SSIS as an extraction and integration platform.
• Created Data Dictionaries and Data Mapping Documents (S2T Artifacts) with all the required transformation logics.
• Worked with QA team to design and develop Test Plan and Test Cases to perform User Acceptance Testing (UAT), Functional Testing and Regression Testing.
• Assisted in Strategically Planning for Data Integrity, Data quality and adding Data Verification and Validity to maintain accuracy and effectiveness of data.
• Involved with Business Intelligence (BI) team creating report catalogs and required parameters as per the requirements.
• Query Multiple Data bases Postgre SQL, MS SQL with SQL queries and documents the analysis reports.
• Collaborated with in Test Planning, Test Preparation, Test Execution and Issue Resolution and Report Generation to assure that all aspects of a Project are in Compliance with the Business Requirements
• Experienced in Logging and tracking the defects using HP Quality Center. Created an error repository and managed the testing process with the QA team
• Worked with BI team in creating the Training Manuals with Standard Operational Procedure. Helped the end users getting accustomed to the system by live demonstrations and system tutorials.

Environment: Waterfall, MS Office suit, SSIS SSAS SSRS, MS VISIO, MS Project, MS TFS, DWH Architecture, SharePoint, Erwin 9.5, MS SQL, POSTGRE SQL, Main frames.

Confidential, Norcross, Georgia

Business Analyst

Responsibilities:

• Involved in Requirement analysis for the Enhancements proposed and in preparing Business requirements, Understanding and Functional requirements documents
• Provided a prompt, efficient and personalized service to clients by interacting with them
• Involved in supporting the application
• Facilitated Disaster Recovery Testing of the application and documented the information for future reference
• Prime responsibility during Month end, to ensure all deliverables are sent and to maintain the SLA
• Participated in Code Reviews, System Testing and UAT followed by production verification, post production testing and support
• Created change requests, reviewed them with the team and published the Change Request Document
• Resolved issues related to financial processing of claims daily.
• Performed Risk Analysis, Prioritization of risks and its impact to project
• Documented and maintained Requirement Traceability Matrix (RTM) to ensure proper requirements management
• Documented and managed Product and Sprint backlogs
• Participated in Daily Agile Scrum, Biweekly Sprint Planning and Retrospective Sessions and update the team on work status
• Created Test cases and test scripts which are aligned with requirements
• Performed root cause analysis to determine solution for pain points using Fishbone analysis technique
• Performed stakeholder analysis to perform identify team members and build a communication plan to interface with different user groups
• Identified and defined pain points, business need, problem areas and opportunities.

Environment: MS office (2013, 2016), MS Visio (2013, 2016), Rationale Requisite pro, JIRA

Confidential, Fairfield, California

Business Analyst

Responsibilities:

• Lead the definition and documentation of business and functional requirements.
• Conducted user/stakeholder interviews to execute the successful planning sessions.
• Provided best practice recommendations in the areas of Order Management System and CRM.
• Created Activity Diagrams & Sequence Diagrams using UML methodologies for easy understanding.
• Created requirement documentation, reviewed with user representatives, restructured the documents with the recommended priorities and obtained user signoff to start the project implementation.
• Analyzed present needs/recommendations and aided in preparing and presenting Return on Investments, business case proposals and Cost Benefit Analysis.
• Worked in conjunction with the team in assigning tasks with understanding of complexity & priority of the task.
• Assisted the Product Owner in converting requirements from BRD into User Stories by conducting User Story sessions and prioritizing Product Backlog Items (PBI) using various techniques.
• Implemented and supported Order Management System by defining and validating requirements relating to OMS and developing process flows to define functionality across the systems for proper EBPP implementation.
• As a Scrum Master, implemented Scrum Practices while handling team and facilitated Scrum Ceremonies like Daily Scrum, Sprint Planning Meeting, Sprint Review Meeting and Sprint Retrospective meeting.
• Tracked team’s velocity and progress during a Sprint using Sprint burn down & Release burn down chart.
• Helped the team in estimating the complexity of the user stories facilitating Planning Poker and Triangulation techniques and guided the team on adhering to the best practices of estimation.
• Assisted Business Intelligence (BI) team in creating dashboards using Tableau as required by the end users.
• The effort involved developing extensive SQL Queries and Procedures, utilized to perform database integrity testing, ensuring various data table entries, data validity, and data integrity.
• Performed logical data modeling and created ER diagrams and used SQL queries for managing database.
• Prepared Requirement Traceability Matrix (RTM) report to foresee the requirements associated with each use case within test plan ensure that every Business requirement is adhered to achieve the expected performance.
• Involved with the Software Quality Assurance (SQA) Team to develop Test plans, execution of Test Cases and logged the defects for failed test cases using HP Quality Center.
• Assisted in deletion of defects and bugs, to meet requirements and deadlines for successful execution of project
• Played a key role in the planning and performing User Accepted Testing (UAT) along with business users

Environment: Scrum Methodology, HP ALM, Tableau 6.1.6, Microsoft SQL Server 2012, Mock-Up Screens, GAP analysis, UML, UAT Testing, MS Office Visio, PowerPoint, Word, Excel, Project .

Confidential

Business Consultant

Responsibilities:

• Analyzed and documented requirements gatheird and authored Business Requirement Document (BRD), System Requirement Specification (SRS) for application configuration and integration.
• Assisted Project Manager in building Work Breakdown Structure to streamline the activities and demonstrate a strong projectile of integration opportunity.
• Analyzed present needs/recommendations and aided in preparing and presenting Return on Investments, business case proposals and Cost Benefit Analysis.
• Assisted Risk Analysts and SMEs in performing feasibility, impact and risk analysis of the stipulated integration and prepared corresponding artifacts such as risk register, risk management plan, feasibility report etc.
• Facilitated and conducted Interviews and Document Analysis with the business owners and functional analysts of every department making use of existing SAP ERP.
• Assisted the Lead Architect in building logical architecture of integration along with data flow diagrams.
• Analyzed source database, identified cardinalities and Created conceptual, logical data diagrams.
• Prepared a data requirement template by performing a detailed analysis of existing legacy systems such as SAPERP6.0 and SAPARIBA14s to assist functional analysts to perform integration through SAP Net-Weaver and developers in PL/SQL coding.
• Gatheird requirements for SOAP web services and RFC APIs, which were used for the integration through SAP Net-Weaver Process Integrator as a middleware in Service Oriented Architecture.
• Documented Web APIs (JSON documentation & XML documentation) using Swagger, IO docs for JSON & XNSDOC for XML to assist developers in their development.
• Elicited requirements and assisted database administration team in preparing data requirements and data mapping artifacts to map the data between SAPBODS (ETL Toolkit) and Oracle11gmasterdatabase through BAPIs and IDOCs.
• Worked with ETL team in data transformations and visualizations in SAPLUMIRA.
• Co-ordinate unit testing, system testing, interface and integration testing and UAT in conjunction with QA team.

Environment: Waterfall Methodology, Oracle database 11g, SAP ERP 6.0, SAP ARIBA 14s, SAP Net-Weaver, MS Visio, SAP BODS, SAP Lumira, System Integration & UAT Testing.

Confidential

System Analyst

Responsibilities:

• Understood state of art processes by interacting with stakeholders and documents analysis and performed GAP analysis to assist Project Manager in planning the transition.
• Facilitated JAD sessions as Moderator and conducted interviews with various Subject Matter Experts (SMEs) and stakeholders, process reviews and policy & procedure reviews to elicit requirements.
• Prepared and validated Business Requirement Document (BRD) and assisted preparation of System Requirement Specification (SRS).
• Created Use Cases and built Use Case Diagram and Activity Diagram using MS Visio.
• Managed and tracked requirements using HP ALM through Application Life-Cycle.
• Worked on data analytics platform using SAS E-Miner, Weka and Rapid Miner to build Decision Tree, Neural Networks for analysis and Regression models to perform statistical predictions on market trends.
• Assisted Data modeling process by creating conceptual and logical ER diagrams using Vertabelo tool and designing database schemas to halp development of an accurate Data Warehouse Structure.
• Integrated various OLTP to the OLAP by using Informatica as an ETL tool and used Tableau as reporting tool.
• Assisted in increasing Data Integrity by performing Data Normalization and adding Data Profiling.
• Generated periodic data reports for reconciliation, reporting using Excel & SQL/PLSQL Joins, views, procedures.
• Involved in implementation by assisting in the preparation of training module. Helped the end users getting accustomed to the system by live demonstrations and system tutorials.
• Sound ‘Change Management’ experience handling change requests at different phases of project by triaging the request, analyzing the impact of change on overall project life cycle and documenting appropriate Change Request Form artifacts.
• Worked with QA team to design and develop Test Plan and Test Cases to perform User Acceptance Testing (UAT), Functional Testing and Regression Testing.

Environment: Waterfall Methodology, MS Office (MS Word, MS Excel, MS PowerPoint), Tableau, Informatica, SAS E-Miner, Weka and Rapid Miner, MS Visio, MS Projects, HP ALM, Wireframes, Mock-Up Screens, MS SQL Server, SharePoint, GAP Analysis, UML, UAT testing.