AKHILA REDDY
Canonsburg,PA
Summary
Experienced IT professional with 3+ years in software development, specializing in BI. Skilled in Oracle databases, PL/SQL, SQL tuning, and performance optimization. Proficient in data analytics and visualization using Tableau Desktop and Server. Strong in creating interactive dashboards and reports. Proven ability to handle workloads, attention to detail, and leadership skills. Seeking a BI analyst role to leverage technical expertise and contribute to impactful data-driven insights
Overview
6
6
years of professional experience
Work History
BI Analyst
Viasat
04.2022 - Current
- Collaborated with stakeholders to understand business needs and translated them into data requirements.
- Defined key metrics and indicators aligning with business goals.
- Analyzed large datasets to identify trends, patterns, and insights andInterpreted data to provide actionable recommendations for business improvement.
- Connected to and queried PostgreSQL databases to extract relevant data.
- Utilized PySpark for ETL processes, transforming raw data into a suitable format for analysis.
- Ensured efficient and optimized extraction strategies for large datasets.
- Developed PySpark scripts and jobs for data transformations, cleaning, aggregation, and enrichment.
- Handled schema evolution and ensured data quality during the ETL process.
- Used Github for version control and collaboration on PySpark scripts.
- Created and maintained Tableau dashboards and reports for data visualization.
- Translated business requirements into effective Tableau visualizations.
- Optimized Tableau dashboards for performance, considering factors such as data volume and user interactions.
- Collaborated with IT teams to enhance the performance of underlying databases and ETL processes.
- Provided training to end-users on using Tableau dashboards and self-service BI tools.
- Offered support to users encountering issues or needing assistance with data interpretation.
- Stayed informed about industry trends, BI tools, and emerging technologies.
- Proposed and implemented improvements to BI processes and solutions.
Database Developer
U-Haul
06.2021 - 04.2022
- Coordinated with the front-end design team to provide them with the necessary stored procedures, and packages, and the necessary insight into the data.
- Created, and modified several UNIX shell scripts according to the changing needs of the project, and client requirements.
- Wrote Unix Shell Scripts to process the files daily like renaming the file, extracting date from the file, unzipping the file, and remove the junk characters from the file before loading them into the base tables.
- Created PL/SQL stored procedures, functions, and packages for moving the data from the staging area to data mart.
- Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
- Creating indexes on tables to improve the performance by eliminating the full table scans, and views for hiding the actual tables, and to eliminate the complexity of the large queries.
- Created PL/SQL scripts to extract the data from the operational database into simple flat text files using the UTL_FILE package
- Used Bulk Collections for better performance, and easy retrieval of data, by reducing context switching between SQL, and PL/SQL engines.
- Wrote packages to fetch complex data from different tables in remote databases using joins, subqueries, and database links.
- Wrote conversion scripts using SQL, PL/SQL, stored procedures, functions, and packages to migrate data from SQL server database to Oracle database.
- Wrote sequences for automatic generation of unique keys to support primary and foreign key constraints in data conversions
- Used SQL Server SSIS tool to build high-performance data integration solutions including extraction, transformation, and load packages for data warehousing
- Extracted data from the XML file and loaded it into the database.
BI Developer
Charter communications
01.2021 - 05.2021
- Interacted with the business users, and business analysts to gather the requirements, and worked on requirement specification documents to build the reports accordingly.
- Wrote complex queries in the form of stored procedures, functions, Triggers PL/SQL packages based on the business needs.
- Implemented the concepts of Table Functions, Indexes, Table Partitioning, Collections, Nested tables, External Tables, etc
- Fine Tuned existing packages, functions, and stored procedures to decrease the execution time, and improve the overall performance of the queries
- Used Bulk Collection for better performance, and easy retrieval of data, by reducing context switching between SQL, and PL/SQL engines
- Created PL/SQL scripts to extract the data from the operational database into simple flat text files using the UTL_FILE Package.
- Created indexes on the tables for faster retrieval of the data to enhance the database performance.
- Experience in writing Explicit Cursors, and Handling exceptions while developing the applications.
- Created Tableau workbooks using Oracle as data source.
- Created various charts in Tableau - like Bar Charts, Line Charts, Pie Charts, Donut Charts, TreeMaps, Box, and Whisker, and Built Dynamic KPIs
- Created ad hoc reports to users in Tableau by connecting to excel sheet, flat files, and CSV files.
- Published the developed dashboards into Tableau Server and assigned the extract refresh schedules for extract connections
- Performed tuning of SQL queries to optimize the dashboards.
- Utilized URLs, Hyperlinks, Filters for developing complex dashboards
- Combine Data sources by Joining Multiple Tables and using Data Blending.
- Scheduling the monthly/weekly/daily reports to run automatically.
Graduate IT Assistant
Southern Illinois University Carbondale
09.2019 - 12.2020
- Worked with the Business Application Manager, and the DBA for the requirements gathering business analysis, development, and testing.
- Worked on minor enhancements, and major creation of Packages, Stored procedures, Functions, Cursors, Constraints, Triggers, Indexes, Views, and Database Links.
- Experience in using Database utility tools like SQL Plus, TOAD, SQL Developer.
- Experience in query optimization, performance, and tuning(PL/SQL) using Bulk Bind, Bulk Collect.
- Experience with all phases of the Software Development Life Cycle(SDLC) including analysis, Physical, and Logical Design, Code Development, Testing, Implementing, and Maintenance.
- Used cursor variables(Ref cursors) to pass query results sets between PL/SQL programs, and client applications.
- Used cursor variables(Ref cursors) to pass query results sets between PL/SQL programs, and client applications.
- Used UTL_FILE package of oracle to read the data from CSV files, and load it into database table, and created an interactive report out of that tables
- Worked with Oracle APEX forms, interactive reports, and clas text area, data picker, number field, and new rich-text editor using Oracle APEX 18.2.
- Developed, and implemented different item types of resizable text area, data picker, number field, and new rich-text editor using Oracle APEX 18.2.
- Cresting Static LOV/Dynamic LOVs for the drop-down menus.
- Created APEX instances, workspaces, and deployed applications in Lower environments.
SQL Developer
Dextro Software Systems
01.2018 - 05.2019
- Worked with SQL Loader to import, and export data from flat files in, and out of legacy database.
- Participated in the development of new PL/SQL procedures, functions, and triggers, and updating the old ones based on the change requests.
- Created various DML, and DDL statements using Oracle PL/SQL, and SQL.
- Tuned some existing queries using Hints to improve execution time of the queries
- Participated in creation of database objects like tables, views, Materialized views, cursors, procedures, packages, using Oracle tools like TOAD, PL/SQL, SQL PLUS, SQL Loader.
- Wrote packages to fetch complex data from different tables in remote databases using joins, subqueries, and database links.
- Extensively used the PL/SQL Advanced features of PL/SQL like Records, Tables, Object Types, and Dynamic SQL.
- Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application
- Experience with Oracle supplied packages such as UTL_FILE, DBMS_SQL.
Education
Master's in Electrical and Computer Engineering -
Southern Illinois University
Carbondale, Illinois12.2020
Bachelor's in Electronics and Communication Engineering -
Jawaharlal Nehru Technological University
Hyderabad, India05.2018
Skills
- SQL
- PL/SQL
- PostgreSQL
- Oracle 8i/9i/10g/11g
- Python
- PySpark
- Windows 10/8/7/XP/2007
- Linux
- Unix
- Tableau Desktop
- Tableau Server
- Apache Airflow
- GitHub
- Jira
Technical Skills Certifications
Tableau Desktop Specialist
Timeline
BI Analyst
Viasat
04.2022 - Current
Database Developer
U-Haul
06.2021 - 04.2022
BI Developer
Charter communications
01.2021 - 05.2021
Graduate IT Assistant
Southern Illinois University Carbondale
09.2019 - 12.2020
SQL Developer
Dextro Software Systems
01.2018 - 05.2019
Master's in Electrical and Computer Engineering -
Southern Illinois University
Bachelor's in Electronics and Communication Engineering -
Jawaharlal Nehru Technological University