SUMMARY:

• 8+ years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
• Expertise in design and development of Data Conversions and Migrations using Interface tables and APIs from Legacy systems to Oracle Applications (EBS) 11i/R12 suite using PL/SQL, Oracle API and Oracle Open Interfaces
• Substantial development experience in creating Stored procedures, Functions, Packages, Triggers, Indexes, Views, UNIX Shell Scripts, SQL * Loader scripts.
• Oracle Application E - Business Suite System Administration activities like application user setup, defining responsibilities, values set, flex fields, lookups, registering menus, concurrent programs, and providing support to apps users for any technical issues.
• Expertise in Client-Server application development using Oracle … PL/SQL, SQL *PLUS, SQL Developer, TOAD and SQL*LOADER.

  • Good working experience in Exception handling, PL/SQL Tables, Record type, Ref Cursor and Dynamic SQL.

• Hands on experience on Oracle HRMS (Core HR) tables.
• 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.
• Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).
• Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
• Experience with Performance Tuning for Oracle RDBMS using Explain Plan.
• Experience in ETL techniques and Analysis and Reporting including hands on experience with the Reporting tools such as Tableau, OTBI.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.
• Hands-on involvement in business requirement, GAP analysis, process mapping, solution design, configuration, setups, work around, interfaces, user training.
• Excellent analytical and communication skills. Highly motivated and able to absorb new technologies quicker and interested to keep up to date in specialized areas.

TECHNICAL SKILLS:

BI/ETL Tools: Informatica Power center 9.0, 8.6/8.5/8.1/7.1/6.2, Oracle Data Integrator (ODI), DTS & Data stage

Databases & Related Technologies: Oracle 11g/10g/ MS Access, DB2 MS excel 2010, MS Share point, GIT, SVN, WinSCP, CA workstation, Putty

Operating Systems: Windows 8/7/XP/2003

MS: Visio, Erwin, Report Builder

Reporting Tools: Tableau, Power BI

Management tool: PL/SQL, C#, VB.NET, ASP.NET, MS ACCESS

Office Tools: Microsoft Office /

PROFESSIONAL EXPERIENCE:

Sr. ETL Developer

Confidential, Columbus, OH

Roles & Responsibilities:

• Conducted data analysis of the source feeds from various systems like NAPS, FPS, SA, HV and other system of records to bring in data related to Policy, customer, quotes, claims, billing etc.
• Design and build ETL logic by using Informatica Power center to pull data from the source feeds, apply necessary rules and transform the data for easy and quick reporting.
• Create source to target mapping documents by reviewing functional and non-functional requirements.
• Used GIT to move the code to higher environments and CA workstation to run ESP jobs.
• Used RTC to track story cards and HP quality center to track defects.
• Requirements clarification was done using RRC.
• Implement calculations on history data or migrate history from legacy systems.
• Performance tuning of database and ETL code to meet delivery SLA.
• Collaborate with ETL, Oracle Database, Release automation, scheduling administrators to accomplish project needs and ensure compatibility of system components.
• Worked on Power Center client tools to perform ETL to extract, transform and load data from Oracle, SQL Server, and flat files to HP exstream.
• Created various transformations such as aggregator, Update Strategy, Look Up, Joiner, Filter and Router Transformations. Created and Monitored Workflows using Workflow Manager and Workflow Monitor.
• Performance Tuning of Sessions and Mappings.
• Involved in Unit Testing & Integration testing of the mappings.
• Created Relational Connections, Migrated the Mappings from Dev to Test and Test to Production.
• Involved in writing shell scripts by connecting to Database to perform various database operations.
• Created and Configured Workflows, Worklets, and Sessions to transport the data to target tables using Informatica Workflow Manager.
• Used Informatica Developer tool to provide data quality and Metadata management solutions.

Environment: Informatica Power Center 9.6.1, Oracle SQL Developer, Flat Files, UNIX Shell Scripting, WinSCP, GIT, Putty, SVN, HP Quality Center, IBM RTC, RRC.

Sr. ETL Developer

Confidential

Roles & Responsibilities:

• Involved in analysis, database design, coding, and implementing database applications.
• Understand business requirements, design and document technical design for the business requirements.
• Involved in writing stored procedures, Creation/Dropping of tables, partitioning tables, indexes, sequences, synonyms for the business application development in TOAD.
• Involved in Designing packages dealing with different data sources (SQL Server, Flat Files) and loaded the data into target data sources by performing different kinds of transformations (For loop, bulk insert, Data flow, Data mining, FTP, XML tasks, etc.) using SQL Server Integration Services.
• Used .Net, C# for complex scenarios that cannot be handled with SSIS packages.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Deploying SSIS packages from various sources like bids, Management Studio, file systems etc.
• Scheduling jobs using Tidal Scheduler in Development, QA and PROD servers.
• Participating in all the phases of the project from Requirement analysis phase, development, QA support and production support.
• Involved in Unit testing and Integration System testing.
• Monitored performance and optimized scripts for maximum efficiency.

Environment: Toad for oracle 12c, visual studio, SSIS 2012, 2008, .NET, Tidal job scheduler, MS Access

Sr. ETL Developer

Confidential

Roles & Responsibilities:

• Involved in analysis, database design, coding, and implementing.
• Understand business requirements, design and document technical design for the business requirements.
• Loaded data into multiple tables using SQL Loader.
• Used extensively PL/SQL, to develop packages, stored procedure, functions and database triggers.
• Tuned SQL queries to improve performance.
• Involved in migrating the data from multiple databases to Postgres database system.
• Redesigned the database to normalize key parts of the system and to also convert the database from MS Access to Postgres to handle growing transaction volumes.
• Used Microsoft Visio for Dataflow and Entity relationship diagram.
• Developed procedures, functions for different forms.
• Used different joins, sub-query and nested query in SQL query, for reports.
• Extensively used PL/SQL in reports to perform calculation and to get desired output.
• Developed single HTML page to serve as a centralized menu for the web application, and then broadcast URL.
• Developed automated notification of Emails, using Unix shell script, to the users in case of failure in the process from time to time.
• Custom developed PL/SQL ETL procedures used throughout. Oracle DBA on same effort.
• Implemented the technical and functional aspects of DEPOT project.
• Interacted with end user for problems faced and providing necessary technical support by fixing the bugs.
• Testing, Integration System test, Implementation (test with users) and documented the entire project.

Environment: Oracle 11g, SQL*PLUS, SQL* LOADER, PL/SQL, Reports 6i, HTML, Java, Unix Shell scripts, Windows NT

Sr. ETL Developer

Confidential

Roles & Responsibilities:

• Developed complex programs in T-SQL\PL-SQL, writing Stored Procedures, Triggers and Queries with best execution plan.
• Maintenance of existing Visual Basics and C# applications, which are used to generate data in a specific format.
• Supervise .NET, C# applications, dashboards and reports via SQL database.
• Developed interactive pages of the application using ASP.NET, Entity Framework, Web Forms pages with C# for the code behind modules and agile methodologies for .Net Framework.
• System design and development, Rapid Application Development (RAD) using MVC and MVP patterns with design patterns, code review, release management.
• Involved in development of MVC patterns for client server interaction.
• Integrated legacy systems across SQL Server and Oracle platforms using integration tools SSIS, Alteryx.
• Created SSIS Packages with time scheduling and various transformations to achieve specific formatted flat files such as pipe delimited, CSV, tab delimited.
• Developed mappings to extract data from SQL Server, Oracle, Teradata, Flat files and load into Data Mart using Informatica Power Center.
• Used Informatica Designer in Informatica 9.0 to create complex mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Expressions and Aggregator transformations to pipeline data to Data Mart.
• Used Informatica Workflow Manager to create, schedule, execute and monitor sessions, work-lets and workflows accessed information using DB2 and AS400.
• Application remains responsive to the user via multi-threading to handle long-running calls to Active Directory, SSIS packages and SQL Server 2008 stored procedures.
• Created internal migration tools and user interfaces.
• Implement and maintain integration processes that adhere to Roche CSV, Application Specific Development Guidelines, Naming Conventions, Roche Best Practices and Security Policies.
• Responsible for supporting/developing/deploying integrated solutions aimed at modernizing, consolidating and coordinating the independently designed applications within and across enterprises.
• Wrote Perl Shell Scripts for scheduling jobs in Perl, regular backups, instance start/shutdown and migrating data into tables.

Environment: Microsoft SQL Server 2008/2012, Visual Studio 2008/2012, Transact-SQL, SQL Server Integration services(SSIS), Informatica Power center 9.0, 8.6/8.5/8.1, C#, .NET, Alteryx, DTS, VBScript, MVC, Microsoft Visio 2010, MS Excel, Perl, TOAD, Oracle 10g Enterprise Edition, OBIEE.

Sr. ETL Developer

Confidential

Roles & Responsibilities:

• Analysis of Source, Requirements, existing OLTP system and Identification of required dimensions and facts from the Database.
• Identified business rules for data migration and Perform data administration through data models and metadata.
• Designed new database tables to meet business information needs. Designed Mapping document, which is a guideline to ETL Coding.
• Responsible for Documentation for ETL development process, Installation and troubleshooting guide.
• Worked with Source Analyzer, warehouse designer, Mapping Designer, and Reusable Transformations.
• Using Informatica Designer designed Mappings that populated the Data from Source to staging area to Sales & Marketing Datamart.
• Handled slowly changing dimensions of Type 1 Type 2 to populate current and historical data to Dimensions tables in the data warehouse.
• Developed Mapplets using corresponding Sources, Targets and Transformations.
• Executed sessions, sequential and concurrent batches for proper execution of mappings and sent e-mail using server manager.
• Analyzed, PL/SQL code as a part of ETL Process.
• Designed Informatica transformations for loading data from various sources like flat files/ OCI/ODBC sources.
• Worked closely with Software Developers to isolate, track, and troubleshoot defects
• Extensively worked on UNIX and shell scripts. Developed UNIX shell scripts to run the pmcmd functionality to start.

Environment: Informatica Power Center 8.6/8.1, Oracle 9i, Flat Files, UNIX Shell Scripting, HP-AIX, TOAD, Business Objects 10/XI.

ETL Developer

Confidential

Roles & Responsibilities:

• Worked with end users in collecting Business Requirements.
• Created database objects like Views to handle secured data and giving grant to views for other schema to hide the information.
• Developed Reports for storing of monthly sales and salaries information.
• Used FORALL and BULK COLLECT to load large amount of data to database and retrieve data from database in large amounts without effecting the performance.
• Used PLSQL tables and records for payroll generation process. Prepared Daily Reports by collecting information from those departments.
• Automated execution processes using UNIX Shell Scripts.
• Used the FTP Commands efficiently to migrate the files and logs have been created successfully in proper directories on completion of the transfer process.
• Involved in analysis, design and coding of Oracle processes in PL/SQL to build packages.
• Developed Packages to validate raw data from Flat Files and Insert into Tables.
• Developed Back End Interfaces using PLSQL Procedures, Cursors and Collections.
• Used TOAD to modify existing Scripts to improve performance.
• Developed new functionality as per change requests by the users.
• Wrote test plans and performed Unit Testing and Integrated Testing.
• Created PLSQL Procedures to validate the data.
• Loaded data from legacy systems which is an ETL operation using SQL* Loader.
• Used Import/Export Utilities to backup daily jobs.
• Created DB Links to connect to other databases.
• Coordinated with DBA in improving database performance.
• Used various Optimizer Hints to speed up the SQL Queries.
• Used ERWIN to create logical and physical database models.

Environment: Oracle 10g, SQL, PLSQL, SQL*Developer, Java Scripts, TOAD, windows XP, UNIX Shell Scripting, Forms and Reports (10g), SQL*Loader, ETL, MS Visio.

ETL Developer

Confidential

Roles & Responsibilities:

• Involved in testing, development, maintenance of system.
• Used Batch Scripts to loop from one database to other to perform system wide operations.
• Worked in co-ordination with DBA in creating Tables, Views and Sequences.
• Created Triggers for audit data validation.
• Used TOAD to improve performance by modifying Scripts.
• Created Procedures for writing data to files.
• Customized existing code as per user requirements.
• Implemented Database Backup Management Policy by automating various kinds of backups using UNIX Shell Scripts.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Created Indexes and partitioned Templates to improve performance of queries.
• Involved in fixing bugs within Packages and Stored Procedures.
• Developed single form to run all Reports as a central point.
• Generated new Reports using Reports 6iand Report Templates.
• Developed graphical interface of Adobe Designer enables users to quickly design Forms, maintain Form Templates.
• Involved in created end user manual and user training.

Environment: Oracle9i/8i, Adobe Designer, TOAD, SQL*loader, UNIX.

ETL Developer

Confidential

Roles & Responsibilities:

• Worked along with DBA and Business Analyst to gather requirements, testing, business analysis.
• Worked on Data warehouse using Fact Tables, Dimension Tables, Star Schema Modeling and Snowflake Schema Modeling.
• Involved in creation of database objects and design of database.
• Developed SQL Queries and conducted SQL Query Tuning to improve performance and Created indexes for stored procedure to improve performance of queries.
• Developed user interface using Forms in Oracle 10g.
• Loaded data into database using SQL Loader and External tables.
• Developed Cursors, REFCURSORS to accommodate user needs.
• Developed Oracle HTML Procedures and Functions using integration of PL/SQL.
• Worked on Database Migration and Database Upgradation from one system to other.
• Improved the performance of system by debugging the errors and handling the exceptions using Exception Handling which displays the error message.
• Created new users and worked on setting up privileges to them to protect data.
• Used Triggers for quickly retrieving row and performing Validation.
• Involved in Reverse Engineering of application using ERWIN.
• Created various custom Reports like Credit Card Transaction Report, Active Invoice Register Report and others using Reports Builder 6i.
• Design, develop, implement, and assist and in validating ETL processes.
• Did Unit Testing and Development Testing at ETL level in my mappings.
• Developed end user and system level documentation.
• Created UNIX Shell Scripts to automate execution process.
• Used Erwin to transform data requirements to data models.
• Developed ETL programming using Informatica to implement business requirements.

Environment: Oracle 10g/9i, SQL, PLSQL, SQL*Loader, TOAD, Oracle Forms Builder6i, Reports Builder 6ig, Erwin.