Developer Manager

Shashi Malraj

**********.******@*****.***

SUMMARY

• About 8+ years of experience in complete software development life cycle (SDLC) implementation of various Business Intelligence and Data Warehouse / Data Marts that covers gathering business requirements, proof of concept, GAP analysis, design/modeling (Star and Snow flake), development, implementation and docmentation(Oracle AIM).

• Experienced in configuring interactive Dashboards with drill-down capability by making use of Filters, OBIEE Security Setup (groups, access/query privileges), Metadata Objects and Web Catalog Objects (Dashboards, u Pages, Folders, Reports).

• Designed Schema using Fact, Dimensions, Physical, Logical, Alias and Extension tables.

• Designed and developed OBIEE 11g metadata repository(.rpd) using Oracle BI admin tool by importing the required objects (Dimensions, Facts & Aggregates) with constraints into physical layer by employing connection pool, developing multiple dimensions & Logical & Facts measures objects in BMM Layer, and developing web catalog in presentation layer.

• Expertise in Business Model development with Dimensions, Hierarchies, Measures, Aggregation Rules, Time Series & Caching.

• Created, modified, and administered analytics Intelligence Dashboards with links to web sites; HTML text; links to documents; and embedded content, such as images, text, charts, and tables

• Implemented security by creating roles & web groups, checks with external tables & LDAP

• Administered various OBIEE (Siebel) environments with large number of users and provided optimum system uptime and performance. Designed security matrix, configured authentication and authorization architecture, and provided permissions to users according to their role.

• Experience in developing OBIEE repository from scratch in past projects. Developed many reports/dashboards with different analytics views (drill-down/dynamics, cascading style sheets, pivot table, chart, column sector, tabular with local and global filters) using OBIEE Answers/Dashboard. Troubleshoot various technical issues and bugs

• Expertise in debugging, optimizing the performance tuning of OBIEE repository & dashboards/reports.

• Expertise in bridging gap between IT and business to exchange ideas, resolve outstanding issues and rolling out innovative and strategic reporting roadmaps utilizing key performance Indicators (KPI’s) and business performance metrics

• Did configuration of NQSCONFIG.INI file for usage tracking.

• Developed different kinds of Reports (pivots, charts, tabular) using global and local Filters.

• Employed OBIEE Delivers for sending real-time, personalized alerts via intelligence agents (iBots) to intelligence dashboards for subscribed users.

• Worked on UNIX /LINUX scripts for pre and post session command lines

• Good understanding of dimensional modeling and relational database management systems.

• Experience in writing various Stored Procedures, SQL Cards, PL/SQL Blocks, and Triggers in EDW environment.

• Experienced in BI Publisher, MS Office Plug-in for rich reporting and Oracle BI Scheduler Configuration for Alerts / iBots.

• Experience with TOAD and Oracle SQL Developer.

• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica PowerCenter/PowerMart 8.1.2/7.1.x/6.x. (Repository Manager, Designer, Workflow Manager and Workflow Monitor).

• Good Experience in working with Teradata 7.1.0.02, Oracle 9i, DB2, MS SQL server 2000.

• Extensively used Teradata and Oracle utilities such as FastLoad, Multiload, Tpump and Toad.

• Expertise in Configuring and maintaining Siebel relationship management warehouse (SRMW).

• Responsible for Unit and Integration testing in various environments.

• Developed effective working relationships with Business Analyst to understand support requirements, develop tactical and strategic plans to implement technology solutions, and effectively managed Business expectations.

• Strong Analytical, Interpersonal, Problem Solving, written and communication skills.

TECHNICAL SKILLS

OLAP Tools OBIEE 10.1.3x, 10.1.3.4.1, OBIEE 11g, Seibel Analytics 7.8/7.7/7.5/8.0

ETL Tools Informatica PowerCenter/PowerMart(8.1.2/7.1.x/6.2/5.1)

Languages SQL, PL/SQL, C++, COBOL, UNIX shell scripting, Visual Basic 6.0

Databases Oracle 7.x/8.x/9i/10g, Teradata 7.1.

0.02, SQL Server 2000, MS-Access 98/2000

Modeling Tool ERWIN 4.1.2, Microsoft Visio

Database Tools Toad, WinSQL, SQL Developer

Methodologies Star Schema, Snowflake Schema, MS Office Suite

BI/OLAP Tools Cognos 5.0/6.0/7.0 (Impromptu, Powerplay), Business Objects (Supervisor, Designer, Business Objects) V4.1/5.0/5.1

Operating Systems Windows 9x/NT/2000/XP, UNIX

General Applications MS Word, Excel, Outlook, Lotus Notes, FrontPage, PowerPoint

PROFESSIONAL EXPERIENCE

Biogen Idec, Morrisville, NC Jul 2009 – Till Date

OBIEE\BI Publisher Developer

Responsibilities:

• Worked closely with the ETL team to determine the granularity and figure out the facts and dimensions.

• Developed and tested RPD (Physical, BMM and Presentation Layer), configured metadata objects and web catalog objects as per the client and reporting requirements using OBIEE Admin Tool and Web tool.

• Developed the repository model for different work with the necessary logic that involved creating the Physical, BMM and the presentation layer. And also determined whether measure calculations should be done in ETL or in metadata. Created level based measures, new logical columns and enforced conditions on the columns in the logical layer for query optimization

• Developed connection pools, physical tables, defined joins in the physical layer of the repository

• Involved in modeling activities which includes building Star Schema as per business requirements and configuration of Logical Layer, Logical Tables, Dimensions and Columns. Established the logical joins/keys required to support drill-down aggregation.

• Developed the metadata repository, created dimension hierarchies using multiple dimensions, and customized presentation, business and physical layers as per the requirements.

• Designed Star Schema from Snowflake using Bridge Tables.

• Done complex calculations to derive the Weighted Averages, and used Time series functions(ago and todate)

• Performance tuning of dashboards/reports and made changes to database by implementing the materialized views, aggregate tables, etc.,

• Extensive experience in working with Repository/Session Variables and Initialization blocks.

• Design and development of various Reports / Dashboards that are dynamic and interactive with drill-down capabilities and local & global filters, prompts, column selectors and view selectors.

• Successfully delivered many BI-Publisher reports (with & without parameters) by choosing the suitable layout using BI-Office (BI Publisher plug-in for MS-Word).

• Created BI-Publisher Groups (XMLP_ADMIN, XMLP_DEVELOPER, XMLP_TEMPLATE_DESIGNER) in RPD.

• Used repository variables to dynamically modify conversion values for logical column formulas

• Developed new dashboards on the business needs, implemented dynamic column naming and dynamic logo which is driven through DB tables. Displaying logo depends on user credentials.

• Configured Row Level Security and Object level security to allow users to view their respective data only according to the requirement

• Customized the look and feel (Skins & Styles) for OBIEE products (Answers Login Page, Banners, CSS files, etc.) as per company specific standards.

• Configured iBots/Delivers to alert the business users about key changes.

• Managed OBIEE administration including manage sessions, create users and cache management.

• Created users and user groups and added security to the groups (data level and object level security).

• Experience in working in Multi-User Development (MUD) environment

• Extensive experience with Catalog Manager to merge the Catalogs.

• Involved in Reconciliation Process while testing loaded data with user reports.

• Involved in Optimizing the Performance by eliminating Target, Source, Mapping, and Session bottlenecks.

• Performed unit testing, integration testing on the deliverables to analyze the errors and fix them.

Environment: OBIEE 10.1.3.4.1, Administration tool, OBIEE Answers/BI Publisher/ Dashboards, Oracle 10g, Informatica Power Center 8.1, DAC, Linux, TOAD, PL/SQL, Mercury Quality Center.

OPTIMOS, Reston, VA Jan 2008 - April 2009

OBIEE Developer

Responsibilities:

• Worked closely with Business Analysts to gather the Analytics requirements and translated business requirements to technical considerations for Data Warehouse and Reporting.

• Created the Business Model in Repository for generating reports as per the requirements.

• Involved in modeling activities which includes building Star Schema as per business requirements and configuration of Logical Layer, Logical Tables, Dimensions and Columns. Established the logical joins/keys required to support drill-down aggregation.

• Created connection pools, physical tables and defined joins in the physical layer of the repository.

• Extensively used OBIEE Admin Tool for customizing and developing Business, Physical and Presentation Layers of Metadata Repository.

• Designed and Developed OBIEE Metadata Repository(.rpd) using OBIEE Admin Tool by importing the required objects (Dimensions, Facts & Aggregates) with integrity constraints into Physical Layer using connection pool, developing multiple Dimensions (drill-down hierarchies), Logical, Facts/Measures Objects in Business Model Layer, and creating the Presentation Catalogs in the Presentation Layer.

• Created dimension hierarchies and assigned levels and custom aggregation rules for each level.

• Involved in creating Users, Groups and managing the object level and data level security.

• Integrated BI Publisher with OBIEE answers and performed configurations.

• Delivered BI Publisher reports in different layouts (Charting, Conditional Formatting, Filter, Sort, Hide, Formulas and Functions, Rich text formatting, Multiple table and forms layout and Bar Coding)

• Designed and Configured Dashboards for different user groups with drill-down capabilities.

• Configured Repository and Session variables to get dynamic Reports and Dashboards.

• Worked extensively on OBIEE Answers to create reports as per the requirements.

• Configured Row Level Security and Object level security to allow users to view their respective data only according to the requirement

• Developed different kinds of reports (pivots, charts, tabular) using global and local Filters.

• Involved in feasibility study and Prototyping some of the main reports for OBIEE.

• Enhanced performance by creating aggregate tables, Indexes and managing cache.

• Configured iBots to deliver analytics content based on schedule, automated iBots queries to obtain reports & sent notifications Alerts to Managers.

• Used TOAD to debug the SQL query to identify duplicate rows in the warehouse tables, and to debug SQL query issued during report execution.

• Worked collaboratively with Infrastructure and support teams, consultants, project managers, and corporate development to develop consulting and project methodology, techniques, tools, and solutions.

• Involved in intensive end user training (both Managers and business users in Presentation Services) with excellent documentation support.

Environment: OBIEE 10.1.3.x, Informatica, Oracle 10g, Oracle Applications R12, PL/SQL, TOAD,SQL Developer, windows XP.

AIG Insurance, New York, NY Oct 2005 - Aug 2007

OBIEE Developer

Responsibilities:

• Involved in requirements gathering and developing reports as per the user requirements.

• Extensively worked with Physical Layer, Business Layer and Presentation Layer.

• Worked on the OBIEE Administration tool to develop and in customizing, developing Business, Physical and Presentation Layers of Metadata Repository.

• Worked on Oracle BI Answers to develop different queries, format views, charts, and added user interactivity, dynamic content to enhance the user experience.

• Created and customized Dashboards for different user groups with drill-down capabilities.

• Developed different kinds of reports (pivots, charts, tabular) using global and local Filters.

• Configured iBots to deliver analytics content based on schedule, automated iBots queries to obtain reports & sent notifications Alerts to Managers.

• Created dimension hierarchies and assigned levels and custom aggregation rules for each level.

• Was responsible for creating Users, Groups and managing the object level and data level security.

• 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 and changed logical tables, logical columns in the business mapping and modeling layer.

• Worked on business requirements and designed design documents.

• Extensively worked on configuring the repository in the physical, Business and Presentation layer.

• Experienced in working with pivot table format, and graphs.

• Worked on cache purging programmatically using event-polling table.

• Involved in managing appropriate security privileges on subject areas and dashboards according to business requirements.

• Created global filters for use in exercising dashboard wide control over requests that are embedded into a dashboard page.

Environment: OBIEE 10.1.3.1, Informatica 6.2, Oracle 9i, Windows XP

Exelon Energy, Chicago, IL Jul 2004 - Aug 2005

Siebel Analytics Developer

Responsibilities:

• Interacted with business representatives for requirement analysis and to define business and functional specifications.

• Created/Modified Metadata repository (.rpd) by using Siebel Analytics Admin tool: Physical, Business Model and Mapping, and Presentation Layers.

• Designed the Siebel Repository Physical layer and created the Star Schema in Business Model.

• Designed and customized Siebel Answers, Reports and Siebel Delivers according to the requirement.

• Extensively used Siebel Answers to support end users

• Managed the Analytics Cache environment.

• Configured Dimension table in Business layer for Drill down functionality.

• Created user level security for intelligence dashboards based on Business Requirement.

• Design and development of custom reports

• Configured metadata objects (Subject Area, Table, and Column) and Web Catalog Objects (Dashboard, Pages, Folders, and Reports).

• Configured iBot to deliver Analytics content based on schedule, automated iBot queries to obtain weekly reports and updates.

• Involved in the ETL development using Informatica.

• Troubleshoot and resolve system integration test issues.

Environment: Siebel Analytics 7.8.4, Informatica PowerCenter7.2, Oracle 9i/10g, Oracle Applications 11i, Sun Solaris, TOAD.

Exxon Mobil, Fairfax, VA Sep 2003 – Jun 2004

ETL Developer

Responsibilities:

• Analyzed software requirement documents and business requirement and assisted in high level data modeling using Erwin data modeling tool.

• Extracted data from multiple sources, which included relational sources, Flat-Files and VSAM Datasets.

• Used Informatica Power Exchange to import source definitions form Mainframe system to Informatica Power Center.

• Worked on Informatica – Source Analyzer, Data warehousing designer, Mapping Designer, Mapplets designer and Transformations.

• Responsible to document interface requirements and program specifications and to obtain client approval on all requirements and specifications.

• Extensively designed, developed, tested complex Informatica mappings, Mapplets and to extract data from external flat files, oracle tables using Informatica.

• Extensively worked on ETL performance tuning, worked with DBAs for SQL query tuning etc.

• Implemented Join, Expression, Aggregate, Rank, Lookup, Update Strategy, Filter and Router Transformations in Mappings. Used Debugger to test the mapping at designer level.

• Implemented Slowly Changing Dimensions methodology to keep track of historical data.

• Involved in writing UNIX shell scripts for Informatica ETL tool to run the Sessions.

• Developed PL/SQL stored procedures for source pre load and target pre load to verify the existence of tables.

• Worked on Informatica developments and enhancements by creating new mappings and making changes to the existing mappings as per the business requirements.

• Extensively used PL/SQL programming in backend and front end functions, procedures and packages.

• Developed ETL DASH BOARD, which is used to track all the daily and monthly load statistics.

• Developed email routines to indicate failure or successful completion of workflows.

• Developed ad hoc reports using Business Objects 6.5 and also created custom reporting solutions.

Environment:

Informatica Power Center, Oracle 10g, Teradata, UNIX, PL/SQL, Toad, Business Objects.

Honeywell, India Jun 2002 – Jul 2003

Data Warehouse Consultant

Responsibilities:

• Analysis of Source, Requirement, existing OLTP system and Identification of required dimensions and facts from the Database.

• Loading the Data from the tables into the OLAP application.

• Writing batch programs and database triggers at staging area for population of warehouse.

• Creating Sessions and batch management and Performance Tuning and initial testing followed by the volume testing Resolve technical issues with software consultants and vendors.

• Documentation of existing mappings as per standards.

• Used Business Objects for reporting.

Environment: Informatica PowerCenter 5.1, Oracle 8.0, MS SQL server 7.0, Business Objects.

Education:

Bachelors in Computer Science

Contact this candidate