Simran Walia Email & Phone Number

Vancouver, BC, CA

Vancouver, BC, CA

My role at Lululemon in Guest/Customer Support org focused on building Data and Analytics as a Product. My role is a hybrid of Technical Product Manager and Product Owner -* Building data and analytics platform strategy to create a self-serve, single source of truth, consolidated and connected data warehouse to support all data and analytics needs of the.

Richmond, BC, CA

My Role at Wenco is managing a couple of products. One of them is Cloud implementation of Fleet Management System and second is Wenco's Analytics and business Intelligence product named Avoca. My Roles and responsibilities include and are not limited to-* Create business plans highlighting the strategic goals and objectives aligning with the company's.

• Leading a team of 6-8 developers in streamlining the BI deployment, managing dashboards, develop new dashboards and reports
• Customize the RPD according to best practices and mentor the team with the new features and functionalities introduced in current version of OBIEE
• Modify and customize the Finance BI Apps to fit the university’s financial requirements.
• Model a brand new Custom Student Information system and Tuition Allocation Model in RPD and develop Dashboards using the Customized Subject Areas.
• Review the Architecture and play a key role in mentoring the Architecture team on the best possible solution. Setup Clustered environments for DEV, UAT and Production environments.
• Responsible for setting up MUDE ( Multi User Development Environment) for efficient development cycle.

San Jose, CA, US

• Gather and document Business Requirement documents from End users.
• Perform Gap Analysis on what is available in Source System and what is required by the business. This gave the visibility of the existing system and fins ways to suffice business needs.
• Created detailed design documentation (mockup of reports in excel and presented to user to get approval), create mock up reports and present it to the business to lock the requirements.
• Monitor the enhancements against performance thresholds and Data model standards.
• Work closely with the Teradata Backend team to clear the performance roadblocks and streamline theRepository to accommodate the change which routes the queries to the database in the most efficient way.
• Analyze and recommend enhancements to Metadata Reporting in Physical, Business and Presentation layer.

San Jose, California, US

• Worked closely with the ETL design team to come up with a scalable dimensional model that addresses the current and future requirement.
• Developed OBIEE Repository (RPD), Physical, Business Model / data mapping (create Logical tables & data source mapping) and Presentation Layer.
• Designed various hierarchies for natural drill down option.
• Developed various Reports using different Analytics Views (Pivot Table, Chart, and Column Selector, View Selector).
• Interactive Dashboards with drill-through capabilities for in-sight on various measures.
• Trained users on the usage of the dashboard and reports.

Austin, Texas, US

• Contracting with Oracle Corp. representing Oracle at Agilent Technologies, Santa Clara, California.
• Gathered requirements for various work streams through constant business meetings, demonstrations & presentations with the Marketing and Sales users.
• Analyzed requirements, designed and implemented customization to OOTB (Out of the box) business intelligence solutions using the Siebel / Oracle Business Intelligence (OBI) Analytics platform and custom data modeling.
• Customized OOTB Subject Areas for Sales (Quotes, Forecasting, Pipeline, Activities, and Opportunities) and Marketing (Planning, Campaigns and Events) and Marketing/Sales Segmentation.
• Developed new models as well as enhanced OOTB models at logical modeling level and presentation layer related to campaigns and MRM (Marketing Resource Planning), Sales Activities and Sales – CRM Forecasting.
• Analyzed & implemented OOTB reporting requirements for (Competitors, Customers, Pipeline and Sales Effectiveness) sales dashboard reports and Marketing dashboards (Customer Insight, Marketing Planning and Performance.

• Gathered requirements for various work streams through constant business meetings, demonstrations & presentations with the users and base lining the details.
• Analyzed requirements designed and implemented customization to OOTB (Out of the box) business intelligence solutions using the Siebel / Oracle Business Intelligence (OBI) Analytics platform and custom data modeling.
• Performed the detailed design of Reports / Dashboards and Analytical Data Model (Metadata).
• Developed new models as well as enhanced OOTB models at logical modeling level and presentation layer.
• Analyzed & implemented reporting requirements for (Competitors, Customers, Pipeline and Sales Effectiveness) dashboard reports.
• Created different mockup reports during requirements gathering sessions with business.

• Created/Modified Metadata repository suiting to data requirements using Siebel Analytics Server Admin tool.
• Created the Physical Layer, Business Model and Mapping Layer and presentation Layer using Siebel Analytics Administration Tool.
• Developed Answers, Filters, Customized Reports and Dashboards using Siebel Analytics Web.
• Responsibilities include business requirement analysis, and functional requirement.
• Using the Siebel Analytics Administration tool to develop and enhance meta-data to Build Business model and establish relationships.
• Simplifies and reorganizes the Meta data into a single business model.

• Communicated with clients regarding system requirements, ensuring the development and implementation of customized products to customer satisfaction.
• Prepared functional specifications for user requirements.
• Developed and modified applications, authored database procedures and triggers for data processing. Developed PL/SQL Packages, Procedures, Database Triggers and Functions to implement business logic.
• Created entry forms/reports for various modules. Created databases, loaded initialization data, generated users, and assigned roles and access.
• Created Tables, Indexes, Table Spaces, Views synonyms, and integrity constraints.
• Involved in creation of schema objects, roles and privileges, users.

Diploma In Computer Sciences

Bachelor Of Arts - Ba, English Literature

Summer Institute Of Future Legislators, Political Science And Government

Bachelor'S Of Technology, Computer Sciences

Bachelor Of Technology - Btech, Computer Science