Summary

• Over Nine years of experience in developing and implementing applications with RDBMS concepts as per Industry standards and client Requirements
• Played vital roles in all phases of SDLC, ranging from Business Requirement gathering, Designing Databases, Develop Applications, Unit Testing, System Integrity Testing and User Acceptance Testing
• Hands on experience in Normalization and De-Normalization of database design for OLTP and OLAP systems
• In-Depth Knowledge of Oracle Architecture, data dictionary, to understand Schema Objects, Schema Objects Relations, Schema Privileges, Roles and Restrictions
• Hands on experience in logical and Physical Data Modelling for Business Requirement.
• Experience in Migrating Code to different Environments from development Environment and Packaging developed code to deploy on Clients/Production Database
• In-depth Knowledge of Schema Objects Tables, GT Tables, Views, Materialized views, Constraints, Indexes, Packages, Procedures, Functions, Triggers, Synonyms, Sequences Database links and Bulk collects/Inserts, CURSORS/ REF CURSORS, Analytical functions, Dynamic SQL, Exception Handling, XML Type and Flashback Operation Concepts
• Knowledge of Object Oriented Programming concepts and Modifying, Troubleshooting GUI interfaces in Java Swings
• Extract, Transform and Load legacy data into Data warehouse and create analytical SQL queries with CUBE, ROLLUP, GROUPING SETS and MODEL Clause to generate reports using data in Data warehouse and Data marts
• Developing DDL and DML scripts, monitor execution of scripts which take time to execute using built in API DBMS APPLICATION INFO
• Performance Tuning application using TKPROF, DBMS HPROF, DBMS PROFILER, DBMS SQLTUNE, DBMS MONITOR and through knowledge about ADDR, AWR, cursor Cache, SQL tuning Advisor, SQL profiles, SQL tuning sets
• Good Knowledge of RULE Based Optimizer, COST Based Optimizer and Forced Optimizer Hints.
• Experience in providing production support and also client support to end users via web-ex meetings
• Perform and Identification of data drivers, Identify relevant trends and Follow-up analysis.
• Active team player with commitment to work to meet deadline, strong communication, good analytical and time management skills.
• Hands on experience with ANSI SQL.
• Hands on experience with Data-mining, Analysis and presentation for business managers
• Developed ETL for data extraction, transformation and loading from legacy system into Teradata database using data Mapping, Conversions, PLSQL and shell scripts
• Hands-on experience with scheduling tools like Crontab, Autosys, tidal and dbms schedular.
• Hands-on experience with Oracle APEX.
• Used UNIX shell scripts and PERL programming to accomplish the report Generation and modification of existing reports.

Technical Skills

Projects

Confidential

Position: Sr Oracle Developer

Responsibilities:

• Understanding the business requirement Of the Business Application. Create or modify Schema Objects to accomplish them.
• ETL script and process design and development.
• Data integration and data validation of replication data and data feeds.
• Deployment of pl/sql scripts into different DEV, QA, Staging and production environment.
• Hands-on experience with Application manager, scheduling tool.
• Performance tuning existing procedure using dbms profiler and hierarchical profiler.
• Developed shell scripts to generate reports for the business manager from Database in production.

Environment:. Oracle 11g, UNIX, SQL developer 4.0, CA Harvest Software Change Manager R12.5, Subversion, SQL PLUS., Pauto, Tortoise SVN v1.8, Beyond Compare V2.5, Winscp V5.5, Web ex, HP Application Lifecycle Management Quality Center Edition 11.0, Service Now., Shell scripting, Automic Application Manager.

Confidential

Position: Sr Oracle Developer

Responsibilities:

• Gathering of business requirement and preparation of technical documentation based on business requirements
• Design and Implementation of complex ETL Logic for Hybrid Measure sampling.
• Create Package and procedures to implementation of Hybrid Measure sample business logic.
• Perform Unit testing and end-to end Testing for the Hybrid Measure Sampling process.
• Create pl/sql script and Deployment scripts into different DEV, QA, Staging and production environment.
• Performance tuning existing sql scripts.
• Using Regular expression function to implementation of complex logic and pattern match operations.

Environment: Oracle 11g/10g, SQL developer, SQL PLUS, Visio, Rally.

Confidential

Position: Sr Oracle Developer

Responsibilities:

• Testing new mail utilities for security of end users
• Create shell script, configuration files for reports
• Gathering of business requirement and preparation of technical documentation based on business requirements
• Creation and performance tuning of sql script for reports
• Testing of the new reports based on technical documentation and business requirement regarding to different business scenarios.
• Generate adhoc reports for managers.
• Identification of data drivers, data-mining and follow up analysis.
• Use of analytical functions and ANSI SQL in sql reports.
• Deployment of PL/SQL scripts into production from unix box.
• Data integration of replication data.
• Hands-on experience with crontab, scheduling tool.
• ETL script and process design and development.
• Using unix output format like email, gzip, gpg, ftp etc.,

Environment: Oracle 11g/10g, Toad, SQL PLUS, Unix, Putty, bug zilla, windows power shell.

Confidential

Position: Sr Oracle Developer

Responsibilities:

• Prepared technical documentation about the implementation of business logic, Workflow diagrams and Activity diagrams
• Understanding the business requirement Of the Business Application. Create or modify Schema Objects to accomplish them.
• Involved in creating logical and physical data model for Data modeling of application.
• To synchronize schema objects from different databases.
• Work with data modeling using ERwin data modeler
• Deploy scripts to different environments like Development, Testing QA , staging ITG and Production.
• To create package, procedure and function for generation of scripts for metadata of schema objects using in-built API's like dbms metadata, dbms lobs..,
• Data integration into fact or lookup tables with Business rules.
• To resolve the data integrity issue among the upstream and Downstream applications.
• To maintain script in Git source control.
• Hands-on experience with Autosys scheduler.
• ETL for new application lookup data from upstream Business Applications using INFORMATICA IDQ.
• Working with the front end Java developers in creating schema objects and resolving any issue related to database.

Environment: Oracle 11g/10g, ERwin, SQL developer, SQL PLUS, source tree, windows power shell, ALM, Visual Studio 2010.

Confidential

Position: Sr Oracle Developer

Responsibilities:

• Understanding the existing business applications functionality, technology and requirements by referring through documentation, WebEx meeting records, database table and reviewing the source code.
• Understanding of data extraction, transfer and loading in existing applications
• Analysis of source code for existing applications, delegation and assignment of work with offshore team.
• Hands on experience with Data-mining and ANSI SQL.
• Developing the PL/SQL script to extract data from database
• Developing ER diagram of existing database in reverse engineering for schema object changes.
• Data mapping for ETL and Data Integration.
• Performance tuning the existing procedures in the packages.
• Hands-on experience with Tidal scheduler
• To add metadata changes to central repository
• Co-ordinate with team to resolve the production issues in SQL scripts and suggestion for modifications.

Environment: Oracle 11g/10g/9i, SQL PLUS, TOAD, UNIX, ERWIN, CVS, XML, WebEx , Workflow Manager, Mapping Designer, MS VISIO, Performance Tuning.

Confidential

Position: Sr Oracle Developer

Responsibilities:

• Procuring existing documentation for knowledge transfer projects from share point, code repository like CVS and Clear case of legacy system.
• Using Dynamic SQL and ANSI SQL for Report generation purposes in stored procedures.
• Understanding the existing business applications functionality, technology and requirements by referring through documentation, Microsoft visio documentation, database table and reviewing the source code.
• Used PERL programming and shell script for report generation to executive and field level business managers.
• Analysis of source code for existing applications, delegation and assignment of work to offshore team.
• Hands on experience with Data-drivers identification and analysis.
• Developing the PL/SQL script to extract data from database maintain Data Integration of data.
• Developing ERD diagram for existing database
• Data mapping for ETL.
• To reverse engineer for generate data model for existing applications
• Understanding of data extraction, transfer and loading in existing applications
• Preparation of the Knowledge transfer documentation.
• Guiding the offshore team to contribute to the success of Knowledge transfers. Co-ordinate with them to resolve the production issues in SQL scripts.
• Worked on Manugistics for Supply chain Management.
• Update Manage on project progress.
• Experience with supply chain management
• Familiar with fundamental concepts of Oracle IOP.

Environment: Oracle 11g/10g/9i, Toad, SQL PLUS, TOAD, UNIX, ERWIN, CLEAR CASE , XSL, Crystal Reports, Workflow Manager, Mapping Designer, MS VISIO, SQL Tuning/ Optimization, Manugistics JDA supply chain software .