SUMMARY

• Over 7 years of experience in Information Technology in designing, developing, architecture, administration and implementation of Data Warehouse Applications and Fusion Middle ware applications under different environments. Core focus on SOA, OSB, ODI, JAVA and SQL.
• Strong experience in design and development of Oracle Fusion Applications using Fusion technology stack which includes SOA Suite 11g, Oracle Data Integrator 11g, Weblogic server 11g and Jdeveloper.
• Have good knowledge in building BPEL processes and SOA composites.
• Travelled Confidential (National Oilwell Valco) client locations in US and Dubai and successfully implemented SOA Suite for various VCE integrations
• Experience in various domains like Retail and Manufacturing.
• Extensively worked with large Databases in Development, Testing and Production environments.
• Strong understanding of the principles of Data warehousing, Fact Tables, Dimension Tables, star and snowflake schema modeling.
• Extensive experience in writing advanced Oracle PL/SQL programs by using Collections, Records, Objects, Packages, API’s, Procedures and Functions..etc.
• Analyzed the Business requirement for Oracle Data Integrator and mapped the architecture and used ODI for reverse engineering to retrieve metadata from data storage and load it to the repository.
• Used Oracle Data Integrator Designer (ODI) to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• Oracle Data Integrator (ODI) reduce the dependency on Excel and other proprietary tools for data entry and reporting, and provide property and department level budgeting/forecasting so as to produce a consolidated budget and forecast.
• Primary responsibility include but not limited to installing and configuring the Oracle Data Integrator (ODI) software tool in a three - tier environment and performing periodic upgrades, performing source-to-target mappings, storage capacity planning, developing ETL.
• Good knowledge on RDBMS concepts. Specialized in developing stored procedures, functions, packages and database triggers using Oracle SQL and PL/SQL to improve query performance.
• Very good understanding of Business Intelligence and Data Warehousing Concepts with emphasis on Analytical Reports and ETL.
• Well experienced in building Fusion Web Applications using Oracle ADF.
• Expertise in deploying and managing applications in Oracle Weblogic Server 11g.
• Have good knowledge in Java/J2EE technologies.
• Strong analytical and problem solving skills along with good Inter personal skills.
• Established and maintained productive working relationship with Management, Clients and Team Members. Self-starter, entrepreneurial, highly motivated team- player with excellent communication / problem-solving skills. Quick learning ability vis-à-vis new technology. Easy adaptability to new environments.
• Received ‘Certificate of Appreciation’ for my contribution to VCP(Value Chain Planning) from Vice President of ORACLE.

TECHNICAL SKILLS

Fusion Stack: Oracle SOA Suite 11g, Oracle Data Integrator (ODI) 11g, Oracle ADF 11g

Web/Application Servers: Tomcat 5.0, Weblogic Server 11g(10.3.1)

Languages: SQL,PLSQL,Java,C

J2EE Technologies: JDBC, Servlets, JSP, Struts 1.2

Scripting: JavaScript, VB Script

Databases: ORACLE 11i/10g,9i, My Sql 4.0.x,SQL Server,MS Access

OLAP: Oracle Data Integrator(ODI)

IDE: My Eclipse 3.0, Oracle Jdeveloper 11gOperating System Windows 7, Linux

Packages/Tools: MS Office Suite, Oracle Open Office

Database Tools: Toad, SQL Developer, SQL Loader, SQL Plus

ERP Functional: Oracle Fusion SCM - Advanced Planning and Scheduling

PROFESSIONAL EXPERIENCE

Confidential, HOUSTON, TX

Senior SOA Consultant

Responsibilities:

• Extensively used ETL to load data from Oracle, XML files and flat files.
• Worked on complex mappings in ODI to map the source xml data with Oracle Data Servers
• Designed data integration using Oracle Data Integrator (ODI) by setting up sources and targets using ODI Topology Manager, creating Designer models, developing integration interfaces.
• Developed different procedures, Packages and PL/sql program Units in Oracle Database.
• Configured Oracle Data integrator (ODI) Master Repository & Work Repository on Oracle Database.
• Analyzed the Business requirement for Oracle Data Integrator and mapped the architecture and used ODI for reverse engineering to retrieve metadata from data storage and load it to the repository
• Used Oracle Data Integrator Designer (ODI) to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database
• Primary focus and/or development efforts were in the reengineering of the ETL processes using the Oracle Data Integrator (ODI).
• Developed various ODI interfaces to load data from Flat file & Relational Sources to Oracle Data Mart.
• Developed SOA Composite to consume the messages from JD Edwards EnterpriseOne ERP
• Implemented Canonical mapping for Sales Order attributes and published the Transformed Canonical payload into Oracle Transport Management JMS Queues using SOA Composites.
• Developed Logger Implementation in SOA to capture each and every success and failure transaction in between JDE and OTM.
• Implemented Email Notification Service for each and every Success and Failure transaction along with the attachment.
• Developed BPEL Components to Call JDE BSSV for every OTM request to update the JDE fields.
• Collaborated with customers in resolving mission critical issues thereby ensuring high productivity.
• BPEL processes to orchestrate the flow of data from source systems to target
• Developing unit test cases using test frame works like junit in each development cycle.
• Integration testing, System testing of the product and final delivery

Confidential, Redwood City, CA

Senior ODI ETL Developer

Responsibilities:

• Developed several work flows and models in ODI
• Created interfaces which transform data from Hyperion to Demantra and vice versa.
• Log file generation to get the execution details
• Enabled Mail communication channel which will send the log detail as an attachment to recipient after flow completion
• Analyzed the performance of the SQL queries and created the scripts for indexes.
• Identifying the poor performing SQL’s & PL/SQL blocks and fixing the tuning issues.
• Worked along with business analysts, developers, management professionals and as well as with business users from various locations of customer to gather requirements.
• Experience in Dimensional Modeling such as star schema, snow flake schema, creating Facts, Dimensions and Measures.
• Experience with Business systems such as Manufacturing, Sales, Inventory and Order Management.
• Analyzed the Business requirement for Oracle Data Integrator and mapped the architecture and used ODI for reverse engineering to retrieve metadata from data storage and load it to the repository.
• Used odiparam.bat file for updating recently encoded password for master repository and used startscen.bat file to start the scenario using agent. These scenarios are finally deployed to production.
• Applied slowly changing dimensions (SCD) in various Mappings to load data from source to target and maintained current and historical data on year wise in all brand dimensions.
• Analyzed Session log files in operator navigator to resolve errors in mapping and managed session configuration
• Used Oracle Data Integrator Designer (ODI) to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• Worked on Job Master for performing Change data capture.
• Worked on Slowly Changing Dimension (SCD).
• Prepared technical design documents
• Primary responsibility include but not limited to installing and configuring the Oracle Data Integrator (ODI) software tool in a three-tier environment and performing periodic upgrades, performing source-to-target mappings, storage capacity planning, developing ETL.
• Primary focus and/or development efforts were in the reengineering of the ETL processes using the Oracle Data Integrator (ODI).
• Used ODI Designer for importing tables from database, reverse engineering, to develop projects, and release scenarios.
• Implemented Synchronous and Asynchronous Change Data Capture (CDC) techniques.
• Used Knowledge modules to achieve client requirements such as connecting to specific technology, extracting data from it, transforming the data, checking it, integrating it.
• Validate the required data at the database level by using tool Toad.
• Used Toad for analysis and maintained Database using DDL’s, DML’s
• Deploying and testing ODI Demantra jar in Weblogic Server

Confidential, Redwood City, CA

Senior ODI/SOA Developer

Responsibilities:

• Understanding the existing product functionalities, new design requirements and developing the technical design documents from functional requirements.
• Analyzing the functional design documents, finding design issues, reporting to product management and also proposing feasible solutions.
• Involved in full SDLC from design requirements to unit testing while developing new features in major releases.
• Developed complex UIs using Oracle ADF and java/j2ee technologies.
• Developed business logic using ADF Business components.
• Also developed stored procedures for business logic using Oracle PL/SQL and SQL.
• Analyzed the performance of the SQL queries and created the scripts for indexes.
• Identifying the poor performing SQL’s & PL/SQL blocks and fixing the tuning issues.
• Played a major role as an integration developer by integrating Oracle products with third party products using web services developed with Oracle SOA suite.
• Designing of service interfaces and integrations with SOA.
• Developed bpel process to call odi async job
• Developed odi interface which will load data from different source like flat file,xml and oracle to staging/interface tables.
• JMS adapter is responsible to store the data coming form odi staging/interface tables.
• JMS adapter will poll the records and do the required validations on staged data.
• Collaborated with customers in resolving mission critical issues thereby ensuring high productivity.
• BPEL processes to orchestrate the flow of data from source systems to target
• Developing unit test cases using test frame works like junit, selenium and open script in each development cycle.
• Creating Procedures, Interfaces and Packages in Oracle Data Integrator 11g to migrate data from source system to target.
• Integration testing, System testing of the product and final delivery.

Confidential, Redwood City, CA

Senior ODI ETL Developer

Responsibilities:

• Developed several business flows and models in ODI
• Created Macros in Microsoft excel which will generate the CSV files
• Developed Parallel Process in ODI using OdiWaitForChildSession tool.
• Customized ODI KM like LKM and IKMs
• Prepared technical design documents
• Involved in implementing new module using Java, Pl/Sql
• Primary responsibility include but not limited to installing and configuring the Oracle Data Integrator (ODI) software tool in a three-tier environment and performing periodic upgrades, performing source-to-target mappings, storage capacity planning, developing ETL.
• Primary focus and/or development efforts were in the reengineering of the ETL processes using the Oracle Data Integrator (ODI).
• Used ODI Designer for importing tables from database, reverse engineering, to develop projects, and release scenarios.
• Implemented Synchronous and Asynchronous Change Data Capture (CDC) techniques.
• Used Knowledge modules to achieve client requirements such as connecting to specific technology, extracting data from it, transforming the data, checking it, integrating it.
• Deploying and testing web services components in Weblogic Server

Confidential, Redwood City, CA

Senior ODI ETL Developer

Responsibilities:

• Extensively used ETL to load data from Oracle, XML files and flat files.
• Worked on complex mappings in ODI to map the source xml data with Oracle Data Servers
• Designed data integration using Oracle Data Integrator (ODI) by setting up sources and targets using ODI Topology Manager, creating Designer models, developing integration interfaces.
• Developed different procedures, Packages and PL/sql program Units in Oracle Database.
• Configured ODI agent and leveraged Knowledge Modules to define workflow and task automation
• Installed ODI, created and configured master, work repositories and the agent
• Analyzed the performance of the SQL queries and created the scripts for indexes.
• Identifying the poor performing SQL’s & PL/SQL blocks and fixing the tuning issues.
• Configured Oracle Data integrator (ODI) Master Repository & Work Repository on Oracle Database.
• Analyzed the Business requirement for Oracle Data Integrator and mapped the architecture and used ODI for reverse engineering to retrieve metadata from data storage and load it to the repository
• Used Oracle Data Integrator Designer (ODI) to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database
• Primary focus and/or development efforts were in the reengineering of the ETL processes using the Oracle Data Integrator (ODI).
• Developed various ODI interfaces to load data from Flat file & Relational Sources to Oracle Data Mart.
• Understanding the developed project in OWB and implemented the concepts in ODI.
• OGG is used ODI with the best possible performance to implement CDC concept.
• Used Knowledge modules LKM, RKM, IKM and JKM and Used Knowledge modules to achieve client requirements such as connecting to specific technology, extracting data from it, transforming the data, checking it, integrating it etc.
• Fixed several customer performance issues in Oracle Database
• Managed and maintain different ODI Versions using ODI Solution
• Developed several business flows and models in ODI
• Worked on several customer enhancements in ODI
• Customized ODI KM like LKM and IKMs
• Tested different business flows
• Prepared technical design documents
• Involved in implementing new module using Java, Pl/Sql
• Deploying and testing web services components in Weblogic Server
• Involved in bug fixing of existing programs and delivery in a short time frame

Confidential

Project Engineer

Responsibilities:

• Responsible for development and design modifications
• Worked on complex mappings in ODI to map the source xml data with Oracle Data Servers
• Primary responsibility include installing and configuring the Oracle Data Integrator (ODI) software tool in a three-tier environment and performing periodic upgrades, performing source-to-target mappings, storage capacity planning, developing ETL
• Resolving day to day production issues.
• Gathering requirements from users to develop interfaces, packages.
• Deploying Scenarios from one environment to other environment.
• Upgrading from ODI 10G to ODI 11G environment.
• Resolving Upgrade issues to make sure daily loads run efficiently.
• Experience in configuring ODI Agent on UNIX server and creating new agents and test them in ODI 11G.
• After Upgrading in Development environment performed export and import
• Experience in Dimensional Modeling such as star schema, snow flake schema, creating Facts, Dimensions and Measures.
• Experience in running RCC (Repository consistency check) to see if master and work repositories are consistence.
• Experience with Business systems such as Sales, Inventory and Order Management.
• Used Interfaces to load data from Flat files, CSV files in to staging area (Oracle) and load in to Oracle data warehouse
• Working closely with Informatica team for performing mapping and data loading which is same as ODI tool.
• Experience in increasing efficiency of data load from source to target by doing performance tuning.
• Analyzed the Business requirement for Oracle Data Integrator and mapped the architecture and used ODI for reverse engineering to retrieve metadata from data storage and load it to the repository.
• Used odiparam.bat file for updating recently encoded password for master repository and used startscen.bat file to start the scenario using agent. These scenarios are finally deployed to production.
• Applied slowly changing dimensions (SCD) in various Mappings to load data from source to target and maintained current and historical data on year wise in all brand dimensions.
• Analyzed Session log files in operator navigator to resolve errors in mapping and managed session configuration

Confidential

Responsibilities:

• Responsible for development and design modifications
• Understanding the existing product functionalities, new design requirements and developing the technical design documents from functional requirements.
• Analyzing the functional design documents, finding design issues, reporting to product management and also proposing feasible solutions.
• Involved in full SDLC from design requirements to unit testing while developing new features in major releases.
• Developed complex UIs using java/j2ee technologies.
• Also developed stored procedures for business logic using Oracle PL/SQL and SQL.
• Played a major role as an integration developer by integrating Oracle products with third party products using web services.
• Contributed immensely to the growth of the team by mentoring new hires.
• Developing unit test cases using test frame works like junit, selenium and open script in each development cycle.
• Always ensured timely delivery with Good quality.