Keywords
Extract Transform Load (ETL)
Unit Testing
Data Modeling
PL-SQL
SQL Databases
Query Performance
Agile Methodology
Technical Support
Unix
Database Application
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
- ETL Developer(Contract), Credit Suisse, RTP, NC,09/17 – Present
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.
- Lead Software Engineer, FujiFilm Medical Systems, RTP, NC, 02/15-09/17
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.
- ETL DB Developer(Contract) Fidelity Investments, Durham, NC, 05/12 – 01/15
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.
- AVP, Credit Suisse, RTP, NC, 01/12-05/12
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.
- Principal Consultant, Deutsche Bank, RTP,NC, 02/09 — 10/11
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.
- Principal Software Engineer, Fidelity Investments, Durham, NC, 04/05 — 12/08
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.