Sql Developer
Resume:
Aparna Gangasani
**********@*****.***
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