SUMMARY:

• Around 12 years of experience in Application Development using Oracle SQL, PL/SQL, and Developer Forms and Reports.
• Experienced in interacting with Business Users, Business Analyst, IT Leads, Developers and System Analysts to gather and analyze business requirements and translating requirements to functional and technical design specifications.
• Involve d i n c o m pl ete S DLC in c l udi ng arc hitec tur e, ana lysis, design, documen tatio n, de velop ment, implementation, testing, deployment, trainin g an d main tena nc e of inter net /intrane t base d applications, i n a pr oc es s ba se d en viron ment .
• Rich experience in writing SQL queries, Views, Materialized views, PL/SQL procedures, functions, packages, triggers, cursors, collections, Ref cursor, cursor variables, System reference cursor, Dynamic SQL.
• Ove r 7 y ea r o f experienc e i n te am - m ana gemen t, pro jec t management, projec t coordination, produc t d evelopmen t/de pl oy men t.
• Ove r 4 year s o f Financia ls Indus tr y Ex perie nc e.
• Experience in using several built-in database packages such as DBMS JOB, DBMS OUTPUT, UTL FILE, and DBMS SQL .
• Trainin g i n Oracl e E RP Imple menta tion s, U pgr ad es an d suppor t m ai nly i n Genera l Led ger, A ccoun t P ayab les, A ccoun t R ec ei vabl es, Fixe d Assets, Cas h M an ageme nt, P ur chasi ng (PO), In v e ntor y (I NV) .
• Experience in using DBMS SCHEDULER to run jobs in parallel to improve time-constrained performance.
• Strong knowledge of Extraction Transformation and Loading (ETL) processes SQL, PL/SQL and SQL Loader.
• Expertise in loading data from legacy systems using SQL*Loader.
• Extensively worked with third party database tools like TOAD & PL/SQL Developer.
• Strong interpersonal skills, ability to interact with people at all levels. Good communication and presentation skills.

TECHNICAL SKILLS:

Databases: Oracle 8i/9i/10g/11g, SQL Server, MS Access, A pplic ati on s erve r 10 gGUI: Oracle Forms 6i/9i/10g and Reports 6i/9i/10g

Languages: PLSQL, HTML,ORACLE

Tools: SQL Developer, SQL Navigator, TOAD, SQL plusApplications: MS Office and MS Visio.

Operating Systems: Windows 7, Windows Vista, XP

PROFESSIONAL EXPERIENCE:

Confidential

Software Engineer

Responsibilities:

• Built complex queries using SQL and wrote stored procedures using PL/SQL .
• Expertise in Client-Server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.
• Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
• Worked with Bulk Collections for bulk load processing.
• Involved in the migration project to load data from mainframe systems into oracle database.
• Involved in Troubleshooting performance issues and bugs within packages and stored procedures using DBMS OUTPUT and Explain Plan.
• Involved in developing data conversion programs using SQL *Loader, PL/SQL and UNIX shell scripts .
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Partitioned large Tables using range partition technique .
• Involved in code walk through and review sessions with the development team.
• Experience in using DBMS SCHEDULER to run jobs in parallel to improve time-constrained performance.
• Coordinated physical changes to computer Databases; and Codes, Tested and Implemented Oracle and SQL Database, applying knowledge of Database Management System.
• Specified which users can access databases and what data can be accessed by users.
• Selected and entered codes of utility program to monitor database performance, such as distribution of records and amount of available memory.
• Developed interface for item data conversion to load items from flat file to Oracle Inventory using SQL* Loader, PL/SQL and import items program.
• Atomized routine jobs using DBMS JOB. On completion of these jobs an email will be sent out automatically with the help of UTL MAIL.
• Worked on the Data Replication from Source systems to Target systems. Designed Data model and new Schemas to maintain daily transactional data.

Confidential

Software Engineer

Responsibilities:

• Interacted with Business Analysts and participated in user requirement sessions to analyze and gather business requirements.
• Involved in data modeling team for identifying tables and relations between them.
• Built complex queries using SQL and wrote stored procedures using PL/SQL.
• Involved in development of interface programs to import parts information to inventory base tables.
• Converted open purchase orders from legacy system to Oracle Purchasing using SQL* Loader, PL/SQL, Packages/Procedures
• Involved in development of shell scripts to send invoices to customer through mailing.
• Developed various reports ‘Customer Statement of Account’, ‘Core Debit memo’ and AR Invoice Report.
• Involved in updating procedures, functions, triggers, and packages for validation and loading of data into target table based on the current requirement.
• Designed and developed various custom packages triggers and forms.
• Involved in implementing Order to Cash (O2C) cycle and P2P cycle.
• Extensively used for all and bulk collect to fetch large volumes of data from table.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like TKPROF, AUTOTRACE and DBMS SQLTUNE.
• Performed performance tuning using the DBMS PROFILER package, this checks the run time behavior.
• Involved in data migration from Production to test and created test data for analyzing problems, providing solution.
• Involved in integration testing.
• Debugging and Fixing Production Data.
• Used PL/SQL and SQL*Loader to create ETL packages for flat file loading and error capturing into log tables.

Software Engineer

Responsibilities:

• Worked with the Business analysts and the DBA for requirements gathering, business analysis, testing, metrics and project coordination.
• Involved in logical modeling and physical modeling of application.
• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Involved in creation of Conceptual Modeling covering all the business requirements.
• Loaded the data into database tables using SQL*loader from text and excel files.
• Developed data model, SQL Queries, SQL Query tuning process and Schemas.
• Created SQL*plus reports as per client's various needs, and developed business objects.
• Developed SQL scripts for Referential Integrity check, which checks validity of incoming data with master tables in database.
• Developed SQL scripts, packages and procedures for Business rules check to implement business rules.
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
• Data loaded from legacy systems (ETL Operations) using PL/SQL and SQL*Loader.
• Developed custom Forms and Reports as per client requirements and making them web enabled using Oracle Reports builder 10g and Oracle Forms builder 10g respectively.
• Developed Master Detail, Detail reports using tabular and Group above reports.
• Developed Procedures for efficient error handling process by capturing errors into user managed tables.
• Developed Shell scripts to automate execution of SQL scripts to check incoming data with master tables, insert the valid data into Customer Management System and invalid data into error tables which will be sent back to sender notifying the errors.

Confidential

Software Engineer

Responsibilities:

• Involved in analysis, Design, Development phases of the project.
• Designed ER diagram using Visio, to set the logical and physical relationships of database.
• Involved in walkthrough sessions with business users during Analysis and Designing phase. Writing PL/SQL Stored Procedures, Functions, and Packages to meet the business requirements.
• Involved in implementing the data integrity validation checks through constraints and triggers.
• Writing SQL reports and scheduling these reports from UNIX scripts.
• Created SQL*Loader control files for moving the data from flat files to staging area tables.
• Worked on performance issues and used EXPLAIN PLAN for tuning the queries.
• Used the advanced features of PL/SQL like collections, nested table, array & Dynamic SQL.
• Developed data entry forms, complex and template forms in Forms 6i.Creation of Pop-up Menus and maintaining Master Detail relation-ship.
• Used Cursor Variables to pass query results sets between PL/SQL programs and client application.
• Used various LOVS (List of Values) and record groups at various points in runtime.
• Development of client side program units and sharing them among multiple applications for processing business logic in the database.

Oracle Developer and AnalystFreelancer Oracle Consultant

Responsibilities:

• Provided technical full support for the development, design, and systems integration for client engagement rom definition phase through implementation.
• Applies significant knowledge of industry trends and developments to improve service to clients.
• Review work of development team.
• Recognized system deficiencies and implemented effective solutions.
• Created and executed development plans and revised as appropriate to meet changing needs and requirements.
• Own the development life cycle and is responsible for managing technical risks throughout the project.
• Communicated and enforced coding standards
• Performed code reviews and mentors junior developers.
• Consistently delivered high-quality services to clients.