Sridhara Gopalappa

Oracle PLSQL/ETLDeveloper

Ph: 651-***-****

ac7bx8@r.postjobfree.com

PROFESSIONAL SUMMARY

Over 10+ years of experience in Analysis, design, development and testing of various business applications using Oracle SQL,PL/SQL,UNIX shell scripting technical production support and 5 Years of experience in Informatica Power Center 9.x. Experience EDI,HIPAA,B2B knowledge in Health care Domain .

Hands on experience with HIPAA X12 EDI transaction formats including: 837, 834 Familiarity with appropriate handling of PHI data.

Hands on experience with 4010 and 5010 transaction formats for 837.

Extensive working experience in writing various database objects like functions, stored procedures, cursors, packages, triggers and creating tables, views and materialized views using Oracle SQL and PL/SQL.

Extensive knowledge of using DBMS Oracle supplied package like UTL_FILE, DBMS_SCHEDULER, DBMS_OUTPUT,DBMS_STATS etc.

Experience in creating the constraints, Indexes, sequences.

Expertise in creating summarized tables and materialized views for efficient reporting and improved performance

Proficient in Oracle tools and utilities such as TOAD, PL/SQL Developer, SQL Developer.

Experience using SQL* Loader, writing PL/SQL procedures to facilitate data import/export from staging tables to production tables.

Experience in creating UNIX shell script, filter the data using the script and scheduling the job using cron tab.

Experience in performance tuning EXPLAIN PLAN, SQL TRACE, HINTS,TKPROF and Partitioning of Tables.

Extensively used the advanced features of PL/SQL like collection types and Dynamic SQL, BULK Collect, FORALL.

Experience in writing the technical specification for the development team to work.

Performed unit testing and supported integration testing and end user testing. Extensively worked on production issues with effective defect management. Involved in logical and physical database design.

Over 4 years of ETL Data warehousing experience using Informatica Power Center 10.x (Source Analyzer, Mapping Designer, Mapplet Designer, Transformations Designer, Warehouse Designer, Repository Manager, and Workflow Manager and workflow Monitor).

Worked extensively with Data migration, Data Cleansing, Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse.

Worked with different data sources non-relational Databases such as Flat files, XML files, and other relational sources such as Oracle, SQL Server.

Extensively used transformations like router, aggregator, lookup, source qualifier, joiner, expression, aggregator and sequence generator transformations in extracting data in compliance with the business logic developed.

Extensively worked with Slowly Changing Dimensions Type1, Type2, and Type3 for Data Loads.

CERTIFICATION

Oracle Certified Associate.

ITIL® Foundation v.3

TECHNICAL SKILLS

Databases: Oracle 8i, 9i, 10g, 11g, SQL Server 2000/2005, Microsoft Access.

Operating System: Windows NT/2000/2003/XP, Linux, UNIX.

Programming Languages: SQL,PL/SQL, ShellScripting,VB,HTML,XML.

Version Control Tools: PVCS,Clear Case,SVCN.

ETL Tool: Informatica Power Center 10.x. B2B.

Tools/GUI/UTILITIES: TOAD, SQL Developer, SQL * Loader, SQL navigator,VI Editor, FTP, SFTP,PGP,Connect Direct,Explain Plan, Microsoft Excel

Scheduling Tool Autosys,Tidal.

EDUCATION

Bachelor of Engineering in Electronics and Communication(Visvesvaraya Technological University)

PROJECT EXPERIENCE

Lincoln Financial Group Omaha, NE Dec 2016 –Till Date

(Group Protection)

Sr. Oracle PLSQL/ETL Developer

Responsibilities:

Configure New partners related to Dental, Vision and DHMO for enrolments using B2B.

Analyzing new Requirement and System to configure for custom flat files, EDI, user applications, and focus on healthcare encounters and HIPAA X12 transactions: 837, 834.

Worked on the new requirement to change/Add new functionality to the existing system.

Created PL/SQL Packages, Views, Functions, Procedures, Indexes, Primary key, foreign key and Triggers according to the requirements.

Created Dynamic SQL statements in procedures.

Developing, Modifying, Debugging SQL Queries according to the requirement

Involved in creating the database objects like Table, cursors,Indexes,Sequences and Materialized views etc.

Involved in complex data extracts, applications, and ad-hoc queries as requested by internal and external customers using SQL, Informatica toolset.

Maintained the production Business Intelligence products and solutions, including resolving production issues and responding quickly to priority problems.

Automated the manual jobs using the scheduling tool Autosys.

Created different transformations such as Source Qualifier, Joiner, Expression, Aggregator, Rank, Lookups, Filters, Stored Procedures, Update Strategy and Sequence Generator.

Involved in creating the new jobs in Job scheduler Autosys.

J.D. Power & Associates, Los Angeles, CA Oct 2015-Dec 2016

Sr. Oracle PLSQL/ETL Developer

Responsibilities:

Analyzing the Requirement and System to get the full Technical details to accomplish Business requirement

Created PL/SQL Views, Functions, Procedures and Indexes, Primary key, foreign key and Triggers according to the requirements.

Created Dynamic SQL statements in procedures.

Developing, Modifying, Debugging SQL Queries according to the requirement

Involved in creating the database objects like Table, cursors, Indexes, Sequences, Materialized views etc.

Involved in Creating the External Tables, Indexed Organized Tables.

Created file transfer script using ftp and scheduled the cron jobs in UNIX environment.

Created the portioned table for better performance of the SQL query.

Tuned SQL queries and performed refinement of the database using tools like EXPLAIN PLAN, SQL*TRACE to significantly improve the system response time and efficiency.

Extensively Used Oracle HINTS in the procedure.

Created the partition tables in oracle database for better performance and easy maintenance of the db objects.

Running the daily ETL Mappings to pull the data from different source system and load in to the staging tables using InformaticaPower Center 9.x Workflow manager.

Extensively used Source Qualifier Transformation to filter data at Source level rather than at Transformation level.

Created and monitored workflows and task using Informatica Power Center Workflow Manager.

Involved in creating the new jobs in Job scheduler Tidal (CISCO).

Technical Environment: Oracle 11g, Informatica 10.x, Toad Developer, Windows NT, UNIX, Tidal.

Alcatel-Lucent, Naperville,IL Dec 2006-May 2014

Sr. Oracle PL/SQL Developer

Responsibilities:

Analyzing the Requirement and System to get the full Technical details to accomplish Business requirement

Writing Technical Design Document and share the knowledge with the Team members for Development

Created PL/SQL Packages, Views, Functions, Procedures,Indexes, Primary key, foreign key and Triggers according to the requirements.

Created Dynamic SQL statements in procedures.

Developing, Modifying, Debugging SQL Queries according to the requirement

Involved in creating the database objects like Table,cursors,Indexes,Sequences and Materialized views etc.

Involved in Creating the physical data model for OLTP system.

Created file transfer script using ftp and scheduled the cron jobs in UNIX environment.

Created tables and macros in MS Access database.

Wrote Unix Shell Scripts to validate and load data files (CSV delimited, Tab delimited) into database using SQL*Loader and to automate the processes using cron tab.

Created tables and macros in MS Access database and loaded the data into oracle tables.

Handled errors using system defined exceptions and user defined exceptions like INVALID_NUMBER, NO_DATA_FOUND.

Created the portioned table for better performance of the SQL query.

Tuned SQL queries and performed refinement of the database using tools like EXPLAIN PLAN, SQL*TRACE to significantly improve the system response time and efficiency.

Migrated the Interfaces from FTP to SFTP.

Extensively used the advanced features of PL/SQL like collection types and Dynamic SQL,BULK Collect.

Created shell script for fetching and sending the file to remote system and added the shell script into cron tab.

Analyzing and resolving Defects raised by UAT and the users. Interacting with UAT Team and the Users to get more details of defect and clarifying the questions.

Created different parameter files and changed Session parameters, mapping parameters, and variables at run time.

Created different transformations such as Source Qualifier, Joiner, Expression, Aggregator, Rank, Lookups, Filters, Stored Procedures, Update Strategy and Sequence Generator.

Used Debugger to test the data flow and fix the mappings.

Running the daily ETL Mappings to pull the data from different source system and load in to the staging tables using InformaticaPower Center 9.x Workflow manager.

Created and monitored workflows and task using Informatica Power Center Workflow.

Technical Environment: Oracle 9i, 10g, Concur, Informatica 9.x,MS Access, Toad, Windows, VBScript, Shell Script

Contact this candidate