SUMMARY

• Over Eight years of Experience with Business/Data Analysis/Visualization/Analytics systems.
• Understanding and knowledge of CCAR / Basel concepts - Credit Risk, Liquidity Risk.
• Experience working with Financial Banking systems dealing in Trading, Capital Markets and Reference Data, Data Governance.
• Extensive knowledge of various asset classes like Loans, Leases, Deposits, Equities, Derivatives.
• Good understanding in Performing Exploratory Data Analysis using Statistical Tools (R, SAS, Tableau).
• Experience on working and implementing large Data Integration Projects.
• Data Analysis functions include Data Management of Large Amount of Data starting from Data Transformation/Sourcing/ Reconciliation, Data Cleansing, Data Profiling, Data Scrubbing, Data Blending and finally to Data Visualization (Interactive Dashboards & Stories).
• Good experience in created dashboards using Bump Charts, Pareto, Box Plots, Histogram, Heat maps, Tree maps, Word Clouds, Trend Lines, Residuals, and Forecasting using Tableau, also worked with API’s.
• Experience on Implementing Data Quality rules and binding it with Reference Data or Business Glossary (Collibra).
• Profound Knowledge of Data Modeling, Data warehousing, Transactional and ODS systems with emphasis on ETL (SSIS), Life Cycle Development (SDLC) including Requirement Analysis, Design, Development, Optimization, Testing and Support.
• Highly proficient and Hands-on in writing T-SQL for developing complex Stored Procedures, triggers, tables, user defined functions, Window Functions (Aggregate and Ranking), CTE, Derived Tables, Error Handling, relational database models and data integrity, SQL joins, SSIS (ETL-using Various Data Flow Tasks).
• Expert in preparing ETLmappingprocess and maintaining mapping documents.
• Extensively worked on Business Intelligence, RDBMS, Multi-Dimensional (OLAP) and Real Time Analytics utilizing Technologies like In-Memory & Columnar DB, SSAS(MDX), GraphDB (NEO4j), Data Marts.
• Extensive experience in documenting business requirements, use cases, functional specifications, Technical Design, Dashboards, KPI’s and test plan documents.
• Excellent communication skills with ability to understand the language of business and technology. Established a strong relationship between stakeholders connecting them to project objectives.
• Extensive experience in leading cross-team meetings during the Requirements Elicitation and Analysis phase. Ability to facilitate conduct UAT and GAP analysis.
• Demonstrated ability to deliver projects from early initiation to implementation and post-implementation follow-up.

TECHNICAL SKILLS

Database: SQL Server 2014/2102/2008/2005 (SSIS, SSAS, T-SQL), Oracle, MS-Access

NoSQL DB: Cassandra, NEO4J (Graph DB)

Data Visualization Tools: Tableau, Microsoft Power BI

Statistical Software: SAS/Base, SAS Macros, SAS Graph, SAS/SQL, R

Data Virtualization: Denodo

Reference Data Management: Collibra

Statistical Modeling: ANOVAs/Linear Regression/Logistics Regression/Cluster analysis

PROFESSIONAL EXPERIENCE

Confidential

BI Developer & Visualization Consultant

Responsibilities:

• Worked on multiple projects parallelly for Data Governance, Regulatory Projects (CCAR, 10k- 10Q Reporting, 2052a & 2052b).
• Extensively worked on Data Integration, Consolidation of different Financial Systems (Lease, Loan, Deposits) using ETL (SSIS).
• Implemented EIW to satisfy Regulatory Reporting by building Data Marts and OLAP Cubes in SSAS. Wrote MDX queries to slice and dice the data.
• Implemented Graph Database (Neo4J) and synchronized with CIT’s MDM solution.
• Created Source to Target Data Mapping & Technical Specification documents for the Data Elements which are needed by Federal Reserve for Integration and Regulatory Projects.
• Performed in Depth Exploratory Data Analysis using (R, SAS, Tableau) statistical. Also created Data Dictionary and Metadata.
• Extensively worked on Data Profiling, Data Remediation, Data Lineage and crosswalks with Collibra (CIT Internal system for Standards & Reference Data) on MRIA (Matter Required Immediate Attention) projects.
• Extensively wrote Stored Procs, Functions, Joins, Derived Tables, Error Handling, DML & DDL operations as per the business need on transactional system as well as on OLAP (Snow Flake and Star Schema).
• Created interactive Tableau scorecards, dashboards using various types of chart for different Line of Business. (Visual representation to manage the risk more efficiently based on Charge-offs, Recovery over a period of 12 months, Borrowers Rating and overall health of each portfolio).
• Worked extensively with SME’s to understand OWB’s upstream commercial systems ACBS (Commercial Loan), PCFS (Small Business) & Strategy & Consumer systems like MSP(Mortgages) & IRESS (Reverse Mortgages) and define key requirements for the Data Sourcing & ETL.
• Performed Risk & Credit Analysis and worked with Accounting team to get the required data and performed reconciliations against the Loans/Agreements.
• Reconciled data parameters such as (OU (Operating Unit), BU (Business Unit) & GL code)) with millions of records from the source systems. Managed the data from Golden Sources and provided Chart of Accounts to Credit & Risk teams.
• Worked extensively with Finarch for various month regulatory reporting and for calculating risk-weighted balance calculation for all assets and off-balance-sheet positions, resulting in aggregated risk-weighted asset values as per Basel accord.
• Created detailed analysis on MRIA and build, automate process to capture user template needed for Regulatory Reporting.
• Built process to handle PII information needed for Customer Balance reports from client online bank.

Environment: Sql Server 2008/2012, Denodo Virtualization Tool, SSIS, SSAS, Tableau 9.0, Collibra, Informatica Data Quality, Microsoft Azure

Confidential

Data Analyst

Responsibilities:

• Utilized Kimball Methodology for creating de-normalized dimensional models and multidimensional DB schema.
• Defined frameworks for Operational data system (ODS), Brokerage data warehouse (BDW) and Data Quality.
• Developed end to end DATA VISULIZATION framework to enable users for creating ad-hoc reporting using Tableau. Also developed customer portfolio reporting system.
• Developed mapping document that contains source and target database details with transformation rules to transform data from source database to target database.
• Worked on dimensional data model (multiple Star Schema) to efficiently support ad-hoc functions and reports in the reporting Layer.
• Utilized OLAP cubes to report large volumes of data, provide hierarchical drill downs, and slice and dice capabilities.
• Developed custom MDX measures, members, and sets to provide dynamic result sets which enables flexible reporting
• Query and mine large data sets to examine financial data by utilizing column store technology in nosql database (Apache Cassandra). Part of big data framework.
• Strong experience in Data Analysis, Data Profiling, Data Migration, Data Integration and Metadata Management Services.
• Extensively used SSIS, T-SQL for accessing and manipulating database systems.
• Developed different charts using Tableau (Word clouds, Waterfall, Bump Charts, and Funnel Charts).
• Synthesized and communicated findings to cross-functional teams and stakeholders in the enterprise.
• Worked with Business analyst and SME in order to translate the requirement into technical design and connect with the off-shore team to carry out certain tasks.
• Responsible for defining the functional and technical design documents for each source to target interface.
• Participated in Design walk-through with SMEs to baseline the business architecture.

Environment: SSIS, SSAS (MDX), Tableau, SQL SERVER 2008, HBase, NOSQL DB

Confidential

Data Analyst

Responsibilities:

• Worked on END-END implementation of AML, KYC, CDD and WLF.
• Good knowledge of BASEL, OFAC, PATRIOT ACT, Bank Secrecy Act.
• Created Data Mapping (Source to Target) and technical design documents.
• Designed and developed data flow from various systems (ERP, CRM, and CIS).
• Worked on Data integration (Batch and Real time) starting from Data Acquisition, Data Preparation (Data Conversion) and Data Loading.
• Created Master and reference data to be used by various feeds to the target system.
• Worked on Data profiling on the origination source of data feeds (Source Systems). ex CIS (Customer information systems, Transaction systems, CRM).
• Implemented WLF (Watch List Filtering), designed to get data from External Sources such as Lexis Nexis and Dow Jones Factiva into Actimize Analytical Engine.
• Implemented KYC and streamline the process.
• Implemented AML by integrating various systems by applying business rules and scenarios.
• Developed number of feeds for ex. (Customer, Transaction type, Geographical,Low Account Type, Cold Account, Line of Business, Industry Code, Account Risk Code, Master data, Lookups).
• Implemented Actimize Case Management System.
• Involved with Business and end users in optimizing the performance of the AML systems.
• Extracted data from source system (Sql Server) using SSIS, Stored Procedures and send feeds to target system (Oracle, Informatica).
• Extensively used SSIS, for performing the ETL operations.
• Involved in ETL design skills, transformations, lookups, aggregations, expressions.
• Developed different charts using Tableau (Word clouds, Waterfall, Bump Charts and Funnel Charts).
• Designed and developed Key Performance Indicators (KPI) to track the guidelines and alert users with the failures.
• Experienced working with Analysis Services (SSAS).
• Designed detail prototype of system showing input/output and interfaces using Visio.
• Performed unit testing, integration testing and assisted QA team in writing test cases and scenarios.

Environment: Actimize CMS, Actimize Repository, MS SQL Server 2008, SSIS, Oracle 10g, Informatica, Tableau Desktop, SAS Base, OLAP