SUMMARY:

Senior Level Information Governance and Technology Experience in Financial Industry Applications. Involved in complete Life Cycle (SDLC, Agile, and Waterfall) Development Model in the capacity of Enterprise Information Architect, Data Governance Analyst, Data Analyst/Technology Lead.

SKILLS:

ADS

Data Analysis

Data Analyst

Data Integrity

Data Migration, database

Database Modeling

Data Modeling

Data Models

DDL, MS SQL Server, SQL Server

OLTP, Oracle, PL/SQL, SQL

Stored Procedures

Apache Hadoop Sqoop

Sqoop, CDH

Data Analytics

Data Architecture

Data Governance

Data Integration

Data Management

Data Mart

Data Science

ETL, Hadoop

Kafka, Machine Learning

Massively Parallel Processing

MPP, Master Data Management

MDM,Reference Data

Teradata, Application Architecture

Dimensional Data

Enterprise Architecture

ER WIN, erwin

Life Cycle

Powerdesigner

Requirement Gathering

SDLC

USE Cases

Security, unix

Amazon Web Services

AWS

Real Time

Visio

Microsoft SSRS

SSRS

Microstrategy

SAS

RDBMS

Information Security

Secure File Transfer Protocol

SFTP

Data Warehouse

Data Warehousing

GIS

Provisioning

EDW

Data Quality

Java

NDM

Billing

MATLAB

Architecture

Information Architecture

Information Architect

Prototype

Prototypes

Integrator

Integration

Best Practices

Metrics

Problem Solving

Retail

Pipeline

Accounting

GL

Audit

Audits

Financials

Regulatory Reporting

EDM

Finance

Credit Card

Credit Cards

Derivatives

Quantitative

Loans, maintenance

Process Flow

Business Intelligence

BI

Marketing Analysis

Retail Marketing

Serial Attached Scsi, excel

Microsoft Powerpoint

PowerPoint

Governance

Vendor Products

Exploration

Performance Tuning

EXPERIENCE:

Confidential

Senior Architect

Responsibilities:

• Architected, Designed and Lead the development of AWS Cloud based Data Migration Efforts for Confidential Project.
• Started as first member of Data Migration Project, went on to architect & design the tools, processes, developed prototypes, hired & trained resources, lead the development efforts for successful implementation.
• As part of recognition of my efforts I was promoted to VP position.
• Developed Standards and Best Practices guidelines and reviewed the implementations.

Confidential

DATA Analyst/Tech Lead/Architect

Responsibilities:

• Working extensively on Strategies/Certifications for Authorized Data Strategy (ADS) and Enterprise Data Management principles.
• Successfully conducted PRC reviews and IA - centric EDM/ADS compliance checks and reviews for multiple releases.
• Authorized Data Sourcing (ADS): As a being Risk Architecture I have been extensively involved in Identification, Evaluation and Certification of different System Of Records (SOR) being the ADS for uniformity and accuracy of the data across the bank.
• As part of the initiative the Applications were tracked for not being ADS Compliant and the Technical Debt was registered and resolved in timely manner.
• Proof of Concepts: Lead the Proof of Concepts on HSP platform for Spark 1.5 which included Data Frames, Spark SQL, RDDs from start to finish, working with Platform Team and App teams. The Spark PoC was conducted for various business use cases such as Aggregations, DQC and CDC Processes.
• The detail PoC document was prepared with very clearly defined success criteria.
• The Spark PoC was successful in terms of its recommendation for adoption.
• Worked on providing the outline and content for Hadoop reference Architecture project, contributing to different aspects of Risk Hadoop Reference Architecture including Data Processing, Security, Best Practices and Standards.
• Working extensively on Logical/Physical Data Modeling (Relational and Dimensional) for Business User Reports for Accounting View of the Risk matrix.

Confidential

Sr. Data Analyst

Responsibilities:

• Worked on NETEZZA TwinFin Data Warehouse Appliance with NPS version 5.x, 6.x. extensively used nzSQL for DDL, DMLs and nzPLSQL for Stored Procedures.
• Used nzLoad and External Tables to Transform and Load the data into Netezza DB.
• Used CLI for various commands.

Confidential, Charlotte

Sr. Data Analyst/Architect/Sr. Consultant

Responsibilities:

• Lead the Data Architecture/Integration and development side efforts in mission critical FOMC / GL Integration Project for merger of legacy Confidential and Wachovia systems, part of Confidential Finance Data Mart/Data Warehouse.
• Supported ReconWeb Integrated Reporting (RIR) data warehousing application for historical data analysis and reporting.
• Worked on Data Integration for Load Batch jobs, Online Data Validations and Interface processes using techniques such as snapshots, migrator process, exception capturing and tools such as SQL, PL/SQL packages, Functions, UNIX scripts and Autosys scripts.

Confidential

Sr. Technical Analyst

Responsibilities:

• Involved complete life cycle involving Planning, Requirement gathering, Development, Testing, Release and Maintenance of the medium and large size applications.
• Extensively involved in tuning the applications at Code and Database levels.
• Worked on NETEZZA NPS Data Warehouse Appliance with software version 4.x, 5.x extensively used nzSQL for DDL, DMLs.
• The IDE tools used were CLI, WinSQL to for DDL, DML statements in large size (25TB) EDW for Billing System/Customer Data serving multiple Data Marts
• Some of the challenges overcome are complex data mappings and converting large amount of data in short duration, by using techniques such as data splitting, incremental loading and speeding the process by tuning the tables and SQLs for better performance.