Sr. Odi Developer Resume
Utica, NY
SUMMARY:
- Over 8+ years of experience in Software Development mainly focusing on Business Intelligence, Data Warehousing and Database Applications including Analysis, Design, Development, Testing and Support.
- Extensive experience as an ODI Developer working on various versions including ODI 10g/11g
- Expert level oracle developer developing efficient and complex SQL, PLSQL Scripts taking performance related best practices into consideration.
- Proficient in Data Warehousing, Dimensional modeling using star schema/ snow flake schema modeling, Fact and Dimension identification.
- Expertise with all ODI graphic tools - Topology, Security Manager, Designer and Operator.
- Hands on experience working with ODI Knowledge Modules LKM, IKM, RKM, JKM and CKM. Customized versions for the existing ODI Knowledge modules which can be reused in data integration projects.
- Installation and Configuration of ODI / OBIEE 11G and 12C.
- Expertise in developing ODI objects like Project, Model, interfaces, Yellow interfaces, Procedures, Filters, Models, Load plans and generating ODI scenarios.
- Excellent experience in implementing Change Data Capture (CDC), Slowly Changing Dimension (SCD) type 1, type 2, type 3 using ODI.
- Expertise in building Metadata Repositories using Physical layer, Business Model and Mapping layer, Presentation layer with the Oracle BI Administration tool.
- Working experience in Oracle BI tools (OBIEE/OBIA) and Strong experience in designing data warehouses using Oracle data integrator and Informatica.
- Working experience in Creating ODI packages, scenarios using interfaces, variables, and procedures and Topology including physical architecture, logical architecture.
- Proficient in RPD designing, developing and generating dashboard Reports, Business views, Unit Testing, Quality Assurance, Project Planning and Documentation.
- Working in design, development and configuration of RPD, Dashboards, Reports, Analysis & Interactive Reporting, OBIEE 11g new functionality and implemented Filters, Scheduled Reports, Prompting, Drill Thru, Multi-lingual reporting, Performed XML Manipulation.
- Design reports and dashboards using OBIEE11G dimensional hierarchies. Design And Develop ad-hoc queries, reports and dashboards.
- Developed data migration approach and strategies.
- Drive data migration strategy and process to enable quality data delivered without any delay.
- Advice and assist in data extraction, data cleansing, data mapping , data harmonization, data enrichment, data consolidation, data loading and data reconciliation.
- Expertise in Informatica Power Center Mapping Designer, Workflow Manager, Workflow Monitor, Repository Manager, Informatica Developer and Data Transformation tools.
- Extensively used ODI to perform ELT from heterogeneous sources using ODI tools - Security Manger, Topology Manager, Designer and Operator.
- Extensively worked on database up gradation and data migration from other systems to oracle.
- Experienced in developing and implementing Dimensional Hierarchies, Level Based Measures, Aggregation Rules, Time Series Functions, and Rank Functions.
- Expertise in database Performance Tuning by implementing Parallel Execution, Partitions, materialized views with query rewriting, creating appropriate indexes, usage of hints, re-building indexes and also used the Explain Plan and SQL Tracing.
- Skilled at creating and scheduling Agents using Oracle BI Delivers to provide real-time, personalized and actionable intelligence data to subscribers.
- Gave a scope for enhancements and Change management in place with agile methodology.
- Technical Experience in developing Informatica Mappings/Mapplets and Tasks using various Transformations for ETL of data from Multiple Sources to Data Warehouse.
- Extensively used BI Publisher for generating various types of BI-pub reports that are sent to customers using several templates/notices that are sent to applicants in BI Publisher using RTF templates.
- Experience in configuring interactive Dashboards with drill-down, drill across capabilities using Filters and Dashboard Prompts, Setup groups, access privileges, Metadata Objects and Web Catalog Objects and guided navigation links.
- Excellent knowledge and experience in data warehouse development life cycle, designing data marts, requirement analysis, dimensional modeling, and implementation of STAR, Snowflake schemas, Incremental loads, Change Data Capture (CDC) and slowly changing dimensions.
- Exclusively worked on different flavors of UNIX /Linux and Windows operating systems and good Experience in UNIX shell scripting.
- Extensively involved in developing Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
- Good knowledge in Oracle tools like SQL*Plus, SQL Loader, SQL Developer using TOAD in secure databases.
- Highly motivated team- player with excellent communication / problem-solving skills and quick learning ability.
SKILL SET:
Database: Oracle 9i/10g/11g/12c, MS SQL Server, DB2
ETL Tool: ODI 11g, 10.1.3 x, Informatica Power
Data Modeling: Dimensional modeling, Star Schema, Snowflake Schema, ERWIN, FACT and Dimensions Tables, Physical and Logical Data Modeling
Programming Languages: SQL, PL/SQL, C, UNIX Shell Scripting, Perl Scripting, Transact SQL
Database Tools: TOAD, SQL Developer, SQL Server Management Studio, Microsoft Visio
Developer Tools: Reports Builder 6i/10g, Forms Builder 10g, OBIEE 10g, BI/XML Publisher
Operating Systems: Red Hat LINUX, Sun Solaris, HP-UNIX, IBM AIX, MS DOS, Windows XP/7
Solutions Area: Sales, Marketing, Customer Relationship Management (CRM), Financial Management (Banking & Insurance), Inventory Management, Enterprise Performance Management
Ticketing Systems: SYSAID, Rational Rose, Service Manager
Version Control Software: Virtual Source Safe, PVCS, Rational Clear Case
PROFESSIONAL EXPERIENCE:
Confidential, Utica, NY
Sr. ODI Developer
Responsibilities:
- Worked closely with Business Analyst in understanding the Analytical requirements and generated reports as per the user specifications.
- Created master and work repositories for ODI by coordinating with Oracle DBAs.
- Involved in creating database connections, physical and logical schema using the Topology Manager.
- Extensively worked on creation of packages, construction of data warehouse and data marts, and synchronization using ODI.
- Using datasets and UNION operations in ODI interfaces, both the error tables are combined and loaded into the target error table.
- Responsible for all the data migration jobs (FTS and OTC), which include preparing all the relevant templates, setting up LSMW based on the requirements (Coding required), data uploading to Q and P system.
- Involved in various Admin tasks such as setting up security, new users and configuring ODI on new machines.
- Promoted all these projects to UAT and performed Unit testing on various possible test case scenarios and then moved to Production.
- Documented each and every detail that is implemented in ODI objects such as interfaces, procedures, variables, packages.
- Mapped different data sources to the Physical Layer and created the Business Model and Mapping Layer (design of hierarchies, dimensions, and aggregates) by defining appropriate joins, calculations, dimensions and measures in the repository
- Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables.
- Worked extensively on Physical Layer, Business Layer and Presentation Layer to get new column as per BU.
- Created and Modified Answers and Dashboards as per user requirement.
- Created union reports to design reports as per business requirement.
- Worked on drill downs, pie-charts, bar diagrams etc on reports to create Program Manager level dashboard pages.
- Worked aggressively on dashboard prompts related to months and dates.
- Enhanced performance by requesting Aggregate tables, Indexes and managing Cache after Benchmarking performance tuning strategies with business model-level calculations versus database level pre-computations and aggregations.
- Implemented CDC through ODI Journalization Knowledge Modules .
- Designed and developed data level security on various reports by creating session variables in the repository.
- Conducted various workshop sessions with super users to bring them up to speed on subject areas, reports, dashboards and also helped them to understand the limitations of the System.
- Involved in performance tuning of various integrations and database by creating indexes on the tables for faster retrieval of the data, Used hints in select statement for improving the performance during extraction.
- Provided updates and status and issues to the project team.
- Worked on ticketing systems for incident resolution and Change requests as per priorities.
- Worked on Agile methodology to keep the whole team involved in the project in terms of communication.
- Responsible for data modeling using Erwin, Star Schema Modeling and Snowflake modeling, FACT and Dimensions tables, physical and logical modeling.
- Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes.
- Performed Query optimization, debugging, and performance tuning for improving performance.
- Created complex master detail reports using Reports Builder 10g. Generated dynamic reports based on parameters using lexical Parameters and After Parameter Triggers.
- Extended the functionality of existing Oracle Reports as per Business requirements by editing code logic, adding new columns, parameters and Program Units.
- Migrated forms to the middle ware, compiled them, and deployed them under custom menus for easy accessibility.
- Provided production support by monitoring the processes and Jobs running daily.
Environment: Oracle Database 12c/11g, Oracle Data Integrator (ODI) 11g, Reports Builder 10g, SQL, PLSQL, MS Visio, ERWIN, TOAD, Windows 7, Visual Source Safe(VSS).
Confidential, Miami, FL
Sr. ETL Developer
Responsibilities:
- Involved in Requirement gathering sessions for the new database and application design and development.
- Authored various documents including BRD(Business Requirements), Technical Specification and Conversion/Interface Mapping Documents and Test Script Scenarios,
- Requirements Gathering and Business Analysis Project coordination, End User meetings.
- Created infrastructure to develop full software development lifecycle.
- Involved in upgrade of ODI 10G to 11G by checking compatibility issues and decommissioned features.
- Translated the business requirements into technical specifications to build the Enterprise data warehouse.
- Responsible for Business Requirements, Technical Design, and Source to Target Mappings, development utilizing ODI, development of unit test plans and execution of unit/integration test cases, development and coordination of ETL deployment plans.
- Used ODQ for data cleansing and Analysis.
- Implemented CDC through ODI Journalization Knowledge Modules .
- Responsible for developing, support and maintenance for the ELT (Extract, Load and Transform) processes using Oracle Data Integrator (ODI).
- Installation & configuration of Oracle Data integrator and responsible for configuration of Master and Work Repository on Oracle.
- Responsible for Design, Develop and implement multiple ODI interfaces.
- Created several ODI Interfaces to implement Business Logic with ODI Graphical (Designer, Topology Manager, Operator, Security Manager) & Knowledge Modules (Reverse-engineering, Journalizing, Loading, Check, Integration and Service)
- Extracted data from various sources including Oracle, SQL Server using ODI.
- Responsible for issue resolution and performance tuning of ODI Interfaces.
- Used Topology Manager to create database connections, schemas, etc.,
- Migrated Code from Development to Testing to production.
- Creating and maintaining the full lifecycle of ETL (interfaces / processes / flows)
- Created Views, wrote functions, Procedures, Packages in PL/SQL for ODI process.
- Created and optimized SQL queries for better performance.
- Identified and fixed bottlenecks and tuned the complex ODI Interfaces for optimized performance.
- Involved in Unit testing, User Acceptance Testing and System Testing to verify accuracy and completeness of ETL process.
- Responsible for the all the interfaces issues like connectivity, integration, applications health check, proxy, firewall, encryption, archiving, migration and environmental issues.
- Involved in software program design, development, logical data modeling and physical data modeling using ERWIN and Visio.
- Developed PL/SQL code to implement business rules using cursors, ref cursors, procedures, functions, Triggers, object types, collections, Dynamic PL/SQL and packages.
- Created mappings for various sources like Oracle, SQL server, flat files to load and integrate data to warehouse.
- Created custom templates in Oracle Reports Builder, for displaying the reports.
- Experience in developing ETL Plans and Processes and using Informatica ETL.
- Handled Production issues with high pace and efficiency.
- Optimized existing queries for better performance and less impact on database and used Materialized views in places where the data does not change very frequently.
- Worked on the Analytical functions.
Environment: Oracle Database 11g, ODI 11g, SQL, PLSQL, SQL *Developer, UNIX, Windows 7,OBIEE 10g, MS SQL Server, Tera Data, HP PPM, HP Quality Center, CVS ETL, ERWIN, MS Office.
Confidential, Buffalo, NY
Oracle/ODI Developer
Responsibilities:
- Analyzed the business requirements of the project by studying the Business Requirement Specification document and prepared data dictionary document.
- Created different schemas and maintained schema objects.
- Involved in all the phases of the project from Planning, Discovery, Requirements Gathering, Design, Construction, Testing, Pilot and Deployment.
- Created new models and work flows for different data sources Oracle DB, MS SQL Server and flat files using ODI.
- Used ODI Topology Manager graphical tool to manage the data describing the information systems physical and logical architecture.
- Used the Oracle Data Integrator Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
- Implemented CDC through ODI Journalization Knowledge Modules .
- Optimized the Knowledge modules for increasing the efficiency of jobs as a part of performance tuning.
- Developed PL/SQL Procedures and database triggers for the validation of input data and to implement business rules.
- Created database objects like packages, procedures, and functions according to the client requirement.
- Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
- Created indexes on the tables for faster retrieval of the data to enhance database performance.
- Developed PL/SQL triggers and master tables for automatic creation of primary keys.
- Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
- Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements.
- Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
- Tuned procedures SQL queries for maximum efficiency in various databases using Oracle Hints, for Rule based optimization.
- Partitioned the fact tables and materialized views to enhance the performance.
- Extensively used Cursors, REF cursors, User-defined object types, Records, in PL/SQL programming.
- Used Advanced queuing concept to deuce the exceptions raised during the cron job execution which will be notified by mail using UTL MAIL package and enque it into main table for error reprocessing.
- Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements.
- Performed SQL and PL/SQL tuning and Application tuning using various tools like Explain Plan, TKPROF, Auto trace and DBMS APPLICATION INFO.
- Involved in fine tuning the existing packages for better performance and providing on-going support to existing applications and troubleshooting errors when occurred.
Environment: Oracle Database 11g/10g, ODI 10.1.3.4, SQL*Loader, SQL, PL/SQL, SQL*Developer, UNIX, PERL Scripting, Golden Gate, SQL Loader, ETL, XML.
Confidential, Fairfield, NJ
ODI/ETL developer
Responsibilities:
- Responsible for data modeling using Erwin, Star Schema Modeling and Snowflake modeling , FACT and Dimensions tables, physical and logical modeling.
- Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes .
- Created Repositories, Agent, Contexts and both of Physical & Logical Schema in Topology Manager for all the source and target schemas.
- Created the users, profiles using the ODI security manager.
- Implemented CDC through ODI Journalization Knowledge Modules .
- Extensively worked and utilized ODI Knowledge Modules (Reverse Engineering, Loading, Integration, Check, Journalizing and service)
- Created various procedures and variables.
- Created ODI Packages , Jobs of various complexities and automated process data flow
- Responsibilities included Building of RPD application design for Physical, Logical, and Presentation layers , configuration of those layers, development of Reports, Dashboards, Publisher and testing, and deployment. .
- Prepared project plan with deliverables and time lines.
- Created the tables and sequences for the experimental data load capture .
- Extracted the data from Iron Port SFDC database by using Data Loader into the Excel .
- Used the Bulk binding techniques for query optimization .
- Created indexes on tables and optimized procedure queries .
- Created PLSQL procedure , to validate the data.
- Created PLSQL procedure , used the DBMS SCHEDULER for automatic weakly sending emails to the users.
- Developed Excel Report using the procedural code .
- Experience in using Informatica ETL Tool .
- Manipulated Stored Procedures , Triggers , Views, Functions and Packages using TOAD .
- Effort also included development of stored procedures .
- Handled Production issues with high pace and efficiency.
- Created Mappings, Map-let designing, Work Flows, tasks and sessions.
- Optimized existing queries for better performance and less impact on database and used Materialized views in places where the data does not change very frequently.
Environment: Oracle 10g/9i, PL/SQL, SQL*Plus, SQL developer, TOAD, Serena Dimensions.
Confidential, Atlanta, GA
Oracle ETL Developer
Responsibilities:
- Created PL/SQL Stored Procedures, Functions, Triggers and Packages for implementing business logic.
- Extensively used Cursors, User-defined Object types, Records, and Tables in PL/SQL Programming.
- Handling the tickets which comes into the queue based on the priority level. Ping the users in the chat window and confirm from them if they are able to login.
- Developed PL/SQL packages using indexes, joins, bulk collects and bulk variables.
- Developed control files for SQL*Loader and PL/SQL programs for loading and validating the data into the Database.
- Solving the issues which users get while working on this production Application server. Also call them and find out the issue they are going on and solve it.
- Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
- Involved in SQL Tuning by creation of indexes, rebuilding Indexes using Explain Plan, SQL Trace and TKPROF Tools.
- Responsible for Power Center and Power Exchange installations, configuring Power Center domain, nodes and integration services.
- Responsible for creating repository folders and giving access to the users.
- Created mappings for various sources like Oracle, SQL server, flat files to load and integrate data to warehouse.
- Developed various mappings, Reusable transformations and validated the ETL logic coded into mappings.
- Developed unit test cases and did unit testing for all the developed mappings.
- Provided production support by monitoring the processes running daily.
- Worked closely with reporting team and helped them whenever they had any ETL issues.
Environment: Oracle 9i/8i, Informatica Power Center 8.1.1, SQL PLUS, PL/ SQL, SQL*Loader, Korn Shell Scripts, SQL Navigator, Windows XP, MS-Excel.
Confidential
Oracle Developer
Responsibilities:
- Involved in gathering requirements for the new enhancements and participated in Database Design changes and prepared documentation of the application.
- Co-ordinate with Business and Data Analysts in reviewing the requirements, posing questions and translating business requirements to technical specifications.
- Created Informatica mappings and sessions to accomplish data migrations sources were Oracle, SQL Server 2000, DB2 and flat files and load into Datawarehouse.
- Involved in database development by creating Oracle PL/SQL Functions, Procedures, Triggers, Packages, Exception Handling, Records and Collections.
- Creation of the database objects like tables, views, Materialized views, sequences, Synonyms, database links and indexes.
- Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
- Developed custom libraries for the existing applications, used canvases, blocks, and visual attributes in developing front end using forms 10g.
- Wrote SQL, PL/SQL, SQL*Plus programs required to retrieve data using cursors and exception handling.
- Effectively used Oracle Reports for generating PDF reports according to the client’s requirements.
- Transferred the data between databases using Export, Import and Data pump utilities.
- Wrote UNIX Shell Scripts for automating the daily/weekly/monthly data process.
- Wrote shell scripts to transfer files using FTP to all the UNIX servers at one time for daily data processing.
- Prepared Technical Documentation. Trained the business users for the better understanding of the Business Application.
Environment: Oracle 10g, SQL * Plus, TOAD, SQL*Loader, SQL Developer, Shell Scripts, UNIX, Windows XP.
Confidential
PL/SQL Developer
Responsibilities:
- Performed review of the business process, involved in Requirements Analysis, System Design Documents, Flows, Test Plan preparations and Development of Business Process / Work Flow charts.
- Developed PL/SQL procedures, customizing existing programs according to the needs of the client testing.
- Wrote PL/SQL packages consisting of procedures and functions.
- Created Materialized Views, Triggers, Sequences, collections.
- Involved in development and testing of oracle back-end objects like database triggers, stored procedures, Sequences and Synonyms.
- Worked with tuning the complex Stored Procedures for faster execution using bulk collections and Dbms profiler.
- Involved in design, development and Modification of PL/SQL stored procedures, Functions, packages and triggers to implement business rules into the application.
- Extensively used cursors for fetching the rows loading data through SQL Loader and UTL FILE.
- Involved in tuning the SQL queries create database objects and optimally set storage parameters for tables and indexes.
- Designed reports using Reports as per user requirements and created Reference and Master/Detail tables to store information. Tested forms and reports using test data.
- Developed complex triggers in reports before/after for validation of user input.
- Designed and developed user interfaces using Oracle Forms.
- Wrote Shell scripts to insert data to database tables. Wrote PL/SQL code to retrieve data for master and detail blocks.
- Customized forms and reports as per user requirements using Oracle Developer Forms & Reports.
Environment: Oracle 9i, SQL, PL/SQL, SQL*Plus, Forms 6i, Reports 6i, Windows.