SUMMARY

Oracle PL/SQL Developer with almost 9 years of extensive experience in analysis, designing, developing, data modeling, implementing and maintaining database applications and solutions, primarily using Oracle Database technologies.

• Experience in Data Modeling 1NF, 2NF, 3NF , dimensional modeling, complex data modeling and deal with their challenges.
• Good knowledge of Data Modeling and creation of Entity Relationships Diagrams.
• Knowledge of Data warehouse and ETL. Knowledgeable in concepts like Dimensional Modeling including Star and Snow Flake Schemas.
• Expertise in requirements gathering, software requirements specifications, systems development, testing unit, performance , reporting, application maintenance, application and production support.
• Analytical thinker, quick learner and proficient problem-solver who envisions business and technical perspectives to develop workable solutions.
• Experience in writing efficient SQL and PL/SQL code stored procedure, functions, triggers, autonomous transactions, procedures and packages on TOAD and Developer to analyze very large data sets.
• Experience in data integration, import export from raw data file to database and database to flat/dat/txt/csv format files by using Tools and own written procedures.
• Hands-on experience using Oracle tools like SQL Plus, SQL Developer, SQL Navigator, PL/SQL Developer and TOAD in many development projects.
• Complete understanding of Oracle architecture including SGA Database Buffers, Redo Log Buffers, Shared Pool Log writer, achiever, PGA, listener services, data dictionary views.
• Expertise in system integrations and client interactions in preparing functional designs.
• Expertise with concepts of referential integrity and constraints.
• Excellent Analytical skills to understand the business process and Functionality, Requirements and to translate them to system requirement specifications.
• Experience in Performance Tuning both SQL Tuning and PL/SQL Tuning using TKPROF, SQL TRACE, TIMED STATISTICS Explain Plans, DBMS PROFILER.
• Well versed with Unix Shell Scripting.
• Excellent documentation and presentation skills, great verbal and written communication skills.

TECHNICAL SKILLS:

• Databases: Oracle 11g/10g/9i/8i
• Languages: SQL, PL/SQL, HTML, UNIX Shell Scripts
• Utilities: SQL Loader, Import/export, Oracle Developer Suite, SQL Plus, TOAD
• Reporting Tools: Oracle Forms/Oracle Reports 6i/10g, Business Object Crystal Reports .
• Operating Systems: UNIX, Linux, Windows 2000/XP/NT
• Productivity Applications: MS Officer, Edit Plus, Visio, Visual Studio, .NET
• Data Modeling Tool: Erwin Data Modeler, Oracle Data Modeler
• Environment: Staging, Developing, Testing, Production

PROFESSIONAL EXPERIENCE:

Confidential

Working as freelance Oracle Application developer and .NET Application developer for several projects, like Database Designing, Data Modeling, Data Integration, Data Conversion, Reports development, Web Development. Also working as Oracle Application Developer Trainer with contractor, giving lectures to trainees.

Oracle PL/SQL Application

Confidential

• Worked with Manufacturer Company who is manufacturing class rings, medals, pins and other emblematic jewelry as an Oracle Application/Forms/Reports Developer.
• Involved in designing of data modeling, design specifications and to analyze dependencies.
• Involved in unit level testing, module level testing and system testing.
• Involved in preparing functional specifications, release notes and documentation using MS-Office.
• Creating complete end-to-end software solutions by developing, testing, rolling out and supporting system, reports and services.
• Design/development of customer integration system, program specs based on functional specifications.
• Wrote/modified existing Procedures, functions, triggers, packages for daily interfacing staging, development, testing, and production environment.
• Designed and modified existing forms and reports as per business requirements.

Oracle PL/SQL Application Developer

• Worked with Health Insurance Company as an Oracle Application Developer for Medicare, Medicaid, and HMO Coverage.
• Involved in Designing of Data Modeling. Design Specifications and to analyze Dependencies, unit level testing, Module level testing and System testing, preparing functional specifications, release notes, and documentation.
• Analyzed the systems, met with end users and business unites, creating complete end-to-end software solutions by developing, testing, rolling out and supporting systems.
• Worked on design/ development of Medicaid system which notice of new members, broker changes, subscribers plan changes.
• Developing program specs based on Functional specifications
• Developed and modified a number of SQL, PL/SQL, packages, stored procedures, functions, views, forms, reports for processing business logic in the database.
• Responsible for following up bugs reported by various users and suggesting possible patches to be applied.

Senior Oracle PL/SQL Developer Lead

• Interacted with business users to understand their business requirements, and design and implement the requirements.
• Design and developed data model as per requirement
• Developed and modified existing PL/SQL Packages, procedures, functions, triggers, views, forms, reports.
• Created numerous Adhoc and canned reports that measured campaign conversions.
• Created, extracted and Ftp'd the data files to a third party vendor for direct mailings.
• Worked with production support team, jobs run daily, weekly, monthly and on demand basis .
• Created various simple, complex reports mainly using business objects universes as data providers.
• Created database tables, indexes and partitioned existing tables, FTP process to extract data from Flat files received from various systems.
• Wrote korn shell scripts to collect information from text files, merge data and store in different file. Wrote shell scripts for users like menu driven screen. Wrote shell scripts to collect users information and files information to create a log file and to extract data from text files.

Oracle PL/SQL / SQL Developer

• Worked as an item analyst, the responsibilities involved writing programs for item conversions.
• Worked in SQL Loader for loading data from various sources like flat file, excel etc. into tables.
• Enhanced the performance of legacy PL/SQL packages by using Oracle 10g new features like
• Worked on writing programs for Data Conversions.
• Worked on Bulk loader utilities like SQL loader for moving data from external files to Oracle.
• Created database tables, indexes and partitioned existing tables.
• Performed unit, system and Integration testing.
• Worked on checking log files on UNIX while working on support for production environment.
• Ensured timely completion of development projects within estimated costs and standards.
• Assisted in the implementation of programs to educate management and users in information processing and system capabilities, uses and requirements.
• Tasked to review and evaluate proposed system design resolutions such as table structure, table relationships and determine feasibility and practicability in real time environment.
• Extensively used of PL/SQL Stored Procedures, Functions, Triggers , Cursors and Packages
• Creating SQL, PL/SQL database objects.
• Involved in Testing Both Unit and Integration Level and Implementation.
• Tested the entire application in testing environment and exported to Production.
• Done the documentation and provided on-site production support.