Nikita Patel

Phone: 347-***-**** Email: ad4la3@r.postjobfree.com

Visa Status: US Citizen Location: Allen, Texas

Business Analyst/Data Analyst/Product Owner

OBJECTIVE

Accomplished business & data analyst with a passion for delivering valuable data through data visualization, analytical functions and data retrieval methods using business tools and dashboards. Proficiency in Team interfacing activities such as discussions/workshops, Daily scrum call, presentations, product walkthroughs and preparation of related documentation as part of stakeholders, senior management interaction. With hands on experience working side by side on multiple projects simultaneity. Strong written, verbal and presentation skills; ability to present and discuss strategies and technical information, and establish understanding for technical and non-technical audiences Leading collaboration with Business Stakeholders, IT infrastructure & Dev teams to ensure business requirements are met through proper system configuration. Along with all, monitor all types of any Fraud or Risk related issues and activities being done throughout with the data being used and presented

Utilization of Business Intelligence Tools

Daily SCRUM Calls

Gap Analysis, KANBAN

JIRA stories, JIRA Dashboard, JIRA Horizon

Fraud and Risk Litigation Issues

Credit Risk, lending, various diff regulations

Requirement Analysis

Stakeholders’ business Gathering

Data Analytics

Project Documentations

TECHNICAL SKILLS

Technical: Data Manipulation and Visualization, MS-Office Expertise (Excel, Word, PowerPoint, Visio, Access), Knowledge of JIRA applications, business documentations, creating meeting minutes,

Script Languages: SQL

Reporting Tools: Business Intelligence, Excel (VLOOKUP, power query, tables, chart), BIAMR tool (Business Intelligence and Metric Reporting) COGNOS Reporting

Business Platform Applications: HUE (cloudera), Arcadia, ROCK, RSAM/TRAM, SharePoint Site, GIS Dashboard, Cloudera Visualization(CDV), Process Owner Portal (POP- data based on Tableau) ARIS Model Tool

PROFESSIONAL CERTIFICATIONS

Microsoft Certified Solutions Associate – BI Reporting

Microsoft SQL Server – Querying Data Using T-SQL

Microsoft Analyzing and Visualizing Data with MS Excel

PROFESSIONAL SKILLS

Exposure to the Gap Analysis, Requirement Gathering, Risk Analysis, Vendor management and Change Management

Requirement gathering, co-ordination with business heads, setting priorities.

Designing, creating and publishing customized interactive reports, dashboards using Business Intelligence tools

Excellent research, investigation skills and good judgement skills.

Use of calculated measures, calculated columns, slicers, filters, DAX formulas, groups to create reports in Power BI and excel

Built dashboards for measures with forecast, trend lines and reference lines.

Data Extraction, Transforming and Loading (ETL).

JIRA standups, writing detailed stories, working in KANBAN,

Utilized Excel functionality to gather, compile and analyze data using vlookup and pivot tables.

COMMUNICATION SKILLS

Presenting graphical data using KPIs

Drawing consensus on research priorities

Facilitating group discussion

Writing stories, documentation and Presentations

Technical writing, setting up meeting with staff via Skype and WebEx

Pitching proposal

Teamwork

Listening,

mentoring coaching, training new and existing team members

Leadership

WORK EXPERIENCE

Apex Systems

Bank of America, Addison Texas

Business Analyst V – Contractor November 2023 – March 2024

Working in GIS- Cyber Security and Risk Management

Conduct multiple types of Monthly Reporting as required per Management

Work on any types of Fraud or Risk related issues and present to the management team for review

Create large set of reporting using COGNOS, Excel extract to present to senior management

Create PowerPoint Presentation Decks for monthly Sr/ Executive level forums

Create Meeting Notes from the monthly forums as per guidelines

Train, mentor and coach new and existing team members

Create READ ME Files (word documentation on “How To” based on the role and requirements step by step to follow to compete the tasks, reports, and projects)

Set up meeting with team members to discuss reporting, task and project via SKYPE and WebEx platforms

Assist Sr Management to complete monthly Metrics reports from start to finish via creating reports in excel, PowerPoint and word to present to Sr Management and team

Point of Contact/Subject Matter Expertise (POC/SME on various projects)

Submitting intake requests and pulling reports weekly basis on SharePoint Site

QA Analysis on Metric Playbooks as per request

Work and run analysis on different types of Common and Unique Process involved internally

Work on Process Owner Portal(POP) for making all kinds of updates regarding the internal common or unique model

Work on ARIS Model to release the process map upon request

Creating weekly Single Process Inventory Report (SPI Internal Process report) for management and team members use

Staying on top of the all the job aids being used and making all the necessary updates where needed

Work on follow up emails as per request

Apex Systems

Bank of America, Addison Texas

Business Analyst V – Contractor March 2023 to November 2023

Working in GIS, Cyber Security and risk management environment

Part of Metric Governance and Operating team, Risk Governance, Maintain GIS Metric Governance Mailbox via Outlook

Provide business consultations to Metric Owners, Delegates, Process and Control owners to execute their requirements

on Metrics

Staying on point regarding any type of fraudulent activities and any related issues

Documentations on monthly Audit Forums including any types of Fraud and Risk related issues, Senior Executive Risk Committee, and sending out meeting minutes as required by Management team

Attend the following meeting on a regular basis: - Weekly Peer Reviews, Manager Team meetings, Business Partners meetings, monthly Audit and Senior Executive Risk Committee meetings as required

analyze and translate the business needs and assess the feasibility for enhancements to existing applications

elicit and document the business and functional requirements, generating process/data flow diagrams, and crafting quick user guides, and job aids.

analyzing the impact of the proposed solutions across the business, develop use cases to explain/demonstrate the business requirements/specifications to the IT team, and contribute a business or process perspective during design reviews

Ability to communicate clearly and effectively with both technology/development and business partners - ability to translate between these two constituencies

Information Security, Auditing, and Control Function

Understanding of how technology interacts with other technology

Heavy data analytics background (manipulation of data within Excel)

Highly organized and motivated to deliver results with minimal direction

Creative and proactive problem solver - ability to understand what the team needs and offer suggestions above and beyond what they desire

ability to quickly become the authority in the various data and systems used by the team

Strong relationship, team building and facilitation skills via SKYPE and Webex

Proficient with Microsoft Office (Word, PowerPoint, Excel) and Visio

Experience in Technical Documentation, creating PPT presentations to create metrics used by Metric Owners, Process and Control Owners as needed

Ability to conduct information gathering meetings with Senior level metric owners, Process Owners

Excellent ability to track details, but summarize thematically (verbal, written, PowerPoint)

Experience in Governance, Audit and/or Testing

Intellectually curious about Info Security for BOFA

Successful and comfortable with: high visibility efforts

multiple, competing and ever shifting priorities... including the occasional fire drills

iterative and continuous improvement mindset

Submitting request to be completed via BIAMR tool as per business partners request

Bandwidth to working on other colleagues’ projects and take it to full completion due to Audit issues

Assist other team members in Performing QAs on Metric Playbooks as needed

Present All types of Metrics on PPT to Peer Review, Business Partners, Metric Owner, Process Owners, Control Owners, and Senior Executive Manager for Approval

Apex Systems Contractor May 2021-November 2022

Bank of America, Addison Texas

Business/Data Analyst

Gathering requirements, designing and implementing solutions for business needs

Data cleaning, data mining from primary and secondary sources then reorganizing data in a form that makes it simple to understand

Monitoring large set of data regarding Fraud and Risk related activities

Identified and drove implementation of continuous improvements within the project team.

Assisting developers, Scrum Masters, Project manager in gathering data and requirements for project

SMEs on the projects assigned and currently in progress

Par take in stakeholders’ meetings and demo to collect data, and prepare reports that present manager how the data could be applied in the project

Work on gathering requirements into technical specs, and business workflow for data ingestion, automation

Create and present PowerPoint deck to management in regard to project analysis

Provide insight on the data gathered and how it can be resourceful to the business and clients

Work on data flow diagram and designing the business model using PowerPoint, Visio

Work together with other departments in the company collecting and analyzing data as needed using Microsoft Excel, PowerPoint

Use JSM (JIRA System Management) for data flow diagram and processes for each application tool and work on JIRA tickets on daily basis to keep track of the project work

Create clear and accurate documentation for developers, engineers, data scientist, and all the other stakeholders to understand the analyzation process

Debrief with the management during the week on the status of the data workflow projects, gathering and requirements

Providing Knowledge Transition to business explaining new business processes

Requirement management, performing impact and gap analysis using existing data and provide solution design.

Responsible for Story points estimation and allocation based on relative technique.

Working with development center team to estimate work effort throughout different phases of the functional domain deliverables.

Participating in meetings with business and development, production support teams on product enhancement and development planning calls, evaluate and coordinate production incidents escalations.

Bank of Texas, Texas Sept 2019 – May 2021

Senior Relationship Banker

Ensured all personal and business account opened at our branch were in compliance

Monitor day to day business activities for Fraud and any type of Risk Issues

Performing Maintenance on personal and business accounts

Process applications for all kinds of lending including personal and business needs keeping in mind that it meets all the Credit Risk and Lending Regulations when going through the process

Providing Credit Risk and Lending and Regulations disclosure to all types of lending loans being worked on including Reg Z, FHA, HDMA etc)

Promotes the bank’s product and services; consistently cross-sells bank products at every client opportunity

Adhere to branch policies and procedure when it came to BSA, CTRs, OFAC listing and Patriot ACT

Submitted SAR reporting to prevent any types of Anti-Money Laundering (AML), monitor any fraudulent activities and any miscellaneous crimes

Excellent analytical problem solving and decision-making skills to uncover and resolve customer issue in timely manner

Promote and maintain positive relationship with all clients and potential clients

Contribute to the fulfillment of department and company objective and goals

Assist customer in Non-Sufficient Fees, fraud against the accounts, any other legal matter

Review all types of checking accounts before submitting to Legal for any missing information as state regulation and laws

Staying current on all the operational compliance, states laws and regulations in the financial institution

Work with operation departments when needed support and report any types of suspicious activities occurs in clients’ accounts

Knowledge in operation functions including loss control, compliance, and customer retention and audit standard

CresCom Bank: Greenville SC June 2018 to August 2019

Universal Banker

Opening and closing the branch

Cross-trained as Customer Service Representative and Teller

Perform maintenance on all personal and business accounts

Cross-sell all bank products

Order cash/do monthly audit paper work

Team Player

Staying on point on Fraud and Risk related issues

Balance and closed the branch end of the day

Process applications for all kinds of lending including personal and business needs keeping in mind that it meets all the Credit Risk and Lending Regulations when going through the process

Providing Credit Risk and Lending and Regulations disclosure to all types of lending loans being worked on including Reg Z, FHA, HDMA etc)

People’s United Bank: East Hills NY May 2015 – March 2018

Sales & Service Supervisor

Opening up personal and business accounts

Performing Maintenance on personal and business accounts

Process application for all kinds of lending including personal and business

Adhering all type of Fraud and Risk Related issues and present to management

Process applications for all kinds of lending including personal and business needs keeping in mind that it meets all the Credit Risk and Lending Regulations when going through the process

Providing Credit Risk and Lending and Regulations disclosure to all types of lending loans being worked on including Reg Z, FHA, HDMA etc)

Adhere to branch policies and procedure when it came to BSA, CTRs, OFAC listing and Patriot ACT

Submitted SAR reporting to prevent any types of Anti-Money Laundering, monitor any fraudulent activities and any miscellaneous crimes

Work with operation departments when needed support and report any types of suspicious activities occurs in clients’ accounts

Led the team to meet company goals and objectives

Completed all the training regarding OFAC, BSA, AML on a quarterly basis

Promotes the bank’s product and services; consistently cross-sells bank products at every client opportunity

Perform weekly audits on ATM, monthly audits on Cash boxes and quarterly audits on Negotiable items

Cross-sell other banking products during account opening or performing any service on clients account

Run branch meeting under management every week

Team player

Balance & proof the cash vault daily

Balance & close branch at the end of the day

Coach my team where it is needed along with delegate projects to the staff when needed

TD Bank, Farmingdale, NY June 2014 – April 2015

Financial Service Representative

Selling and cross-selling insurance products to new and existing clients

Assist and recommend proper insurance products and services based on customer needs along with performing maintenance on clients account

Direct contact to client in regards to their financial needs in the branch along with their personal banking needs

Coach tellers with cross selling products along with assisting them with referral to insurance products and banking products

Manage the staff during in absence of management and took managerial decision

Monitor all types of Fraud and Risk related issues

Adhere to branch policies and procedure when it came to BSA, CTRs, OFAC listing and Patriot ACT

Submitted SAR reporting to prevent any types of Anti-Money Laundering (AML), monitor any fraudulent activities and any miscellaneous crimes

Process applications for all kinds of lending including personal and business needs keeping in mind that it meets all the Credit Risk and Lending Regulations when going through the process

Providing Credit Risk and Lending and Regulations disclosure to all types of lending loans being worked on including Reg Z, FHA, HDMA etc)

Completed all the training regarding OFAC, BSA, AML on a quarterly basis

Excellent analytical problem solving and decision-making skills to uncover and resolve customer issue in timely manner

Open and close bank, combos to all the vaults in the branch

Open/close personal and business accounts

Process lending application such as credit cards, mortgages, home equity and personal loans

cross-sell all banking products

adhere with compliance, audit and security with policies and procedures

sales in the branch and a team player

Capital One Bank, Floral Park, NY September 2011 – May 2014

Relationship Banker/Branch Designee

Open/close personal accounts and business accounts

Open credits cards, debit cards, and safe deposits boxes for customers

process personal loans, home equity line of credit, auto loans and mortgage applications

follow compliance, audit and security with policies and procedures to banking

staying on point on all types of Fraud and Risk Related incidents

Process applications for all kinds of lending including personal and business needs keeping in mind that it meets all the Credit Risk and Lending Regulations when going through the process

Providing Credit Risk and Lending and Regulations disclosure to all types of lending loans being worked on including Reg Z, FHA, HDMA etc)

Bring in referrals for Investments and Insurance to the Financial Consultant

Process fixed deposit CDs for customer in lieu of opening and closing, and CD renewal

up-sell the latest bank products to customers

promote and offer new bank products to customers

process maintenance on customers’ accounts

process wire transfers international/domestic incoming/outgoing

handle fraud related issues regarding customers

meet customer needs at all times

coach tellers about bank products for referrals

opening and closing the branch adhering proper procedures

Adhere to branch policies and procedure when it came to BSA, CTRs, OFAC listing and Patriot ACT

Submitted SAR reporting to prevent any types of Anti-Money Laundering (AML), monitor any fraudulent activities and any miscellaneous crimes

Completed all the training regarding OFAC, BSA, AML on a quarterly basis

EDUCATION

County College of Morris, December 2006

Associates in Applied Science in Business Administration &

Computer Information Systems

Contact this candidate