SUMMARY:

• 12+ years of experience in Oracle PL/SQL Database development in generate packages, procedures, functions, and triggers in ORACLE 11g RDBMS environment
• 12+ years of experience in Oracle Forms and Reports (11g, 10g and 6i) in ORACLE 11g RDBMS environment
• 12+ years of experience in UNIX Shell Script, AutoSys JIL (Job Information Language), Pearl Script
• 12+ years of experience in Data Export/Import with SQL*Loader, Oracle SQLs in Oracle (RDBMS) Database development in Unix (HP and Sun Solaris OS) environment
• 12+ years of experience in TOAD, PL/SQL Developer, FTP, ODBC, Windows Batch Files and Unix / Linux Shell Scripts
• 2+ years of basic experience in Oracle OBIEE with Oracle 11g RDBMS environment
• 2+ years of basic experience in INFORMATICA tools in ETL exposure on Datawarehouse with Oracle 11g RDBMS environment
• 2+ years of Basic Level experience in Oracle APEX/ADF/PYTHON with Oracle 11g RDBMS environment
• 2+ years of basic experience in AWS Colud EC2 Services environment
• 5+ years of experience in Crystal Report, Visual Basic, COBOL, Informix database, and Pro*C
• 5+ years of experience in TCP/IP Concepts, ADO, OLEDB, True DB Grid V6.5, Visual Source Safe and Informix Data Director 3.x for Visual Basic V6 on Informix database with UNIX Environment
• Working experience on SQL Server Management Studio (SSMS) in T - SQL, MS-Visio 2000 & 2003, MS-Word / MS-Excel / PowerPoint 98/2000/XP and Ms-Projects 98/2000
• Working experience on PVCS Source Control Program and Batch Control Program Autosys / Control-M Batch Scheduling tools in Unix Architecture
• Worked on various domain and business environment with the SDLC concepts and implemented applications for various clients in different verticals including Manufacturing, Gold Business, Government, Retail, and Pharmaceuticals

TECHNICAL SKILLS:

Knowledg: Involved in Development, Support, and Maintenance of existing RETEK RMS/RDM systems, Order, Item Maintenance, Allocation System, Coupon System, POS support system and Promotion / BOGOs (Deals) system in Oracle 11g/10g/9i Database environment Worked on the ServiceNow Dashboard tools, Agile software development (Scrum / Sprint / Kanban Board) methodology in DEVOPS Environment Involved in developing Oracle Forms / Reports using Oracle Developer Suite 11g/10g/6i on Oracle 11g/10g/9i Database on Sun Solaris UNIX environment on Oracle Application Client / Server environment Involved in developing user defined complex Stored Procedures, Functions, Packages, Tables, Indexes, External Tables, View, Material Views and Database Triggers using advanced PL/SQL (Procedural Language/Structured Query Language) in Toad Software environment on Oracle 11g/10g/9i Database to optimize processes 24x7 on call support for the Retailer business modules and 100s of Autosys Jobs monitoring in Sun Solaris UNIX sever and maintenance and developed lots of Autosys jobs using the AutoSys JIL (Job Information Language) scripts Involved in Testing, Debugging and User Support for the various Business Modules and Oracle Reports in Oracle application client / server environment Involved in developing the modules using the UNIX (Korn) Shell Scripting, Perl Scripts, and scheduling jobs using AUTOSYS, DBMS SCHEDULER and DBMS JOBS in the Sun Solaris UNIX environment Having a strong Data Warehousing experience in Bulk Collect, View, partitioning, Merge, collection objects and having a strong database query performance tuning skill (SQL tuning) Having a strong Data Warehousing experience in ETL(Extract, Transform, Load) environment using the Oracle SQLs in Oracle RDBMS Having a strong knowledge of using the common database tools like PL/SQL Developer, TOAD, Oracle SQLs developer for Oracle RDBMS, and SQL Server Management Studio (SSMS) for Microsoft SQL Server Having an excellent communication skill, interpersonal skills, motivated, energetic, and team player. Proven ability to accept challenges and produce results in a multi - tasking environment Having a demonstrated proficiency for learning new tools and business environment with excellent Analytical skills. Able to manage changing responsibilities and deliver time critical projects on schedule Support and monitoring the RETEK related real time system like RIB (Retek Integration BUS) Involved in developing the dashboards and reports using in Oracle OBIEE and Oracle BI Publisher Having a knowledge about maintaining the Source Control like PVCS and SVN concepts Having a basic knowledge on the Oracle ADF, Oracle Apex, and PYTHON environment Involved in SQL Performance Tuning using Oracle HINTS in Data Modeling and Data Architecture in Oracle 9i/10g database on Solaris 7 Unix OS environment

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Senior Oracle Database Developer

Responsibilities:

• Involved in Support, Maintenance and Development of the existing RETEK (RMS) system; this system contains lots of modules like Organization and Merchandizing hierarchy related modules, Item, Order Maintenance modules, Price change modules; which will support the business in Retail environment using the Oracle Forms environment
• Along with the existing RETEK system, I have involved to develop lots of customized modules to support and improve our Retails stores business; which are located in various states all around the USA
• Involved in developing the Allocation System to allocate the Order items based on the Store’s sales history and various calculative methodology to maintain the Store’s inventory on regular basis
• Involved in developing the Coupon System to improve the Store’s sales and attractive the customers to buy the product in our retail stores very often
• Involved in the Promotion / BOGO (Deals) system to improve the sales in our retails stores. The process participates in sending lots of Item level information to more than 880 stores over night process. Since this process are involved over 500K item level information has to be send to the 880 stores, it will be a great exposure to me to worked on the system development and handle the large volume of the data as very often
• I have acquired lots of business and systems developed knowledges while worked on the various other POS (Point of Sales) system, Sales and Inventory System, MDO (Markdown Optimization) system, Support and Monitoring of the Retek Integration Bus (RIB) concepts that are common to all Retek applications on the RIB system, and OMS (E-Commerce Order) system
• Involved in System Study, Design and Development of various programming modules like Orders, Allocations, Item Maintenance, Promotions, DEALS, PCMS, Price Change, Sales, and Coupons systems
• Involved in Preparing of System’s HLD (High Level Design) Documentations, Unit Test Documents and User Documentations for the various systems; which are as part of our Retail business environment
• Involved in System Study, Design, Development and implement solutions provided to various programming modules like Orders, Allocations, Item Maintenance, Promotions, PCMS, Coupons in Retail Industries
• Involved in strong tuning skills of SQL and PL/SQL codes, database packages and procedures in the Oracle RDBMS
• Managing the 100s of batch programs in AUTOSYS Batch control on Unix instance
• Involved in creating Database Design (Physical and logical) as per the requirement given by business
• Involved to develop the complex SQL queries using joins, sub queries and inline views to retrieve data from the Oracle database environment
• Involved in UNIX Shell Scripting to automate procedure execution from Solaris UNIX servers
• Involved in developing an AUTOSYS JIL scripts for scheduling jobs and managing critical paths
• Involved in creating end users to run ad-hoc reports and analysis as per business requirement model in the Oracle OBIEE dashboard tool; which is part of Oracle BI Presentation layer services. That enables Interactive dashboards are pixel perfect reports which can be directly viewed or printed by end users

Technology/Platform: Oracle 11g/10g/9i Database, Oracle Developer Suites 11g/10g/6i (Forms / Reports) on Oracle Application server 9i /10g/11g on Sun Solaris Unix, Toad for Oracle Version 9.0.1.8, PL/SQL Developer, Advance PL/SQL, SQL Performance Tuning, SQL*Loader, Windows Client, FTP, Telnet for Unix, PVCS / SVN source control, Oracle OBIEE, AUTOSYS Batch Control Tools, and Unix shell / Pearl script, ServiceNow Dashboard tools, Agile software development (Scrum / Sprint / Kanban Board) methodology Work Environment and AWS EC2 Cloud services

Confidential - Government Atlanta, GA

Senior Oracle Database Developer

Responsibilities:

• The Confidential is a governing body. Confidential, like all public housing authorities, is a non-federal entity that administers affordable housing programs for low-income persons and families. Confidential is not part of HUD, although we do receive funding from HUD. Confidential, Atlanta the largest housing authority in the nation, serving over 50,000 customers. The Oracle CRMS Phase-2 system development environment is in Oracle Developer Suits 10g (Forms and Reports), Oracle AS 10g with Oracle 9i/10g database. Job responsibility is senior oracle Forms, Reports and PL/SQL developer working with the Information Technology division in Confidential .

Technology/Platform: Oracle 10g/9i Database, Oracle Developer Suites 10g (Forms & Reports) on Oracle Application server 10g on Unix, Toad for Oracle Version 9.0.1.8, Advance PL/SQL, SQL Performance Tuning, SQL*Loader, Windows XP, FTP, Reflection X for Unix, CVS source control, PowerBuilder 9 and Unix shell script

Confidential, Ridgefield, Danbury - CT

Senior Oracle PL/SQL Developer

Responsibilities:

• The Confidential Inc. (BIPI) is a first-class and fast-growing pharmaceutical corporation in North America. The Vista 2.4 system development environment is in Oracle Siebel 7.8 CRM with Oracle 9i/10g database. Job responsibility is senior oracle PL/SQL developer working with the Data Integration Team in BIPI.

Technology/Platform: Oracle 10g/9i Database, Toad for Oracle Version 9.0.1.8, Advance PL/SQL, SQL Performance Tuning, SQL*Loader, Windows XP, Siebel 7.8 CRM, PowerBuilder 9, Unix shell script, Control-M for job scheduling and HP UNIX Server