Livecareer-Resume
Jessica Claire
  • Montgomery Street, San Francisco, CA 94105
  • Home: (555) 432-1000
  • Cell:
  • resumesample@example.com
Summary
9+ years of experience in IT industry with emphasis on Analysis, Design, Development,Implementation and Management of projects using ETL/Oracle (Sql, PL/SQL).
Skills

  • Active member in MBIA Insurance Deal Analysis System(Midas) Database Development team. 
  • Investment banking knowledge - Member of Credit Suisse Advanced Execution Services (AES)
  • Participating in Algorithmic and High Frequency Trading project.
  • Insurance domain knowledge – Claims adjudication, Pricing, Provider networks.
  • Developed DDL/DML scripts, Stored procedures required for migrating data from ADP - WFN 7.0 to ADP - WFN 9.0
  • Proficient in Oracle, PL/SQL, Extraction Transformation and Loading (ETL) concepts and have used various tools like Informatica, DataStage.
  • Proficient in reporting concepts and have used tools like Crystal Reports, Oracle Reports.
  • Intermediate level of knowledge in UNIX shell scripting and Perl.
  • Extensive working experience in writing various modules likes functions, stored procedures, cursors (Implicit, Explicit, REF), packages, triggers and creating tables, views and materialized views using Oracle SQL and PL/SQL.
  • Proficient in Oracle tools and utilities such as TOAD, PL/SQL Developer, SQL Developer.
  • Experience in Data Warehouse design, Data Modeling and Schema Design.
  • Proficient in Oracle SQL Tuning and PL/SQL debugging.
  • Experience in performance Tuning using various types of Hints, Partitioning, Indexes, SQL Trace, TKPROF and Explain Plan.
  • Good knowledge of the RDBMS concepts advanced Oracle queuing and Oracle Workflow.
  • Extensive experience in client facing roles and working in multicultural, multi-geographic teams. 
  • Ability to be an effective team player and work under time constraints. 
  • Deep understanding of Software Development Cycle (SDLC) and implemented various models like Spiral, Agile (XP, SCRUM).
Experience
Sr Oracle PL/SQL Developer (Consultant), 09/2015 to Current
, ,
MBIA - Bond Insurance
Purchase(Greater New York), New York
 
MBIA Insurance Deal Analysis System
Midas empowers the largest municipal bond insurer product to MBIA. Which would provide financial guarantee insurance and other specialized financial services.
​Responsibilities: 
  • Creating new Procedures, Functions, Triggers, Materialized Views, Packages, Simple, Ref & Traditional Cursors, Dynamic SQL, Table functions as part of Project/Application requirements.
  • Working on SQL*Loader to load data from flat files obtained from various facilities every day.
  • Expertise in UNIX shell Scripts according to the changing needs of the project and client requirements.
  • Wrote Unix Shell Scripts to process the files on daily basis like renaming the file, extracting date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.
  • Involving in continuous enhancements and fixing of production problems.
  • Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
  • Developing PL/SQL triggers and master tables for automatic creation of primary keys.
  • Creating PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
  • Extensively working to create new tables, views, queries for new enhancement in the application using TOAD.
  • Creating indexes on the tables for faster retrieval of the data to enhance database performance.
  • Involving in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
  • Extensively performance tuning SQL and PL/SQL tuning and Application (OLTP & OLAP) tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
  • Extensively involving in creating hints to direct the optimizer to choose an optimum query execution plan.
  • Expertise in Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
  • Creating PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL_FILE package.
  • Partitioning the fact tables and materialized views to enhance the performance.
  • Creating collections (nested tables and arrays) for improving Query performance by reducing context switching and Dynamic SQL using Pragma Autonomous Transaction to avoid mutating problem in database trigger.
  • Handling errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
 
Environment: Oracle 11g database, SQL, PL/SQL,Toad, XML, JIRA, PLSQL-Developer, Unix Scripting, Perl, Windows7, JAVA
Sr Oracle PL/SQL Developer (Consultant), 04/2015 to 08/2015
SyllableCity, STATE,
 
 WorkForce Now (WFN)
ADP Workforce Now empowers clients to effectively address business challenges with a flexible, secure and integratedHCM solution that supports the full spectrum of HR needs – from recruitment to retirement and everything in between.
Responsibilities:
  • Creating new Procedures, Functions, Triggers, Materialized Views, Packages, Simple, Ref & TraditionalCursors, Dynamic SQL, Table functions as part of Project/Application requirements.
  • Working on SQL*Loader to load data from flat files obtained from various facilities every day.
  • Wrote conversion scripts using SQL, PL/SQL, stored procedures, functions and packages to migrate data from WFN 7.0 database to WFN 8.0 database.
  • Expertise in UNIX shell Scripts according to the changing needs of the project and client requirements.
  • Wrote Unix Shell Scripts to process the files on daily basis like renaming the file, extracting date from the file,unzipping the file and remove the junk characters from the file before loading them into the base tables.
  • Involving in continuous enhancements and fixing of production problems.
  • Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remoteinstances.
  • Developing PL/SQL triggers and master tables for automatic creation of primary keys.
  • Creating PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.Extensively working to create new tables, views, queries for new enhancement in the application using TOAD.
  • Creating indexes on the tables for faster retrieval of the data to enhance database performance.I
  • nvolving in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
  • Extensively performance tuning SQL and PL/SQL tuning and Application (OLTP & OLAP) tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
  • Extensively involving in creating hints to direct the optimizer to choose an optimum query execution plan.
  • Expertise in Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
  • Creating PL/SQL scripts to extract the data from the operational database into simple flat text filesusing UTL_FILE package.
  • Partitioning the fact tables and materialized views to enhance the performance.
  • Creating collections (nested tables and arrays) for improving Query performance by reducing context switching and Dynamic SQL using Pragma Autonomous Transaction to avoid mutating problem in databaseTrigger.
  • Handling errors using Exception Handling extensively for the ease of debugging and displaying the errorMessages in the application.

 Environment: Oracle 11g database, SQL, PL/SQL,Toad, XML, JIRA, PLSQL-Developer, Unix Scripting, Perl,Windows7.

Sr Oracle PL/SQL Developer ( Consultant ), 09/2013 to 03/2015
, ,

Credit Suisse - Equity IT 

New York City, New York

Advanced Execution Services (AES)
AES helps over a thousand institutions and hedge funds reduce market impact, improve performance vs benchmarks add consistency to their trading process. AES group provides Credit Suisse's award winning suite of algorithmic trading strategies, tools  and  analytics for global trading. A single connection for your desk to AES will get your access to liquidity around the world. Algorithmic Trading/ Crossfinder (Dark Pool), Direct Market Acess, Smart order routing are key the engines part of AES.
Responsibilities: 
  • Creating new Procedures, Functions, Triggers, Materialized Views, Packages, Simple, Ref & Traditional Cursors, Dynamic SQL, Table functions as part of Project/Application requirements.
  • Working on SQL*Loader to load data from flat files obtained from various facilities every day.
  • Expertise in UNIX shellScripts according to the changing needs of the project and client requirements.
  • Wrote Unix Shell Scripts to process the files on daily basis like renaming the file, extracting date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.
  • Involving in continuous enhancements and fixing of production problems.
  • Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
  • Developing PL/SQL triggers and master tables for automatic creation of primary keys.
  • Creating PL/SQL stored procedures, functionsandpackages for moving the data from staging area to data mart.
  • Extensively working to create new tables, views, queries for new enhancement in the application using TOAD.
  • Creating indexes on the tables for faster retrieval of the data to enhance database performance.
  • Involving in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
  • Extensively performance tunning SQL and PL/SQL tuning and Application (OLTP & OLAP) tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
  • Extensively involving in creating hints to direct the optimizer to choose an optimum query execution plan.
  • Expertise in Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
  • Creating PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL_FILE package.
  • Partitioning the fact tables and materialized views to enhance the performance.
  • Creating collections (nested tables and arrays) for improving Query performance by reducing context switching and Dynamic SQL.
  • Using Pragma Autonomous Transaction to avoid mutating problem in database trigger.
  • Handling errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
  • Extensive scripting in PERL to generate regulatory reports and deliver to Business.


Environment: Oracle 11g database, SQL, PL/SQL,Toad, XML, JIRA, PLSQL-Developer, Unix Scripting, Perl, Windows7.

Sr Oracle PL/SQL developer ( Consultant ), 05/2011 to 09/2013
, ,

Delta Dental of Virginia - Insurance

Roanoke, VA

 
Delta Claim System
DCS integrates Claims, Eligibility and Billing functions. Claims are keyed directly into DCS2000, One step claims processing  feature keeps how DCS delivers superior service to Members, Providers and Employer Groups. Subscriber/Groups/Claims data would be loaded using various ETL methods and necessary strategy would be applied by system for Adjudication/Pricing and Enrollments.
Responsibilities: 
  • Involved in the maintenance and enhancement of the application.
  • Maintaining Logical and Physical structure of the database.
  • Creating table spaces, tables, views, scripts for automatic operations of the database activities.
  • Coded various stored procedures, packages and triggers to incorporate business logic into the application.
  • Used the technical document to design the database tables.
  • Data conversion from flat file to intermediate tables using SQL*Loader, Data mapping.
  • Gather Database and User Level Statistics and Analyze Overall System Performance.
  • Designed/developed tables, views, various SQL queries, stored procedures, functions.
  • Monitor database and system backups, developed Oracle Stored procedures, functions, packages, and triggers that pull data for reports.
  • Develop UNIX shell scripts to administer the system.
  • Extensively worked with Dynamic SQL, Composite data types & Global Temporary Tables.
  • Responsible for purging and archiving the production databases.
  • Used UTL_JOB to automate the PL/SQL procedures and packages.
  • Involved in Interacting with users, error fixing by enhancing PL/SQL packages, stored procedures & functions.
  • Performed logical backup using export and import utilities.
  • Developed database objects including tables, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems.
  • Involved in Unit Testing Stored Procedures and Functions
  • Created SQL*Loader scripts to load data into the temporary staging tables.
  • Created Custom Triggers, Stored Procedures, Packages and SQL Scripts.
  • Involved in uploading of the data from flat files into Databases and validated the data with PL/SQL procedures.
  • Performance Tuned complex Stored Procedures for faster execution and Developed database structures, according to the requirements


Environment: Oracle 10g/11g database, SQL, PL/SQL, Oracle Stored-procedures/functions, Java 1.5, MySQL, Toad, XML, JIRA, SQL-Developer, Unix Scripting, JAVA
Oracle PL/SQL Developer ( Consultant ), 09/2009 to 02/2011
, ,

Fidelity National Information Services - Consumer Banking

Malvern, PA
 
Electronic Deposit Account Opening (eDAO)     

eDAO would provide financial institutions with the ability to offer an enhanced New Account Opening workflow via the internet to their customers. This new account opening includes internal verification & external verification, using alerts to notify applicants about the outcome of their application, added notes for an application and enhanced application management features by providing advance search options and the ability to re-submit applications that could not be completed successfully.

​Responsibilities:
  • Responsible for design and development backend applications in Oracle, PL/SQL.
  • Delivery of onsite and offshore ETL development for the clients.
  • Performance tuning of backend queries used for online applications.
  • Prioritization of projects based on business needs and timely deployment of ETL code.
  • Designed ETL workflows in various tools like Informatica, DataStage and SSIS.
Software Engineer, 01/2007 to 09/2009
, ,
iGATE Global Solutions​
Bangalore, INDIA
Education
: , Expected in
Bachelor of Engineering in Computer Science - Model Engineering College - ,
GPA:

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

Disclaimer

Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.

How this resume score
could be improved?

Many factors go into creating a strong resume. Here are a few tweaks that could improve the score of this resume:

57Fair

resume Strength

  • Personalization
  • Strong Summary
  • Target Job

Resume Overview

School Attended

  • Bachelor of Engineering in Computer Science - Model Engineering College

Job Titles Held:

  • Sr Oracle PL/SQL Developer (Consultant)
  • Sr Oracle PL/SQL Developer (Consultant)
  • Sr Oracle PL/SQL Developer ( Consultant )
  • Sr Oracle PL/SQL developer ( Consultant )
  • Oracle PL/SQL Developer ( Consultant )
  • Software Engineer

Degrees

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

*As seen in: