We provide IT Staff Augmentation Services!

Sql Developer Resume

Northbrook, IL

SUMMARY:

  • Overall experience: 8 Years
  • 6.7 years’ of strong experience in analysis, design and development using ETL tool Ab - initio
  • 1.5 years of experience includes training and project work in Mainframe Technology
  • Strong background in ETL processing using Ab-initio, UNIX, Linux and Oracle
  • Experience in working on Development throughout the SDLC, unit testing, migration and post Migration Support
  • Worked extensively to develop optimized and maintainable solutions using ETL tool Ab-initio for any complex problem
  • Well versed with parallelism techniques and developed processes using MFS and other parallelism techniques to produce optimized execution speed
  • Created ETL processes to read and write various formats like Mainframe datasets with variable record size, XML files, Tables, Excel spreadsheets or CSVs and flat files.
  • Delighted clients with loads of value adds with POCs and presentations offering direct/indirect $ benefits
  • Possessing a creativity and ideas that helped me produce handy tools/utilities that in turn helped team and myself to increased productivity
  • Experience in Unix and Linux Shell scripting to create daemons, wrappers or small jobs
  • Experience in EME (Enterprise Metadata Env.) versioning, air commands and setting up schedulers
  • Training in Mainframe Application and programming. Enterprise COBOL, JCL, CICS and Ab-initio
  • Heavily interacted with Business Users, system analysts, business analysts to understand the requirement, to remove ambiguity and helped client to implement flawless processes and minimal or no defects in Quality Check testing
  • Excellent analytical and communication skills always helped me to provide feasible solutions and timely exceptional deliveries.
  • Worked with team as a team player, guide, mentor, coordinator and leader

TECHNICAL SKILLS

ETL Tools: Ab-initio (version 2.14, 3.0 and 3.2.2)

Application Servers: Windows, UNIX, Linux

Languages: C, C++, COBOL, JCL, CICS

Database: Oracle, DB2, SQL

PROFESSIONAL EXPERIENCE

Confidential, Northbrook, IL

SQL Developer

Operating System: Windows operating systemApp platforms:UNIX

Tools:Ab-initio GDE, EME

Responsibilities:

  • Handling maintenance activities. Acting as SME to this Project and on-site coordinator.
  • Performing analysis of requirement document.
  • Building strategies and setting standards for application and code development.
  • Handling Problem Tickets, Production Migration, Service Requests
  • Unit Testing of application and handling migration activities to QA and Production
  • Analysis of requirement document.
  • Building strategy, setting standards for application.
  • Code Review and enhancements.
  • Presenting Weekly and Monthly Reports to the client on ongoing production activities.
  • Production Support for dotMAX, Talent connection and exterro project.
  • Worked on UNIX to Linux Ab-initio code upgrade and migration.
  • Worked with System and Business analyst closely to write tech specs and to setup flawless processes.

Confidential, Northbrook, IL.

Operating System: Windows operating systemApp platforms:UNIX

Database:Oracle 10g/11g, SQL developer

Tools:Ab-initio GDE, EME

Responsibilities:

  • Handling maintenance activities. Acting as SME to this Project and a on-site coordinator.
  • Performing analysis of requirement document.
  • Building strategies and setting standards for application and code development.
  • Handling Problem Tickets, Production Migration, Service Requests
  • Unit Testing of application and handling migration activities to QA and Production
  • Analysis of requirement document.
  • Building strategy, setting standards for application.
  • Code Review and enhancements.
  • Presenting Weekly Reports to the client on ongoing production activities.
  • Maintenance, Enhancement and Production Support for EPC and Ebridge-EDMS project.

Confidential

Operating System: Windows operating systemApp platforms:UNIX

Database:Oracle 10g/11g, SQL developer

Tools:Ab-initio GDE, EME

Responsibilities:

  • Delivered 5 major and 3 minor releases being a on-site coordinator since June 2012.
  • Performing analysis of requirement document.
  • Building strategies and setting standards for application and code development.
  • Unit Testing of application and handling migration activities to QA and Production
  • Analysis of requirement document.
  • Building strategy, setting standards for application and
  • Production Support for ACSR project started from April 2011.

Confidential, Northbrook, IL.

Operating System: Windows operating systemApp platforms:UNIX

Database:Oracle 10g/11g, SQL developer

Tools:Ab-initio GDE, EMEDescription: Version 2.14 of the application had a need to be upgraded to 3.0 as the CO>Op was updated and it was developed in

Responsibilities:

  • Impact analysis and building a steps to upgrading the application.
  • Updating the code.
  • Unit Testing plan, meetings and documentation.
  • Doing peer review for test plans and test results.
  • Cycle execution after the changes to ensure functionality is maintained.

Confidential, Northbrook, IL.

Operating System: Windows operating systemSQL developer

Responsibilities:

  • Acting as SME to this Project and on-site coordinator.
  • Develop code to add supporting controls.
  • Modification of graphs to accommodate new changes.
  • Performance enhancements at module level.
  • Unit testing and documentation.
  • Testing of modified objects and co-coordinating with QA team in resolving the defects and queries

Hire Now