PROFESSIONAL SUMMARY:

• Over 7+ years of total IT Experience with 5+ years of extensive experience on Business Intelligence using OBI EE/Siebel Analytics 7.x.
• Expertise in Complete SDLC of Analysis, Design, Development, Maintenance and Documentationof various functionalities of OBIEE.
• Very strong experience in developing OBIEE Repository (RPD) - three layers (Physical Layer, Business Model & Presentation Layer), Time Series Objects, Siebel Interactive Dashboards with drill-down capabilities using global & local Filters.
• Expertise in repository development, configured metadata objects (Subject Area, Table, and Column) and web catalog objects (Dashboards, Pages, Folders, Reports).
• Practical understanding of theData modeling(Dimensional & Relational) concepts likeStar-Schemamodeling,Snowflakesmodeling, fact and dimension tables modeling of data.
• Extensive experience in Siebel Analytics, Admin tool, dashboards, configuring dashboard, user, report level security, metadata tools, and user interface designs.
• Proficient in the Design and Customization of Seibel Answers, Reports, Dashboards, iBots and Siebel Delivers.
• Experienced in Data Analysis, Identification of Dimensions, Facts, Measures, Hierarchies developed Reports/Dashboards with different Analytics Views (Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular with global and local Filters) using Siebel Analytics Web.
• Experience in setting upintegrationwithPresentation servicesforBI Publisher.
• Expertise in SiebelSecurity Setup (groups, access / query privileges).
• CustomizedSecurity levelsby assigning privileges for various Groups and Users.
  Set privileges for the same at bothObject level (Metadata) and Data level (Reports).
• Experienced in Installation, Configuration, Upgradation, Migration and Administration of Informatica Power Center/Power Mart Client.
• Experience in data warehousing methodologies for Extraction, Transformation and Loading using Informatica PowerCenter (Repository Manager, Workflow Manager and Workflow Monitor).
• Experience in Performance Tuning of Informatica mappings, sources, targets and sessions.
• Expertise in debugging and optimizing the Siebel analytics dashboards/reports and Informatica mappings/workflow.
• Strong skills in Oracle PL/SQL backend programming like Stored Procedures, Functions, Cursors, Triggers and Packages and also on MS SQL Server.
• Created Test plans, Test objectives, Test strategies and Test cases in the QA Testing phase.
• Strong Communicator and Creative Problem-Solver skilled at understanding business needs and transforming them into technical designs, applying technical skills.

TECHNICAL EXPERTISE:

Business Requirements Analysis and Process Mapping.

BI/OLAP:

Siebel Analytics 7.8.4 / 7.8.2 / 7.7/7.5, OBIEE 10.1.3.x, BI Publisher.

DW/ETL Tools:

Informatica Power Center 8.1.1/7.1.2/6.1.

Data Modeling:

Star Schema Modeling, Snow-flake Schema.

Database:

Oracle10g/9i/8g, MS SQL Server 2005 & 2008, MS Access, DB2, SAP BW.

Languages:

C, C++, SQL, PL/SQL, SQL*Plus.

Web Technologies:

HTML, XML, HTML, JavaScript.

EDUCATION:
Bachelor of Engineering, JNT University, India.

PROFESSIONAL EXPERIENCE:

Confidential, Parsippany, NJ March 2009 - Present
Data Warehouse / OBIEE Developer

Confidential, is a multichannel, pharmacy research company that specializes in Brand Promotional programs, e.g., e Detailing (online & convention-based), brand analysis, Patient education, adherence, and persistency programs leveraging the strengths of Internet, multimedia, tablet PCs, dimensional direct mail, and proprietary software to allow clients to better understand the needs and opinions of their audiences and, in turn, to market their brands more effectively.

Responsibilities:

• Established and enforced overall modeling standards, guidelines, best practices, techniques and approaches.
• Involved in gathering the requirements, performing scope analysis and identifying gaps.
• Gathered business requirements, performed Business Requirement analysis andpreparedETL Technical specs.
• Served as an SME in all aspects of Data mart and ETL design & development.
• Designedstart schemaand usedsnowflakeswhere ever necessary.
• Developed data mapping spreadsheet to present the transformation process.
• Created complex Informatica mappings to load the data mart and monitored them. The mappings involved extensive use of transformations likeAggregator, Filter, Router, Expression, JoinerandSequence generator.
• Expertiseinperforming optimization analysis.
• Optimized theCachefor Dynamic, Static and Persistent Cache Lookup Transformations.
• Created several aggregate tables to improve the reports performance.
• Developed OBIEE Repository as per user requirements and available information in Data Warehouse.
• Analyzed and validated the business model in OBIEE Administration Tool by performing consistency check, validating logical source tables, logical columns, and also validating repository level calculations done in the business model layer.
• DevelopedSCD type 2mappings in informatica andconfigured in rpd.
• Implemented afact less facttable forglobal promptin the OBIEE dashboard as part of improving performance of global prompt.
• Configured navigational links and drills while creating Dashboards.
• Used IBOT caching mechanism to cache reports which took a long time to run.
• Created severalaggregate tablesas part of improving performance and configured accordingly in rpd.
• BI Answerswere used generating web-based reports for executives and management individuals.
• Designedexternal table authenticationas part of security deployment.
• Coordinated the QA team with development team for the new release of the software.
• Worked closely withBA Teamto understand theBusiness Requirements.
• Documented processing times for each module, developed test cases and used them to run through each process. Tuned the matching parameters based on test results.
• Provided production support.
• DesignedTest Plans,Test Casesand Test Procedures.
• UsedTest Directorfor bug tracking and reporting, also followed up with development team to verify bug fixes, and update bug status.
• Involved in end user training.

Environment:Informatica Power Center 8.1.1, OBIEE 10.1.3.4 Test Director, Oracle 10g, Flat files, Oracle SQL Data modeler, MS Excel, SQL, PL/SQL, TOAD, RED HAT LINUX.

Confidential, VA February2008 - March 2009
Sr. OBIEE Developer

Confidential, offers a student-centered environment about 100 miles southwest of Atlanta. Through engaging learning experiences, CSU aims to educate students for career and life success.

The scope of this project is to deliverkip's in three areas including APPLICANT METRICS; SCHOLOSTIC METRICS AND FINANCIAL METRICS.CSU uses SUNGAURDBANNERas their OLTP system. We have built the data warehouse usingtalend open studio.

Responsibilities:

• Validated the target/destination tables after the data loading mechanism was automated using Data Stage routines.
• Involved in Gathering business requirements to prepare KPI document.
• Designed start schema and modeled usingOracle sql data modeler
• Developed source to target mapping spreadsheet.
• DevelopedETLjobs using Talend open studio which includesscd type 1andscd type2.
• Installed and configuredOBIEEon a red hat Linux server.
• Installed client tools and usedodbc to connect to bi repository.
• Used Linuxshell scriptsto automate the bi server start after booting the Linux box.
• Developed obieerpd(physical layer, business model layer, presentation layer).
• Implemented dimensional hierarchies within bmm layer.
• Designed and developeddashboardwhich includes several kind of reports.
• Implemented guided navigation to achieve some of the drill downs.
• Involved in migration to test environment and to production environment.
• Worked closely with functional people to validate data.

Environment:Talend open studio, Oracle 10g, OBIEE 10.1.3.4, Oracle SQL Data modeler, MS Excel, SQL, PL/SQL, TOAD, RED HAT LINUX.

Confidential, Franklin Lakes, NJ April 2006 - January 2008
OBIEE/Reports Developer

Confidential, within USA implement a CRM strategy (Integrated Customer Management). The solution is focused on the needs of the sales forces, call centers and delivering a Sales and analytical environment for ISFA. The objective is to implement business priorities on Field Time Optimization, Segmentation & Sales Line Targeting and Account Contact and Opportunity Management in a centralized operational model (Single instance).

Responsibilities:

• Installation and Requirement Gathering & Analysis.
• Installed and configured the OBIEE 10.1.3.2 server and dealt with the installation issues.
• Participated in the Business requirements gathering meetings with the end users/business people.
• Working closely with Business Analysts and DBAs on physical database design
• Developed and maintain Data modeling standards, policies and procedures
• Enforce data quality measures and data elements naming standards at the time of validating logical data model components
• Experience in Conceptual, Logical and Physical Modeling
• Extensive experience in designing dimensional models such as Star Schemas.
• Involved in Siebel Analytics gap analysis related to SRMW Data Model and ETL, creation of detailed design documentation, accurately mapping requirements into Siebel Analytics functionality
• Responsible for preparing the Technical Design document keeping in view the end user requirements.
• Involved in Usage tracking and scheduler implementation.
• Configured Oracle BI scheduler in an application and server that manages and schedules the job
• Configured Proxy Users.
• Involved in Data level and object level security model in OBI presentation catalog to view there report according to the user level/position and permission
• Responsible for creating custom columns in the BMM layer to calculate the percentage changes in the sales.
• Created various Ad-hoc reports for day-to-day business requirements making use of global and shared filters with different views in accordance with the requirements
• Created sales reports to compare Current cycle and previous cycle sales using Pivot table views.
• Performed Repository Testing and validation before exposing Business Models in the Presentation layer.
• Generated I Bots using the Delivers to send notifications to the users.
• Worked on setting up both data and user level securities at Administration level and Server levels.

Environment: OBIEE 10.1.3.2, Informatica Power Center 8.1, Oracle 10G, Windows XP.

Confidential, Plymouth, MNJune 2005 - March 2006
Siebel Analytics Reporting / Functional Analyst

Responsibilities:

• Worked closely with Business user in Understanding the Analytics reporting needs from target user groups.
• Actively involved in gathering user requirements and GAP Analysis
• Worked extensively on Customizing Siebel Vanilla Analytics Repository, that includes Physical Data Layer, Business Model and Presentation Layer in Siebel Analytics Administration Tool.
• With the Security settings in Siebel Analytics Admin Tool to set up users, groups, access privileges.
• Involved in Dimension modeling, Identified business attributes and measures, defined dimensional model (STAR Schema) to store the business attributes and measures.
• Created Reports in Siebel Answers/Dashboards in Analytics Answers
• Created Reports for the opportunity forecasts to measure the potential business, as well as the business to measure lost business opportunity and the factors associated with it to aid the management.
• Developed calculated measures and assigned Aggregation levels based on dimension hierarchies.
• Designed various reports like Drill Down, Pivot, Break down Reports and Nested reports in Answers and configured Intelligent Dashboards for different user groups to view data across regions and Customer Demographics with the facility of drill downs and Charts.
• Trained the end users in accessing reports in pre-built dashboards, configuring their personal "My Dashboard", creating sharing reports with shared folders etc.
• Implemented Data Level security into Business Model that has both Position Based Security and Geo based security for different user groups.

Environment: Siebel Analytics7.5, Informatica 6.1, Oracle 9i, SQL Server 7, Windows 2000, IE 6.

Confidential, INDIA April 2004 - May 2005
Oracle Developer

Responsibilities:

• Extensively involved in coding of the Business Rules throughPL/SQLusing theFunctions, Cursors, Triggers,Stored Procedures, andPackagesin the server side.
• Participated actively in the technical and functional discussions.
• Extensively involved in designing the project and coordinating a highly professional team.
• Interacted with the user group on a regular basis to discuss requirements and updates.
• Used Forms to provide the interface for the application and Reports to takeperiodical reports.
• Responsible for the Instructor module user interface design, implementation and testing.
• Generated reports and graphs to study instructor utility percentage every quarter and display the feedback results.
• Was responsible for providing expertise training to end users on the new system and its user interface and reports running procedure.

Environment: Developer 2000, Oracle 8i, SQL *Loader, Windows 2000.

Confidential, Mumbai, India May 2003 - March 2004
Data Warehouse Developer

Central Data Module is financial services application dealing with data related to Online Banking, Equities, Fixed Income Mutual Funds, Bonds, etc. The application enables the customer to trade the stocks along with providing real time quote information and news.

Responsibilities:

• Implemented Aggregate, Filter, Joiner, Expression, Sorter, Lookup and Update Strategy, Normalize, Sequence generator transformations.
• Created Mapplets in Designer and used those Mapplets in the Mappings.
• Executed sessions, sequential and concurrent batches for proper execution of mappings and sent e-mail using server manager.
• Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters.
• Used the Workflow manager to create Workflows, Worklets and Tasks.
• Partitioned source data and performed extract, transformation and load for each partition in parallel using an Informatica server for achieving high performance.
• Troubleshootsystem issues, monitoredscheduled jobsand set up maintenance plans for proactively monitoring the performance ofSQL Server databases.
• Proficiency of writing complex SQL queries and demonstrated ability to collaborate with other developers during design, development, and testing.
• Created and Monitored Sessions and Batches using Server Manager to load the data into the Target Database.

Environment:Informatica Power Center 6.0 (Designer, Workflow Manger, Workflow Monitor and Repository Manager), SQL Server 2000, Oracle 8i, SQL, PL/SQL, Windows 98.