Designer & Sr.Developer Resume

SUMMARY

A Senior Software developer having 4 years and 8 months of experience in EBI environment as a Data Integrator proficient in various tools and eager to implement the acquired skills and grow with your concern.

TECHNICAL SKILLS

OWB 11g R2 (Oracle Warehouse Builder), Datastage 11.5, Pervasive Data Integrator.
Oracle SQL, PL/SQL .
Unix Shell Scripting.
Oracle 11g.
Toad, SQL - Developer.
Data Modeling.
Version controlling tool - SVN, CVS.

PROFESSIONAL EXPERIENCE

Confidential

Designer & Sr.Developer

Responsibilities:

Hitrate - This project helps the business to find the product performance and acceptance in the market.
It calculate enquiry about the policy and they are converted into a customer which is considered as HIT.
Based on the data loaded in EDW environment the report has generated which describes the how many enquiries converted as successful HIT if not based on what reason it rejected.
Working on Projects as well as change requests and guiding junior team members.
Preparation of Detail Level Design (DLD) documents for projects and change requests.
Created design, development and testing of PL-SQL Procedure and packages.
FTP/SFTP scripts to place outbound files, fixed-width or delimited, on remote servers, to be used by client as feeds for their systems.
Scheduling procedure and packages using APEX job scheduler.
Reviewing the Test case documents prepared by QC Team and provide any comments/suggestions if needed.
Support to the DBAs while migrating the code to Test, QC and Production environments.
Assisting Production Support Team during any unexpected issues, first by implementing the workarounds in Development environment and then providing the steps.

Tools: used: OWB 11gr2, Oracle Exadata, Oracle SQL, PL/SQL, UNIX shell scripting, SVN.

Confidential

Designer & Sr.Developer

Responsibilities:

Understanding the requirements from the client and developing the product.
Involved in design, development and testing of Datastage Jobs.
FTP/SFTP scripts to place outbound files, fixed-width or delimited, on remote servers, to be used by client as feeds for their systems.
Support to the DBAs while migrating the code to Test, QC and Production environments.
Automated data load mechanism, this will concurrently loads the data into the system to achieve the minimum time to load the huge amount of data.

Tools: used: Datastage 9.1, Oracle 11g, Oracle SQL, PL/SQL, UNIX shell scripting, Rational Clear case.

Confidential

Designer & Developer

Responsibilities:

Working on Projects as well as change requests.
Preparation of Detail Level Design (DLD) documents for projects and change requests.
Involved in design, development and testing of OWB Mappings & Process flows/ PL-SQL Procedure and packages.
FTP/SFTP scripts to place outbound files, fixed-width or delimited, on remote servers, to be used by client as feeds for their systems.
Creating PL/SQL code/Shell Scripts that identifies the workday of the client to in turn trigger specific jobs on specific workdays.
Reviewing the Test case documents prepared by QC Team and provide any comments/suggestions if needed.
Support to the DBAs while migrating the code to Test, QC and Production environments.
Assisting Production Support Team during any unexpected issues, first by implementing the workarounds in Development environment and then providing the steps.
Automated Source to target validation process so that the business places data, the system will load it and intimate the business upon successful load and also if any mismatch or records are dropped the system will trigger mail with attachment of where it went wrong to the developers for checking it will reduce developer’s time.

Tools: used: Oracle 11g, PL/SQL, OWB 11g r2, Pervasive Data Integrator, Informatica Power Center, Unix shell scripting, Toad, CVS.