Translated business requirements into Jira stories, revamped complex data models using Visio, and documented on Confluence, achieving 90% accuracy in project deliverable. • Designed physical data models for over 5 schemas and built DDL (Data Definition Language) scripts for MySQL, MariaDB, PostgreSQL using Liquibase and YAML, ensuring simplified configuration. • Prepared data pipelines to ingest and transform data from AS400 DB2 to relational database MariaDB using Pentaho Data Integration (PDI), achieving an 84% reduction in load time, and enhancing operational efficiency. • Achieved nine times performance improvements for the ETL migration by optimizing table dimensions, adding partitions and indexes, improving data extraction time by 69% and collaborating with application teams. • Orchestrated seamless migration of data from MariaDB to Big Query using Airflow and Pentaho reducing data storage and processing costs by 30%. • Automated data maintenance with python scripts, reducing manual effort by 40% and saving 50 hours per month. • Implemented Python Flask application for centralized master data management, reducing manual database updates by 60% • Maintained version control in GitHub for consistent parallel development efforts

Fidelity Investments | Aug 2016 - May 2018

Data Analyst

• Engineered data mapping and transformation processes improving data accuracy by 25% and reducing retrieval times by 30%. • Implemented an ER modeling system to streamline database structuring, optimizing data flows and reducing redundancy, which boosted the productivity for the data analysis team by 25%. • Authored advanced SQL scripts in DBeaver, achieving a 63% increase in data accuracy by using Swagger to test endpoints • Engineered robust ETL pipelines to process and transform 500GB+ of financial data weekly, optimized data wrangling processes and ensured data export to the warehouse, enhancing data accessibility by 30% and leveraged Swagger documentation to streamline API integration and ensure seamless data flow between systems. • Improved query performance by 40% through effective tuning and optimization, resulting in faster data retrieval and processing times for critical business applications. • Created Tableau dashboard reports with over 1 million records to analyze investment performance contribution rates. • Conducted root cause analysis enhancing process efficiency by 60% through targeted solutions. • Overseen 100+ ticket changes in Jira improving traceability and accountability.

CGI | Nov 2014 - Aug 2016

Data Analyst

• Conducted exploratory analysis using SQL, Excel, and Tableau, increasing marketing efficiency by 15% enabling business owners to view monthly data in a Tableau dashboard. • Ensured 99.9% accuracy in monthly batch loads, reducing reconciliation time by 20% by analyzing T-SQL queries. • Led End-to-End implementation of the data optimization projects focusing on the removal of obsolete and redundant data from databases, successfully eliminating over 100 thousand records, resulting in a 30% reduction in storage costs and 50% improvement in database performance and maintenance efficiency. • Designed 20+ data visualizations dashboards using Tableau to monitor and report KPIs, improving business’s decision making by 25%. • Transitioned 250 documents from SharePoint to Confluence. • Streamlined Python scripts to generate SQL deployment scripts for diverse environments, effectively reducing the time required for DDL file creation by 70%.

CGI | Jun 2012 - Nov 2014

Business Analyst

• Partnered with stakeholders and data owners of an Oil and Gas Client to document and validate the business requirements, converting them into Azure DevOps user stories. • Functioned as a scrum master, preparing use cases, ensuring project milestones are met and consistently reviewed backlogs. • Managed Jira workflows, leading to 30% increase in project milestones and 25% increase in team transparency and collaboration. • Enhanced product backlog by prioritizing high-impact features, achieving a 15% increase in customer satisfaction. • Conducted QA swarming on test plan formulation, test case preparation and script execution over two hundred test cases for web applications, ensuring 99% success rates on deployment date. • Achieved a 95% data quality assurance bug free delivery rate during UAT phases across four major phases. • Documented comprehensive release notes, deployment manuals, and customer agent work instructions, significantly reducing support call volume by 40% and expediting new agent onboarding time by 50%

My Education

Take a look at my formal education

Master of Science - MS in Information Systems and Technology University of North Texas G. Brint Ryan College of Business | 2023

Master of Business Administration (MBA) in Technology ManagementAnna University | 2016

Bachelor of Engineering (B.E.) in Electrical and Electronics EngineeringSri Muthukumaran Institute Of Technology | 2012

About Me

Analytics professional with five years of experience in the field of Data Analytics, Business Intelligence, Data Engineering, and Software Development

Create Your Data Portfolio for Free

Bhuvaneshwari Murthy

Data Engineer

Introduction to Python

Introduction to Python

Numbers enthusiast, translating data into meaningful insights.

My Work

Joining Data in SQL

Introduction to SQL Server

Intermediate SQL Queries

Introduction to Tableau

NoSQL Concepts

Introduction to SQL

Intermediate SQL

SQL for Joining Data

Project: Analyzing Students' Mental Health

Intermediate SQL Server

Introduction to Python

Introduction to SQL

Joining Data in SQL

My Certifications

SQL Associate

Other Certificates

DataCamp Course Completion

Courses

Courses

Projects

My Work Experience

Copart Inc., | May 2023 - Jun 2024

Data Engineer

Fidelity Investments | Aug 2016 - May 2018

Data Analyst

CGI | Nov 2014 - Aug 2016

Data Analyst

CGI | Jun 2012 - Nov 2014

Business Analyst

My Education

About Me