We provide IT Staff Augmentation Services!

Sr. Bi Consultant Resume

Sunnyvale, CA

SUMMARY:

  • 11 Years of IT experience in Business Intelligence technologies and data warehousing systems
  • 5 years of experience in Client facing roles - interacted, explained, influenced business managers, project sponsors and user groups. Worked in multiple industries like manufacturing, technology, product development and pharma.
  • Has implemented Financial Analytics, Fixed Assets and Procurement and Spend from Confidential EBS Source, Implemented customized reports and ETL mappings to handle the specific requirements. Implemented for a large multi-national hi-tech company.
  • Has implemented Sales Analytics with Salesforce.com (SFDC) as source. Implemented for a clinical research company.
  • Has implemented HR Analytics with HR workdays cloud based solution using universal adapters.
  • Experience in OBIEE Installation, Configuration, Administration Tool, Answers, Dashboards, Agents.
  • Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables. Expertise in Pareto charting, advanced calculations, work with demographic and geographic fields
  • Experience in repository catalog Administration tasks like user groups, users and managing users by setting up Data Security and Object level Security.
  • Upgraded application from OBIEE 11g to OBIEE 12C. Expert in Visual Analyzer report development.
  • Hands on experience in OBIEE Administration.
  • Worked on the ESSBASE integration with OBIEE 11g, generated reports in OBIEE 11g using Selection Steps, Groups and Calculated Items.
  • Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameterized using Tableau.
  • Experienced in creating Reports, Dashboards, Stories in Tableau Desktop.
  • Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, Calculated fields, Sets, Groups, Parameters etc., in Tableau. Employed various Tableau functionalities like Tableau Extracts, Parameters, Filters, Contexts, Data Source, Filters, Actions, Functions, Trends, Hierarchies, Sets, Groups, Calculations, Data Blending and Maps etc.
  • Completed a Proof of Concepts to setup OBIEE in Confidential Cloud Platform.
  • Extensively worked on design and development of fact and dimension tables, staging table loads from source, ETL load using Confidential data Integrator ODI 11g.
  • Configured Confidential BI Apps 11.1.1.8.1 using BI Apps Configuration Manager, (BIACM). Customized ODI Interface to accommodate customized requirement
  • 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. Exposure to ETL loads using Informatica
  • Batch job scheduling, ordering & monitoring using DAC. Hands on experience in creating execution plans in DAC.
  • Proficient in production data load monitering, issue reporting and resolution.
  • In-depth 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 Erwin, Toad Data Modeler.
  • Experience identifying granularity level of the data required to be available for analysis. This was achieved by studying the ER Diagrams of the underlying Transactional System.
  • Proficient in identifying the Fact, Dimension, Hierarchy, creating logical model, physical model, defining primary key - foreign key relationship,
  • Identified SCD (slowly changing dimension) since end users were interested in maintaining historic information.
  • Proficient in Design of Physical and Logical Model of RPD, Development of Dashboard, Canned Reports, Ad-hoc Reporting Solution (Answers) Reporting, Testing and Deployment of BI Repositories and Reports.
  • Evaluation and analysis of requirements, high and low level database designing, code review, standardization, performance tuning, 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 Report creation and implementation.
  • Experienced in creating Test Strategy, Test Plan, Test Cases for BI Projects for Financial Analytics Implementation, HR Analytics Implementation. Executed Load Testing using Confidential Application Testing System(OATS).
  • Onshore - Offshore model and AMS Transition & Projects Delivery. Training & Development and Competency Development.

TECHNICAL S KILLS:

Business Intelligence: OBIEE 11.1.1.7.1 , DAC 11.1.6.4, OBIA 11.1.1.8.1 , BOXI 3.1, Tableau, QlikView

Data Integration: Informatica PowerCenter 9.6.1, 9.0, 8.6, ODI 11.1.1.7.1 , Pentaho 3.8

Data Analytics: R 3.2.3, R Studio, ORE 1.3, Hive 2.0.0

EPM: Hyperion Planning 11.1.2.3, Essbase 11.1.2.3.500 , Workspace 11.1.2.3

Operating Systems: UNIX, Sun-Solaris, oel5, oel6, Windows NT

Database: DB2 8.2, Confidential 9i/10g, 11g, Exadata, SQL Server 2008, Teradata

Methodologies: Waterfall, Agile, Scrum, RAD

CRM: Siebel 8, Siebel Tools, Actuate, EIM, Sales Force

Languages: Java, C, SQL, PL/SQL, HTML, Java Scripting, UNIX Shell Scripting

Modeling: ER/Studio DA 9.0, Erwin 9.2, Toad Data Modeller

Testing Tools: OATS, BI Validator, HPQC

PROFESSIONAL EXPERIENCE:

Confidential, Sunnyvale, CA

Sr. BI Consultant

Responsibilities:

  • Part of Scrum development team and reported the exact status of the development to the customer.
  • Responsible for OBIEE 12c upgrade from onshore. Supports and manage offshore team from different vendor.
  • Responsible to work with Confidential Support Team, DB Engineers from Confidential to resolve the Service requests raised during Upgrade process.
  • Review business requirement documents from users, assess the requirements functionally and translate business requirements into Technical Design Documents.
  • Working with different teams from gCore Support, EBS support, and multiple upstream/downstream applications team to work for a smooth production rollout.
  • Responsible to do a Proof of Concepts to setup OBIEE in Confidential Cloud Platform.
  • Working on upgrade OBIEE 11g from OBIEE 12c. Supported the Bug fix and new development for OBIEE 12c.
  • Implemented Data Lineage module in ODI, sourced data from ODI metadata and OBIEE RPD and Catalog and created new reports and Dashboards.
  • Customized ODI mappings to meet with business requirement.
  • Monitored the load in ODI Operator and debugged if there is any issues during the load.
  • Implemented Fixed Assets module and Purchase Order Module for Confidential . Developed the fully customized Fixed Assets module in RPD. Created Roll forward report, Asset Transaction Report and Asset Retirement Report.
  • Created new dashboards, reports to implement External OpEx reports using different Account Hierarchy with Selection steps, custom groups and calculated items.

Environment: OBIEE 12c, ODI 12c

Confidential . Santa Ana, CA

Sr. BI Consultant

Responsibilities:

  • Responsible for leading project delivery for development phase in full cycle implementation.
  • Review business requirement documents from users, assess the requirements functionally and translate business requirements into Technical Design Documents.
  • Work with different teams to understand systems for data integration and consolidation.
  • Responsible for reviewing and providing inputs for sizing and capacity planning for procuring new hardware.
  • Responsible for overall data integration, visualization of business data for reporting and analysis.
  • Working on upgrade from 11.1.1.7.1 to 11.1.1.9.1 and then Subsequently OBIEE 12c.
  • Worked on migration project from Confidential BI on-demand(PaaS) to on-premise
  • Designed and build the RPD incorporating the Essbase Cube to RPD. Federate Essbase multidimensional sources with other relational data source
  • Built new dashboards and subject areas based on Essbase cubes as sources. Worked on Financial operational reporting to build Profit and Loss (P&L Variance), Product Mix, Opex reports and dashboards.
  • Created a new custom Fact and Dimension star to report Usage Tracking. Created new reports. Also included Security dashboard.
  • Knowledge in Confidential Fusion Financials implemented at client site. Matched data with Confidential fusion application with OBIEE reports.

Environment: OBIEE 11.1.1.9.1 , EBS 12.1.1, HFM 11.1.2.4, Essbase 11.1.2.4,OBIEE 12c

Confidential, Columbus, IN

Sr. BI Consultant/Architect

Responsibilities:

  • Reporting to IT Program director who was managing the Thunder Program. As a Senior BI consultant have played multiple roles across the project.
  • Responsible for gathering requirement, design and development of fully customized Account Receivable Dashboard with 6 Pages and 16 reports.
  • Reviewed General Ledger and Account Payable Dashboard. Reviewed the RPD, implemented the best practices in gathering requirement, design of RPD, development cycle, User training manual etc.
  • Suggested changes in the Teradata data model and in corporate them in the RPD to improve the performance. Designed the DSO ( Daily Sales outstanding) model as the team was struggling to create for a long time.
  • Follow the release plan to migrate the TDE code, DB objects, RPD and Catalog into the UAT environment and Production environment from SIT environment.
  • Load and monitor the data load for UAT and Production load. Reported the issues to the development team and fixed the issues.
  • Controlled the Version of the ETL Code, created the ETL packages to include the right version of code to be migrated into production.
  • Completed a successful POC for OBIEE 12c upgrade from OBIEE 11.1.1.7 for GL module in one of the development environment.
  • Implemented GL Data security model, as client does not want any security for AP and AR.
  • Set up project documentation repository for future development for which Confidential business manager was very thankful.

Environment: OBIEE 11.1.1.9 and OBIEE 12c Teradata Database, Teradata Decision Experts 14.1 Confidential EBS 11g, Confidential R12, Confidential Data base, Unix

Confidential, St. Louis, MO

Solution Architect

Responsibilities:

  • Reporting to the Vice President of IT from Emerson Tool Company. Managed communication between Cognizant and Emerson at different level. Involved from the planning phase, design, build, SIT and Go-live phase.
  • Created the Plan for project execution, created the weekly status report, monitored the progress of the development, highlighted the delays, dependencies at appropriated forum
  • Handled the requirement gathering sessions, demo to various super users, created design documents, explained business requirement to offshore developers to do the reports and ELT mapping delivery, conducted conference room pilot (CRP) session, guided tester to do SIT, lead many problem solving discussions with customers and other stake holders of the project.
  • My responsibility includes analysis of Confidential EBS Data Model, identify the Gaps between the OOTB FA, MA, P&S, SCM Solutions and the client requirement. Created the customized data model to capture the Marketing Forecast and Point of Sales Data using custom
  • Act as Lead Architect of the project responsible for the ETL Architecture of the project. ETL Design, Report Design, is also included in my scope of work.
  • Done review the RPD, ETL Code review, implemented best practices for RPD and ETL.
  • Planned the data load schedule with customer considering all the various scenarios.
  • Updated the OOTB RPD to handle new subject area, created reports.
  • Integrated Essbase with OBIEE 11g, created a new data source and business model in the RPD. Created reports from Essbase. Pulled Data from Hyperion system.
  • Pulled Data from Confidential ERP Supply Chain Management System. Well versed with Confidential ERP data model.
  • Created comparison reports from Forecast and Actuals report.
  • Executed SIT for ETC, participated in UAT from development, explained the functionality to Users.
  • Migrated the code from dev to test and then to Prod env. Implemented production Go-live. Implemented security in OBIEE environment.
  • Reviewed the data model, included performance tuning during the course of the project to get the targeted time.
  • Used BI validator to do the measure parallel load testing.
  • Created POC on Tableau Reporting and did demo to Executive level users. Working on generating various dashboards in Tableau Server using different data sources such as Teradata, Confidential and Microsoft SQL Server and Excel data sources.

Environment: OBIA 11.1.1.8.1 , OBIEE, ODI, Confidential 11g Database, Confidential EBS 1.2.1.3, Essbase 11g

Confidential, Raleigh, NC

ETL Engineer

Responsibilities:

  • Reporting to the Project owner from Confidential Research. He was over all responsible for the delivery of the project. Responsible for the overall ETL and Reports delivery from KPI to Confidential Research. Currently leading the offshore team of 5 resources from India and 2 onshore resources. Handling all day to day activities like work allocation, conflict resolution, ensuring quality product delivery from offshore, gathering statuses from each person and ensuring the progress aligned with the project goal and vision.
  • Act as Lead Architect of the project responsible for the ETL Architecture of the project. ETL Design, Report Design, DAC Design is also included in my scope of work. My responsibility includes discuss with various group of Confidential Research to understand the business model around Opportunity, Contract, Activities, Experience Subject Areas. This project is implemented in Confidential Managed Cloud Service (OMCS)
  • Understand their Business Requirement, writing the BRD document, submitting them at Confidential Research and get the sign off from the appropriate stake holders. During this process KPI is committed to provide 25 Custom Reports and OOTB Sales Analytics Application.
  • My responsibility includes analysis of SFDC Data Model, identify the Gaps between the OOTB Salesforce Sales Analytics Solutions and the client requirement, Design the Data Model, Design the RPD Modelling, Informatica Mapping. DAC Tasks.
  • Used Apex data loader to pull data salesforce cloud into Confidential relational tables.
  • Developed the de-normalized data model, created Informatica mappings for loading these new tables. Created the DAC Tasks.
  • Updated the OOTB RPD to handle new subject area, created reports.
  • Done review the RPD, ETL Code review, implemented best practices for RPD and ETL.
  • Executed SIT for Confidential research, participated in UAT from development, explained the functionality to Users.
  • Migrated the code from dev to test and then to Prod env. Implemented production Go-live.
  • Implemented security in OBIEE environment.
  • Used Confidential Golden Gate to replicate the data.
  • Captured changed Data using Informatica CDC.

Environment: Confidential 11g, OBIEE 11.1.1.7, Informatica 9.1, DAC 10.3.4, Salesforce.com, SFDC, PLSQL developer, BI Publisher 11.1.1.7, Health Care Domain Knowledge.

Confidential, Redwood City

Sr. Developer, SME

Responsibilities:

  • Reporting to the Director, Business Platform, my responsibility is to provide technical architecture of BI reports that need to present in Business Platform Cloud Product.
  • My responsibility also involves identify the report requirement, design the reports, define the SOA workflow to create and deliver the reports to the specified user group.
  • Create the UI and improve the UX using Html 5 and CSS3,
  • Designed the data model to implement the Confidential Unified Methods (OUM) to create generic product to cater multiple customers.
  • Design the BPEL workflow to deliver the report after the workflow.
  • The Reports generated are pixel perfect reports using BI Publisher. Used Word and excel based templates to create static reports which are disbursed through emails to various users.
  • Used OATS to complete automated functional test script, load test and manage the manual testing cycle.
  • Implement the security in the Java based Cloud solution.
  • Created solution methodology for Confidential Golden gate

Environment: Confidential 11g, OBIEE 11.1.1.7, BPEL, BI Publisher, OATS

Confidential, Dever, CO

Consultant/BI Tech Lead/Informatica, DAC Configurator

Responsibilities:

  • Reporting to the Practice Director, Information Management, my responsibility is to engage with Confidential . 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. Executed the Gap Analysis for the existing source Data and OOB reports. 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.
  • For HR Analytics project I have created 4 dashboards, 30 reports. Lead resources to analyze HR analytics requirement, design the reports, Logical models, Physical Models.Involved in RPD development, created Physical, Logical Data Models. Involved in implementing Object level and Data Level Security. Implemented best practices for HR analytics.
  • 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 Confidential 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 in corporate some of the specific requirement, created Physical Model, Logical Model, implemented security through LDAP, implemented usage tracking.
  • In Confidential Wave 2 release custom reports are built to for Real Estate analytics. The OLTP system is YARDI VOYAGER. As an ETL Configurator in Confidential Wave 2 release, I was responsible for the Data Model design through TOAD Data Modeler Tool.
  • Analyzed the requirement, designed the mapping created ETL design document, get it approved by the Client’s Technical Manager, defined the loading strategy, completed trial run for FULL LOAD and INCREMENTAL LOAD, Created Custom Mappings for custom Dim and Fact Tables. Implemented SCD2 in various dimension mapping.
  • Created custom Subject Areas, Tasks in DAC. Supported the System Test Cases, UATs and rolled out the application successfully.

Environment: Confidential 11g, TOAD, OBIEE 11.1.1.7, Informatica Power Center, DAC 10.1.3.4,TOAD Data Modeler

Hire Now