BE
available

Last update: 04.03.2019

ETL SQL PL/SQL Consulrant (Part Time Remote options only)

Graduation: MS in Computer Applications
Hourly-/Daily rates: show
Languages: English (Full Professional)

Keywords

Extract Transform Load (ETL) Unit Testing Data Modeling PL-SQL SQL Databases Query Performance Agile Methodology Technical Support Unix Database Application + 11 more keywords

Skills

  • 15+ Years Experience in leading projects with offshore/onsite resources model for Major Financial and Insurance companies.
  • 15 Years of Experienced in Data Modeling using ERWin and Oracle Designer.
  • 15 Years of Experience in Data Modeling for ETL and OLTP systems.
  • 15+ years of experience in PL SQL and SQL programming.
  • 3 years of experience in Transact SQL on Sybase 11.x.
  • Experience in Perl and UNIX scripts.
  • utPLSQL Scripting for Unit test Suites.
  • Proven track record in Analysis and Problem solving skills and Database applications and Query Performance Tuning.
  • Experience in Agile development methodology.
  • Experienced in technical documentations Systems Specifications, Technical design, Unit test plan, Install plan and Application support documents.

Project history

  1. ETL Developer(Contract), Credit Suisse, RTP, NC,09/17 – Present
Environment: Oracle 11g, PL SQL, Control-M, JIRA,SVN and ETL
Role and Responsibilities:
  • PL SQL Packages and Procedures coding.
  • Design and Development of ETL processes using Control-M and SQL Loader
  • Performance tuning of PL SQL and SQL components.
  • Using JIRA application to track day to day tasks and status.
  • Data Modeling for ETL data warehouse systems.
  1. Lead Software Engineer, FujiFilm Medical Systems, RTP, NC, 02/15-09/17
Environment: Oracle 11g, PL SQL, Visual Studio 2015, Visio 2013, C#
Role and Responsibilities:
  • Lead development efforts for Legacy Synapse and Fox applications for Radiology imaging systems.
  • Carry out the enhancements using agile development methodology
  • Hands on coding using PL SQL, C# and SQL
  • Agile development methodology, hands on Unix and Windows scripting
  • Refectored  existing complex legacy default data load scripts
  • Performance tuning of PL SQL and SQL components.
  • Developed unit test suites.
  1. ETL DB Developer(Contract) Fidelity Investments, Durham, NC,  05/12 – 01/15
Title: Lead Database Developer for NetBenfits, Advanced Analytics and Data Mining, PPMC and Application Life Cycle Management
Environment: Oracle 11g, PL/SQL, SQL, utPLSQL, ETL, Microsoft Visio 2012, TOAD
Roles and Responsibilities:
  • Designed and developed PL/SQL Packages, Stored procedures, Functions for Grace Letter generation, Benefits Enrollment processing and Rate Premium Services modules.
  • Developed Data Model for Advanced Analytics and Data Mining application sourcing the data from PPMC, Financials (FCAP) and Application Life Cycle Management Systems using Visio 2012.
  • Data model design for Enterprise Report Center (ERC)
  • Designed and implemented ETL processes for Enterprise Reporting Center.
  • Developed Materialized Views, PL SQL Packages, Database Tables, Views.
  1. AVP, Credit Suisse, RTP, NC, 01/12-05/12
Title: Trading Systems Management and Support
Environment: Oracle 11g, Sybase 15.x, Linux 2.6, Solaris 5.x, SQL and Shell Scripts
Role and Responsibilities:.
  • Define and document processes for support operations and implementation.
  • Implement production changes through change control processes.
  1. Principal Consultant, Deutsche Bank, RTP,NC, 02/09 — 10/11
Title: Inter Listed Stocks Enhancements for Autobahn Equity, Cash and Program Trading 
Oracle 11g, SQL, PL SQL, SQL Loader, ETL, ERWin 7, Shell and Perl Scripts and Control-M
Role and Responsibilities:
  • Developed PL SQL Packages for Order Activity Tracking Systems processes to load and process orders and generate Reports.
  • Mentored team members in document standards and coding standards.
  • Logical and Physical Data Modeling.
  • ETL and Control M usage documents for RTB system support.
  • Enhanced Perl script for ETL processes.
  • Agile methodology for SDLC.
  1. Principal Software Engineer, Fidelity Investments, Durham, NC, 04/05 — 12/08
Title: Financial Applications Design and Development, B2B and Web Services API design, development and support for Portfolio Advisory Services (PAS), Prospects and Fulfillment, SIEBEL CRM and Oneview applications.
Environment: Oracle 9i/10g, IAS 9i/10g, PL/SQL, Java, SIEBEL, Web services Framework xPresso 3.x, Apache Tomcat 5.x and Sun Solaris 2.8, Oracle Designer 2000, SQL*Loader, MS Visio and MS Project.
Role and Responsibilities: Responsible for Technical design, install Plan and Application support documents.
  • Developed PL SQL Packages, Procedures, and Functions for Data Access APIs to support OLTP systems.
  • Logical and Physical Data modeling.
  • Production support for various financial applications like Portfolio Advisory Services (PAS) Developed custom APIs using B2B framework on xPresso 3.x.
  • Developed PL/SQL packages and Java classes for B2B APIs.
  • Batch Jobs using Unix Shell scripts.

Local Availability

Only available in these countries: USA
Remote work from home option only.
Profileimage by Anonymous profile, ETL SQL PL/SQL Consulrant (Part Time Remote options only) ETL SQL PL/SQL Consulrant (Part Time Remote options only)
Register