Data Analyst Front Office

PARTHEEBAN MANI

Phone: 980-***-****

E-mail: **************@*****.***

AREAS OF EXPERTISE

Requirement Analysis

Agile Methodologies

Data Analysis

Data Profiling

Data Modelling

ETL Concepts

Data Mapping

Data Visualization

Report Development

EDUCATION

PGDM in International Business Management - Centennial College, Toronto, Canada

Master’s in Software Systems - Birla Institute of Science and Technology, Pilani, India

Bachelor of Technology in Information Technology - Anna University, Tamil Nadu, India

SUMMARY

Ambitious and detail-oriented professional with 10 years of experience as a business intelligence analyst, data analyst, system analyst and production support analyst

Extensive experience in requirement gathering, transforming business requirements into functional requirements and design documents

Extensive knowledge on various SDLC methodologies (Waterfall and Agile) working towards development and implementation of enhanced business and technical solutions

Co-ordinating effectively with business partners, technical and non-technical teams and tracking project objectives

Expert in data analysis and Extraction, Transformation and Loading (ETL) process in enterprise data warehouse environment

Very strong in SQL queries and tuning techniques across different databases

Expert in data visualization concepts and experience in creating reports and dashboards using business intelligence tools and analyzing large data sets

Work independently as well as part of a team with key focus on quality deliverables and take ownership within a dynamic team

Providing innovative cost effective solutions to save overall project cost

TECHNICAL SKILLS

Databases

: Oracle, SQL Server, MySQL, Teradata, DB2

Data Analysis

: SQL, PL/SQL, Python, Oracle SQL Developer, TOAD for SQL, Teradata SQL Assistant, MS Excel (Macros, Pivot Tables)

Data Warehousing

: ETL Concepts, SSIS, Informatica PowerCenter 9

Reporting and Data Visualization

: OBIEE, SSRS, Tableau

Documentation and Management

: JIRA, HP ALM, Confluence, SharePoint, MS Office

PROFESSIONAL EXPERIENCE

Wells Fargo, Charlotte NC May 2019 – Present

Reporting Data Analyst

Requirement elicitation with business users and other stakeholders to develop technical BI requirements for customer on-boarding and due diligence application in an Agile environment

Conduct data analysis, data profiling, data quality checks, data modelling and develop business transformation logic and data mapping for source to target database and provide detailed ETL specs for technical team

Develop simple to complex worksheets, visualizations and dashboards for consolidated views of customer and prospect due diligence activities in Tableau

Work with multiple teams and their respective managers and analysts to do impact analysis for application and reporting data migration from SSRS to OBIEE

Use advanced MS Excel functions to develop macros, pivot tables, conditional formulas, formatting, charting, and VLOOKUP to support and share data analysis

Create designs and wireframes/mockup screens to handle more than 150 reports and dashboards for OBIEE reporting

Conduct reverse engineering to identify the data transformation logic, source to target mapping information and develop data dictionary

Prepared test cases to validate ETL loads, interactive reports and support UAT

Active involvement in code promotion and deployment activities, provide post production support and necessary code-fixes

Bank of the West, Tempe AZ Jul 2018 – April 2019

Data Analyst

Analyzed various source systems to develop wealth customer data mart and supported the complete ETL process

Developed the reporting data requirement and determined the schema/tables for logically pulling the data for reporting

Conducted data profiling on the raw and denormalized data to determine sourcing of data into EDW and write source to target data mapping with transformation logics and data selection techniques for ETL development

Performed data analysis using complex SQL queries and understand how data can be utilized for incoming and ongoing data requirements

Created simple Python scripts to perform data validations and analysis using libraries such as Pandas and NumPy

Developed multiple reports and supported performance metrics, KPI’s using Tableau and Excel for developing products and services recommendation

Reviewed Informatica ETL workflow and determined its alignment with business requirements

Provided recommendations based on technical limitations, downstream impacts and mitigating risks both financially and technically

Worked on determining bank’s sensitive data on customer and non-customer to build an online user-driven system for data privacy aligning with the California Consumer Privacy Act

Wells Fargo, Charlotte, NC Jun 2016 – June 2018

Business System Analyst

Developed data requirements for Foreign Exchange clustered applications - Cross-country Funds Transfer, Money Market and Loans, International Treasury and Funding of affiliated banks

Conducted data profiling on data gathered from source types like CSV, excel, or text and uploaded them into database using SSIS, or SQL Import Export Wizard

Developed worksheets and dashboards with KPI’s and live data using Tableau

Determined up-stream/down-stream systems touch point, and created data and process maps

Validated reconciliation and reporting mechanisms as per business requirement

Conducted end-to-end business validations for the complete FX trade process flow

Worked on BREXIT conversion and supported FINTRAC compliance reporting for Wells Fargo Canada branch to meet the Canadian Financial standards to onboard customers

Alert Energy, Toronto, Canada May 2015 – Mar 2016

Data Analyst

Involved in design and development of an in-house Energy and Resource Management product and interpreting the business needs in an agile environment

Extracted billing and energy utility data from multiple energy utility clients across Canada and US and consolidate using automated logic and cleanse data using Python

Consolidated the cleansed data, and developed visualization dashboards for state-wise cost metrics of energy flow across the country using Tableau with filter, parameters, calculated fields, URL’s, navigation to other reports, drill down, sets, groups, actions and other features

Monitored and tracked customer satisfaction results on a global basis and prepare the training and service manual

Infosys Ltd. (Royal Bank of Scotland, New York City, NY) Jul 2011 – Apr 2014

Systems Analyst

Gathered requirements for front office, middle office, and financial controller applications and developed high quality FSD and SRS

Performed GAP analysis to create an optimal database design to handle multiple gigabytes of customer data in a DW environment

Created moderate SQL queries to perform data mining and extract test data based on scenarios

Generated data feeds and user access rules for SailPoint IAM system using automated VB scripts saving manual effort/time and validated the behavioral changes of the system

Developed various automation tools and reports to reduce manual work

Performed root cause analysis and worked with QA and UAT teams to resolve any issues

Co-ordinated with teams at different geographical locations, tracked the status and ensured all stakeholders involved in the project are updated with the current status on weekly basis

Infosys Ltd. (Morgan Stanley Smith Barney, New York City, NY) Jan 2010 – Jun 2011

Systems Analyst

Designed the data model for partitioning a huge transactional table for optimized data retrieval

Converted business requirements and design documentation into test design products: test scenarios, automation test scripts and test cases for Wealth Management system

Engaged the database team to discuss on the data quality issues and determine the correctness of the data and analyze the severity and priority

Conducted reverse engineering on the financial and transactional data to determine the source and transformation logic and derive the data dictionary

Performed application migration and decommission activities by analyzing the process flow, identify & remove file dependencies and archiving activities

Data Telesis May 2008 – Jan 2010

Production Support Analyst

Communicated with the clients and developers on-site to support clients and customers in solving their issues for the application that handled healthcare insurance billing and claims processing.

Created JavaScript’s that displays validation error in Client Information user forms and used CSS (Cascading Style Sheets) in ASP.Net pages.

Executed test cases and prepared test execution report and developed SQL queries to conduct analysis on Call Volume Reports

Coordinated with the other teams during defect management activities and participated in Daily/ Weekly status meeting calls

Contact this candidate