SUMMARY

• Over 8 years experience in Information Systems as an Oracle developer, Systems Analyst/Programmer.
• Over 6 years experience in software development for custom applications, preparing use cases, writing business logic. Strong knowledge of system development life cycle, data models, data flow diagrams, methodologies, E-R relationship and Normalization.
• Worked on all stages of SDLC (Software Development Life Cycle) including requirement analysis, design, development, testing and implementation
• Over 6+ years in Oracle environment, with extensive experience in designing relational databases and creating/maintaining databases, control/parameter file, redo log, data integrity, indexing, partitioning, Table Backup/Recovery, Performance Tuning, data conversion, Data warehouse.
• Experience in SQL*Loader, EXPORT/IMPORT, SQL*NET. And TOAD; Tuning: EXPLAIN PLAN, SQL TRACE, STATSPACK, SGA, Database, init.ora parameters, optimization.
• Experience in Pro*c, PL/SQL (Stored Procedures, Functions, Packages & Database Triggers).
• Experience in developing front-end application using (Forms/Reports 6i) and Discoverer 4i.
• Proficient in SQL*Plus scripting, in UNIX shell and SQL programming , in SQL*Loader scripting, in Data Modelling and use of CASE Tools such as ERWIN.
• 2+ experience in programming using C/C++, Oracle, visual basic, ODBC.
• 2+ experience in designing GUI applications and web base based applications as a customers' requirements using tools like UML-Rational Rose.
• Experience in programming using Java, JSP, JDBC, experience in web programming using ASP.NET,XML, and HTML.

Expert IT Skills

• Oracle7, Oracle8, Oracle8i, Oracle9i and Oracle10g database administration and management.
• SQL*Plus, SQL and PL/SQL programming and development, Plsql developer tool, TOAD Tool, SQL navigator, crystal report.
• Dataflow chart, Star schema, Snowflake schema, Data marts
• UNIX Systems (HP/UX, Solaris, AIX, Linux) administration, Windows xp,2000 server.
• RDBMS, JSP, REXX, TSO, ISPF
• Micro strategy, Business Objects, Erwin, ETL, Oracle enterprise manger, Plsql developer tool, SQL Navigator, TOAD, Visio.
• Oracle*Net, SQL*Net, TCP/IP, Oracle Forms and Reports 6i.
• C,C++,, Shell scripting, Visual Basic, Perl scripting, Oracle XDB, XML, HTML
• HP-9000, IBM 30xx, IBM 43xx, IBM-PC, IBM RS6000, all HP/UX and Solaris architectures.

Professional summary

Confidential, San Francisco ,CA Oct 2007 - till date
Oracle developer
Confidential, has a software development team does tracking of different store.Developed Price Management Application,regarding different branchstores pricing level in chain stores.Different pricing strategy and management,Vendor authorization for pricing of clothes. Different types of retail sales. Pricing Management is a collaborative logistics solution that enables end-to-end, real-time logistics monitoring

• Design and develop PL/SQL procedures/functions/triggers which carry out data flow to respective schemas meant for different client data models.
• Logical and Physical Data modeling and desigining, writing server side stored procedures/ triggers.
• Develop PL/SQL procedures to perform business validation checks on the data for master-detail, default value integrity constraints.Developed code using collections ,cursors,file search.
• Analyze the Existing code and make new Enhancement as per different customer's request.Developed complicated SQL queries and database performance tuning. Bulk DML operation, Dynamic cursor, Ref Cursor, Partitioning, Sql tuning using explain plan,Tkprof,autotrace.
• Developed and maintained purging data for different level of pricing aspects by PLSQL developer and passed through the shell scripts in application level for user interface.
• Created several unix shell scripts calling various PL/SQL packages and procedures to perform the business rules in the Microstrategy and business objects reports
• Create and manage work orders forms/reports .Allow customers to directly enter work requests online by web based application .Assign subcontractors to work orders and track status of work orders online
• On the job field benefits such as scan in customer signatures, work request reports, online document storage and more.Fully customizable applications available in addition for a complete business solution. The data in XML format transferred by JDBC connection to oracle.
• Developed Fiscal Annual report(weekly, monthly, quarterly, yearly) in Microstrategy and Business objects with backend function in pl/sql called by scheduled unix shell scripts.
• Implementation and Tesing involved in data integration,unit testing and integration testing .

Environment: Oracle 9i, Oracle 10g, Microstrategy and business objects, ,Oracle Forms 6i/ Reports 6i, SQL, PL/SQL in unix and windows ,Shell script, Perl scripting, Enterprise Manager, XML,JDBC, T.O.A.D.

Confidential, Milwaukee,Waupun. May 2005- April 2007
Senior Oracle developer

This project deals with Manufacturing company of cheese production from milk in different types(cheddar cheese, mozarella, shredded cheese).(OMS)Dealing with milk bulk fluid,(PO)handle the billing process,(ERPJournal entry and general ledger, inventory, shipment, receipts,pricing,advances,settlements.

• Analysis, designing, coding.Studied the entire existing system and developed the system architecture design, documentation and dataflow diagram(Visio tool)of the system.Manage the Data warehouse architecture, providing a liaison between the ETL and BI architects.Prepared ER diagram through ERWIN tool.Implemented datamodels and database designs,data access and table maintenance codes.
• Developed several procedures,triggers,packages, functions, cursors,SQL queries. Implementing Materialized views for Reporting applications.
• Analyze the Existing code and make new Enhancement as per different customer's request.Developed complicated SQL queries using crystal reports .Created many database objects.
• SQL loader,analytical SQL,involved in Dynamic cursors,data analysis and trouble shooting.Pl/sql ,varray nested tables,bulk DML operation. Global temporary tables.
• Design, modify and analyze existing business applications and processes and provide recommendations for system improvements or enhancements for improved efficiency and/or process improvement.
• Performance tuning, SQL tuning. Recommend and implement changes to the Oracle instance to alleviate performance problems allowing for better throughput. Analyze Oracle instances for performance bottlenecks.Tuned the SQL's procedures,forms, reports with the output of Oracle Tools Explain Plan, TKPROOF, statspack. Oracle partioning, indexing.
• Developed Logical and Physical Data modeling and desigining, writing server side stored procedures/ triggers. Written the Interface Stored Procedures and shell scripting for Data Transformation.
• Involved in Testing (Both Unit and Integration Level) and Implementation. Tested the entire application in Testing environment and exported to Production written testing scripts. Documentation and provided on-site production support.

Environment: Oracle 8i/9i/10g ,OEM, ,Sun Solaris 2.8,Windows XP,Oracle forms 6i/9i,PL/SQL, SQL, Visio, SQL*LOADER, TOAD, PL/SQL Developer, Erwin,ETL Crystal reports .

Confidential
Confidential, Iowa, US Mar 2003- May 2005
Oracle DBA/Oracle developer
This project deals with employees service,Insurance coverage,years of experience and type of plan he is involved.The rate of insurance coverage depends on their type of job ,where monthly premium billing will be calculated.Involved in nightly process,statement processing and payment processing.Another project deals with drug testing taken on different person on different medicines.

• Oracle installations, upgrades, database design, Performance tuning, data porting, objects, schema creation. Hot, cold, and archive backups, disaster recovery planning and implementation.
• Writing PL/SQL Procedures ,Writing PRO*C programs
• Unix Administration & writing Shell script to automate processes like FTP
• Set guidelines and coordinate with Development Teams.
• Database and Instance reconfiguration and Tuning
• Evolving optimal Backup strategy ,Data Replication using Advanced Queue methodology
• Performance monitoring using Precise Software
• Physical files distribution based on I/O statistics to improve performance
• Security - Users & Privilege Management
• MS SQL Server 7.0 Installation, Administration and writing TRANSACT SQL Procedures. Creating PL/SQL Packages, Functions, Procedures, Sequence, Synonyms, Views, and Database Triggers, Object Views, PL/SQL database objects.Maintain and develop security procedures. Creating the Oracle schema i.e. table spaces, tables, indexes, constraints, triggers, synonyms, database links, roles,partioning etc.

Environment: Sun Solaris 2.8,Windows XP, Oracle 9i, SQL, PL/SQL in unix and windows ,Shell script, Oracle Enterprise Manager, PL/SQL Developer tool,SQ Navigator,T.O.A.D,RMAN.

Confidential, California , U.S.A. Dec 2000 - Dec 2002
System Analyst & Oracle developer

As a Developer involved in the Project Planning, Scheduling, Tracking of the maintenance of the state wise vehicle emission control details database system. Also involved in the database related preparation of functional specifications, test plans, Code Reviews. Implemented the project and involved in the user training and testing.

• Developing PL/SQL stored procedures, packages and Shell scripts to generate an automated process of spooled data feedouts for the e-billing report system.
• Perform simulated testing in a test environment to observe the impact of the new programs.
• performance tunning,backup and recovery,database 9i installation and user privilege maintenance,space maintenance.
• Analyze the scope of changes that need to be carried out to the billing system to accommodate changes to different remote databases.
• Provide accurate, comprehensive documentation,trouble shooting(bug-fix) and write-ups of the analysis results for the scope of required changes.
• Creation and enhancement of back end database objects that access the remote databases as part of the changes for the data migration project. Making enhancements and maintaining Pro*C programs for related impact on the Billing system.
• Carrying out end-to-end integration testing starting from unit testing in the Development database, observing the performance in the UAT database for user approval and acceptance and finally migrating all changes to the Production database environment.

Environment: Sun Solaris 2.8, Oracle 9i, PL/SQL ,OEM, java script( XML),ASP.net, C ,T.O.A.D Tool.

Confidential, Coimbatore Feb 1997 - Apr 1999
programmer/analyst.
Accounts Payable Module: This module is highly integrated with Purchase Order, Inventory and Finance Module. The highlights of the modules are Finance,Goods Receipt Note (GRN) are prepared by Stores Department against Purchase Orders, Payment Voucher, Creditors post dated Check Voucher, Journal Voucher all are generated automatically by the above module. Financial Module: Nature of work involved in the Reverse Engineering/Migration of Financial module.

Environment:Sun Solaris 2.5, Cobol, Oracle 7.3.3, Forms 4.5, Reportwriter 1.1, Pro*C.

EDUCATIONAL QUALIFICATIONS
MCA - Master of Computer Applications
BS - Bachelor of Science