EXPERIENCE SUMMARY:

• 5 years of IT experience with extensive Data Warehousing implementations across Retail, Pharmaceutical Industries.Expertise in Finance and Healthcare domains.
• Business Intelligence: 4yearsof experience using OBIEE 11.1.5,10.1.3.2/3.3/3.4and Siebel Analytics 7.5/7.7/7.8.
• 4+ years of ETL experience using InformaticaPowerCenter / PowerMart tool.
• Experience includes three Project Life Cycles encompassing analysis, design, development, configuration, testing, documentation and end user training.
• Experienced in configuring OBIEE Reports & Dashboards, OBIEE Delivers, Narrative views and advanced Reports.
• Extensive expertise in Siebel Answers, Delivers, iBots, and Siebel Intelligent DashboardsSiebel Analytics Admin Tool, Analytics Web and Scheduler forSiebel Analytics stand-alone/integrated implementation..
• Highly Skilled in developing all 3 layers of the Analytics Repository (Physical Layer, Business Model & Presentation Layer).
• Proficient in deploying Informatica workflows to the Siebel DAC and created dependency and dependent hierarchical tasks. Streamlined the Execution Plans with their respective tasks in Siebel DAC.
• Integrated Hyperion Essbase cubes into OBIEE repository. Provided support and administration for Hyperion Planning & Reports.
• Experience in Business Model development with Dimensions, Hierarchies, Measures, Partitioning, Aggregation Rules, Time Series and Cache Management.
• Accomplished in Installation, Configuration and Administration of Informatica Power Center/Power Mart on Client/Server environment.
• Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema modeling, Snowflakes modeling, fact and dimension tables modeling of data.
• Methodologies: Complete knowledge of data ware house methodologies (Ralph Kimball, Inmon), ODS, EDW and Metadata repository.
• Excellent communication, written, interpersonal, analysis and leadership skills. Proven ability to work efficiently in both independent and team work environments.

SKILLSET:

BI Tools: OBIEE 11.1.5,10.1.3.2/3.3/3.4 , Siebel Analytics 7.5/7.7/7.8

Dimensional Data Modeling: Dimensional Data Modeling, Data Modeling, Star Join Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Erwin 7.1/4.5/4.0, Oracle Designer and Visio

Data Analysis: Requirement Analysis, Business Analysis, detail design, data flow diagrams, data definition table, Business Rules, data modeling, Data Warehousing, system integration and team building.

Databases: Oracle 11.1.6/7,10g/9i/8i/8.0/7.x, IBM DB2 UDB 8.0/7.0, MS SQL Server 2005/ 2000 and MS Access.

Environment: Win 3.x/95/98, Win 2000,Win NT, Win XP, Red Hat Linux, Unix, MS-Dos

EDUCATION:

Bachelor of Information Technology

PROFESSIONAL EXPERIENCE:

Confidential, MI Dec 10- Present
Obiee/ Informatica Developer

Masco Corporation is today one of the world's largest manufacturers of brand-name products for the home improvement and new home construction markets. Masco is also a leading provider of a variety of installed products and services, including insulation, for homebuilders.

Key Reports:

AP : Due date analysis for open items , Vendor due date forecast, Vendor payment history with Open item sorted ,List of down payments open on key date , China / APAC - Business tax for non-mainland vendors
AR: Due data for open items [Aging report], Customer due date forecast
COST: Variances of Standard cost vs. Average Cost.
Other: Employee Expense Report,Headcount, Enrollment and Eligibility Reports

Responsibilities:

• Worked on complete lifecycle of integrating new source system into the warehouse. Involved in design, specifications, and delivery of Data Warehouse & Operational Systems; Enterprise through functional level application, data architecture and modeling. Analyzed user and system requirements, preparing and executing unit test cases.
• Created OBIEE Repository (.rpd) which involves Schema Import, Implementing the business logic by customization, Dimensional Hierarchies, Aggregate Navigation, Level Based Measures, Security Management (Data level/Object level security), Variables, Initialization blocks and cache management.
• Demonstrated ability to manage and supervise a team of technology advisors through all phases of the technology life cycle, including requirements definition, architecture, design, development, implementation, conversion and testing.
• Performance tuning of Dashboard/Reports and made changes to database by implementing materialized views and partitions, rebuilding of indexes.
• Successfully implemented OBIEE delivers/Created Proactive agents (iBots) and configured Interactive dashboards to alert the Business/Field users as per the requirements. Created Static and Dynamic variables for several report and Security requirements.
• Setup Usage tracking option to monitor frequently run reports in order to provide caching for the reports and perform database optimization by analyzing query performance.
• Integrated LDAP users to authenticate for BI Publisher and setting up connections to Oracle BI Answers request.
• Worked extensively on Custom Build Real-time reports (OLTP source) to enable Market/Corporate Users to Manage Orders, Installation Management and Cash Management.
• Involved in upgrading the Siebel analytics web catalog to Oracle BI presentation catalog. Also performed upgrading the existing repository for use with Oracle BI infrastructure.
• Extensively used ETL to load data from multiple sources to Staging area (Oracle) using InformaticaPowerCenter 8.1.1.
• Involved in Creating Informatica mappings and mapplets and also tuned them for Optimum performance, Dependencies and Batch Design.
• Loaded the data in incremental fashion by using batches & sessions on Informatica Server Manager.

Confidential, NH Nov 09- Dec 10
Obiee/Informatica Developer

C & S is the largest wholesale grocery supply company in the U.S. and the lead supply chain company in the food industry receiving products from food and grocery companies and ship them to supermarkets and other institutions.

Key Reports:

GL: Balance sheet, Profit & Loss, Statement of cash flows
Controlling/ Costing: Overhead by retail stores, Cost by retail stores

Responsibilities:

• Interacted with Procurement, Operation/Maintenance business representatives for gathering the OBIEE Reports/ Dashboards requirements and define business and functional specifications.
• Created proactive agents iBots and interactive Dashboards to alert the financial team about business changes.
• Identified and analyzed business needs versus existing applications and served as the subject matter expert driving alignment through innovative solutionsin Data Modeling and Data Mapping review, including sources, staging areas, and target database.
• Deployed Informatica workflows to Data warehouse Application Console(DAC) for parallel execution of various tasks within an execution plan with their respective priority.
• Worked onInformatica Power Center tools-Source Analyzer, Target designer, Mapping Designer, Workflow Manager, Mapplets and Reusable Transformations.
• As part of ETL process, loaded data fromFlat files, Heterogeneous Database tables and Excel spreadsheetinto targetOracle database and applied Business Logic on Transformation Mapping for inserting and updating records when loaded.
• Provided Technical Assistance by responding to inquiries regarding errors, problems or questions with programs/interfaces.
• Createdsession tasksto schedule using scheduler in the workflow manager for the transformations and mappings. Scheduled server sessions for the mappings at predetermined time intervals.
• Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent Worklets and Sessions and scheduling them to run at specified time before creating Jobs.
• Used Analytics Scheduler to configure Delivers andiBots to notify the corporate managers and region managers immediately about the messages. Generated iBot alerts for reports to be delivered by email.

Confidential, CT Oct 08-Oct 09
Obiee/InformaticaDeveloper

• Involved in business analysis and technical design sessions with business and technical staff to develop requirements document and ETL specifications.
• Responsible for developing reports/Ad-hoc queries using Answers and assigned them to application specific dashboards.
• Installed Analytics Application in Dev, Test and UAT Environments.
• Defined the Primary, Foreign keys and created Simple and Complex joins between various Dimension and Fact Tables.
• Worked on dimensional modeling to Design and develop STAR Schemas, identifying Fact and Dimension Tables for providing a unified view to ensure consistent decision making.
• Designed and developed the ETL Mappings for the source system data extractions, data transformations, data staging, movement and aggregation.
• Worked on Informatica Power Center 7.1.1 - 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, Mapplets and Transformation Developer.
• Developed standard and re-usable mappings and mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup, and filter.

Confidential, India Jul 07- Aug 08
Siebel Analytics/ Informatica Developer

• Designed and developed the Siebel Analytics metadata repository (.rpd) using Server Admin tool by importing required objects (Dimensions, Facts, Aggregations) with integrity constraints into physical layer using connection pool, developing multiple dimensions and logical facts/ Measures in business model layer, and creating the presentation catalogs in presentation layer.
• Interacted with the Business Requirements and the design team and prepared the Low Level Design documentation studying the High Level Design documents.
• Debugged reports and Dashboards visibility with respect to user's responsibility and web groups in an integrated environment.
• Used SQL plus database application tool wrote complex SQL queries against other Legacy Systems to retrieve data and validate it for Siebel Import process.
• Created workflows to schedule and trigger mappings and Used update strategies to update tables.
• Performed Unit, Integration and Regression testing of various Dashboards/ Reports and repository. Created measures and level Based measures in Business Model
• Designed and developed the ETL Mappings for the source systems data extractions, data transformations, data staging, movement and aggregation.
• Responsible for delivering world-class business and technology solutions that enable client to become high performance businesses.

Confidential,India Aug 06 - Jul 07
Oracle/PL/SQL Developer

• Gathered user requirements and created the business requirements documents.
• Documented the technical specification for the reports and tested the generated reports.
• Created and managed the Database, designed tables.
• Generated SQL and PL/SQL scripts to install create and drop database objects including tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.
• Created Database triggers to maintain the database security.
• Created stored procedures and functions to be called by the application.
• Created trading reports using Crystal Reports.
• Optimized the SQL queries for improved performance.
• Used SQL loader to import data from large flat files and Excel sheets to Oracle tables.
• Prepared test plans for various modules.
• Prepared user manual and technical support manuals.