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, and AUTOSYS JIL (Job Information Language)
• 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, Oracle SQl Developer, PL/SQL Developer, FTP, ODBC, Windows Batch Files and Unix / Linux Shell Scripts
• 3+ years of experience in OLTP and OLAP process, INFORMATICA Power Center tools in ETL exposure on Datawarehouse with Oracle 11g RDBMS environment
• 2+ years of experience to develop the reports and dashboards in Oracle OBIEE with Oracle 11g RDBMS environment
• Basic level personal experience in Oracle APEX/ODI/ADF with Oracle 11g RDBMS environment
• Basic level personal experience in PYTHON with understanding knowledge
• Basic level personal experience in AWS Colud EC2 Services environment with DevOps process
• Working experience in Oracle 11.5.10 or R12 experience within Oracle Finance modules including Oracle GL, and AP Modules
• 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
• 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 RMS 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
• Involved and responsible for the successful delivery of business intelligence information to the entire organization and is experienced in BI development and implementations, data architecture and data warehousing.
• OLTP(Online Transaction Processing) is a class of software programs capable of supporting transaction-oriented applications on the Internet. Typically,OLTPsystems areusedfor order entry, promotion/ deals / coupons, financial transactions, customer relationship management (CRM) and retail sales.
• Additional responsibilities include in the Data warehouse environment:
• Creating Star schema and/or Snowflake schema data models, performing ETLs and validating results with business representatives
• Supporting implemented BI solutions by: monitoring and tuning queries and data loads, addressing user questions concerning data integrity, monitoring performance and communicating functional and technical issues.
• Supporting the Databases configured for OLAP (Online Analytical Processing) use a multidimensional data model, allowing for complexanalyticaland ad hoc queries with a rapid execution time. They borrow aspects of navigational databases,hierarchicaldatabases andrelationaldatabases.
• 24x7 on call support for the Retailer business modules and 100s of Autosys Jobs monitoring in Sun Solaris UNIX server 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 and responsible for the successful delivery of business intelligence information to the entire organization and is experienced in BI development and implementations, data architecture and data warehousing.
• OLTP(Online Transaction Processing) is a class of software programs capable of supporting transaction-oriented applications on the Internet. Typically,OLTP(Online Analytical Processing) systems areusedfor order entry, promotion/ deals / coupons, financial transactions, customer relationship management (CRM) and retail sales.
• Additional responsibilities include in the Data warehouse environment:
• Creating Star schema data models, performing ETLs and validating results with business representatives
• Supporting implemented BI solutions by: monitoring and tuning queries and data loads, addressing user questions concerning data integrity, monitoring performance and communicating functional and technical issues.
• Supporting the Databases configured for OLAP use a multidimensional data model, allowing for complexanalyticaland ad hoc queries with a rapid execution time. They borrow aspects of navigational databases,hierarchicaldatabases andrelationaldatabases.
• 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 support and maintenance of the Oracle 11.5.10/R12 experience within Finance modules including Oracle GL, and AP
• 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, Atlanta, GA

Senior Oracle Database Developer Position: Consultant

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. ( Confidential ) 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 Confidential .

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