Developer Sql
Resume:
MINICHITRA SHANMUGANANDAN
ph: no:925-***-****, Email *********@*****.***
SUMMARY
• Over 8 years experience in Information Systems as an Oracle DBA, systems Analyst/Programmer,
Developer, Architect, System Engineer.
• 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, and 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,
TKPROF, 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, and ODBC.
• 2+ experience in designing GUI applications and web base based applications as a customers’
requirements using tools like UML-Rational Rose.
• Εxperience 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, Pl/sql 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
Gymboree Corporation, Sanfrancisco,CA Oct 2007 – Till date
Oracle developer
Gymboree has a software development team does tracking of different store. Developed Price
Management Application, regarding different branch stores 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
• Designed and developed PL/SQL procedures/functions/triggers which carry out data flow to
respective schemas meant for different client data models.
• Developed 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.
Page 1 of 2
• Developed and maintained purging data for different level of pricing 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 Micro strategy and business objects reports
• Created and managed 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
• Developed Fiscal Annual report(weekly, monthly, quarterly, yearly) in Micro strategy 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, Micro strategy 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.
Alto dairy, 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,
(ERP)Journal 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 data models 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 modelling and designing, 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 .
IFMC – Iowa Foundation For Medical Care (www.ifmc.org)
West Des Moines, 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
Page 2 of 2
• 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.
MCI World com, 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.
Lakshmi Ring Travellers Ltd, 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, Avinashlingam University, INDIA.
BS - Bachelor of Science from Avinashlingam University, INDIA.
Page 3 of 2
Page 4 of 2
Contact this candidate