SUMMARY

• 8 years of experience in Oracle, SQL, PL/SQL, and SAS technologies 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.
• Developed SQL*Loader control programs to transfer external data into staging tables. Written PL/SQL validation scripts to transfer clean data from staging tables to production tables.
• 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 wif multi-terabytes database
• Experience and noledge 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 has 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 noledge of Apex 3.0, HTML, CSS, and JavaScript
• Good understanding of data mining concepts, ETL processes, and data modeling concepts such as design of teh 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 wif proven ability to deliver excellent results in competitive environment

TECHNICAL SKILLS

Database: Oracle 12c/11g/10g/9i/8i, Forms 10g/9i/6i, Reports 10g/9i/6iOracle EBS 11i.

Programming Languages: PL/SQL, SQL, C, C++, VBA, SAS 9.0, MATLABAWK, HTML, CSS, DHTML, Shell Scripting

Tools: Developer 2000, Forms & Report 6i/9i, SQL Plus, TOADSQL Developer, SQL*Loader, Informatica Power CenterEdit Plus, Rapid SQL, WinScp, Perforce, SharePoint, SubversionSQL Server Management Studio, FTP.

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

Communication tools: MS Outlook, Lotus Notes

PROFESSIONAL EXPERIENCE

Confidential, Greensboro, NC

Data Analyst/Sql Developer

Responsibilities:

• Worked wif Tech lead, Business analyst, Responsible in gathering Requirements and IT review. Interacted wif Business Users in teh 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 teh requirements, target and source data
• Production Support based on on-call rotation basis, since 2 years for all HUBDI Autosys Jobs.ICC/HUBODS/FIDO/SOLR(AWD,ECS1,ECS2)
• Involved in Data analysis and Data profiling
• Used Soup UI for Testing teh DATA and to make a keen analysis on teh raw data by generating teh Test suite.
• TOAD, SQL Developer tools were used to develop programs and executing teh 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 wif BA’s and teh DBA’s to analyze teh issues that were encountered while testing teh applications.
• Involved in Data analysis and Data profiling.
• Responsible to validate teh data between teh various systems and drive changes that ensure teh integrity based on Business Rules and Transformations.
• Involved in reading and analyzing teh data mapping documents.
• Strong ability in developing advanced SQL queries to extract and calculate information to fulfill data and reporting requirements .
• Used teh Toad Data Analyst to compare teh results between teh Source and teh Target .
• Used teh ALM tool to write teh test cases and to track teh defects.
• Extensively worked wif Excel advanced commands for preparing and comparing teh 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 teh regression testing.

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

Confidential, Utica, NY

Senior Oracle PL/SQL Developer

Responsibilities:

• Involved in Data Analysis, and Design teh Process flows in teh more efficient way then earlier flows.
• Worked individually in developing teh 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 teh DATA and to make a keen analysis on teh raw data by generating teh Test suite.
• Fine-tuned teh SQL queries using Explain Plan.
• TOAD, SQL Developer tools were used to develop programs and executing teh queries.
• Extensively wrote SQL Queries (Sub queries, correlated sub queries and Join conditions) for generating various kinds of reports as per teh user requirement.
• Provided support for teh application database related issues.
• Involved in coding, debugging, and trouble-shooting.
• Involved in reports designing and developing. Involved in integrated reporting capability.
• Developed various reports using oracle reports builder 6i and upgrades teh existing reports .
• Developed teh Stored procedures using PL/ SQL Tables and records to generate teh output in XML format.
• Involved in teh data analysis and data discrepancy reduction for teh source and target schemas.
• Using UNIX shell scripting created batch jobs to create Index and Analyze tables once teh Imports are done.
• Automating data loading, extraction, report generation using UNIX shell scripting.
• Involved in writing Oracle PL/SQL packages, functions, procedures, Korn Shell scripts that were used for staging, transformation and loading of teh data into base tables.
• Provided support for teh application database related issues.
• Involved in coding, debugging, and trouble-shooting.
• TOAD, SQL Developer tools were used to develop programs and executing teh queries.
• Developed forms using forms 6i based on business requirements.
• Worked wif SQL Query performance issues. Used index logic to obtain teh 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 teh 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 teh queries.
• Developed forms using forms 6i based on business requirements.
• Worked wif SQL Query performance issues. Used index logic to obtain teh good performance.
• Involved in teh monitoring of database performance in Enterprise Manger console.
• Studied user requirements and functional specifications.
• Converted User Requirements into formal Functional specification and Interfacing wif client.

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
• Used SQL*Loader to load data from external system and developed PL/SQL programs to dump teh data form staging tables into base tables.
• Extensively wrote SQL Queries (Sub queries, correlated sub queries and Join conditions) for generating various kinds of reports as per teh user requirement.
• Designed star schema using dimensional modeling and created fact tables and dimensional tables. Used Erwin for Logical and Physical database Modeling.
• Installation and configuration of Informatica Power Mart
• Used Informatica Designer (Power Mart) to create complex Mappings
• Created mappings using various Transformations like Source Qualifier, aggregator, expression, filter, joiner, lookup, update strategy, sequence generator and prepared Documentation for teh Mappings
• Developed several Informatica mappings that transfers data from source teh Data Mart.
• Created Source definitions, Source Tables, Target definitions and Target Tables.
• Used Informatica Server Manager to create sessions/ batches to run wif teh logic embedded in teh mappings.
• Tuning Informatica session parameters for performance and running them.
• Prepared documentation of Informatica ETL implementation.
• Involved in reports designing and developing. Involved in integrated reporting capability.
• Developed various reports using oracle reports builder 6i and upgrades teh existing reports .
• Developed teh Stored procedures using PL/ SQL Tables and records to generate teh output in XML format.
• Involved in teh data analysis and data discrepancy reduction for teh source and target schemas.
• Scheduled teh jobs using crontab in UNIX.
• Using UNIX shell scripting created batch jobs to create Index and Analyze tables once teh Imports are done.
• Automating data loading, extraction, report generation using UNIX shell scripting.
• Involved in writing Oracle PL/SQL packages, functions, procedures, Korn Shell scripts that were used for staging, transformation and loading of teh data into base tables.
• Provided support for teh application database related issues.
• Involved in coding, debugging, and trouble-shooting.
• Involved in Data loading and data migration - Used SQL * Loader to load data from excel file into staging table and developed PL/SQL program to load data from staging table into base tables.
• Used Erwin for designing Database both logical and physical data modeling.
• TOAD, SQL Developer tools were used to develop programs and executing teh queries.
• Developed forms using forms 6i based on business requirements.
• Worked wif SQL Query performance issues. Used index logic to obtain teh good performance.
• Involved in teh monitoring of database performance in Enterprise Manger console.
• Studied user requirements and functional specifications.
• Converted User Requirements into formal Functional specification and Interfacing wif 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 wif client.
• Designed, Partitioned, Developed and Maintained teh 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 teh data into base tables.
• Used CRONJOB for job scheduling on UNIX as well as tools like Autosys to run regular day to day administration scripts and setting up batch scripts.
• Developed teh stored procedures using PL/SQL Tables and records to generate teh output in XML format and pull data from Web services and from XML format and parse it and load it into tables.
• Enhancing teh 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.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Created teh database Objects such as Tables, Views, Indexes, constraints .
• Involved in Development, Testing and Maintenance database objects.
• Developed teh forms for teh application and developed Procedures and functions at application level.
• Created teh Stored Procedures, functions and Packages using PL/SQL.
• Oracle PL/SQL functions, procedures, Korn Shell scripts were used for staging, transformation and loading of teh data into base tables
• Performed data loading using Data Loader to teh data into staging tables.
• Created PL/SQL procedures in order to dump teh data from staging tables to base tables
• Scheduled teh jobs using crontab in UNIX.
• Developed a framework to establish procedure exception or job failure and alerted via email configuration.
• Responsible for developing reports as per Customers order using reports
• Involved in developing front end screens using forms 6i and generated reports using reports 6i.
• Created Editors, Created List of Values and Record Groups in Oracle Forms 6i.
• Developed Customer transaction upload module to load data into database from flat file wif business validation (Package, Procedures & Triggers are used).
• Worked closely wif quality assurance and development teams to clarify and understand teh functionality to resolve issues and provide feedback in terms of teh test matrices and to nail down teh bugs.
• Involved during User Acceptance Testing of teh application.

Environment: Oracle9i, Forms 6i, Reports 6i, TOAD, Data Loader, AUTOSYS SQL*Plus, PL/SQL, Windows NT server, UNIX.