Objective

Seeking Software Engineering opportunities as

ETL Developer / Weblogic Administrator

Professional Summary

• Over 4 years of extensive experience in development of ETL process using Oracle ODI, Oracle Databases and MySQL.
• Excellent proficiency in developing ETL for supporting Data Extraction, Transformation and Loading using ODI/Synopsis.
• Good command of Weblogic Administration that included Install, Configure, Clustering and Web Application Deployment.
• Adept at all ETL Consulting Practices and procedures with expertise in design, development and, testing phases and tools.

Technical Skills

Database: Oracle, MySQL, SQL Server

Languages/Web Technologies: Weblogic, SQL, PLSQL

Operating Systems: Windows, Linux

Tools: ODI, SQL Developer, Eloqua, Siebel

Other Skills

• Strong project people management skills.
• Possess good analytical skills in examining logs and troubleshoot the software bugs.

Professional Experience

Confidential

Title: ODI Developer and Weblogic Administrator

• Install and configure ODI for JDE-VCP integration.
• Install and configure weblogic.
• Creating new Data sources and Tuning Weblogic connection pool.
• Tuning Weblogic JVM's.
• Weblogic clustering and also msc application deployment on weblogic.
• Configuring node manager for weblogic Auto restart, memory dump etc.
• Regenerate the Scenarios with the new directory structure for different interfaces.
• Configure ODI agents for Automated Load execution between VCP, JDE and Demantra databases.
• Interacted with VCP functional Analyst to gather new business and data requirement.
• Migrating data from JDE to VCP and Demantra databases.
• Troubleshoot Load failures.
• Deploy ODI on weblogic , AIA and configure Java Agent
• Encrypt passwords of various endpoints and configure the Agent to detect encryption.
• Provide daily support to Senior Developers.

Confidential

Title: Consultant, ETL Developer

• Interacted with Business Users and Business Analysts to gather new business requirements and to understand existing requirements.
• Developed complex interfaces mappings to load data from various sources into dimensions and facts using ODI Designer.
• Implemented/enhanced different Knowledge Modules Reverse Engineering, Journalizing, Loading, Check, Integration, Service in mappings to load and integrate data from sources to targets.
• Created ODI Packages and Scenarios to execute all the mappings, procedures in desired order.
• Used Security Manager to create users/profiles and ODI Operator to debug/view the execution details of interfaces/packages.
• Converted PL/SQL logic used currently into ODI Interfaces and tuned SQL statements based on the execution plan.
• Enhanced the ODI Package with exception/error handling procedures in order to avoid job failures due to incorrect data in XMLs.
• Implemented the Change Data Capture CDC feature of ODI to minimize the data load times.
• Used Metadata Navigator to analyze the statistics generated by executing mappings and packages.
• Participated in meetings and communicated plans, status and issues to management on a regular basis.
• Environment: ODI 11g, Oracle 11g, SQL, PL/SQL, SQL Server, SQL Developer.

Confidential

Title: Consultant, ODI Developer

• Used Metadata Navigator to analyze the statistics generated by executing mappings and packages.
• Interacted with Users and Analysts for gathering new business requirements and to understand the current requirements.
• Involved in Installation, Configuration and Security setup for Oracle Data Integrator on windows platform across all environments.
• Executed scenarios via predefined schedules or on demand using ODI Scheduler Agent and performance tuned ODI objects.
• Created multiple work repositories for each environment Dev, QA, and Prod .
• Converted PL/SQL logic used currently into ODI Interfaces and tuned SQL statements based on the execution plan.
• Tuned mappings and PL/SQL procedures by defining hints, degree of parallelism, tweaking loading parameters and executing them in parallel threads.
• Interacted with CTS OBIEE team on Data Mapping, Table design and BI Reports.
• Setup Load failure notifications and trained CTS support team in fixing load issues and rerunning the loads.
• Completed Documentation of design, development and other details of every Interface designed.
• Trained offshore team to support team on ODI.
• Configured the testing environment and process to export/Import ODI Objects into the Development/Production Execution environment.
• Participated in meetings and communicated plans, status and issues to management on a regular basis.
• Environment: ODI 11g, Oracle, SQL Server, SQL Developer, PL/SQL

Confidential

Title: Data Analyst

• Configured the tested environment and process to export/Import ODI Objects into the Development/Production Execution environment.
• Pulled Marketing Data Group on Earth Observations GEO from SIEBEL and ELOQUA to export in to Excel.
• Formatted reports in to Excel as per Siebel loader format.
• Analyzed the given client data and validated the given information for accuracy.
• Responsible for manipulating, transferring and managing data in EXCEL.
• Uploaded data NA, LTAM, EMEA, and APAC in to Siebel Upload Tool.
• Solved the Siebel data error to ensure that the Data load successfully in Siebel.
• Developed and maintained detailed monthly and quarterly Marketing reports of all field programs analyzed the key components of each campaign, including lists, offers, messaging and creative.
• Tracked all campaigns via marketing and sales Siebel Tool.
• Implemented CRM/Marketing Automation industry trends and best practices.
• Responsible for Cleansing of duplicate records and creating an opportunity for the approval of product with the help of INSIGHT TOOLS directly to the representatives to deal with the McAfee reseller's partner for the further approval of product license.
• Knowledge in Excel VLOOKUP, HLOOKUP, PIVOT TABLE SUBTOTAL and Excel Formulation .