Sr. Business Analyst
Resume:
Bina Jitendra Shukla
Carol Stream, IL, *****
ad5tqr@r.postjobfree.com
PROFESSIONAL SUMMARY:
** ***** ** ******** ********** as a Business Analyst in the Finance, Banking and Investment domain.
Experience reviewing codes in JavaScript and XML and writing SQL queries.
Extensively interacted with the QA Team to help them execute various Test plans GUI, Functionality test and system test, Integration test, defining Test Cases, POC, and facilitated UATS.
Experience conducting GAP Analysis, SWOT Analysis, and ROI analysis.
Proficient in conducting Meetings, Interviews, and Joint Application Development JAD sessions with various Stakeholders and flexible in coordination across various groups and vendor partners.
Gathering Business requirements from users and converting them to user stories for the development team.
Proficient in Business Requirements Elicitation, Data Modeling, Analyzing and Translating requirements into Specifications across different functions and Application Design.
Effective Project management skills and effectively acted as Project Manager on various occasions to maintain Scope, resource scheduling, status reports update and project plan updates.
Experienced in gathering requirements, analyzing business processes, and defining project specifications to support asset management and banking initiatives.
Strong experience with Basel III, CCAR, KYC rules and regulations. Expertise in Serving as Data Validation and serving as SOX application migration.
Worked in mainframe environment and used SQL, Oracle PL/SQL to query various reporting Databases.
Very good understanding of Business Intelligence and Data Warehousing concepts with emphasis on ETL and Life Cycle Development including requirements analysis, design, development, testing and implementation.
Working on regulatory reporting framework and Reporting domain projects like Basel Reporting, CCAR, and Liquidity Reporting.
In - depth knowledge of and experience in the financial industry and global financial markets including product expertise (Equities, Swaps, Fixed Income, Money Markets, FX, futures & options and both OTC and exchange-traded derivatives products).
Well-versed with SDLC methodologies Waterfall Model, Agile-Scrum, RUP, and Six Sigma.
Experienced in Financial Markets and Capital Markets regulations (Basel, CRR, CRD IV)
Created prototypes, user stories, Business cases, UI Storyboards, and screen flow diagrams for a preliminary assessment of functionalities.
Gathered requirements within an Agile/Scrum framework and confirmed delivery of User Stories met Business needs.
Proficient in creating documentation like BRD, SRS, FRD, RFP, RFQ, RTM Wireframes, Mock-ups and conceptual design creating Use Cases, specifications and Use case scenarios Business Processes Modeling using BPMN, Data mining and Data Modeling Entity relationship diagrams. Workflow diagrams, Sequence Diagrams, Activity Diagrams, etc. using UML.
Worked with creating databases on servers SQL and Sybase and in applications, using data generated from live and static feeds in a variety of formats
Experience in using BI Business Intelligence tools like Cognos, Toad, Oracle OBIEE, Financial Analytics, Crystal reports, etc for reporting purposes. Proficient in working with Excel and functions like Pivoting, recording Macros, solver and lookups.
EDUCATION:
Masters from, Gujarat University, Gujarat, INDIA
Bachelor's from Gujarat University, Gujarat, INDIA
Visa: US citizen
PROFESSIONAL EXPERIENCE:
Fifth Third Bank, Chicago, IL July 2020– Present
Business Systems Analyst
Responsibilities:
Managed requirements based on securities like Equities, Fixed Income, Mortgage-Backed Securities (MBS), and Asset-Backed Securities (ABS).
Helped to develop wireframes and graphical data visualization for clients.
Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams and Dataflow Diagrams in MS Visio. Prepared functional requirements to define the system rules by creating Use Cases, Interface design.
Performed extensive data analysis using MS Excel and gap analysis.
Stored and modified requirements in MS Word, Documented business requirements with wireframes and mockups to explain in detail the business implications and impacts.
Managed SharePoint Designer workflow creation.
Assisted Customer Service, Sales and Marketing departments with customers’ accounts for billing and promotion errors.
Created different graphs and charts such as Pie charts, Bar charts, etc using MS Excel and also created reporting presentations using MS PowerPoint.
Collaborated with trading desks, portfolio managers, and stakeholders to gather requirements, define project scope, and prioritize initiatives related to fixed income, equities, and derivatives.
Conducted comprehensive financial analysis, including market research, economic analysis, and investment strategies, to support trading decisions, portfolio optimization, and risk assessment.
Analyzed fixed income securities, equities, and derivative products to identify trading opportunities, evaluate investment risks, and enhance portfolio performance.
Monitored regulatory developments related to Basel frameworks, CRR, and CRD to ensure compliance
Supported the development and implementation of new trading strategies, financial products, and risk management solutions to enhance trading operations, investment performance, and business growth.
Worked on JIRA (Agile tool) to create product roadmaps, product backlog, user stories and tasks.
Prepared a traceability matrix for tracking the requirement to software requirement specifications and test cases. Also maintained change management throughout the inception phase to the transition phase.
Developed strategic partnerships with the business units to develop a solid knowledge base of the business line; including the business plan, products, and process and revenue streams.
Used senior level SQL query skills Oracle and TSQL in analyzing and validating SSIS ETL database data ware house processes.
Worked with the Business Objects developers to provide input for generating automated and ad-hoc Business Objects reports.
Used SQL for querying and analysis purposes on various source tables and conditions applied.
Assisted the PM in setting realistic project expectations and in evaluating the impact of changes on the organization and plans accordingly; also conducted project-related presentations.
Helped the testing team in creating the test plans and test scripts. Assisted the users in UAT testing by providing test scenarios and test data.
Involved with the QA team to conceptualize, determine and develop test approaches and methods for unit testing, integration and functional testing, load and usability testing according to the application complexity and test requirements.
Collaborated with asset management teams and stakeholders to gather requirements, define project scope, and prioritize initiatives related to investment analysis, portfolio optimization, and risk assessment.
Conducted comprehensive investment analysis and financial modeling to support asset management decisions, portfolio performance evaluation, and investment strategy optimization.
Analyzed historical credit data to develop predictive models and assess credit risk for new and existing customers.
Conducted portfolio segmentation analysis to identify high-risk segments and implement targeted risk mitigation strategies.
Assisted in the development and maintenance of credit risk policies and procedures in alignment with regulatory guidelines.
Collaborated with IT teams to enhance data infrastructure and automate credit risk reporting processes.
Provided support for regulatory exams and audits by preparing documentation and responding to inquiries related to credit risk management.
Involved in developing Oracle PL/SQL procedures for creating/dropping of table and indexes of performance for pre and post session management.
Worked on data extraction, analysis, refining, migration and loading of data into MDM database through ETL process.
Responsible for creating different sessions and workflows to load the data to Data Warehouse using Informatica Workflow Manager.
Analyzed financial markets, economic trends, and investment opportunities to identify risks and opportunities and make recommendations to enhance portfolio performance and asset allocation.
Supported the development and implementation of new asset management products, services, and strategies to enhance client satisfaction, investment performance, and business growth.
Conducted financial analysis, including modeling and valuation, for potential mergers, acquisitions, and capital raising transactions.
Collaborated with senior bankers to prepare pitch books, presentations, and financial models for client meetings.
Conducted industry and market research to identify investment opportunities and trends.
Proficient in writing good SQL queries.
Conducted benchmarking activities to identify best practices.
Trained business users and sales teams on new promotions and operational procedures.
Functioned as a liaison between business users and developers to design, develop, implement, and deploy Client Risk Rating (CRR) applications.
Conducted thorough market research and analysis to identify emerging trends, potential opportunities, and risks within the capital markets
Involved in Requirement Elicitation and maintaining requirements from Inception through the Construction phase.
Analyzed and prioritized user and business requirements as system requirements that must be included while developing the software. Conducted Business Analysis and Data Analysis.
Involved with Investment Management Accounting group to understand the back office processing of trading various instruments.
Responsible for entering and updating Issues (Epics, Stories, and Tasks) onto JIRA Agile application.
Involved in requirement gathering sessions with and Product Owner and Business Owner.
Maintained requirements and entered bugs in JIRA for tracking and testing purposes.
Refined and input business requirements in HP Quality Center for traceability to test requirements.
Designed the business requirement collection approach based on the project scope, Created Business Analysis using agile methodology.
Conducted Interviews with key business users to collect requirements and business process information.
Created project plans, style sheets and templates to analyze and estimate feasibility, cost, time and general guidelines for the project team.
Facilitated JAD (Joint application development) sessions with business users and development teams to drive out detailed business requirements.
User Stories and Acceptance criteria and in prioritizing product backlog as per business priorities.
Assisted with user testing of systems, developing and maintaining quality procedures, and ensuring that appropriate documentation is in place.
U.S. Bank, Omaha, NE Mar 2018 – June 2020
Business Systems Analyst
Responsibilities:
Interact with business stakeholders from multiple departments including: Card Finance, Accounting, Third Party Investor Reporting and Capital Market and led meetings and interviews.
Interface with the Wholesale Commercial Loan and Mortgage user group to address issues.
Performed Requirement Gathering, Analysis & Management by actively discussing and exploring customer requirements and prepared the Business Case Document using MS Word
Gather and document business requirements and business process flow, following the existing template and specifying the objects, assumptions, constrains, scope, features, data file load processes, and screen mockups etc.
Review Commercial loan documentation to ensure enhancements are meeting the proper audit standards.
Writing of technical documents regarding use and provisioning of access in Role-Based Access Management and that all procedures are followed.
Gathering requirements, analyzing business processes, and defining project specifications to support various fixed income, equities, and derivatives projects and initiatives.
Conducted and lead requirements elicitation meetings with end users to document system requirements and management of these requirements.
Wrote BRD, FRD, use cases, test scenarios, test cases for testing the functional and non-functional aspects of both ETL jobs and Reporting jobs.
Determined alternatives approaches to Basel II regulatory capital calculations allowing significant capital savings
Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
Risk Consulting with emphasis on Governance, Risk & Compliance (CCAR, Basel, BCBS)
Participated in regulatory capital projects like Basel III and CCAR implementation for the FCM business.
Work experience in Risk Control, DFAST (Dodd Frank), CCAR and other regulatory reporting process.
Conduct comprehensive analysis of credit risk data to assess portfolio performance, identify trends, and anticipate potential risks.
Develop and enhance credit scoring models to improve credit decision processes and optimize risk-adjusted returns.
Collaborate with cross-functional teams, including risk management, finance, and IT, to implement credit risk strategies and ensure compliance with regulatory requirements.
Perform stress testing and scenario analysis to evaluate the impact of economic factors on credit risk exposure.
Assisted in the analysis and documentation of financial data for investment opportunities.
Conducted market research and contributed to the development of investment proposals.
Wrote Test Plans in MS Word for Manual Testing, System Testing, Integration Testing, Performance Testing, Regression Testing & reviewed their consistency with the business requirements
Used JIRA to enter and and verify the closed bugs.
Collaborated with data engineers and developers to design and implement ETL processes for data extraction, transformation, and loading into Oracle databases, ensuring data accuracy and integrity.
Utilized SQL queries and Oracle PL/SQL to perform data analysis, identify trends, and generate insights to support decision-making and strategic planning.
Performed data analysis, data reconciliation and data retrieval from various systems along with identification of data gaps and data quality issues for Basel II Credit Risk Mitigation System (CRMT)
Assisted senior analysts in gathering requirements, analyzing business processes, and defining project specifications to support various asset management and banking projects and initiatives.
Supported project planning, tracking, and management to ensure timely and quality delivery of asset management and banking-related projects and strategic initiatives.
Analyze Credit and Equity OTC Derivatives Trading Life Cycle to improve legacy and proprietary trading process & systems.
Responsible for managing Capital Markets transformation projects involving trading, accounting and risk management systems implementations, business process optimization initiatives, and industry standards for Fixed Income, Equities, FX and Derivatives lines of businesses.
Analysis and requirements document for implementing of FX spot/forward/ options and money markets from the Treasury users and cash management team.
Conducted data analysis to support business decision-making, risk assessment, and process optimization within the asset management and banking operations departments.
Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.
Created Use Case Models, Analysis Models, Design Models, Implementation Models, Use Case Diagrams, Behaviour Diagrams sequence diagrams, collaboration diagrams, activity diagrams and Class Diagrams based on UML methodology using MS Visio.
Assisted in the creation and maintenance of project documentation, requirements, and specifications, facilitating effective communication, knowledge sharing, and collaboration among project teams and stakeholders.
Supported the development and implementation of new asset management products, services, and process improvements to enhance client experience, operational efficiency, and business growth.
Wrote Test Cases in MS Excel for user registration, access to training material, and activity log-in, reviewed the test cases and finalized
Authored the detailed Business Requirement Document (BRD) Functional Requirement document (FRD) for new product functionality after conducting requirements elaboration sessions with Vendor & client teams.
Used UML modeling tools such as MS Visio to define business flow and activity diagrams.
Worked extensively with financial instruments, including equities, fixed income products and derivatives and their trading life cycles.
Made recommendations to development teams regarding the design and implementation of the missing functionality.
Created tickets for all defects identified and coordinated with development team and business to get the defects resolved using JIRA.
Worked with requirements analysts and Subject Matter Experts (SME) to identify, understand, and document business needs for the data flow to create market risk and credit card modules.
Responsible for working with the manager and other users and creating Work flow diagrams as per the requirement analysis.
Maintained and kept track of stakeholders' requests for enhancements and changes using Unified Change Management tool (UCM) such as Rational Clear Quest.
Created detailed periodic status reports to provide end-users, top management and implementation team, visibility into the progress of the implementation.
Republic Bank, Louisville, KY June 2016 – Feb 2018
Business Analyst
Responsibilities:
Worked closely with the business community in gathering the data storage needs to establish Third Party Liability Issues. Translated the business needs into system requirements, communicating with the business on a non-technical level, and with the System Analyst on a more technical level.
Maintaining a documented system of accounting policies and procedures along with maintaining a system of controls over accounting transactions in SSCS (Service Station Computer Systems) and SAP CR (Crystal Reports).
Assisted in the production of the annual company budget and forecast. Assisted project managers with the development of project schedules.
Worked with multi-site teams to organize content on SharePoint for Collaboration and worked with all levels of client staff in solution definition. Provided recommendations to senior management to dissolve the problems. Identified and escalated problems to senior management.
Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project cycle.
Worked closely with product owners to write user stories and define the acceptance criteria.
Facilitated and participated in Bi-weekly estimation meeting to provide high level estimate (story points) on user stories committed for forthcoming sprint.
Regulation and Risk management Basel III. Dodd-Frank - Understanding of Credit Risk, Market risk and Operations risk, ICAAP Process. Regulatory experience in CCAR, BASEL III, Dodd-Frank, etc.
Coordinated activities between the business house and technical staff, in developing new methods, policies, and procedures to meet the business needs, and has acted as a Subject Matter Expert.
Used MS Visio to carry out the Business Use Case Modeling and Business Object Modeling effort to develop the business architecture for rapid and controlled application development.
Applied Unified Modeling Language (UML) methodologies to design Use Case Diagrams, Activity Diagrams, Sequence Diagrams, ER diagrams & Data Mapping.
Responsible for the production of BRD, PDD and SRS for the banks critical and high priority systems and for FI, FX, Equities, Repos and Derivatives.
Worked with Gold Line Nationwide Pricing to analyze and document detailed requirements also acting as a customer representative during the iteration cycles, and aided in the data mapping process.
Created relationships in Requirement Traceability Matrix linking User stories to Functional requirements and Functional Requirements to Systems Requirements.
Wrote SQL statements to extract data from the Tables.
Participated in data profiling and data cleansing activities to ensure data quality and integrity for migration into Oracle PL/SQL databases.
Responsible for Preparing annual operating budget and project future profit and cash requirements and merging management reports and reconciling cash, bank and credit card transactions, Supervise and managing payroll.
Collaborated with the offshore/onsite QA team to ensure adequate testing of software and data validation maintained quality procedures, and ensured that appropriate documentation is in place.
Assisted the Product Owner and the team in entering and updating Issues (Epics, Stories and Tasks) onto JIRA Agile Application.
Conducted UAT (User Acceptance Testing) at the cents premises after successfully deploying the product.
Creating and analyzing financial reports at the month’s end and reporting the outcome to the Manager.
As a part of the finance project team interacted closely with the business community to define and analyze the business requirements to present possible technical solutions.
Performing audits and analyzing inventory reports of C-Stores by using SSCS and Crystal Reports. Calculating variances from the budget and reporting significant Issues to the top management. Provision data to the Financial Firm for reporting purposes.
Collaborate, Review and Finalize, using SP, the Financial Data and update the procedures to perform Data Validation.
Passing beginning of the year, month end and year ending Adjusting Journal Entries and Year End Journal Entries.
Conducted gap analysis to derive the requirements for the proposed systems enhancements.
Royal Bank of Canada – Jersey City, NJ Aug 2014 – May 2016
Business Analyst
Responsibilities:
Extensive Involvement in the calculation of Duration and convexity of the bond. Captured pricing data and implemented and maintained a strategic repository of global pricing for both internal and vendor sources.
Analyzed and investigated business user issues and worked with SMEs and Managers to identify related "defects" and required "enhancements" in the application and capture business requirements.
Experienced in defining business processes, identifying risks, base-lining acceptance criteria, and deliverables.
Developed and managed the formal Software Development Life Cycle (SDLC) Methodology which includes Configuration Management, Requirements Management, UML Analysis and Design.
Performed financial modeling, data analysis and data mapping related to credit risk and market risk data to conduct root cause analysis with respect to inputs required and model results
Performed the requirement Ad-Hoc Analysis and documented the requirements.
Closely interacted with designers and software developers to understand application functionality and navigational flow and keep them updated about Business users’ sentiments.
Developed BRD, FRD, Use Case diagrams, business flow diagrams, Activity/State diagrams and Wire Frame diagrams so that developers and other stakeholders can understand the business process.
Documented and validated the business process flow of the Online Securities Trading System.
Interacted with SMEs in Fixed Income, Bonds and Bond Trading Cycle, Bond Pricing, and Asset Management.
Drafted new Requirements for new PKI architecture to include Simplified Sign-On.
Assisted the research and development team in creating SSO solutions utilizing Public Key Infrastructure.
Work under Agile methodology.
Working knowledge in writing SQL query for identifying databases involved in the application development.
Conducted JAD sessions to develop an architectural solution that application meets business requirements, resolve open issues, and change requirements.
Created and maintained a project schedule using MS Project showing all of the deliverable’s target dates.
Worked closely with the client base to understand and meet their needs by incorporating new functionality and features into the systems.
Facilitated weekly meetings with the review teams to continuously improve the QA process for application development.
Interacted with business heads to finalize the Business Requirements for the application.
Contact this candidate