Sales Developer

SUMMARY

• Over Seven years of extensive experience in IT with Five years in OBIEE 11.1.1.5/10.1.3.4 which include Design and Development of OBIEE repositories, and building OBIEE Dashboards/Reports, iBots, Oracle BI Publisher and Delivers.

• Good understanding of tracks like Financials, Supply Chain & Order Management, Procurement and Spend Analytics.

• Experience in implementing Security using roles in OBIEE 11g.

• Experience in administering Weblogic 10.3.5 for OBIEE 11g.

• Experience in administering DAC 10.1.3.4 and Informatica 9.0.1.

• Extensive experience in working with OBIEE Answers, Delivers, iBots and Intelligent Dashboards.

• Experience in developing OBIEE Repository at three layers (Physical Layer, Business Model & Mapping Layer and Presentation layer).

• Expertise in creating Logical tables and columns, Dimensional Hierarchies, Level Based Measures, Time series data, and Repository Variables.

• Extensive experience in using OBI Answers for creating different Requests, Filters, Views, Charts, Interactive Dashboards with page and dashboard Prompts.

• Experience in security tasks like creating user groups, users and managing users by setting up their privileges and profiles.

• Experience in configuring interactive Dashboards with drill-down, drill across capabilities using Filters and Dashboard Prompts, Siebel Security Setup (groups, access privileges), Metadata Objects and Web Catalog Objects (Dashboard, Pages, Folders, Reports) and guided navigation links.

• Expertise in accomplishing the performance using materialized views, aggregate navigation, and partitioning and cache management techniques.

• Expertise in fine tuning reports by using view selector, column selector, is prompted, drill down- drill through analysis, creating master/detail reports, using database, numeric, date and time functions, etc., where ever necessary to increase performance.

• Experience in managing users and groups, setting up their privileges and administering the Object Level Security and Data Level Security using different authentication methods.

• Performed Cache Management at repository level.

• Developed Delivers iBots/Scheduler to automate report delivery and provide alerts on Interactive Dashboards.

• Experience in working with Informatica Power Center in applying transformations, creating mappings & loading data into the data warehouse.

• Excellent interpersonal and communication skills for efficient client interaction.

EDUCATION

• Bachelor of Technology in Computer Science – Jawaharlal Nehru Technological University, India

TECHNICAL SKILLS

OLAP Tools: Siebel Analytics 7.8.3, OBIEE 11.1.1.5, 10.1.3.3/10.1.3.4, Oracle BI Apps, BI Publisher

Databases: Oracle 10g/9i

DB Analysis Tools: SQL* Plus, ODBC, SQL Developer, TOAD.

ETL Tools: Informatica Power Center 8.6/8.1/7.x

Languages: PL/SQL, C, UNIX Shell Scripting, .NET

Web Technologies: HTML, JavaScript, XML, MS FrontPage

Operating Systems: Windows-All versions, Linux-Red Hat, Fedora and Ubuntu

Networking: Routers-LAN/WAN configuration, Firewall configuration, VPN configuration, Wireless configuration, services like FTP, TELNET, SSH.

PROFESSIONAL EXPERIENCE

HELEN OF TROY, TX April 2011 – Till Date

[OBIEE Developer]

Helen of Troy Limited is a manufacturer of personal care electrical products under brands licensed from Vidal Sassoon, Revlon, Dr. Scholl's, Sunbeam, Health o meter, Sea Breeze, and Vitapoint. It is also the parent corporation of OXO International. The company is headquartered in Hamilton, Bermuda, and its U.S. operations are headquartered in El Paso, Texas.

Roles & Responsibilities:

• Translated Business requirements into technical requirements.

• Customized Purchase Orders, GL, Account Receivables, Account Payables, Procurement and Spend Analytics, Order Management, Inventory reports using OBIEE 11g.

• Worked with OBIA rpd, making use of the existing physical/logical objects, creating reports based on pre-built rpd.

• Created Dashboard prompts and advanced filter criteria.

• Created new connection pools for different data sources and designed from the scratch (physical, business model and presentation).

• Customized reports from BI Apps (OOB-prebuilt) seeded reports.

• Used BI Apps prebuilt Informatica mappings for development.

• Fixed many OOB issues.

• Created major and important dashboards like Customer Profitability from the scratch including

• The top priority reports like Monthly Net Sales, Customer Profitability, Funds Details, Credit Summary.

• Utilized features like dashboard prompts, pivot tables, column selector, drill down, hierarchy.

• Configured Web Catalog Objects (Dashboards, Pages, Folders, and Reports).

• Implemented various Repository Variables and System Variables depending up on user

requirements.

• Effectively managed ODBC connections and imported the Physical tables, Views, keys and foreign keys as per the Business requirements for Sales, Operations, Secondary Marketing and Top of the House Subject Areas purpose.

• Extensively worked on Informatica PowerCenter 8.6 tools – Designer, Workflow Manager, Workflow monitor.

• Upgraded from OBIEE 10g to 11g.

• Designed and developed complicated/complex reports.

• Followed best practices to make sure there was good performance.

• Administered MUD rpd, reviewed developers’ rpd development before merging into MUD server.

Environment: OBIEE-11.1.1.5, Oracle BI Apps, Oracle DB 10g, SQL Plus, Oracle SQL Developer, Informatica Power Center 8.6, DAC.

EATON STEEL CORPORATION, MI July 2010 – April 2011

[Sr.OBIEE Consultant]

Eaton Steel Bar Company is a sales and support services company for hot rolled and cold finished steel bar products. Eaton Steel Corporation maintains the largest inventory of SBQ and carbon and alloy bar products for the forging and machining industries delivering more than 500 hot-rolled steel bar products that are machined into precision parts across a broad range of industrial and consumer categories.

Roles & Responsibilities:

• Interacting with management, business and users, gathering the business requirements, designed and developed complex dynamic business quality compliance group reports related to audit and early warning.

• Created transformations like Expression builder, joiner, and router.

• Implemented OBIEE solution for ‘Sales’ subject area using various components of OBIEE Suite like Administration Tool, BI Answers, Interactive Dashboards, iBots/Delivers.

• Tuned the performance of the reports by creating various types of indexes.

• Configured MUD for OBIEE Tool

• Used existing data from Hyperion Essbase for analysis.

• Utilized various building blocks like calculation measures, time series measures,

Initialization blocks, session and repository variables, fact tables, dimension tables, dimension

hierarchies.

• Created variety of interactive dashboards containing charts, graphs and pivot tables using BI

Answers.

• Utilized features like narrative views, dashboard prompts to create interactive dashboards.

• Configured BI Scheduler and created simple, conditional and chained iBots to create alerts and

Deliver them using Oracle Delivers.

Environment: OBIEE-10.1.3.4, OBIA 7.9.6.1, Oracle DB 10g, SQL* Plus, PL/SQL, Informatica Power Center 8.6.

WORLD FUEL SERVICES, FL August 2009 – July 2010

[Sr.OBIEE Consultant]

World Fuel Services is a Fortune 500 company that is based in Miami, Florida. It provides marketing and financing of aviation, marine and ground transportation fuel products and related services to commercial and corporate aircraft, petroleum distributors and ships at more than 2,500 locations around the world.

Roles & Responsibilities:

• Gathered User requirements, reporting requirements and the document for requirement specifications.

• Used Administration Tool for customizing and modifying the Physical, Business Model & Mapping and Presentation Layers.

• Created dimension hierarchies, aggregates and keys in BMM layer.

• Worked on session variables and dynamic variables along with initialization blocks.

• Created users and groups in the repository and granted privileges and group inheritance.

• Worked extensively on Oracle BI Answers, Delivers and Interactive Dashboards.

• Involved in troubleshooting of Informatica Mappings and Workflows

• Compared data from Hyperion Essbase with the OBI for data validation.

• Created source and target instances and various transformations (Joiner, Aggregator, Filters, and Router).

• Configured many dashboards with different views like Pivot table, Chart, Tabular and View Selector and guided navigation links.

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

• Created highly formatted reports using BI Publisher based on Oracle Database.

Environment: OBIEE 10.1.3.4, OBIA- 7.9.6.1, Oracle 10g, Oracle BI Publisher, Informatica Power Center 8.1.

THOMSON REUTERS, India July 2008 – August 2009

[OBIEE Developer]

Thomson Reuters Corporation is a business data provider and is headquartered at 3 Times Square, Manhattan, New York City, New York, United States which operates in 100 countries. Thomson Reuters operates in two divisions: Professional and Markets.

Roles & Responsibilities:

• Involved in translating high-level business requirements into logical business dimensional model.

• Development of RPD using Physical, BMM and Presentation layers of BI Administration Tool.

• Imported physical tables and defined relations between Physical tables at the Physical Layer.

• Created Drill down Hierarchies, Levels and implemented logic by creating Level Based Measures at BMM Layer.

• Utilized Aggregation to improve query performance

• Created Reports using different views

• Implemented BI Security using External Table for Authentication and Authorization

• Worked on iBots using BI Delivers for issuing Alerts and setup a Delivery Profile to email reports to various power users at scheduled intervals.

Environment: OBIEE 10.1.3.3, 10.1.3.4, Oracle 10g, MS Excel, Linux, Windows XP, SQL Plus

COMCAST, India August 2007 – May 2008

[Siebel Analytics Developer]

Comcast Corporation is the largest cable operator, home Internet service provider, and third largest home telephone service provider in the United States, providing cable television, broadband Internet, telephone service and home security to both residential and commercial customers over 40 states.

Roles & Responsibilities:

• Involved in gathering the reporting requirements from Operation and Marketing departments.

• Identified the GAPs by analyzing the Data mart instance and provided alternative solutions as well recommended changes to database.

• Analyze Design and Developed Metadata repository (.rpd) that consists of physical layer, multiple business models with dimensions & time series objects, presentation layers with catalogs, external table security using session variables, LDAP authentication, assigning catalog objects & Web modules to users & groups etc.

• Designed and developed the various Dashboards/Reports that are Dynamic & Interactive with drill-down capabilities and local & global filters and cache monitor using Siebel Analytical Web. Extensively used Siebel Delivers and iBots.

• Debugged reports and Dashboards visibility with respect to user’s responsibility and web groups in an integrated environment.

• Performed Unit testing and Integration testing to validate Dashboards/Reports.

• Developed/Updated Informatica Mappings and Workflows for ETL processes per reporting requirements.

Environment: Siebel Analytics 7.8.3, Informatica Power Center 7.1.2, Oracle10g,

HANDLEMAN COMPANY, India Jan 2006 – July 2007 [Informatica Developer]

Handleman Company is one of the largest U.S. distributors of prerecorded videotapes and music, as well as computer software and books. It stocks the shelves of large retail chains, a task called rack jobbing. Handleman also licenses the right to exclusive manufacture of some video and audio products.

Roles & Responsibilities:

• Created new ETL transformations, mappings, mapplets, workflows and loading data into DW transforms.

• Tracking long running Transformations and Loads and was involved in performance tuning the SQL queries.

• Executing Day to Day Operations which include rerunning the jobs on failure, fixing the transformation issues and verify data quality of the tables.

• Developed and tested stored procedures, functions in SQL for data ETL Process.

• Handled dynamic data load via staging tables in the ETL Layer.

Environment: Informatica Power Center 7.1.2, Oracle 10g, Windows, TOAD

TeamF1 Inc., India Jan 2005 – Jan 2006

[Software Engineer]

TeamF1, Inc., headquartered in Fremont, CA, is a privately-held preeminent supplier of OEM-ready software to the embedded systems market. TeamF1’s technology offerings build up on existing operating system tools and components and offer our customers embedded network security and performance-critical, hardware-assisted networking protocol implementations in the form of stand-alone modules or complete turnkey solutions.

Roles & Responsibilities:

• Developed core modules which are the major components of the product.

• Coordinated with other teams for quality performance and resolving at critical stages.

• Debugged issues reported by QA team and customer.

• Maintained projects after stable release.

• White box testing of the components.

Environment: gcc, Windows and Linux, shell scripting, C,

Contact this candidate