OBJECTIVE:

• To obtain a challenging position as an Oracle Developer, where I can utilize my skills and expertise that will enable business, add value and provide opportunities for professional growth.

SUMMARY

• 8+ years of extensive IT experience in all aspects of Systems Development and complete Project Life Cycle in Oracle PL/SQL including requirements, Analysis, Design, Development, Testing and Implementation
• Substantial development experience in creating Procedures, Packages, Functions, Triggers views, Cursors, PL/SQL Collections and optimizing query performance and other database objects using SQL, PL/SQL
• Experienced in backend database development using tools SQL*PLUS, SQL*Loader, Oracle Designer, Oracle TOAD with good understanding of RDBMS and Normalization Techniques
• Experience in all development and implementation of Database (Oracle RDBMS), work that includes OLTP Database as well various reporting data marts, Data warehouse, ETL, providing data feed to various groups
• Involved in designing Data model for various reporting based Data marts, enhancement of OLTP data model. Star schema, snowflake
• Experienced in environments requiring direct customer interaction during specifications, design, and development and product implementation phases
• Experience in developing forms and generating reports
• Extensively worked with various SQL scripts for relational databases
• Proficient in Application Performance Tuning and Query Optimization
• Writing scripts for collection of statistics, reorganization of tables and indexes, and creation of indexes for enhancing performance for data access
• Strong knowledge of Data Extraction, Data Mapping, Data Conversion and Data Loading process using UNIX Shell scripting, SQL, PL/SQL and SQL Loader
• Enforcing data integrity using integrity constraints and database triggers
• Extensively worked on Triggers for implementing complex data integrity checks and for auditing tables
• Developed (Extraction, Transformation and Loading) Using Pre - Stage, Stage, Pre-Target and Target tables
• Knowledge in Test Scripts, Test Cases, and SQL QA scripts to perform Unit testing, System Testing and load testing. Seamlessly migrated the Code from Development to Testing, UAT and Production
• Experienced in requirement analysis, coding and testing various modules in a software development life cycle
• Excellent interpersonal skills, team player and ability to work well with all levels of an organization with effective presentation, verbal and written communication skills
• Ability to utilize new tools and technologies in a changing environment
• A Self-starter with a positive attitude, willingness to learn new concepts and accept challenges.

TECHNICAL SKILLS

Programming: SQL, PL/SQL, JavaScript, Shell Scripting

Databases: Oracle 12c, 11g, 10g, SQL Server Management Studio

Reporting Tools: Oracle forms and reports, Tableau

Tools: SQL*PLUS, TOAD, Putty, Forms Builder, SQL Developer, Data Modeler, Explain Plan, TKPROF, Microsoft Excel, Microsoft PowerPoint, Microsoft Visio, Data migration, Tortoise SVN.

Operating Systems: UNIX, Linux, Windows

PROFESSIONAL EXPERIENCE

Confidential, Miami, FL

Oracle PL/SQL /Apex Developer

Responsibilities:

• Involved in various stages of SDLC like Requirement gathering, high level design, low-level design, Coding
• Developed database objects including Tables, Clusters, Indexes, Views, Sequences, Packages, Triggers and Procedures to troubleshoot any database problems.
• Created SQL*Loader scripts to load data into the temporary staging tables.
• Involved in uploading of the data from flat files into Databases and Validated the Data with PL/ SQL procedures.
• Designed/developed tables, views, various SQL queries, stored procedures, function, complex PL/ SQL packages.
• Involved in PL/ SQL code review and modification for the development of new requirements
• Developed PL/ SQL code for various levels of front-end validations
• Worked on various Back End Procedures and Functions using PL/ SQL
• Developed and maintained database objects like tables, views, materialized views, indexes, constraints, triggers, sequences, packages, procedures, functions etc. according to the proposed feature.
• Mapping the Field ids to their templates.
• Writing SQL, PL/ SQL code in their respective Excel format Metadata files with the required logics.
• Created the integrity constraints and database triggers for complex data validations
• Automated Quality Check tasks by creating PL/ SQL procedures, cursors, functions and dynamic SQL. Enhanced it with creating exceptions for error handling
• Written complex Oracle SQL queries with complexity using Inner/Outer joins, Union All, Intersect & Minus set operators.
• Writing Test Cases and creating Test Plan.
• Perform Unit testing to make sure if data is sent as per the requirement.
• Writing PL/ SQL blocks to test the flow involved in the business.
• Writing complex SQL queries using inline views, with-clause, sub-queries etc. and tune those complex queries by looking Confidential the Explain plan, setting optimizer hints, analyze stats on tables.
• Used Ref cursors to call select statements dynamically instead of calling them statically using cursors.

Confidential, Los Angeles, CA

Oracle PL/SQL /Apex Developer

Responsibilities:

• Took active role in developing new functionality, design and implemented Oracle PL/SQL solutions that satisfy business requirements
• Prepared time estimates for phases of technical projects
• Developed and maintained project tasks for large and medium projects
• Documented all aspects of projects to assure other administrators can support the environment easily
• Experience in all development and implementation of Database (Oracle RDBMS), work that includes OLTP Database as well various reporting data marts, Data warehouse, ETL, providing data feed to various groups
• Involved in designing Data model for various reporting based Data marts, enhancement of OLTP data model, Star schema, snowflake
• Developed the standards for documentation of batch scripts migration
• Used Sub-query (WITH clause) to make complex SQL statements simple and make them more efficient
• Wrote Shell Scripts for batch jobs from the scratch to simplify the underlying logic where ever necessary like using IFS and modified the existing shell scripts where ever needed
• Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, prepared test data for testing and error handling
• Populated master tables from the extracts from the other databases
• Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files
• Used SQL*Loader and external tables to populate data into tables depending on the requirement
• Designed and Developed scripts for uploading data from flat files and XML files into database, performing business validations on the data using PL/SQL Procedures
• Automated data fetch using UNIX Shell script
• Created business views and materialized views as per the requirement for Sales Audit project which is developed to integrate the Store Point of Sales (POS) with the General Ledger, currently Infor Masterpiece
• Created materialized views and views for generating Warehouse Reports
• Created PL/SQL stored procedures, functions and packages for moving the data
• Developed custom Forms and Reports as per requirements and making them web enabled using Oracle forms and reports 11g
• Created test packages to validate the new and existing procedures and functions in Unit Testing Phase
• Experience in developing various Unix Shell Scripts, set-up environment variables, and file archiving
• Mostly involved in code reviewing and performance tuning with optimization techniques in PL/SQL
• Seasoned in optimizing query performance using Explain Plan, SQL Trace utilities

Environment: Oracle Apex 4.2, 5.1, Shell Scripting, Windows 2007 Enterprise, TOAD, HTML, XML, JAVASCRIPT, CSS, ETL, SDLC, Waterfall, Agile methodologies, Autosys

Confidential - El Segundo, CA

Oracle PL/SQL /Apex Developer

Responsibilities:

• Reviewed the Business/ Functional/ System Requirement Specs, High Level Design Documents, and Detailed Design Documents
• Worked on Queue Processing and Shell Scripting
• Collaborated with Business Analysts and Business Objects team to understand the requirements and translate the requirement into technical specifications
• Experience in application development using various features of Oracle like Bulk Collections, Autonomous Transactions, Dynamic SQL and External tables
• Wrote custom support modules for upgrade implementation using PL/SQL and Unix Shell Scripts
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE and TKPROF
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines
• Created Cursors and Ref Cursors in the PL/SQL Blocks
• Imported the data from flat file and written SQL Loader scripts to load the flat file data into External table for data profiling
• Validated and loaded data into Oracle Database using DB links and external tables from CSV files
• Performed Forms customization on various existing forms
• Experience in all development and implementation of Database (Oracle RDBMS), work that includes OLTP Database as well various reporting data marts, Data warehouse, ETL, providing data feed to various groups
• Involved in designing Data model for various reporting based Data marts, enhancement of OLTP data model. Starr schema, snowflake
• Designed and implemented client-server application. Developed various complex User Interface screens using Oracle Forms Builder 11g
• Resolution of day to day queries raised by the business users.

Environment: UNIX, Oracle, JavaScript, Core Java, HTML, Windows 2007 Enterprise, ETL, SDLC, Waterfall, Agile methodologies. Autosys

Confidential - Vancouver, WA

Oracle PL/SQL Developer

Responsibilities:

• Resolution of day to day queries raised by the business users
• Assisted Business Analysts and Users in requirement analysis and authored various documents including BRDs, Technical Specifications, Migration Instructions and conversion mapping documents
• Created Designs for various PL/SQL codes based upon the requirements, developed them, tested, migrated and provided pre- and post-production support
• Created numerous database objects like Tables, Sequences, indexes, views, materialized views, synonyms, etc., as per the business requirement
• Created database triggers based on requirement analysis and utilized pragma to avoid mutating state
• Used PL/SQL scripts as ETL to load target tables
• Involved in coding of Data Extraction Scripts as per technical specifications
• Designed and developed PL/SQL stored procedures, packages, external tables to extract, transform, load data for data warehouse and business intelligence applications
• Experience in all development and implementation of Database (Oracle RDBMS), work that includes OLTP Database as well various reporting data marts, Data warehouse, ETL, providing data feed to various groups
• Involved in designing Data model for various reporting based Data marts, enhancement of OLTP data model. Starr schema, snowflake
• Developed UNIX Shell Scripts with embedded SQL*Loader and PL/SQL statements to extract data in the form of flat files for data loading and migration
• Worked on Performance tuning extensively. Created database partitions, global and local indexes, optimizer hints to improve overall performance
• Developed Shell scripts to automate execution of SQL scripts to check incoming data with master tables, insert the valid data into Customer Management System and invalid data into error tables which will be sent back to sender notifying the errors
• Worked on SQL Tuning with Query optimization techniques for SQL statements
• Extensively worked on Performance tuning by using Explain plans and various hints
• Creating Materialized Views for replication of the actual data present over a DB Link
• Prepared Test Plans for various functionalities developed and assisted the testers in creation of test scripts that are used in testing the Oracle stored procedures
• Worked on creating users and roles as needed for the applications.

Confidential - Gaithersburg, MD

Data Analyst / Developer

Responsibilities:

• Worked with Business Analyst, Project Manager and other Users to gather understand and analyze requirements
• Created SQL database tables and views for the data collected from the field
• Participated in Database Design and Code Reviews to ensure optimum Performance
• Extracted, interpreted and analyzed data to identify key metrics and draw conclusions
• Use existing procedures to solve routine and standard problems
• Pull and integrate data from disparate sources like cost, claims, clinical data, Ailments, Population size, Record of birth rate, Death Rate, etc.
• Presenting explaining information, suggesting improvements, taking precautionary actions, educate people to minimize risks
• Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau
• Worked on data pre-processing and cleaning the data to perform feature engineering and performed data imputation techniques for the missing values in the dataset using Python
• Developed UNIX Shell scripts to automate repetitive database processes
• Data sources are extracted, transformed and loaded to generate CSV data files with SQL queries
• Designed and Optimized Data Connections, Data Extracts, Schedules for Background Tasks and Incremental Refresh for the weekly and monthly Dashboard reports on Tableau Server
• Customized data by adding Filters Calculations, Prompts, Summaries and Functions
• Developed Tableau visualizations and dashboards using Tableau Desktop
• Blended data from multiple databases into one report by selecting primary keys
• Fine/tunes SQL Queries for maximum efficiency and performance.