Data Test Cases

Krishna Kompelli Business Analyst

*****.**@***.*** 732-***-****

Summary:

7+ years of experience as a Business Analyst in the Banking and Financial Services domains. Expertise in Capital Markets, AML monitoring, Business Analysis and Data Analysis.

Strong working knowledge of various capital market instruments and processes including Equities, Fixed Income, Derivatives, Mutual Funds, Trade Processing & Trade Settlement System.

Experience and strong understanding of Risk Management and control, Dodd Frank Compliance, AML monitoring, Bank Secrecy Act and Know Your Customer(KYC).

Expertise in dealing with Software Development Life Cycle using the Waterfall Model, Rational Unified Process (RUP) model and Agile/Agile Scrum methodologies and experienced in Business Process Management.

Proficient in gathering requirements from stakeholders by conducting various elicitation techniques like Brainstorming, One on One Interviews, Surveys & Questionnaire, Focus Groups, Requirement Workshop, Prototyping, Requirements gathering session, Observation, Document Analysis and Interface Analysis.

Experienced in preparing artifacts like Business Requirement Document (BRD), Function Requirement Document (FRD), Software requirement Specification (SRS), Data Mapping Document (DMD), RTM and dependency matrix.

Proficient in giving walkthrough and creating Unified-Modeling language (UML) diagrams for business process modeling like Use Case Diagrams, Sequence Diagrams, State Chart Diagrams, Activity Diagrams and Class Diagrams.

Functional experience in crafting Work flow, business process flow, data flow and creating UI mock-ups, and wireframes.

Experience writing Test Strategies, Test Plans, Test Cases, Test Scripts and maintained Defect Logs for defect tracking during the different phases of the STLC process.

Well versed in handling organizational change management and conducted assessments in the event of change request, effectively performing both business and technical impact analysis on the triple constraints of the project, baselining documents endorsed by Change Control Board.

Extensive experience in creating Data Visualizations Dashboards and Reports using Tableau.

Hands-on experience with RDBMS, ER Modeling, Data Modeling, Data Indexing, and Data Normalization.

Great expertise in working with cross functional teams and offshore teams and managing project time, resources and risks accordingly.

Extensively Implemented business logic, data lineage mapping and traceability for Dodd Frank regulatory reports.

Proficient in using Prioritization techniques (MoSCoW method, Kano method), Estimation Techniques (Planning Poker, T-Shirt sizing) in helping the Product Owner and the team to commit the Product Backlog Items (PBI) for Sprint.

Experienced in using development techniques like Test Driven Development (TDD), Behavioral Driven Development (BDD) and Acceptance TDD (ATDD) and capturing empirical data necessary for forecasting for sprints.

Facilitating Scrum ceremonies such as Daily Scrum, Sprint Planning and Grooming, Sprint Review and Retrospective sessions during the sprint.

Experience of working with XML, WSDL, SOA, and created Web Service Document.

Technical Skills:

SDLC Methodologies

Waterfall, Agile Scrum, Scrum-Waterfall hybrid, Rational Unified Process (RUP)

Requirement Management Tools

JIRA, Rally, Rational DOORS

Design Tools

MS Visio, Rational Rhapsody

Statistical Tools

MS Excel, SAS-JMP

Databases

MySQL database, Oracle, SQL server

Data Warehousing

Entity Relationship Diagrams, Dimensional Modelling (Star Schema, Snow-flake schema), Data Modelling, Normalization (1NF, 2NF, 3NF and Boyce-Codd NF)

Reporting Tools

Tableau, Power BI, SSRS

Programming languages

C#, .net

Education:

Bachelor of Technology in Computer Science from JNTU

CERTIFICATIONS:

Certified Scrum Master

Certified BA Pro

Scrum Fundamentals Certified

Advanced Scrum

Professional Experience:

Primerica Jun 2017 - Present

Business Systems Analyst/ Scrum Master Duluth, GA

Summary: Primerica is an independent financial services marketing organization in North America.

The project is focused for customers with sound financial knowledge and doesn’t want to spend on the advisory charges. The objective of the project was to develop a system which evaluates the needs of the customers and provides unbiased financial advice based on the risk appetite and the profile of the users. It had two stages. The initial stage was to develop a system which would evaluate the Financial needs of the customers by considering the earning potential and the need. The second stage of the project was to develop the system which would suggest the customers the best investing options based on the investing potential, risk appetite and the results of the Financial needs analysis of the customers.

Responsibilities:

Interacted with the Financial Advisors and the Financial Analysts to understand Financial Needs Analysis procedure and gathered requirements considering the compliances and risks.

Collaborated with the Financial Risk Analysts to evaluate risks associated with various investment opportunities (Equity Funds, Fixed Income Funds, Exchange Traded Funds etc.) using Monte Carlo Analysis.

Extensive experience in Financial Service industry related - Credit Risk, Market Risk, Market Risk, Credit Risk and Liquidity Risk. Involved depth understanding of Credit Risk management for the application.

Interviewed traders, Advisors and investors to know the needs of the project and created the list of functional specifications and Business rules based on it.

Provided recommendations for process improvements and assisted in policy development to support change initiatives and support the Business Process Management.

Conducted and lead the JAD session with Financial Advisors and developers to setup project goals and objectives when faced with a set of issues related to system design and development.

Worked as a liaison between the Business team and the development team during the planning, eliciting, developing and testing phases of the system.

Collaborated with the Product owner in breaking down the epics into user stories and supplemented the user stories with prototypes.

Was responsible for writing the use cases for the features with all the possible Alternate flows, Exception flows and well defined Normal flow.

Created/ reviewed SQL for many different applications to achieve best performance possible.

Utilized strong SQL knowledge and executed performance tuning. Performed root cause analysis and identified missing links in system designs.

Defined the business rules with the support of the Financial Analysts using ‘if’ and ‘then’ statements and helped the development team to develop the algorithm.

Analyzing the Capital Market instruments such as Equity, Fixed Income, Derivatives etc and suggesting the best investment opportunities to the customers.

Collaborated with Front Office team for suspicious activity reports on KYC/ AML for flagged accounts in line with the Bank Secrecy Act (BSA).

Implemented Actimize Anti-Money Laundering (AML) system to monitor suspicious transactions and enhance regulatory compliance.

Configured and managed changes to the application to analyze the financial needs of the individuals efficiently.

Created the UML diagrams such as Usecase diagrams, Class diagrams, Sequence diagrams and Activity diagrams for clear understanding to the developers.

Activelyassistedtheproductownerinprioritizingtheproductbacklogasperthemaximumbusinessvalue, grooming User Stories in planning activities using INVEST criteria.

Supported and assisted Product owner in capacity planning to determine the production capacity with respect toavailabilityofonshoreandoffshoreteammemberstomeetthechangingneedsoftheproject.

Extensively used JIRA to record and maintain the artifacts such as Product backlogs, Sprint backlogs, user stories, Impediments list, tasks, defects and issue tracking.

Facilitated various Scrum ceremonies like Sprint Planning Meeting, Daily Stand-up Meeting, Sprint Review Meeting, Sprint Retrospective Meeting and Backlog Grooming.

Worked with the Quality Assurance team and wrote test cases, test scenarios and test plans, and managed the defect tracking life cycle.

Used Test Driven Development (TDD) and Acceptance Test Driven Development(ATDD) to develop the components of the system.

Conducted User Acceptance Testing(UAT) and validated the results generated by the system with the solutions defined by the Advisors.

Environment: Agile Scrum, MS Office Suite, MS Visio, MS Project, C#, Oracle Toad, JIRA, Confluence, TDD, ATDD.

Key Bank Jan 2016 – May 2017

Business Analyst Brooklyn, OH

Summary: The objective of the project was to integrate the existing Anti-money laundering (AML) surveillance system with an updated and Automated system that provided AML solutions as a part of compliances and Legal division and assisted in the Anti-money laundering Program. The basic purpose of the system is to identify and protect the institution from Anti-Money laundering transactions and filing Suspicious Activity Reports to FinCEN.

Responsibilities:

Collaborated with Project Manager, Developers and QA Team in the Planning, Analysis, Design, Development and implementation of the system.

Responsible for eliciting, analyzing and documenting all system specifications including Data rules, Data requirement, Data mapping, Transaction mapping and over viewing the testing activities.

Worked along with the Compliance team and the SME’s to know the type of transactions which may lead Anti-Money laundering and Terrorist Financing activities and defined the transaction monitoring rules.

Responsible for identifying Data requirements, data mapping, transaction mapping needs in compliance with Bank Secrecy Act requirements in general and anti-money laundering.

Derived functionalrequirement specifications to facilitate the generation of daily Anti-Money Laundering(AML) reports and Suspicious Activity Reports(SAR) to meet the compliance requirements.

Assisted the compliance teams to conduct AML investigations to analyze the alerted data and measure, report and monitor risk from a Bank Secrecy Act (BSA)/AML standpoint.

Worked with SMEs to understand AML KYC guidelines and make sure that the requirements are in compliance with AML KYC guidelines.

Updating KYC documentation in line with the AML guidelines, interacted with Developers for fixing the bugs and make sure to close the resolved bugs and issues.

Documented deposit related Know Your Customer (KYC) processes, identified higher risk customers, and maintained the list of the deposits of high-risk customers in Actimize.

Implemented business logic, data lineage mapping and traceability for Dodd Frank regulatory reports.

Involved in the risk analysis for clients based on risk assessment and risk management. Maintained required evidence and supporting documents based on their risk levels.

Performed Customer Due Diligence (CDD) on all clients, Enhanced Due Diligence (EDD) checks on high-risk clients and on any suspicious transactions.

Assisted in identifying documents needed to develop Suspicious Activity Reports (SAR) as required according to the Bank Secrecy Act and FinCEN.

Worked as liaison between Business units and Data Modelers, Technical System to study the data lineage and created a data mapping document to ensure the automatically generated reports are aligned according to the compliances.

Ensured timely submission of Suspicious Activity Reports (SARs) and identified potentially suspicious activity referred to the deposits AML team by Actimize.

Created UML diagrams like Use Cases Diagram, Activity Diagram, Sequence Diagram, and Class Diagram using MS VISIO.

Created Requirements Traceability Matrices to support the application development that included Business Requirements.

Collaborated with QA department to write and execute Test plans and Test Cases and conducted User Acceptance Testing.

Attended the Scrum ceremonies, workshops on SCRUM and decomposed Epics into User Stories. Created user stories using INVEST criteria, tasks using SMART criteria, and defined Acceptance criteria. Used various Estimation, planning and Prioritization techniques such as Moscow, Planning Poker and Kano respectively. Responsible for identifying Impediments and conflict management.

Environment: Agile Scrum, MS Office Suite, MS Visio, MS Project, Quality Center, Dodd Frank, Matlab Simulator, Actimize, .Net, Oracle Toad, SharePoint.

Factset Research Systems Jan 2013 – Jul 2015

Business Analyst Hyderabad, India

Summary:

FactSet creates flexible, open data and software solutions for tens of thousands of investment professionals around the world, providing instant access to financial data and analytics that investors use to make crucial investment decisions. The project was to automate the process of content collection of Mutual Funds to increase the efficiency and reduce the processing time.

Responsibilities

Gathering requirements from the business users using various elicitation techniques such as Interviewing, Video conferencing and JAD sessions.

Acted as a liaison between the development team and the business team which consisted of Financial Analysts, Research Analyst and Content Managers.

Worked closely with the back-office Research Analysts who manually process the mutual funds to understand the procedure.

Documented the process of acquiring the mutual fund information, segregating the Capital Market securities based on the asset classes and validating the prices of each security of the Mutual Fund.

Performed Gap Analysis by analyzing the existing manual processing of the Mutual Funds (AS-IS) and the proposed automated system (TO-BE) and wrote requirements to fill in the gap.

Primary workflow involves checking the accuracy of the portfolio of holdings which would be the amalgamation of various Capital markets investment options such as Equity, FI, Derivates etc with internally prescribed parameters and updating the processed Mutual fund information to the database.

Review, interpret and input complex quantitative regulated information contained in various sources including Securities and Exchange Commission filings.

Created Business Requirement Documents(BRD) and Functional Requirements Documents(FRD) capturing all the functional and the non-functional requirements.

Was responsible for Planning, performing and implementing process improvement activities as a part of Business Process Management.

Prepared Process Flow diagrams capturing the flow of the data through the Mutual Fund processing and wrote use cases for the requirements indicating the normal flow, Alternate flow and exceptional flows.

Created Class diagrams, Usecase diagrams, Sequence diagrams, Activity diagrams and mockups for a better visual understanding and involved in modelling business scenario predictions.

Aided the developers by providing them with the documentation of the entire process and acted as the SME.

Handled changes efficiently by conducting Business Impact Analysisand Technical Impact Analysis. Managed scope and implemented the changes after base-lining the requirements

Implemented changes for improving the performance of the internal tools such as Portfolio Maintenance, Securities Maintenance and Institutions & Contacts without affecting the dependencies among them.

Wrote the Test cases in an end users perspective and was also involved in User Acceptance testing to verify the system has all the functionalities.

Utilized SQL to fulfill ad-hoc data procurement requests in a timely manner to accelerate seamless delivery of results.

Environment: Waterfall Development methodology, SQL, MS Visio, MS Office suite, Sharepoint.

Data Modeler/Analyst Aug 2010– Dec 2012

Axis Bank, Hyderabad, India

Description: Axis Bank is the third largest of the private-sector banks in India offering a comprehensive suite of financial products.

Responsibilities:

Data analysis and reporting using MY SQL, MS Power Point, MS Access and SQL assistant.

Involved in MS Access Database design and designing new database on Netezza which will have optimized outcome.

Designed the data marts using the Ralph Kimball's Dimensional Data Mart Modelling methodology using ER Studio.

Involved in writing T-SQL, working on SSIS, SSRS, SSAS, Data Cleansing, Data Scrubbing and Data Migration.

Used Normalization methods up to 3NF and De-normalization techniques for effective performance in OLTP systems.

Initiated and conducted JAD sessions inviting various teams to finalize the required data fields and their formats.

Created base tables, views, and index. Built a complex Oracle procedure in PL/SQL for extracting, transforming and loading the data into the warehouse via DBMS Scheduler from the internal data.

Create ETL scripts using Regular Expressions and custom tools (Informatica, Pentaho, and Sync Sort) to ETL data.

Extensively involved in Recovery process for capturing the incremental changes in the source systems for updating in the staging area and data warehouse respectively

Worked on Data Modelling using Dimensional Data Modelling, Star Schema/Snow Flake schema, and Fact & Dimensional, Physical & Logical data Modelling.

Environment: ER Studio, MY SQL, MS Power Point, MS Access, MY SQL, MS Power Point, MS Access, DB2, T-SQL, DTS, Informatica MDM, SSIS, SSRS, SSAS, ETL, MDM, 3NF.

Contact this candidate