Sql Data
Resume:
Satyanarayanachary.M, Sr. Oracle Developer
Contact: 925-***-**** E-mail: **********@*****.***
Over 8+ years of experience as an Oracle PL/SQL Developer in Analysis, Design, Data Modeling (Logical and Physical), and Development of client/server and multi tired application using the Oracle Relational Database Management System(RDBMS), SQL, and PL/SQL on different platforms like Windows NT/2000/XP, UNIX and LINUX.
IT Experience as Oracle Developer for System Analysis, Designing, TestingDevelopment & Support of Oracle 8i, 9i, 10g & 11g, 12c in Production, Staging, Development environments.
Experience in conducting Requirement and Systems Analysis, Feasibility Studies, Design Reviews, Plan Reviews, Implementation, and Post Implementation surveys. Highly skilled in Design, Development, Implementation, and Testing of business applications, Unit and System testing on database.
Proficient in PL/SQL programming – Stored Procedures, Functions, Packages, SQL tuning, and creation of Oracle Objects – Tables, Views, Materialized Views, Triggers, Sequences, Synonyms, Database Links, and User Defined Data Types.
Experienced in Dynamic SQL, PL/SQL Collections and Exception handling.
Experience in advanced PL/SQL concepts like Bulk collect, Multi Table insert, PL/SQL table, Cursors, Nested tables, V arrays, Records, Types and Dynamic SQL for DML operations for better performance.
Proficient in Oracle 12c/11g/10g/9i/8i/7.3, PL/SQL back end applications development Toad, SQL Plus, and PL/SQL Developer.
Experience with data flow diagrams, data dictionary techniques, Entity relation modeling and design techniques, database normalization theory.
Expertise in Database Performance Tuning, Performance Monitoring and Optimization using Oracle Hints, Explain plans, TK-Prof and Table Partitioning.
Experience in creating SQL loader scripts to load data from flat files into the database and also creating External Tables to manage data, which is store at the OS level.
Documentation of projects for Functional Requirement Spec (FRS), Use case Spec, ER-Diagram, Test Plan, and Test Script & Test Cases.
Worked on Oracle Forms12c/10g/9i/6i Reports/ 12c/10g/9i/6i.
Proficient in Object Oriented Development of applications using .NET Technologies.
Experience working in performing Unit Testing in all .Net Applications developed.
Well-versed with different stages of Software Development Life Cycle (SDLC).
Expertise in C/C++, Pro*C using Pointer, Structures, Macros, Functions
Experience in migration and conversion from MS Access/SQL-Server to Oracle.
Expertise in creating new C/C++, Pro*C Batch Programs with embedded SQL’s, Pl/SQL Procedure calls, Arrays and Dynamic SQL. Exposure to Retail domain and gained Retek Business Knowledge.
Extensively used PL/SQL to build Oracle Reports 12c and views for processing data, enforcing referential integrity and needed business rules.
Experienced in Tuning Queries for better performance with large volume of data. Extensive experience in developing applications using Oracle Forms / Reports. Experience in almost all the versions of Forms/Reports.
Excellent analytical, problem solving, communication and inter-personal skills to manage and interact with individuals at all levels. Able to interact effectively with other members of the Business Engineering, Quality Assurance and other teams involved with the System Development Life cycle.
Expertise in implementing ETL (extract, transform and load) by using Oracle Warehouse Builder (OWB).
Experience in migration of source code using version control system (CVS, Arch, Visual source safe, SVN, TFS).
Skill Synopsis
Skill Set
Name
Languages
SQL,PL/SQL,UNIX SHELL SCRIPT,C,C++,JAVA
Microsoft Technologies
Microsoft .Net Framework ASP.NET, MVC 4, Silverlight,Web Forms
Oracle Tools
SQL Developer, SQL* Plus, SQL Loader, Toad
Databases
Oracle 12c/11g/10g/9i/8i,Oracle Forms 6i/9i/10g, Reports 6i/9i/10gMS-SQL Server 2000/2005, Sybase, DB2 MS Access, Oracle E-Business Suite (Order Management Module), 11gR2
GUI Tools
APEX 4.2,3.2,Oracle Forms 12c,10g, 9i, 6i and Reports 10g, 9i, 6i, ERWIN,VISIO, Golden gate, Autosys Control-M, JIRA and HP quality center.
Operating Systems
HP-UX 11i, Solaris 2.x/8, AIX 5.3, OpenVMS, Windows XP/NT/2000
Work Experience
Sr. OracleDeveloper Mar ‘16 – Till Date
Bank of the West – San Ramon, CA
Responsibilities:
Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
Experience with Oracle partitioned tables and queries.
High-Transaction environment experience.
Loaded the data into database tables using SQL*loader from text and excel files.
Developed data model, SQL Coding, SQL Query tuning process and Schemas.
Developed SQL Scripts, Packages and Procedures for Business rules check to implement business rules.
Used Bulk Collections, Indexes, and Materialized Views to improve the query executions.
Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables in PL/SQL blocks and even have experience with exception handling.
Created scheduled and schedule now reports.
Developed Forms Screens used by Oracle Developer Suite for forms procedures, functions and packages generate to end product of forms.
Customized the Forms 10g for functional areas of Financial Management System
Analyzed data, designed and developed Oracle forms 12c queries, layout, report triggers, parameter form, data models etc.
Tested the Forms, debugged and fixed the Forms after the testing
Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases
Data loaded from legacy systems (ETL Operations) using PL/SQL and SQL*Loader.
Developed Procedures for efficient Error Handling process by capturing errors into user managed tables.
Using Oracle Jdeveloper Database tools to write triggers and procedures, Function.
Worked with java developers to repair and enhance current base of PL/SQL packages to fix production issues and build new functionality and improve processing time through code optimizations and indexes.
Designed and developed different Database Objects (Stored Packages, Procedures, Functions, and Triggers) using Pl/SQL for RETEK-12.
Support modules for implementation using PL/SQL Scripts, Unix Shell Scripts and Pro*C.
Performed SQL and PL/SQL Performance tuning and Application Tuning using various tools like TKPROF and AUTOTRACE.
Used Toad for creating PL/SQL (trigger, sequence, stored procedure).
Environment: Oracle 11g,Forms 9i/10g, Reports 9i/10g, IBM AIX 5.3,C, C++, pro*C SQL, PL/SQL, TOAD, UNIX, MS Windows 7,VISIO, GOLDEN GATE
PL/SQL Developer Apr’14 – Feb’16
Fiserv – Ohio, Dublin
Responsibilities:
Involved in designing ER diagram using oracle designer, to set the logical and physical relationships of database.
Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
Worked with the Business analysts and the DBA for requirements gathering, business
analysis, testing, metrics and project coordination.
Migration of DBMS jobs to control M.
Scheduling jobs in control M and handling them.
Created SQL*plus reports as per client's various needs, and developed business objects.
Programed in UNIX shell scripts to provide a user interface to Oracle forms and reports.
Oracle Forms developed and deployed in all UNIX environment through Dev, Test, and Prod in an Oracle Applications environment
Developed SQL Scripts, Packages and Procedures for Business rules check to implement
business rules.
Part of a development team for creation and maintenance of custom apps/reports.
Designed and developed different Database Objects (Stored Packages, Procedures, Functions, and Triggers) using PL/SQL for RETEK-12.
Developed C/C++, Pro*C Batch programs using Multithreading Programming for handling
Have involved in data modeling and designing of custom tables.
Support modules for implementation using PL/SQL Scripts, Unix Shell Scripts and Pro*C.
Atomized routine jobs using DBMS_JOB. On completion of these jobs an email will be sent out
automatically with the help of UTL_MAIL.
Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
Performed SQL and PL/SQL Performance tuning and Application Tuning using various tools
like TKPROF, AUTOTRACE and DBMS_SQLTUNE.
Data loaded from legacy systems (ETL Operations) using PL/SQL and SQL*Loader.
Used ORACLE SQL DEVELOPER for creating PL/SQL (trigger, sequence, stored procedure).
Environment: Oracle 9i/10g,Forms 6i/9i, Reports 6i/ 9i, C++, pro*C Reports 9i, SQL, PL/SQL, TOAD, SQL*Loader, UNIX, MS Windows XP/2000, Oracle Development Suite, 11gR2.
Oracle Developer Jan ’13 – Mar ’14
Samsung SDS America – Ridge Field Park, New Jersey
Responsibilities:
Involved in designing ER diagram using ERWIN and VISIO. To set the logical and physical relationships of database.
Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
Developed data model, SQL Coding, SQL Query tuning process and Schemas.
Migration of dbms_jobs to control_M.
Scheduling jobs in control_M and handling them.
Used tortoise svn version control for changing the codes.
Making changes to the existing apex applications in the production.
Created SQL*plus reports as per client's various needs, and developed business objects.
Developed SQL Scripts, Packages and Procedures for Business rules check to implement business rules.
Worked on Forms Triggers, Alerts, Data Blocks, LOVs, Parameters, and Program units by using PL/SQL procedures and functions of OOPS methodology
Tested the Forms, debugged and fixed the Forms after the testing
Used Bulk Collections, Indexes, and Materialized Views to improve the query executions.
Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables in PL/SQL blocks and even have experience with exception handling.
Atomized routine jobs using DBMS_JOB. On completion of these jobs an email will be sent out automatically with the help of UTL_MAIL.
Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
Data loaded from legacy systems (ETL Operations) using PL/SQL and SQL*Loader.
Developed Procedures for efficient Error Handling process by capturing errors into user managed tables.
Worked with java developers to repair and enhance current base of PL/SQL packages to fix production issues and build new functionality and improve processing time through code optimizations and indexes.
Environment: Oracle 9i/10g, Forms 6i/9i, Reports 6i/ 9i, SQL, PL/SQL, TOAD, SQL*Loader, UNIX,
MS Windows XP/2000, Oracle Development Suite, WebSphere 8, MQ.
Oracle Developer Jan ’11 – Dec’ 12
AP Online India Pvt Ltd., India
Responsibilities:
Responsible for analyzing business functionality for the back end processes.
Created PL/SQL stored procedures, functions and packages for moving the data from staging.
Involved in using dimensional modeling, created fact tables, dimensional tables and other
Database objects in the Star schema model.
Developed ETL processes for Data Extraction, Data Mapping and Data Conversion usingPL/SQL scriptsand load data into warehouse Schemas.
Worked on improving the Performance of SQL queries by extensive usage of Explain plan andvarious hints and indexes.
Responsible to load various table data, flat file data to populated and processed on daily basis from legacy to online production environment using SQL*LOADER.
Involved in creating user interface Forms and adhoc reports using Oracle Forms/Reports 6i.
Participated in performance tuning, unit test case preparation and execution.
Environment: Oracle 8i, SQL, PL/SQL, TOAD, SQL*Loader, SQL*Plus, Forms 6i, Reports 6i, Windows 2000.
Database Developer Mar ’09 – Dec’ 10
Harvest Technologies, India
Responsibilities:
Developed and modified a number of Forms and for various modules. Also responsible for following up bugs reported by various users and suggesting possible patches to be applied.
Wrote Shell Scripts for Data loading and DDL Scripts.
Worked in Production Support Environment as well as QA/TEST environments for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc.
Wrote conversion scripts using SQL, PL/SQL, stored procedures, functions and packages to migrate data from SQL server database to Oracle database.
Sequences packages and procedures.
Involved in Logical & Physical Database Layout Design.
Set-up and Design of Backup and Recovery Strategy for various databases.
Used SQL*Loader as an ETL tool to load data into the staging tables.
Provided user training and production support.
Improved the performance of the application by rewriting the SQL queries.
Wrote packages to fetch complex data from different tables in remote databases using joins, sub queries and database links.
Environment: Oracle 8i, SQL, PL/SQL, TOAD, SQL*Loader, SQL*Plus, Forms 6i, Reports 6i, Windows 2000.
Contact this candidate