SUMMARY:

• Over all 11+ years of IT experience with prime focus on Analysis, Design, Development, Customization, Data Modelling, Gap Analysis, Testing, Administration, Documentation and Maintenance of Data Warehouse / Data Marts.
• Good exposure to business domains like telecommunication, Logistics/transport.
• Excellent Data Analysis Skills and ability to translate Business logic into mappings using complex Transformation logics for ELT/ETL processes.
• Worked extensively in developing ETL mappings for supporting Data Extraction, Transformation and Loading using ORACLE DATA INTEGRATOR 12C & 10g.
• Extensively used ODI (Oracle Data Integrator) to perform ELT from heterogeneous sources like using ODI tools - Designer and Operator also good knowledge in Security Manger & Topology Manager
• Working experience in Creating ODI packages, Load Plans, scenarios, mappings/interfaces, variables, procedures and Topology including physical architecture, logical architecture.
• Good experience in configuring mapping details in excels to create ODI interfaces in groovy environment.
• Good experience in Customizing ODI IKM knowledge modules to generate desired generic sql code.
• Good Experience in writing SQL/PLSQL scripts for ETL development
• Created UNIX frame work to control ODI jobs and generate UNIX log files to capture odi session details.
• Created Tivoli scripts to schedule ODI Jobs.
• End to End Owner ship in delivering new Enhancement.
• Good experience in setting up new ODI environment and Migrating Load plans/Scenarios from one environment to another environment with required topology.
• Efficient in troubleshooting, performance tuning and optimization of ELT/ETL and reporting analysis.
• Experience in Implementing CDC through ODI Journalization Knowledge Module (JKM -KMs) and Golden gate.
• Experience in Data Warehousing development using other ETL tools such as Informatica.
• Experience in Extracting data from SAP R/3, SAP BW/BI, Flat file, XML, Oracle and Teradata.
• Analyzing processes and recognizing areas that need improvement.
• Involved in Test Scenarios, Unit & Integration test cases preparation and execution.
• Experience in web based software development and collaboration tools, e.g. Jira, Confluence, and Trelo.
• Trained on Big Data technologies. (Hadoop,MapReduce,HDFS,HBase,Pig,Hive..etc)
• Adaptive to team environment blended with capabilities of completing complex tasks independently under tight deadlines.

SKILLS/TOOLS:

Data Warehousing: E LT/ETL ODI 12c, ODI 10g (10.3.5.6), Informatica

Reporting Tools: OBIEE, BO, WebAnalysis,Workspace, IntractiveReportingTableau

Operating Systems: MS-DOS, Windows family, Red Hat Linux

Programming Languages: C, C++, Core Java

Databases, Database Tools: Oracle 11g/10g/9i/8i/8.0/7.x, Teradata

Scripting: Shell Script, SQL, PL/SQL, Jython, Python

PROFESSIONAL EXPERIENCE:

Confidential

ODI Developer

Environment: RDBMS(Oracle DB and MS SQL Server),ODI 12c,Unix,PL/SQL,SQL Developer, OBIEE 12c,BIP 12c.

Responsibilities:

• Creating ODI Mappings/Load plans for Data Extraction/Transformation/Load via ODI 12c for Oracle DB and SQL Server DB.
• Creating API requests through ODI to move files .
• Creating PL/SQL Packages and Procedures to load Daily/Weekly Adhoc Data loads to Data Warehouse.
• Create and schedule Unix Scripts to load data from vendor source files to database.
• Sanity check of each report via SQL statements in SQL Developer and physical SQL optimization for OBIEE Reports Performance tuning.
• Provide support and fix issues in the PL/SQL packages and ODI mappings.
• Working in RDBMS and job scheduling, indexing and ETL and OLAP processing and software development Life cycle (SDLC).
• Responsible for UAT validation and fixing the issues created for OBIEE/BIP/ETL in Jira.

Confidential

ETL Senior Developer

Environment: ODI ( 12.1.3),Groovy, Teradata v13,BusinessObjects,Unix,Tivoli,Golden gate

Responsibilities:

• Understanding and preparing LLD’s for the requirement and system use cases provided.
• Creating ODI mappings, packages and load plans to load data into Datawarehouse.
• Created complex interfaces to load data from various sources into dimensions and facts.
• Configured interface details in excels to create ODI interfaces in groovy environment.
• Used Reusable mappings in ODI 12c for developing most complex interfaces.
• Created various test scenarios and test cases and Performed unit and integration testing.
• Customized knowledge modules to generate desired generic sql code.
• Involved in performance tuning of ODI mappings.
• Created Materialized views and PL-SQL Scripts to perform various data transformations.
• Created UNIX frame work to execute ODI jobs to generate unix log files for odi sessions.
• Created Tivoli scripts to execute ODI Jobs.
• Involved in Moving and deploying ODI objects in multiple environments.
• Drafted the Technical specification documents along with the architecture diagram in Visio.
• Documentation of every step involved in the process.
• End to End Owner ship in delivering new Enhancement.
• Involved in setting up new ODI Environment and Creating users with required permissions.
• Assigning work to team members and keeping track of work status.
• Establish “Best Practices” and plan for continuous improvement of processes

Confidential

ETL Developer

Environment: ODI10g, ODI11g, Oracle11g, Business objects

Responsibilities:

• Designed, developed, reviewed, packaged and deployed ODI Interfaces and Packages for EDW platform and several data marts.
• Created high level and detailed technical design and ETL flow documents.
• Provided supervision, oversight and guidance to the BI/DW development team member.
• Reviewed mapping specifications that are provided by the solution architect.
• Created framework-based FTP, ETL backup, Release Management and ETL auditing capabilities within ODI environment leveraging customized ODI KMs
• Created Enterprise Information Systems, BI Development Guidelines documentation for ODI.
• Reverse Engineer source and target models (flat files, XML, Excel, Oracle).
• Developed ODI interfaces to populate Dimensions and FACT tables with customized SCD Type1 and Type2 KMs.
• Used different ODI Variables and Contexts to make interfaces reusable.
• Migrated ODI Scenarios from Development environment to QA/UAT/Production following SDLC practices.
• Optimized solutions using various performance tuning methods (SQL tuning, ETL tuning (i.e. optimal configuration of transformations and memory parameters), Database tuning using Hints, Indexes, partitioning, Materialized Views, Procedures, functions etc.)
• Created Pre/Post Session/SQL commands in sessions and mappings on the target instance.
• Participated in reviews, meetings, status updates, Client Meetings and Client Presentation of documentation and code.

Confidential

ETL Developer

Environment: Informatica 8.1, Oracle 10g, UNIX

• Developed Informatica Mappings, Worklets, Work flow Sessions to perform reconciliation in target table.
• Written SQL transformation queries.
• Developed materialized views and PL-SQL Procedures.
• Involved in creating test scenarios, test cases and test data.
• Developed Technical design and Unit Test Case Documents
• Developed Unix scripts
• Performed Data validations through Excel spreadsheet features.
• Involved in resolving daily production issues
• End to End Owner ship in delivering new Enhancement
• Involved in documenting production support issues.

Confidential

ETL Developer

Environment: ODI10g, Oracle 10g, UNIX, SAPR/3,OBIEE

Responsibilities:

• Analyze the Technical Requirements Document & Technical Requirement Specifications
• Design and develop Oracle Data Integrator packages as per the requirements.
• Developed mappings using ODI Designer to transform and load the data .
• Developed Technical Design document and Unit Test Case Documents .
• Scheduled packages & Sessions tasks comprising of different mappings in order to load data into Target database.
• Train and manage developers within the project on Oracle Data Integrator development
• Establish “Best Practices” and plan for continuous improvement of processes
• Interacting with the Onsite counterpart and acting as a bridge between onsite and offshore team
• Understanding the Test Environment and Project Requirement from SRS Document.
• Participated in Identifying test scenarios with client.
• Participated in Identifying test data.
• Developing the Test cases based on the Design document.
• Executing the test cases and identifying the bugs.
• Posting and tracking the bugs through BugDB.
• Regression testing for new releases.
• Involved in installation of ODI,Creation of master repository, Creation of Work repository.
• Involved in creation of ODI security settings (User creation, assigning of necessary scenarios and other objects to respective users).
• ODI Topology settings (Creation of Data servers, Physical servers, Logical schema)
• ODI Designer (Creation of Models, Projects, Packages, Interfaces, Procedures, scenarios
• Deploying of scenarios in the execution Repository.
• Involved in preparing performance comparison report between ODI and Informatica.
• Created the users, profiles using the ODI security manager.
• Configured the OBIEE repository (Physical, BMM and Presentation layer)
• Created dimension hierarchies and aggregates in the BMM layer.
• Customized reports in OBIEE answers and integrated them into the Dashboards according to the Business requirements.
• Performed Data Validation of data in the reports and dashboards.