SUMMARY

• Over 8 years of programming experience as anOracle PL/SQLDeveloper in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
• Involved in all phases of theSDLC (Software Development Life Cycle)from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Experience withData flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modelinganddesign techniques.
• Expertise in Client - Server application development using OracleR12/11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOADand SQL*LOADER.
• Strong experience inData warehouse concepts.
• Good Knowledge on logical and physical Data Modeling using normalizing Techniques.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling forOLTPand dimension modeling forOLAP.
• Extensively used ETL methodology for supporting of Extract, Transform, and Load environment using Informatica Power Center 8.x/7.1 (Designer, Repository manager, Repository Server Administrator console, Server Manager, Work flow manager, workflow monitor).
• For major technical issues worked in collaboration with JDA for resolution.
• Marketed other JDA products to the client and the actual users as Wipro representative to bring more business for her own company
• Experience with full development cycle of a Data Warehouse, including requirements gathering, design, implementation, and maintenance.
• Extracted Transformed and Loaded (ETL) data source database to data warehouse system.
• Coded PL-SQL packages and procedures to perform data loading, error handling and logging. Tied the procedures into an existing ETL process.
• Initialized utilization ofData WarehouseETL software during conversion of Legacy data in IMS to Oracle.
• Extensively analyze the security holes in the PLSQL and Java script coding. Fixed all the security hole and bugs in most of the packages and also fixed security hole in control file’s of the Sql*loader.
• Wrote and modified Oracle PL and SQL, Sql statements procedures and functions that are called in the Java Scripts, Jsp and EJBs.
• Experience inOracle supplied packages, Dynamic SQL, RecordsandPL/SQL Tables.
• Portal included strong Java coding experience.PL/SQL scriptsin an Oracle RDBMS environment
• Designed allows JavaScript to be embedded into aform, allowing programmatic changes to theformlayout as well as communication with various data sources (ORACLEFORMSAND REPORTS, OLEDB)
• Experience in SQLperformance tuningusing Cost-Based Optimization (CBO).
• Experience withPerformance Tuningfor Oracle RDBMS usingExplain Plan and HINTS.
• Experience inETLtechniques and Analysis and Reporting including hands on experience with the Reporting tools such as Cognos.
• CreatedShell Scriptsfor invoking SQL scripts and scheduled them using crontab.
• Developed Unix Shell Scripts and DBMS Jobs to automate jobs and loading data into the Database using SQL* Loader.
• Experience in data migration from legacy systems to Oracle Databases using tools like SQL, PL/SQL, SQL*Loader and Unix Scripts.
• Developed and maintained Oracle Forms and Reports for various applications using SQL*Plus and PL/SQL.

TECHNICAL SKILLS

Databases: Oracle 7.x/8i/9i/10g/11g/R12 (SQL, PL/SQL, Stored Procedures, Triggers), MS SQL SERVER 2000/2005/2008 , DB2/UDB, Tera data, SAP Tables and MS Access.

Hardware: HP-9000, RS-6000, Sun Spark Server 20, Intel 80x86 based Computers, Compaq Pentium/486.

Operating System: Windows XP, Windows NT/95, Windows for Work Group 3.11, HP-UNIX, Digital UNIX, UNIX SAS.

RDBMS: ORACLE 7.x/8.0/8i/9i/10g/11g/R12.

Languages: SQL*Plus, PL/SQL, PRO*C, C, Java.

Software: Developer/2000 Forms 4.5/5.0/6i/9i & Reports 2.5/3.0/6i/9i, Designer/2000.

Others: MS Office for Windows 95. PL/SQL Developer.

PROFESSIONAL EXPERIENCE

Confidential, NJ

Oracle PL/SQL Developer

Responsibilities:

• Actively involved in each phase ofSoftware Development Life cycle (SDLC): Requirements, Specification, Design, Implementation, and Testing.
• Working with globally distributed agile teams and delivering next-gen security software to reduce risk throughout the software lifecycle.
• Strong design and development experience in JDA Demand, Fulfillment & Transportation.
• Create JDA database schema and structures.
• Technical experience working on JDA 7.7 and above, currently in doing 8.1.
• Used the descriptors for getting the input and output values in ANSI SQL.
• Alerted software staff to ANSI-compatible functions to reduce code changes between Oracle and SQL Server versions.
• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Worked onSQL*Loaderto load data from flat files obtained from various facilities every day.
• Develop the Perl and Shell scripts to automate the finance billing file.
• Develop the post-processor script in PERL for American Funds ingestion process to move the pdf files to the NAS mounted directory structure based on the config file format.
• Also, use Perl scripting tool to read /write user data into the test bench.
• Created many migration and maintenance scripts in Perl.
• Implemented Perl packages extensively. Used multithreading. Used SOAP Lite module to communicate with different web-services based on given WSDL.
• Created and modified severalUNIX shell Scriptsaccording to the changing needs of the project and client requirements.
• Using UNIX environment for performing the testing.
• Automated data fetch using UNIX shell script.
• Developed Unix Shell Scripts and DBMS Jobs to automate jobs and loading data into the Database using SQL* Loader.
• Worked with Type 1 and 2 dimensions, Fact Tables, Star Schema design, Operational Data Store (ODS), leveling and other Data Warehouse concepts.
• Designed and implemented a multi tier data warehouse And Data Mart using SQL Server 2008.
• Involved in various projects related toData Modeling, System/Data Analysis, Design and Development for both OLTP and Data warehousing environments.
• Extensively involved in UNIX shell scripting for writing Wrapper scripts, SQL Execution scripts in ETL processes.
• Developed an application for the purchasing department using SAS.
• Developed six reports using Proc Reports with SAS datasets.
• Wrote Unix Shell Scripts to process the files on daily basis like renaming the file, extracting date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.
• Created scripts to createnew tables, views, queriesfor new enhancement in the application using TOAD.
• Knowledge on using Swing Concepts in Java Front End Forms are designed.
• Involved in data loading usingPL/SQLandSQL*Loadercalling UNIX scripts to download and manipulate files.
• PerformedSQL and PL/SQL tuningand Application tuning using various tools likeEXPLAIN PLAN, SQL*TRACE, TKPROFandAUTOTRACE.
• Handled errors usingException Handlingextensively for the ease of debugging and displaying the error messages in the application.
• Worked onJDeveloperfor development in Java, XML, SQL and PL/SQL, HTML, JavaScript, BPEL and PHP.
• Worked on OracleWeb Apache Serverfor configure of upload and download with the required Oracle forms refers to a class of systems that facilitate and manage transaction-oriented applications, typically for data entry and retrieval transaction processing.
• Used built-in functions in oracle forms.
• Made Forms customization on various existing forms.

Environment: Oracle 11g, SQL * Plus, TOAD, SQL*Loader, JDA, SQL Developer, ANSI SQL, Shell Scripts, UNIX, Perl, Java, Windows XP.

Confidential, Dayton Beach, FL.

Oracle PL/SQL Developer

Responsibilities:

• Developed Perl scripts to load data feeds into GASS and to generate feeds for the downstream systems.
• Suggested effective implementation processes of JDA modules for versions such as Demand and Master Planning.
• Prepared detailed technical documentation for ecommerce JDA enterprise operations and plans.
• Participated in workshops to discuss technical and functional designs in collaboration with JDA functional consultants.
• Supported technical team members for installation and configuration of JDA enterprise architecture.
• Working with an Agile, Scrum methodology to ensure delivery of high quality work with every monthly iteration.
• Established and maintained comprehensive data model documentation including detailed descriptions of business entities, attributes, and data relationships.
• Developed Perl scripts to automate frequent reports for the users.
• Writing scripts in Perl for automating the release process.
• Involved in creatingUNIX shell Scripting. Defragmentation of tables, partitioning, compressing and indexes for improved performance and efficiency. Involved in table redesigning with implementation of Partitions Table and Partition Indexes to makeDatabaseFaster and easier to maintain.
• Extensively involved in UNIX shell scripting for writing Wrapper scripts, SQL Execution scripts in ETL processes
• Resolved different kinds of tickets issued to us which involved in UNIX shell scripting, modifying database tables, hands on UI changes using HTML5.
• Component in data warehouse project planning.
• Responsible for gathering requirements and designing data mart entities and data warehouse.
• Handling the design, development, testing and deployment of custom data warehouse systems.
• Involved in writing Oracle PL/SQL Stored Procedures/Functions and to create the necessary indexes and work tables for performing the ETL process.
• Experience inDatabase Application Development, Query Optimization, Performance TuningandDBAsolutions and implementation experience incomplete System Development Life Cycle.
• Designed and developedOracle forms & reportsgenerating up to 60 reports.
• UsedCrystal Reportsto track logins, mouse over's, click-through, session durations and demographical comparisons with SQL database of customer information.
• Used principles of Normalization to improve the performance. Involved inETLcode usingPL/SQLin order to meet requirements for Extract, transformation, cleansing and loading of data from source to targetdata structures.
• DevelopedUNIX Shell scriptsto automate repetitivedatabase processes.
• Designed and DevelopedJSP programsby using Web Logic, an Eclipse IDE for Java, SOA and Rich Internet applications.
• Created layout wizard and data block wizard in oracle forms.
• Developed complex SQL Coding and used in creating Reports and Forms.
• Designed and developed user interfaces using Oracle Forms.
• Developed screens andForms10g usingOracle Forms/Reports9i. Also developedreportsusing Pro*C andPL/SQL
• WroteCrystal Reports as business intelligence applicationto design and generate reports from a wide range of data sources.

Environment: Oracle R12/11g, SQL * Plus, JDA, TOAD, SQL*Loader, ANSI SQL, SQL Developer, Java, Shell Scripts, Perl, UNIX, Windows XP, Oracle Forms /Reports.

Confidential, Dallas, TX

Oracle PL/SQL Developer

Responsibilities:

• Designed/developed/Modifiedtables, views, materialized view, stored procedures, packagesandfunctions.
• Coded PL-SQL packages and procedures to perform data loading, error handling and logging. Tied the procedures into an existing ETL process.
• Supported Business Objects Universe for data warehouse analytical reporting.
• Evaluated SQL Server 2005 and formulated migration plan for ongoing data warehouse development.
• Created source, target, and process models to load data with DB2 Data warehouse Center.
• Designing, Implement and delivering data warehouse ETL and reporting applications.
• Worked on the Performance tuning of the programs, ETL Procedures and processes.
• Extracted Transformed and Loaded (ETL) data source database to data warehouse system.
• ImplementedOracle Web Logic Server 11gSecurity on application business logic security code to complete scope of security coverage for all Java EE and non-Java EE components.
• Portal included strong Java coding experience.PL/SQL scriptsin an Oracle RDBMS environment
• Createdpartitioned tablesandpartitioned indexesto improve the performance of the applications.
• WrotePL/SQL Database triggersto implement the business rules in the application.
• Developed various backend application programs, such asViews, Functions, Triggers, ProceduresandPackagesusingSQLandPL/SQLlanguage for the top management for decision making.
• Created and customized UNIX shell scripts for automating regular maintenance and batch jobs.
• Developed SQL*loader scripts to load data from various forms of flat files into staging tables in Oracle database using shell scripts.
• Created LOV’s for data elements in Oracle Forms.
• Design and development of several PL/SQL packages, procedures and functions that were used in Custom Reports and Forms development.
• WroteCrystal Reportsas graphically design data connection(s) and report layout.

Environment: Oracle R12, SQL * Plus, TOAD, SQL*Loader, SQL Developer, Unix Shell Scripts, ETL, Crystal Reports, UNIX scripts, Windows XP.

Confidential, TX

Oracle PL/SQL Developer

Responsibilities:

• Developedstored procedures to extractthe data from different sources and load it into data warehouse.
• Analyzing the data and Mapping the data requirementsdeveloping Stored Procedures, Functions and Triggers.
• Involved in uploading of the data from flat files into Databases and validated the data with PL/SQL procedures.
• Worked with Type 1 and 2 dimensions, fact tables, star schema design, Operational Data Store (ODS) and other data warehouse concepts.
• Database development and ETL process in Oracle l0g and Greenplum using PSQL, SQL, PERL and UNIX scripting.
• DevelopedETLprograms (Mappings, Sessions, Workflows) viaInformatica 7.1.4.
• Analysis of source systems and work with business analysts to identify study and understand requirements and translate them into ETL code.
• Involved in Business Requirements, System analysis and Design of the Data warehouse application.
• Created Stored Procedures, Functions and Triggers to maintain various business rules in the Active Data Warehousing Project.
• Maintainingdaily batch cycleand providing 24 hour production support.
• Preparation of the Test Cases and involvement in Unit Testing and System Integration Testing.
• UtilizedSQL*Loaderto load flat files into database tables.
• CreatedSQL*Loaderscripts to load data into temporary staging tables.
• PerformedSQL tuningusingExplain Plan, Tkprof, Hintsandindexes.
• Developed reports using complex queries as per client request as a part of production support.
• Resolving Production severity Issues in time and meeting the SLA.
• Performed on variousOracle databases Architect presentationlayers likeOracle forms/reports.
• DevelopedForms Screensused by Oracle Developer Suite forforms procedures, functions and packagesgenerate to end product of forms.
• Programmed inUnixshell scripts to provide a user interface toOracle formsandreports.
• Some exposure to Business Objects reporting tools and Crystal Reports.

Environment: Oracle 11g, UNIX shell scripting,10g,11g, PL/SQL, Toad, Informatica, Forms and Reports, Data warehouse concepts, TOAD, SQL developer.

Confidential, PA

Oracle PL/SQL Developer

Responsibilities:

• Involved in system study, requirements analysis and design documentation.
• Prepared technical specifications document (MD 70) based on the functional requirement specifications (MD 50).
• Developed Data Conversions and Interface Programs in INV, OM, AR, WSH and BOM using PL/SQL, SQL, SQL*Loader Scripts and Bulk Binding concepts.
• Developed Item Master Conversion and BOM Conversion programs.
• Customized the standard Workflow Items and process such as Order Headers and Order Line.
• Developed scripts for entering transactions like Regular orders, Inter Company Invoicing, Regular Invoicing, Invoicing Rules and different methods of Receipt Processing and application in OM and AR (Order Management and Accounts Receivable).
• Designed and developed Inbound Interface Program using APIs to load the shipped orders into standard OM tables, to bind the customized WSH (Shipping) system with OM (Order Management).
• Customized Standard reports in OM, WSH and AR using XML publisher & Report Builder 10g like: 1. Pick slip report, Lines on Credit Check Hold Report OM, 2. Orders by Item Report in WSH, 3. Aging - 4 Bucket Report in AR.
• Worked on Forms Personalization.
• Maintained Discoverer access levels using Discoverer admin.
• Involved in Preparing Training material for WSH (Shipping), Order Management and Account Receivables.
• Involved in Performance tuning of various queries using TK-PROF and Explain Plan.
• Support for maintenance, troubleshooting of R12 environment.
• Oracle Forms developed and deployed in allUNIX environmentthrough Dev, Test, and Prod in an Oracle Applications environment.

Environment: Oracle Application 11g, SQL*Loader, Toad, UNIX, Discoverer, Workflow Builder 2.6.3.5, Report Builder 10g, Form Builder 10g, XML publisher.

Confidential

Oracle Developer

Responsibilities:

• Involved in collecting functional specifications and converting them into technical specifications.
• Developed the PL/SQL programs which would be a part of central engine to perform the tasks created.
• Development of PL/SQL stored procedures, triggers, functions and packages.
• Used PL/SQL programming to develop Stored Procedures/Functions and Database triggers including standard packages like DBMS SQL, DBMS PIPE, DBMS JOBS, UTIL FILE, and DBMS OUTPUT.
• Involved in modifying various objects like Tables, Indexes and Views.
• Use of SQL*LOADER for loading data from flat files into oracle database.
• Involved in Unit testing and Documentation design.
• Consolidated documentation on the project.
• Created unit test and integrity test plans and test cases, executed test cases and documented the test results.
• Tested the integration of various components to make sure the system as a whole is working intact.

Environment: Oracle 8i, SQL*PLUS, PL/SQL, SQL*LOADER, TOAD, Windows NT, UNIX .

Confidential

Oracle Developer

Responsibilities:

• Created Tables, Views, Triggers and Indexes.
• Implemented database packages and procedures using PL/SQL.
• Designed and Developed data entry screens in Forms.
• Developed reports in Reports like daybook, general and party leaders, trail balance, profit & loss statements and balance sheet.
• Developed Master Detail and Tabular reports.
• Involved in User training.

Environment: C, C++, Oracle 8i, PL/SQL, Toad, SQL developer.