SUMMARY

• Over 8 years of IT experience in RDBMS concepts, Application Analysis, Data Warehouse, Application Development, Testing and Implementation using Oracle 11g/10g/9i/8i, SQL, PL/SQL, Reports 6i/9i/10g, Forms 6i/9i, SQL* LOADER, Oracle E - Business SuiteApplications, Query Optimization, Performance Tuning and Trouble Shooting.
• Thorough knowledge in software processes and involved in all phases of development life cycle.
• Successfully provided customized solutions improving business processes, operations and profitability.
• Demonstrated ability to develop partnerships, negotiate with and influence senior executives in matrixed organizations.
• Good functional background and real world business experience in major aspects of Human Resources.
• Extensive exposure to concepts of Data warehouse like Design, Data Modeling, OLTP, ETL and Reporting.
• Experience in OLTP System Study, Analysis and E-R modeling, understanding in developing Database Schemas and also created different Schemas and maintained Schema objects.
• Extensively worked on Backend Programming using PL/SQL, Stored Procedures, Functions, Packages, Database triggers for Oracle 10g/9i/8i and also SQL queries/reports and scripts
• Expertise in SQL and PL/SQL programming, developing complex code units, database triggers and using the latest features to optimize performance (Bulk Binds, Materialized views, Inline views, Global Temporary Tables).
• Experience inOracle E-Business SuiteApplications including 1 years of experience in the area of Accounts & Finance.
• Expertise in the AIM Methodology, Documentation, Configuration of Applications, Testing, End-User Training and Supporting for Oracle Financials R12/11iGL, AP, AR, CM,andFAmodules.
• Extensively worked with Oracle Utilities like Imports / Exports, SQL * Loader.
• Expert in designing the Data model in Conceptual, Logical and transforming them to Physical Data model, and developing the ERD schema diagrams in Erwin.
• Worked with very large databases in terms of Terabytes
• Extensively used UNIX shell Scripts for automating batch programs
• Strong skills in writing technical and functional documents defined by the business requirements
• Experience in Business Analysis/design, developing, managing and Implementing Banking applications & Database.
• Excellent Interpersonal and communication skills, efficient time management and organization skills, ability to handle multiple tasks and work well in a team environment
• Excellent logical and analytical skills to solve complex problems

TECHNICAL SKILLS

ERP: Oracle Financials R12/11i/11.5 (GL, AP, AR, CM, OM and FA)

Languages: PL/SQL, SQL, Shell Programming

Development tools: Oracle Developer (Forms 6i/9i, Reports 6i/9i/10g)

RDBMS: Oracle 8i/9i/10g/11g, DB2, MS Access

Database tools: SQL*PLUS, SQL*Loader, TOAD, SQL Navigator

Hardware: Sun SPARC, IBM PC/AT/XT, Intel Pentium PC, DELL PC, Compaq PC

Operating Systems: Windows 7/Vista/XP/2000/98/95, Windows NT, HP Unix, MS-DOS, PUTTY

Reporting tools: Oracle BI Publisher, Oracle Reports, Business Objects, Crystal Reports

Defect Management Tool: Test Director 8.0

PROFESSIONAL EXPERIENCE

Confidential, WI

Oracle Developer

Environment: Oracle 11g, PL/SQL, SQL, Unix shell scripting, Toad 9.1, SQL*PLUS 10.1, Putty, E-Business Suite Oracle Applications R12/ 11.5.8

Responsibilities:

• Involved in the continuous enhancements and fixing of production problems. Designed, implemented and tuned interfaces and batch jobs using PL/SQL. Involved in data replication and high availability design scenarios with Oracle Streams. Developed UNIX Shell scripts to automate repetitive database processes.
• Monitoring committed to keeping accurate records, ensuring on-time deposits, and maintaining tax compliance. Possesses a numerical accuracy and calculating balances.
• Application Enhancement and Support forAP, ARandGLmodules.
• Created and modified several UNIX shell scripts according to the changing needs of the project and client requirements.
• 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.
• Involved in the continuous enhancements and fixing of production problems.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Converted open purchase orders from legacy system to Oracle Purchasing using SQL* Loader, PL/SQL, Packages/Procedures.
• Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• Executed thePayablesTransfer toGLprogram and resolved the issues during the process.
• Created Alerts to notify users on various business events. Resolving the issues during the implementation life cycle.
• Documenting the mapping and requirements for the interfaces and conversions between the source and Oracle Applications.
• Analyzing the high priority critical issues on Production System and resolving them.
• Supporting solving Day-to-Day End - User problems. Also performing Week/Month end Reconciliation Activities.
• Analysis of the Problem/Issue Reported on Remedy Toll, JIRA and Suggesting Solutions.
• Performed Unit testing, UAT and End-User training for Go-live.
• Conducting meetings with Team members to discuss about project scope and project planning.
• Involved in various activities like preparation of Technical Documentation, Client Discussions for purposed solution and User Acceptance Testing.

Confidential, Miami, FL

Senior Oracle Developer

Environment: Oracle 11g, PL/SQL, Oracle reports 10g, HP Unix, Unix shell scripting, Toad 8.6 & 9.1, SQL*PLUS 10.1, Putty, Oracle Applications R12/ 11.5.8

Responsibilities:

• Developed programs to sanction entities in customer maintenance system based on the data provided by US Treasury Department. This helped in avoiding costly penalties imposed by government for doing business with sanctioned entities.
• Created custom programs and reports (using Reports 10g) to track Alliance card (WFS owned credit card issued to customers) usage and revenue statistics.
• Maintained good rapport with Business Analyst & Business Users to identify information needs as per business requirements
• Customization designs and work around for various business requirements in R12.
• Created new Schemas, Tables, Synonyms, Views, Indexes, Partitions and Sequences needed as per new requirements.
• Extensively developed complex PL/SQL packages for Invoice Processing.
• Designed/developed tables, views, various SQL queries, stored procedures, functions.
• Involved in PL/SQL code review and modification for the development of new requirements.
• Extensively worked with Dynamic SQL, Composite data types & Global Temporary Tables
• Used Pl/Sql tables, array structures as a part of oracle collections.
• Involved in partitioning of very large tables. Used list and range partitioning.
• Associated with DBA in monitoring the performance related issues using Explain plan, SQL Trace and TKPROF utility.
• Handled errors usingException Handlingextensively for the ease of debugging and displaying the error messages in the application.
• Developed scenarios for Unit, Integration testing to ensure that all the components work correctly when integrated.
• Involved in Production Support and troubleshooting data quality and integrity issues.

Confidential, Dallas, TX

Senior Database Developer/ Analyst

Environment: Oracle 10g, PL/SQL, SQL*LOADER, Oracle BI Publisher, Oracle Reports 10g, Oracle forms 6i, SQL Navigator, SQL*PLUS 10.1, Toad 8.6 &9.1. Oracle Financials 11.0.3, Putty, Erwin 4.1.4, APEX, Autosys.

Responsibilities:

• Developed a framework for extensible automated production support in PL/SQL
• Developed customer creation and modification packages to maintain customer data.
• Developed order processing packages.
• Developed shell scripts to alert users in the event of job failures and also automated jobs.
• Developed scripts to populate test data for Quality Assurance team.
• Developed tables, views, synonyms, sequences, constraints, stored procedures, packages, triggers, functions, and reports using PL/SQL.
• Implemented audit triggers on tables to control user account access to the database.
• Used PL/SQL and SQL*Loader to create ETL packages for flat file loading and error capturing in log tables.
• Involved in performance tuning of SQL queries by using explain plan and oracle hints (occasionally).
• Developed Forms for Payment Approval, Cancellation and Manual Entry using Forms 6i.
• Used Procedures, Functions, Triggers in Forms.
• Efficiently De-normalized the data in building the DataMart’s in Star schema.
• Developed sales journal report and financial reconciliation reports using oracle BI publisher/Reports 10g.
• Developed end to end Integration module for Auto Debit Installments with Core Banking MIBS & SYMBOL
• Actively involved in gathering business requirements, process and design enhancements, application development, testing and documentation of tasks as per company standards.

Confidential, Bronx, NY

Oracle Developer/ Analyst

Environment: Oracle 9i, Oracle 10g, Oracle SQL, Oracle PLSQL, Oracle BI Publisher (reporting tool), Oracle reports 10g, Oracle forms 6i, SQL Navigator, VB, HTML, Windows/Unix, Toad 10.1, SQL*PLUS 10.1, Putty

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC).
• Extensively worked on External tables to load data from external systems and developed PL/SQL programs to dump data from temporary tables into base tables.
• Designed/developed tables, views, various SQL queries, stored procedures, function, complex PL/SQL packages for ETL.
• Associated with DBA’s in monitoring the performance related issues using Explain Plan, SQL Trace and TKPROF utility.
• Used AutoSys for batch scheduling.
• Created complex SQL statements using joins, sub queries, inline views and Oracle Analytical Functions.
• Involved in data analysis and reducing data discrepancy of the source and target schemas.
• Developed Forms using Oracle Forms 6i for order processing and inquiry this involved analysis, design, development and migration to UNIX box and deployment on web.
• Executing XML files in Putty using UNIX commands
• Tracking logs in Putty using UNIX
• Expertise in PLSQL attached libraries, Functions, Triggers in Forms.
• Responsible for writing database triggers to validate business logic using PLSQL.
• Coded reports and programs to support billing functions in SQL, Oracle Reports and PLSQL.
• Developed many inventory control reports like stock status report, customer comparison reports, etc.
• Developed various reports for client applications using Oracle reports 10g, Oracle BI Publisher.
• Conducted code walkthrough & internal/peer reviews.
• Provided assistance in developing test scenarios, test scripts and test data to support unit and system integration testing.

Confidential, Fond Du Lac, WI

Oracle Developer

Environment: Oracle 9i, PL/SQL, HP UNIX, UNIX shell scripting, DBArtisan, PVCS Tracker, UC4, SQL*Plus10.1, Toad10.1, Erwin 4.1.4

Responsibilities:

• Participated in all the Life Cycle phases including requirement analysis, Client Interaction Design, Coding, Testing, Support and Documentation
• Created Functional Specification document and High-level design document
• Worked under the supervision of a DBA and created database objects such as tables, views, sequences, synonyms, and table/column constraints, indexes for enhancement
• Written complex SQLs using joins, subqueries and correlated subqueries
• Developed complex PL/SQL packages for EBS.
• Scheduling the Data stage batch jobs using UC4.
• Developed Oracle Stored Procedures, Functions and Packages to effectively in corporate Business rules
• Worked extensively with Composite data types, Cursors and Dynamic SQL
• Written Row Level Triggers to replicate Legacy Systems data to Oracle Database
• Worked with Dynamic SQL, Global Temporary Tables
• Used PL/SQL Tables, Ref Cursors to process huge volumes of data and used bulk collect and bulk bind for mass update as performance improvement process
• Import/Export utility is used for transforming data from one place to another from testing to Production.
• Involved in SQL Tuning by creation of indexes, rebuilding Indexes using Explain Plan, SQL Trace and TKPROF Tools
• Prepared the procedures to update the internal structures to reflect the newly loaded data. Created the materialized views
• Partitioned very large database tables using list partitioning to improve performance.
• Written UNIX scripts and run/review production jobs in the UNIX environment
• Communicate issues and progress to project manager
• Effectively resolved QA Trackers.

Confidential

Software Developer

Environment: Oracle 9i, PL/SQL, Informatica 6.2/7.1/8.6, SQL *PLUS, UNIX, Shell Scripts, SQL*LoaderReports 6i, UC4, MS Office, Excel, TOAD, Workflow 2.6, AIM Methodology, PVCS, SQL Server 2005.

Responsibilities:

• Involved in requirement gathering and analysis.
• Involved in writing procedural scripts using PL/SQL
• Installation of databases and integration of different banking applications with them.
• Designed the database and schema objects.
• Generated various types of reports and forms by using reports/forms builder 6i
• Involved in implementation and documentation of the system
• Generated specific reports using crystal reports
• Involved in the logical and physical database design and developed the logical dimensional models using ERWIN 4.0
• Developed entity and attribute descriptions and definitions for the models.
• Lead part in Design and Code walk through
• Development of the DW - Extraction of data from disparate sources and uploading the data after cleansing into the DW.
• Wrote SQL Loader & Pro *C scripts for Import/Export data files.
• Developed Informatica Mappings to load data into Lease Data Mart.
• Developed reusable transformations and Mapplets.
• Extensively used mapping parameters, mapping variables and parameter files
• Extensively developed complex PL/SQL packages for ETL.
• Troubleshooted the existing PL/SQL procedures, functions, triggers
• Analyzed tables and indexes for performance tuning.
• Knowledge in UC4 job scheduling software, set up and maintenance.
• Seasoned in optimizing Query performance using explain plan, SQL Trace and TKPROF utility
• Developed scripts for checking Oracle errors in alert logs and trace files for every 15minutes
• Performed unit testing, system integration
• Involved in Production Support and Operations teams to resolve production issues in a timely and efficient manner.
• Member of Performance Management Team that identified developmental areas, which can help in increasing productivity.