SUMMARY

• 7+ years of experience in Data Management including Business Analytics, Data Analytics, Data Governance, Metadata Management, Data Stewardship, Data Cataloging, Data Lineage, Data Privacy, Data Quality, Data Profiling, Database Systems, Quality Assurance and ETL & DWH Processes
• 3+ years of experience with Collibra, IBM IGC & Informatica EDC Data Governance Software’s
• Extensive experience in delivering to Financial Services (Banking, Capital Markets & Investment Management), Healthcare clients for projects using Software Development Life Cycle (SDLC), Agile - Scrum and Waterfall Methodologies
• Strong subject matter expertise and experience in the domains of Banking, Regulatory Reporting, Risk Management, Equities, Fixed Income, Collateral, Derivatives, Mortgage, Credit Cards, Financial Statement Analysis, Data mapping & analysis, Reference Data, LBO & DCF Modeling, Credit Rating, Basel II/III
• Hands on experience with Data Governance and cataloging tools such as Collibra, IBM Information Governance Cataloging and Informatica Enterprise Data Catalog
• Experienced in gathering, communicating, documenting business requirements them effectively. Building dashboards for presentations and reporting
• Excellent knowledge of Relational Databases (Oracle and MS SQL Data Warehouse) and ETL process. Experienced in SQL DDL, DML, DQL, DCL, TCL, PL/SQL and database testing
• Strong experience in Data Extraction, Transformation and Loading (ETL) using various tools such as SSIS, data cleansing and profiling
• Expertise working with Tableau Desktop and Tableau Prep for building advanced visualizations
• Utilized Tableau Online and Tableau Server to enable user interaction of Tableau dashboards with clients
• Strong experience in building visualizations, performing data modeling and data transformation in Power BI Desktop
• Coordinated with clients in publishing dashboards and scheduling refreshes in Power BI Service
• Comfortable at presenting data lineage and data management concepts to business and technical audiences and ensuring that the data lineage is clear, and signed off, with any assumptions or dependencies clearly identified and mitigated
• Created user stories, epics and story boards to illustrate requirement needs
• Effective communicator, able to bridge the gap between technology and business organizations
• Utilized Power Apps for advanced data analytics techniques
• Expertise in Requirements gathering/analysis, design, development, testing and production rollover of reporting and analytics projects
• Proven ability to work with senior leadership to align business objectives with information technology

TECHNICAL SKILLS

Data Governance and Metadata Management Tools: Collibra 5x, IBM Infosphere IGC, IBM Infosphere Information Analyzer, Informatica EDC

Data Visualization Tools: Tableau (Desktop/Server) 9.x/8.x, SSRS, Microsoft Power BI, MS Excel, Business Objects

ETL Tools: SSIS, Informatica PowerCenter 10x, 9x, SAS Data Management, SAS Enterprise Guide, SAS 9.4

SQL Tools: MS SQL, MYSQL, PostgreSQL, SQLite

RDBMS: Microsoft SQL Server, MYSQL server, Oracle RDBMS, P/L SQL Server

Scripting/Lang: HTML, JavaScript, Python, R, SAS

Project Methodologies: Agile-Scrum, Kanban, Rational Unified Process, Waterfall

Requirements Management Tools: JIRA, Confluence, Rally, Share Point

PROFESSIONAL EXPERIENCE

Confidential, NY

Data Management Consultant

Responsibilities:

• On behalf of IT in business operations as Data Stewards to oversee the data governance rules and work with governance consultants and IT team to rollout the reference data management system
• Experienced working with Property and Casualty (P&C) insurance data and requirements gathering and analysis involving reference data governance
• Planned sprint release and making sure team has a crystal clear understanding of sprint goals
• Facilitated daily scrum meetings, enforcing time boxes and responding to the impediments, tracking baseline, sprint planning and sprint retrospective
• Worked with multiple Line of Businesses to gather metadata to build Business Glossaries
• Expertise in Data Governance Process and Stewardship Supported using Collibra DGC 5.x
• Developed materials and presented issues to the Data Stewardship Forum and Developed Forum agenda and lead Data Stewardship Forum meetings
• Business Terms, Acronyms and Synonyms have been captured while working with the stakeholders and managed them in Collibra
• Created Communities, Domains and Asset relationships in Collibra to manage metadata gathered from a variety of sources
• Onboarded multiple LOB users into the enterprise metadata management product and implemented data stewardship for Enterprise Data Stewardship (EDS) team
• Managed data dictionary and Investment Management metadata to facilitate transaction reconciliation of Custodian statements between Confidential and the custodian banks
• Ensured masking of PII information in asset management data
• Created risk score comparison analysis to identify risks and control weaknesses in data
• Designed and executed the testing of internal controls and facilitated the related remediation for any control deficiencies identified
• Develop presentations tailored to audiences at various levels and business functions to communicate internal control findings
• Managed all aspects of the Investment Management projects in the Data Governance Platform - analysis, estimates, technical specification, High Level and detail design, development, testing, packaging, UAT Support and deployed within the planned time
• Lead the Data Governance enhancement project successfully with outside vendors to smoothly transition and update Data Lineages into our data repository
• I oversee the organization'sdataassets to help provide business users with high-qualitydatathat is easily accessible in a consistent manner
• Trained business partners on how to use IBM Infosphere Information Governance Catalog (IGC) Software
• Performeddataquality management activities includingdataprofiling,datavalidation, and assessingdatarelevancy to further improve information reliability
• Acted as a liaison between Share Services business partners and IT to define the business terms that will be used by the organization

Confidential, NY

Data Governance Analyst

Responsibilities:

• Supported the implementation of Firmwide Data Management Policy
• Documented User Guides on how to create communities, domains, domain type, assets, asset types, relationships, traceability, lineage etc.
• Performed a key role in Databook multiple releases and promoted the identified business terms through the life cycle for certification by creating specific requirements and a governance structure with approvals for each stage of the lifecycle
• Created Transactional and Functional Data Domains within Collibra
• Documented Business Requirements in the form of User Stories in JIRA
• Modelled mock-ups for User Interfaces in Collibra using Balsamiq
• Documented Data Quality rules and Thresholds
• Coordinated User Acceptance Testing (UAT) to ensure all business requirements are met
• Experienced in creating the Test Plans, Test Cases, and Test Scripts and efficiently prioritized and managed defect using the Defect Tracking System
• Modelled Collibra Asset Model as per the Organization Standards

Confidential, New York, NY

Business Data Analyst

Responsibilities:

• Developed advanced analytics providing solutions the areas of revenue analysis, risk-assessment, multi-period comparisons and transactional reconciliations in Tableau and Power BI saving 1000+ client service hours by eliminating manual processes, enhancing sample selections and thereby transforming audit procedures Worked closely with senior management, cross departmental teams and attended weekly status meeting
• Created Investment Portfolio Analysis and Asset Management dashboards to aid auditors in their risk assessment procedures
• Provided different test case scenarios and created transaction reconciliations for Investment data using advanced excel features like VLOOKUP, HLOOKUP, Index Match, Exact functions and Pivot Tables and created automation scripts in VBA
• Reviewed Business requirements and prepared the dashboards as per the audit requirements for Risk Assessment processes
• Expert in generating on-demand and scheduled reports for business analysis or management decision using SQL Servers Reporting Services (SSRS), Tableau and POWER BI, Business Objects
• Performed Data cleaning, validation, data pre-processing steps using SQL and SAS before its use in Tableau
• Pulling the Data from DB using SQL, Designing, Development and Publishing of the Report/Dashboard into the Tableau Server through both Live and Extract connection through the Best practices. Worked on Quality Assurance of User Interface and Database of Dashboard
• Experienced working with on web development projects using HTML, CSS and Node JS
• Firm understanding of SAS products, such as: SAS EDI, EBI tools (OLAP), BASE 9.4, Viya, Data Management, Enterprise Miner, Marketing Automation & Optimization, Visual Statistics and Analytics, Text Miner and Contextual Analysis
• Worked across departments to identify and understand key business questions and standardize key metrics and measures
• Performed ingesting, analysing and summarizing large datasets using SQL and Python
• Created extensive documentation on thedesign, development, implementation, daily loads and process flowof the mappings and provided Knowledge Transfer to the end users
• Involved in installation and upgrade ofTableau Server and Server performance tuning for Optimization
• Conducted stand-up calls with analytics assistants to track project progress and solve problems

Confidential, Dallas, TX

Business Reporting Analyst

Responsibilities:

• Worked extensively increating dashboards using Tableauthat includes tools likeTableau Desktop, Tableau Server and TableauReader in various versions of Tableau.
• Managing theMetadataassociated with theETL processesused to populate theData Warehouse.
• Identified the factors involving the performance of the reports and coordinated increation of indexes, statisticsto improve the query turnaround time efficiently
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other making use of actions, other Local and Global filters according to the end user requirement.
• Highly skilled in Tableau Desktop for data visualization, Reporting and Analysis; Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trials and Density Chart. Making sure the team delivers reports as per the requirements.
• Used Tableau Desktop createdInteractive reporting dashboardsby combiningmultiple views.
• Developed narratives that describe the technical process in business terms. Communicated on daily basis with stakeholders and clients on Tableau related activities.
• Mastered in using Filters, sorts, groups and sets, reference lines, Bands and Boxes in different kinds of charts
• In depth knowledge in Tableau advance analysis features like Actions, Calculations, Forecasting, Parameters and Trend Lines
• Mastered the ability to design and deploy rich Graphic Visualizations Parameters using Tableau and Power BI
• Built interactive dashboard using techniques like guided analytics and visual best practices provided by Tableau
• Designed and implemented multiple dashboards using Power BI - PowerPivot & Power Query tools for in house metrics
• Created DAX functions in Power BI such as RELATED, RELATEDTABLE, CALCULATE, FILTER etc
• Used Power BI Service to publish dashboards to clients and schedule refreshes

Confidential, New York, NY

Business Data Analyst - Intern

Responsibilities:

• Worked in Centre for Information and Integration Services (CIMIC) as part of a data science team.
• Collected studied and interpreted large data sets; conducted reports; performed accurate, successful data management
• Performed analysis on Newark City Data in collaboration with Newark Police Department by applying Regression analysis, K means clustering, Support Vector Machines for predicting the occurrences of future crimes and presented findings using data visualization in Tableau.
• Developed website for Office of University-Community Partnerships, Rutgers using SQL and JavaScript
• Created reports using Tableau and presentations using MS Power Point.
• Utilized web scraping techniques to extract and organize Newark City Data
• Improved data mining processes, resulting in a 20% decrease in time needed to infer insights
• Modernize data streamlining processes, resulting in a 25% redundancy reduction
• Gathered and turned business/user requirements into Technical Design documents, SAS programs and SQL queries
• Loaded transformed data to relational database using SAS and SQL programming
• Pulled data for analysis and reporting, using SAS, and SQL

Confidential

Data Analyst

Responsibilities:

• Worked as a Data Analyst as part of the analytics team creating marketing analytics and streamlining data between Finance, Supply chain and Engineering teams
• Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insight
• Perform analysis of large data sets using components from the Hadoop ecosystem
• Work with the application team to design and develop an effective Hadoop solution. Be actively engaged and responsible in the development process
• Created reports in TABLEAU for visualization of the data sets created and tested native Drill, Impala and Spark connectors.
• Generated Test Cases for each specification in Requirement Specification Document corresponding to each module
• Generated the test plan specifying an overview of testing approach, testing strategy, roles, responsibilities and its scope
• Created Test Scripts, Test hierarchy to represent the features and functionality that need to be tested in the application
• Analysed user and business requirements attended periodic meetings for changes in the application requirements and documents