SUMMARY

• Experience in all phases of Software Development Life Cycle (SDLC) including analysis, specification, software and database administration, development, maintenance, testing and documentation.
• Excellent proficiency in Data Extraction, Transformation and Loading, Database Modeling and Data warehousing tools and technologies such as ODI.
• Profound Knowledge in Star Schema Modeling and Snowflake Dimensional Modeling (Data Marts, Facts and Dimensions.
• Strong technical expertise in creating and maintaining database objects - Tables, Views, Materialized Views, Indexes, Sequences, Synonyms, Database Links and Database Directories.
• Extensive experience in developing PL/SQL Stored Procedures, Functions, Packages, Cursors, Collections (Nested tables and Varrays), Records, Object types and Database Triggers.
• Proficient in Oracle utilities and tools - SQL*loader, Export/Import, TOAD 8.0/8.5/9.0, SQL*plus, iSQL*plus, SQL Developer and SQL Navigator.
• Expertise in generating customized Forms and Reports using Oracle Forms and Reports 6i/9i.
• Expertise in Performance Tuning and Query Optimization using various types of Hints, Partitioning, Bulking techniques and Indexes.
• Profound experience in Tuning SQL queries using utilities like EXPLAIN PLAN, SQL Trace and TKPROF to improve the performance.
• Strong experience in Oracle ETL data loading techniques like UTL FILE, SQL loader, Copy Command and External tables from various business source environments.
• Strong knowledge of UNIX Shell Script on Sun Solaris 2.8/2.7 and Confidential UNIX 12.x/11. x and Worked on KORN Shell Scripts to write maintenance script for Oracle.
• Exposure in Oracle Applications 11i Oracle Financials (AR, AP, GL modules of Oracle Applications 11i in multi Org, multicurrency environment
• Experience in writing ANT build scripts to automate the compilation, creating directory structures, generate classes from WSDL, deploy the services onto the Web Server, and generate JAR and WAR files.
• Ability to work in a team environment and as an individual with strong technical and communication skills, and good zeal in adapting new technologies in a fast-paced environment.

TECHNICAL SKILLS

Databases: Oracle 8i/9i/10g/11g, MS-SQL Server 7/2000, MS Access.

Languages: C, C++, COBOL HTML/DHTML, XML, PERL and T-SQL.

Scripting: SQL, PL/SQL, UNIX Shell Scripting.

Reporting Tool: Business Objects, Crystal Reports.

ETL Tool: ODI.

Query Tools: TOAD, SQL Developer, Pro*C, SQL Navigator, SQL* Plus, iSQL* Plus.

Operating Systems: HPUX, Solaris 7.0/8.0, MVS, Windows 2000/NT/XP/7/98 and UNIX.

GUI: Developer 2000-Forms 6i/9i, Reports 6i/9i.

Packages: Micro Soft Office Suite- MS-Word, MS-Excel, MS-Power point.

Other Tools: SQL*Loader, MS-Visio, MS Project Professional 2003, PVCS, VSS, IBM

PROFESSIONAL EXPERIENCE

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Worked on SQL*Loader to load data from flat files obtained from various facilities every day. Used standard packages like UTL FILE, DBMS SQL and PL/SQL collections and used BULK binding involved in writing database procedures, packages and functions for front end module.
• Database experience using Oracle 12c.
• Designed and set up the test database servers for Oracle 12c.
• Successfully implemented Oracle 12c Cloud control.
• Developed advanced PL/SQL Packages, Procedures, Triggers, Functions, Indexes and Collections to implement business logic using SQL Navigator.
• Used SED and AWK in Unix shell scripting to correct the data issues in the SQL-Loader data file.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object Types and Dynamic SQL.
• Upheld quality control and data validity for Java programs.
• Resolved application and connectivity problems in Java programs.
• Programmed in UNIX shell scripts to provide a user interface to Oracle Forms and Reports.
• Oracle Forms developed and deployed in all UNIX environment through Dev, Test and Prod in an Oracle Applications environment.
• Build proper test cases for QA team.
• Coordinated with different teams in designing and implementation of business process enhancement plans.
• Provided technical assistance for development and testing of functional design for new solutions.
• Used Informatica file watch events to pole the FTP sites.
• Extensively used SQL Loader and UTL FILE methods to load the fixed length, csv and pipe delimited flat files from Mainframe and DB2 into the Oracle database.
• Used UNIX Shell scripts (KORN) for Extracting and Parsing data from the files. FTP process is extensively used to send and receive the flat files.
• Involved in ETL code using PL/SQL to meet requirements for Extract, Transformation and Loading of data from source to target data structures.
• Extensively used ODI ETL tool to create data warehousing OLAP model.
• Experience in ODI designer, Topology, Operator and ODI tools.
• Maintained documentation for technical systems.
• Responsible for preparing as well as review of all documents.

Environment: Oracle 10g, 11g, 12c, SQL PLUS, PL/ SQL, SQL*Loader, TOAD, SQL Developer, Shell Scripts, UNIX, Pro*C, Windows XP, MS-Excel

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Developed advanced PL/SQL Packages, Procedures, Triggers, Functions, Indexes and Collections to implement business logic using SQL Navigator.
• Created database objects Tables, Views etc.
• Generated server side PL/SQL scripts for data manipulation and validation for remote instances.
• Involved in creating Unix Shell Scripting. Defragmentation of Tables, Partitioning, compressing and Indexes for improved performance and efficiency.
• Designed and Developed SSIS Packages.
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day. Used standard packages like UTL FILE, DBMS SQL and PL/SQL collections and used BULK binding involved in writing database procedures, packages and functions for front end module.
• Experience in Database Application Development, Query Optimization, Performance Tuning and DBA solutions and implementation experience in System Development Life Cycle.
• Used principles of Normalization to improve the performance.
• Utilized Oracle technical tools such as SQL Developer, TOAD, and Oracle Workflow to develop solutions to support the business and to enhance functionality based on business requirements.
• Involved in ETL code using PL/SQL to meet requirements for Extract, Transformation, Cleaning and Loading of data from source to target data structures.
• Filtered and Loaded data from different formats of data sources into database tables.
• Prepared and Validated QA, UAT and PROD Release scripts/Packages.
• Used SED and AWK in Unix shell scripting to correct the data issues in the SQL-Loader data file.
• Involved in the continuous enhancements and fixing of production problems.
• Worked closely with the Application Development teams to identify and implement continuous improvements and effective problem resolution strategies.
• Provided the Production and Technical support for the users.

Environment: Oracle 10g, 11g, 12c, SQL PLUS, PL/ SQL, SQL*Loader, TOAD, SQL Developer, Shell Scripts, UNIX, Pro*C, Windows XP, MS-Excel

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Designed and developed Packages, Procedures and Functions
• Interacting with users to gather Business requirements and Analyzing, Designing and Developing the Data Loading Process and Reporting systems.
• Involved in performance tuning of codes.
• Providing support during implementation.
• Oracle installation, configuration, management and support. (12c, 11g, 10g)
• Extensively wrote the PL/SQL and SQL programs and Designed and developed the views, materialized views, functions, procedures, packages, triggers and cursors.
• Created Cursors, Collections and database triggers for maintaining complex integrity constraints and implementing the complex business rules.
• Worked on Performance tuning using the Partitioning and indexing concepts (Local and Global indexes on partitioned tables).
• Build proper test cases for QA team.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object Types and Dynamic SQL.
• Process annual redeterminations for Medicaid clients that are associated with Family health plans.
• Processed 60 to 80 claims daily.
• Determined if a Claim is payable via regulations, plan benefits as well as policies and procedures.
• Involved in ETL code using PL/SQL to meet requirements for Extract, Transformation and Loading of data from source to target data structures.
• RAC configuration Oracle 9i/10g/11g/12c.
• Designed and Developed Oracle Forms and Reports using Forms 11g and Reports 11g, including Forms based on stored procedures.
• Involved in designing numerous Oracle Forms and Reports by interacting directly with End Users and Business Analysts.
• Developed Forms screens used by Oracle developer suite for Forms Procedures, Functions and Packages generate to end product of forms.
• Responsible for preparing as well as review of all documents.
• Extensively used SQL Loader, UTL FILE and External Table mechanisms to load legacy data, feed files data and data from various sources into the Oracle database tables.
• Developed Complex UNIX shell scripts and Autosys jobs for the scheduling and automation of the application jobs execution.
• Involved in tuning using EXPLAIN PLAN and used hints to tune the queries.
• Applied technical skills using SAS, Tableau and SQL in data collection, data analysis and reporting to procure data from data structures to report and provide solutions to client requests in a timely manner.
• Installed ODI. Set up the ODI connection with Oracle and Flat files.
• Created ODI packages, scenarios using interfaces, variables, procedures.
• Performance tuned the ODI interfaces.
• Used ODI commands like ODI file move, ODI fileappend, odifilecopy etc.
• Used Data Warehousing tools like OBIEE, ODI and JDeveloper.
• Developed mappings/sessions using Informatica powercenter 9.6 for data loading
• Worked closely with the Application Development teams to identify and implement continuous improvements and effective problem resolution strategies.

Environment: Oracle 10g, 11g, 12c, SQL PLUS, PL/ SQL, SQL*Loader, TOAD, SQL Developer, Shell Scripts, UNIX, Pro*C, Windows XP, MS-Excel