Kaavya k

adycnh@r.postjobfree.com

469-***-****

Data Analyst / Data Governance

Summary

Over 8+ years of professional global experience in Business Intelligence, Data Analytics and Process Improvement, including expertise in Operations Management Data management, and Data Governance.

Hands-onon experience with applications like Snowflake (SNOWSQL), SAP HANA, Oracle SQL, Teradata, SQL Server Management Studio (SSMS), SQL Developer, and SQL plus for ELT and Data management

Developed reports, and dashboards using Tableau for quick reviews to be presented to Business and IT users.

Hands on experience migrating on-premise ETLs to Google Cloud Platform (GCP) using cloud native tools such as BIG query, Cloud Data Proc, Google Cloud Storage, Composer.

Design and develop ETL integration patterns using Python on Spark.

Develop framework for converting existing PowerCenter mappings and to PySpark (Python and Spark) Jobs.

Analyzed the SQL scripts and designed solutions to implement using PySpark.

Solid working experience with SQL including MySQL and MS SQL Server.

Strongly skilled in writing stored procedures, triggers and complex queries containing multiple joins, subqueries, and window functions to create reports and perform analysis.

Very keen in knowing newer techno stack that Google Cloud platform (GCP) adds

Data Analysis with the help of Python Scripting for AML alert data files and few process implementations to store AML Alert data in DB in Python.

Implemented CSV file load processes in Oracle in PySpark by using Panda libraries.

Developed SPARK programs using Python to load data from Oracle to HDFS and Hive external tables.

Hands on learning with different ETL tools to get data in shape where it could be connected to Tableau through Tableau Data Extract.

Worked a great extent with the design and development of Tableau visualizations which includes preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies.

Collaborated with Data Governance Lead and other stakeholders to execute Data Governance implementation across enterprise.

Designed, installed, and configured Collibra Operating Model and helped business to model enterprise Metamodels.

Implemented performance effective solutions for long running SQL processes by using PySpark Data Frame processing.

In addition to the ongoing involvement in Data Warehouse Development life cycle was the designer, developer and architect of several Data warehouse, Data marts and related backend applications.

Highly proficient in using T-SQL for developing complex Stored Procedures, Effective Triggers, Tables, Views, User defined Functions, Relational Database Models and Data Integrity, SQL Joins, Indexing and Query Writing.

Created business driven dashboards using different chart types like Crosstab's, Geo/Tree/Heat Maps, Dual Axis Charts, Pie/Bar Charts, Line/Area Charts, Gantt charts, Bubble charts, Scatter Plots, Trend lines, Bullet Graphs and Histograms in Tableau Desktop.

Extensively worked in OLTP & OLAP environments that include QA, Production, and development, implement maintain database schema (in source code control) and Entity relationship diagrams.

Tracked Tableau Server Performance for Alerts, Monitoring, Tuning and troubleshooting.

Strong commitment to organizational work ethics, value-based decision making, and managerial skills.

Good experience in working with a team together to deliver best outputs in given time frames.

Excellent interpersonal and communication skills, creative, research-minded, technically competent, and result-oriented with strong problem solving and leadership skills.

TECHNICAL SKILLS

Tools: DB Viewer, AWS, SSMS, SQL Developer, Toad, DB visualize, Eclipse, Tableau, Teradata, Nifi .

Technologies: PHP, spark, CSS, HTML, Java, Python, Pyspark, SQL, PL/SQL, Oracle SQL, MySQL, PostgreSQL, Snowflake, Salesforce Einstein Analytics, ED, NBA.

Scripting Languages: UNIX, HTML .

Platform: Windows XP, UNIX\LINUX, MAC .

Big Data: HDFS, MapReduce, Hive, Snowflake .

PROFESSIONAL EXPERIENCE

Client: Charter Communications, Denver,colorado October 2021 to Present

Sr. Data Analyst/Data Governance

Roles & Responsibilities:

Developed SQL queries to get data from Database.

Developed various SQL Queries, Views for Generating Reports.

Prepared Scripts in Python and Shell for Automation of administration tasks.

Defined actionable key performance indicators (KPI) to support business goals.

Created Segments, custom metrics, and dimensions for advanced analytics.

Involved in Migration activity for few modules from IBM DB2 to Oracle. Implemented Python Scripts to validate source system data.

Linked data lineage to data quality and business glossary work within the overall data governance program.

Implemented Data Governance using Excel and Collibra.

Traced and catalogue data processes, transformation logic and manual adjustments to identify data governance issues.

Interview with Stakeholders (Subject Matter Expert) to document the transformation logic

Migrating an entire oracle database to Big Query and using of power bi for reporting.

Build data pipelines in airflow in GCP for ETL related jobs using different airflow operators.

Experience in GCP Dataproc, GCS, Cloud functions, BigQuery.

Responsible for configuring, integrating, and maintaining all Development, QA, Staging and Production PostgreSQL databases within the organization.

Responsible for all backup, recovery, and upgrading of all the PostgreSQL databases.

Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.

Hands on experience in connecting to Oracle and SQL databases and troubleshooting.

Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop.

Designed and developed Insights and visualization solutions using Tableau.

requirement gathering and dashboards development in Tableau Desktop.

Preparing Dashboards using calculations, Parameters, Trend Lines, Aggregate Functions, Filters in Tableau.

Used Sqoop efficiently transfer data between databases and HDFS and used PySpark to stream the log data from servers.

Involved in various stages of data preparation for model training and inferencing

Develop, organize, manage, and maintain graph, table, slide and document templates that will allow for efficient creation of reports.

Configuration of Communities, Domains, Asset Model, Relations per MS Data Governance Approach & Requirements

Implemented security in reports according to employee groups and roles according to the requirement and was involved in deployment process.

JH Softech. India,Hyderabad October 2018 to July 2021

Sr. Data Analyst/Data Governance

Roles & Responsibilities:

Developed various Complex SQL Queries, Views for Generating Reports

Automating ETL process for moving data from landing zone to data warehouse by integrating workflows

Created best visualizations reports as per the business requirements using Tableau desktop professional edition.

Blended data using multiple data sources (primary and secondary).

Enabled tableau Actions to drill down from Dashboard to worksheet.

Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.

Extensive experience on creating trend reports including forecast and trend lines.

Designed excel Pivot tables and V-Lookup tables to analyze large data.

Reviewed incoming Data Streams for missing data, corrupt data, and tables/fields.

Provided estimates to the project managers.

Implemented the change management procedures.

Configured incremental data refresh for the data sources.

Prepared BI Interactive Dashboards using calculations, parameters in Tableau.

Develop, organize, manage, and maintain graph, table, slide and document templates that will allow for efficient creation of reports.

Background in installing and upgrading of Tableau server and server performance tuning for optimization.

Used Microsoft Visio and Igrafx to draw business process swim lane diagrams.

Documented controls points, data enhancement processes, and transformation logic identified during stakeholder interviews

Analyzed data lineage processes to identify vulnerable data points, control gaps, data quality issues, and overall lack of data governance.

Performed Dependency Analysis (by identifying any breaks in lineage), root cause analysis and remediation as part of the data lineage effort.

Tracked metrics/KPIs that provide visibility to management into the lineage progress.

Gathered Business Requirements, interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.

Analyzed the source systems and created Business Requirement Document (BRD).

Deep experience with the design and development of Tableau visualization solutions.

Set Up Row level security on Tableau dashboards.

Responsible for creating reports using Tableau desktop and publishing reports to Tableau server.

Involved in migration activities related to Tableau across the environments.

ICICI, India, Hyderabad April 2015 to October 2018

Data analyst

Roles & Responsibilities:

Defined actionable key performance indicators (KPI) to support business goals

Developed various Complex SQL Queries, Views for Generating Reports

Gathered the functional and business requirements by conducting JAD sessions and participatory Design Sessions involving major leads from the Technical Department.

Identified and developed Use Cases from the business and systems requirements.

Documented high level and detailed Use Cases to include all the functionalities of the new system

Involved in integrated adjacencies analytics for Risk optimization, cross-sell, and up-sell

Responsible for revelation, engagement, and churn analysis

Responsible for operational analytics and tracking quality score (TQS)

Responsible for inbound and outbound campaign analysis

Responsible for building automated insights and alerts

Defined actionable key performance indicators (KPI) to support business goals

Involved in reports generation for path, funnel, and cohort analysis

Developed various Complex SQL Queries, Views for Generating Reports

Developed python scripts for data cleanup and automations

EDUCATION

Bachelor’s of Engineering in computer science, 2016

Contact this candidate