Siebel EIM Developer, Siebel Database(Oracle) Admin, Siebel CRM Support, PL SQL Developer Resume

PROFILE SUMMARY:

My main areas of work are Siebel EIM, Datastage development and PL/SQL programming.
Having hands on experience in Siebel EIM, PL SQL, Datastage development, Informatica, Autosys and having good knowledge on CRM Sales domain, Python, MongoDB, Informatica ETL, Core Java.
Over 8.5 years of IT experience in Requirements Gathering and analysis, Design, translating business requirements to production level technical specifications, Data Modelling, Data migration, Data Analysis, Data warehousing and Data integration via Datastage and other ETL tools.
Experienced in Database design and creating the data models.
Experienced in working on conceptual, logical and physical data models using MS Visio.
Proficient in creating objects such as Stored Procedures, Indexes, Views, Triggers, User defined functions, cursors, derived tables and Complex Queries on Oracle platform.
Was part of Insurance and Annuity client Data developer team where I enhanced and created new Datastage ETL, Unix shell script and Autosys jobs for different requirements over a period of 3.8 years.
Experienced in optimizing the performance in both relational and dimensional database by making proper use of indexes.
Very good knowledge and experience in SQL, PL/SQL and Data warehousing Concepts.
Worked in projects using Agile/Scrum methodology
Having good knowledge on Big Data, MongoDB, Python, Core Java and Tableau.
Ability to work independently and deliver the results on time.
Excellent planning and administrative abilities with exceptional communication skills.
Worked on Informatica job development and have working knowledge.

TECHNOLOGY EXPERIENCE:

PL/SQL Programming: Oracle 10g & 11g,Mongo DB, Datastage Developer,HTML,Tableau, Siebel CRM, Siebel EIM,Unix Shell Scripting, Core Java, Informatica, Big Data, Analytics

Tools: SQL developer, Siebel Tools, Datastage Designer, Informatica

PROFESSIONAL EXPERIENCE:

Confidential

Siebel EIM Developer, Siebel Database(Oracle) Admin, Siebel CRM Support, PL SQL Developer

Responsibilities:

Solving ad - hoc issues raised by the customer
Involved in improving the performance of the present application.
Involved in complete functional and technical testing of end to end testing.
Organization Division hierarchy setup for different geographies.
Giving Functional training to Helpdesk teams on Application usage and Production Support issues.
Giving trainings to Sales users on Sales functionality
Resolved user issues related to Siebel Sales Functional.
Account and Opportunity creation and ownership transfer
Creation of new users and assigning positions to them.
Creation of views and assigning responsibilities to views.
Creating and managing views, procedures, packages, functions and triggers
Generation of report as per the requirement.
Writing Complex SQL query.
Done the Job scheduling at DB level for timely data fetch into the Siebel tables from other integrated Applications.
Worked as a Siebel EIM and Interface Developer-
Designing New interfaces
Resolving all interfaces issues
Creating IFBs
Generating ad-hoc reports
Writing complex SQL Queries
Preparation of Data migration Scripts (CTLS, IFBS and Export SQL Scripts) as part of new implementation of CRM Application.
Extensively involved in Code reviewing and Defect fixing.

Confidential

PL SQL Developer (DB2,Sybase)

Responsibilities:

Converting Sybase database objects to DB2.
Involved in improving the performance of the present application.
Involved in complete functional and technical testing of end to end testing.
Worked on PL\SQL-
Creating and managing views, procedures, packages, functions and triggers
Writing Complex SQL query.

Confidential

Datastage/Informatica ETL developer, Siebel EIM developer

Responsibilities:

Creating new Datastage jobs.
Creating new Informatica jobs
Modifying existing Datastage jobs.
Creation of Autosys JIL to schedule Datastage Jobs.
Monitor and resolve Autosys job failures.
Creation/Modification of Siebel EIM IFB files.
Creation/modification of Unix shell scripts.
Worked on PL\SQL-Creating and managing views, procedures, packages, functions and triggers
Writing Complex SQL query.

Confidential

Informatica ETL and Oracle PL SQL developer

Responsibilities:

Creating new PL SQL objects.
Creating new Informatica jobs
Developing data mapping between source and target.
Monitor and resolve job failures.
Creation/Modification of Siebel EIM IFB files.
Worked on PL\SQL-Creating and managing procedures, packages, functions.
Writing Complex SQL query.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship