Data Analyst Project

ANKIT GUPTA

Jersey City, NJ – ***** 646-***-**** **********.**@*****.*** GitHub

MOTIVATED PROACTIVE DETAIL-ORIENTED TECHNICAL BUSINESS ANALYST CSM SAFe SM MBA

PROFESSIONAL EXPERIENCE SUMMARY

•Over six years of IT experience as a Business Data analyst and System analyst in the financial industry, mainly in banking, financial services, and capital markets with expertise in Trading and Compliances (AML/KYC).

•Experienced in Capital markets such as Equities, Equity Derivatives Fixed Income – Corporate Bonds, Government Securities, Mortgage-Backed Securities (MBS), Collateralized Mortgage Obligation (CMOs), Asset-Backed Securities (ABS), Collateralized Debt Obligation (CDOs).

•Strong in Trade activities, Trade Life Cycle, KYC, AML Surveillance, and Wealth Management.

•Excellent in Financial Product knowledge in Equity; Fixed Income (CDs, Treasury Bonds, Corporate Bond, Municipal Bond, Money Market, Repo); Structured securities, Derivatives: Futures, Forwards, Options, SWAP.

•Working knowledge about risk management models such as Basel III and CCAR, Dodd-Frank reform, and Credit Rating.

•Highly proficient in preparing Business and System Use Cases and supporting all the documents with UML diagrams. Able to build Use Case Diagrams, Activity Diagrams, Data Flow Diagrams, Sequence Diagrams, Process Flows using UML modeling tools such as MS Visio.

•Extensive knowledge of Agile Scrum, Rational Unified Process (RUP), Waterfall Methodologies with expertise working with tools, such as Rational Requisite Pro, Microsoft Office Suite, and HP/ALM Quality Center.

•Strong knowledge in the ETL (Extract, Transform, and Load) of data into a data warehouse and OLTP/OLAP systems and in the Erwin model for Conceptual, Logical, and Physical designs.

•Extensive experience in developing Business Requirements Document (BRD), Functional Requirements Document (FRD), User Stories, Use Cases, Test Cases, Test Plans.

•Experience in maintaining the Requirement Traceability Matrix and Test Matrix and developing Test Cases and Test Scripts. Managed end to end UAT for projects.

•Proven skills in writing SQL queries for Data Analytics and Business Intelligence. Creating and modifying databases for management purposes and creating custom SQL scripts for Data Conversion.

•Proven track record of excellent communication and presentation skills needed for interface with C level executives. Adapt to communication across the project team, including technical staff and offshore teams.

•A proven track record for performing independently and in teams. Managing teams in matrix environments. Expert at handling multiple projects simultaneously.

•Expert in quickly grasping business processes and act as a bridge between management and development teams. Experienced in the analysis and testing of web-based applications as well as mobile. Possess a detailed-oriented nature with excellent communication, problem-solving skills, and recognized for being a valued team player.

SKILLS

Technical

Software Development Life Cycle, UAT, Azure, Jira, ETL, AML, Agile Project Management (SCRUM)

Data

SQL, Tableau, PowerBi, SAS, SQL Server, Db2, DWH (Informatica)

Finance Domain

AML-KYC/CDD, AML-SAM, BSA, US Patriot, BASEL III, CCAR, Dodd-Frank, Credit Rating

Actimize

AML-CDD, Risk Scoring, CDD-HRC, CDD-INR, CDD-CIP, CDD-DOC, CDD-PRE, CDD-EBD, CDD-BOI, Dynamic onboarding, AML-SAM

Trade

Black Scholes Model Options Pricing, Binomial Model, Trade Life Cycle, Front, Middle, Back Office, Payoff Diagrams Holder & Writer

Securities

Equity, Fixed Income, Hybrids, Derivatives

Contracts

Strangle, Straddle, Spreads, Warrants, LEAPs, Greeks, Forwards, Futures, SWAPS, ABS, MBS

Markets

Primary, Secondary (Stocks, Bonds, Derivatives, Money (Repos), Forex, Commodity)

Testing

HP AML, QTP, LoadRunner, Selenium

API

Wolters Kluwer - MediSpan, FDA-Daily Med, Google Location, Google Maps, PayPal, Amadeus, SMS API, Open Graph, OAUTH

Visualization

Tableau, Power BI, Alteryx, @Risk, StatTools

Programming

SQL, SAS, R, Python, HTML, CSS, PHP, jQuery, JavaScript, C

Tools

Microsoft (Project, Visio, SSIS, SQL Server, Access, SharePoint, Excel, PowerPoint, Word), Jira, Rally, VersionOne, Bloomberg Terminal, HP AML

MRM/CRM

Microsoft Dynamics 365 Marketing, Salesforce

Soft skills

Communications, Presenting, Analytical skills, Proactive, Quick learner, Organizational Design, Business process design, Developing & implementing end-user training, Risk Management, Change Management

Volunteer

PACE Graduate Finance Club (e-board member), WhoWhatWhy (Business Analyst), PMI-NYC Chapter, PMI-NJ Chapter

Certifications

CSM®, SAFe Scrum Master, SAS Programming for R users, R Programming language, Bloomberg Market Concepts

EDUCATION

Pace University, Lubin School of Business New York, NY

MBA - Financial Management & Information System - CGPA: 3.75 September 2017 - May 2020

Relevant Coursework Business Analytics, Database Management Systems, Project & Change Management, Corporate Finance

Deen Bandhu Chotu Ram University Murthal, India

Bachelor of Technology – CGPA: 7.47/10 August 2009 - May 2013

CERTIFICATIONS & MEMBERSHIP

Certified SCRUM Master: by SCRUM Alliance (April 2020)

SAFe Scrum Master by Scaled Agile (May 2020)

SAS Programming for R users by Jordan Bakerman on LinkedIn Learning (January 2019)

R Programming language by Barton Poulson on LinkedIn Learning (January 2019)

Bloomberg Market Concepts by Bloomberg for Education (15 April 2018)

WORK EXPERIENCE

NEW YORK CITY – DEPARTMENT OF SOCIAL SERVICES New York, NY

Business Analyst July 2020 – Present

Writing SQL queries to download the recently expiring contracts data from SQL Server, communicating with vendors for contract renewals and continuation.

Setting up new contracts for Hardware, Software, and other product/services for NYC DSS and NYC HRA

Documenting the organization process workflows in MS Visio (Swin Lane Diagrams) by gathering requirements from the stakeholders, contract management staff, HRA staff, DSS office, and ACCO office.

Creating dashboards and reports using Microsoft PowerPoint and Microsoft PowerBI to present weekly contract reports to the senior executives.

NEW YORK CITY – DEPARTMENT OF FINANCE New York, NY

Business System Analyst/Scrum Master June 2019 – May 2020

The project scope is to automate the ECB Debt collection process for the violations tickets issued by NYPD, DOT, DOB, and other city agencies. A new CRM portal was developed for new incoming cases, and data is migrated from the legacy system.

Prepared the ETL mapping specifications to extract data from the existing system to the new system data marts under the specifications given by the subject matter experts.

Provided Data Mapping Documents by MS Excel for the automation rating risk score purpose.

Implemented Workflow Diagrams and Use Case Diagrams by MS Visio to help IT team to get a better understanding of the customized requirements.

Created Use-Cases and Business Use-Case Model after accessing the status and scope of the project and understanding the business processes.

Worked with the SQL database to analyze various queries to conduct data analysis.

Mined top priority parking violations & tax evasion cases using complex SQL queries, saving assessment cost by 40%

Identified nearly 800 previously unknown city park summons across all five boroughs of NYC by combining and analyzing a property, fire, buildings, police, mayor's office, & environment department's data with NumPy & Pandas libraries in Python

Reviewed and determined the eligibility of licenses and permits renewal by analyzing ECB debt using complex SQL queries and creating macros in excel to automate the process for DOF, DOT, DOB, and NYPD

Annual Report: Assisting with the creation of tables/charts for DOF collection rates, DOF inventory by financial year (FY 19: $209 M), DOF inventory by the issuing agency, revenue generated ($85.8 M), enforcement efforts, marshal and sheriff executions, and expired debt.

ECB Debt Treatment Flow and Collection Efforts: Assisting DOF and other City agencies (DOT, DOB, NYPD, etc.) in expanding reviews for ECB debt before agencies issue or renew licenses and permits.

Segmenting $782M debt owed to the city into seven buckets by organization type, property ownership, business license, and other leverage information, which helps city collectors to increase their collections, and design treatment flow.

Research and Marketing: Assisting with the analysis of current standard payment plans that are at risk of default and helping to develop SOP's for the unit to be utilized every year for the tax lien sale process.

THOMPSON & COMPANY Brooklyn, NY

Business Data Analyst June 2018 – May 2019

This project is aimed at building a Wealth Management Platform to connect Accountants, CPA, and Financial advisors.

Worked as a coordinator between business users and system developers to collect business requirements and support in system design/development/test/implementation.

Responsible for use case analysis, BRD/FRD documentation, diagram creation, dynamic testing, user manual preparation, and client training.

Communicated with business sponsors to elicit business/functional requirements and generated use cases following Waterfall Best Practices.

Conducted brainstorming sessions to extrapolate the requirements that are not stated.

Used UML methodology to capture, analyze, and translate business requirements.

Developed business Use Case scenarios, conducted use case analysis, and created use case/sequence/activity diagrams.

Documented BRF/FRD and explained the functional and nonfunctional requirements to developers.

Assisted in requirement verification and validation during various phases of the Software Development Life Cycle (SDLC).

Participated in the black-box test, regression test, and system integration test (SIT).

Created the user manual and provided onsite training to the end-users.

Tools & Technologies: SQL Server, Jira, HP Application Lifecycle Management (ALM), MS Access, MS Excel, MS Visio

CLIENT: BARCLAYS CAPITAL Off- Shore

Business Data Analyst February 2016 - June 2017

This project involves in implement customer risk assessment in Know You Customer (KYC) process to comply with Anti Money Laundry (AML) regulations, including data processing, information verification, workflow and process design, risk assessment modeling, to help the bank understand the Inherent Money laundering risks posed by customers and make more informed decisions and consistent monitoring on customers risk exposures.

Performed as liaison between bank's Anti Money Laundry (AML) team/data scientists and IT system developers.

Responsible for gathering and analyzing business requirements, designing risk assessment solutions in different stages of KYC process, and assisting in system development/implementation/migration/testing.

Participated in requirement gathering, data processing, information verification, risk parameter and table creation, workflow and process design, risk scoring and modeling, and function integration.

Based on the AML regulations, gathered, analyzed and allocated the business requirements in the KYC workflow, including Customer Due Diligence (CDD), Enhanced Due Diligence (EDD), and continuous monitoring of customers, by conducting document analysis, brainstorming, personal interviews, and e-mail survey.

Detailed the user stories in different stages of the KYC process, including Deployment Initiation, Real Time Account On-boarding, Account On-boarding, and Re-review.

Designed the risk assessment solutions to Identification of Customers, Identification of Interested Parties, Customer Identification Programme (CIP), Watch List Scan, Negative News Search, Other Parameters of the Risk Models, and Determination of the Customer's Effective Risk (CER).

Completed in-depth analysis of the matching logic and take steps for optimization and tuning of the process to determine the optimum threshold level, to minimize the false positives.

Assisted in data profiling and data quality checkup on the data for multiple functions to ensure it met the specified business rules and standards set within the organization.

Applied performance tuning and optimization of queries, stored procedures, scripts and in-depth analysis of indexes and their tuning in order to improve the overall speed and efficiency of the system.

Established and documented the Real-Time Account Onboarding Risk Parameters, Rule-based Assessment Model Parameters, Algorithm-based Assessment Model Parameters, and Accelerated Re-Review Rules.

Supported in building the Rule-based and Algorithm-based Assessment Models to quantify Real-Time Account On-boarding Risk (RAOR).

Explained the risk assessment process and models to developers, and helped with the application development, system integration and migration.

Conducted regular review of the Function and Technical Specifications to reflect the latest changes and enhancements to the product owner.

Guided the users to finish the user acceptance test and provided advice or solutions to the existing or possible risks and issues.

Tools & Technologies: Agile SCRUM, UML, MS Word 2007, MS Excel 2007, MS Project 2007, MS PowerPoint 2007, MS Visio,

CLIENT: HDFC BANK New Delhi, India

Business Data Analyst October 2014 - December 2015

The scope of the project was to implement NICE Actimize (SAM/CDD) solutions according to the requirements of the AML operations of HDFC bank. It involved execution of various AML scenarios with respect to structuring of the cash deposits, cash intensive businesses, trade-based laundering, shell companies and trusts, round tripping, Deposits through casino winnings, Fictional Loans. The core objective of the project was to prepare CTR and SARs as per the AML compliance requirements.

Understood the AML compliance requirements by interacting with compliance department, and SMEs.

Lead the team in requirement gathering and managing the requirements using JIRA, which included questionnaires, interviews, brainstorms and meetings with stakeholders, Business users, and compliance department and SMEs.

Studied the existing KYC/CIP system and prepared the test data for the CDD and EDD based on the inputs.

Created the data mapping from the transactional data to the Actimize tool.

Prepared the reporting formats for the regulatory filings for internal use and helped the Actimize team to produce the SAR reports.

Performed testing on generation of compliance reports (SAR/ CTR) to the regulatory agencies and internal systems

Understood the business logic, User requirements and test-objectives to develop test plans, test cases, and test case execution using HPQC.

Participated in Defect-Review meetings with developers, QAs, managers and suggested enhancements to the existed application from business perspectives.

Conducted UAT to make sure that all the user requirements are catered by the application.

Tools & Technologies: Agile SCRUM, UML, MS Word 2007, MS Excel 2007, MS Project 2007, MS PowerPoint 2007

BLACK BUTTERFLY WEB DESIGNER PVT. LTD New Delhi, India

Business Analyst & Project Manager June 2013 – Aug 2014

Planned and tracked financial & wealth resources and establish a structured approval process using Siebel MRM

Replaced the hospital's existing system with the TriZetto® Facets® core administration platform for more cost-efficient processing

Lead the development and client service team of four creative and technical people; we were responsible for client service, documentation of the business process, software development, and testing, for approximately 200 companies.

Executed advertising campaign on Amazon India, which generated a wealth of over $1M at a 2% cost of sales.

Documented and wrote content for the supply chain, customer support team, operations, advertising campaigns, and product development for the e-commerce division of the company.

VOLUNTEER EXPERIENCE

WhoWhatWhy New York, NY

Business Analyst Volunteer (Remote) April 2020 - Present

Implemented communication channel organization-wide by evaluating costs, benefits, and functionality of various web conferencing tools and saved over $25,000 per year for the organization. Developed analytical frameworks and models to optimize performance and process efficiency.

Built and managed reports showing the health of key business metrics across platforms.

Managed end to end analytical projects – to conduct analysis, research customer and industry reports to recommend new strategies, and then to lead the initiative and monitor its impact.

Build reports in Google Sheets and Microsoft Excel as well as using dashboard technologies to represent data visually.

Collaborated with the editorial staff to help drive media for growth, develop new strategies and communicate results, and provide marketing and editorial with data-driven insights around the types of stories and content that resonate with users

Assisted the team with optimization projects related to subscriber engagement, email marketing, website conversion, subscriber retention

Managed projects for core functional areas by preparing and maintaining implementation plans, managing project issues, and ensuring project tasks are completed.

RELEVANT COURSEWORK

Accounting for Decision Making, Globalization, Marketing Management, Business Analytics, Managerial Finance, Macroeconomics, Organizational Behavior, Advanced Corporate Finance, and Managing Innovation, Project & Change Management, DBMS, Corporate Finance, Mergers and Acquisitions, FX Trading, Financial Risk Management, Financial Analysis, Mergers & Acquisitions.

ACADEMIC PROJECTS

ROKU VALUATION: Valued Roku by analyzing financial data of 8 comparable companies & created mean, median, bullish & bearish scenarios; suggested $2,210M enterprise value & $30.64 share price as target acquisition price as of November 2019.

NYC PROPERTIES: Designed a relational database of 1000 properties in Microsoft Access by analyzing NYC open data and generated 11 reports by writing 18 SQL queries and eight forms; Reports can be searched by tax class, property details, and owners' demographics.

Other Relevant Projects: GM Risk Management, NIKE Hedging, Easy Rent Pay, US Current Account Deficit, Respire – Resume Builder

LEADERSHIP & ACTIVITIES

Organized campus events as an e-board member of Pace Graduate Finance Club during Fall 17 and Spring 18.

Worked on a project for Animal Rights and volunteered for an event organized by 'People for Animals' in Chandigarh.

Won a silver medal in Sahodaya state-level inter-school chess competition.

Helped to launch a new singer by organizing an event at the university cultural festival.

Contact this candidate