We provide IT Staff Augmentation Services!

Lead Etl Developer, Performance Analyst Resume

San, FranciscO

SUMMARY:

  • Over 18 years of experience in Analysis, Design, Development, Implementation of Business Applications on various platforms.
  • Proven ability in all aspects of software development life cycle, worked on both waterfall and iterative methodologies.
  • Expertise in SQL performance tuning used various tools and utilities. Hands on experience on database performance.
  • Extensively worked on databases of very large data volume.
  • Experience working on both OLTP and OLAP environments.
  • Experience in Support, Operations and maintenance activities.
  • Extensively worked on designing and developing interfaces with various inbound and outbound external systems and platforms.
  • Strong experience using Oracle Front end development tools, ETL development tools and reporting tools.
  • Expertise in creating, scheduling batch processes, extensively used scripting languages.
  • Expertise implementing complex business rules using stored procedures and functions.
  • Strong experience in Star Schema design, slowly changing dimensions, ETL design and development, data sourcing and staging.
  • Hands on experience in Java Web based applications.
  • Experience handling XML files stored in Oracle database.
  • Experience in writing test scripts, test cases, preparing test data.
  • Strong communication and interpersonal skills, self - motivated, team player.

TECHNICAL SKILLS:

Databases: Oracle 12/11gR2 RAC/10g/9i/8x/7x, IBM DB2, DB2-UDB, MS-SQL Server

Operating Systems: Unix (IBM AIX, Sun Solaris, HP-UX), Linux, Windows, DOS

Design Methods: E-R Modeling, Star schema, Snowflake schema

Languages: PL/SQL, SQL, C++, Pro*C, Perl, SQR, COBOL, Java, JDBC, XML, HTML

Scripting Languages: Perl, Shell (K/B/C), JavaScript

Data Modeling Tools: ERWin, Embarcadero, Oracle Designer/2000

ETL Tools: Informatica Power Center 10.2/9.8/8.6/7.1, Oracle Warehouse Builder

Reporting Tools: Reports 10.1/6i/2.5, SSRS, Business Objects 6/5

GUI Tools: Developer 2000/Forms 10.1/6i/4.5/3.0, Visual Basic, Power Builder

Other Tools/Utilities: TKProf, AWR, SQL Performance Analyzer, SQL Advisor, SQL Trace, StatsPack, SQL Profiler, SQL*Loader, Data Pump, Autosys, Cron jobs, Toad, PVCS, Clear Case, SVN

Testing and tools: WinRunner, LoadRunner, Test director,Test Plans/Test Cases

EXPERIENCE:

Confidential, San Francisco

Lead ETL Developer, Performance Analyst

Responsibilities:

  • Worked closely with business in gathering business requirements and involved in converting them into technical requirements.
  • Lead a team of developers for developing a project that schedules conversion of Wachovia corporate accounts to Wells accounts by seeking relationships between various accounts of a same customer.
  • Worked closely with Oracle consultants and DBA on performance tuning. Reviewed AWR reports, TKProf outputs and recommended many changes to the database configuration, backup strategy, worked on application tuning to get the scheduling engine job per SLA and business expectations.
  • Used SQLAccess advisor to identify indexes and materialized views Created materialized views. Used SQL performance analyzer by testing changes against real-life workloads.
  • Created Logical and Physical data models for the application.
  • Created detail design of the Scheduling and accounts relationship engine.
  • Prepared FSD, program specifications, flow diagrams, and coding logic flowcharts to assist in problem analysis, provided recommendations for solutions.
  • Worked on creating interfaces for external inbound and outbound data sources.
  • Wrote complex algorithms in PL/SQL stored procedures.
  • Created and modified Autosys jobs for inbound Wachovia feeds and table refreshes.
  • Performed support, Operations and maintenance activities on a routine basis.
  • Worked with QA teams and resolved critical defects.
  • Created K-shell and Perl scripts to automate stored procedures and SQL*Loader scripts.
  • Customized, enhanced, tuned existing reports using Oracle Autotrace and explain plan utilities in SQL*Plus, worked on tuning to help improve response time of reports.
  • Worked on data security, integrity of the system. Created, modified database Triggers for scheduling reference and lookup tables.

Environment: Oracle 11g/10g, SQL, PL/SQL, Sun Solaris, Shell scripts, InformaticaTKProf, AWR, SQL Performance Analyzer, SQLAccess Advisor, SQL*loaderDBMS Profiler, Autosys Job Scheduler, Toad

Confidential, Walnut Creek

Lead ETL Developer

Responsibilities:

  • Interacted with end users and business analysts to understand new requirements, enhancements and existing functionality changes for IFD, involved in problem analysis, provided recommendations and solutions.
  • Created and modified Logical and Physical data models for various sub modules in the IFD application.
  • Worked closely with DBAs on database and application tuning. Used AWR reports to analyze database performance at critical periods. Used TKProf and trace files to identify bottlenecks in CPU time, memory, I/O and network.
  • Made changes to live production environment (without downtime) using 11gR2 new feature cross edition.
  • Used workload capture and replay feature of the Oracle Real Application Testing and SQL performance analyzer by testing changes against real-life workloads.
  • Used SQLAccess advisor to identify indexes and materialized views Created materialized views to pre-summarize data whenever needed for reporting purposes.
  • Worked on query optimization, used analytical functions, inline views, hints in SQL queries and stored procedures to reduce multiple table scans to improve query performance.
  • Enhanced database performance and availability by compressing data onto low cost storage partitions.
  • Worked on identifying and creating interfaces for external inbound and outbound data sources such as enterprise data ware house, data marts and online order system.
  • Prepared High Level Design documents, program specifications and flow diagrams.
  • Wrote complex PL/SQL stored procedures to extract the required data based on business specifications.
  • Extensively worked on extracting and exchanging XML data through interfaces using web services and Oracle database links. Performed various activities on XMLs stored in the database, such as extractions, validations, updating XML contents and error handling and reporting.
  • Performed support, Operations and maintenance activities on a routine basis.
  • Worked with QA teams and resolved critical defects.
  • Created K-shell and Perl scripts to automate stored procedures and SQL*Loader scripts.

Environment: Oracle 11gR2 RAC, SQL, PL/SQL, XML, Sun Solaris, Shell and Perl scriptsTKProf, AWR, SQL Performance Analyzer, SQLAccess Advisor, SQL*loaderDBMS Profiler, cron jobs, ClearCase, Toad

Confidential, San Francisco, CA

Lead ETL Developer, Performance Analyst

Responsibilities:

  • Interacted with business users and analysts in gathering requirements and converting them into technical requirements.
  • Worked on data modeling Logical and Physical data models for the application using the ERWIN.
  • Used AWR reports to analyze database performance at critical periods. Used TKProf and trace files to identify bottlenecks in CPU time, memory, I/O and network.
  • Used SQL*Loader direct path to load huge claims data files coming from Mainframe Created complex SQL scripts and PL/SQL stored procedures using Ref Cursors, dynamic SQL, used Bulk collections, partition utilization, materialized view and query re-write to improve performance of PL/SQL program units.
  • Worked on query optimization and performance tuning, used analytical functions effectively in SQL queries to reduce multiple table scans, inline views to improve query performance.
  • Analyzed existing file handling process written in CoSort; and migrated to Oracle PL/SQL program units and SQL scripts.
  • Prepared program specifications, diagrams, and coding logic flowcharts to assist in problem analysis, provided recommendations for solutions. systems into staging environment Oracle database.
  • Worked on designing ETL processes, modified existing ODS process to add/append data coming from new source systems.
  • Developed complex mappings in Informatica, created external procedures using PL/SQL and C++ to be called from Informatica transformations.
  • Scheduled the workflows to pull data from the source databases at daily, monthly intervals, to maintain most current and consolidated data for reporting.
  • Wrote unit test cases, worked on deployment strategies in SIT and UAT environments.
  • Worked on designing Online Products Enrolment System which would enable the users to enter new products and insurance plans online.
  • Created Libraries, complex Forms and generated reports for the internal online plan and products system using Oracle Forms, Reports.
  • Involved in improving performance of monthly data refresh into enterprise data warehouse.

Environment: Oracle 11g/10g, SQL, PL/SQL, Sun Solaris, Shell and Perl scripts, Informatica Power Center 8, Oracle Application Server 10g, CoSort, C++, SQL*loaderPVCS, Trizetto Facets 4.41/4.6

Confidential, San Jose, CA

Sr. PL/SQL Developer, Performance Analyst

Responsibilities:

  • Interacted with Business Analysts, involved in converting business requirements into technical requirements.
  • Created High level and Detail design of data extract logic of expense related data from the Enterprise data warehouse (EDW) and Oracle ERP system.
  • Worked on data modeling Logical and Physical data models for the application.
  • Worked on developing complex SQL scripts involving analytical functions, dynamic SQL, PL/SQL procedures to extract data from EDW and Oracle ERP system.
  • Involved in moving business logic from front end java code to backend PL/SQL code of Non SI (System Integrated) audit system which is used to track bad journal entries made by employees.
  • Worked on resolving performance related issues for “Drill to Detail (DTD)” reports, tuned SQL statements and PL/SQL stored procedures, used Bulk collections, created materialized views, to use query re-write.
  • Created K-shell and Perl scripts and Cron jobs to automate stored procedures and SQL*Loader scripts.
  • Created and modified $Universe and cron jobs for flat file generation and stage table refreshes.
  • Wrote PL/SQL procedure, functions, Triggers to implement data security and integrity.
  • Customized, enhanced, tuned existing reports using Oracle Autotrace and explain plan utilities in SQL*Plus, worked on tuning to help improve response time of reports.
  • Worked on data security, integrity of the system. Created, modified database Triggers.
  • Created and modified staging tables to speed up various DTD queries for reporting purposes in FETCH and COA cubes in data warehouse environment.
  • Used SQL*Loader to load data from other systems into Oracle database.

Environment: Oracle 10G/9i, Oracle Applications (ERP) GL, SQL, PL/SQL, Unix, JSP, JDBCShell, Perl scripts, C++, Business Objects, Remedy, $Universe, Kintana, Hyperion Essbase, Toad

Confidential, Newark, CA

Oracle PL/SQL Developer

Responsibilities:

  • Involved in High level design and detail design phases of SubBurst system, to extract data from the parent SunAware system and ERP system, which send data as ETL extracts to SunBURST.
  • Worked on data modeling, created Logical and Physical data model layouts using Erwin.
  • Involved in creating schema objects for SunBURST system on Oracle 8i server.
  • Worked on backend, created packages and stored procedures to load summary or aggregate tables involving very high volume of data.
  • Designed, Developed and documented the new reports and Customizing Existing reports.
  • Involved in SQL & PL/SQL programming for stored procedures, worked on application performance tuning of SQL and PL/SQL stored program units, using SQL Trace, Tkprof.
  • Developed, tested and implemented both Visual interface as well as the database of the whole application.
  • Worked on Shareplex to transfer data between source and target Oracle servers.
  • Created views to simply complex queries and created computational procedures in C++ and Pro*C.
  • Worked on creating interfaces between legacy systems and SunBurst system and created load programs to load data from flat files with necessary business validations.
  • Involved in DBA activities such as creating and managing schemas: tables, indexes, snapshots, rollback segments, roles, links etc.
  • Converted old reporting application from Reports 4.5 to Reports 6i to make them web enabled.
  • Developed Web enabled Oracle reports using Reports 6i and automated the daily report jobs.
  • Involved in assisting front-end development in JSP to create reports fetching data from the data warehouse.

Environment: Oracle 8i/9i, PL/SQL, SQL, Sun Solaris, Shell, Perl scripts, C++, Reports 4.5, 6iErwin, SharePlex, JSP, Java.

Confidential

Oracle Developer

Responsibilities:

  • Involved in creating interface between APEX on Sun Solaris and native Mainframe system, using Pro*C.
  • Created batch programs to load air tickets data for Pro-ration from flat files sent by revenue accounting system, into the APEX database, with all necessary validations.
  • Modified above Pro*C batch programs and interface to make portable to Continental Airlines environment.
  • Created complex reports for Inward Billing System using Pro*C on Solaris system, created batch programs using Shell scripts to automate time driven reports.
  • Developed front-end modules using Developer/2000 modified and added features in the Forms libraries, created complex Forms involving multiple opened form windows
  • Worked on Performance Tuning: Tuned and modified the SQL statements to avoid frequent calls to the database avoiding bottleneck of network.
  • Involved in the testing phase, created test plans, cross testing of modules, Pro*c report programs, Forms created by other team members, among the team members.

Environment: Sun Solaris, K-Shell, Oracle 7.3, SQL, PL/SQL, Pro*C/C++, Developer 2000Forms 3.0/4.5, Reports 2.5

Hire Now