SUMMARY:

• Siebel EIM/Configuration, Oracle BI Publisher BIP , Oracle PLSQL, Oracle ETL developer seeking a challenging, technical position in the area of Siebel and Oracle development .
• 7 years 6 months experience in analysis, design and development, system testing, and programming, in Oracle environment as a Siebel Developer, Oracle BI Publisher developer, Oracle PLSQL and Oracle ETL developer.
• Over Seven plus years of exclusive experience working with Siebel, Oracle PLSQL/SQL , Business Intelligence and Reporting. Experienced in developing Oracle stored packages, procedures, functions, Partitions, triggers, views , DML, DDL queries and Unix Shell Scripting.
• Around 1.5 years of experience on Siebel Public sector Vertical.
• 5 Plus years experience on Oracle BI Publisher, Oracle forms and reports, , ETL tools like SQL Loader, Informatica etc.
• Extensive experience in Building Complex Interfaces using Siebel EIM , Oracle PLSQL and Unix Shell Scripting , Siebel ETL Data Migration/Loads, Performance tuning ETL Loads, PLSQL Interfaces , Scheduling and building ETL jobs using Siebel EIM , SQL, PLSQL,SQL Loader ,Informatica .
• Experienced in all phases of Software Development Life Cycle SDLC , Working on Projects with Agile Implementation as per client needs.
• Experience in full life-cycle database including data architecture, logical and physical design, data modeling, and implementation.
• Expertise in Database Performance Tuning, Performance Monitoring and Query Optimization using Oracle Hints, Explain plans and Table partitioning.
• Experience in creating SQL loader scripts to load data from flat files into the database and also creating external tables to manage data.
• Writing scripts for collection of statistics, reorganization of tables and indexes, and creation of indexes for enhancing performance for data access.
• Experience in advanced PL/SQL concepts like Bulk collect, Explain Plan, PL/SQL tables and Dynamic SQL for DML operations for better performance.
• Identified several SQL and PL/SQL bottlenecks using PL/SQL Profiler package DBMS PROFILER , explain plan, auto trace and tuned them to suit SLA.
• Excellent planning, analytical, written Communication and Interpersonal skills.
• Good Knowledge on Microsoft Project Planning, baseline the work, track MSPS , worked on Project related metrics required by Leadership.

Technical SKILLS:

• Primary Skills :- Siebel Development, Siebel EIM, Siebel Configuration , Workflows , Oracle PLSQL , Oracle BI Publisher 10g/11g , Oracle 11g/10g, Unix Shell Scripting , Data Conversion, ETL, Application Manual Testing, Oracle Data Model, Siebel Tools , , Informatica Power Center, Microsoft Project Planning etc.
• Secondary skills : - Siebel E-scripting , VB , XML , Autosys,Control-M , html , dhtml ,XML.
• TECHNOLOGY SUMMARY:
• Database: Oracle 8i/9i/10g/11g, DB2, MYSQL , SQL Server
• Languages:- SQL, PL/SQL, DB2 SQL,C, C , HTML, XML, VB Script ,Unix Shell Scripting etc
• Tools and Utilities Used :- BI Publisher 10g/11g , TOAD for Oracle, TOAD for DB2, SQL Loader, PL/SQL, SQL Navigator, SQL Developer, SQL Assistant , MYSQL Workbench, SQL Plus, Informatica Power Center etc.
• CRM: Siebel Public Sector 8.2.2.0 , Siebel Hospitality 8.1.1.2, Siebel Consumer Goods 7.8, Siebel eFinance 8.0.0.2, Siebel eFinance 7.0.5.6 Call Center 7.7
• Operating Systems: Windows 8/7/XP/NT/2000, UNIX, Linux , MS-DOS.
• Project Management: - VSS, Tortoise SVN , MSPS, MPP, Project Planning, Calculating SPI/CPI, VSS, share point.

PROFESSIONAL EXPERIENCE:

Confidential

Environment: Oracle PL/SQL, Oracle 11g RDBMS, BI Publisher 11g , MYSQL , TOAD, Unix Shell Scripting, Windows 7, SharePoint, MS Visio, Microsoft Project Plan MPP ,IBM Clear Quest defect tracker , HP QTP 11.0 automation testing etc.

Roles :- Siebel Data Conversion , Oracle PLSQL development , ETL Developer, UI Reporting , BI Publisher 11g

Responsibilities:-

• Interacting with Users, Business Analysts including requirement definition, problem resolution training.
• Preparing Deliverable Expectation Document for DOL IWRS and WIPP Projects.
• Built Data Conversion Architecture, Source-To-Target Mapping Document.
• Involved in Architectural meetings for prepare Data Model and ERD etc.
• Creating interactive reports using Oracle BI Publisher 11g .Integrating BI Publisher with Oracle forms and reports and Crystal reports.
• Automate Data exchange interfaces to process and daily/nightly delta interface feeds from legacy Agency systems.
• Involved in Developing and handling the PL/SQL Packages, Procedures and Database Triggers, Views, Sequences, Indexes, Functions, ER Diagrams, Audit , reporting etc
• Responsible for making decisions on coding standards and documentation.
• Involved in developing ETL Process to Load the Data from Source systems to target Oracle Database using TOAD, SQL Loader Utility tools.
• Involved in tuning and optimizing SQL queries by using quest control tools and manual by EXPLAIN PLAN.
• Built the PLSQL , Siebel EIM batch interfaces to import/purge data for the entities Account, Contact, Profile, Registration, Job Seeker Events, Mass upload of Profile and few other modules
• Data Conversion Expert in analyzing data quality issues , data cleanings and reporting them to client team to fix the data using Oracle Data Cleansing techniques
• Participating in the Client Meetings, coordinate with the client teams of DOL NY, MS,OR
• Involved Analysis, Design, Build Performance Tuning and writing Technical Documentation etc.

Confidential Siebel Public Sector

Environment: Siebel Public Sector 8.2.2.0, Oracle 11g , Linux, TOAD, Putty, FileZila , FTP, JobScheduler, Siebel Tools, OBIEE 11g , Informatica, Oracle BI Publisher 11g .

Roles :- Siebel Data Conversion Lead, Oracle PLSQL development , BI Publisher Developer, ETL Interface Developer

Responsibilities :-

• Interacting with Users, Business Analysts including requirement definition, problem resolution training.
• Preparing DED - Deliverable Expectation Document for Data Conversion Modules.
• Built Siebel Data Conversion Architecture, Source-To-Target Mapping Document.
• Involved in developing and handling the Siebel EIM , Oracle , PL/SQL Packages, Procedures and Database Triggers, Views, Sequences, Indexes, Functions.
• POC and prototype on building reports using Oracle BI Publisher 11g , OBIEE for Incident Reporting , Admissions , Court Orders , Reports modules .
• Involved in developing ETL Process to Load the Data from different sources to target Oracle systems using TOAD, SQL Loader Utility tools.
• Involved in tuning and optimizing SQL queries by using quest control tools and manual by EXPLAIN PLAN.
• Involved in Siebel Architectural meetings for prepare Oracle Data Model and ERD etc.
• Built/used JobScheduler tool to Schedule and automate Siebel Data Conversion process and daily/nightly delta interface feeds to Oracle Database from legacy Agency systems like CJIS, JJIS, ACS Mainframe systems.
• Built Siebel EIM, Oracle PLSQL , Siebel EIM batch interfaces to import/purge data for the entities like Employee, Juvenile Contact Management , Incident Reporting , Admissions , Court Order and few other modules .
• Data Conversion Expert in analyzing data quality issues and reporting them to client team to fix the data using Oracle Data Cleansing techniques
• Created/Modified Business Components, Screens, Views, Applets, MVG Applet, Pick Applets, Pick Lists, Joins, Links, MV Links, Business Object, Calculated fields, etc.
• Extended existing tables by adding new columns
• Participating in the Client Meetings, coordinate with the client team ACS , KPMG.
• Trouble Shooting/Fixing Issues
• Involved Analysis , Design , Build Performance Tuning and writing Technical Documentation etc.

Confidential Siebel Hospitality

Environment: Siebel Hospitality 8.1.1.0, Oracle 11g, Oracle BI Publisher 11g , Siebel Tools, Siebel Configuration , scripting , Workflows , Oracle PLSQL, Unix Shell Scripting, Windows XP , TOAD , Putty , FileZila , FTP .

Roles :- Siebel Configuration , Siebel EIM, Siebel Data Migration Developer, Reports developer, Unix Shell Script Developer, Property Migration Expert using Oracle Business Intelligence tools .

Responsibilities :-

• Interacting with Users, Business Analysts in support of applications including requirement definition, problem resolution training.
• Analysis and Build of Siebel EIM, Oracle PLSQL and ETL Development new enhancements, Change Requests and Production support P2/P3 tickets.
• Built the Oracle BI Publisher 10g reports , Oracle PLSQL , ETL interfaces to import/purge/merge data for the entities like Quotes , Opportunities , Functions , Accounts ,contacts ,Price List , Revenue calculations, consumption , Employee , Positions etc.
• Property Migration BI Reports Expert in App, Support, fix all the data patch related issues after property migration to Siebel CRM Hospitality Application.
• Build and support the Data Patch, CRs, Enhancements related to PLSQL and ETL in ISAC as part of Maintenance team.
• Helping Level 2 support in delivering the Critical/Emergency Production issues on time.
• Created interactive reports using Oracle BI Publisher 10g .Integrating BI Publisher with Oracle forms and reports and Crystal reports.
• SME in Siebel Data Migration Oracle BI Reporting 11g.
• Developed Oracle PL/SQL Packages, Procedures and Functions accordance with the business requirements for loading data into database tables. Responsible for making decisions on coding standards and documentation.
• Designed and developed Informatica mappings to load data from source systems.
• Responsible for writing scripts for Data Staging, Loading and cleanup process.
• Experience in developing various kinds of triggers and used sequences to generate values for surrogate keys in data warehouse tables using Before Insert triggers.
• Created SQL Loader scripts to load data into temporary staging tables.
• Created scripts for Views, Materialized Views and Partitioned tables.
• Created/Modified Business Components, Screens, Views, Applets, MVG Applet, Pick Applets, Pick Lists, Joins, Links, MV Links, Business Object, Calculated fields, etc.
• Extended existing tables by adding new columns
• Developed test cases and Involved in Unit testing and system integration testing.
• Responsible for Analyzing and Implementing the Change Requests
• Monitoring day-to-day Process for different Data Loads and resolving Issues.
• Created complex stored procedures, views, SQL joins and scripts.
• Involved in Maintenance, Building, Testing, Debugging, Performance Tuning and writing Technical Documentation.

Confidential Siebel Consumer Goods

Environment: Siebel Consumer Goods 7.8 ,Oracle 11g, Siebel Actuate Reports, Siebel Tools, scripting, Siebel Workflows, Windows XP , TOAD , Putty

Roles : Optima Project Offshore Team Lead, Oracle Performance Tuning Project Offshore Lead, ETL Development Specialist, Unix/PLSQL Development , Production L3 Support specialist etc.

Responsibilities

• Offshore Siebel Development Team Lead.
• Offshore Technical Lead for JFM project with 6 team members.
• Offshore coordinator for Performance Tuning project, ETL Data loads.
• Build reports using Siebel Actuate reporting tool for Siebel Database Archival project.
• Used Oracle PLSQL, ETL to import/purge Accounts , Account Team , Products , Plans , Promotions, Activities, Price List , Sales Volume Planning Data ,Base Volume Planning , Fund Forecast , Data Allocation Aggregation techniques
• I have build Siebel Interfaces , Oracle PLSQL packages, Stored Procedures, ETL Config/IFB files, Unix Shell scripts, batch files, Control-M Setup etc.
• Project Management peer review ownership, MSPS, GDD, team hours, WSR, VSS providing all process related documents as per compliance, attending Audits etc.
• Developed stored procedures and complex packages using PL/SQL and Shell programs.
• Developed triggers, packages, procedures and functions using PL/SQL.
• Worked on analyzing Explain plans for various Sql's and analyzed AWR reports to improve the performance of the database applications.
• Worked on developing stored procedures for database administrative tasks and database triggers to implement database auditing and to store historical data.
• Involved in Developing and maintaining control files for SQL Loader to load data from flat file into database tables.
• Worked on testing several 11g features in Oracle and upgraded several instances from 10g to 11g.
• Involved in tuning and optimizing SQL queries by using quest control tools and manual by EXPLAIN PLAN.
• Worked on moving data from Production to lower environments for various testing cycles using Oracle data pump and also refresh the UAT and Test environments with Prod data.
• Worked on Access control by creating various database roles, setting up profiles to control schema level and table level permissions for the users from different groups.
• Worked on automating database statistics collection at object level and schema level while loading the data into Data warehouse to run the process without any issues.
• Handled L3 Production Support activities.
• Oracle capability trainer for Oracle 7.8, 8.0, Oracle ETL SME at Accenture India.
• Built 3 reusable tools which are used across Accenture 'ARTL -Accenture Reusable Tool Library'
• I Oracle Objects Validator Tool
• II Siebel View/Responsibility Matrix Loader Tool
• III Siebel EIM/Unix Logs Monitoring Tool
• Received MVP Award from Procter and Gamble CEO during offshore visit for doing multiple roles in P G Optima Project and managing multiple projects as offshore Oracle development lead.

Confidential Siebel Consumer Goods

Environment: Siebel Consumer Goods 7.7, Siebel Tools, Oracle 11g/10g, Toad ,SQL Server, Windows XP

Roles : Oracle Interface Developer, PLSQL developer, Production Roll Out Activities Specialist etc.

Responsibilities

• Siebel EIM and Oracle PLSQL Developer.
• Analysis and Build of SQL/PLSQL and ETL Development for Release Specific Interfaces.
• Development, Testing, Deployment and Maintenance of the ETL Roll Out Oracle Interfaces for the Specific Release etc.
• Interacting with Client regularly for Roll Out activities and for data specific issues, Monitoring Control-M Chains daily etc. ETL capability trainer for Siebel 7.8, 8.x, Siebel EIM SME at Accenture.
• Understanding customer business process and requirements.
• Worked on advanced PL/SQL concepts like Bulk collect, PL/SQL tables and Dynamic SQL for DML operations for better performance.
• Identified several SQL and PL/SQL bottlenecks using PL/SQL Profiler package DBMS PROFILER , explain plan, auto trace and tuned them to suit SLA.
• Interacting with Users, Business Analysts in support of applications including requirement definition, problem resolution training.
• Used Oracle Tools to customize the Applications according to Customer requirements
• Created/Modified Business Components, Screens, Views, Applets, MVG Applet, Pick Applets, Pick Lists, Joins, Links, MV Links, Business Object, Calculated fields etc.
• Extended existing tables by adding new columns
• Used User Properties to avoid scripting.
• Involved in Testing, Debugging, Performance Tuning and writing Technical Documentation.
• Handled L3 Support activities.

Confidential Siebel Financial Sector

Environment: Siebel Finance , DB2 , Oracle 11j/10g, ETL Informatica 7.6 , Tools, SQL Server, Windows XP, Siebel Financial 8.0, Siebel eFinance 7.0.5.6

Roles : ETL Development Lead , Upgrade ETL specialist, PL SQL development, Backup Application DBA

Responsibilities

• Siebel ETL Team Lead for WACE2UPG project at onsite/offshore and primary responsibility for ETL setup and automation of ETL daily and monthly loads.
• Involved in Siebel upgrade activities like Siebel EIM setup, Automation of ETL Siebel Interface Loads, DB setup, testing, deployment, oracle interface data loads to Siebel Consumer Goods 8.0.0.2.
• Primary Responsibility includes setup and support for production and Dev/Test environments Siebel EIM Batch interfaces.
• Supporting Testing/Release specific data loads.
• Created Materialized Views and partitioning tables for performance reasons.
• Involved in testing PL/ SQL programs, UNIX shell scripts required for maintaining the data Models
• Involved in quality assurance of data, automation of processes, programming for data manipulation validation of programming, and presentation of results.
• Preparing documentation for requirements, design, install and Unit testing.
• Tuning of stored procedures developed business logic in database layer using PL/SQL.
• Modifying existing ETL setup for performance improvement, process cleanup, PL SQL development, writing UNIX shell scripts etc.
• Communication with Client Teams like middle-tier, Autosys scheduling, Informatica support, Atlas MDM Data provider, Client DBA Team B1, CIMs etc.Understanding customer business process and requirements.
• Writing Autosys jobs JIL Job Instruction Language jobs , and automating ETL loads.
• Interacting with Users, Business Analysts in support of applications including requirement definition, problem resolution training.
• Extended existing Siebel EIM, Base tables by adding new columns, and extension of EIM mapping.
• Involved in Siebel Testing, Debugging, Performance Tuning and writing Technical Documentation.
• Level 5 24 7 Production Support .

Confidential

Environment: Siebel Finance 7.0.5.6, ETL Informatica 7.1.4 , Oracle SQL Loader , Siebel Tools, DB2 , SQL Navigator, SQL Developer , TOAD , Windows XP.

Roles : Siebel EIM Developer Primary ,Siebel EIM Upgrade specialist , Siebel Configuration Controller Backup Role for Siebel Server Administrator.

Responsibilities

• Siebel EIM/Interface Developer , Oracle Maintenance and Support Developer
• Involved in Siebel Upgrade activities like ETL setup , DB setup ,Migration of Siebel EIM Scripts.
• Primary Responsibility includes support for production environment's Oracle PLSQL/ Siebel Batch interfaces,
• Modifying existing ETL setup for performance improvement, process cleanup, PL SQL development, Unix, shell scripting etc.
• Primary Responsibilities includes support for Production Environment, Data Migration Activities .i.e. Table Changes, Running Informatica Data Transfer Jobs, Application Administration, Release specific activities like code migration etc.
• Involved in testing Siebel EIM. PL/ SQL programs, UNIX shell scripts required for maintaining the data Models
• Developed VB and PL/SQL based generic transaction system and batch processing system.
• Involved in quality assurance of data, automation of processes, programming for data manipulation validation of programming, and presentation of results.
• Preparing documentation for requirements, design, install and Unit testing.
• Tuning of stored procedures developed business logic in database layer using PL/SQL.
• Writing Autosys jobs JIL Job Instruction Language jobs , and automating ETL loads.
• Interacting with Users, Business Analysts in support of applications including requirement definition, problem resolution training.
• Created/Modified Business Components, Screens, Views, Applets, MVG Applet, Pick Applets, Pick Lists, Joins, Links, MV Links, Business Object, Calculated fields, etc.
• Extended existing tables by adding new columns
• Involved in Testing, Debugging, Performance Tuning and writing Technical Documentation.
• worked on Level5 24 7 Support with pager alerts.
• Shared Success Award, Appreciation from Client for getting Siebel EFinance Application to work with Informatica and saving around 35-40 Hours time in Siebel EIM Full Loads.
• INFOSYS Enterprise Solutions ESTEEM Award, received ES ESTEEM MVP Most Valuable Player Award in Developer role category in FY 07-08, from N R Narayan Murthy on March 27th 2008.