SUMMARY

• Around 8+ years of experience with Oracle 9i, 10g and 11g working as Oracle SQL PL/SQL Developer.
• Extensive experience in writing/debugging Oracle SQL, Dynamic SQL, PL/SQL code i.e. Packages, Stored Procedures, Functions, Triggers, Cursors, Ref Cursors, Constraints, Indexes, Views, Materialized Views, Database Links (DBLINKS), Sequences, Synonyms, and Global Temporary tables.
• Extensive experience in Complex SQL Queries, SQL Server enterprise edition, Dynamic SQL, Analytical function, Oracle forms etc.
• Extensive experience in Extraction, Transformation loading (ETL) data from various sources using WebSphere, DataStage, Ascential DataStage. Worked on data stage client tool like DataStage designer, DataStage Director, DataStage Manager and DataStage Admin.
• Strong understanding of the principles of Data Warehouse using fact tables, dimension tables andstar schema modeling.
• Familiar in using highly scalable parallel processing infrastructure using parallel extender.
• Hands - on experience with SQL Server 2008/2005/2000 databases in query optimization & performance tuning using, SQL Profiler, Performance Monitor, Explain Plan.
• Experience in code optimization and improving efficiency in databases including reorganizing and rebuilding indexes, updating statistics, recompiling stored procedures and performing other maintenance tasks.
• Extensive and very intense SQL coding and development experience for OLTP database.
• Experience using TOAD and PL/SQL Developer for query building and analysis and manipulations of databases for checking compatibility and integrity of RDBMS.
• Extensive experience in working with end users and documentation of business process.
• Possess sound knowledge in various phases of Software Development Life Cycle (SDLC) including Design, Analysis, Development, Testing, and Implementation.
• Good understanding of Oracle Data Dictionary, RDBMS and Normalization Techniques.
• Experience with various DDL functions like Creation of Schemas, tables, Indexes, Materialized Views, and Partitioning tables.
• Assisted with Error/Exception handling methods using system defined exceptions and user defined exceptions.
• Experience in developing External Tables, Joins, Indexes and sequences.
• Experience in Dynamic SQL, PL/SQL Collections and Exception handling. Experience with various DDL functions like Creation of Schemas, tables, Indexes, Materialized Views, and partitioning tables.
• Assisted with Error/Exception handling methods using system defined exceptions and user defined Exceptions.
• Usage of utilities such as SQL Loader, export, imports.
• Strong skills in writing technical and functional documents defined by the business requirements.
• Experience in supporting the various production issues addressed by the users from the client side and providing them with required solutions.
• Experience in developing External Tables, Joins, Indexes and sequences.
• Highly motivated and adaptive with the ability to grasp things quickly with excellent interpersonal, technical and communication skills. Ability to work effectively and efficiently in a team and individually.

TECHNICAL SKILLS

Data Base: My Sql server 2012,Oracle11g,10g,9i,8i,7.x,MSAccess and SQL Server 2000,2005

Operating Systems: UNIX,Solaris10,Windows95/98/2000/XP/Vista.

Data Base Tools: iSQL *Plus, Toad 9.5, OWB (Oracle Warehouse Builder), Erwin 7.2, Sql*loader,SqlNavigator

SQL server tools: Management studio,Business intelligence,Development studio,Visual studio2005,EnterpriseManager,QueryAnalyzer, Profiler, OSQL, dtl, log shipping, Microsoft clustering services

Utilities: Oracle Developer Suites 10g, Forms 9i, 6i, 4.5 and Reports 6i, 2.5

GUI Tools: ASP.Net, HTML5, AJAX,XML,BootStrap

Languages: SQL,PL/SQL,C,C++,JAVA,UNIX,ShellScripting

Internet Technologies: Java Script, HTML and XML

PROFESSIONAL EXPERIENCE

Confidential, Highpoint, NC

Oracle forms & Pl/SQL Developer

Responsibilities:

• Developed new PL/SQL programs to load data through SQL loader and pull the respective data for those eligible to be processed based on various business criteria.
• Developed new Packages to load eligible Vendor Order Request into the Target table based on various business criteria using the MERGE Statement.
• Involved in writing DDL and DML operations.
• Worked very closely with SAP team in helping get the required procedure and function change, Execute pricing slot for the users to get the required data.
• Bug fixing in forms 11g for any functional related pricing slot.
• Migration of data from 10g to 11g in all environment and helping them get the desired tables location in TBBUAT(User control) and TBBWAR(Production).
• Worked closely with websphere to send the quotes to SAP functional and logistics team for final review and pricing.
• Worked with managers and team leads in submitting the data quality and logistics reports and create a new assist form and change the existing form which is the most commonly used at Confidential .
• Also performed performance tuning of database in P1 project deliverables.

Environment: Oracle Database 11g, SQL Server, Forms11g/10g/9i, Reports 11g/10g, Windows XP, Sun Solaris

Confidential, PA

Oracle PLSQL/SQL Server Developer

Responsibilities:

• Developed new PL/SQL programs to load data through Sql loader and pull the respective data for those eligible to be processed based on various business criteria.
• Developed new Packages to load eligible Vendor Order Request into the Target table based on various business criteria using the MERGE Statement.
• Involved in writing DDL and DML operations.
• Worked very closely with functional team to understand their Development related requirements.
• Worked on Migration of SQL server 2008 to SQL server 2012 in microsoft windows 2012 enterprise edition.
• Installed and administered Eight-Node clusters active/Passive on Microsoft Windows Server 2012 edition on SAN environment.
• Migration of SSIS Packages from SQL server 2008 R2 to SSIS 2012.
• Written complex SQL queries with complexity using Inner/Outer joins, Union All, Intersect & Minus set operators.
• Designed and developed several views like Materialized View for data retrieval for the reports.
• Created a package to generate the Trace file for the Materialized View Groups using DBMS SUPPORT Package.
• Responsible for Tuning of application with the help of Other Team Members & Oracle Support.
• Created Table structures along with Triggers, Indexes like Bitmap and Function based Indexes.
• Tuned SQL queries to enhance performance, using the method Explain Plan both at backend and in Toad.
• Created test scenarios for created code and distribute across to the QA along with Knowledge transfer.
• Used Erwin to read Data Models.
• Written an excellent documentation about the entire NRTO flow.
• Extensively used TOAD tool to increase the productivity and application code quality.

Environment: Oracle 11g,SQL Server 2008/2012 enterprise edition, Microsoft reporting Services, TOAD, PLSQL Developer, Oracle 11g, 10g, Windows XP, Win Merge, Sybase, ETL, Power Designer 12.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Active Participation in the System Study.
• Involved in analysis, designing, coding, testing, implementation and maintenance
• Enhancement and troubleshooting of database processes (scheduled Procedures).
• Created tables, Indexes and views.
• Created Stored Procedures, PL/SQL Packages, Functions and Triggers.
• Wrote test cases and test scripts for all stored procedures.
• Developed SQL loader scripts to load data in the custom tables.
• Wrote complex SQL queries to retrieve information from the databases depending on user requirement.
• Participated in analyzing and normalizing the database.
• Involved in preparing documentation and user support documents.

Environment: Oracle 8i, oracle 9i, SQL *Plus, Toad and Windows XP.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Incorporating all the business rules, writing code-using SQL, PL/SQL.
• Mapping Operational Repository to Business Repository elements and incorporating the build rules.
• Used SQL Loader to load data into different tables from flat files.
• Wrote stored procedures, functions and database triggers to perform and verify accounting.
• Extensively used complex SQL queries with various Joins, sub-queries to validate data.
• Created reports using MS access tool according to specific guideline.

Environment: Oracle database 9i, SQL, PL/SQL, SQL*PLUS, SQL*Loader, MS Access.