Data Analyst
Resume:
Vivek Radhakrishnan
Naperville, IL
adhl7c@r.postjobfree.com; LinkedIn
Summary
Over 11 years of Business Analysis, Data Enablement, Quality Assurance experience on wide variety of ETL/Data warehousing and BI Reporting projects for Large U.S. banks
•Performed the roles of Data Analyst, Business Analyst, SIT/UAT Test Lead, Test Analyst for Compliance Regulatory, Risk Data Gathering and Reporting, Global Payment Settlement and Securities Settlement projects with a strong understanding of the business model
•Strong knowledge and hands-on experience on Data preparation and Data Visualization tools
•Extensively worked on querying Oracle and Netezza Datawarehouses to provide data requirements for ETL requirements with strong Data visualization experience
•Addressed complex data inconsistencies across multiple data sources to establish data lineage while building integrated curated datasets
•Proficient in preparing Complex SQL queries involving complex joins across many tables and aggregate, analytical functions
•Engaged with customer team to understand, create and validate organized datasets ready for modelling, reporting and downstream consumption
•Proficient in Data Profiling and understanding behavior of various data elements
•Improved Data visualization, preparation and analytics practices within multiple business groups of
•Strong in Banking Domain and Software Development Life Cycle (SDLC) model with exposure to both waterfall/agile Methodologies
•Experience managing multiple stakeholders with conflicting interests on requirement analysis, issue resolution and appraising project status
•Delivery oriented person and a quick learner with excellent analytical, problem solving and strong customer interfacing skills. Independent worker who can deliver with minimum assistance
Technical Experience
Title
Contents
DW & BI Tools
Datameer, TIBCO Spotfire, Informatica Power Center, Informatica Test Data Management, IBM Cognos Report Studio, SAP Business Objects
OS
UNIX, Windows XP, Windows 7, Windows 10
Database Tools
Aginity work bench for Netezza, Aginity Workbench for Hadoop, Oracle 10g/11g/Exadata, Netezza and Hadoop
PL/SQL Developer, SQuirreL SQL Client, TOAD for Oracle 10, DB Visualizer, Impala
Testing Services
ETL, Datawarehouse, BI Reports and Big Data, Enterprise Data
Process Management Tools
JIRA, Confluence, HP Quality Center and HP Application Life Cycle Management
Certifications
International Software Testing Qualifications Board (ISTQB) - Foundation Level
Introduction to Oracle 9i – SQL
Employment History
BMO Harris Bank
Data Analyst
Mar 2020 to May 2020
Self Employed
Contractor for BMO Harris Bank
May 2018 to Dec 2019
First Tek Inc
Programmer Analyst
Apr 2017 to Dec 2017
Universal Software Corporation
Programmer Analyst
Oct 2016 to Mar 2017
Cognizant Tech Solutions
Senior Associate
Oct 2014 to Oct 2016
Tata Consultancy services
IT Analyst
Oct 2008 to Oct 2014
Education
Bachelor of Technology in Electronics and Communication Engineering,
Pondicherry Engineering College, Pondicherry University, Puducherry
Professional Experience
Bank of Montreal Harris Bank, Chicago, IL USA
U.S. Personal and Business Banking – Data Analytics and Reporting
Mar 2020 – May 2020
Roles: Data Analyst
Gathers data requirements for the business case
Analyze data across multiple systems, provide insights and refine data requirements
Identify data elements that need to be sourced from Hadoop and Netezza Data warehouse
Design reusable process to gather and integrate the data elements required for COVID dashboard
Partner with the Data modelers throughout the model developmental and address data issues
Validate the data in COVID dashboard and ensure data integrity
Continue capturing required data elements for new hardships reported everyday and update the data for previously reported hardships.
Enterprise Data and Artificial Intelligence Enablement
May 2019 – Dec 2019
Role: Enablement Consultant
Set up and maintain centralized knowledge management resources such as onboarding process, Analytics tools information, training, support process, etc. in Atlassian Confluence
Demo capabilities of Data Analytics tools such Datameer and Spotfire to various business groups in the bank
Engage business groups and onboard them to Netezza/Hadoop Analytics Sandboxes, Datameer and Spotfire platforms.
Set up guidelines on features to be enabled and acceptable usage of Spotfire and Datameer
Offer guidance to business groups on end to end Data preparation/visualization solution and implementation
Share Datameer/Spotfire best practices and use cases across multiple teams. Review business groups Datameer and Spotfire use case designs and determine if enterprise architectural standards are met before productionizing the use case
Managed Enterprise Spotfire PMO Mailbox
Assist Business groups in developmental and process related challenges through JIRA tickets
Managed business teams to go through TIBCO Spotfire version upgrade from v7.7 to X
Organized Spotfire X upgrade meeting for large groups of business users and provided an overview of the upgrade process and the action items on business teams to ensure smooth transition
Co-hosted Spotfire and Datameer Communities of Practices meetings to bring together various business groups within the bank, provide a platform to share their data analytics use case and open lines of communication between teams
Contribute constantly to improve Onboarding, Training and Support processes.
Projects: Integrated Data Platform - CCAR Risk/Data Acquisition Phase III & IV, IFRS9 (International Financial Reporting Standard) and CECL (Current Expected Credit Loss)
Oct 2016 – Dec 2017; May 2018 – Apr 2019
Roles: Business Data Analyst
Performed Data profiling on source Databases and fed inputs to Source to Target mapping documents.
Understand the requirements from Business data modelers and capture the detailed data requirements in JIRA
Develop SQL scripts to profile data sources, understand data trends and determine the best data sources
Participate in the Datawarehouse modelling/designing sessions with the Data architect and developers and help finalize the Datawarehouse model
Translates high-level requirements into detailed technical specification documents to capture the sourcing criteria, joins between different sources used in the build
Create Mapping rules for data movement between Source and Target tables
Participate in Daily meetings with the Development and System Testing team and provide clarifications whenever required
Review System testing results and assess its comprehensiveness
Create Training documentation using established PMO standards
Prepare User Acceptance Test scripts to validate the accuracy of data delivered
Profile the data delivered and determine its completeness and validity
Reconcile the balance trends of the data delivered through time with the Bank’s general ledger and asses any deviations
Participate in the future release meetings and estimate the effort
The Northern Trust Company, Chicago, IL USA
Projects: Enterprise Data Platform, Global Cash Hub for Payments Platform and Loss Given Default
Oct 2014 – Oct 2016
Roles: Data Analyst/Test Manager/Test Coordinator
Performed Data profiling on Sources Databases and fed inputs to Source to Target mapping documents.
Conducted test strategy, Estimation and planning sessions
Worked closely with the business analysts and understand the different business events/transactions occurring on the source Databases.
Identified business use cases scenarios and its data by querying the Big Data layer using Impala queries.
Played keyed role in setting up the process of UAT of in the absence of consumers of Enterprise Data during the initial releases of program.
Validated the Enterprise Datawarehouse against the data in the Big Data layer.
Participated in User Acceptance Testing (UAT) by creating robust data quality checks on the Enterprise Datawarehouse data.
Participated in future release meetings, understand the scope of the next releases to plan the testing activities, resources, etc., discuss the about the challenges and lessons learnt from previous releases and suggest process improvements.
Lead a team of offshore testers.
Maintenance of test cases and scripts in HP ALM
Execution of test cases in HP ALM.
Conducted Daily status meeting with Stake holders
Bank of Montreal Harris Bank, Chicago, IL/Brookfield, WI USA
Comprehensive Capital Analysis and Review Y14
March 2013 – Oct 2014
Roles: Onshore Test Analyst/Data Analyst
Identified source data elements and examined them for discrete values, null (blank or unknown) values, data uniqueness and data patterns and assessed the risks and challenges of integrating the data into the CCAR database
Performed Data profiling on Sources Databases and fed inputs to ETL specifications and Source to Target mapping documents.
Prepared Test cases and scripts to test the data movement between different tables in the source system and CCAR database. These test scripts are complex Structured Query Language (SQL) queries prepared to validate the record count, data completeness, presence of duplicates records, table structure, data quality, sum of $ amounts, side by side validation of every field in CCAR tables against the source tables.
Participated in User Acceptance Testing (UAT) by running Ad-hoc queries, analyze a given business scenario and provide data to help the business users validate the data from a business perspective
Created Ad-hoc reports in Business Objects to facilitate UAT
The data submitted to the Federal Reserve undergoes several stress tests to identify the data quality. These stress tests are mimicked and performed monthly on the production data to identify deviations from the Fed standard beforehand and treated appropriately through overrides or change requests
Last minute requirement changes and requests from Federal Reserve are accommodated as manual overrides. These overrides are directly implemented in production environment. Validate these overrides and sign off production data.
Tested Outbound Text files submitted to the Federal Reserve for accuracy
Participated in future release meetings, understand the scope of the next releases to plan the testing activities, resources, etc., discuss the about the challenges and lessons learnt from previous releases and suggest process improvements.
Prepared knowledge transition documents to help any new addition to the team get to speed.
Bank of America, USA
Jan 2009 to Mar 2013
Role – Offshore Test Lead, Test/Data Analyst
Projects – Global Commercial Banking Reporting and Integrated Management reporting
Coordinated with the team members for better understanding and analysis of Requirement documents
Prepared Estimation, Test Plan and Traceability Matrix
Preparation of Test Scenarios and Test scripts
Review of the Test scenarios and Test cases prepared by the team.
Walked through the test cases with Development team and Business Analysts.
Executed Test scripts and reported the status of test execution.
Took ownership of the project at offshore and guiding the team to achieve project objectives.
Training and mentoring new resources at off-shore
Ensured the timely delivery of different testing milestones
Contact this candidate