SUMMARY

• 15+ years of software architecture, Integrations and development experience including: Custom Data warehouse architecture, enhancement to Oracle BI warehouse following Ralf Kimball styles.
• Data modeling (Dimensional, Relational) using a variety of popular ERD tools.
• Prepare strategies for data load to Data warehouse using ODI and Informatica ETL Designer using various data extraction techniques for incremental/full data loads.
• Install and configure ODI/ Warehouse Developer / Informatica Power Center 8.6.1 in a Windows Server 2008 and Microsoft SQL Server 2005/Oracle environment
• Involve in Enterprise Data Warehouse, Data Conversion, Data Integration, ETL services and Data management projects for a variety of industries
• Integration of Various source systems (Oracle EBS R12 (Procurement, Supply Chain, HR) Siebel Apps, Peoplesoft, SalesForce, Jira etc.) with Data warehouse using Microsoft, Informatica and Oracle Technologies (ODI, Warehouse Builder).
• Database table design and implementation for data warehouse and related ETL processes.
• ETL architecture for disaster recovery plan.
• OBIEE (Siebel Analytics 7x) 11g/10x Metadata (Physical layer, Business Modeling layer and Presentation Layer) development using Administration Tool/ BI Publisher
• Work with OBIEE answers to create Master - Details, Scorecards and Strategy, Maps, List/Cross Tab complex report, Global Filters, Prompts, Complex Calculated columns, Format data types and Catalog Management.
• Dashboard management to deliver BI reports content with Global Filters and various types of Graphical Representation of Data.
• DAC management for data load execution plans for Informatica workflows to load data warehouse every night as refresh or Full load from time to time.
• Full software life cycle development across numerous software and hardware platforms in a variety of industries.
• Requirement Analysis, Prototype design, development, and implementation of data warehouse on SQL Server and Oracle Databases with Unix/Windows and ETL.
• Waterfall and iterative data warehouse and application development lifecycle methodologies.
• Agile project development methodology.
• General Business Processes, Offshore/Onsite Model, End User Interactions, Requirement Gathering, Documentation and Great Communication skills.
• Internal infrastructure improvement and knowledge management analysis.

TECHNICAL SKILLS

Tools: OBIEE 11g/10g, Informatica Power Center 7/8.5/8.6, ODI, BI Publisher, DAC, Microstrategy, Business Objects, Crystal Reports, Actuate, Microsoft BI Studio, Microsoft Integration Services, Visio, Erwin, Siebel Tools 7.x/8.0

Operating Systems: UNIX (Sun Solaris, AIX, HPUX, Linux), Windows servers.

Databases: Oracle 10g/11g, Teradata, IBM DB2 UDB,Microsoft SQL Server 2005/08, Microsoft Access, Flat/csv data files, MYSQL.

Languages: Shell Scripts, HTML, CSS, Microsoft Visual Basic, C#, SQL, PL/SQL, T-SQL, ASP.net, VBScript, JavaScript, C, C++.

Industries: K12 Public Schools, Public Sector, Sales, Service, Marketing, Retail, Finance, Telecommunications, Manufacturing, Banking

PROFESSIONAL EXPERIENCE

Confidential

Environment: Oracle Data Integrator (ODI) 10/11, Oracle warehouse Builder, Informatica 8.5/9.x, OBIEE 10g/11g, EBS R12, School Apps by Harris, K12 School data Warehouse by eScholar and Oracle Database 11g, Oracle Linux, Windows Server, BI Publisher and Discoverer.

Data warehouse Architect/Lead Developer

Responsibilities:

• Perform full Data Warehouse life-cycle systems Implementation, development and support
• Work with clients to understand requirements, GAP Analysis and translate to appropriate Technical solution and Documentation
• Develop and test programs using SQL, PL-SQL and SQL-Loader for database applications
• Perform full Oracle R12 Apps development with OBIEE, ETL Informatica/ODI and DAC
• Setup of Development/Test environment and prepare migration methodology to production.
• Data warehouse modeling for custom sources to support OBIEE metadata and interactive dashboards.
• Data integration to data warehouse using ODI, Warehouse Builder and Informatica.
• Ensure Data quality and data validity for various KPI.
• Work with Vendors for outsourced work and lead the development work for OBIEE metadata and data integration with ODI and Informatica.
• Write SQL/PLSQL code using SQL Plus, SQL Loader, SQL Developer for data extractions as per required by eScholar CDW and Informatica Power center for OBIEE Data warehouse
• Work with End users to create new dashboards and BI publisher documents as per requirements
• Code fixes for OBIEE dashboard reports, metadata, Data integration mappings and deploy to production
• Prepare Code migration documents for deployment to production

Confidential

Environment: Informatica 8.5, SQL Server 2008, PeopleSoft Financials 8.4, Salesforce.com, OBIEE, Crystal Reports, Excel Reporting, and Windows 2008 servers, Oracle Hyperion Essbase.

OBIEE Administrator/Developer, Informatica Data Integration Expert

Responsibilities:

• Requirement gathering, Analysis of the requirement and Team building.
• Infrastructure requirement study for Software and hardware servers
• Configuration analysis for Data extracts based on Peoplesoft Financial application.
• Customization to Data warehouse schemas to include custom tables and columns.
• OBIEE implementation, Administration, Code movement, Testing and Development.
• Dimensional Data modeling to include Fact Tables and dimension Tables for Service, Sales and Finance System.
• Configure Time series data dimension.
• Install Setup, Configure Informatica and Database environment for Regular and Disaster Recovery site.
• Setup Informatica schedulers for automated Jobs for data extractions and alerts
• Informatica Code Migration to QA and Production
• Performance analysis and fine tuning data load process through SQL and Informatica
• Support Informatica ETL Jobs 24/7 for production issues and work with Informatica support for Service requests
• Custom Build Database to hold SalesForce data and Build Dbamp jobs to extract source data.
• Customize/Create Informatica ETL extractions for SalesForce Data warehouse.
• Used Informatica Designer to import the sources, targets, create various transformations, mappings for extracting, transforming and loading operational data into the Siebel OLAP database. Worked with various transformations such as expression, Lookups, filter, rank, source qualifier, joiner, aggregator, stored procedure and normalizer in the mappings.
• Create Reports in Excel power pivot, OBIEE and Crystal Application.
• Oracle Hyperion EPM suite installation, Bug fixes, integration to OBIEE and upgrade.

Confidential

Environment: Custom Service System, Oracle Siebel CRM, Informatica 8.5, SQL Server 2005, Oracle 10g, Linux, Windows 2003 Servers, Actuate, OBIEE, Data warehouse.

OBIEE and Informatica Developer

Responsibilities:

• Systems Analysis, Requirement Gathering and Customer interaction.
• Upgrade and Support Siebel applications (Call Center/Sales, eBusiness Applications) to Latest version 8.1.1.
• Use Business Intelligence tools such as BI publisher etc., for Siebel Reporting.
• Perform Enterprise Integration Manager Tasks with Siebel OLTP data sources and legacy database systems.
• Data modeling for custom enterprise applications.
• Work with SQL, PL/SQL, HTML, XML, JavaScript, Siebel Tools, Informatica, Repository Management with Business Intelligence Analytics Tools, Operating Systems - Windows, Sun Solaris, AIX and Shell Scripting, Microsoft SQL server and Oracle Database.
• Use Actuate reporting Tool for transactional databases.
• Install and optimize Informatica environments with various server parameters
• Data modeling for data warehouse and ODS for centralizing data for reporting.
• Prepare strategies for data load to Data warehouse staging tables and Conversion using various transformations to load data into warehouse tables using Informatica ETL Designer.
• Data warehouse schema customization as per changes done to OLTP Application.
• Create Complex SQL for analysis of data in source system and central database.
• SQL optimization for performance tuning of the data load jobs.
• Install, Setup, Configure OBIEE environment.
• Use OBIEE Administration tool to develop new metadata (Physical Layer (connecting Data sources and import schema), Business Model and data mapping (create Logical tables and data source mapping) and Presentation layer level (create presentation catalogs)) for OBIEE reports.
• Administer OBIEE dashboards, Security, Single Sign on, Web catalog, Code migration to QA and Dev.

Confidential

Environment: Oracle Siebel Sales, Marketing, eCommunication, Informatica 7.1, Oracle 10g, Sun Solaris, Windows 2003 Servers, Actuate, OBIEE 7.5/10.1.3.4 , DAC, Oracle Data warehouse.

OBIEE / Informatica Administrator / Data warehouse Developer

Responsibilities:

• Analysis of Business Requirements, Data warehouse and Siebel Applications (OBIEE & OLTP) functionalities.
• Support Informatica data loads and process 24/7
• Customize Data warehouse for new Transactional Tables and columns to support new functionality.
• Create new Informatica ETL mappings (Source, Target, Source Qualifiers, and Update insert strategy, Sequencer, Lookups and Mapplets) to load data for new Facts and Dimensional Tables.
• Create workflow with Informatica workflow manager and schedule them to run every day.
• Version control for Informatica code and migration to QA and production.
• Setup Informatica security for various users and Active directory users
• Work on production data load issues and fix with the help of Informatica Global support
• Worked with SQL, PL/SQL for OLTP and OLAP databases
• Developed/Customized Actuate reports and Integration with Siebel Application.
• Communication with Business team/ End users for new requirements and change requests.
• Generate new OBIEE repository metadata for new warehouse tables and columns using Admin tool.
• Create OBIEE reports using answers and publish them on dashboards.
• Resolve OBIEE issues in production, work with Oracle Support, escalation of SR, Production Migration for Informatica and OBIEE.

Confidential, Herndon, VA

Siebel Analytics Data warehouse and ETL Developer

Responsibilities:

• Prepare Adhoc Queries with OBIEE Tools (Answers, Dashboards, Catalog, Physical, Logical and Presentation layers of analytics Repository).
• Develop / Modify ETL mappings using Informatica Designer to load data into Siebel OLAP database from Siebel OLTP databases.
• Install and configure Informatica servers.
• Performance analysis of the data load process
• Security model setup for corporate users with LDAP integration
• Work with various transformations such as expression, filter, rank, source qualifier, joiner, aggregator, stored procedure and normalizer in the mappings.
• Data testing and verification of Data warehouse facts as compared to OLTP data.
• Informatica server administration

Confidential

Data integrator to legacy System using EIM and SQL Loader

Responsibilities:

• Work with Enterprise application users to get requirement and analyze to convert to Technical documents.
• Prepare Data files for feed to EIM process to load data to Siebel CRM applications.
• Write shell scripts to automate data load jobs.
• Data verifications of the data loads to Siebel CRM.
• Train other team members for Business Applications.
• Customize Siebel CRM application using Siebel Tools.
• Create / Update Business Rules in Siebel CRM based on the procedures in use by the organization.
• Siebel Administration for users, groups and LOVs.

Confidential

Siebel applications Developer and Integration expert

Responsibilities:

• Install, Setup, Upgrade Siebel CRM applications.
• Customize Siebel CRM applications based on requirements from users.
• Prepare Strategies for Data integrations from Legacy Applications to Siebel CRM applications.
• Data loads to Siebel Application with SQL loader and EIM.
• Reports development for Siebel Applications using Actuate reports development workbench.
• Prepare user guide documents for Enterprise applications.
• Administration of Siebel CRM.
• Testing of various functionalities.

Confidential

Application Developer

Responsibilities:

• Requirement gathering from users, analyze, convert them to Functional documents.
• Data modeling for Enterprise applications.
• Design Application forms based on requirements.
• Write Microsoft Visual Basic Scripts for Enterprise applications.
• Testing of Enterprise Applications.