PROFESSIONAL SUMMARY:

• Overall 9 years of experience in Business analysis, requirements gathering and testing with a focus in LCR & 2052a, CCAR, Capital Market, Regulatory reporting (With understanding of Dodd frank) and Retail/Ecommerce and Banking and finance Industry.
• Good experience with Commercial Lending Domain with commercial Loan products.
• Experience with Loan origination, Appraisal and underwriting process.
• Good experience with commercial lending, Mortgages, Deposits, ILN, RCC (Retail credit card), CCC ( Corporate credit card).
• Good exposure in Middle Office, Back Office settlement and Transactional Data as well as understanding of Trade life Cycle, Trade settlement according to Dodd Frank Rules guideline.
• Hands on experience in Web Service requirements, including knowledge of WSDLs, schemas, and other web service standards.
• Good Experience in Regulatory compliance with LCR and 2052a.
• End to End knowledge on Medicaid modules like Claims Adjudication, Claims Pricing, Claims Payment, TPL.
• Experience in model risk management and associated regulatory requirements such as OCC SR 11 - 7 and Basel.
• Stakeholder analysis, management and communication by working with senior business sponsors and technical specialists.
• Acted as a liaison between the business and development teams for requirements.
• Good experience with Pre-trade workflow, Post-trade work flow, Data Mart.
• Experience with provider to consumer mappings and transformations.
• Complete understanding of the different integration points of Healthcare transactions.
• Good experience in ACH, cash management, Wire, payment hubs, and online banking platforms.
• Partnered with operations and PMO to create efficient cross-functional processes by eliminating non-value adding activities. Worked with executives and staff to develop culture of continuous improvement (business process improvement).
• Responsible, perform budgeting, forecasting, internal auditing and financial analyses. Work with minimal supervision, reporting to VP ofFinance& Accounting.
• In depth knowledge on different phases of Software Development Life Cycle (SDLC),Project Life Cycle (PLC) and Software Testing Life Cycle (STLC).
• Hands on experience working with derivatives from a full lifecycle perspective coupled with knowledge of various asset classes i.e. FX, Commodity, Equity, Rates.
• Good knowledge of Equities, Fixed income, Futures, and Order to cash derivatives (OTC).
• Hands on experience in FPML reporting.
• Expertise in writing Epics and user stories in JIRA using 'Agile' and 'Waterfall' methodology, root cause analysis, creating workflows and process mapping.
• Expertise in excellent client interaction and communication skills as well as experience working in complex, cross functional and geographically dispersed team environments.
• Complete understanding of the AS-IS and TO-BE business processes and experience in converting these requirements into technical specifications for preparing test plans.
• Facilitated and participated in Joint Application Development (JAD) sessions to gather the requirements and to resolve the revolving issues and to facilitate the coordination between the teams.
• Well versed in authoring Business Requirements Document (BRD), Functional Specification Document (FSD), Software Requirement Specifications (SRS), Use Case, Business case and Data mapping document.
• Conducted 'GAP Analysis' to analyze the variance between the system capabilities and business requirements. Managed meeting sessions with the SMEs to review business requirement.
• Expertise in Data Modeling, Data Analysis, Requirement Analysis and Business Modeling.
• Proficient in User Acceptance Testing (UAT), Functionality Testing, Unit testing, System Testing, Integration Testing and Regression Testing.
• Good understanding of the data warehousing concepts like Star schema, Snowflake Schema, conformed dimensions,dataarchitecture,datamodeling and data mapping.
• Worked with the Data Analyst to create data mappings in Functional requirements; Well versed with SQL/writing queries
• Highly collaborative team player with extensive customer relationship skills, also possess excellent facilitation and mentoring skills and ability to prioritize tasks according to business needs.
• Creative thinker and analytical problem-solver with demonstrated ability to multitask and deliver innovative projects from planning through execution under the pressure of fast-paced, time-sensitive environments.
• Self-directed to meet end-user requirements, cost, and quality objectives through timely development and execution of information system functions, computer operations, and programming systems.
• Good knowledge on Medicare, Medicaid, and commercial insurances in HIPAA, EDI- 278, CCF for interfaces and images to third party vendor applications.

TECHNICAL SKILLS:

Project Management Tools/Methodology: MS-Project, MS SharePoint, JIRA, Agile-Scrum, Waterfall-Scrum, WaterfallRequirement and Test Management Tools: MS Office, JIRA, HP ALM 11.5

Reporting Tools: SSRS, MS office Suite, Qlik Sense, Qlik View

Databases: Oracle, Microsoft SQL Server, TOAD - Data Analysis/Data Mappings

Office Tools: MS Word, MS Excel, MS PowerPoint, MS SharePoint 2013, MS Project, MS Visio

Analytics Tools: MS Excel, MS Access, Pivot Tables, V-Look Ups, Tableau

ETL and BI Tools: MSBI

Languages: HTML, XML, C, PL/SQL, SQL, Unix

Data Analytics: HDFS, Pig, Hive, SQOOP, Mini Tab

Business Analysis & Planning: Work Flow analysis, UML & Use Cases

Languages/Framework: VB.Net/C#.Net/ASP, VBA, SQL

PROFESSIONAL EXPERIENCE:

Confidential, NJ

Sr. Business Analyst

Responsibilities:

• Conducting user interviews, gathering requirements, analyzing the requirements.
• Facilitated JAD sessions with SMEs’, Business Change managers (BCM) managers to understand the business process; gather Business Requirements and identified changes for the applications.
• Interacted with stakeholders and gathered requirements as per thebusinessneeds.
• Conducted GAP analysis byunderstanding the AS-IS and TO-BE system requirements by having discussions with BCM’s and Directors.
• Served as liaison between the technical team, architect and non-technical stakeholders, earning their confidence with reliable follow-through.
• Good domain knowledge on LCR and 2052a with respect to HQLA (High quality liquidity asset).
• Experienced within regulatory space (LCR&2052a, CCAR, Basel).
• Change request on commercial lending line of business implemented.
• Understand the change of commercial loan products, changed the impacted work flow for loan origination, Appraisal and underwriting process, with having good domain expertise on commercial lending process.
• Worked on Crunch time change request, where analyzed the impacted sources systems and target audience and business persons, Scheduled the meeting to discuss workflow, functional specific doc for respective changes and got the sign off’s with no hazel, and given the walk thru to Development and QA team to make requirement clear.
• Performed impact analysis, change management, Workflow management.
• Performed smoke testing to provide BA certified code to the business before each month end run.
• Created UML Diagrams, USE cases and other artifacts to document the clear requirement.
• Written uses cases, Arranged flow diagrams & Swim lanes.
• CR’s (Change requests) implemented for direct lending/ commercial lending/Fix Income/liquid credit/Commercial loans and Defined and manage contract migration status reporting.
• Performed UAT, Helped business to get UAT done in targeted time.
• Worked with the data analysts and DB team for data mappings and data discrepancies. Created queries in Access.
• Identified all data sources by working directly with different IT Data teams and helped create targets and assisted testing team.

Environment: Water fall Methodology, UAT, TOAD, EDI, ALM, Visio, SharePoint, MS Access, SQL Server, MS Office, HP ALM, Mock-up screens.

Confidential, Charlotte, NC

Sr. Business Systems Analyst

Responsibilities:

• Enacted as liaison between business and IT.
• Worked on Change requests, while performing change management and its impact.
• Good experience in stake holder analysis and make good relation with them.
• Coordinated UAT and other testing activities with having tool (ALM) experience.
• Good experience in negotiation with business and IT, Good experience in defect management and manual testing.
• Created artifacts i.e. BRD, FRD, Project Charter.
• Designed and review of various documents including the Functional Specification Document (FSD), Software Requirement Specifications (SRS), Use Case Specifications, Data mapping document and verifying Requirement Traceability Matrix (RTM).
• Conducted the JAD (Joint application development) session and the solution out of it.
• Maintained the share-point portal for all project related documents i.e. Sign off email, FSD’s, CR’s ( Change requests and Production change requests).
• Scheduled workshops to discuss proposed change and its impact and modified workflows and FSD’s afterwards followed up respective business people to get sign off’s.
• Designed and developed the Conceptual, logical and PhysicalDataModels in par with the requirements gathered.
• Facilitated the scrum events and managed Agile Lifecycle in JIRA from planning to sprint deployment. Tracked and communicated team velocity and sprint/release progress. Assisted in managing the Product Backlog, Sprint Backlog, Sprint Burn down and Release burn down charts.
• Reviewed and assisted the team in functional testing of the application prior to demo in the sprint review meeting.
• Removed internal and external impediments that hinder team’s productivity. Worked with the team in the grooming and prioritization of product backlog using technique such as planning poker.
• Developed test scenarios/scripts, test plans, prepared user acceptance test cases (UAT), UAT issue log for tracking the defects in JIRA and collaborated with system users to conduct UAT.
• Preparing End of schedule report and carrying out minutes of meeting with the team (Both offshore and onsite).

Environment: Agile Methodology, UAT, TOAD, EDI, JIRA 6.3.3, Visio, SharePoint, DataMart, MS Access, SQL Server, MS Office, HP ALM, Mock-up screens.

Confidential, Deerfield IL

Agile Business Analyst

Responsibilities:

• Interacted with stakeholders,SystemsArchitect, UI/Content Management Team, Developers, SME’s and facilitated JAD sessions to understand the business process, gather Business Requirements for the data-warehouse as well as business-intelligence reports to be used by the management.
• Health care claims process artifacts created, written user stories on claims, Modified Epics.
• Worked as Product owner to elaborate the requirements to SME’s and other Business users.
• Worked on ICD 9 to 10 conversions and GEMS Techniques.
• Translatedfinancerequirements into functional specifications (identify any gaps, communicate & remediate)
• Helped Marketing and campaigning team to perform the functions what stake holders expected in business system.
• Performed Impact analysis for any changes in the requirements, Facts and dimensions.
• Interacted with the Stakeholders, Business Users defined & finalized Business Requirements.
• Performed Requirement Analysis generated Document of Understanding and project deliverables.
• Coordinated with Management, Business Areas and Application Owners and designed Functional
• Specifications in accordance with the scope of the project.
• Coordinated and managed daily Agile meetings and addressed end to end issues and resolutions daily.
• Identified the current Business Process, defined Use Cases from the requirements, created Sequence
• Diagrams using tools like MS-VISIO and developed a revised Business Process Model.
• Managed and led a team of 4 people including development, and testing resources.
• Actively involved in prioritizing requirements (vs.) deliverables throughout the SDLC in association with the Business Partners.
• Created reminders (internal and external to project) and task alerts, to ensure that every one is aware of the
• Upcoming changes in the Infrastructure and ensured that the Infrastructure is Silent.
• Conducted JAD sessions to finalize the Billing system design, scoping of functionality to be implemented per
• Release and design changes needed in Middleware services for Billing and Retail systems.
• Implemented Process improvements for Order Processing in billing and Middleware systems.
• Defined a solution and included case types, documents and other tasks using IBM Case Manager
• Worked on Data Analysis to identify and enhance the Cycle, Time& Cost metrics associated to the issues of concern.
• Performed detailed data mapping from Legacy to the new web-based integrated system.
• Executed SQL/join queries to validate the data for to-be processes.
• Provided deliverables quality assurance, management support for requirements and impact analysis for the Unified Billing Program.
• Negotiated and managed multiple priorities, project plans, time frames and trade-offs, ensuring the Technical team understood the expected results of the projects.
• Served as a point of contact to handle and share requirements between Business Partners, Development Team, Testing Team, Design Team and Management.
• Communicate any further enhancements to the Technical Team based on the BP’s reviews and feedback.
• Created Exceptions and Dependencies between applications that were delayed due to incompatibility issues.
• Developed test scenarios/scripts, test plans, prepared user acceptance test cases (UAT), UAT issue log for tracking the defects in JIRA and collaborated with system users to conduct UAT.

Environment: .Net, Microsoft Office (Excel Word, PowerPoint, Project), MS-Project, MS Visio 2010SharePoint 2010, JIRA, SRSS, JIRA 6.3.3, Visio, SharePoint, HP ALM, Mock-up screens.

Confidential

Business Analyst Regulatory reporting

Responsibilities:

• Conducted and facilitated various elicitation sessions in order to extract the requirements and expectations from the stakeholders.
• Created the Business Requirement document and the software requirement specification document and facilitated the architects to create the detailed design document.
• Worked as part of team to handle FPML XML messages issues and resolve problem.
• Analyzed current OTC Derivatives operations processes, identify gaps in workflows, research system defects and inefficiencies, recommend and create new solutions to fill these gaps by leveraging expert derivatives business knowledge.
• Established customer expectations of project scope, deliverables, procedures for project communications and delegation of tasks for team members.
• Documented requirements for regulations i.e. Dodd Frank, CFTC, Canadian regulations, ESMA/EMIR, MIFID and HKMA.
• Communicated with Business users and provided clarity on requirements to Tech Team.
• Attended sessions and discussed, negotiated and communicated regulatory requirements with business teams from FO/MO and Back Office.
• Supervised 15+ client accounts including banks, hedge funds, asset management institutions, and insurance firms.
• Directly responsible for the marketing, pricing and auctioning of Corporate, CD, Agency, High-Yield, Muni, and MBS to institutional investors.
• Strengthened Municipal bond business by forging relationships between private clients and Dallas based Municipal trading desk.
• Printed 500+ transactions with 20+ counterparts in excess of $100 million notional for fiscal year 2016.
• Ensured the timely entry of day trades as well as reconciled account balances at days end.
• Provided clarity to QA and Production Support teams.
• Had discussions and work with GTR teams to troubleshoot issues during UAT to provide clarity across cross functional teams
• Ability to understand business problems and articulate a corresponding solution
• Asset Classes: Interest Rate, Credit, FX, Equities, Commodities, Fixed Income, FCM, etc.
• GTRs: DTCC, ICE, MIFID ARM and APA, extensively involved developing User interface prototypes and got the approval from the Business users.
• Expertise in creating test cases and tracing requirements throughout the development process and verifying their adherence to Requirement Traceability Matrix (RTM).
• Interacted with stakeholders,SystemsArchitect, UI/Content Management Team, Developers, SME and diverse group of personnel and involved in JAD sessions to understand the business process, gather Business Requirements and identify changes for the applications and implemented the systems.
• Worked in cross functional teams on building business use cases, understanding the process flow and gathering Signoffs from Businesses.
• Served as liaison between the technical team, architect and non-technical stakeholders, earning their confidence with reliable follow-through.
• Conducted GAP Analysis to understand limitations of the existing system and designed future system, modeled the AS-IS and TO-BE business process workflow.
• Design and review of various documents including the Functional Specification Document (FSD), Software Requirement Specifications (SRS), Use Case Specifications, Data mapping document and verifying Requirement Traceability Matrix (RTM).
• Invented performance improvement tools which led to reduced technical debt in existing and newly developed systems.Was in regularcontact withBusinesspartners on the Prioritization of issues, pain points, action plans and timeframefor resolution throughout the development cycle maintaining customer satisfaction.

Environment: Waterfall Methodology, Prototyping, JAVA, HTML, Mockups, MS Visio, SOAP, XML, SQL Server 2005, Ab Initio, HP Quality Center

Confidential

Business Analyst

Responsibilities:

• Interviewed Business Users to gather Requirements and analyzed the feasibility of their needs by coordinating with the project manager and technical lead.
• Collaborated on creation of documents such as the Vision, business requirements (BR) and business systems design (BSD) documents.
• Prepared Functional Specification Documentation (FSD) and communicated the same to the stakeholders.
• Analyze Risks, documented Risk Logs and created Requirement Traceability Matrix (RTM) as a roadmap for the 'TO BE” system
• Developed complex queries, stored procedures, UDFs in support of the ETL processes, front end applications and reports.
• Wrote SQL queries to retrieve the data and for data manipulation and integration, created complex SQL queries, such as joins, pivot tables, cubes and sub queries.
• Developed and optimizing SQL queries using SQL Server profiler, indexed views and indexes.
• Assisted in Data modeling, Data Mapping, Data Mining, DataStaging and Data Integration process. Helped in performing ETL from current OLTP to the target data warehouse.
• Working closely with users for data mining and provide critical data for banks day to day and monthly use
• Designed Test Plans and Test Cases for User Acceptance testing (UAT), Regression, and Black Box and White box testing with the help of QA teams.
• Involved in application enhancement in terms of Improved security, Error logging, Exception Handling and Code Reuse.
• Designed and developed Use Cases, Activity Diagrams, Business case, and Sequence Diagrams, using UML and Visio according to business rules.
• Proficient in System Test Plans, Integrated Test Plans (ITP), Extensive experience in User Acceptance Testing (UAT).

Environment: Waterfall, Methodology, XHTML, CSS & JavaScript, HP Quality Center, Java/J2EE, JSP, Apache TOMCAT, Web Services, MySQL, Eclipse, Unix, WebLogic Application Server, Spring, Hibernate.

Confidential

Jr. Business Analyst/ Project coordinator

Responsibilities:

• Performed document analysis to derive business rules from legacy system and validated them with stakeholders for consistency and completeness.
• Conducted GAP Analysis to understand limitations of the existing system and contributed to design of future system; assisted in modeling the AS-IS and TO-BE business workflow.
• Worked with business and technical SME’s to develop thorough understanding of Applications, Systems, relational database, Business Methods and Strategies.
• Generated key statistics e.g. Defect reporting by application, performance usage, tasks estimating as well as time and task reporting.
• Managed SQL Server environments, by configuring a facet in one instance of SQL Server, copy the state of the facet to a file, and then import that file into another instance of SQL Server as a policy.
• Involved in performance tuning using indexing (Clustered Index, Non Clustered Index) tables.
• Assisted in Data modelling, Data Mapping, Data Mining Data Staging and Data Integration process. Helped in performing ETL from current OLTP to the target data warehouse.
• Designed Test Plans and Test Cases for User Acceptance testing (UAT), Regression, and Black Box and white box testing with the help of QA teams.
• Encouraged and implemented process improvements techniques and ensure that there was room for change. Introduced a checklist during story time to ask the right questions while reviewing each story.
• Highly proficient in writing User stories, creating Use Cases, Use case diagrams, Workflow Diagrams, Sequence Diagrams, and Class Diagrams etc. Extensively used Rational Rose and MS Visio for UML.
• Constructed Requirements Traceability Matrix to determine the source of the requirement, ensure all requirements are met and locate affected system components when there is a requirements change. Maintained the traceability matrix until business requirements were signed off.
• Preparing End of schedule report and carrying out minutes of meeting with the team. (Both offshore and onsite).

Environment: Waterfall Methodology, .NET3.0, ASP.NET, Ms Office, Visual Studio 2005/2008, LINQ, HTML, CSS, SQL Server 2005/2008, C#. Net, Team Foundation Server (TFS), Ajax Control Toolkit, Visual Source Safe.