UDAY SINGH KANWAR
Over 8 years of exposure to IT Industry, focusing on Business Analysis, Requirements, Development, Testing, Administration and Implementation of BI solutions in various verticals such as Retail, Telecom, Sales, Hospitality and Health Care. Currently doing my Masters in Computer Science from University of Texas at Dallas, CGPA 3.95/4
Oracle Business Intelligence Foundation Suite 11gCertified Implementation Specialist
Oracle Business Intelligence Applications 7 for ERP Certified Implementation Specialist
Business Intelligence Applications 7.9.6 Sales Specialist
Business Intelligence Applications 7.9.6 PreSales Specialist
Extensive experience in using BI tools like OBIEE 188.8.131.52, OBIEE 10.1.3.3/4. Implementation of Web based Reporting, Business Intelligence reporting using OBIEE.
Experience in installation and configuration of OBIEE, administering permissions, privileges to users based on their groups and responsibilities.
Experience in creating Dashboards, Answers, IBots, Administering presentation access, configuring Aggregates, fragmentation and cache management using OBIEE.
Experience in Data Modeling and working with Data Warehousing tools like Informatica Power Center 9.1 and 8.6.
Configured and installed BI Publisher and integrated with OBIEE server.
Experience in ETL scheduling using Data warehouse Administration console (DAC).
Strong experience on working hierarchies, complex and foreign key joins initialization block, presentation/repository/session variables, aggregate tables, partitions and fragmentations.
Implemented different Caching techniques to improve the performance of BI server.
Very good in Debugging, Optimizing the Analytics Dashboards/ Reports and Performance Tuning of Oracle BI / Siebel Analytical Dashboards / Reports.
Extensive experience in building Interactive Dashboards with drill-down & drill-across capabilities using global & local Filters, Guided Navigation, Business rules with User Identity & Roles, Profiles & Personalization.
Developed and scheduled IBots using BI delivers to deliver Analytics content based on schedule, automated delivers to obtain daily and weekly reports.
Experienced in Installation, Configuration, and Administration of Informatica Power Center. Thoroughly worked on ETL process to loading into OLAP systems.
Strong understanding of data warehousing concepts, dimensional modeling, designing Star and Snowflake schemas.
Years of strong experience in Retail, Telecom, Sales, Hospitality and Health Care.
Strong Project management knowledge, Knowledge in areas of project integration management, Project scope, Time, Cost, Quality, Human resource, Communications, Risk Management, Procurement Management etc.,
Operating System : WinNT 4.0/Win98/2000/XP /Wintel/Linux/Unix
Database : Oracle 10g/9i/8i, DB2, MS SQL Server, MS Access
Domain : E-Commerce, Telecom, Materials Management, Financial Management, Supply Chain Management,Health Care
Reporting Tools : OBIEE184.108.40.206/OBIEE10.1.3.3/4,BI Apps 7.9.3
ETL : Informatica Power Center 9.3/8.6, DAC
Frontend Tools : MSOffice
Database Tools : SQL Developer
University Of Texas at Dallas, Teaching Assistant (August, 2016- Present)
•Take classes for C++/JAVA, help the Professor in grading and scoring exams and assignments, and hold regular doubt clearing sessions.
Steria India Ltd., Consultant Analyst (July, 2014- Mar-2016)
Project Title- NHS-SBS(National Health Services-Shared Business Services)
•Worked with the business analysts and enterprise architects to understand the complex technical requirements and analyze new opportunities and proposed the technical solution to business problems.
•Prepared system and technical high level design documents, reviewed low level design documents
•Supported and mentored analyst programmers in all technical deliveries, review their codes and provided technical guidance
•Built trusted relationships with business partners and proactively seek feedback on systems processes and personal performance
•Analyzed technical issues, flag risks and provide solution approach to such issues.
•Designed highly formatted reports using BI Publisher
Environment: OBIEE 11g/10g, Oracle11g/10g, Informatica 9.1/8.1, SQL Developer, SQL Server 2008,
Linux, WINDOWS XP/Server 2003, DAC.
Cognizant Tech. Solutions- Associate (Jan 2014- July 2014)
Project Title- Baskin Robins and Dunkin Donuts
•Helped in defining the architecture and the configuration of Oracle HTTP server and Oracle Identity Manager 11g with the existing Dunkin software base
•Provided POC’s and helped to overcome bottlenecks by suggesting a plan B, also suggested the changes that can make the existing plan work
•Lead the project from the front by providing vital technical expertise which saw the project through
•Contributed heavily to the innovation stack of Cognizant technologies and Dunkin Donuts
•Gave expertise in the integration and implementation of enterprise security. Technology stack under the same comprised of OID 11g(Oracle Internet Directory),Weblogic Server 10.3.5, OIM 11g(oracle identity manger), IDM 11g (oracle identity management) and OAM 11g(Oracle access manger)
•Redefined the BI layer and cleaned the data model and BI layer to let the data flow be more accurate and to the point
•Collaborated with Technical and Business SMEs to design and extend the physical data model and security model
•Provided leadership and project management skills to make the process clearer and more transparent
Environment: OBIEE, Oracle 9i, Informatica 8.6, Oracle HTTP server, Oracle Identity Manager 11g, OID 11g(Oracle Internet Directory),Weblogic Server 10.3.5, IDM 11g (oracle identity management) and OAM 11g(Oracle access manger)
IBM India Pvt. Ltd. -Business Analyst (April 2013- Jan 2014) Bangalore, India
Project Title- Hertz Global Holdings Inc
•Served as a subject matter expert (SME) for OBIEE and one or more of the pre-packaged BI Analytic Applications with hands on expertise in RPD Development, Oracle Answers, Oracle Delivers, DAC Configuration, ETL Configuration, and BI Publisher
•Experience with Siebel Analytics/Oracle Business Intelligence Analytics. Design and build BI Data Integration Architecture
•Worked to assist in the implementation of Oracle Business Intelligence (BI) technologies at business units
•Play a key role in the IBM’s OBIEE roadmap and provided guidance on the use of OBIEE version 11g and future releases
•Created technical designs from requirements/fit gap
•Ensure standards compliance and provide leadership for standards development and change
•Collaborate with Technical and Business SMEs to design and extend the physical data model and security model
•Provide leadership and project management skills for strategic projects and Develop Product Lifecycle Roadmap
•Worked closely with BI development/QA teams to ensure consistency, standardization, and collaboration across teams
Project Title- Vodafone Greece
•Provide technical guidance to the Industry Leadership team on the scope and technical challenges involved in implementing a BI system from Telecom Point of view.
•Responsible for Oracle BI and Informatica 8.6 Code merge and deployment activities
•Provide expert knowledge of OBIEE best practices enabling the team to leverage the platform as effectively as possible
Environment: OBIEE 11g, Informatica PowerCenter 8.6, Oracle 11g
Wipro Technologies India Pvt. Ltd. - Business System Analyst (April, 2010 to April, 2013)
Projects Handled for Client – Wal-Mart
•Created various reports in OBIEE 10g/11g using prompts and filters
•Developed and managed Web Groups and Reports Security
•Responsible for Building Repository at all three layers, namely physical, business model & presentation layer level
•Accountable for creating session variable, repository variable in RPD and use the same for role based security and dynamic calculation in OBIEE answers
•Effective defect tracking and reporting to improve communications and reduce delay and write detailed Test Summary Report
Project Title: Titan-US Groceries
Project was undertaken by Wal-Mart stores to set up new home delivery system for home shopping users in California
Worked on Oracle BI and provided security in OBIEE
Handled aggregations and fragmentations
Accountable for developing, modifying and maintaining analytics reports and dashboards
Environment: OBIEE 10g, Informatica Power Center 8.6, Oracle 10g, PL/SQL, Windows