We provide IT Staff Augmentation Services!

Sr. Etl Lead Developer Resume

Richardson, TX

PROFESSIONAL SYNOPSIS:

  • Oracle PL/SQL Developer with 8+ years of programming experience with emphasis on Analysis, Design, Development, Testing, Implementation and Management of projects using Oracle (SQL, PL/SQL)
  • Solid experience in translating business requirements into creation of Database Objects.
  • Extensive experience in writing Simple and Complex SQLs, PL/SQL Functions and Procedures, Packages and creation of Oracle Objects - Tables, Materialized views, Triggers, Synonyms, User Defined Data Types, Nested Tables and Collections.
  • Expertise in Client-Server application development using Oracle 12c/11 g/ 10g/9i, PL/SQL, SQL *PLUS, TOAD, SQL Developer and SQL*LOADER.
  • 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.
  • Developed Informatica mappings for dimensions and facts including junk dimensions, fact less facts.
  • Experience in designing and development of Oracle Forms and Reports/Crystal reports.
  • Good knowledge in front end development using Oracle Forms/Reports6i/9i/10g.
  • Experience in developing forms based on views, tables and procedures in tabular and form layouts.
  • Expertise in performance tuning of the mappings, ETL Environments, procedures, queries and processes.
  • Experience in Informatica Power center 10.1.0,9.x, 8.x, 7.x.
  • Very good understanding of Partition, Indexing and Optimization Goals of Sybase 15x.
  • Good Work experience of Embedded SQL and C Sybase Open servers and remote Procedures
  • Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modelling and design techniques.
  • Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, and Analytical functions, Materialized Views, Query Re-Write and Transportable tablespaces .
  • Experience in advanced PL/SQL concepts like Bulk Collect and forall.
  • Expertise in Dynamic SQL, Records, Arrays and Exception Handling.
  • Highly skilled in Performance tuning - analysing query plans and query tuning using the tools such as EXPLAIN PLAN and use hints wherever required.
  • Expertise in working with built-in packages like DBMS LOB, DBMS SQL, DBMS S C HEDULER, DBMS DDL, UTL FILE.
  • Comprehensive hands on in AOL, SYSADMIN, UNIX and Shell scripting.
  • Experience in writing Technical design documents and developing unit test documents.
  • Experience with features such as Sybase Partitioning and Replication.
  • Hands on experience working in Oracle apps Financials.
  • Experience in both 11i and R12 environments of Oracle Apps.
  • Comprehensive Hands on in Oracle RICE components viz. Reports, Interface, Conversions and Extension components.
  • Strong performance tuning skills on Sybase Replication.
  • Good knowledge about SDLC, AIM methodology, ITIL process, Support tickets and resolution process (SLAs).
  • Served as the key point of contact/Liaison between onsite and offshore and coordinated and followed up with the offshore team to accomplish the milestones as per the project timeline.
  • An effective communicator with excellent analytical, team building and coordination skills.

TECHNICAL EXPERTISE:

Database: Oracle 9i/10g/11g, Sybase 11x to 15x

ERP: Oracle Apps R12 EBS and 11i (INV, PO, OM, AR, AP & GL).

RDBMS: Oracle 9i/10g/11g,12c (SQL,PL/SQL, Stored Procedures, Triggers)

Reporting Tools: Oracle Developer suite, Oracle BI Publisher, XML Publisher.

Languages: SQL & PL/SQL, XML, HTML, UNIX, D2K, Java programming and C.

Front end Tool: Reports 6i, 10g & Forms 6i, 10g.

Tools: TOAD, FTP, SQL*loader, XML Publisher, SQL Developer, Workflow builder.

Operating Systems: Windows 2000/XP & UNIX.

Domains: Healthcare, Tele communication, Finance, Manufacturing, Retail

ETL Tools: Informatica 9.5.1, Datastage 11.5

PROFESSIONAL EXPERIENCE:

Confidential, Richardson, TX

Sr. ETL Lead Developer

Environment: Informatica Power Center 10.1.0/9.5.1 (Source Analyzer, Data Warehousing Designer, Debugger, Mapping Designer, Mapplet, Transformations), PL/SQL, Oracle Reports, Oracle forms personalization, Oracle database 12c, 11g, SQL*Plus, Oracle Applications R12, SQL Developer.

Responsibilities:

  • Involved in SDLC gathering requirements from end users. Developed views to facilitate easy interface implementation and enforce security on critical customer information.
  • Participated in system analysis and data modelling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages. Created programming code using advanced concepts of Records, Collections and Dynamic SQL.
  • Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
  • Wrote Unix Shell Scripts to process the files on a daily basis like renaming the file, extracting data from the file, unzipping the file and removing the junk characters from the file before loading them into the base tables.
  • Developed Informatica mappings for TYPE 1, 2 Slowly Changing Dimensions employee dimension.
  • Documented Mappings, Transformations and Informatica sessions.
  • Worked with production team to resolve data issues in Production database of OLAP and OLTP systems.
  • Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
  • Tuned the performance of the informatica workflow to increase the performance.
  • Created indexes on the tables for faster retrieval of the data to enhance database performance.
  • Used Informatica ServiceNow connector for complex data integrations.
  • Designed and developed various custom packages triggers and forms.
  • Responsible for data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
  • Developed and modified a number of Forms and for various modules. Also responsible for following up bugs reported by various users and suggesting possible patches to be applied.
  • Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
  • Involved in data migration from Production to test and created test data for analysing problems, providing solutions.

Confidential, Miami, FL

Sr ETL Developer

Environment: Informatica Power Center 9.6, Informatica IDQ, Oracle Applications R12, RDBMS 11.1.0.7.0 , PL/SQL, XML/BI Publisher Reports, Oracle Forms and Reports, Procure to Pay (P2P) lifecycle design, Oracle CRM

Responsibilities:

  • Developed Advanced PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic using SQLNavigator. Generated server-side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
  • Used principles of Normalization to improve the performance. Involved in ETL code using PL/SQL in order to meet requirements for Extract, Transformation, Cleansing and Loading of data from Source to target data structures.
  • Involved in creating UNIX shell Scripting. Defragmentation of tables, partitioning, compressing and indexes for improved performance and efficiency. Involved in table redesigning with implementation of Partitions Table and Partition Indexes to make Database Faster and easier to maintain.
  • Forms personalization: Developed various customizations in different interfaces using Oracle Forms.
  • Designed Informatica Mappings and Workflows to be re-startable after a failure.
  • Experience in Database Application Development, Query Optimization, Performance Tuning and DBA solutions and implementation experience in the complete System Development Life Cycle.
  • Worked on SQL*Loader to load data from flat files obtained from various facilities every day. Encapsulated error handling and use of autonomous transactions for logging. Used UTL FILE for exporting data and UTL MAIL to generate E-mails. Extensively used PL/SQL features like collections, nested tables, Varrays and Bulk collect for high performance of stored procedures.
  • Optimized the SQLs and Informatica mappings which handled millions of records.
  • Worked on set up of Web ADI for Journal Upload process, mass allocation rule, Cross validation rule and Security rule.
  • Worked with Informatica Data Quality (IDQ 8.6.1) for data quality measurement.
  • Optimized the SQLs and Informatica mappings which handled millions of records.
  • Interacting with the Business Users for issues fixes in Tickets and Business processes.
  • Addressing & resolving the high priority application support issues and devising permanent solutions for the same and also preparing RCA (Root cause analysis) for the same.
  • Served as a Technical lead, guided the team members in incident resolutions and independently carrying out the critical activities.
  • Engaged in month end maintenance activities of Confidential applications.
  • Point of contact for both Onsite and Offshore teams, coordinated with both the teams to accomplish the goals within the scheduled time.

Confidential, Salt Lake City, Utah

Oracle Applications PL/SQL developer

Environment: Oracle Applications R12, RDBMS 11.1.0.7.0 , PL/SQL, XML/BI Publisher Reports, Oracle Reports, Procure to Pay (P2P) Implementation

Responsibilities:

  • Involved in the full development cycle of Planning, Analysis, Design, Development, Testing and Implementation.
  • Gather, manage and document functional requirements for technical customization including workflows and scripting.
  • Identified the business requirements which need to be handled by the customizations and did the necessary analysis.
  • Developed Functional specifications for custom enhancements, Co-ordinated with all the teams, tested the components and got approval for deployment in production.
  • Facilitated Knowledge Transfer and business engagement sessions for Quarterly Releases.
  • Developed and modified a number of Forms and for various modules. Also responsible for following up bugs reported by various users and suggesting possible patches to be applied.
  • Wrote Shell Scripts for Data loading and DDL Scripts.
  • Worked in Production Support Environment as well as QA/TEST environments for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc.
  • Wrote conversion scripts using SQL, PL/SQL, stored procedures, functions and packages to migrate data from SQL server database to Oracle database.
  • Performance tuning of Oracle Databases and User applications.
  • Used SQL*Loader as an ETL tool to load data into staging tables.
  • Provided user training and production support.
  • Improved the performance of the application by rewriting the SQL queries.
  • Conducted the UAT with the business user and responsible for issue resolution and providing solutions for closure of the UAT.
  • Prepared test scripts of all sub-process identified in assessment phase.
  • Conducted workshops for training of user groups.

Confidential, Palmyra NY

Oracle PL/SQL developer

Environment: Oracle Applications 12.1.3, Oracle Database 11g, PL/SQL, SQL, Forms, Reports, SQL*Loader, DB2 and UNIX.

Responsibilities:

  • Developed PL/SQL Procedures, Functions and Packages and used SQL loader to load data into the database.
  • Wrote Shell Scripts for Data loading and DDL Scripts.
  • Used EXPLAIN PLAN, TKPROF to tune SQL queries.
  • Wrote conversion scripts using SQL, PL/SQL, stored procedures, functions and packages to migrate data from SQL server database to Oracle database.
  • Performance tuning of Oracle Databases and User applications.
  • Used SQL*Loader as an ETL tool to load data into staging tables.
  • Provided user training and production support.
  • Improved the performance of the application by rewriting the SQL queries.
  • Conducted a workshop with the business team as a part of explaining the flexibility of oracle functionality and how it meets the business requirements.
  • Coordinated and led the entire phase of the project which included initial operations analysis, business process re-evaluation, testing, training, conversions, customizations and documentation and implementation of modules.
  • Developed several Custom Reports and Customized Oracle Reports for Payables.
  • Set-up Banks, Receipts, Transactions, Plus training for invoicing, Receipts, Adjustments, and Period closing.
  • Created updated adjustments of Invoices, Debit memos, Credit memos.
  • Analysed and Mapped historical data of existing customers.

Hire Now