SUMMARY:

• Around 6 years of IT experience in Software Development life cycle and in analysis, design, modeling and implementation of business logic.
• A good Team player with excellent communication and time management skills.
• Good experience in Dimensional modeling, Star and Snow flake schema and OLTP/OLAP.
• Solid knowledge in ETL and warehouse concepts.
• Good knowledge in mapping data from source to target.
• Analysis and in Conceptual, Logical and physical data modeling.
• Extensive experience in creating stored procedures, functions, packages, triggers and other database objects using SQL, PLSQL.
• Worked on oracle PLSQL constructs nested tables, associative arrays, records, varrays and dynamic SQL and analytical functions.
• Good work experience in different operating systems UNIX, Windows 95/98/NT/XP/2000.
• Expertise in Tuning and management of SQL scripts and documentation of the work.
• Good experience with database design, database dictionary views, data flow diagrams and Data Modeling.
• Good experience with UNIX shell scripting, Performance tuning and explain plain
• Good experience in extraction, transformation, loading and data mapping.
• Experience in installing oracle 9i/10g software and creating databases using manual scripts and database configuration utility.
• Experience in tuning and writing complex sql queries.
• Support and maintenance of database servers in a 24 hour working environment.
• Strong in working on UNIX environment and working with FTP and SCP to transfer files to remote servers.
• Good working knowledge of Oracle Database Architecture and experience in DBA skills, configuration of Data guard.
• Good experience in creating users and assigning roles and privileges to the users.
• Expertise in MS office tools, Visio, SQL*loader, Import/Export and Import/Export dump utilities.
• Good understanding of Oracle Database Architecture.
• Good technical knowledge with the ability to solve current technical issues and understanding of overall business logic.
• Certified as Oracle Certified Associate.

TECHNICAL SKILLS:

Operating Systems: Windows 98/ NT/ 2000/ XP/VISTA/7, UNIX, HP - UX11.23, Linux, Solaris 10, AIX.

Programming Languages: C,C++, C#, Java, Oracle SQL, PLSQL programming, UNIX scripting, Java scripting,PERL scripting,VB Scripting, Pro * C.

Databases & Reporting: Oracle 8i/9i/10g/11g, SQL Server, MS Access 2000, Sql*Plus, Oracle reports

Tools: & Utilities: Import/Export Utility, Import/Export Data pump, Sql*Loader, Dimensional Modeling, Putty/Unix,, Dream weaver, Informatica, Remedy, VERITAS, Load Runner, Toad 9.5/8.6.1, Demantra, SQL Navigator, XML Erwin, RMAN, TK-Prof, Explain plan, UTL File packages.

Packages: MS office 97/ 2000/ 2007, MS Office, MS Visio, MS PowerPoint, MS Word/Excel, MS Project, Microsoft Visio

Others: UML, RDBMS Concepts, Mercury Quality center 9.0, VNCserver.

PROFESSIONAL EXPERIENCE:

Confidential

Sr Oracle Developer.

Responsibilities:

• Participated actively in the project maintenance and worked to meet the deadlines.
• Involved in Weekly Projects status meetings.
• High interaction with client and resolving the issues.
• Worked on peregrine to track the issues reported.
• Moved dbms jobs to control M jobs.
• Involved in scripting unix shell script which acts as a wrapper between control M and oracle.
• Worked extensively to fix issues on production support tickets.
• Actively involved in deployments and code checkins to subversion.
• Assisted other developer to check the code and reviewing the code.
• Actively involved with Oracle DBA and Unix Admins to resolve the infrastructure/agent setup issues for control M job deployments.
• Actively involved in remediation tasks.

Environment.: Oracle 11g, Oracle APEX, Java script, Subversion, Toad, PLSQL developer, Unix, Unix scripting, Control M tool, Peregrine defect tracking.

Confidential

Sr. PLSQL Developer

Responsibilities:

• Participated actively in the project maintenance and worked to meet the deadlines of the agile methodology.
• Involved in creating ERD diagrams and IT daily status meetings.
• Coordinated with the offshore team to perform development and defect fixes.
• Maintained schemas for parallel development of the releases.
• Actively involved with DBA in solving performance and environment related issues.
• Optimized sql query for better performance in both Development and production related queries.
• Deployed objects in various environments.
• Actively involved in deployments of the code in various test and prod releases.
• Created stored procedures and packages and maintained best industry standards.
• Used Clear case to check-in the code and Quality center for defect tracking.
• Updated and maintained all the DDL and DML scripts for production release.
• Assisted other teams in code related issues.

Technical Envrionment: Oracle 10g, Message Broker, Java, J2ee,Toad, sql developer, Oracle Data modeler tool, Unix, Mercury Quality Center.

Confidential

Sr PLSQL Developer

Responsibilities:

• Participated actively in every day scrum and tri-weekly sprint-planning meeting in agile methodology.
• Involved in Data modeling meetings and IT screen review meetings.
• Altered objects based on every day data modeling meetings.
• Created ERD using oracle data modeling tool after each sprint meeting.
• Updated and maintained DDL script of all tables.
• Created referential integrity constraints and seeded data for tables.
• Written complex queries, dynamic sql and assisted application team in resolving query related issues.
• Written oracle packages and stored procedures.
• Created oracle views and functions.
• Frequently checked in code to SVN.
• Updated documents and ERDs to share point.
• Actively involved with DBA in resolving database related issues.
• Sent scripts to DBA for each application build of the sprint.
• Loaded data into tables from a different database and from flat files.
• Coordinated with Offshore team.
• Used JIIRA to access and log defects.

Technical Environment: Oracle SQL Developer, Oracle 11g,Java Hibernate, Cognos, web sphere, Unix, Oracle Data modeling Tool.

Confidential

PLSQL & Reports Developer

Responsibilities:

• Participated in project kick-off meeting and weekly status meeting.
• Participated in preparing the technical specification documentation.
• Generated reports using Birt tool and written complex sql queries.
• Run Gem process to load data into internal tables based on context dates.
• Good hands on experience with the Fermat risk management tool.
• Performed in writing & query tuning of new and enhanced stored procedures, functions, packages.
• Created stored procedures, functions, triggers and packages based on requirements.
• Good experience in creating database objects like tables, views, synonyms, constraints, indexes, materialized views, sequences based on requirements.
• Experience in drill through the entire workflow to fix defects.
• Good use of ref cursors and collections in greater execution of procedures.
• Experience in handling errors and use of pragma exception init and raise application error.
• Participated in data modeling and presented power point presentations.
• Good experience in writing procedures with dynamic SQL.
• Good experience with explain plan and hints to tune performance of the complex queries
• Performed in deliverable duties based upon the milestone and also generated reports
• Good use of for all statements to improve performance and execution of the procedures.
• Strong use of tools like toad, oracle sql developer and Erwin.
• Worked with Technical writers in preparing the system documentation and user manuals.
• Worked with the end-users for enabling the smooth transition from the manual system thereby fixing bugs once the system went to production.
• Generated reports for the end user based on the requirement.

Technical Environment: Toad 8.5.3, Oracle 10g, Birt Tool, Fermat Web, web sphere, Rational Quality Manager, Unix.

Confidential

PL/SQL Developer

Responsibilities:

• Involved in gathering requirements, reviewing and documentation.
• Participated in project kick-off meeting and weekly status meeting.
• Participated in preparing the technical specification documentation.
• Involved in coding and the development of Inventory modules of the items of Project.
• Performed in writing & query tuning of new and enhanced stored procedures, functions, packages.
• Created stored procedures, functions, triggers and packages based on requirements.
• Good experience in creating database objects like tables, views, synonyms, constraints, indexes, materialized views, sequences based on requirements.
• Good use of ref cursors and collections in greater execution of procedures.
• Experience in handling errors and use of pragma exception init and raise application error.
• Participated in data modeling and presented power point presentations.
• Good experience in writing procedures with dynamic SQL.
• Good experience with explain plan and hints to tune performance of the complex queries
• Performed in deliverable duties based upon the milestone and also generated reports
• Good experience with Sql * loader in loading flat files.
• Good use of for all statements to improve performance and execution of the procedures.
• Strong use of tools like toad, oracle sql developer, Erwin and SQL*loader.
• Worked with Technical writers in preparing the system documentation and user manuals.
• Worked with the end-users for enabling the smooth transition from the manual system thereby fixing bugs once the system went to production.
• Generated reports for the end user based on the requirement.
• Good use of external tables, table functions to load data into oracle tables.
• Provided Production Support and interacted with the business/end users directly to resolve issues.
• Created and Tested SQL*Loader scripts to load data from flat files into Oracle Database.

Technical Environment: Toad 8.5.3, Oracle 10g, SQL*loader, Java, Quality Center, Sybase PDM power Designer, JAVA, Oracle RAC, Load Runner, SQL* Loader.

Confidential

 Oracle PLSQL Developer

Responsibilities:

• Supported in software installation on Oracle 9i, Toad, Microsoft Visio, UNIX and other party tools.
• Modified and developed sql codes and maintained documentation for support and team business.
• Participated in weekly status meetings to discuss new plans and
• Involved in Developing, Tuning SQL and PL/SQL code.
• Worked in mapping data from source to target and applied transformations.
• Good experience in data conversions and complex transformations.
• Worked extensively on various kinds of queries such as Sub-Queries, Correlated Sub-Queries, Dynamic SQL
• Created stored procedures, functions, triggers and packages based on business rules and functional requirements.
• Reports, performance tuning for various events and modules.
• Extensive use of SQL* loader for loading data from flat files to oracle database.
• Good use of import and export utilities for logical backups of the database.
• Created backups using VERITAS backup software and troubleshoot them when the backups failed.
• Responsibility included in trouble shooting errors in the production environment.
• Developed batch scripts to update the duties weekly or monthly.
• Created and Maintained bug tracking using Remedy software.
• Monitored the performance of the queries by running TKprof and explain.
• Created tables, views, materialized views, synonyms and external tables based on business requirement.
• Created indexes and partitioned tables in order to improve performance.
• Extensive use of PLSQL collections and native dynamic SQL to improve performance of procedures.

Technical Environment: VERITAS backup software, Microsoft Visio, Microsoft Excel, Troubleshooting Servers, Remedy software, Oracle 9i/10g,linux, Java.