SUMMARY:

• 7+ years of IT experience in Business Requirements Gathering, GAP Analysis, Data Modeling, Development, Testing, Implementations and Documentations of Data Warehouse / Data Marts deployments and Business Intelligence solutions.
• Experienced in Information Gathering, Requirement Analysis, Data Profiling, ETL architect, ETL Design, Development, Testing, re - engineering, deployments & on time Delivery.
• Extensive working experience on OBIEE repository management (RPD) and the development of custom modules for the Warehouse using Oracle E-Business Applications, Oracle BI (Siebel Analytics).
• Worked on complex reports that require running totals, sub-totals, sub-reports, cross-tabs and conditional display of groups, fields and messages.
• Experience configuring Interactive Dashboards with drill-down and drill through capabilities using global and local Filters, Siebel Security Setup (groups, access / query privileges), Metadata objects and Web Catalog Objects (Dashboard, Pages, Folders, Reports, Session Manager).
• Well versed with Dimensional Modeling (Star and Snow flake) to build the Data warehouse with the approach of Kimball methodology.
• Developed many Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Narrative View, Guided Navigation, Tabular with global and local Filters) using Siebel Analytics Web.
• Experience in Debugging, Optimizing and Performance Tuning of Oracle BI / Siebel Analytical Dashboards/Reports.
• Experience in implementing pre-built Analytics such as Order Management, Order Fulfillment, Sales, Marketing, Forecasting and Finance.
• Experience in developing Informatica Mappings / Mapplets using various transformations for ETL of data from Multiple Sources to Data Warehouse.
• Experience in setting up a Multi-User Development Environment (MUDE).
• Expertise in debugging and optimizing the OBIEE Dashboards / Reports and Informatica Mappings / Workflows.

TECHNICAL SKILLS:

Methodologies: Dimensional Data Modeling Logical / Physical

OBIEE Tools: OBIEE 12C,11.X/10.X, OBIA 7.9.5/7.9.6/7.9.6. X & DAC.

ETL Tool: Informatica 9.x, Informatica on Demand, SSIS.

OBI Apps Modules: Supply Chain, Manufacturing, OM, Financial &Sales Analytics.

Databases: Oracle 10g/11g/12c, MS SQL Server 2005/2008/2012 , DB2, Teradata

Query Tools: SQL, PL/SQL, TOAD

Languages: C/C++, C#, Java, Visual Basic, XML, HTML, CSS, ASP, JavaScript.

Operating Systems: Windows 98/00/NT/XP, Redhat Linux, Windows 2000/2003, UNIX

Other: Visio, MS Office, Adobe Acrobat.

PROFESSIONAL EXPERIENCE:

Confidential, New Jersey

OBIEE /Informatica Developer

Responsibilities:

• Interacted with Subject Matter Experts and Business Analysts for reporting requirements analysis and to define business and functional specifications.
• Analyzed the Business Requirement Documents (BRD's) and created the technical Specifications for the required Subject areas and corresponding Dashboards.
• Conducted on OBIEE Analysis, Dashboard Prompts, Dashboards and so on to Business Users, Financial Planning Manager and other developers.
• Analyzed, Designed, and Developed OBIEE Metadata repository (RPD) from scratch that consists of Physical Layer, Business Mapping and Presentation Layer.
• Built Reporting Dashboards and Pages. Created critical Reports in Answers developed and debugged existing Dashboards / Reportswith differentAnalytics Views(Pivot Table, Chart, Tabular and View Selector),Alerts, Guided Navigation andDynamic Dashboardswith drill-down capabilities using dashboard and page prompts.
• Managed security privileges for each subject area and dashboards according to user requirements
• Developed Metadata repository (.rpd), configured metadata the Business Model Layer & Physical Data Model and Web Catalog Objects as per the data requirements.
• Created detailed documents for all the reports which included the business logic, database connections, types of join statements used, the different filter conditions, details of all the formulas and parameters used, etc. in order to conduct efficient knowledge transfer.
• Create, maintain and optimize existing database components using ETL jobs, stored procedures, views.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements. Analyzed the sources, targets, transformed the data, mapped and loaded the data into the data warehouse.
• Involved in developing the Incremental ETL process by Informatica Mappings & Mapplets using various Transformations and worked on PLP, SDE and SIL mappings & workflows in Informatica.
• Created Reports, Dashboard Prompts and Dashboard Pages like P&L - Budget and Actual, Balance Sheet.

Environment: s: OBIEE 11.1.1.6.5 , OBIA 7.9.6.3, Oracle EBS, Informatica 9.5, DAC 10.1.3.4.1

Confidential, Illinois Chicago

OBIEE Developer/Business Intelligence Analyst.

Responsibilities:

• As a module lead my responsibilities includes project planning, estimation of the effort for development, testing and implementation of various dashboards to comply with company standards and coordinate with the team towards the project milestones.
• Worked on Key Performance Indicators (KPI) within the BI environment which can be used as the catalyst towards driving more responsive interaction between users and data.
• Configured the metadata for KPIs, multiple facts with non conformed dimensions, Level based measures, dimension hierarchies, complex metrics, aggregation, fragmentation
• Developed theOracle BIEEMetadata repository (.rpd)model with for Sales & Marketing subject areas that inviolved creating Physical, BMMlayers with aggregates, dimensions, hierarchies & time series functions, Presentation layerwith catalogs & foldersusingOracle BIAdministration tool.
• Developed Interactive Dashboards using Reports relating to Sales Forecasting, Marketing Campaigns and Financial Analysis with different Views (Drill-Down, guided navigation, Pivot Table, Chart, Column Selector, dashboard and page prompts) using Oracle Presentation Services.
• Customized requests and modified the OBIEE Dashboard using cascading style sheets
• Scheduled and published the new reports OBIEE server based on the existing reporting requirements.
• Created Proactive Alerts /iBots using Siebel Delivers & delivered using Scheduler services.
• Performance Tuning of Dashboards/Reports and made changes to database by implementing the materialized views, re-building of indexes, overwriting the SQL execution path by making use of hints
• Configured the metadata for KPIs, multiple facts with non conformed dimensions, Level based measures, dimension hierarchies, complex metrics, aggregation, fragmentation.
• Have significantly improved the dashboard look n feel by using interactive maps, KPI’s calculated from different business areas, dashboard navigation functionalities, enabling hierarchical browsing & interactions, custom grouping etc.
• Have implemented the business model in Administration Tool by configuring multiple Facts & Dimensions (Drill-Down Hierarchies) & Logical & Facts / Calculated Measures objects in Business Model Layer, and creating the Presentation catalogs in Presentation Layer.
• Configured iBots and scheduled BI Publisher reports to other applications based on requirements to obtain daily and weekly reports.
• Performed Unit, Integration, and Regression testing to validate report and mapping functionality
• Actively participated in weekly Project status meetings and communicated effectively with Project Managers.

Environment: s: OBIEE11.1.1.5, OBIA 7.9.6.4,DAC,Oracle EBS, Oracle Database 11.1.0.x.

Confidential, MA.

Informatica ETL developer

Responsibilities:

• Documented user requirements, translated requirements into system solutions and developed implementation plan and schedule.
• Extensively used transformations like Lookup, Aggregate, Joiner, Filter, Sequence Generator, and Expression to create complex mappings.
• Involved in gathering requirements and prepare Functional and Technical document for development of OBIA Financial Analytics.
• Created mappings to load aggregate tables in the data warehouse.
• Customized workflows, worklets, and tasks using Workflow Designer.
• Used Workflow Manager/ Workflow Monitor to develop, validate and run sequential and concurrent batches and sessions.
• Created email tasks in workflows to send post session and suspension emails as per user requirements.
• Provided support activities to their existing warehouse by developing new pl/Sql programs to support their existing structure and also data validation.
• Performed mapping gap analysis between existing OTB mappings and already existing tables to support the new requirements.
• Developed complex new Informatica ETL process and Mappings &Mapplets using various Transformations (Update Strategy, Filter, Router, Expression, Stored Procedure, Lookup, and Aggregator) and Workflows with Sessions / Tasks.
• Designed and documented multiple interfaces using the Informatica Power Center.
• Developed many complex Informatica mappings and Mapplets to build key interfaces using transformations & reusable transformations (Source Qualifier, Update Strategy, Lookup, Expressions and Aggregator) for loading the data into DW.
• Optimal utilization of object-reusability features like reusable transformations, Mapplets, copying objects from other repositories, using variable / parameters for simplifying complex mappings.
• Performed Database and Informatica performance tuning and implemented the session partitions, changes to database by re-building the indexes, analyzing the objects etc.
• Developed many Shell Scripts for pulling data from remote machines, Backup / Migration of metadata from version, development and production, FTP, sending files to source directory, managing session’s files in the server.
• Extensively developed complex PL/SQL packages for ETL.
• Used the tools and views of Data warehouse Admin Console, objects, tasks, Subject Areas and created Custom Execution Plans and Scheduling.

Environment: Informatica 9.1, OBIEE 11.1.1.6.X,DAC, Oracle 11g, TOAD.

Confidential, Panorama City, CA

OBIEE / Informatica Developer

Responsibilities:

• Involved in gathering and analyzing user requirements in co-ordination with business.
• Designed, Developed and Tested Data security and Dashboard security in Analytics
• Configured measures in the Business Model Layer and mapped to multiple logical source tables.
• Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner.
• Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems.
• Managed security privileges for each subject area and dashboards according to user requirements
• Customized/Created presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders
• Developed many Ad-hoc and standard Reports / Dashboards with different Analytics Views (Drill-Down, Pivot Table, Chart, Column Selector, and Tabular with global and local Filters) using Presentation Services/Siebel Analytics Web.
• Configured Intelligence dashboards by adding content such as links/images, HTML objects and folders
• Used the Catalog manager and maintained the Analytics web catalog to manage Dashboards, Answers
• Assisted in creating Reusable and Non-Reusable Mappings and Mapplets using Filters, Aggregator, Lookups, Expression Aggregator, Sequence generator, sorter, Joiner and Update Strategy Transformation
• Developed Mappings and Workflows using various Transformations (Update Strategy, Router, Expression, and Aggregator) for extracting the billings data from Oracle Applications.
• Developed many shell scripts for executing the workflows using Informatica pmcmd command.

Environment: OBIA/BI APPS 7.9.5.x,, Informatica PowerCenter9.1, Oracle 10g/11g

Confidential

BI Engineer

Responsibilities:

• Involved in data modeling and creation of E-R diagrams.
• Created and maintained Views, Materialized views and Tables Participated in building business areas, workbooks according to user’s requirements and also involved in creating Ad-hoc reports.
• Very good exposure to data warehousing domain, extensive experience in working with OBIEE, ODI.
• In-depth understanding of RPD configuration, Creation of connection pools, Logical tables & columns, Hierarchies, Calculated measures, Variables, Users and groups.
• Goods Hands-on experience in Dimensional modeling like Star and Snow flack schemas.
• Developed Reports / Dashboards with different Analytics Views (Drill-down / Dynamics/Action links/master detail, Pivot table, Chart, Column Sector, Tabular with local and global filters) using OBI Analytics.
• Key contributor in development of Union reports spanning multiple subject areas, Understanding the Design Considerations for Star Schemas and its relationships.
• Proven experience in Authentication, Authorization and managing appropriate Object level and Data Level Security in Web logic server console and Enterprise Manager.
• Proven track record in ETL Tools Oracle Data Integrator and Oracle relationships.
• Assists in OBIEE administration, system maintenance, and upgrades.
• Assists in the administration and implementation of BI system/system security.
• Building geospatial reports/dashboards.
• Builds OBIEE reports and dashboards using BI Publisher, Answers and Dashboards.
• Configures Ad Hoc query and Reporting environments.
• Design, develop, and document OBIEE repository/metadata.
• Develop, implement, and maintain data cubes, loading data, dimensions, calculating data and aggregation techniques.
• Models, configures and optimizes the RPD/Universes from Data Warehouse (OLAP) and databases (OLTP).
• Perform unit, system and integration testing.
• Prepare estimates of time for design and development.
• Provide design and development mentorship/cross- with fellow team members.
• Working in a team environment to develop reports and/or dashboards while working as a team member on an assigned project.
• Works with business users to gather reporting/analytics requirements.

Environment: Oracle 9i, OBIEE 10.1.3.2, SQL Developer, XML/BI Publisher.