AKHILA REDDY

***** ******* **, **. *****, MO, ***46 C: 678-***-**** adkern@r.postjobfree.com

PROFESSIONAL SUMMARY:

Innovative IT Professional with three years of experience in complete software development lifecycle right from requirements gathering through GO Live and Post Deployment Support in both large and small organizational settings. Expert in advanced development methodologies, tools and processes contributing to the development and support of software applications.

Expertise in client server application development using Oracle 12c/11g/10g/9i/8i,PL/SQL, SQL*PLUS, TOAD and SQL*LOADER.

Strong PL/SQL programming skills and expertise with SQL tuning, Performance tuning and Bulk binding techniques.

Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Materialized views.

Good knowledge on logical and physical Data Modeling using normalizing techniques. Created Tables, Views, Constraints, Index.

Developed Complex database objects like Stored procedures, Functions, Triggers and Packages using SQL AND PL/SQL.

Experience in Oracle supplied Packages, Dynamic SQL, Records and PL/SQL Tables. Loaded Data into Oracle Tables using SQL Loader.

Experience in development of database objects like tables, indexes, Views, Procedures and Synonyms.

Experience in advanced PL/SQL constructs like Oracle supplied Packages, Nested tables, Varrays, Records, Types, Dynamic SQL.

Experience with Oracle Supplied Packages such as DBMS_SQL,DBMS_JOB and UTL_FILE. Experience in writing Explicit Cursors and Handling exceptions while developing the applications.

Experience with data analytics, prototyping and designing reports with visualization solutions using Tableau Desktop, Tableau server and Tableau Reader.

Strong Knowledge in creating complex data visualizations and interactive dashboard for decision support systems using Bars, Lines, Pies, Maps, and Scatter plots, Gantts, Bubbles, Histograms, Heat/ Highlight Maps, KPI Scorecards, Tree Maps using Tableau Desktop.

Proficient in Tableau data visualization tool to analyze and obtain insights into large datasets, create visually compelling and actionable interactive reports and dashboards.

Extensive experience in various Tableau Desktop objects like Measures, Dimensions, Folder, Hierarchies, Extract, Filters, Table calculation, Calculated Fields, Sets, Context Filters, Clusters, Custom Territories, Actions,Groups, Parameters, Forecasting, Data blending, Reference Lines/Band/Distribution and Trend lines.

Created Interactive Dashboards using MAPS, Map services and Custom geocoding, background images and KPI (Existing Key Performance Indicator).

Worked on Tableau administration tasks such as publishing workbooks, setting permissions, managing ownerships, working with Sites, providing access to the users and adding them to the specific groups and Projects, Scheduling Refreshes and Subscriptions in Tableau Server.

Flexible, enthusiastic and Well-oriented team player with strong attention to details approach and leadership skills to develop creative solution for challenging client needs, expertise in workload handling.

TECHNICAL SKILLS:

Programming Languages: C, Basic java, SQL,PL/SQL

Databases: SQL server, Oracle 8i/9i/10g/11g, MS-Access

Reporting Tools: Tableau Desktop and Server, MSBI Tools

Oracle Tools: SQL*LOADER,PL/SQL Developer, TOAD, SQL*PLUS

Operating Systems: Windows 10/8/7/XP/2007, Linux, DOS

WORK EXPERIENCE:

Charter communications, St louis, MO Aug 2020 - till date

SQL Developer

Responsibilities:

Interacted with the business users and business analysts to gather the requirements and worked on requirement specification document to build the reports accordingly.

Wrote complex queries against SQL Server and Oracle Databases to pull the data into Tableau for building the dashboards and reports.

Designed and implemented stored procedures and triggers for automating tasks and created PL/SQL stored procedure, Function, views as the reports are custom SQL based .

Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Materialized views.

Extensive experience in writing and modifying SQL LOADER and PL/SQL Code, Views, Materialize Views, Partitions, Nested tables, External Tables etc.

Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.

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 UTL_FILE Package.

Created scripts to create new tables, views, queries for new enhancement in the application using TOAD. Created indexes on the tables for faster retrieval of the data to enhance the database performance.

Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.

Handled errors using Named System Exceptions such as INVALID_NUMBER, NO_DATA_FOUND and PRAGMA EXCEPTION_INIT.

Created Tableau workbooks using Oracle as data source. Created various charts in Tableau - like Bar Charts, Line Charts, Pie Charts, Donut Charts, Tree Maps, 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 URL's, Hyperlinks, Filters for developing complex dashboard.

Combine Data sources by Joining Multiple Tables and using Data Blending. Written Custom SQL Queries to join data from multiple tables.

Scheduling the monthly/weekly/daily reports to run automatically.

Environment: Tableau 9.0 Tableau v8.2(Tableau desktop, Tableau server, Tableau online, Tableau reader), SQL server 2008, TOAD, SQL Loader, Oracle12c(SQL, PL/SQL).

ADT Security, Miami, FL Jan 2020 - July 2020

BI Developer

Responsibilities:

Designed, developed, tested, and maintained Tableau functional reports based on user requirements.

Mastered the ability to design and deploy rich graphic visualizations with Drilldown and Dropdown menu option.

Involved in creating database objects like tables, views, procedures, functions using Oracle SQL to provide definition, structure and to maintain data efficiently.

Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Materialized views.

Developed Complex database objects like Stored procedures, Functions, Triggers and Packages using SQL AND PL/SQL.

Experience in writing Explicit Cursors and Handling exceptions while developing the applications.

Extensively involved in creating graphs by using measures and dimensions data from various databases by using data blending concept.

Developed Tableau data visualization using Cross tabs, Heat maps, Box and whisker charts, Scatter Plots, Geographic Map, Pie charts and Bar charts.

Worked extensively with Advance analysis Actions, Parameters, Maps, Trend Lines, Statistics and Table Calculations.

Provided Production support to Tableau users and wrote custom SQL to support business requirements.

Utilized Tableau Server to publish and share the reports with the Business Users.

Responsible for creating calculated fields, combined fields, bins, sets, geo coding and hierarchies using Tableau Desktop.

Involved in creating Dual-axis bar chart with multiple measures.

Implemented data blending to blend related data from different data sources.

Worked on Tableau administration tasks such as publishing workbooks, setting permissions, managing ownerships, working with Sites, providing access to the users and adding them to the specific groups and Projects, Scheduling Refreshes and Subscriptions in Tableau Server.

Environment: Oracle 11g(SQL,PL/SQL), Toad, Tableau v8.2(Tableau desktop, Tableau server, Tableau online, Tableau reader), SQL server 2012.

Southern Illinois University Carbondale, Illinois Sept 2018 to Dec 2019

Graduate IT Assistant

Responsibilities:

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.

Good exposure to DBA routine tasks like managing users, roles, privileges, schema and objects, developing PL/SQL triggers for user access audit.

Worked on analytical functions like RANK and DENSE_RANK.

Used cursor variables(Ref cursors) to pass query results sets between PL/SQL programs and client application.

Used UTL_FILE package of oracle to read the data from CSV files and load into database table and created an interactive report out of that tables.

Worked with Oracle APEX forms, interactive reports, and classic reports.

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.

Worked on form, report enhancements and debug.

Enabled single and multi-row delete in the reports.

Created APEX instances, workspaces and deployed applications in Lower environments.

Environment: Oracle 11g(SQL,PL/SQL), Toad, Oracle APEX 18.2

Dextro Software Systems, Kolkata, India Jan2018-May 2018

Intern

Responsibilities:

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 also updating the old ones based on the change requests.

Created various DML and DDL statements using Oracle PL/SQL and SQL.

Created Records, Tables, Collections(nested tables and varrays) for improving query performance by reducing context switching.

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 and Handled Exceptions.

Wrote packages to fetch complex data from different tables in remote databases using joins, sub queries 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.

Environment: Oracle E -Business Suite, Oracle 11g, Toad, SQL*Plus, SQL*Loader, Excel.

EDUCATION QUALIFICATIONS:

Master’s in electrical and Computer Engineering GPA:3.85 Dec 2019

(Southern Illinois University Carbondale, Illinois)

Bachelors in Electronics and Communication Engineering GPA:3.00 May 2018

(Jawaharlal Nehru technological University Hyderabad, India)

Contact this candidate