SUMMARY:

• 8 years of experience in Oracle, SQL and PL/SQL involving database design, application development, implementation, quality testing, statistical analysis, and support.
• Involved in database design and data modeling to create ER diagram and database objects.
• Proficient in writing stored and application procedures, packages, database triggers and functions using PL/SQL.
• Fundamental understanding of materialized views, replication, and external tables
• Experience of complete Software Development lifecycle (SDLC) process
• Utilized oracle advance features like Bulk Bind (Bulk collect, For all), Ref Cursor, and Index - By Tables.
• Experience in quality testing of data-warehouse objects, using a customized scripts based on in-house methodology.
• Experience in maintaining and developing database objects like tables, views, indexes, sequences, synonyms etc
• Experience in tuning complex SQL statements using Explain plan and SQL trace
• Experience in utilizing oracle analytical and decoding functions and dealing with multi-terabytes database
• Experience and knowledge of FTP transfer from UNIX to Windows and vice versa
• Developed Interactive User Interfaces using Forms 6i/9i and generated reports using Reports 6i
• Experience in writing Shell (Korn, Bash, C) and AWK scripts and have utilized crontab functionality
• Experience utilizing dynamic SQL (dbms sql, Execute Immediate) functionality
• Generated Excel Reports using oracle supplied package UTL FILE for data analysis purpose
• Knowledge and experience of Data Analysis, Data Warehousing, and ETL Techniques
• Conceptual understanding of Data marts, OLAP, OLTP, STAR Schema, and Snowflake schema
• Expertise in Oracle 10g/9i/8i database server, forms 6i/9i and reports 6i/9i, and tools like SQL Plus, SQL Developer, TOAD, Data Loader, SQL * Loader, and RapidSQL.
• Experience and knowledge of HTML, CSS, and JavaScript
• Good understanding of data mining concepts, ETL processes, and data modeling concepts such as design of the dataflow, ER Diagrams, Normalization and Denormalization of tables
• Involved in unit testing, functional testing, system testing, data validation, and user acceptance testing
• Strong Inter-personal, analytical, and problem-solving skills with proven ability to deliver excellent results in competitive environment

TECHNICAL SKILLS:

Database: Oracle 12c/11g/10g/9i/8iProgramming

Languages: PL/SQL, SQLHTML, CSS, DHTML, Shell Scripting

Tools: Toad,Sql Developer,sqlplus

Operating Systems: Windows XP, 2000, VISTA, UNIX (Solaris, HP, AIX), LINUX

Communication tools: MS Outlook, Lotus Notes

PROFESSIONAL EXPERIENCE:

Confidential, Albany, NY

Data Analyst/Oracle Developer

Responsibilities:

• Attend meetings with Business users and gather project requirements, convert business requirements into technical design, coding using PL/SQL programming language
• Involve in creating various database objects like Tables, Views, Materialized Views, Procedures, Packages and Indexes.
• Use DBMS SCHEDULER to schedule the jobs and monitor them on daily basis
• Use tools like Toad and PL/SQL and Oracle 12c database to write complex SQL queries
• Involve in programming Views, Procedures and Packages
• Work with different teams like Data Administrators, Application Developers, Infrastructure and Networking teams to deploy the code and troubleshoot
• Involve in Data Analysis and Data profiling
• Perform code migration from development to stage to production
• Handle production support tickets using JIRA as tracking tool

Environment: Toad 12, PL/SQL Developer, Notepad++, Oracle 12c, JIRA.

Confidential, Greensboro, NC

Data Analyst/Oracle Developer

Responsibilities:

• Worked with Tech lead, Business analyst, Responsible in gathering Requirements and IT review. Interacted with Business Users in the design of technical specification documents.
• Tuning code, reviewing tables and applying indexes where needed.
• Analyse, design, code, and test highly efficient and highly scalable integration solutions using Informatica suite of products· Analyze the requirements, target and source data
• Production Support based for all HUBDI/HUBODS/SOLR(AWD,ECS1,ECS2)
• Involved in Data analysis and Data profiling
• Used Soup UI for Testing the DATA and to make a keen analysis on the raw data by generating the Test suite.
• TOAD, SQL Developer tools were used to develop programs and executing the queries.

Environment: Toad 12, SQL developer, Unix, Putty, Notepad++,Oracle 10g/11g/12c,JIRA.

Confidential, Winston Salem, NC

Senior Oracle PL/SQL Developer

Responsibilities:

• Interacted with BA’s and the DBA’s to analyze the issues that were encountered while testing the applications.
• Involved in Data analysis and Data profiling.
• Responsible to validate the data between the various systems and drive changes that ensure the integrity based on Business Rules and Transformations.
• Involved in reading and analyzing the data mapping documents.
• Strong ability in developing advanced SQL queries to extract and calculate information to fulfill data and reporting requirements .
• Used the Toad Data Analyst to compare the results between the Source and the Target .
• Used the ALM tool to write the test cases and to track the defects.
• Extensively worked with Excel advanced commands for preparing and comparing the data.
• Developed ETL’s for data extraction, Data mapping and Data Conversion using SQL, PL/SQL.
• Performed system testing, functional testing and Integration testing and the regression testing.

Environment: Toad 12, SQL developer, Unix, Putty, Notepad++, Oracle 10g/11g,ALM12.0

Confidential, Utica, NY

Senior Oracle PL/SQL Developer

Responsibilities:

• Involved in Data Analysis, and Design the Process flows in the more efficient way then earlier flows.
• Worked individually in developing the Procedures, Functions, Cursors, Complex Queries and Performed Data loading using ORACLE ODI (oracle data Integrator).
• Experience in using Dynamic SQL's, BULK COLLECT, REF Cursors and VARRAYS and Collections..
• To develop Test Plan and participate in UNIT testing and System Integration Testing for Production Implementation.
• Involve in Unit testing PL/ SQL Stored Procedures and Functions.
• Used Soup UI for Testing the DATA and to make a keen analysis on the raw data by generating the Test suite.
• Fine-tuned the SQL queries using Explain Plan.
• TOAD, SQL Developer tools were used to develop programs and executing the queries.
• Extensively wrote SQL Queries (Sub queries, correlated sub queries and Join conditions) for generating various kinds of reports as per the user requirement.
• Provided support for the application database related issues.
• Involved in reports designing and developing. Involved in integrated reporting capability.
• Developed various reports using oracle reports builder 6i and upgrades the existing reports .
• Developed the Stored procedures using PL/ SQL Tables and records to generate the output in XML format.
• Involved in the data analysis and data discrepancy reduction for the source and target schemas.
• Involved in writing Oracle PL/SQL packages, functions, procedures, Korn Shell scripts that were used for staging, transformation and loading of the data into base tables.
• Provided support for the application database related issues.
• Involved in coding, debugging, and trouble-shooting.
• TOAD, SQL Developer tools were used to develop programs and executing the queries.
• Developed forms using forms 6i based on business requirements.
• Worked with SQL Query performance issues. Used index logic to obtain the good performance.

Environment: Oracle 10/11g, Rapid SQL, Edit Plus, SQL Plus, SQL, PL/SQL, UNIX (HP), Shell (Bash) Script, Windows XP, LINUX, Soup UI

Confidential, Greensboro,NC

Senior Oracle PL/SQL Developer

Responsibilities:

• Involved in creating Oracle tables, views, procedures, packages, triggers, functions and indexes.
• Designed star schema using dimensional modeling and created fact tables and dimensional tables.
• Manipulated large amount of data.
• Extensively wrote SQL queries for generating various kinds of reports as per the usual requirement.
• Debugged SQL and provided alternate ways to write SQL for DB performance improvements.
• TOAD, SQL Developer tools were used to develop programs and executing the queries.
• Developed forms using forms 6i based on business requirements.
• Worked with SQL Query performance issues. Used index logic to obtain the good performance.
• Involved in the monitoring of database performance in Enterprise Manger console.
• Studied user requirements and functional specifications.
• Converted User Requirements into formal Functional specification and Interfacing with client.

Environment: Oracle 10/11g, Rapid SQL, Edit Plus, SQL Plus, SQL, PL/SQL, UNIX (HP), Shell (Bash) Script, Windows XP, LINUX, Soup UI

Confidential, Hoover,Alabama

Senior Oracle PL/SQL Developer

Responsibilities:

• Involved in designing, developing, and testing of PL/SQL stored procedures, packages and triggers.
• Developed complex SQL and PL/SQL queries.
• Created database objects like Tables, views, synonyms, Indexes etc
• Extensively wrote SQL Queries (Sub queries, correlated sub queries and Join conditions) for generating various kinds of reports as per the user requirement.
• Used Informatica Designer (Power Mart) to create complex Mappings
• Developed several Informatica mappings that transfers data from source the Data Mart.
• Created Source definitions, Source Tables, Target definitions and Target Tables.
• Used Informatica Server Manager to create sessions/ batches to run with the logic embedded in the
• Involved in writing Oracle PL/SQL packages, functions, procedures, Korn Shell scripts that were used for staging, transformation and loading of the data into base tables.
• Provided support for the application database related issues.
• Used Erwin for designing Database both logical and physical data modeling.
• TOAD, SQL Developer tools were used to develop programs and executing the queries.
• Developed forms using forms 6i based on business requirements.
• Worked with SQL Query performance issues. Used index logic to obtain the good performance.
• Involved in the monitoring of database performance in Enterprise Manger console.
• Studied user requirements and functional specifications.
• Converted User Requirements into formal Functional specification and Interfacing with client

Environment: Oracle 10/11g, Rapid SQL, Edit Plus, Perforce, WinScp, SQL Plus, SQL, PL/SQL, UNIX (HP), Shell (Bash) Script, AWK, SQL * Loader, Windows XP, LINUX, Erwin, Informatica Power Center 9.1

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Studied user requirements and functional specifications.
• Converted User Requirements into formal Functional specification and Interfacing with client.
• Designed, Partitioned, Developed and Maintained the necessary database objects
• Participated in implementation meeting strategies.
• Involved in developing Entity Relationship diagrams/Dimensional Diagrams for business requirements using ERWIN.
• Designed and developed Oracle Forms & Reports using Forms10g and Reports 10g. Including Forms based on stored procedures.
• Developed ETL’s for Data Extraction, Data Mapping and data Conversion using SQL, PL/SQL and various shell scripts in Data stage.
• Involved in writing Oracle PL/SQL functions, procedures and packages in Oracle RAC environment.
• Written Bash Shell scripts that were used for staging, transformation and loading of the data into base tables.
• Enhancing the existing packages for better performance and providing on-going support to existing applications and troubleshooting serious errors when occurred.
• Used Bulk processing for performance enhancement.
• Created UNIX shell scripts using SQL*Loader, SQL*Plus and PL/SQL programs that run as nightly interfaces.
• Was responsible for development and testing of conversion programs for importing data from text files into Oracle database utilizing SQL *Loader.

Environment: Oracle 10g/11g, PL/SQL, SQL Plus, Erwin 7.3,SQL Navigator, XML, Shell Scripting, SQL*Loader, Shell Scripting, SQL developer, Reports 10g/6i,CSS, DBMS JOB,UTL FILE,UNIX.