| CAREER SUMMARY | - 5 years of experience in technical lead activities evaluation and analysis of requirements, high and low level database designing, code review, standardization, interacting with various user group such as Directors, Functional analysts, Solution Architects etc.
- My responsibility also involves Project Plan creation, potential risk identification, plan for risk mitigation, tracking BI related status and reporting to management. As a SME, my responsibility includes understanding the reporting requirements of various user groups and documenting the Business Requirement Document, justifying the requirement, getting it approved by the Sponsors steering committee .
- Thorough understanding of Software Development Life Cycle SDLC , involved in various phases - Requirements, Analysis/Design, Development and implementation.
- Implemented Agile Methodology for BI Publisher report creation and implementation.
- Strong knowledge of data warehouse concepts, design techniques such as Star, Snow Flake schemas, multi-dimensional data model analysis using OLAP, Physical and Logical data modeling using OBIEE 11.1.1.7, OBIEE 10.3.4, Siebel Analytics 7.8.4.
- Used Oracle BI Publisher to create Interactive reports, Template Reports using MS word Plugin, delivered the reports through email using Bursting Technique.
- Gathered Functional Knowledge in Financial Anlaytics, HR Analytics, Real Estate Analytics, Sales and Activity Analytics for Pharma.
- Worked extensively in OBIEE 11g and OBIA 7.9.6.3. It includes
- Multilingual and Multicurrency Applications Implemented multicurrency application for Financial Analytics.
- Disconnected Analytics Implemented world's largest disconnected analytics implementation for Pharma client in Europe's 23 Markets.
- Marketing Analytics experience in Siebel Marketing. Experience of creating Lists, Target List, Segments using the same
- Siebel ePharma Sales and Activity Analytics Proficient in Siebel Data Model and Designed and Developed the Warehouse from Siebel.
- HR Analytics OOB implementation using Universal Adapters Flat File as Source
- Real Estate Analytics Created fully customized Real Estate Data Ware House using YARDI Voyager as Source.
- Financial Analytics Has implemented Financial Analytics using Peoplesoft as Source. Customized Reports and ETL Mappings to handle the specific requirements for a Real Estate Client.
- Experience in Data Warehouse process, Data Modelling concepts. Experienced in designing complex BI Reporting solutions for Large Data warehouses rolled out in multiple geographies i.e US and EMEA regions.
- Proficient in Design of Physical and Logical Model of Repositories, Development of Dashboard and Answer-live Reports, Testing and Deployment of BI Repositories and Reports.
- Hands on experience in integrating Map viewer with OBIEE reports. Create reports that are plotted on USA maps for real estate client. Created Master-Detail report where the master report is USA Maps, details report says about the details of the property.
- Worked in Migration and Up gradation project to OBIEE 10g and OBIEE 11.1.1.8 from lower version of OBIEE, and worked in Performance improvement techniques.
- Implemented MUD Env for OBIEE and used during development phase of the project.
- Extensively worked on design and development of fact and dimension tables, staging table loads from source, SCD2 close of business based loading, ETL load using Informatica and audit frameworks, lookups on dimension tables, data quality logging, partitioning and indexing of large tables, parallel jobs framework for large loads, rollback of batch loads, housekeeping custom stats gathering.
- Well versed in Informatica Power Center. In depth knowledge in basic data transformation stages. Hands on experience in Data Warehousing basics like SCD 1, 2 and 3.
- Exposure to ETL loads using Informatica and batch job scheduling, ordering monitoring using DAC.
- Hands on experience in creating execution plans in DAC.
- Hands on knowledge in Oracle Data Integrator 11g ODI . Experience in creating Interfaces, modifying KMs.
- Experienced in creating Test Strategy, Test Plan, Test Cases for BI Projects for Financial Analytics Implementation, HR Analytics Implementation. Executed Load Testing using Oracle Application Testing System OATS .
- Onshore Offshore model and AMS Transition Projects Delivery. Training Development and Competency Development.
- Excellent communication skills with well-developed business acumen. I am excellent stakeholder relationship management skills which enables him to successfully lead and manage the project team and project stakeholders.
- Adept at working with diverse technical groups and global customers to develop technology solutions that meet or exceed expectations
- Exposure in varied business processes of many fortune companies. Outstanding organizational skills, work ethic and drive to succeed. Strong analytic, diagnostic and problem solving abilities
- Always updated with latest Oracle Technologies. Done POCs in BIG Data technologies.
| |
| TECHNICAL SKILLS | | Proficient or familiar with a vast array of programming languages, concepts and technologies, including: | O.S RDBMS LINUX, HP UNIX, Oracle 9i,10g 11g, | LANGUAGES SQL, PL/SQL | TOOLS UTILITIES OBIEE 11.1.1.8, OBIEE 10.1.3.4, Siebel Analytics 7.8.4, Informatica 9.0, DAC 10.3.4, Oracle Data Integrator 11g, Sql Developer, SQL Plus, Toad 9, PLSQL developer, ERWIN 4.0 | | |
| PROFESSIONAL EXPERIENCE | | Confidential Sr. Consultant BI | | RESPONSIBILITIES: - Reporting to the Director, Solution Innovation group, my responsibility is to provide technical architecture of BI products that are dedicated for Business Platform application. Responsible for design, development of new solutions in BI and Data Ware housing. Developed a Proof of Concept on OBIEE in Exalytics, Oracle Data Integrator, Open surce BI tool like TABLUE.
- My responsibility also involves Project Plan creation, potential risk identification, plan for risk mitigation, tracking BI related status and reporting to management
- As a SME, my responsibility includes understanding the reporting requirements of various user groups and documenting the Business Requirement Document, justifying the requirement, getting it approved by the Sponsors steering committee .
- As a Data Modeler, designed the data model, translated the business requirements to physical data models holding the principles of de-normalization. Used ERWIN Data Modeling tool to create the data models.
- Designed, developed reports, Dashboards in BI Publisher.
- Used Word and excel based templates to create static reports which are disbursed through emails to various users.
- Integrated Oracle Identity Management OIM with BI Publisher for Application Security.
- Created POC
- Created UAT test scripts using Oracle Application Test Suites OATS and guided UAT participants remotely for successful test case execution.
ENVIRONMENT TOOLS: Oracle 11g, OBIEE 11.1.1.7, ODI 11g, TOAD, PLSQL developer, BI Publisher 11.1.1.7, Oracle APEX,TABLUE | | Confidential Consultant/BI Tech Lead/Informatica | | RESPONSIBILITIES: - Reporting to the Practice Director, Information Management, my responsibility is to engage with Prologis Inc. largest corporate lender of real estate in US. This project was implemented in a phased manner. I have played various roles during this 2 Years stint such as Lead for HR Analytics Implementation, BI Lead for Financial Analytics, Informatica and DAC configurater for Real Estate Analytics. Lead for QA during retrofit. This is implemented using OBIA, OBIEE, Informatica.
- As Lead for HR Analytics with Universal Adapters, I designed the Project Plan, created the work distribution Plan, designed the Resource Loading Plan. Guided the resources to deliver the project, created the testing strategy, designed the test plan, helped UAT users remotely to execute the Test Cases and finally got the sign off for the project. After sign off planned the smooth deployment of HR analytics into Production. Planned the knowledge transition to the Application maintenance Team.
- I was also involved in review of Informatica Mapping, DAC workflows and RPD modeling.
- Hands on experience in integrating Map viewer with OBIEE reports. Integrated Google Maps with OBIEE. Created Master-Detail report where the master report is USA Map Viewer reports, details report says about the details of the property. This shows the occupancy rate of client held properties across USA. This helps the client to plan for the future seeing the report.
- This has given a very good ROI as the client's sales manager knows exactly which property, in which locality is going to vacant in coming 30 days, 15 days etc.
- Review and provide recommendations for solution design ensuring that all aspects of a solution including technical, Functional designs fit together in a consistent manner and satisfy the business requirements and other objectives of the client.
- As a BI Lead for Financial Analytics I was responsible for the delivery of all the reports from offshore. I have designed and developed the reports and guided my colleagues during development and system testing phases. I have implemented SCRUM methodology.
- In this project OBIA 7.9.6.2 is implemented. The source system is Peoplesoft 9.0. Customized RPD to incorporate some of the specific requirement, created Physical Model, Logical Model, implemented security through LDAP, implemented usage tracking.
- In Prologis Wave 2 release custom reports are built to for Real Estate analytics. The OLTP system is YARDI VOYAGER. As an ETL Configurater in Prologis Wave 2 release, I was responsible for the Physical Table creation through TOAD Data Modeler Tool. Created Custom Mappings for custom Dim and Fact Tables. Created custom Subject Areas, Tasks in DAC. Supported the System Test Cases, UATs and rolled out the application successfully.
ENVIRONMENT TOOLS: Oracle 11g, TOAD, OBIEE 11.1.1.7, Informatica Power Center, DAC 10.1.3.4,TOAD Data Modeler | | Confidential Consultant/Onsite Co-Ordinater/Offshore Lead | - Major accomplishment for this Project is Siebel 7.8.4 to OBIEE 10.1.3.2 Upgrade. I was playing the role of Lead in this project. Have identified all the tasks for this upgrade and created the project plan.
- Handled all the upgrade related issues, improved the performance of reports by 40-50 . Performance tuning of the database was performed done. Modification of Physical Model, Logical Model to support the physical level design.
- Developed and supported Marketing Analytics for Pfizer Animal Health. This is implemented for Siebel ePharma Application.
- Developed and rolled out OBIEE Answers. Trained users of 5 biggest markets of Europe onsite.
- Integrated Microsoft Word with OBIEE reports.
Confidential - Worked in the UK for Pfizer Global Pharmaceuticals, as a RPD Developer, participated in Customer Room Pilot CRP understood business requirements analyzes them passed it to offshore for development. As a onsite co-ordinator acted a s a liaison between the client, offshore and the application maintenance team. Planned the deployment for both point and major releases.
- Trained users for the usage of the application, handled support queries. Designed the support mechanism, planned the retrofitting of the application.
- It was the Largest ePharma implementation for Siebel, in world's most advanced 23 Markets. This involves 10,000 disconnected users. This was one of the most complicated multi lingual applications with 20 languages.
- As a RPD and Webcat Developer, I was responsible for creating the RPD, Reports, Dashboards, iBots etc.
- Responsible for development of multilingual application.
- Investment Banker portal is a transaction processing system for the bankers for the deal life cycle management from idea to mandated for the products offered by the bank in investment banking. The system interfaces with various other systems inside the bank.
| | |
Privacy Policy
