Data Analyst Business

Shivam Mathur

Email: ************@*****.*** Phone: 631-***-****

PROFESSIONAL SUMMARY

A data solutions architect with over 20 year of experience in designing strategies for data solutions, cloud data security, and cloud migration. A techno-functional expert enabling business and technology teams to take appropriate decisions about solution selection and technical approach. A strong team-builder and keen problem solver.

SKILL HIGHLIGHTS

Technologies

Business Domains

Data solution design, Data analysis, Data management, and modeling

AWS database migration strategist and Cloud Data Security planning

Advance SQL and NoSQL – Oracle, SQL server, MongoDB

Data solutions tools – SAS, Python, Shell scripts, .Net, Stored procedures

Reporting – SSRS, SAP BO (Crystal Reports), OBIEE, Tableau

API integration

Financial Crimes and Fraud Prevention

Customer Authenticaton-Authorization

Retail Banking

Consumer Lending

Business Process Management

Technical project management

Executive level reporting

Techno-functional expert

Delivery of complex data projects and programs

PROJECT EXPERIENCE

Enexus Global (Wells Fargo Bank), Charlotte, NC Oct’21 – Present

Role: Data Solution Architect

Description: Data solutions and reporting of consumer lending data

Responsibilities:

Design data solutions for consumer lending using SAS Enterprise Guide to generate data after combining data from multiple SORs.

Design solutions based on TOGAF framkework.

Design and develop ETL pipeline between SAS-Teradata-SQL Server, using SSIS ETL package and Python scripts

Design data models using ERWIN

Desgined Python based data generation model to automatically include new data elements from configuration files

Automated and optimized data lineage and acquisition process from mulitiple SORs.

Optimized report requesting workflow to operate on a self-serve model

Developed data management strategies – restructured data storage structure of large string data field consuming 85% of space – reduced to 56% storage space

Helping business achieve operational efficiencies by identifying and optimizing technical workflows that are creting bottlenecks prior to migration

Developing data archiving and restoration strategy to and from Cloud environment

Code version control and deployment using Github anfd Jenkins respectively

Enexus Global (BNP Paribas, Bank of The West), CA Feb’21 – Oct’21

Role: Senior Technical Analyst

Description: Tier 2 application and data migration

Responsibilities:

Developed ingestion process for online account opening risk data for fraud review, using Python API call to FIS

Designed real-time account balance web-services call for loss mitigation services

Designed authentication and authorization events data sync between applications for suspicious activity review

Mapping business workflows to technical workflows and with the underlying data sources

Develop data migration scripts using SQL stored procdures, and Python Bonobo ETL framework

Develop data field mapping strategy to store mapping meta data as configuration for migration scripts

Tuned HiveSQL queries to retrieve ACH transactions processed in Hadoop

Design and optimize data lineage for data collected from multiple sources

Utilizing SAS 9 for creating new data models for the target environment after matching and merging legacy data with target data.

Migrate data acquisition pipelines from PERL to Python

Helping business achieve operational efficiencies by identifying and optimizing technical workflows that are creting bottlenecks prior to migration

Arrange discussions with technology leadership to help identify Cloud migration opportunities

Enexus Global (Wells Fargo Bank), Charlotte, NC Apr’20 – Jan’21

Role: Senior Data Analyst

Responsibilities:

Used SAS 9 for data cleaning and synthesizing by creating data hashes using sha256 encryption

Generated data insights using SAS 9

Created new anomaly findings data structure for various alerting strategies

Developed python scripts for data acquisition

Invoked SAS stored procedures from Python

Transferred Python Pandas dataframe into SAS dataset

Synechron Inc. (Wells Fargo Bank), Charlotte, NC Apr’19 – Feb’20

Role: Senior Business Analyst –Business Consulting

Responsibilities:

Analyze existing fraud-tech capabilities and compare the maturity model with peer banks

Recommend best industry practice and introduce emerging technologies in fraud technology management for Asset Management

Provide a 12-month roadmap for implementation of strategic recommendations and product enhancements

Product evaluations and recommendations for upgrade or retire

Provide recommendations for application rationalization

BNP Paribas, Bank of The West, San Ramon, CA Dec’12 – Apr’19

Role: Data Solutions Architect (FTE)

Managed multiple projects that provide business technical requirements and user acceptance testing support for projects over ~$10MM.

Responsibilities:

Successfuly managed a complex, multi-location software integration project

Provide lead coordination of User Acceptance Testing for several projects across several programs within Financial Crimes space

Managed several large-scale cross-platform software implementations and upgrades

Work with other Scrum masters and program manager to manage any interdependencies

Design data integration architecture for new data sources

Designed large ACH file processing in Hadoop Couldera environment.

Designed processes to retrieve data from Hadoop using HiveQL and feed then into relational database.

Design and implement new features on Mantas, Actimize and Detica products – integration architecture

Design TOGAF framework based data solutions architecture

Perform agile project management activities including planning, execution, tracking and reporting

Participated in developing company Systems (Software) Development Life-Cycle methodology

Successfully developed process to track and surface interdependencies within Trust and Safety Deparment

Managed a project portfolio of ~$12MM in automated OD processing area

Vendor SOW management and reviewing of invoices

Participate in requirements gathering and convert them into technical specification documents

Co-ordinate creation of implementation plans and orchestration with technical actions

OFSAA infrastructure platform support processes and methodologies with respect to environments, user security, object migration, data model maintenance, patching and upgrades

Rules configuration methodologies of PFT and GL Recon configuration

OFSAA Technical expertise on building T2Ts, F2Ts, PR2 framework, SCDs and excel uploads

Develop Python and SQL based data pipelines for Fraud Data analytics

Develop data transformations like Address Nomarlization using Python

Scenario Development, Unit testing and Data mining Using Oracle Mantas Scenario Manager.

Analysis of the Issues reported for coding, unit testing and reviews.

Unit testing of scenarios on UNIX boxes using shell scripting and UNIX commands.

Strong experience on coding SQL and Oracle PL/SQL procedures, functions, packages and Triggers.

End to End Oracle Mantas suite of products Installation, Implementation and support.

Standard Chartered Bank, Africa, Dubai and India Nov’11 – Aug’12

Project: Global Compliance Solution Implementation

Role: Technical Lead – Detica NetReveal SME (formerly Norkom), Oracle Mantas

Description: At Standard Chartered, a multinational bank, worked as Technical Project Manager to deliver Anti-Money Laundering program across the global footprint of the bank.

Responsibilities:

Liaised with business project team in gathering requirements, functional specifications and operational procedure documentation. (Administered SDLC)

Drive meetings to get tasks completed by international teams

Lead the team through the data requirements, data mapping, construction, UAT and production roll out phases.

Responsible for creating work breakdown structure using predictive project development methodology, ensuring configuration/change/release management of key deliverables.

Responsible for the deliverables/reviews of offshore team for Anti-money laundering, Trading Compliance, Broker Compliance, Fraud solution set of Oracle Mantas.

Co-ordinate creation of implementation plans and orchestration with technical actions

Techno Functional expertise on OFSAA PFT/GL Recon and end to end installation, implementation and support.

End-to-end implementation, customization, data integration and rollout of Detica NetReveal product.

Creation of detection rules using Scenario Manager – Detica, Mantas

Customize investigation operations workflow for Alert and Case Management

Risk and Issues tracking, project status tracking and reporting to program stakeholder

Develop Python and SQL based data pipelines for transactions monitoring

Develop ETL transformations using Python Dask library to process large data files

Tieto Jul’10 – Nov’11

Role: Technical Lead

Clients: Handels Bank, Finland & Tieto, India

Responsibilities:

Design real-time financial transaction monitoring (domestic and international) solution using Python, PYML (Python Markup Language) and Oracle 11g, SEPA payments integration

Analyze and fix lending application security vulnerabilities developed on Python, PYML

Project deliverables planning, project status reporting to stakeholders, hire and train developers on python

Capgemini Jun’07 - Jul’10

Role: Senior Consultant

Clients: Nordea Bank (UK), Prometric, Baltimore, MD

Responsibilities:

Develop analytical reports using Oracle Reports, Tableau and Crystal Reports

ABN Amro Bank, Singapore May’06 – Jun’07

Role: Associate

Responsibilities:

Finacle (from Infosys) customization, Advance SQL queries creating for reporting, PL/SQL programming and PERL scripting

IBM - India Apr’05– May’06

Role: Analyst

Responsibilities:

PL/SQL programming and Hyperion reports development

Nelito Systems Jul’04 – Apr’05

Role: Technical Lead

Client: Multiple large banks, India

Responsibilities:

Core banking application Finacle (from Infosys) customization and implementation, and train business users, PL/SQL programming

STG Limited Apr’03 – Jul’04

Role: Software Engineer

Client: Multiple large banks, India

Responsibilities:

Core banking application Finacle customization and implementation, and train business users, PL/SQL programming

HDFC Bank, India Aug’01 – Mar’03

Role: Associate

Responsibilities:

Data Center monitoring, Finacle application support, SQL queries for reporting, PL/SQL programming, PERL and Shell Scripting

EDUCATIONAL QUALIFICATION

Bachelor of Commerce (Accounting and Statistics), Delhi University, Delhi, India

Diploma in Software Development, NIIT New Delhi, India

CERTIFICATIONS

Certified Fraud Examiner (CFE) – Association of Certified Fraud Examiner, Texas

Certified Information Security Manger (CISM) – ISACA

IBM Certified Data Science Professional – Coursera

Certified Cloud Security Professional (CCSP) from ISACA

Contact this candidate