Sql Developer
Resume:
Nalini T
Phone: 732-***-****
******.******@*****.***
Experience Summary
* ***** ** ** ********** related to Oracle Database programming and Application development.
•
Technical proficiency in PL/SQL, Unix scripting and SQL tuning.
•
Hands on experience in data modeling.
•
Hands on programming experience in Java, C, Perl.
•
In depth understanding of RDBMS concepts(Oracle) and Data Warehouse/ETL concepts.
•
• Familiar with MS SQL Server with hands on programming in T SQL.
Good understanding on Object Oriented programming.
•
Thorough understanding of all phases of the SDLC from requirements gathering till post implementation support.
•
Good communication, collaborative and problem solving analytical skills with proficiency at grasping technical concepts
•
quickly and utilizing the same in a productive manner.
Educational Qualifications
M.S, Computer Science, Oakland University, Michigan, USA .
•
B.S., Civil Engineering, J. N. T. U .C. E, India.
•
Certifications and Trainings
Oracle Database SQL Certified Expert (Oracle 10g/11g)
•
SUN certified Java Programmer (SCJP 1.4)
•
Training on Informatica Power Center 7/8.
•
Technical Skills
OS Linux, Solaris 8, WINDOWS XP
Languages PL/SQL, T SQL, Pro *C, Core Java, C, XML, Perl
DBMS/RDBMS Oracle 9i/10g/11g, MS SQL Server 2000/2005
ETL Tools Informatica Power Center 7.x
DBTools SQL*Loader, SQL*Plus, SQL Developer,TOAD
Web Server Apache Tomcat, Weblogic Server
Web tools JSP, Java Servlets.
Data Modeling Tool Erwin 4.3/7
Miscellaneous SVN, CVS
Project Summary
NYSE Euronext
Client
Role Database Developer
January 2010 – July 2010
Duration
Role & Responsibilities:
• Participated in requirements analysis for ETL in conjunction with Datawarehouse.
Worked on Oracle datawarehouse specific features like Analytic functions, External tables, Sql Loader utilities.
•
• Devised PL/SQL and T SQL scripts to perform data cleansing.
• Analysis of multiple source data for data profiling.
• Devised database triggers, stored procedures, packages to implement new development adhering to established coding
standards and Agile scrum software development methodology.
Worked on various Oracle partition features including table partioning and Index partitioning.
•
Performance tuning on SQL queries using explain plan, SQL hints and tuning application logic for enhanced
•
performance..
Performed Unit and system testing.
•
• Unix scripts to automate execution of daily loads and maintenance tasks .
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
Environment: Oracle 10g/11g, PL/SQL, MS SQL server 2005, T SQL, TOAD, Solaris, Sql Loader,SVN
Company Management Science Associates
Role Database Analyst/Developer
Duration May 2008 – December 2009
Role & Responsibilities
• Involved in database requirements analysis.
Involved in design and maintenance of data models(conceptual/logical/physical data models).
•
Evaluation of specifications for complex business requirements and processes prepare datamodels and databases solutions.
•
Participated in design and development of PL/SQL applications.
•
Devised database triggers, stored procedures, packages to implement new development adhering to established coding
•
standards and Agile scrum software development methodology.
Performed tuning of SQL queries using explain plan, tkprof, hints, database indexes.
•
Involved in design review and code review processes.
•
Performed unit and system testing and facilitating code delivery to production.
•
Investigated and resolved production and QA tickets.
•
Developed shell scripts to automate and schedule maintenance tasks.
•
Produced SQL Plus scripts for development and testing teams.
•
Performed basic DBA tasks such as database configuration,creating users, support and enhancement of development
•
databases.
• Development and testing of upgrade scripts for database enhancements.
• Maintained metadata, naming standards and standards for future application development.
Environment: Oracle 9i/10g, Erwin, SQL developer, PL/SQL, TOAD, SVN, Solaris,Microsoft Excel.
Applied Materials, US
Client
Role ETL/Database Developer
October 2006 – April 2008
Duration
Role & Responsibilities:
• Participated in requirements analysis for ETL in conjunction with DataMarts.
• Hands on working with dimensional databases.
• Worked with Oracle datawarehouse specific features like Analytic functions, External tables, Sql Loader, Data pump
utilities.
• Devised database triggers, stored procedures, packages for data transformation process and several internal modules.
• Worked with various Oracle partition features including table partioning and Index partitioning.
• Performance tuning on SQL queries using explain plan, SQL hints and database indexes.
Performed Unit testing.
•
Unix scripts to automate execution of maintenance tasks .
•
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
Environment: Oracle 10g/9i, PL/SQL, TOAD, Solaris, Sql Loader, Data Pump
CMC Ltd.
Company
Role Application Developer/ Database Programmer
November 2003 September 2006
Duration
Client : Department of Technical Education, India
Role & Responsibilities:
• Participated in ETL requirements analysis.
• Involved in development, testing, maintenance and documentation of ETL in PL/SQL, Perl for ODS.
• Developed back end interfaces in PL/SQL.
• Responsible for unit testing and documentation of the interfaces.
• Responsible for coding data cleansing process.
• Utilized SQL*Loader to bulk load external source data
• Developed Perl scripts to schedule and load of flat files to database on daily, weekly and monthly basis.
Environment: Oracle 9i, PL/SQL, Pro *C, SQL * Loader, Perl, SQL developer, Solaris 8,CVS
Client : Board of Intermediate Education, India
Role & Responsibilities:
• Involved in coding, tracing and tuning of database access tier using JDBC and Oracle.
• Developed, tested and documented back end code .
• Involved in Perl scripting for data cleansing process.
• Responsible for maintenance and support of the application system .
• Coded shell scripts to automate and batch process data maintenance tasks.
Environment: Oracle 9i, PL/SQL, JDK1.4, Perl, Solaris 8, SQL developer,CVS
References available on request.
Contact this candidate