SUMMARY

• Over 7+ years of experience in System Designing, Analysis, Application Development, Maintenance, Implementation, Production Support and System Admin using Oracle Data Integrator, OBIEE, Informatica and mainframes applications.
• Being Part of full lifecycle of DW Project, gathered hands on experience on Evaluation, Installation, Development, Maintenance and Implementation of ETL tools such as Oracle Data Integrator & Informatica...
• Experience in integration of various data sources like Oracle 9i/10g/11g, Informix, MS SQL Server 2005/2000, DB2, Netezza, Mainframe, AS400, Flat Files and XML files.
• Hands on experience in writing, testing and implementation of the PL/SQL programs, Stored procedures, Functions, Views, Materialized Views, Packages and performance tuning of SQL queries.
• Experience in Performance Tuning & Optimization of SQL statements using various types of Hints, Partitioning and Indexes
• Having good working experience in UNIX shell scripting. Created scripts for calling pmcmd command, file watcher, FTP and file archiving scripts
• Extensively used ODI tools such as Designer, Operator, Security and Topology.
• Experience in creating connections using physical Architecture, Logical Architectures and Context for new source databases.
• Installation, Configuration and Maintenance of ODI 11g/10g. Applying Patches, configuring agents on UNIX, Linux and Windows Servers.
• Experience in migration process from ODI 10g to ODI 11g.
• Experience in ER (Embarcadero) and ERWIN data modeling
• Experience in implementing Control Append, Incremental Update and CDC processes according to requirements.
• Expertise in creating Load Plans and Scenarios for scheduling.
• Expertise in scheduling using JAMS scheduler.
• Extensively used Informatica tools (such as Informatica Server and Client Tools like Designer, Server Manager/Workflow Manager, Work flow Monitor, Repository Manager)
• Extensively worked on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence Generator, Union, XML Source Qualifier and HTTP Transformation.
• Expertise in Building Executive Dashboards using OBIEE tools Physical Layer, BMM Layer and Presentation Layer.

TECHNICAL SKILLS

ELT/ETL/Reporting Tools: Oracle data Integrator 11.1.1.6/10.1.3.5 , OBIEE, Informatica Power Center7.1/8.1/8.6

Power Mart 5.0/5.1.1/6.2 Databases: Oracle (8i, 9i,10g, 11g), DB2, SQL Server, Sybase, MSSQL, Server2000/2005, MS - Access, AS400, Netezza, Informix

Operating Systems: Microsoft Windows (NT 4.0/XP/2000/VISTA), UNIX, z/OS.

Tools: & Utilities TOAD 8.5, Erwin 4.0/2.6, SQL developer, JAMS

Programming Languages: SQL, PL/SQL, C, UNIX Shell Scripting

Mainframes: Cobol, JCL, CICS, VSAM

Data Modelling: ER/Studio Modelling (Embarcadero)

PROFESSIONAL EXPERIENCE

ODI/OBIEE Developer

Confidential, Waynesboro, VA

Responsibilities:

• Configured data servers for Oracle database, File systems and setup physical/logical models in Topology Navigator
• Involved in Architecture Design, Requirement Gathering, Design, Coding and Migration processes.
• Designed and created Dimensions and Fact tables.
• Extracted data from various Sources like Oracle, Excel, XML, JDE using different transformations.
• Designed table structures and relationships using Visio data modeler
• Created PL/SQL Functions and Stored Procedures for the processing of data from Warehouse to Mart.
• Customized the ODI Knowledge modules to handle the complex business scenarios and implemented the transaction control.
• Working on extract transactional and historical data from Legacy Applications to Data Warehouse based on user requirements.
• Implemented Incremental Update and Slowly Changing Dimension processes according to business requirements.
• Implemented ODI CDC process for one of the requirement.
• Developed PL/SQL packages and created Temp tables, which were used in ODI and to develop reports in BI.
• Designed and Developed Object Level and Data Level Security for Business Users to define users, groups, set roles and responsibilities, permissions, group inheritance and filters
• Built a complex Data model/Business model that has a dimensional hierarchy table that joins to multiple Dimensions which in turn joins to a fact.
• Developed and debugged many intelligence Dashboards using different Analytics Views (Pivot Table, Pie/Bar Chart, and View/Column Selector, Narrative View), Dynamic / Interactive Dashboards with drill-down capabilities using global and local Filters.
• Designed and developed Analytics Metadata Repository (.rpd) using Oracle BI by importing the required objects with integrity constraints into Physical Layer using connection pool, developing multiple Dimensions (Drill-Down Hierarchies), Logical objects in Business Model Layer, and creating the Presentation catalogs in Presentation Layer.
• Experience creating, enhancing and optimizing simple to complex reports using Oracle Business Intelligence reporting tool including implementing functions to customize and enhance reports.
• Responsible for day-to-day running of a busy team and able to mentor and guide team members.

Environment: ODI 11.1.1.7.0 , OBIEE 11.1.1.7.1 , PL/SQL, BIACM, Toad, SQL Developer, Oracle 11g, Unix

ODI Admin/Developer

Confidential, North Wales, PA

Responsibilities:

• Installation, Configuration and Maintenance of ODI 11g/10g. Applying Patches, configuring agents on Unix Servers
• Installed ODI 11g/10g on Unix platform and configured the Dev, Test and production environments
• Created Master, Work and Execution repository in Dev, Test and Prod Environments.
• Configured different technology data servers, physical/logical models, ports, physical/logical agents using Topology manager
• Setup different physical scheduler, slave agents on the Linux server.
• Created users using security manager and provide respective profiles both Generic and Non Generic.
• Created ODI standards document for coding, naming convention.
• Extracted data from various Sources like Oracle, Excel Spread sheets, XML, Flat Files.
• Involved in design, development of ODI for ETL (ELT) Project, gathering requirement specification documents and presenting and identifying data sources
• Designed table structures and relationships using ER (Embarcadero) data modeler
• Created PL/SQL Functions and Stored Procedures for the processing of data from Warehouse to Mart.
• Loaded data into various tables from Oracle database as well as from Excel Spreadsheets
• Identifying and tracking the slowly changing dimensions, heterogeneous sources and determining the hierarchies in dimensions.
• Tuned the Sources, Targets, Transformations and Mapping to remove bottlenecks for better performance.
• Performed extensive Unit Testing on the developed Mappings and was also involved in the documentation of Test Plans and testing with the users (UAT).
• Created Master, Work and Execution repository in Dev, Test and Prod Environments.
• Created ODI standards document for coding, naming convention.
• Coordinated with Testing team and DBA for the System testing and Performance testing.
• Involved in production support for issue fixes and helping out from the system failures.
• The project is an end-to-end development project that involves extraction of data from different business areas/data sources; transforming it and loading it into centralized data warehouse and enable Analytical.
• Migrated and converted the flat source files from multiple sources to Oracle Target databases
• Customized the Knowledge modules to handle the complex business scenarios and implemented the transaction control.
• Built transformations, configured servers and established connections to various sources and targets
• Worked on pulling transactional and historical data from Legacy Applications and other applications to Data Warehouse based on user requirements.

Environment: ODI 11.1.1.6, PL/SQL, SQL Loader, Toad, SQL Developer, XML files, Oracle 11g/10g, Windows Server 2008.Unix, Embarcadero.

ODI Developer

Confidential, Nashville, TN

Responsibilities:

• Installation, Configuration and Maintenance of ODI 11g/10g. Applying Patches, configuring agents on Unix Servers.
• Designed table structures and relationships using ERWIN data modeler
• Installed ODI 11g/10g on Unix platform and configured the Dev, Test and production environments.
• Created Master, Work and Execution repository in Dev, Test and Prod Environments.
• Configured different technology data servers, physical/logical models, ports, physical/logical agents using Topology manager.
• Setup different physical scheduler, slave agents on the Linux server.
• Created users using security manager and provide respective profiles both Generic and Non Generic.
• Created ODI standards document for coding, naming convention.
• Exported the Projects and Data-Stores from Dev to Test Environments, as well as Scenarios imported to Production.
• Design and Development of the Logic and related Interface, Package based on the required on it.
• Parallel Design and Development on Interface Development based on the Source of the Data for Multiple Work Repository (Development).
• Providing support on Test and Production environment.
• Designed the ETL process flow and framework for loading the data using ODI.
• Involved in design, development of ODI for ETL (ELT) Project, gathering requirement specification documents and presenting and identifying data sources
• Prepared Source to Target Mapping Document.
• The project is an end-to-end development project that involves extraction of data from different business areas/data sources; transforming it and loading it into centralized data warehouse and enable Analytical.
• Migrated and converted the flat source files from multiple sources to Oracle Target databases
• Using ODI, Developed, Maintained various Packages, Interfaces, Variables, and Models, which populated the Data into the Target Star Schema on Oracle Instances.
• Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems (Flat files, DB2, COBOL copybooks and Oracle) feeds using ODI, PL/SQL and Unix Shell scripts.
• Customized the Knowledge modules to handle the complex business scenarios and implemented the transaction control.
• Built transformations, configured servers and established connections to various sources and targets
• Worked on pulling transactional and historical data from Legacy Applications and other applications to Data Warehouse based on user requirements.

Environment: ODI 11.1.1.6, PL/SQL, SQL Loader, Toad, Erwin 7.x, Flat files, Oracle 11g/10g, MS SQL Server 2008/2005, Netezza, AS400, Informix, Windows Server 2008.Unix.

ETL/Data Specialist

Confidential, Whippany, NJ

Responsibilities:

• Prepared system design documents and system test documents.
• Designed the ELT processes using ODI to extract data from Oracle, Flat Files to load into target Oracle/Files.
• Extracted data from flat files and loaded in to the Oracle database
• Created new process for 10 CCM HUB Activity files like CAMPAIGN, TARGET, etc.
• Created UNIX scripts to automate some existing functionality.
• Used HTTP transformation to get data from internal server.
• Created process for Automated DQC (Data Quality Checks) using Oracle 9i/10g, Unix.
• Created UNIX generic scripts for migration purpose.
• Modified some of the SAS programs upon requirement.
• Created jobs in Tidal Scheduler for automations.
• Involved in production support for fixing issues

Environment: ODI 10.1.3.5, PL/SQL, SQL Loader, Toad, Erwin 7.x, Flat files, Oracle 11g/10g, MS SQL Server 2008/2005, Windows Server 2008.Unix.

ETL Developer

Confidential

Responsibilities:

• Analysis of business requirements for end-to-end ETL process.
• Worked closely with business analysts to understand the business needs for decision support data.
• Analyzed and Created Facts and Dimension Tables for star schema.
• Extraction, Transformation and Load was performed using Informatica Power Center to build the data Mart.
• Designed the ETL processes using Informatica to extract data from Oracle, Flat Files, and XML files to load into target tables.
• Developed various Sessions, Batches for all Mappings to load from Source flat files tables to Target tables
• Extensively managed the data skew all the database tables
• Creation of Transformations like Sequence generator, Lookup, joiner and Update Strategy transformations in Informatica Designer
• Wrote shell scripts for data validation and reconciliation.
• Extensively worked on the tuning of mappings and sessions.
• Wrote stored procedures for dropping and recreating indexes for efficient Data Load.
• Creation of database objects like Tables, Views, Procedures, Packages using Oracle query tools like PL/SQL Developer and also created anonymous blocks for onetime execution tasks, and managed primary data base objects such as Tables, Views, Indexes, Sequences, and Synonyms.
• Responsible for information gathering and data analysis.
• Used pmcmd command for running of the sessions.

Environment: Informatica Power Center 8.6, MS SQL Server 2000, PL/SQL, Oracle9i, Windows NT, HP-Unix.