Jayashree Ganesan

**** ******* **, ****** **: +1-571-***-****

Charlotte, NC 28262 Email:acy3dt@r.postjobfree.com

Professional Summary

●Over 6.5 years of IT industry experience in the field of Data Analytics, Business Intelligence, Report Development and Data mining.

●Analytical skills with ability to analyze and interpret trends and patterns using data visualization and reporting tools - Tableau, Business Objects and Crystal Reports.

●Developed and delivered Ad-hoc or on-demand reports.

●Hands-on experience in Teradata PL/SQL programming, UNIX and Python Scripting.

●Report environment production/platform support, maintenance and troubleshooting.

●Worked as a project coordinator, collaborating with stakeholder and report developers in Agile environment. Taken care of onsite-offshore model project execution.

●Completed Tableau Desktop 10 Qualified Associate Exam (Feb-2017)

Education

Bachelor of Engineering in Electronics and Communication Engineering Graduation - 5/2010

Anna University, Chennai, India

Technical expertise

Reporting tools - Tableau, Business Objects, Pentaho, Crystal Reports

Database - Teradata, Oracle, IBM DB2, MS SQL server, Microsoft Access, Greenplum Scripting language - UNIX, Python, SAS

ETL tools - SAS EG, BTEQ, Fastload, Tpump, Multiload, Ab-initio

Integration/Version control - GIThub

Data profiling tools - Informatica DQ, Ab-initio EME

Professional Experience

Cognizant Technology Solutions 6.5 years (11/2010 to present)

Worked with banking clients - Wells Fargo & Co., Capital One

Project-1

Data Analyst at Wells Fargo & Co.

Project Description

Mortgage LOB of Wells Fargo, is a centralized warehouse where data from sales, loan origination and servicing system is integrated to provide a unified view of business. Reporting team converts available data into critical information and knowledge that can be used to make sound business decisions.

Roles & Responsibilities

●Responsible for full cycle of reporting solutions from definition, design and implementation of the data visualization solution for Wells Fargo Mortgage LOB.

●Created complex dashboards combining different charts, tables, calculated fields and maps.

●In-depth understanding of Tableau concepts such as Level of Details, Analytics, Joins & Blends and Extracts.

●Built Tableau visualization for distribution and predictive analysis.

●Responsible for Tableau Workbook best practices implementation, workbook publishing, authorization and set permission.

●Worked on Data Model design, Data Extraction, Transformations and Loading, Mapping Workflows and Customized Analytics Reports.

●Semantic views are built in Teradata platform combining various sources; it is used as report feed for Tableau dashboards.

●Prepared test case, test scripts from the data mapping documents for semantic views and validated data from source to target.

Project-2

Data Analyst at Capital One Investing

Project Description

Capital One Investing is the brokerage firm of Capital One Financial Corporation. Investing Data Analytics team takes care of interpreting Capital One’s customer data into meaningful information. Analytical reports are used by senior management to make decisions, understand customer behavior and business trends.

Roles & Responsibilities

●Project coordinator organizing and prioritizing task, creating tasks list, analyzing project status and progress, reporting its status to business partners.

●Created dashboards, analytical reports, charts and graphs using Tableau Desktop.

●Worked in Tableau Suite – Desktop, Server, Online and Reader

●Implemented UNIX based ETL applications using K-shell, BTEQ to pull data from Teradata.

●UNIX scripting experience with a focus on data processing utilities such as grep, awk, sed, cut and sort.

●Worked in powerful python modules and packages – NumPy, SciPy.

●Used Teradata utilities fastload, multiload, fastexport and tpump to load data from various sources to Teradata DB.

●BTEQ scripts are used to transform data and views are built integrating different subject area tables for Tableau dashboards.

●Constructed K-Shell routines for BTEQ scripts deployed and scheduled in UNIX server to run on recurrence.

●Provided L2 support for report process, schedules and delivery. Ensured base layer data is available for report feed.

●Worked in migration projects to migrate data from legacy Sybase system to Teradata.

Visa Status

H1-B valid till June 2018

Linked-In Profile

https://www.linkedin.com/in/jayashree-ganesan-1068a044

Contact this candidate