SUMMARY:

• Nearly 12 years of experience in Data Warehousing and Business Intelligence.
• Ability to work with business in a fast - paced environment to lead the requirements analysis sessions, partner to translate them into clear technical requirements and recommend optimal solutions for business intelligence and analytics implementation.
• Involved in complete software development lifecycle of various client/server applications and DW&BI Architecture - analysis, design, development, testing, maintenance, support and implement end to end solutions.
• Translator between business and solution delivery, detail specifications for the development team.
• Deep expertise in Design, development, document, test, maintain, support, performance improvement and troubleshoot Analytics solutions (interactive reports and dashboards in Tableau 9/10, OBIEE10g/11g/12c, Business Objects as well as customized reports and ETLs in Informatica).
• Implemented many end to end solutions in reporting and visualizations for clients with various business sectors using Tableau and Oracle BI technology on Oracle and Teradata.
• Define technical architecture to meet business requirements in infrastructure and setting up Tableau and OBIEE platforms.
• Provide infrastructure sizing, including hardware and software requirements in Tableau and OBIEE.
• Ability to work effectively with both technical and non-technical stakeholders, balance independent and highly collaborative aspects of the job function.
• Understand and lead in the development of reporting, analysis and visualization of business data, metrics and measures in order to allow consumers to align and track against overall business strategies, goals and objectives, drive innovation, insight and decision making.
• Roles and responsibilities include requirement gathering and analysis, data analysis, functional analysis, translate business requirements into technical specs, end to end solution and implementation of BI applications, reports, dashboard and data visualization, Upgrades, System testing, bug fixing and performance improvement, assessing the optimum BI tool for the clients.
• In-depth understanding of Excel; ability to solve problems with least amount of training/experience.
• Perform extensive market research, analyze and understand the trend, competition, and customers, and identify new market functionalities and capabilities in the BI world.
• Present findings internally to assist decision making process. Interpret and communicate information in a manner that can be comprehended by non-analytical audience.
• Take aspects of multiple dimensions and perspectives reflected in the business and bring them together with a quantitative approach.
• Have good understanding on components of the financial statements, Journal entries and reconciliations. Evaluate and communicate the impact of Sales and Profit Margin for the company.
• Assist with logical and physical data modeling to support business intelligence initiatives.
• Demonstrated attention to detail, execution and follow up on multiple initiatives.
• One of the prime members and contributors of Oracle BI Centre of Excellence in the organization.
• Influence data visualization best practices and user experience elements in designing Tableau and OBIEE.
• Motivate in promoting the latest in technologies and bringing new opportunities.
• Provide training support, both from a training development and delivery perspective.
• Certified Trainer for Oracle BI application development & maintenance in the Organization.

TECHNICAL SKILLS:

Database and BI Technologies: Oracle 9i/11G, DB2 9.1, MS-SQL Server 2000, MySQL, Teradata, Tableau 8, 9, 10, OBIEE 10g, 11g, 12c, BICS, SAP Business Objects XI R2, Informatica 9.1

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Gather requirements from Sales and Operations business users on the existing Discoverer transactional reports.
• Design the business model based on requirement analysis and develop the metadata in RPD.
• Design and develop reports, dashboards and visual analytics projects on BI Cloud Service (12c).
• Innovation in handling frequent failures resulting in 80% reduction in monitoring and bug fixing efforts.
• Review the project instance at multiple stages to accommodate further enhancements into the model.
• Conversion of Oracle Discoverer and Oracle BI Apps reports into Oracle Business Intelligence Cloud Service.
• Provide user support and training in using Report Designer for creating Ad-Hoc reports.

Confidential

BI Technical Analyst

Responsibilities:

• Worked persistently with many teams on Confidential ’s pick rate issue, proposed optimum solution to the product team for 20% more accurate pick rate saving ~$300k, which directly impacts the store associates’ performance evaluations.
• Worked with various third party systems and product teams for improved, accurate and reliable month end closures and Sales Reconciliation worth $200k.
• Personal appreciation from Client stake holders and Product Managers scoring a 4.8 on 5 satisfaction.
• Manage and Support US, UK & Canada markets in Walmart’s e-Commerce space.
• Provide business solutions to financial analysts, Store Managers & executive leadership team.
• Mitigate, manage & resolve incidents, system stabilization and inflow reduction in Tableau and OBIEE.
• Bug/Defect creation on system failures, prioritization, performance tuning and automations.
• Pro-active anticipation and implementing precautions on any business impacting disturbances, resulting a 50% reduction in high priority business critical issues.
• Gather new requirements, create and automate Informatica workflows for various ad-hoc purposes to improve Trend visibility to Business and generate OBIEE Dashboards to handle views more efficiently.
• Work extensively with OBIEE and Tableau Admin on managing usage, sizing, load balancing, etc.
• Train end users in understanding reports functionalities and multidimensional Formatting.
• Analyze, troubleshoot, performance issues in OBIEE and Tableau during implementations and go-live.

Confidential

Responsibilities:

• Functional analysis and business requirements gathering and transform to tech specs.
• Effort estimation, recommend and drive towards implementation in OBIEE and Tableau.
• Provide solutions to the Hispanic Marketing VP to handle Hispanic and Global stores hierarchy in improving the business of the VP’s division compared to NA.
• Design and develop ETLs in Informatica, metadata, front end OBIEE reports and submit recommendations.
• Implement Security and performance improvement by aggregations, MV’s and Stored Procedures.

Confidential

Responsibilities:

• Made a big difference in Agilent Product Lines’ business innovations especially in bookings, backlogs, travel expenses and HR with ~ $300k soft dollar savings.
• Provide business solutions to Directors & above on one point access to their daily, weekly, monthly and yearly business behavior with latest In-Memory BI technology and data visualization with Tableau.
• Handle highly sensitive data, maintain integrity and implement security.
• Identify and road map the Business Requirements (functional & technical) on a bi-weekly basis following a prototype model post analyzing the requirements.
• Gather Customer, User and Owner requirements; analysis and documentation.
• Functional analysis for Headcount, Ranking, Compensation, Attrition, New Hires, Job Requisitions and Travel Expenses for the respective Directors Organization using Trend analysis in OBIEE.
• Design, develop metadata and security domains for individuals and user groups. Set up multilevel hierarchies, enable drill down functionality.
• Provide user support and training in using Report Designer for creating Ad-Hoc reports
• Currency impact on Average Selling Price for top Products, Product Categories and Product Lines with the help of Actual and Constant Currency rates.

Confidential

Responsibilities:

• Integrate various Business Models & Subject matters into one single Master Subject Area.
• Design and build one master business model in OBIEE combining various business models.
• Considering all the pros and cons of including and eliminating various objects and making the business and end users understand and aware about all the pros and cons of designing a master business model.
• Provide Project Effort estimates and recommend best approach in project execution.
• Identify and create classes with Dimension, Detail & Measure Objects and specify the hierarchies and use Aggregate awareness Functions to improve the Performance.
• Understand biz requirements, design and build OBIEE reports using universe queries and other data providers freehand SQL.
• Schedule and publish reports on OBIEE to different destinations, bug fixes and train end users.
• Integrate Hyperion with OBI, configure Essbase cubes, import multi-dimension to relational views.
• Integration and data validation from Oracle BI with Essbase Finance application.

Confidential

Responsibilities:

• Provide solutions with OBIEE and BI Publisher to assist management of loss in stores and Dynamic Waste Management Application at Confidential .
• Lead in requirements gathering on a daily basis and design the Data model.
• Technical Design Doc and Functional Spec, Effort estimation and recommend best approach.
• Design and build Metadata and OBIEE reports & Interactive dashboards.
• Design and build complex layout BI Publisher reports and burst to desired locations.
• Test case preparation, execution, debugging and performance tuning. Integrate Mobile with OBIEE 11g, configure interactivity and formulate layouts for best fit.

Confidential

Responsibilities:

• Performance improvement of existing Confidential BI in Enterprise environment of Confidential BI.
• Lead in requirement gathering, design and development phases and effort estimation.
• Integrate OBIEE with Oracle SOA using BPEL manager, Oracle Biz Rules Engine and SOA Suite.
• Build new competencies, create enablers for established competencies and train business with in-depth technical know-how in the Oracle BI technologies and process areas.
• Technical Design Document, Test case execution, debugging and performance tuning.

Confidential

Responsibilities:

• Monitor CPU, Memory Utilization and concurrent usage of OBIEE Production environments.
• Assist in Capacity planning & Configuration changes during project initiation, periodic review of environment capacity and Configuration for OBIEE environments depending on capacity/usage.
• Perform metadata and web catalog merge, test, debug and migrate to all the environments.
• Create security blocks in web catalog, maintain user group and dynamic user id creation.
• Requirement analysis of Warranty reports, prepare Detail Design Document.
• Train teams on OBIEE best practices. Stabilize OBIEE Production and manage compliance of GBI team.

Confidential

Responsibilities:

• Manage, mitigate BI application issues (AIMS) and provide solutions to business reporting.
• Estimation and project planning. Prepare Functional Specs & Detail Design Documents.
• Design and build new metadata, various dashboards layouts, implement Caching, redefine logical model, implement Object and Data Level Security, performance tuning.
• Create biz process using BPEL that uses the Oracle BI web services to invoke an OBIEE request.

Confidential

Responsibilities:

• Enable Ad-hoc reporting - design, develop and test metadata for subject areas per requirement.
• Design, build, test reports from OBIEE for Confidential Stores, verify source and target data.
• Detailed metadata, reports, dashboards and data validation by dimensional drills,
• Write and execute unit test cases in Quality Centre, provide testing estimates.
• Migrate existing tactical reports in Brio SQR to OBIEE using ABG’s independent data warehouses.
• Requirement gathering from existing system and feasibility check on migrating components.
• Design and develop the metadata for Wunderman Module. Validate OBIEE reports match PL/SQL.
• Impact analysis to find cons in proposed changes, coding, testing and implementation.
• Develop ETLs, fix bugs and perform CRs, code review, unit & system testing.
• Warranty Support to BI with Business Objects XI R2 and integrate with SAP.
• Design, develop and test reports using BO XI R2 and Oracle PL/SQL for the B2B application.
• Co-ordinate with onsite for Warranty Support, solve UAT Defects, perform Confidential
• Detailed data analysis and impact analysis for various enhancements.