Summary


Senior PL/SQL Developer or Oracle Application Developer


Certified Senior Oracle Developer with 8 years experience Oracle in NT and UNIX environments. Energetic self-starter with excellent analytical and organizational skills. Strong leader and communication with ability to work as a team player or independent player and ability to interact with clients.
Over 6+ years of solid experience with PL/SQL, Data Warehouse or Data mart Design, Development, OLAP Analysis, Performance and tuning.
Very strong experience in writing SQL scripts, Database Procedures, Functions, Packages, Indexes and Database Triggers, SQL * Loader and Unix shell scripts
Very strong experience in using Crystal reports for implementing Reports and rich formatting, sourcing data from multiple databases/flat files to Oracle.
Worked in full SDLC software development life cycle for Oracle, databases involving Data modeling, Capacity Planning and Database Administration using OEM and Control Center.
Expert level Data Architect with extensive database system analysis, design, implementation and Project Management experience Specialist in Data Analysis, Data Modeling, Database Design and Data Migration.
Work with Enterprise Dab s and Data Modeler to accomplish Design of the Enterprise Data Warehouse Model and Business Intelligence BI Tools.
Handled complex data formats which included Vector type of record format coming as a source and Maps using Ab Initio Normalize and later on Denormalize component.
Strong analytical and conceptual skills in database design and development using Oracle, Access and SQL Server.?
Work with business teams and obtain relevant business logic to translate business requirement into code and improve the services in customer relationship management CRM.
Extensive experience in UNIX Solaris and Windows operating systems.
Availability off work hours to meet project deliverables or deadlines involved in troubleshooting Production Critical issues.
Experienced in database design, data analysis, development, SQL performance tuning, data warehousing ETL process and data conversions.
Experienced in working on Distributed Oracle database servers 7. x/8.0/8i/9i.
Experienced in developing stored packages, procedures, functions, triggers, views.
Experienced in SQL*Loader, Import, Export, UTL_FILE, Optimization using Analyze, Explain Plan, TKPROF, snapshots.
Strong programming and debugging skills in PL/SQL, SQL, Dynamic SQL, C, C++, Pro*C, UNIX shell scripting.
Developed and maintained the applications by utilizing ASP.NET.
Experienced in developing forms and reports using Oracle tools.
Excellent skills in developing both technical and functional specs
Experienced in production support and trouble shooting of database applications.
Good understanding of web based J2EE Technologies - Java, JDeveloper, Servlets, EJBs, XML, HTML and Oracle 9iAS.
Excellent communication, quantitative, analytical skills and ability to work either individually or as a member of a team
Provided User training and 24/7Production support.
Strong ability to understand the business requirements and technology perspective to enable alignment of Information Technology initiatives with business requirements.
TECHNICAL
Databases
Oracle 7. x/8. x/9i/10g/11g, SQL Server 7.0, 2000, 2005, Sybase and MS-Access.
Oracle Products
Oracle 7. x/8. x/9i/10g OID Oracle Internet Directory, Enterprise Manager, JDeveloper 1.5 - 2.0, SQL*Plus, SQL*Loader, Net8/Sql*Net, Server Manager and PL/SQL, Developer - 2000/Forms 6i or 9i Reports 6i/9i, Oracle Supply Change Management, Visual Basic 6.0, Oracle Designer 9i, Designer 2000
Reporting Tools BI Business Intelligence Tools
Business Objects Xi R2, Crystal Reports, SSRS
ETL Tools
Ab Initio EME Release 2.10/ 2.13/2.14 GDE Release 1.10/ 1.13/1.14, WarehouseBuilder2.1, Hummingbird Genio4 .x, Informatica4.6, Cognos, DTS Data transformation Server.
Languages
C, PL/SQL, SQL * Plus, Pro *C, Java, ASP. net, VB. Net, C/C++, SQL, UNIX shell script, PERL, SQL Loader control scripts, SQL *Loader
Data Modeling Tools
Erwin 3.5/3.5.2, Data Architect, DataStage, Designer 2000, ICL
Operating Systems
Sun Solaris 2.5/2.6/2.7 and 2.8, HP UX 10.3/11, IBM, AIX 5.1, Linux 7.0, Windows 95/98/2000/NT/XP, Sun Sparc Solaris 2.5, SunE3500, E250 E10000, HP-Unix 11.0.1, Digital Unix4.0.6 AIX4 .x, OS/2, OS/390 VMS 5.54.5
Third-party Tools : Remedy, Daybreak, USD - Tickets, Toad, Rational tools Clear case, Clear Quest, PVCS, VSS, SAS, Litespeed, Service Center


Employment

January, 2007 -  March, 2008

Analyzed all business functionality related to back end database interfaces
Developed technical specifications for various back end modules from business requirements. Specifications are done according to standard specification formats.
Worked with DBA in making enhancements to physical Database schema. Also coordinated with DBA in creating and managing table, indexes, tablespaces, triggers, Database links and privileges.
Analyzed and designed tables based on small and large database transactions.
Developed back end interfaces using PL/SQL stored packages, procedures, functions, Collections, Object Types, triggers, C, Pro*C, K-Shell scripts.
Developed Korn shell scripts to kick off back end PL/SQL, SQL, Pro*C programs.
Developed screens and reports using Oracle Forms/Reports 6i/9i. Also developed reports using Pro*C and PL/SQL
Utilized SQL*Loader to load flat files database tables.
Responsible for SQL tuning and optimization using Analyze, Explain Plan, TKPROF utility and optimizer hints.
Utilized PL/SQL developer tool in developing all back end database interfaces.
Developed automated Korn shell scripts to schedule the load of flat files on daily, weekly and monthly basis.
Responsible for performing code reviews.
Developed user documentation for all the application modules. Also responsible for writing test plan documents and unit testing for the application modules.

Environment : Oracle 8i/9i, HP UNIX, Windows NT 4.0, PL/SQL, SQL*PLUS, SQL, C, PRO*C, k-shell, SQL*Loader, Explain Plan and TKPROF tuning utility, Forms 6i/9i, Reports 6i/9i, PL/SQL Developer Tool, TOAD, Forms6i, Reports 6i

December, 2005 -  November, 2006
Crystal Reports Developer

Interacted with Users and gathered requirements for the Reports. Mostly involved in making Changes to the existing Reports and updating the reports as per the Requirements.
Created Users, assigned Rights and Authorizations for report users. Involved in the administration of Management Console for implementation of security at Report level, Folder level.

Involved in Trouble Shooting all the issues in Crystal Enterprise. Maintained Proper Documentation for all the work for Future Reference
Created and Updated Views or Stored Procedures as per the user requirements. Used these Procedures and Views in numerous reports for better performance.
Developed, formatted, complex reusable formula reports and reports with advanced features like conditional formatting, built-in/custom functions usage, multiple grouping reports.
Exported Reports to different formats like Word, Excel, PDF, HTML etc.

Environment : Crystal Reports 8.5, Crystal Enterprise 8.5, Oracle 8i/9i, SQL 2000 and Windows 2000

February, 2005 -  November, 2005
Senior Oracle PL/SQL Programmer

Data Extracted from DB2 and Generated flat files Using shell scripts.
Created External tables and loaded the data into oracle TMS tables.
Developed PL/SQL packages and Generated Complex Oracle Forms.

Provided User training and Production support. Develop modules using UNIX
Wrote PL/SQL packages to calculate Missing Information and Determining Eligibility in the processing of a Medical/Health Families Application.
Developed the Termination Package and interface to load the data into Business Transaction reporting and Monitoring systems tables by using the advanced PL/SQL features viz., Dynamic SQL, Dynamic Cursors.
Optimizing the SQL s for optimum performance by using SQL Trace, TKPROF, EXPLAIN PLAN and TOAD
Fixed various complex issues in packages, forms, reports and Performance issues.
Symantec Springfield, OR
Designing Program specifications and Data Flow Charts for program development
Interacting with Database Architect and Business Analyst regarding design and business requirements
Developing PL/SQL interface programs for transferring Customer data from ELS to BLOC system
Developing compatible Programs or codes for integrating the Bright Mail order processing functions into Symantec source system from BrightMail BLOC system.
Developing Complex PL/SQL Procedures and Packages for data validation per business requirement.
Developing control files for SQL *Loader and loaded data into database tables from flat files.
Developing Inbound interfaces using PL/SQL programs for data conversion packages for data validation and convert legacy data for Oracle Applications.
Developing shell scripts to automate process, generate reports and logs.
Developing outbound interfaces using PL/SQL procedures for data reconciliation between ERP.

Environment : Oracle, SQL, Ab Initio, PL/SQL, Windows NT 4.0, UNIX, SQL* Loader, ETL, Business Objects HP-UX, UNIX Solaris, Perl script, Windows-2000

October, 2004 -  January, 2005
Oracle PL/SQL developer

Supported IS Development team from an infrastructural architecture perspective in designing, developing, testing and implementing Executive Information System EIS. EIS repository provides the meta-data source for the Business Objects development life-cycle. Thus, helping the high-level executive management, marketing, underwriting and customer service departments in generating/viewing various adhoc, trend analysis and forecasting reports.

Responsibilities : Developed detailed data architecture, process flow and data model diagrams by conforming to database management policies and standards.
Set up the ETL environment implementing parallelism, administer the environment and developed the wrapper to run the application through the scheduling tool.
Responsible for ground up physical and logical design of select Oracle Staging Data Warehouse.
Developed filter, aggregate the data before loading them into Oracle database.
Tested and implemented Abinitio graphs for all fact tables.
Involved in relational design, table design and indexing strategy.
Developed new or modified SAS programs to load data from the source and create study specific datasets which are used as source datasets for report generating programs.
Developed a Data Manager tools that read all the day to day transactions related data from different Account type files and apply the changes to the centralized database.
Involved in defining programming standards, database design, program development and testing and implementing the system
Worked with business unit VP s for development, acceptance and implementation of strategic and technical business unit for plastics and pins applications
Developed standard process to extract the data from mainframe to the client server environment
Developed High level and Detail Designs for the application
Developed multiple graphs to load the application.
Coordinated the Development and Implementation of Strategic Plans
Build some complex queries using SQL and wrote stored procedures using PL/SQL
Involved in reporting team for developing ongoing or schedule reports based on 1 time or based on some application to schedule reports based quarterly, monthly or weekly.
Involved in the design, development and testing of the PL/SQL stored procedures, packages and triggers for the ETL processes.
Developed PL/SQL Procedures for concurrent programs which will run during the off peak period
Designed and developed custom forms using Oracle forms and Oracle Tools, SQL * Loader, PL/SQL UNIX shell scripts and integrated with oracle Applications
Involved in data conversion of Legacy Data using SQL * Loader by validating, using subprograms and Packages, the data was loaded into temporary tables
Developed scripts for checking Oracle errors in alert logs and trace files for every 15minutes

Provided User training and Production support.
Generated Monthly quarterly weekly reports, interacting with business users, understanding the business process and Made timely changes and fixes to reported problems from the user community.

Environment : Oracle 9i, SQL, Ab Initio, SAS, PL/SQL, Tivoli, Windows NT 4.0, UNIX, SQL* Loader, ETL, Control-M, HP-UX, Perl Script, UNIX IBM AIX OS/2, OS/390 Windows-2000

January, 2004 -  September, 2004
Oracle Database Developer

Written PL/SQL Stored Procedures, Functions and Packages and Triggers to implement business rules into the application.
Developed various Complex Forms and reports using Developer 6i
Made timely changes and fixes to all the modules on reported problems from the user community.
Involved in data conversion of Legacy Data using SQL * Loader by validating, using subprograms and Packages, the data was loaded into temporary tables, API S were used to load data from temporary tables.
Written and Tested C, Pro*C applications for loading inventory data into database tables.

Designed and developed Oracle Forms 6i for user access, Oracle reports 6i to highlight the high inventory items and deployed in the web as HTML/JSP pages.
Participated in the design, development and implementation of comprehensive inventory tracking custom application for the automotive client.
Responsible for data validations, feeding of live data and user acceptance for each module.
Written SQL scripts for implementation at the client's place and mentored the end users.
Prepared checklist, final design documents and general instruction to follow during development.
Designed and Developed various user interfaces screens and reports using Developer 6i.
Developed shell scripts to have logical backup of important tables with suitable buffer size using export, import utility.

Environment : Oracle 9i, PL/SQL, SQL, SQL*Plus, Daybreak, SQL * Loader, Export or Import, Proc * C, Unix shell script, Perl Script, Sun Solaris or Windows

October, 2001 -  November, 2003
Architect

Education

Training

Oracle 9i PL/SQL Developer Certified Associate
Certified Oracle PL/SQL Developer from Brainbech



Miscellaneous

GMAC
located at Fort Washington, PA, I worked for the department responsible for developing the applications and maintenance of Database servers, Oracle 9i, 10g and 11g also Microsoft SQL Server 2000 and 2005. My responsibilities, designing and modeling the database, writing store procedures, designing packages, Design entity relationship diagrams and dimensional data models, ETL works, transfer data from OLAP Database to OLAP Database. Also responsible to monitor and tune large databases for performance and availability, modify database structures, develop database backup/recovery procedures, provide support and guidance to operational models and forecast database and platform resource utilization, consistence check, security administration, data quality, documentation and technical support.
Responsibilities : Responsible for analyzing business functionality for the back end processes.
Responsible for developing technical specifications from business requirements.
Responsible for making enhancements to the physical data model.
Developed back end interfaces using PL/SQL packages, stored procedures Collections, Object Types and triggers and Pro*C.
Performed tuning and optimization on SQL queries using Analyze, Explain Plan, TKPROF utility and optimizer hints.
Developed screens and reports using Oracle Forms/Reports 6i.
Extensive experience in UNIX Solaris and Windows operating systems
Utilized SQL*Loader to load data from flat files into database.
Developed automated Unix-shell scripts to schedule the load of flat files on daily, weekly and monthly basis.
Responsible for performing code reviews.
Developed test plan documents for all back end database modules.
Also responsible for unit testing and documentation of the interfaces. Also utilized version control software PVCS and make utility.
Responsible for trouble shooting end production problems.
Worked with development team responsible for expansion of database management System using Oracle 9i to maintain the track of calls made outside the RGV network.
Developed functions, procedures and packages to implement the system's business logic using PL/SQL.
Involved in the design phase of the development. Responsible for the physical and logical design of physical configuration on the storage media.
Developed and maintained the applications by utilizing ASP.NET.
Analyzed data access controls and provided suggestions in enhancing the security.
Created and managed the database triggers and subprograms.
Provide training to the managers in using the system, using reports, executing complex queries and writing.
Evaluated, examined and implemented user roles and assigned relative database access privileges.
Environment : Oracle 9i/10g SQL Server 2005, Business Objects Xi R2, PL/SQL, C, Pro*C, SQL*PLUS, Forms 6i, Reports6i, SQL*Loader, Explain Plan, TKPROF utility, UNIX-Shell Scripting, Perl, Windows NT, Oracle 8/8I, HP-UNIX, PVCS, CRM, ASP. NET, Oracle objects for OLE.
AP State Electricity Board is the Power utility catering to the electricity needs of the state, It is a large Organization with vast manpower and machinery. To assist the corporate activities of the Organizations several applications were developed via the accounting package dealing with the ledgers, Trails Balances etc.,, technical information systems dealing wit h the Energy Management systems involving Energy transmission Energy distribution, Material Inventory management, Breakdown Management, Disaster Management etc., and Payroll package.
Responsibilities : Developed numerous programs using Complex PL/SQL and many packages to do the validations as per requirements.
Written a PL/SQL interface program that imported customers from a legacy system interface tables. SQL * Loader or UTL_FILE was used to populate into temporary tables, from where PL/SQL program validated and loaded the data into open interface.
User-friendly forms were developed using forms Daily weekly and Monthly details of the company were generated using Reports.
Designed and Developed various user interfaces screens and reports using Developer 6i.
Associated in developing Billing Module using Pro * C, by utilizing array processing power of Pro * C to run batch processing programs to validate, process update and insert into various intermitted tables of billing processing Module.
Prepared design document, Checklist and test scripts for the applications.
Provided user training in writing code that supports Functionality.
Developed Control scripts and loaded existing data using SQL * Loader and Shell scripts
Developed Forms or Reports using Forms 5.0/4.5 and Reports 3.0/2.5 and solved Numerous Problems Reports.
Evolved good backup strategy using hot backup and Export/Import techniques.
Developed stored procedure using PL/SQL to update payment info into Bills. Developed Database Triggers to enforce security.
Developed Shell Scripts to start tests, generate reports, day to day administration jobs, backups for production database and also pages to administrators if any abnormal conditions
Environment : Oracle 7.3.4/8.0.5 Developer 2000, SQL * Plus, SQL * Loader, Export, Import, Pro * C, Unix Shell Script, Sun Solaris 2.3/2.6, Unix/Sybase, Windows 95/98.
Resume of Radhika page 1 of 8