SUMMARY:

• Hands - on Oracle Database developer; Including Analysis, design, development, testing and implementation of projects in Retail and Financial domain.
• Extensive experience in Oracle PL/SQL, SQL*Plus, SQL*Loader, Greenplum import/export functionalities, building advanced relational database objects and Forms 10g & Reports 10g as front-end on Windows and UNIX environment (K-shell). Support which uses Oracle 8i/9i/10g database, Shell Scripting and UNIX (K-shell).
• Thorough knowledge of Oracle and Manugistics Demand Module, Arig Rockblocks.
• Functional Analysis, Technical Analysis, Coding, Testing, Deployment, Debugging and Troubleshooting of Oracle application for clients like Timberland, IKEA, Prudential etc.
• Hands on knowledge and understanding of underlying database architecture and concepts.
• Experienced in interacting with system users in understanding business requirements and project use cases for development of project.
• Worked on integration and implementation of projects and products, database creations, modeling, calculation of object sizes, table spaces and database sizes.
• Followed software development life cycle and conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues
• Proficient in setting up Materialized Views/Snapshots for data replication
• Involved in Quality Related Processes for identifying major defects in the projects and provided a preventive action

TECHNICAL SKILLS:

Programming Languages: C, PL/SQL, Visual Basic, Fox-pro

Office Tools: MS Office, MS Visio.

Database: MS Access, Oracle 9i, Oracle 10g, Greenplum

ETL Tool: SQL * Loader, Import/Export

Reporting Tool: Oracle Forms & Report 6i/10g, SAS 9.0

Operating Systems: Windows 9x/2000, XP, NT, UNIX, Windows 7.

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Programmer Analyst

Responsibilities:

• Interacting with Business users, gathering and analyzing requirements
• Developed complex PL/SQL packages, using Oracle's features such as VARRAYS, Associative arrays.
• Design of logical and physical data model of the components.
• Writing complex SQL queries and PL/SQL procedures to extract data from various source tables.
• Performance tuning of multiple application mappingsto improve performance; PDO (Push down optimization), bulk loadingand also addingindexes& constraints on the staging tables.
• Creating User defined function for loading of data from SQL Server to Greenplum
• Preparing documentation for Unit, Regression, Integration, and Final End-to-End Testing.
• Created test cases, test plans and deployment of code across Dev, Test and Prod Repositories.
• Developed scripts for purging database logs, archive logs based on various policies.
• Loading data from flat files to staging tables using Greenplum user defined functions
• Design user defined functions for transferring data from SQL Server to Greenplum
• Design user defined functions to transfer and convert tables directly to Greenplum from SQL server
• Design user defined functions for transfer table definition and data from SQL server to Greenplum
• Design user defined functions to compare two tables in different schemas Converting procedures, functions and UNIX scripts to Greenplum functions
• Rewriting Cognos queries for optimization
• Worked with Reporting group to facilitate report request and Build base tables for effective and efficient reporting needs.
• Worked on designing/developing theControl-M jobsbased on thedependencies

Environment: Oracle11g, Oracle PL\SQL, SQL Server 2005, Greenplum, UNIX, PG Admin

Confidential

Oraclepl/SQL Developer

Responsibilities:

• Interacting with Business users, gathering and analyzing requirements on calls or net meeting.
• Involved in design of logical and physical data model of the components.
• Designed star schema using dimensional modeling and created fact tables and dimensional tables.
• Involved in designing the data model (logical/physical) by creating new objects and by using existing objects of the data mart as per the business requirements using the ER-win.
• Loading data from flat files into to database tables using SQL*Loader.
• Used features like PL/SQL Record inserts & updates of Oracle 9i.
• Automating data loading, extraction, report generation using UNIX shell scripting.

Environment: JAVA, JDeveloper, Oracle SQL 10g, SQL Loader, Windows NT

Confidential

Software Developer

Responsibilities:

• Writing stored procedures for reports generation at the end of the month or every week.
• Designing the database for the application using Oracle Mobile-Server
• Involved in designing the data model (logical/physical) by creating new objects and by using existing objects of the data mart as per the business requirements using the ER-win.
• Developed front end restaurant automation system using Android programming or packages in JAVA.

Environment: JAVA, Android, Eclipse, Oracle Mobile Server Database, SQL Loader, Windows NT

Confidential

Senior Oracle Programmer

Responsibilities:

• Involved in the optimization of process performances b, creating indexes on tables, reducing context switching by usin Collections.
• Developed various complex PL/SQL packages, using Oracle's features VARRAYS, Associative arrays.
• Interacting with Business users, gathering and analyzing requirements on calls or net meeting.
• Involved in design of logical and physical data model of the components.
• Writing complex SQL queries and PL/SQL procedures to extract data from various source tables.
• Designed star schema using dimensional modeling and created fact tables and dimensional tables.
• Involved in designing the data model (logical/physical) by creating new objects and by using existing objects of the data mart as per the business requirements using the ER-win.
• Created PL/SQL packages, procedures, cursors and exception handling.
• Loading data from flat files into to database tables using SQL*Loader.
• Used features like PL/SQL Record inserts & updates of Oracle 9i.
• Extensively worked on Explain plans and various hints for Performance tuning.
• Automating data loading, extraction, report generation using UNIX shell scripting.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and maintained logs for the results.
• For Optimization Process actively involved in creating views, materialized views, partitioning tables and creating indexes etc.
• Responsible for code migration of existing application from SQL Database to Oracle Database. .
• Worked with Reporting group to facilitate report request and built base tables for effective and efficient reporting needs.
• Extensively worked on form attributes like Alerts, Attached Libraries, Editors, LOV’s, Program Units, Record groups and Menus.
• Personalized standard reports and forms according to business requirements, using Oracle Forms and Reports.
• Attended Design meetings, code review and test review meeting before checking code into CVS.
• Used Dynamic SQL in procedures using DBMS SQL package and EXECUTE IMMEDIATE command.
• Performed the uploading and downloading flat files from UNIX server using FTP.
• Involved in debugging and Tuning the PL/SQL code, tuning queries, optimization for the Oracle database.
• Review data transformation rules and provide technical suggestions in data transformation logic and pseudo code (PL/SQL)
• Attended status meetings and technical meeting with Developers from various other application and DBA to discuss bottlenecks in the systems and potential.
• Involved in different phase of testing like User Acceptance Testing, Unit testing.
• Involved in writing Test cases and performing data validation and process testing for application moving into production

Environment: Oracle PL\SQL, Oracle Forms & Reports 10g, Arigo, Manugistics(Demand Module), Unix CRON jobs, MS Visio, TOAD, Excel, Access, Windows NT

Confidential

Senior Oracle Programmer

Responsibilities:

• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Created SQL*Loader control files for moving the data from flat files to staging area tables.
• Analysed the Sqltrace (for tuning database of 5 terabytes) using TKPROF for several sql scripts.
• Implemented Complex business Logic as per the client requirement.
• Prepared unit test cases and executed the same.
• Participated in System test case preparation and execution.
• Worked on tuning the SQL Queries for better performance.
• Performance tuning: Partitioning the fact tables and materialized views to enhance the performance.
• Developed Reports to extract the monthly sales information.
• Prepared daily reports from the invoice data received for different department like sales, marketing.
• Customized Reports to change its layout like changing size of the fields, adding some extra field into the display, changing the display of the reports.
• Worked closely with Production Support team to Troubleshoot and fix any production issues.
• Responsible for code migration of existing application from SQL Database to Oracle Database.
• Performed the uploading and downloading flat files from UNIX server using FTP.
• Involved in debugging and Tuning the PL/SQL code, tuning queries, optimization for the Oracle database.
• Review data transformation rules and provide technical suggestions in data transformation logic and pseudo code (PL/SQL) program asynchronously.
• Wrote SQL Loader control file for flat file data load and scheduled them in UNIX cron job to load every night in Production Environment.
• Developed systematic strategy for measurements of free space in table spaces & trend analysis of this growing database
• Wrote many simple and complex ad-hoc reports using SQL Plus and TOAD for the business users.
• Transformed complex business rules to Oracle PL/SQL.

Environment: Arigo,PL\SQL, Oracle 10g, Oracle Forms & Reports 10g, UNIX, Windows NT and Oracle, UNIX

Confidential

Senior Programmer/Analyst

Responsibilities:

• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Created SQL*Loader control files for moving the data from flat files to staging area tables.
• Implemented Complex business Logic as per the client requirement.
• Prepared unit test cases and executed the same.
• Participated in System test case preparation and execution.
• Worked on tuning the SQL Queries for better performance.
• Performance tuning: Partitioning the fact tables and materialized views to enhance the performance.
• Developed Reports to extract the monthly sales information.
• Prepared daily reports from the invoice data received for different department like sales, marketing.
• Customized Reports to change its layout like changing size of the fields, adding some extra field into the display, changing the display of the reports.
• Worked closely with Production Support team to Troubleshoot and fix any production issues.
• Responsible for code migration of existing application from SQL Database to Oracle Database.
• Performed the uploading and downloading flat files from UNIX server using FTP.
• Involved in debugging and Tuning the PL/SQL code, tuning queries, optimization for the Oracle database.
• Review data transformation rules and provide technical suggestions in data transformation logic and pseudo code (PL/SQL) program asynchronously.
• Wrote SQL Loader control file for flat file data load and scheduled them in UNIX cron job to load every night in Production Environment.
• Developed systematic strategy for measurements of free space in table spaces & trend analysis of this growing database
• Wrote many simple and complex ad-hoc reports using SQL Plus and TOAD for the business users.
• Transformed complex business rules to Oracle PL/SQL.

Environment: Manugistics (Demand Module), Oracle, PL/SQL, UNIX, IBM Rational Clear Quest.HP Quality Centre Windows NT, XP, 2000.

Confidential

Oracle Developer

Responsibilities:

• Involved in Data Analysis and Requirements gathering.
• Developed Design Documents.
• Actively participated through the whole life cycle of the project.
• Involved in Database Design.
• Developed Stored Procedures and Functions.
• Involved in problem analysis and resolution, troubleshooting, performance tuning and code fixes of various Stored Procedures running in development and production environment.
• Developed and managed Standard customer reports.
• Interacted with Business users and developed reports in excel using TOAD.
• Coded storedProcedure Function Packages and strong and weak Ref Cursor, to provide the best performance for the Reports.
• Automation of the procedures to copy the data from the production servers to the test
• Doing recovery of databases from the backups taken in case of database crashes.
• CreatedViewsto fulfill the requirement of Reports.
• Developed Menu screens, Allotment entry screens, Certificate generation screen, Transfer of bonds screen, Payment of Interest screen, Deduction of tax screen, Splitting of certificates and generation of duplicate certificates screen, Reports menu screen and query screens based using Oracle Forms.
• Developed various Reports namely Allotment letter, Certificate printing, Interest warrants and interest covering letter, Tax Deduction at Source Report.
• Created and managed primary data base objectssuch as Tables, Views, Indexes, Sequences, and Synonyms.
• Actively involved in System testing and deploying application.
• Involved in developing data conversion programs using SQL, PLSQL and UNIX shell scripts.

Environment: Oracle forms 9i, Oracle reports 9i, implemented on Oracle application server 10g, MS Access, Excel, Windows 2000.

Confidential

Corporate Oracle Trainer/Software Developer

Responsibilities:

• Conduct training sessions for clients on Oracle Developer Track, Oracle Application Server and related technologies.
• Customize training content according to the requirements of clients.
• Training of full Oracle 9i Developer Track to 150 people at one time.