SUMMARY

• Overall 6+ years of IT experience which includes analysis, design, development, testing, implementation, deployment and maintenance of Oracle Data Integrator .
• o End to end implementation experience on various versions of Oracle Data Integrator ( ODI 10g & ODI 11g ).
• Extensive experience with ODI tools - Topology, Designer and Operator.
• o Expertise in Data warehousing concepts such as dimensional modeling, Star Schema and snowflake schema, Dimensions and facts identification .
• o Hands on experience with Data Extraction, Transformation and Data Loading in Data Warehouse environment.
• Designed and developed Oracle Stored Procedures and Packages to meet data integration and processing for high volume data warehouse instances.
• o Knowledge of BI tool - OBIEE - OBIEE RPD and Analytics .
• o Experience in Unix Shell scripts to generate reports.
• o Experience in middleware coding using SOA BPEL .
• Understanding in Service-Oriented Architecture and its related technologies like BPEL, Web Services, and WSDL .
• Worked on Oracle SOA Suite SCA composites and components like BPEL process, Mediator, Business Rules, Human Workflow, and activities like Assign, Invoke, Pick, Receive, Switch, Flow, Java embedding, Email, Wait, While, Validate etc. in JDeveloper.
• Experienced in communicating with business to gather/clarify requirements and provide data warehouse solutions.
• Team player with excellent communication and problem solving skills.
• o Experienced in design, development, testing and implementation activities during the project life cycle as well as production support activities after go live.
• o Ability to multi-task and work independently .

TECHNICAL SKILLS:

ETL Tools: ODI 10g, ODI 11.1.1.4

Tools: Toad, SQL Developer, PL/SQL Developer, JDeveloper

BI Tools: OBIEE 11G

WEB Tools: H TML, JSP, JSF, Java Script

Databases: Oracle 11g/10g/9.x,DB2

Languages: C, C++, Java, COBOL

PROFESSIONAL EXPERIENCE

Confidential

Sr. ODI Developer & Admin/PLSQL /UNIX Developer/Onsite Coordinator/OBIEE

Environment: Oracle Data Integrator 11.1.1.6, Oracle Business Intelligence Enterprise Edition (OBIEE) 11.1.1.5.0 , Oracle 10g/11g, LINUX, SQL Developer.

• Understand the business requirement and preparation of Business Requirement specification.
• o Worked with the Project Manager and Data Analyst.
• Assisted the designer in designing by doing source data analysis, rectifying the requirement documents, creating source to target mappings.
• Provided extended production support based on the demand and complexity of the issue.
• Involved in requirements gathering, designing functional and technical specifications for reporting needs.
• Worked with Business Analyst(s) and Reporting and Information Delivery Architect to design solutions that simultaneously meet both functional and architectural requirements.
• o Developed Calculated Measures and assigning these Aggregation levels based on Dimension Hierarchies.
• Did error analysis for continued improvement of the system by catching data anomalies and code issues.
• Created design to handle huge amount of data and perform business related operations.
• o Set up the Topology including physical architecture, logical architecture and context.
• o Created new models for the data sources - flat files, XM L, Oracle, and SQL Server.
• o Did reverse engineering for the data sources and targets.
• Developed interfaces to load the data from flat files, xml and oracle database to Oracle target DB.
• Developed interfaces for loading the lookup and transactional data.
• Install, configure, and administer the ODI platform for maximum utilization and throughout.
• o Supported technical team members in complete implementation of ODI.
• o Created users and provided different level of access.
• o Created ODI packages, scenarios using interfaces, variables, procedure o Used ODI commands like ODIFile Move, odiFileAppend, etc o Performance tuned the ODI interfaces.
• o Deployed ODI scenarios using smart export.
• Improved performance by setting the array size, batch size, ODI Init heap and ODI Max heap.
• Co-ordination with offshore to understand the requirement and work on the solution.
• o SQL and PL/SQL programming for ODI and oracle.
• o Created PL/SQL stored procedures, functions and triggers.
• o Analyzed data and fine-tuned the code to handle huge data.
• o Created shell scripts and updated the scripts as per the requirement.
• o Developed scripts for inbound and outbound of the data on servers.
• o Unit testing of codes. o QA & UAT support and bug fixing.
• Deployment of ETL / UNIX codes to different environments.
• o Involved in configuring OBIEE (Multi User Development) MUD.
• o Conducted code reviews and planned the knowledge transfer to client.
• o Deployed OBIEE 11g RPD and Web Catalog by using Web logic Enterprise Manager.
• Implemented MUDE (Multi User Development Environment) in OBIEE.
• Involved in Root Cause Analysis of issues and day-to-day production support.
• o Involved in release meetings and created release notes.
• Interacted with BI team during design and development of facts and dimensions to accommodate all the reporting requirements.

Confidential

ODI/PL/SQL/SOA/UNIX Developer

Technology: ODI 10g, JDeveloper 11g, PL/SQL, UNIX Shell script,

Environment: Oracle 10g/11g, Windows XP.

Responsibilities:

• Understand the business requirement and preparation of Business Requirement specification. o Technical ETL & Middleware Design preparation.
• Set up the Topology including physical architecture, logical architecture and context.
• o Created new models for the data sources - flat files, Oracle.
• o Did reverse engineering for the data sources and targets.
• Worked with the Project Manager and Data Analyst.
• Assisted the designer in designing by doing source data analysis, rectifying the requirement documents, creating source to target mappings.
• Co-ordination with offshore to understand the requirement and work on the solution.
• o Developed interfaces to load the data from flat files, oracle database to stage and from stage to Oracle target DB.
• SQL and PL/SQL programming for ODI and oracle.
• o Created PL/SQL stored procedures, functions and triggers.
• o Developed interfaces for loading the lookup and transactional data.
• o Created shell scripts and updated the scripts as per the requirement.
• o Developed scripts for inbound and outbound of the data on servers.
• o Created shell scripts and updated the scripts as per the requirement.
• o Middleware coding using SOA (BPEL).
• Created connection pools, data source connections, JNDI names in application server.
• o Created Quartz scheduler to schedule the web services.
• o Unit testing of codes. o QA & UAT support and bug fixing.
• Deployment of ETL / Middleware / UNIX codes to different environments.
• Creating design documents and technical document.
• Prepared web- pages using JSP to give demo to client with the mock application.