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