SUMMARY

• Business Analyst with experience of about 7+ years functioning primarily in Confidential domains using several Software Development Life Cycle (SDLC) methodologies ranging from traditional Waterfall, Scrum - Waterfall Hybrid to modern Agile Frameworks like Scrum, RUP.
• Highly experienced in creating the requirements artifacts such asBusiness Requirement Document(BRD), System Requirements specification (SRS), Functional Requirements Specifications (FRS), Technical Requirements Document (TRD) and Requirements Traceability Matrix (RTM) and validating these requirements against the business case.
• Excellent communication skills necessary to elicit requirements through Brainstorming, Job shadowing, surveys, interviews, focus groups, document analysis, interface analysis and JAD sessionswith Business Owners, Business Users, Subject Matter Experts (SMEs), Technical Architects, Testers, Developers and other stakeholders.
• Experience in As-IsandTo-Be process models by conducting Gap Analysis, Impact Analysis,SWOT Analysis, Cost-Benefit Analysis, Risk Analysis, Root Cause Analysis, Feasibility Study and Return on Investment.
• Good Knowledge onElicitation, analyzing and prioritization of each sprint in product backlogaccording to end user perspective & designUser Storieswith design perspective.
• Profound knowledge of various Confidential fundamentals like capital markets, equities, financial databases, general ledger, accounts payable/receivable, risk management, derivatives contracts etc.
• Highly experience in record for deliveringBanking & Finance Project for Retail & Commercial Banking, Digital Banking(Online Account opening Retail) & Risk & Regulatory(Liquidity coverage ratio, CCAR ), Knowledge inBasel I, II, IIIwith primarily Agile framework Implementation.
• Detail understanding and domain expertise in regulatory reporting requirements including Regulatory Reports withFR2420, FR2314, FRY9 LP, and FRY 9C.
• Strong exposure in store and process credit card / Debit Card accounts and process transactions (Visa, MasterCard, Confidential, Euro pay, private label transactions), Strong domain knowledge in application catering to banking/Credit cards. Familiar with the full life cycle of credit cards applications for different banking systems.
• Good knowledge of Case Management Applications (Actimize) and Strong product knowledge on financial instruments and payment/Treasury products Understanding of AML, KYC process, and Trade Life Cycle Working knowledge of AML/Financial Data.
• Performed Payroll simulation for different payroll areas and Performed Payroll.
• Process Knowledge of AR/AP/GL, Credit management, fixed income analysis, Risk management, banking basics (Unsecured Loans) Personal Loans Operations.
• Acute understanding of concepts related to Consumer/Business Credit Cards and Consumer loans.
• Extensive knowledge and working experience of financial accounting, SOX, Dodd Frank Act, US GAAP, CCAR, Bank Secrecy Act (BSA), and PATRIOTS Act.
• Hands on experience in assisting the team to create SQL Queries, Stored Procedures, Triggers, Views, Indexes in SQL Server with a strong understanding of data & analytics.
• Experience with ETL Informatica Power Center and other ETL tools such as data stage and creating Database objects (Tables, Views, Stored Procedures, and Triggers etc.).
• Expert level skills in MS Office productsMS Word, MS Excel, MS PowerPoint, MS FrontPage, MS Excel. Also proficient withMS Project.
• Experience in assisting Analytics Project, involved in Data analysis, design Dashboard & Reports as Functional & Technical design documentand assist Technical team for any Business requirement clarification.
• Good knowledge ofData warehousing, BI Tool (Tableau), Data Visualization, Analytical tool SPSS, Google Analytics.
• Experience with issue creation and resolution usingJIRA,facilitating the team and creating Scrum artifacts likeProduct Backlogand helped define theUser Acceptance Criteria, (Minimum Viable Product) and (Minimum releasable features) to assist with an overall release and feature plan for the products.
• Experience in conducting UAT, facilitated discussion between business team and QA team to determine the test requirements and pass/fail criteria; document and report user feedbacks to management team.
• Experience in preparing and reviewingTest Cases, Test Plans, and Test Scenarios; facilitatedUser Acceptance Testing (UAT), Regression Testing, and Functional Testing;assisted inSmoke and Sanity testing.
• Demonstrated ability to work well with a wide variety of people at various levels and collaboration among individuals in the work unit, help team resolve conflicts constructively and ability and willingness to communicate when help is needed. A Self-starter with a positive attitude, willingness to learn new concepts and acceptance of challenges.

TECHNICAL SKILLS

Business Modeling Tools: MS-Visio,RationalRose,UML

Databases: MS Access,MS SQL, Teradata

OperatingSystems: Windows,UNIX,Mac

BusinessManagementTools: Monday.com,Jira,MS-Project

SDLCmethodologies: Waterfall,Agile,RUP,GAP

MicrosoftTools: MS-Office,Word,Excel,PowerPoint

Data Visualization Software: MicrosoftPower BI

Skill SetsUser: AcceptanceTesting,BusinessProcessAnalysis

PROFESSIONAL EXPERIENCE

Confidential, San Francisco, CA

Sr Business Analyst

Responsibilities:

• Implemented and managed the formal SDLC implementation using the Agile Methodologies depending on the project.
• Elicited requirements involving vast set of interactions with various stakeholders including hedge fund managers, financial strategists and financial analysts using JAD Sessions, Structured Interviews and Business Rules Analysis.
• Created the user requirement specifications and helped convert them to functional requirements and managed them in Rational Requisite Pro with proper traceability to the system requirement specifications (SRS) and also created the business vision document and glossary.
• Analyzed feasibility of business requirements and defined scope, found out dependencies by interacting with Management Business Analysts, other Subject Matter Experts, Product Owner, Project Manager and Technical Lead.
• Performed a high-levelGap Analysisbetween the existing platforms against the business requirements.
• Worked closely with product owner in Prioritization of User Story in Product backlog & Refining the user story in Sprint Backlog for every sprint.
• Worked with cross project technical BA teams to design ERS (Enterprise Registration Services) and MDM interface designs to SYNC UP systems, conversion and survivor rules.
• Described processes for landing, staging, and calculations and reporting schema with attributes, calculations, and rules for outputs from the OFSAA suite.
• Performed analysis as part of annual Federal Reserve stress tests such as Comprehensive Capital Analysis and Review (CCAR) and Dodd-Frank Act Stress Test (DFAST).
• Conducted web based sessions to showcase the OFSAA Reporting Analytics capability to the Business and Technical Users.
• Interacted with business users and subject matter experts to produce technical documentation and business requirement documents (BRDs) for CCAR filing for FRY-9C, FRY 14M, FR Y 14Q, and FFIEC 031 reports as well as IHC filing.
• Regularly held sessions with Lines of Business (LOB) to document, implement and maintain the metadata and business rules for the bank's data, beginning with the data required for CCAR.
• Provided statistical guidance to the development team on the interpretation of VAR models, IRB - F/IRB-A Economic Capital calculations, Liquidity Ratios and Stress Testing scenarios as per new BASEL III requirements.
• Performed analysis as part of annual Federal Reserve stress tests such as Comprehensive Capital Analysis and Review (CCAR) and Dodd-Frank Act Stress Test (DFAST).
• Provided business analysis coverage for the Governance, Risk and Compliance initiatives usingActimizeTrade Surveillance solution platform.
• Updated the OFSDF data Model to include new BASEL III related entities; Validated the pre-built BASEL III business rules and runs in OFSAAI Application Infrastructure; Enhanced the BASEL II Analytics Solutions to include additional reports as per BASEL III requirements in OBIEE and upgraded the underlying OBIEE repository.
• Worked onUML Diagramsto createActivity Diagram, Sequence Diagram,andState Chart Diagramfor better understanding.
• Wrote and updatedUser Storiesto capture all actions. CreatedUser Interface Document (UID)by using number of modeling tools.s
• Developed internal reporting using MS SQL Server to track that individual milestones and work stream targets have been met.
• Designed BI & Analytics Data Requirement using TABLEU and transform into Functional Specification.
• Extensively used tools such as Rational Rose, Rational Requisite Pro, UML, MS Visio, MS Project, MS Office, and MS Access.
• Provided technical expertise and knowledge to the software engineering team for the functional side of the collaboration tools (JIRA, Confluence and SharePoint) along with Front End and Back End support to the team.
• Designed and Developed ETL (Extract, Transformation & Load) strategy to populate the Data Warehouse from the various source systems feeds.
• Conducted User Acceptance Testing on the application resolved issues from the participants, prepared Test Analysis Reports.
• Developeduse casesand oversee creation oftest scriptsby the QA team. Provided reports and metrics as requested by the users to improve the effectiveness of trade surveillance.

Confidential, Bloomington, IL

Business Systems Analyst

Responsibilities:

• Gathered analyzed, documented business and technical requirements from both formal and informal sessions and validate the needs of the business stakeholders.
• Conducted user interviews and documented business and functional requirements.
• Performed Requirement Analysis and developed Use Cases, Activity Diagrams using Rational Rose
• Analyzed and translated business requirements into system specifications utilizing UML and RUP methodology
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data
• Worked extensively with MS Excel and MS access
• Involved in creating business processes and modeling diagrams using Rational Unified Process (RUP).
• Created use case scenarios and documented work flow and business process using Rational Rose
• Involved in project management using MS Project
• Documented requirements associated change requests with requirements and connected requirements with Use cases.
• Wrote test cases and test scripts for the User Acceptance Testing
• Use Cases and other Process Flow Models were designed using Visio and Rational Rose.
• Involved with all the phases of Software Development Life Cycle (SDLC) methodologies throughout the project life cycle.
• Queried database using SQL for backend testing.

Confidential, New York City, NY

Sr. Business Analyst

Responsibilities:

• Involved with all the phases of Software Development Life Cycle (SDLC) methodologies throughout the project life cycle.
• Authored Business Requirements Document BRD with project teams. Extracted, discussed, and refined business requirements from business users and SME’s.
• Liaison with business users and IT for Business Requirement Document (BRD) and Business Functional Specifications (BFS) integration and conversion project execution.
• OrganizedJAD sessionsand workshops, prepared agenda and facilitated the meetings with the SMEs, product owner & stakeholders to elicit requirements and document risked outcomes.
• Conductedrisk and feasibility analysis, to make sure the enhancement process was in the project budget and feasible in carrying out the activities within the specific time.
• PerformedGAP Analysisby understanding theAS-IS (existing)business process andTO-BE (future)business process and created business process model.
• Analyzed requirements & recommend strategic initiatives for OTC derivatives protocols and practices around DTCC, CDS, and SWIFT.
• Involved with the procedures ofBanking & Regulatory Compliances- Anti-Money Laundering (AML), Customer Identification Program (KYC/CIP), CCAR/CECL Regulatory Reporting,Dodd-Frank Act stress testing.
• Ensured the data quality by checking the completeness, consistency and accuracy of risk data for regulations of BASEL III and Comprehensive capital analysis and review (CCAR).
• Resolved issues with check printing, Crystal Reports, positive payment and Accounts Payable voucher matching functionality. Bring outsourced Oracle E-Business Suite support in-house, improve business processes.
• Worked on preparing metadata for regulatory reporting FFIEC 101, FR-Y 7, FR-Y7Q, FR-Y 14, FR-Y9C, FR-2248, FR 2236, BQ1, BQ2, BL1, BL2, AND on other regulatory reports.
• Responsible of creating the Meta data mapping forAnti money laundering (AML)under their financial crime & compliance program andknow your customer (KYC) for Confidential.
• UsedActimizeto know your customers and to automate regulatory reporting process including Suspicious Activity Reports.
• Responsible for business case development, ROI analysis and planning for Securities Finance cash management project.
• Defined Payroll Areas and assigned relevant period parameters and date modifiers and set up features.
• Provided system implementation guidance to Compliance team forForeign Account Tax Compliance Act (FATCA)includingBank Secrecy Act (BSA)for oversea US entities and subjects.
• Created Payroll Accounting Areas, Generated Payroll Periods for each Combination of Payroll Parameter and Date Modifier; Created Control records to each payroll accounting Area.
• Assisted the development team in preparation of the CRUD Matrix.
• Extensively used MS Office tools like MS Access, MS Word, MS Excel, MS PowerPoint and MS Project.
• Exposed to SQL queries while churning out relevant information from company’s database.
• Performed sample data analysis and data quality control validation of Basel III regulatory reporting systems using pivot table calculators, stored procedures and SQL queries.
• Submitted change requests and worked with change request records in Clear Quest.
• Extensive knowledge in HCM and US Payroll business processes including Personnel Administration (PA), Organization Management (OM), Benefits and Enterprise Compensation Management in addition to Time Management.
• Worked on US Payroll issues along with Time Evaluation in SAP HR, in addition to third party remittances.
• Presented variousKey Performance Indicators(KPI) and Business Metrics by assisting the BI Analysts in generating reports, ad hoc reports and interactive dashboards and created a storyline for presentation usingTableau for Analysis and Visualization.
• Extensively used JIRA to draftEpics, Stories, and Sprint Burn down Chartsto track team’s progress andBurnup chartsfor the Stakeholders view to show the current status of the project.
• Assisted in system and user acceptance testing (UAT), free-trial demos, performed client presentations.
• Executed all aspects of business analysis, reporting, database management, and financial analysis. Assisted in Conducting Smoke Testing,UAT testing, User Interface testing, functional testing, Integration testing,Regression testing, Back- end testing, UI testing, Parallel testing, Rules testing.

Confidential, Sulphur Springs, TX

Business Analyst

Responsibilities:

• Interacted with various cross functional teams, defined and document business processes and Requirements, and managed projects from design to completion by using Agile Methodology.
• Facilitated JAD Sessions with users, developers, and database design team to deal with backend synchronization issues accompanied with interviews and document analysis.
• Identified the requirements of the stakeholders and created Business Requirement Document (BRD) and Functional Requirement Document (FRD).
• Designed and implemented Portfolio Supervisory System, including trend analysis, forecasting returns and interfaces for risk management, financial advisors and financial analysts implementing the agile methodology.
• Performed GAP analysis to enhance the monitoring and reporting of control processes in Capital Markets dealings from front office (sales and trading) to middle office (product control,) to back office/operations, (regulatory reporting and compliance) as well as trade processing, including clearance and DTCC settlement.
• Gathered CCAR, PPNR and supplementary metrics (FRY-14, FRY-9C) forecast from different business units.
• Supported the assessment of CCAR IHC report preparation environment.
• Created data dictionary and data decomposition documents, including FATCA regulations.
• Performed cost benefit analyses and evaluated alternate courses of actions. Developed Independent Government Cost Estimates (IGCE). Monitored and reported cost benefits for Foreign Excess Personal Property (FEPP).
• PreparedUse casesandActivity flow diagramsandWork flow diagrams, considering the scope of the project withMicrosoft VISIO.
• Maintained Sprint burn down chart, Product burn down chart, Time boxed the Sprints and Daily Scrum meetings for the record.
• Followed the UML methodology to generate Activity Diagrams, Sequence Diagrams, Class Diagrams and Collaboration Diagrams using Rational Rose.
• Attended and facilitated dailyScrum meetingsto implement the project in anAgile Methodologyand extensively worked with tools likeMS TFS,MS CRM,MS Office suiteMS Project, MS Visio, MS Outlook, MS PowerPoint, Snag it,PhotoScape,Web conferencing and Tableau.
• Performed data analysis using SQL queries to extract information from databases.
• Minimized defects in software application by collecting, reviewing, managing, and monitoring software application defects inJIRAthrough resolution as reported by various internal and external customers.
• Identified and assessed potential data source of Interest Rate, help the market data team to integrate data using ETL tools.
• Reviewed test scenarios to ensure complete coverage of release contents, management of change controls and integration into existing work items.
• Actively participated in the testing of the system during UAT, Regression Testing, and Black box Testing. Created Test Cases and Test scripts.

Confidential, Richmond, VA

SQL Developer

Responsibilities:

• Analyzed business needs and developed Technical Specifications based on interaction with Managers and Development Teams.
• Involved in the all the stages of Software Development Life Cycle (SDLC).
• Troubleshoot and support reports in the production environment resolve issues and deploy bug fixes in a timely manner.
• Support Production issues on Archiving Job failures which might related to data issues
• Coordinated with business users, application development team on various production issues.
• Involved in the normalization and de-normalization of the databases.
• Created and Modified tables, views, triggers, Indexes, User Defined Functions, Stored Procedures, cursors in SQL Server 2012.
• Wrote the complex queries using joints, Sub-queries, common table expressions (CTE) in T-SQL-2012.
• Improved the performance of the T-SQL queries and Stored procedures by using SQL profiler, Execution plan, SQL performance monitor and Index tuning advisor.
• Extensively used DML scripts to perform modification tasks like Insert, Update and Delete data in database tables.
• Developed Many Excel Reports like Power Pivot Table, chart Reports for Data manipulation.
• Created Macros to automate moving and formatting data, and Macros to run financial formulas behind the Scene.
• Involved in extensive DATA validation by writing several complexes SQL queries and involved in back-end testing and worked with data quality issues.
• Improved the performance of the T-SQL queries and Stored procedures by using SQL profiler, Execution plan, SQL performance monitor and Index tuning advisor.
• Used SSIS features like event handlers, property expressions, and package configurations, transaction option, checkpoints and protection levels in the packages.
• Migrated DTS packages to SSIS packages using package migration wizard.
• Migrated SSIS packages from lower version to higher version.
• Used containers, Execute SQL task, Execute package task, Script task etc. for transformation of data in the SQL Server Integration Services packages from OLTP to OLAP.
• Developed Complex SSIS Packages using Proper Control flow and data flow elements.
• Worked with different methods of Logging in SSIS.
• Deployed SSIS Packages into Different Servers by Configuring it.
• Excellent report creation skills using SSRS
• Developed Tabular Reports, Matrix Reports parameterized Reports Sub reports, Snapshot and Adhoc reports (SSRS)
• Improved the SSRS Report performance by using different methods.
• Created Standard And Data driven Subscription for SSRS Reports
• Wrote C#,VB.NET Code for Script Task in SSIS 2012
• Also responsible for transferring data from Production Server to the Development Server occasionally on Incremental Basis for the purpose of checking the consistency in data.
• Used the WCF services as the major component in communicating with the data access layer.
• Implemented WCF Web service for Integration with other Inbound Applications using .Net 4.0, C#, WCF ADO.Net Entity Framework, XML, XSLT, SOAP and SQL Server 2008.
• Created Rest Web Services to communicate between SOAP Web Services and UI.