Aparna Gangasani

972-***-****

ac5l38@r.postjobfree.com

Summary:

Over 19+ years of experience in delivering cost effective, high performance data-driven solutions to meet challenging business demands.

Application on call and production support for various backend Reports/Modules and functionalities.

Accomplished Business Intelligence / Enterprise Datawarehouse Professional with strong design, development and architecture skills.

Database backend Development and tuning using oracle PL/SQL for Several front ends/ ETL loads

Maintain source control and promotion of Oracle PL/SQL Objects in several environments.

Monitoring various oracle Jobs and processes using Unix Shell and PL/SQL objects.

Experienced in Analysis, Design, Development, Implementation, Testing and maintenance of Business Intelligence solutions using Data Warehousing/Data mart design, ETL, OLTP client /server applications.

Extensive qualifications in all areas of information systems from design through documentation, implementation, user training, quality review, and enhancement.

Key areas of expertise include Business Intelligence, Billing, Marketing, Sales applications.

A motivated BI specialist with strong inter-personal, organizational, writing and communication skills.

Worked with Different Shell Structures in Linux and Solaris versions

Expertise in writing SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.

Academics:

Big Data Certification, Cloud Computing technologies, Agile Bronze Certification.

Six Sigma Training, ITUP Bronze Certification, MicroStrategy technologies.

Technical Skills:

BI Tools Tableau, Informatica, BO

Tools Toad, Teradata SQL Assistant, Query Analyzer.

Data Modeling Erwin, Rational Rose, Microsoft Visio

Languages SQL, PL/SQL, C, C++, Java, J2EE, VB.Net, VB 6.0, ASP Net

Databases Hive,Oracle, SQL Server, HP Vertica, Teradata, MS Access

Work Experience:

Amdocs, Dallas, TX Dec 2016 – Feb 2018

Role: Sr Developer

Responsibilities

Worked with PL/SQL (Packages, functions, procedures, triggers, Materialized Views, Types) and other related objects.

Performed functions including PL/SQL tuning, Database Application Design and Development Support.

Worked with Analytical Functions and complex queries for business requirements.

Built and enhanced all objects packages/functions in PL/SQL to support application process.

Implementing Best Practices in PL/SQL such as usage of Table hints, Index approach, Joins Vs Sub Query, Bulk Inserts, Dynamic SQL etc.

Performance Tuning of SQL queries to keep data loads within SLA (Execution plans, tuning Advisor, Index Usage, PL/SQL coding standards, I/O Usage Bottlenecks, CP Time, Memory usage, Performance counters etc.).

Implemented a lot of UNIX scripts for report generation on the usage, activation, errors statistics.

Created Stored Procedures to build Fact tables in data mart for Multi-Dimensional Analysis

Analyzed requirements for various reports, dashboards and created the same using Tableau10.1.

Created Tableau Dashboards using Stack bars, Bar graphs, scattered plots, Geographical maps` Gantt charts using show me functionality.

Environment: SQL, PL/SQL, Tableau10.1, Business Objects XI, Toad, SQL Assistant, UNIX/Linux

AT&T, Dallas, TX Apr 2006 - Dec 2016

Role: Lead Developer

Responsibilities:

Applying Constraints and Writing Triggers to apply the business Rules

Participated in creating or updating tables, Columns, Triggers and Writing PL/SQL

Responsible for optimization & Tuning Complex PL/SQL queries.

Optimized performance of queries with modification in PL/SQL queries, Removes, Unnecessary columns, eliminated, redundant and inconsistent data, Normalized tables, established joins and created indexes to assimilate client information from multiple developers

Determined critical customer needs, performed technical designing, code reviews and documented process at every step; delivered code base and provided KT to the Support Team

Re-design Informatica and Teradata applications for Vertica.

Perform data validation, monitoring performance tuning activities using customized projections and partitioning techniques

Prepared conceptual/logical, physical data models and performed reverse and forward engineering.

Environment: Oracle, Pl/SQL, Toad, SQL Assistant, UNIX, Composite, Teradata, Business Objects XI

Cingular Wireless, Dallas, TX Apr 2000 – Apr 2006

Role: Sr Developer

Responsibilities

Participated in gathering User Requirements and System Specifications

Involved in designing, testing disaster recovery model & implementation

Enhanced database structures as per the business requirement which is applicable for Contract Accounting Maintenance in an efficient way.

Developed and maintained data, procedures and performed Data Impact Analysis

Wrote optimized Pl/SQL queries to access source data from RDBMS and provided reports according to the requirements.

Wrote and modified stored procedures to implement the complex business needs for generating new customer number, updating user profiles, transaction processing, generating messages with code encryption.

Wrote User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.

Designed, coded, tested, and debugged enterprise wide applications.

Coordinated and assisted with the Front-End Developers in handling & solving bugs.

Environment: Oracle, Pl/SQL, UNIX sun Solaris, TOAD

SBC, Dallas, TX Apr 1998 – Apr 2000

Role: Developer/Analyst

Responsibilities

Wrote stored PL/SQL Procedures for reports.

Constructing private and public PL/SQL packages.

Developed PL/SQL scripts for data processing.

Developed Pl/SQL stored procedures for ad-hoc reports.

To estimate the performance of Oracle Database During SQL Design

Created the PL/SQL scripts for production database, estimating the space requirements.

Tuning of the SQL statements for application developers.

Environment: Oracle, Pl/SQL, UNIX sun Solaris, TOAD

GTE Card Operations (Presently Verizon) Feb 1997 – Mar 1998

Developer/Analyst

Responsibilities

Involved in major re-write of the existing codes for the project, creating new procedures.

Developed Oracle Stored Procedures, Triggers and Packages.

Tuning of databases, applications & Tuning of the SQL statements for application developers.

Developed PL/SQL scripts for data processing.

Prepared unit test scripts and conducting unit tests and debugging using the PL/SQL debugger Wrote PL/SQL scripts for loading tables and debugging PL/SQL programs

Wrote stored PL/SQL Procedures for reports.

Environment: Oracle, Oracle developer, Pl/SQL, UNIX sun Solaris, TOAD

** References Available Upon Request **

** US Citizen **

Contact this candidate