SUMMARY:

• Total IT: 12+ years of IT Experience with of Oracle Development experience including analysis, modeling, design, administration and maintenance of Oracle Database systems on both UNIX and NT platforms.
• Oracle: 12+ years of solid database experience on Oracle 11G/10G/9i/8i/8.0/7.3, DBArtisan 5.1, SQL*Loader, Physical database design, Logical database design, Data Modeling (Designer 2000), Gap Analysis, Data Mapping, Cleansing, Massaging, Transformations, Data Exports & Imports, Inbound/Outbound Interfaces, Application Support, Performance Tuning, Security Administration, Resource Management, Software Maintenance, User & Security Management, Oracle Tuning & Optimization.
• Reports: 6 years of strong front - end programming experience using Oracle Forms 6i/5.0/4.5, Oracle Reports 6i/3/2.5, Oracle Report Writer, Oracle Developer 2000, SQR 3.0, Crystal Reports and Oracle Discoverer.
• Database: 12+ years of Database experience working on Oracle Warehouse Builder, Oracle 11G/10g/9i/8i/8.0/7.3, MS SQL 12, SQL Server 2006/2000/7.0/6.5, IBM DB2 8.0/7.0, Teradata V2R5/V2R4, MS Access.
• Programming: 12+ years of strong back-end programming experience using PL/SQL, SQL, MS SQL, SQL*Loader, SQL*Plus, TOAD, T-SQL, Pro*C, C, C++, Java, VB, HTML, Stored Procedures, Functions, Ref Cursors, Constraints, Triggers, Indexes-B-tree Index, Bitmap Index, Views, Inline Views, Materialized Views, Database Links, Export/Import Utilities, Ad-hoc queries using SQL.
• UNIX: 8+ years of UNIX experience on Unix Shell Scripting, CGI/PERL, Pro*C, Autosys, Clearcase, Sun Solaris, Windows 2000, Windows NT 4.0, Windows 98/95/3.1, MS DOS 6.22, Novell Netware, IBM Compatibles, Sun Classic, Sun Sparc & Sun Ultra.

TECHNICAL SKILLS:

Oracle: Oracle 10g/9i/8i/8.x/7.x, Oracle Forms 4.5/5.0/6i, Reports 6i/3/2.5, Database Design (both Physical and Logical), Database Modeling (Designer 2000), Data Exports & Imports, Inbound/Outbound Interfaces, Performance Tuning, Administration, Software Maintenance, User & Security Management, Query Optimization, Export/Import Utilities

Databases: MS SQL Server 2005/2000, Sybase SQL Server, DB2, Teradata

DW and BI tools: Oracle Warehouse Builder 10.1/9i, Manual ETL, UNIX Shell Scripting, Informatica power Center, Power Mart, Power Plug, Power Connect, Data Mining, Data mart, OLTP, OLAP, Main frames, Cognos Series 7.0/6.0 (Impromptu & PowerPlay), Business Objects 6.5/6.0/5.0.

Programming: SQL, PL/SQL, MSQL, Unix Shell Scripting, SQL*Loader, SQL*Plus, Discoverer, Pro*C, Pro*C++, C, C++, Java 2.0/1.2, XML, XSD, SOAP, WSDL, Siebel Prolog, Haskell, PASCAL, HTML 4.0, FORTRAN, Assembly Language (8085/8086)

Environment: Sun Solaris 2.6, Sun OS, MS DOS 6.22, Windows 3.x/95/98/2000, Windows NT 4.0, IBM compatibles, Red Hat Linux, SUN Sparc, Sun Classic, Sun Ultra, DOS, Windows 98/NT/2000/XP, SUN Solaris 2.5/5.6 Unix and Linux

PROFESSIONAL EXPERIENCE:

Confidential, OH

Senior Informatica Developer

Responsibilities:

• Interacted with Business Analysts to gather and analyze the Business Requirements.
• Analyzed the source data, Coordinated with Data Warehouse Architect in developing Relational Model. Designed and developed logical and physical models to store data retrieved from other sources including legacy systems.
• Extensively used All Fusion-Erwin for Logical / Physical data modeling and Dimensional data modeling, and designed Star join schemas.
• Designed and developed Star Schema, Snowflake Schema and created Fact Tables and Dimension Tables for the Warehouse and Data Marts.
• Used Informatica Repository Manager to create Repositories and Users and to give permissions to users.
• Used Informatica Designer to create mappings using different transformations to move data from source to a Data Warehouse.
• Designed and Developed mappings in Informatica using different transformations like Source Qualifier, Expression, Lookup, Aggregator, Router, Rank, Filter and Sequence Generator transformations.
• Created Update Strategy and Stored Procedure transformations to populate targets based on business requirements.
• Created and Configured Workflows, Work lets and Sessions to transport the data to target warehouse tables using Informatica Workflow Manager.
• Scheduled the sessions to extract, transform and load data into warehouse database as per Business requirements. Improved the session performance by pipeline partitioning.
• Used various Index techniques to improve the query performance.
• Automated Unix shell scripts to verify the count of records added everyday due to incremental data load for few of the base tables in order to check for the consistency
• Implemented Slowly Changing dimension methodology for accessing the full history of accounts and transaction information.
• Optimized the performance of the mappings by various tests on sources, targets and transformations. Developed Procedures and Functions in PL/SQL for Data ETL.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Analyzed, Designed and Developed OBIEE Metadata repository (rpd) that consists of Physical Layer, Business Mapping & Model Layer and Presentation Layer.
• Creation of presentation layer tables by dragging appropriate logical columns from the BMM layer.
• Developed many Dashboards using different Views (Pivot Table, Pie/Bar Chart, Column Selector and Narrative View) with drill-down capabilities.
• Worked with various Presentation Services objects such as Dashboard, Reports etc.
• Worked on Time Series Objects.
• Created Interactive Dashboards with drill-down capabilities and applied various filters, both global & local Filters.
• Developed and scheduled iBots for delivering personalized reports to users on time.

Environment: Informatica Power Center 9.5/9.1, SQL, PL/SQL, TOAD, Oracle 10g, Linux, SSH, UNIX Shell Scripting, Dollar U, OBIEE 11.1.1.3, Windows XP, JAVA.

Confidential

Sr. DWH ODI Developer

Responsibilities:

• Involved in designing and developing the ELT flow that will update the data-structure related to Target Oracle tables.
• Configured connections in Topology for Oracle10g, DB2, Excel, File and more.
• Created ODI Packages of various complexity and automated the data flow Process.
• Created ODI Sequences and Data sequences and implemented them in the ODI process.
• Performed source to Staging and staging to target mapping specifications and developed ELT ODI code for the same.
• Transferred SQL and Korn Shell programs into ODI and created data extracts.
• Replicated PL/SQL and Complex SQL procedure into ODI Procedure and Interfaces.
• Created ODI Interfaces of various complexities, Lookups and Constraints
• Configured the testing environment and process to export and Import ODI Objects into the Testing and Production (Execution) environment.
• Modified the existing and creating new KM.
• Directly dealt with Business users, coordinated with the Project Manager and team members on a day-day basis
• Used Maestro - Tivoli Job Scheduling software to schedule jobs.
• Used ITEAM for creating Maestro Stubbs used in the scheduling of Jobs.
• Production support and off hours pager rotation.
• Experience in Data Modeling (Logical and Physical Design of Databases), Normalization, De-Normalization and building Referential Integrity Constraints.
• Extensive knowledge and experience in dealing with Relational Database Management Systems, including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes(i.e.,Clustered and Non Clustered), Data Import/Export, Triggers, Functions, Sub Queries, Cursors.
• Thorough knowledge of addressing Performance Issues and Involved in query tuning, Index tuning, Data Profiling and other database related activities.

Enviornment: Oracle 11g, IBM Netezza 6.0, Sql server 2008 R2, ODI 10.2, Toad, IBM Tivoli Workload Scheduler 8.0ITeam, Unix, Cognos

Confidential

Sr ODI Developer

Responsibilities:

• Installed and configured ODI for POC
• Involved in designing and developing the ELT flow and framework to support ELT development.
• Developed functional and Technical specs for moving data across based on requirements.
• Created data integration blueprint and installed, configured and tuned ELT infrastructure to support the Data Warehouse solution.
• Configured connections in topology for MS SQL server 2005, Oracle 11g.
• Created projects, Models, Contexts, logical, physical architecture.
• Created interfaces to extract data from Hyperion Essbase 11 to staging Oracle tables.
• Created ODI interfaces with simple to complex transformation rules.
• Optimized ODI Interfaces to improve performance.
• Created the ODI packages and generated scenarios for packages of various complexities.
• Established communication between ODI with scenario's and agent code
• Customized the JKM, LKM, IKM knowledge modules for various requirements.
• Wrote PL/SQL packages to in corporate into ODI Interface as part of Transformations.
• Prepared UNIX shell scripts for ELT to run in batch.
• Unit tested the Interfaces.
• Did root cause analysis to figure out what was wrong during production support.
• Maintained data integration measures and reviewed peer codes and requirement.
• Worked closely with business and technical teams to understand, document, design and code ELT processes.
• Configured the testing environment and process to export and Import ODI Scenario's into the Testing and Production (Execution) environment.
• Implemented Best Practices using ODI for Data Warehousing, ELT (Extract, Load and Transform) and Data Integration Purposes.

Environment: Oracle 11g, ODI 11.1.1.7, SQL developer, MS SQL server 2005, C#, .net, UNIX .

Confidential, LA

Sr. Informatica Developer

Responsibilities:

• Interacted with Business Analysts to gather and analyze the Business Requirements.
• Designed Informatica process and involved in mapping development to load data from different ERP Sources like SAP, baan4, baan5, JDE, Marinette into the target relational database. Data is migrated by applying business logic using transformations in mapping for deleting and inserting records.
• Used Source Analyzer and Warehouse Designer to import the source and target database schemas, and the Mapping Designer to map the sources to the target.
• Used Informatica Designer to create complex mappings using different transformations like Filter, Router, lookups, XML, Stored Procedure, Joiner, Update Strategy, Expressions and Aggregator transformations to pipeline data to Data Mart.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Implemented Slowly Changing Dimensions (Type1 and Type2) logic for mappings to capture historical data.
• Developed reusable Mapplets, Transformations, Sessions and Parameterized DB connections and Session logs.
• Created sessions, sequential and concurrent batches for proper execution of mappings using Workflow manager.
• Involved in writing Shell Scripts to run batch jobs and automating their schedules.
• Helped out in migration of the mappings, Session and other objects from Development to QA and to Production Server.
• Used DAC to configure and monitor the sessions and also ran weekly loads to update the data within the data warehouse.
• Analyzed, Designed and Developed OBIEE Metadata repository (rpd) that consists of Physical Layer, Business Mapping & Model Layer and Presentation Layer.
• Creation of presentation layer tables by dragging appropriate logical columns from the BMM layer.
• Developed many Dashboards using different Views (Pivot Table, Pie/Bar Chart, Column Selector and Narrative View) with drill-down capabilities.
• Developed and scheduled iBots for delivering personalized reports to users on time.

Enviornment: OBIEE 10.2, Informatica PowerCenter 7.2/8.1.1, Oracle 10g, SQL Server 2005, PL/SQL Developer.

Confidential, Easton, PA

Sr. BI/ DWH Oracle Developer

Responsibilities:

• Interacted with business representatives for requirement analysis and to define business and functional specifications.
• Involved in designing the data model.
• Documenting the entire process. The documents include mapping document and unit testing document.
• Guided team in solution approach, design, development and testing phases of the projects.
• Extensively worked on creating High Level Design documents.
• Involved in requirement clarification meetings with the end users and converting the requirements into designs.
• Worked on creating re-usable components in Informatica.
• Implemented Business rules and logic using Source Qualifier, Expression, Filter, Lookup, Joiner, Rank, Router, Sequence Generator, Normalizer and Update strategy transformations.
• Involved in development activities, unit testing and load testing of ETL jobs.
• Created Connected and unconnected transformations to look up the data from the source and target tables
• Responsible for best practices like naming conventions, Performance tuning and Error Handling.
• Tuning of SQL queries for better performance
• Created Sessions, Workflows, Link Tasks and Command Tasks using Workflow Manager and monitored the workflows/sessions using Workflow Monitor.
• Involved in SIT & UAT phases for support.
• Involved in migration of the mappings, Sessions and other Objects from QA and to Production environment and warranty support.

Environment: Informatica Power Center 7.2, SQL, PL/SQL, TOAD, Oracle 10g, Linux, SSH, UNIX Shell Scripting, Dollar U, Windows XP, JAVA, ADMT.