SUMMARY

• Having 10 years of overall experience in Oracle PL/SQL, MS T - SQL, NoSQL, PostgreSQL, MySQL, Informatica, SSIS, SSRS, Java, Data Modeling, Performance tuning, Data warehouse and ETL concepts and in UNIX shell scripting.
• Worked in different phases of projects like Development, Production Support, Re-designing and Data Migration.
• Good knowledge on reporting tools like SAP BO, SSRS and Tableau
• Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Expertise in Client-Server application development using Oracle 12c/11g/10g/9i, PL/SQL, SQL *PLUS, PLSQL developer, SQL Server, TOAD and SQL*LOADER.
• Experience with Data flow diagrams, Data dictionary, Database normalization techniques, Entity relation modeling and data modeling techniques.
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces
• Good knowledge on logical and physical Data Modeling using normalizing Techniques and Erwin tool.
• Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
• Loaded Data into Oracle Tables using SQL Loader.
• Experience with Oracle Supplied Packages such as DBMS SQL, DBMS JOB and UTL FILE.
• Worked extensively on Ref Cursor, External Tables and Collections.
• Expertise in Collections and Exception handling.
• Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).
• Developed Complex database objects like Stored Procedures, Functions, Packages, Pipelined functions, With-clause SQL’s and Triggers using SQL and PL/SQL.
• Experience with writing API’s to access data from web services.
• Developed T-SQL procedures and functions for database management and to satisfy business needs.
• Good in T-SQL (create, read, update, delete), scalar functions and table-valued functions.
• Good in index optimization techniques, transactions and rollback, MERGE, using TRY/CATCH and in execution plans.
• Developed materialized views for data replication in distributed environments.
• Partitioned large Tables using range partition technique and also implemented Soft-partition method in migrating data.
• Worked with migrating 600 millions of records from legacy system to oracle database.
• Good knowledge of key Oracle performance tuning related features such as with clause queries, Pipeline Functions, Bulk bind, Query Optimizer, Explain Plans, Gather Stats, HINTS and Indexes.
• Involved in analyzing AWR reports.
• Experience in resolving deadlocks.
• Experience in implementing parallelism
• Expert in creating test cases and in debugging PLSQL/ETL code.
• Experience in creating, monitoring and analyzing cron jobs and oracle scheduled jobs.
• Involved in creation of migration scripts, UNIX shell scripts.
• Involved in building mappings documents by understanding the business requirements
• Created multiple mappings, mapplets, sessions and workflows to extract data for multiple outbounds.
• Worked on multiple transformations such as Source Qualifier, Aggregator, Filter, Router, Sequence Generator, look up, Rank, Joiner, Expression, Stored Procedure, SQL and update strategy to meet business logic in the mappings
• Created Mapplets to avoid redundancy of code whenever needed
• Performance tuning is performed at the Mapping level as well as the Database level to increase the data throughput.
• Involved in converting database procedures to Informatica mappings as per the business needs when new sources keep added.
• Evaluate business requirements to come up with Informatica mapping design that adheres to Informatica standards.
• Followed Informatica best practices, such as creating shared objects in shared for reusability and standard naming convention of ETL objects, design complex Informatica transformations, mapplets, mappings, reusable sessions, worklets and workflows.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task, Multicast, Merge, Conditional Split, slowly changing dimension, Union All, Sort and Send Mail task etc.
• Worked extensively on JAVA and Web service consumer transformations.
• Develop cross validation rules to ensure mapping accuracy.
• Provide production support of existing ETL processes.
• Converted Python data loading scripts to Informatica mappings.
• Worked with business analysts and data analysts to support the business needs.
• Worked on defects fixes, production support and job monitoring activities.
• Involved in DBA activities like Installation Oracle 11g, Backups, creating users, resetting passwords, table space changes, creating DB links and Gather Stats.
• Worked in different development life cycle such as Waterfall and Agile work environment.
• Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Strong communication, interpersonal, analytical & team building skills with proficiency at grasping new concepts quickly and utilizing the same in a productive manner.
• Core areas of skill are design and development using Oracle SQL, Pl/SQL, Informatica, SQL Server, Performance Tuning, UNIX shell scripting and Python.

TECHNICAL SKILLS

ETL and BI: Informatica power center 10.2.0/9.1.0/8.6.1 , SSIS 14.0, SSRS 13.0, SAP BI, SAP BO 4.0 and Tableau 9.1

LANGUAGES: SQL, PL/SQL, MS T-SQL, Java and UNIX Shell & Python Scripting

RDBMS: Oracle 12c, 11g,10g,9i, SQL Server 2016, SQL Server 2012, PostgreSQL, MySQL and MongoDB

OPERATING SYSTEM: Windows, Linux

TOOLS: Sql * plus, pl/sql developer, MySQL Workbench, informatica power center, Shell SQL, Toad, SQL Server Management Studio, Autosys, Eclipse, JIRA, SFDC, Winscp, Filezilla, Putty, Citrix, BMC Remedy and Solution Builder.

Data Modeling: Erwin 8.2

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles, CA

Sr. PLSQL/ETL Developer

Responsibilities:

• Involved in requirements gathering and design phases of the projects.
• Wrote multiple complex packages, procedures, functions and triggers as part of processing, validating, submitting encounters to State and federal.
• Developed T-SQL procedures for database management and to satisfy business needs.
• Involved in member enrollment and disenrollment and eligibility validation process.
• Migrated around 500 million of encounter’s and member data without any performance issues from legacy systems to new applications.
• Involved in fine tuning multiple outbound process using oracle tuning approaches (AWR Reports, gather stats, Index’s, Hints, explain plan and profiler).
• Used advanced Bulk techniques (FOR ALL, BULK COLLECT) to improve performance
• Experience with Oracle Supplied Packages such as DBMS SQL, DBMS JOB and UTL FILE.
• Worked extensively on Ref Cursor, External Tables and Collections.
• Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
• Loaded Data into Oracle Tables using SQL Loader.
• Expertise in Collections and Exception handling.
• Good at using V$ tables to monitor the DB activities/performance.
• Involved in building mappings documents by understanding the business requirements
• Created multiple mappings, mapplets, sessions and workflows to extract data for multiple outbound.
• Worked on multiple transformations such as Source Qualifier, Aggregator, Filter, Router, Sequence Generator, look up, Rank, Joiner, Expression, Stored Procedure, SQL and update strategy to meet business logic in the mappings
• Worked extensively on JAVA and Web service consumer transformations.
• Worked with JSON, XML, WSDL file formats and SoapUI tool to test API’s.
• Created Mapplets to avoid redundancy of code whenever needed
• Performance tuning is performed at the Mapping level as well as the Database level to increase the data throughput.
• Involved in converting database procedures to Informatica mappings as per the business needs when new sources keep added.
• Evaluate business requirements to come up with Informatica mapping design that adheres to Informatica standards.
• Followed Informatica best practices, such as creating shared objects in shared for reusability and standard naming convention of ETL objects, design complex Informatica transformations, mapplets, mappings, reusable sessions, worklets and workflows.
• Extracted data connected to multiple databases PostgreSQL, MongoDB, Oracle, SQL Server, MySQL, SFDC, Web services, text files and more using ETL tools.
• Converted Python data loading scripts to Informatica mappings.
• Worked with business analysts and data analysts to support the business needs.
• Worked on defects fixes, production support and job monitoring activities.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task, Multicast, Merge, Conditional Split, slowly changing dimension, Union All, Sort and Send Mail task etc.
• Develop cross validation rules to ensure mapping accuracy.
• Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements.
• Wrote shell scripts to automate the loading, balancing and extraction process.
• Extensively worked in debugging PL/SQL and ETL Objects.

Environment: Informatica 10.2.0, SSIS 14.0, SSRS 13.0, Oracle 12c, SQL Server 2016, Java and UNIX

Confidential, Stillwater, MN

Sr. Oracle/ETL Developer

Responsibilities:

• Involved in gathering requirements and preparing design and technical documents.
• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements.
• Executing ftp, telnet for remote access between UNIX systems.
• Wrote shell scripts to automate the loading, balancing and extraction process.
• Part of installation, configured, and maintained development and test database environments.
• Performed database modeling.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Involved in tuning application (AWR Reports, gather stats, Index’s, Hints, explain plan and profiler) and automating the process.
• Tuned complex and expensive queries by applying optimizer Hints.
• Developed Database Triggers for audit and validation purpose.
• Used pipelined functions for faster data accessibility.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Used advanced Bulk techniques (FOR ALL, BULK COLLECT) to improve performance
• Extensively used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Involved in creating database links.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Coordinate with BA team and develop all ETL processes.
• Allocating and reviewing the work of offshore.
• Responsible for Extracting, Transforming and Loading data from Oracle, SQL Server, Teradata, XML files and Flat files.
• Extensively wrote user defined SQL coding for overriding generated SQL query.
• Worked extensively on mappings and different types of transformations.
• Converted PL/SQL procedures to Informatica mappings.
• Extensively worked in debugging PL/SQL & ETL Objects.
• Creating/Building and Scheduling workflow and Sessions using the Workflow manager.
• Involved in unit testing.
• Involved in reviewing the Mappings.
• Monitor all production issues and inquiries and provide efficient resolution for same.
• Performed the tasks of validating, execution and scheduling the sessions.
• Involved in creating SQL Server tables, index and writing SQL queries.
• Involved in writing SQL Server stored procedures.

Environment: Informatica 9.1, Oracle 11g, SQL Server 2008, Teradata, Tableau, JIRA, iQ, CPQ, BAAN and UNIX

Confidential, IL

Sr. Oracle Developer

Responsibilities:

• Review the business requirement, functional requirement document for various modules so as to have good understanding of the application and capture it into a SSA (Source System Analysis) document.
• Gathering the Requirements from Business Users
• Preparing the Technical Design based on the requirements.
• Allocating and reviewing offshore work.
• Loading data from different sources (oracle, xml files, csv files and flat files) to data warehouse application.
• Used analytical functions like Rank, Row Number, Dense Rank, Listagg, First, Last etc to compute an aggregate value based on a group of rows.
• Used EXPLAIN PLAN, DBMS STATS, Analyze, SQL TRACE to tune complex SQL statements and PLSQL objects.
• Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.
• Created and modified SQL*Plus, PL/SQL and SQL*Loader scripts for data conversions.
• Created Triggers and packages for audit purpose.
• Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.
• Wrote Shell Scripts for Data loading and DDL Scripts
• Monitoring and executing Informatica jobs.
• Involved in creating BO Universe and reports.
• Involved in writing Plsql procedures, Sql queries and UNIX shell scripts.
• Involved in tuning application (AWR Reports, Gather stats, Index’s, Hints, explain plan and profiler) and automating the process.
• Developing procedures, functions and packages and creating tables, views, indexes and pipelined functions.
• Involved in schema comparisons.
• Developing the code according to the design and do the Unit Testing.
• Gathering the UAT Results from the customer
• Involved in writing test case and unit testing.
• Involved in debugging code.
• Involved in smoke testing and analyzing the issues among the applications.

Environment: Informatica, Oracle 11g, JDA, Autosys, SAP BO, Windows and Linux.