PROFESSIONAL SUMMARY:

• 9+ plus years in leading and executing full life cycle of software development of a Data Warehousing and Business Intelligence solution including designing DW, ETL & Reporting experience.
• Skill - set - Oracle Data Integrator, Oracle Warehouse Builder, OBIEE, Oracle Discoverer, Oracle Database, PL/SQL, UNIX.
• Six Years’ experience in designing, creating & managing of Facts, Dimensions & Data Marts.
• Highly skilled and experienced in Agile Development process for diverse requirements.
• Experience in designing and developing Star/ Snowflake schemas.
• Good knowledge of Data warehouse designs (Top-down, Bottom-up & Hybrid Design).
• Experience working in globally distributed technology teams. Handled multiple roles - Team Lead, Data warehouse Developer, Business Analyst, Data Modeler and Back-End Developer.
• Technology expertise includes in-depth skills in Designing and developing applications with Oracle Technologies.
• Good knowledge of PL/ SQL programming (Creating Stored Procedures, Functions, Triggers, cursors and packages).
• Extensive experienced in developing & supporting company-wide systems.
• Proven ability to work with a wide range of departments and levels of management.
• Proficiency in Software Development Life Cycle (SDLC) and AGILE methodologies of development process such as requirement analysis & definition, prototyping, proof of concept, designing, coding, testing and implementation.
• Experienced in Configuration Management, setting up company Version policies, build schedule using Clear Case and Visual Source Safe (VSS).
• Quick and accurate thinker with an optimistic attitude towards problem solving combined with efficient analytical skill set.
• Significant experience in offshore leading, coordination thus implementing a successful onsite-offshore model of delivery.
• Strong team player, motivator but has also executed projects independently.
• Excellent Written, Analytical Skills and Verbal Communication skills with a customer service oriented attitude.
• Proven track record of dependability and reliability with an accomplished sense of responsibility.

TECHNICAL SKILLS:

ETL: Oracle Data Integrator (Formerly Sunopsis) Ver 11g/12c, Informatica 9.1/ 8.6, Oracle Warehouse Builder, PL/ SQL scripts.

Databases: Oracle 8i/ 9i/ 10g/ 11g/12c, Sybase Version ASE 15, SQL Server 2008/2005/2000 , Teradata

Reporting: OBIEE, Oracle Discoverer, Cognos Reporting, Actuate Reporting.

Version Control: Visual Source Safe 6.0, Clear Case.

Other Tools: Toad, SQL Navigator, Microsoft Visio, Excel, Rapid SQL, SQL Advantage, HP Service Desk, SQL Developer.

Servers: Unix, Windows 2003 server.

PROFESSIONAL EXPERIENCE:

Confidential

SR ODI/OBIEE Consultant

Environment: Oracle DB 12c, ODI 12c, OWB, PL/SQL, TOAD, Serena Team Track, PVCS, Oracle Primavera p6, SAP BI, OBIEE, Linux

Responsibilities:

• Conversion of existing OWB (Oracle Warehouse Builder) process flows to ODI packages
• Develop ODI mappings, packages, procedures and Load Plans in Oracle Data Integrator (ODI)
• Provide O&M Support to Data Warehouse
• Daily ETL load monitoring and Performance tuning
• Improve the design of the existing ETL jobs
• Test the ODI packages developed by the team
• Customize the Knowledge Modules in ODI
• I have followed an extremely light and efficient Agile process, adapted to be most easily applied, and with that you may pursue and at any time change a project plan; and others, battle-proven, easy and fast, to prioritize among projects and manage a program in an Agile manner.
• Organized and facilitated sprint planning, daily stand-up meetings, reviews, retrospectives, release planning, demos and other Scrum-related meetings
• Instructed and modeled core Agile principles of collaboration, prioritization, team accountability and visibility; ensured consistent application of scrum methodologies across the enterprise
• Design, develop and maintenance of Complex PL/SQL Packages, Procedures, Functions, Materialized Views, Materialized Views logs, Materialized Views Refresh Groups, DB Triggers, Views and Sequences.
• Consolidation of multiple schemas from multiple physical sites into one schema - activities involved data modeling, table creations, index creations, ETL/ELT, Data Analysis and data cleanup.
• 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.
• Used ODI Operator to monitor sessions.
• Created model folder, sub folders reversed the technologies to get the table structures.
• Created project folder and imported, exported the knowledge modules in different environments.
• Created interfaces, Procedures and Packages, generated scenarios using Oracle Data Integrator Designer.
• Automated the ETL packages and File delivery packages using Oracle Data Integrator built-in agent.
• Designed and developed the purge process for purging operator logs using oracle data integrator tools in the package.

Confidential, Cambridge, MA

Sr. ODI Consultant

Responsibilities:

• Developed various ODI interfaces to load data from Flat file & Relational Sources to Oracle DataMart.
• Topology Manager is used to create database connection, physical and logical schema in order to achieve the whole infrastructure.
• Used ODI Designer for importing tables from database, reverse engineering, to develop projects, and release scenarios.
• 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.
• Used ODI Operator to monitor sessions.
• Created model folder, sub folders reversed the technologies to get the table structures.
• Created project folder and imported, exported the knowledge modules in different environments.
• Created interfaces, Procedures and Packages, generated scenarios using Oracle Data Integrator Designer.
• Automated the ETL packages and File delivery packages using Oracle Data Integrator built-in agent.
• Designed and developed the purge process for purging operator logs using oracle data integrator tools in the package.

Confidential, NYC, NY

Lead ODI/ OBIEE Developer

Environment: Oracle Business Intelligence EE 11.1.6, Oracle 11g, PL/SQL, OracleSQL Developer, Oracle Data Integrator 11.1.1.7, 12.1.2.0, SQL, PL/SQL, TOAD, Erwin

Responsibilities:

• Leading a team of 6 ODI & OBIEE developers.
• Responsible for delivery of releases related to Confidential .
• Gathered and analyzed requirements. Discussed the requirements with Business Analyst for any clarifications.
• Analyzed multiple sources (database and files) and designed normalized staging area to source data for Mart.
• Prepared Source to Target Mapping Document.
• Created physical and logical Data models for Confidential .
• Designed hierarchies and dimensions as per business rules.
• Designed the developed data Extraction, transformation and load process.
• Completed code review of ODI code.
• Created OBIEE repository for different subject areas and Adhoc reporting in BI Administration.
• Developed various reports using BI Analysis.
• Used BI Catalog Manager to maintain Catalog folders for code promotion to different environments.
• Worked on BI Enterprise Manager to save RPD on server and restart servers post deployment
• Defined OBIEE/ ODI row level & subject area level security.
• Completed Parallel Processing in ODI to achieve performance benchmarks.
• Completed ODI job scheduling for Daily, Weekly & monthly jobs in various environments using ODI Operator.
• Co-ordinate with Business, DBA and other technical teams for analysis.
• Extensively used Designer to develop the interface, packages and create scenarios.
• Implemented complex business rules into ODI transformations/ mappings.
• Promoted Scenarios to different environments for ODI code promotion.
• Developed Packages and generated Scenarios to integrate all the interfaces sequentially.
• Developed the procedures to update the process control parameter tables.
• Used constraints to achieve the data quality.
• Created Models for File structures and updated/ maintained Data Models for Oracle/ Sybase DB.

Confidential, MI

Sr. ODI Developer

Environment: Oracle data integrator 10.1.3.6/11.1.1.7.0 Enterprise Edition, JReports,oracle 11g,PlSql, Informix 11.70 fc 7,Weblogic 10.3.6.0.0 , Dimensional model, Sub Version, Windows 2003 server.

Responsibilities:

• Upgraded the existing ODI 10.1.3.6 development, quality and production Master /Work repositories to latest ODI 11.1.1.7.
• Installed of web logic server on development, test and production environment.
• Creating the web logic domain to access ODI web console for monitoring the jobs.
• Defining the technology definitions in topology for Informix and Oracle database.
• Configuring the ODI Standalone agent’s on Linux environment for development, quality and production environment.
• Configuring the ODI web console for development, quality and production
• Modified the existing interfaces pointing from project specific knowledge modules to Global knowledge a module which is the new feature available in ODI 11.1.1.7.
• Creating complex interfaces and packages and scenarios, Load plans for scheduling.
• Creating a utility using ODI API’s to compare the different builds.
• Code migration, Support and Maintenance of the development/ production jobs.