Developer Data

Padmini Priya Chinthpalli

Oracle PL/SQL LEAD Developer/DBA, MYSQL DBA,POSTGRES DBA

Email: *********.****@*****.***

Summary:

Solid technical experience of 11+ years in full software life cycle using Database tools for industries including Oracle design, development, Modeler, testing and implementation of various software projects, applications and database management systems in a variety of environments.

Highly experienced in Planning, Analysis, Design, Development, Testing, and Deployment in a demanding and challenging environment.

Experience working with relational databases Oracle, MySQL, PostgreSQL, Redshift and AWS-RDS.

Experienced in UNIX Shell Scripting / Python Scripts and expertise in developing scripts to reduce manual effort from IT & Business teams to improve the productivity

Good knowledge and practice on GitHub, Terraform & Bitbucket.

Good hands-on presenting data statistics using Tableau VIZ.

Expert in Oracle backend developer includes PL/SQL, SQL, Performance Tuning Analyst and Database Administrator.

Experienced in creating Stored Procedures, Packages Database Triggers, Functions, Views, Synonyms, Indexes, Materialized Views, Complex queries.

Resolving complex performance issues, Performance monitoring and SQL Tuning.

Good experience in executing Database Administrator jobs like Database creation, Upgradation, Backups, Restore, Recovery and User security.

Experience in Data migration Projects.

Experience working on MySQL Server Installations, Databases, Backups, Restore, Replication and Administrative activities.

Worked on PostgreSQL databases administrative activities.

Experience on Redshift & AWS-RDS admin activities.

Experience using ERdiagram, Dimensional datamodeling, Logical / Physical Design, StarSchemamodeling, Snow-flakemodeling using tools like Erwin.

Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modelling and designs techniques.

Experience in OLTP, OLAP / Data Warehouse and Data Mart.

Enhance and maintain the data warehouse that powers reporting and analytics.

Decisive, energetic, focused team leader / player who lead high-performing teams through execution under the pressure of fast-paced, time-sensitive environments.

Experience in developing new components in an AGILE environment.

Technical Skills:

Programming Languages:

SQL, PL/SQL, UNIX, Informatica 9.6.1, XML, Java, Python

Database:

Oracle 8i /9i /10g /11g/12c, MS-Access, Sybase, MySQL, PostgreSQL, Redshift & AWS-RDS

Database Tools:

TOAD, SQL Developer, SQL *Loader

Source Control

Clear Case, Git

Tools

Putty, solarwinds(DPA), New Relic, Spyder, Terraform, Bitbucket, Atom

Educational:

Bachelor of Technology in Electrical and Electronics Engineering from JNTU, Hyderabad, India in 2006.

Work Experience:

20th Century Fox, Los Angeles, CA Aug’17 - Present

Oracle PL/SQL LEAD Developer/DBA,MYSQL DBA,POSTGRES DBA

20th Century Fox, is an American film studio. Fox Group, Inc. operates as an entertainment company. It operates through four segments: Filmed Entertainment, Television Stations, Television Broadcast Network, and Cable Networks. The world’s most diverse, creative, global media company

.

Responsibilities:

Expert as an Oracle backend developer includes PL/SQL, SQL, UNIX scripting, Linux Scripting, Oracle Performance Tuning Analyst and Database Administrator.

Worked on administrative activities like User maintenance, Restoring Databases, Replication, Backup Jobs & resolving issues on MySQL Databases, PostgreSQL, Redshift & AWS-RDS databases.

Resolve complex performance issues, monitoring and tuning using tools like AWR, ADDM, SQL tuning advisors, SQL profiles, SQL Plan Baselines, Stored outlines, SQLT, SQL monitoring, Statspack, Oracle performance views, Solarwinds (DPA).

Proactive Monitoring of Databases and providing proactive suggestions to overcome issues of database like Undersized SGA, Unusual Behavior of Database.

SQLTuning of complex queries by using various methodologies.

Good experience in executing Database Administrator jobs like Database creation, Upgradation, Backups, Restore, Recovery and User security.

Migrated Databases using different Backup methods including Cold Backup, Hot Backup & RMAN Active Database method.

Applying Security patches and OJVM patches across all the databases.

Developed & deployed Python script for enhanced security on new Users creation on Oracle & MySQL Databases.

Experienced in creating Stored Procedures, Packages Database Triggers, Functions, Views, Synonyms, Indexes, Materialized Views, Complex queries.

Hands on experience using Oracle utilities like SQL*Loader, SQL Developer and TOAD.

Creating or modifying existing DB objects (Procedures, Packages, Triggers, Views and Tables, etc.) on Business Enhancement projects and keep the current business running by participating in maintenance of DB.

Performed Unit testing and Functionality testing of the Financial module based on test scenarios and validating the data.

Involved in the analysis, design, and development and testing phases of Software Development Lifecycle (SDLC).

Experience using ERdiagram, Dimensionaldatamodeling, Logical / Physical Design, StarSchemamodeling, Snow-flakemodeling using tools like Erwin.

Have hands on experience in Data migration, Analysis, Validations and Reconciliation.

Environment: Oracle 11g, Oracle 12c, Linux Servers, Unix Shell Script, Python, MySQL, PostgreSQL & AWS-RDS, Terraform, Git, bitbucket & Tableau.

Nation Star Mortgage, Irving, TX Feb’17 – Aug’17

Oracle PL/SQL Lead Developer

NSM provides Reverse Mortgage which offers multiple solutions to meet the reverse mortgage needs of customers. CHIP Application is providing software services to customers to generate month end processing and generate Bills for New Loans and Existing Loans.

Responsibilities:

As an Onsite Development Lead, responsible for Gathering Requirements, Code Development and End-to-end Unit and User Acceptance Testing and Production Roll-out of Data Migration.

Developed Complex queries on Database and developed PL/SQL Procedures to extract data from multiple tables

Responsible for Gathering Requirements, Code Development and End-to-end Unit and User Acceptance Testing and Production Roll-out of New Loans.

Used several Oracle predefined functions NVL, NVL2, DECODE, CASE STATEMENT, REGEXP_REPLACE, REGEXP_SUBSTR.

Tuning Complex queries by converting derived tables to Common Table expressions (CTE) which will enhance query throughput.

Tuning sql queries to enable Database process huge set of migrated Loans into NSM.

Development, Testing of Java Code to meet business requirement and to resolve issues.

Performance monitoring and tuning using tools like AWR, ADDM, SQL tuning advisors, SQL profiles, SQL Plan Baselines, Stored outlines, SQLT, SQL monitoring, Statspack and Oracle performance views.

Experience in using various Oracle PL/SQL collections VARRAYS, NESTED TABLE.

Creating or modifying existing DB objects (Procedures, Packages, Triggers, Views and Tables, etc.) on Business Enhancement projects and keep the current business running by participating in maintenance of DB.

Performed Unit testing and Functionality testing of the financial module based on test scenarios and validating the data.

Involved in the analysis, design, and development and testing phases of Software Development Lifecycle (SDLC).

Experience using ERdiagram, Dimensionaldatamodeling, Logical / Physical Design, StarSchemamodeling, Snow-flakemodeling using tools like Erwin.

Experience in Data migration Projects which uses SQL Developer, PL/SQL programming, coding Procedures, triggers and functions

Have hands on experience in Data migration, Analysis, Validations and Reconciliation.

Environment: Oracle 12c,SQL Developer tool, SUN Sparc 5.10, Java,UNIX

NIKE INC, Hillsboro, OR May’16 – Feb’17

Oracle PL/SQL Developer

Nike is Multinational Corporation engaged in the design, development, manufacturing and worldwide marketing and sales of footwear, apparel, equipment, accessories and services. This project is to Enhance Business activities on Decision Support System.DSS functioning and its data integration with the other applications is represented in the form of documents and pictorial diagrams by understanding Informatica, UNIX shell scripts & Oracle PL/SQL objects.

Responsibilities:

Worked for analysis of new applications Product Data Hub(PDH), Project Creation Excellence(PCX) and its dependencies on Decision Supporting System (DSS) by documenting all the Informatica Mappings, PL/SQL objects and Unix Shell scripts integrated with the system.

Main AIM of the project is to build Integration diagram of Footwear & Apparel DSS, which enables in assimilation of new applications and divestiture of existing systems.

Documented relationships between various objects, their criteria, role-played in transforming data and data shared across applications.

Involved in the development of new Oracle Database objects like Complex queries, Packages, Stored Procedures, Views, and Materialized Views.

Developed new components and positioned them in new applications to enhance business functionalities.

Modifying the existing DB objects to accommodate enhancement in DSS.

Developed New SQL queries to provide Reports to business users.

Informatica Mappings are represented to provide information of Data consumed into DSS, flowing with in DSS and data sent by DSS to other applications by working with Informatica Designer, Workflow Manager & Workflow Monitor.

Documented and thoroughly checked Database Objects like Complex queries, Packages, Stored Procedures, Views, and Materialized Views.

Understood UNIX shell scripts and wrote their objective in the STM, Data Flow Diagram & finally into Engine Level diagram.

Developed Source to Target Mapping document of Foot ware DSS system on Material, BOM and Color categories, which provides information of the data consumed by DSS from various systems.

Built Dataflow diagrams & Engine Level Diagrams for Material, BOM and Color Categories for pictorial representation of FWDSS system.

Established STM for Apparel DSS system at Integration Level by documenting all the Informatica Mappings, PL/SQL objects & Unix Shell scripts.

Constructed Dataflow & Engine Level diagrams for APDSS system.

Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.

Helped clients implement solutions to meet their business and technical needs.

Experience in OLTP, OLAP / Data Warehouse and Data Mart.

Involved in the analysis, design, and development and testing phases of Software Development Lifecycle (SDLC).

Experience using ERdiagram, Dimensionaldatamodeling, Logical / Physical Design, StarSchemamodeling, Snow-flakemodeling using tools like Erwin.

Environment: Oracle 12c, SQL Developer tool, SUN Sparc 5.10, Informatica 9.6.1,UNIX

S3 Group Inc, Duluth, GA Jan’ 16 – Apr’16

Oracle PL/SQL Developer

Child Support Information System is responsible for the delivery of child support services. Involved in Design, Development and Support of Web Based Applications of Child Support Information System

Responsibilities:

Written Batch Program, SQL queries, stored procedures, functions and triggers using Oracle DB

Creating or modifying existing DB objects (Procedures, Packages, Triggers, Views and Tables, etc.) on Business Enhancement projects and keep the current business running by participating in maintenance of DB.

Experience in Data migration Projects which uses SQL Developer, PL/SQL programming, coding Procedures, triggers and functions.

Developed Complex queries on Database and developed PL/SQL Procedures to give in nice strategic plans to higher level of management.

Have hands on experience in Data migration, Analysis, Validations and Reconciliation.

Performed Unit testing and Functionality testing of the financial module based on test scenarios and validating the data.

Experience in using various Oracle PL/SQL collections VARRAYS, NESTED TABLE.

Used several Oracle predefined functions NVL, NVL2, DECODE, CASE STATMENT.

Wrote UNIX shell scripts for automated installations, to extract logs using Bash

Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements.

Scheduled the Jobs for loading data using DBMS_SCHEDULER.

Job monitoring and doing Reconciliation process for failed jobs.

Experience with Data flowdiagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.

As Architect, responsible to design 20 plus aggregates using tables and migrate the corresponding logic from the present DB's stored procedures.

Experience in OLTP, OLAP / Data Warehouse and Data Mart. Enhance and maintain the data warehouse that powers reporting and analytics.

Performance monitoring and tuning using tools like AWR, ADDM, SQL tuning advisors, SQL profiles, SQL Plan Baselines, Stored outlines, SQLT, SQL monitoring, Statspack and Oracle performance views.

Primarily responsible for support and management of 400+ customized application embedded SQLreports, validation of DB schema changes and Version to Version data accuracy.

Involved in the analysis, design, and development and testing phases of Software Development Lifecycle (SDLC).

Experience using ERdiagram, Dimensionaldatamodeling, Logical / Physical Design, StarSchemamodeling, Snow-flakemodeling using tools like Erwin.

Environment: Oracle 11g /12c, SQL Developer tool, SUN Sparc 5.10

Vodafone South India Limited, Hyderabad, India

Oracle PL/SQL Developer Nov’13 – Nov’15

Project: Unify Project-OSS/BSS

Vodafone Essar is a leading provider of wireless telecommunications services in India. The company serves about 85 million subscribers located in every major region of the country. At present, Vodafone has recognized 23 circle for their mode of operation across the India. Every circle has their independent business methodology henceforth no absolute view is available.

Unify project has CPOS and UPSS applications.Centralized point of sales internally comprises of inventory, number management system, customer registration system and reporting module hence it is not just an order punching system.

Unified Project Support System (UPSS) is customized to accommodate customer information / profile configuration management, monitoring Customer Benefits and revenue exposure.

Responsibilities:

Created stored procedures, triggers and views to transform the data and worked extensively in PL/SQL for various needs of transformations while loading the data.

Data Validations and testing with Business Users, fixing data issues

Worked on SQL developer to load data from flat files obtained from various facilities

Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements.

Creation of database objects like tables, views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.

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

Gathering data elements needed for analysis of the data, decoding flat file data and loading into database tables

Experience in Data migration Projects and Scheduled the Jobs for loading data using DBMS_SCHEDULER.

As an Oracle DBA/Architect and Performance Analyst have to perform tasks for smooth functioning of the application.

Creating or modifying existing DB objects (Procedures, Packages, Triggers, Views and Tables, etc.) on Business Enhancement projects and keep the current business running by participating in maintenance of DB.

Provide technical second-level support for Billing application.

Provide technical support for the queries and implements fixes for the problems.

Works on cross-functional teams to proactively address support issues.

Closely worked with Comptel Mediation, Interconnect Billing and Kenan Billing systems to understand and resolve issues of Roaming Files.

Coordinated with QA and Production support teams during code deployment in their respective environments.

Involved in data report customization using iReport tool.

Scheduled the Batch Jobs & scheduler for loading data using DBMS_SCHEDULER.

Worked in Production Support Environment as well as QA/TEST environments for projects, maintenance requests, bug fixes, enhancements, data changes, etc.

Loaded the data into database tables using SQL*loader from text and excel files.

Experience in Software Development Life Cycle (SDLC).

Environment: SUN Sparc 5.10, Oracle 10g, SQL Developer tool, Amdocs (Kenan) Billing, HP-UX 11.23 Itanium, Unix Scripting.

Moody's Investors Service, New York City, NY

Sybase Developer Jan’ 13 - Oct’ 13

Project: Sybase Upgradation of Accurate Application

Moody’s is an essential component of the global capital markets, providing credit ratings, research, tools and analysis that contribute to transparent and integrated financial markets.

Moody’s associates and analysts use AccuRate to create and publish ratings, press releases, research, and analysis. AccuRate organizes application windows according to commonly performed tasks.

Responsibilities:

Involved in Requirement Analysis and Coding using UNIX &Sybase of Accurate Sybase Up gradation

Queries in PL/SQL, performance tuning.

Involved in unit testing and maintenance, Testing scripts in different environments while server migration phase

Coordinating with project stake holders for deliverable &support

Setup of various testing environment &conduct UAT for sigh off

Responsible for offshore team deliverables like Trouble shooting production issues, conducting root cause analysis for the issues.

Experience in creating the tables, constraints, Joins, Subqueries, Sequences, Views, Synonyms, Indexes and sequences in SQL.

Wrote complex SQL queries by using Joins.

Loaded the data into the tables using TOAD and SQL*Plus.

Created metadata validation lookup tables and pre-populated them using SQL Loader generator application.

Created the Integrity Constraints and Database Triggers for the data validations

Experience in working a variety of analytical SQL functions, RANK, DENSE RANK, LAG, LEAD and PARTITION OVER.

Tuned several Oracle SQL statements using Explain plan, Auto Trace utilities

Worked on external hints during the SQL optimization to fast up the SQL process.

Scheduled the Jobs for loading data using DBMS_SCHEDULER.

Designed the application and lead the development effort.

Data loaded from legacy systems using PL/SQL and SQL*Loader.

Developed Unix Shell Scripts for loading data into the database using TOAD

Experience in Software Development Life Cycle (SDLC) [this includes multiple platforms like system study, analysis, design, development, unit integration, acceptance testing and implementation], Agile and Waterfall Software test methodologies.

Environment: SUN Sparc 5.10, Windows 2000 for servers/clients, Sybase 12.5, TOAD

Tata Teleservices Limited, Hyderabad, India

Oracle PL/SQL Developer Jun’ 07 – Aug’12

Project: Fraud Management System (FMS)-OSS/BSS

Fraud Management System is the Total Telecom Fraud Management Solution. It addressed different types of telecom fraud by using advanced technologies and by employing a variety of closely integrated modules. It helps in revenue maximization to the network operator by timely detection of both internal and external fraudsters. It proficiently handles all the operations from the time an individual applies to become a subscriber until the individual ceases to be a subscriber of the network.

Responsibilities:

Primary responsibilities include Creating & implementing numerous Stored Procedures and Functions for pulling and pushing data from/into database and Flat file.

Writing Package and Scheduling jobs to pull/push data from/into Flat file and Tables

Data Gathering and Hardware resizing as per business projections

Development of new scripts to cater Business Requirement

Implementation of Tata Docomo GSM services and Mobile Number Portability services in FMS

Catering to service request by the Clients (such as data Spooling and analysis) by using SQL queries

Impact analysis on the upstream/downstream systems

Involved in unit testing and provided required support to business during the UAT and soft launch phase of the project.Coordinated with Vendor in resolving the major issues

Bug Fixing. Queries in PL/SQL, performance tuning. Proactively involved in resolving the postproduction roll out issues

Regular interaction with business in gathering the requirement, Analyzing and preparing a solution

Proactive performance tuning and recommendations implementation with the help of oracle features and performance-tuning tools like AWR.

Smooth handling of issues and got the customer satisfaction.

Worked well under pressure and within tight deadlines and always pro-active with build service requests and issues.

Provide technical support for the queries and implements fixes for the problems.

Provided outage and service restoration details to Operations Command Center for degradation statistics and root cause analysis.

Performing billing for National Roaming, NRTRDE files as these files need subscriber information which is present in FMS and sending to Comptel Mediation for further processing.

Writing unix scripts to format National Roaming and NRTRDE files to make them compatible with Kenan Billing system.

Closely worked with Comptel Mediation and Kenan Billing systems to understand and resolve issues of Roaming Files.

Provide technical second-level support for Billing application.

Assisted in developing engineering and operational service metrics with actionable plans to improve operational efficiency, enhance service quality/SLA, and optimize delivery.

Developed Unix Shell Scripts for loading data into the database using TOAD

Involved in end to end testing on releases made to ensure proper functioning of the application

Involved in the prepaid system architecture development for New GSM server

Loaded the data into database tables using SQL*loader from text and excel files.

Help the client manage the Frauds in the telecom network. Activities include maintenance of Fraud Management System Server and Software and related issues to provide back-end support for the team at the client site.

Environment: SUN Sparc 5.10, Comptel Event link Mediation, Amdocs (Kenan) Billing, CSG Interconnect Billing, HP-UX 11.23 Itanium, Windows 2000 for servers/clients, Oracle 10g, Ranger 5.4, TOAD

Contact this candidate