Data Sql

Yoganand Tenkayala

Minneapolis, MN

SUMMARY

** ***** ** ********** ** developing Data warehouse solutions using PL/SQL

Expertise in Designing, Developing SQL, PLSQL on Relational Databases

Proficient in SQL Tuning, Hints, Explain Plan and Application Performance Tuning

Expertise in Designing Large Data Warehouse systems

Expertise in PL/SQL Stored Procedures, Views, Triggers, Materialized Views etc.

Quick learner and impressive team player.

Implemented Advanced features such as Automatic Partition Maintenance.

Expertise in programing using PL/SQL, UNIX Shell Scripting, Informatica

Has extensive knowledge in various database concepts such as Stored Procedures, Functions, Triggers, Bulk Data processing, Indexes, Materialized Views, Advanced Queuing, Dynamic SQL, Performance Tuning Hints, Generate JSON Messages.

Expertise in ETL technologies such as Informatica

Expertise in Designing and Performance tuning in Data Warehouse environments.

Looking for an opportunity to engage in delivering next generation solutions.

TECHNICAL SKILLS

Oracle 10g/11g/12c/19c/Exadata, PL/SQL, UNIX Shell Scripting, SQL, C, Pro*C, INFORMATICA, PVCS, Rational Clear case, Maestro Scheduler

PROFESSIONAL EXPERIENCE

Best Buy, Richfield, MN June 2015 – Present

Senior PL/SQL Developer

Work closely with business users to capture the requirements. Evaluate the various approaches to the solution and propose the optimal solution approach.

Involve all the stake holders to ensure the solution approach is fine for the dependent systems.

Extensively involved in building the EDW and several Operational Data Store databases for Supply chain area, which was around 80 TB.

Create Technical designs with focus on Performance, scalability, maintenance, and cost effectiveness based on the business requirements.

Created packages, procedures, functions, tables, views, triggers, materialized view, collections for data processing.

Create and maintain architecture diagrams and process flows and maintained the Data Model using ErWin.

Set the application design standards and conveyed the same to the development team to ensure cohesive development.

Perform review of the code developed offshore to identify any deviations to the standards and identify any defects before deploying into production.

Extensively worked on designing and implementing Tables using Slowly Changed Dimensions, and Complex Summary Tables.

Worked through migration from 12c to 19c; required code clean up and resolution of run time errors.

Resolving Performance issues in long running Queries by using EXPLAIN PLAN

Implemented Automatic Partition Maintenance using Interval Partitioning on Oracle 12C

Extensively involved in Code Review.

Developed PL/SQL Stored Procedures to Aggregate data into the Data Warehouse

Created Indexes and Temporary Tables to improve performance.

Extensively used Analytical functions such as RANK, ROW_NUMBER, LEAD, LAG and built very complex Queries

Technologies Used: Oracle Exadata 11g/12c/19c, SQL, PL/SQL, SQL Loader, UNIX Shell Scripting, Maestro Scheduler, Confluence, PVCS

IKEA, Sweden July 2012 – February 2015

PL/SQL Developer

Create High Level designs based on the business requirements.

Create and maintain architecture diagrams and Data Model using ErWin for development team to reference, as well as the business when they needed to run their own queries.

Designed the data structures and built integrations with different Source systems,

Created Tables, Views, Triggers, Stored Procedures, functions, and Packages using PL/SQL to aggregate and load into various Metric Tables

Created ETL pipelines using Informatica to supplement work of the designated ETL team.

Used Explain Plan to ensure the SQLs are optimally tuned

Used HASH Joins, PARALLEL hints, Nested Loops as applicable to improve performance

Extensively used PL/SQL Collections and Bulk data processing to improve performance

Efficiently used Autonomous transactions to create Process logging

Coordinate with Infrastructure support teams to ensure the different environments are stable.

Technologies Used: Oracle 11g, SQL, PL/SQL, Informatica, SQL Loader

AT&T, Seattle, WA January 2010 – April 2012

Oracle Database Analyst/Performance Tuner

Involved in the delivery of ad-hoc reports using CDRlive using PL/SQL for a wide customer base of internal users. .

Designed and developed Business Objects Universes and Business Objects reports.

Performance tuned the PL/SQL procedures which query the fact tables (size is about 27 TB) and populate the summary table in a 35 TB data warehouse.

Performance tuning the SQL reports and BO reports.

Used direct path loading to achieve loads of more than 1 TB per day

Providing guidance to the team to work on a very large data warehouse (35 TB).

Functional and Technical review of the newly developed reports.

Designed and created an Oracle 10g Database for maintaining Meta data for Business objects.

Performed all kinds of administration activities like user creation, archive logging, backup & recovery and monitoring on the Oracle 10g database.

Creating the necessary user accounts and assigning roles and quotas.

Periodic maintenance of the database.

Designed data interfaces between CDRlive and downstream systems such as LCR, SQM and other systems.

Actively involved in identifying and automating various manual tasks.

Developed UNIX shell scripts to automate the SQL scripts which were previously executed manually.

Used CVS for version controlling.

Used Mercury Quality Centre for testing and logging defects and review comments.

Technologies Used: Oracle 10g, Direct Path Loading, SQL, PL/SQL, UNIX, Business Objects

EDUCATION

Sri Venkateswara University

Bachelor of Technology (Electrical & Electronics Engineering)

Contact this candidate