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 T uning.
• 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

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles, CA

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

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.

Confidential, Irving, TX

Oracle PL/SQL Lead Developer

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

Confidential

Oracle PL/SQL Developer

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