Developer Manager

Location:

Marietta, GA

Posted:

May 14, 2018

Contact this candidate

Resume:

Ketki Hande

Tableau/ OBIEE Consultant

+1-669-***-****

Profile

Around 9+ Years of IT Experience

8+ Years of OBIEE /Siebel Analytics Experience

Around 2 Years of Experience with Tableau Desktop

Professional Summary

Around 9+ years of Complete Software Development Life cycle (SDLC) (gathering Business Users Requirements, System Analysis, Design & Data Modelling, Development, Testing) implementation experience of Data Warehouse, Data Mart and Business Intelligence using Siebel Analytics/ OBIEE, Informatica, BI Publisher DAC and OBIA

Excellent communication skills and experience working with business users and leads/managers with strong analytical & problem-solving skills and a quick learner of innovative technologies and concepts.

Working with Business to understand the functional flow to best guide with a solution that scale the needs.

Experience in Agile Methodology with focus on process driven framework.

Driven by data to get to the Business, tools to strengthen decisions.

Experience in identifying & analyzing the source/feeder systems, identifying GAPS and providing appropriate solutions.

Creating documentation for all processes and guides followed.

Creating functional and technical documents for all the Reports, Dashboards or analysis worked on.

Co-ordinating with the Business Users and the Stakeholders for bringing up the merge and Prod deployment.

Very strong in OBIEE/Siebel Analytics Admin Tool, Analytics Web, Presentation Services and Delivers.

Experience transforming complex business requirements into rich data visualizations using Tableau.

Experience with Tableau Desktop Visualization Tool.

Developed, publishing customized interactive reports and dashboards using Tableau Desktop.

Experience in creating Tableau visualizations using Advanced Calculated Fields, Filtering, Table Calculations, Parameter driven analysis and TDEs.

Working Experience with BI Publisher.

Understanding on MOGO DB, MDM and Big Data.

Expertise in developing Oracle BI/Siebel Analytics Repository consisting of three layers (Physical Layer, Business Model & Presentation Layer.

Good in validating the BI reports/dashboards by preparing the Test Plans & Cases.

Expertise in providing end-to-end business intelligence solution by dimensional modeling design, building business models, configuring metadata, Answers, Delivers/iBots, creating Interactive Dashboards with drill-down and drill-across capabilities, Security (groups, access/query privileges), Web Catalogue Objects (Dashboard, Pages, Folders, Reports), cache monitor, Job Manager, Catalog Manager and building Repository consisting of three layers (Physical Layer, Business Model & Presentation Layer) using Oracle BIEE/Siebel Analytics.

Experience serving industrial segments like Sales, Marketing, Finance and Service in business related to implementation of ERP and BI Solutions.

Expertise in debugging and optimizing the Oracle BI/Siebel Analytics Dashboards/Reports and Informatica Mappings/Workflows.

Hands on experience in developing Informatica Mappings/Mapplets using various Transformations for Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse and creating Workflows with Worklets & Tasks and scheduling using Workflow Manager.

Performance tuning of Oracle BIEE/Siebel Analytics Repository, Analytics Dashboards/Reports.

Organizational Skills

Team based working

Time management

Ability to communicate at all levels within an organization

Ability to work autonomously and as part of a small project team

Ability to write user requirements, system specifications and test plans

Experience working in large, medium and small sized projects

Education

Bachelor of Engineering, Rajiv Gandhi Technical University, INDIA

Technical Skills

Siebel Analytics

Siebel Analytics 7.x

OBIEE

OBIEE 11.1.X, OBIEE 10.1.X, OBIEE marketing

Tableau Desktop

Tableau Desktop version 9.3,10.2, 10.5

Languages/Utilities

SQL, PL/SQL,

Databases, Database Tools

Oracle 8I/9I/10G, SQL Developer, TOAD

ETL\Data migration

Informatica 9.5 and DAC

BI Tools

Tableau 9.2, BI Publisher, Quality Stage

Testing Tools

Manual Testing

Operating systems

Windows 98/NT/XP/2000/2003

Domain Experience

Telecom

Finance

Marketing

Clinical Research

Professional Experience

Employer: PRA Health Sciences, Raleigh, NC, USA

Business intelligence Developer May16 – Till Date

Project Title : Innovative intelligence Group

Phase : Development

Scope of the Project: PRA Health Sciences IIG Team is responsible for providing information about the various information aspects of the Clinical Development. Improving the facilities based upon the information obtained through the statistics and data Analysis.

Responsibilities:

Participated in gathering and analyzing the Business Requirements in collaboration with the Subject Matter Experts (SMEs), Business Analysts, Users and base lining the details.

Closely working with Business to better understand the requirements and design a solution that best cater the needs.

Continuous Communication with the Business stakeholders to make sure the ongoing deliverable is in line with the requirements.

Developed, publishing customized interactive reports and dashboards using Tableau Desktop.

Created and Scheduled Data extracts (.tde) Data source Connections.

Developed Tableau visualizations using Advanced Calculated Fields, Filtering, Table Calculations, Parameter driven analysis.

Developed several Visualizations using Scatter plots, Gantts, Bubbles, Histograms, Heat maps, Text Tables, Highlight Tables for analyzing the data.

Used Individual Axes and Dual Axes to compare different measures.

Utilized several dashboard objects Vertical Panes, Horizontal Panes, Blank, Tiled, Floating, Text, Web-page, Image to create efficient dashboard using tableau desktop.

Customized the Quick Filters by enabling/disabling different Filter types, Include/Exclude, All Values.

Created Aggregations, Table calculations, Totals, percentages using Key Performance Measures (KPI).

Created Worksheet actions to Filter or Highlight or navigate to the Target Sheets from the Source Sheets.

Implemented best practices for better performance of the Dashboards and sheets.

Worked with ETL team for performance improvement and tuning of SQL queries and fixed the slow running queries.

Developed and customized the OBIEE Metadata repository (.rpd) model by creating connection pools, physical / Alias Tables, defined joins and implemented authorizations in the physical layer, aggregates, dimensions, hierarchies & time series functions in the BMM Layer, Catalogues & folders in Presentation Layer using Oracle BI Administration tool.

Utilized Oracle Delivers for sending real-time, personalized alerts via intelligence agents (iBots) to subscribed users.

Resolved issues resulting from User Acceptance Testing (UAT).

Provided Documentation and Training for End Users to access and utilize the Dashboards.

Environment: Oracle Business Intelligence (OBI) EE 11.1.1.x, BI Publisher 11.1.1.7.0, Tableau 10.X, Oracle 10g, SQL Developer, MS Windows XP, MS Office Suite

Client: PRA Health Sciences, Raleigh, NC, USA

Employer: Reliable Software Resources Inc

Senior BI Consultant Jul15 – Apr16

Project Title : Information Technology Services

Phase : Development

Scope of the Project: PRA Health Sciences BI Team is responsible for providing information about the various information aspects of the Clinical Development. Improving the facilities based upon the information obtained through the statistics.

Responsibilities:

Participated in gathering and analyzing the Business Requirements in collaboration with the Subject Matter Experts (SMEs), Business Analysts, Users and base lining the details.

Participated in complete life cycle of the project from project initiation, to development, to production support and maintenance.

Participating in the Analysis, Design and Review phase for every Sprint.

Working with the Business stakeholders to best answer questions on every stage of the development cycle.

Co-ordinating with the Business Users and the Stakeholders for bringing up the merge.

Use of Java Scripts to achieve specific requirements.

Created different types of Reports (Drilldown, Aggregation, Levels) to meet business requirements. Generated various Analytics Reports like Formulary Report, Union Report and Direct Sales Report using global and local filters.

Implemented security by creating users & web groups, setting up External Table Authentication, creating Session Variables and Initialization Blocks and associating catalogue objects and Web modules with the created groups.

Utilized Oracle Delivers for sending real-time, personalized alerts via intelligence agents (iBots) to subscribed users.

Created comprehensive and easy-to-understand Documentation of the complete implementation of the Customer Sales Business modules (Reports, Dashboards, Security and Star schema).

Thoroughly following the Agile Methodology for Release management.

Environment: Oracle Business Intelligence (OBI) EE 11.1.1.x, BI Publisher 11.1.1.7.0, Oracle 10g, SQL Developer, MS Windows XP, MS Office Suite

Client: New York State Department, Albany, NY, USA

Employer: Marquee of Emerging Market Inc

Senior BI Consultant Feb15 – Jul15

Project Title : Information Technology Services

Phase : Development

Scope of the Project: New York State Department Business Information Team is responsible for providing information about Children and People with Disabilities. Improving the facilities based upon the information obtained through the statistics.

Responsibilities:

Participated in gathering and analysing the Business Requirements in collaboration with the Subject Matter Experts (SMEs), Business Analysts, Users and base lining the details.

Working with the Business stakeholders to best answer questions on every stage of the development cycle.

Identified the aggregate levels for measures and created dimension hierarchy sources for each level of aggregates for performance enhancement.

Developed and customized executive level dashboards and reports in various views such as Pivot Table, Charts, View Selectors, Column Selectors, catering to provide insight into the Sales / Marketing / Financial data.

Utilized Oracle Delivers for sending real-time, personalized alerts via intelligence agents (iBots) to subscribed users.

Created comprehensive and easy-to-understand Documentation of the complete implementation of the Customer Sales Business modules (Reports, Dashboards, Security and Star schema).

Worked BI Publisher to create the reports as per the business requirements.

Understanding of BI Aps for merging the existing Data Warehouse with the OBIA.

Executed Informatica SDE/SIL ETL mappings to populate facts/dimensions.

Involved in developing ETL process i.e., Mappings & Mapplets using various Transformations and Workflows with Sessions / Tasks.

Administered NQSConfig.ini and Instanceconfig.xml configuration files.

Environment: Oracle Business Intelligence (OBI) EE 11.1.1.x, BI Publisher 11.1.1.7.0, OBIA 7.9 Oracle 10g, SQL Developer, MS Windows XP, MS Office Suite

Client: Child Maintenance Group, Mumbai, India

Employer: Tata Consultancy Services

Senior OBIEE Developer /Analyst Jun14 – Aug14

Project Title : Business Information

Phase : Development

Scope of the Project: Child Maintenance & Group is the Commission set by the Government of United Kingdom for maintaining the rights and benefits of children living in separated or single families. As an OBIEE developer, worked on the core data for the individual customers and created Campaigns using OBIEE Marketing.

It works with every client to research, analyze and interpret the business of Information Technology.

Responsibilities:

Participated in gathering and analyzing the Business Requirements in collaboration with the Sales, Marketing and Finance Subject Matter Experts (SMEs), Business Analysts, Users and base lining the details.

Developed and customized the Oracle BIEE Metadata repository (.rpd) model by creating connection pools, physical / Alias Tables, defined joins and implemented authorizations in the physical layer, aggregates, dimensions, hierarchies & time series functions in the BMM Layer, Catalogues & folders in Presentation Layer using Oracle BI Administration tool.

Utilized Oracle Delivers for sending real-time, personalized alerts via intelligence agents (iBots) to subscribed users.

Created BI Publisher Reports to download as PDF for analysis.

Created comprehensive and easy-to-understand Documentation of the complete implementation of the Business modules (Reports, Dashboards, Security and Star schema).

Administered NQSConfig.ini and Instanceconfig.xml configuration files.

Worked with Catalogue Manager Tool.

Performed the Server Administration tasks of migrating the BI Repository, Webcat between the Development, Testing, and UAT.

Executed Informatica SDE/SIL ETL mappings to populate facts/dimensions.

Involved in developing ETL process i.e., Mappings & Mapplets using various Transformations and Workflows with Sessions / Tasks.

Participated in complete life cycle of the project from project initiation, to development, to production support and maintenance.

Extensively involved in task allocation and release management

Environment: Oracle Business Intelligence (OBI) EE 10.1.3.x, OBIEE Marketing, Informatica 7.1.8, Oracle 10g, TOAD, MS Windows XP

Client: Child Maintenance Group, Leeds, United Kingdom

Employer: Tata Consultancy Services

Senior OBIEE Developer /Analyst Apr12 – May14

Project Title : Business Information and Case Closure

Phase : Development

It works with every client to research, analyze and interpret the business of Information Technology.

Responsibilities:

Created BI Publisher Reports to download as PDF for analysis.

Created comprehensive and easy-to-understand Documentation of the complete implementation of the Business modules (Reports, Dashboards, Security and Star schema).

Administered NQSConfig.ini and Instanceconfig.xml configuration files.

Executed Informatica SDE/SIL ETL mappings to populate facts/dimensions.

Involved in developing ETL process i.e., Mappings & Mapplets using various Transformations and Workflows with Sessions / Tasks.

Monitoring and configuring DAC.

Creating marketing Campaigns for the enabling the scheme to reach remote customers through SMSs

Worked with Catalogue Manager Tool.

Performed the Server Administration tasks of migrating the BI Repository, Webcat between the Development, Testing, and UAT.

Participated in complete life cycle of the project from project initiation, to development, to production support and maintenance.

Extensively involved in task allocation and release management.

Co-ordinating and working closely with the offshore team located in Mumbai, India.

Environment: Oracle Business Intelligence (OBI) EE 10.1.3.x, OBIEE Marketing, Informatica 7.1.8, DAC 7.8, Oracle 10g, TOAD, MS Windows XP

Client: Royal Bank of Canada, Mumbai, India

Employer: Tata Consultancy Services

Senior OBIEE Developer Feb11 –Mar12

Project Title : Business Intelligence and Independent Price Verification

Phase : Development

Scope of the Project: Royal Bank of Canada is one of the Leading banking firms. The project involved maintaining Business Information spanning to all the sectors of work for the bank and analysis for the day to day business.

Responsibilities:

Participated in requirements gathering of the various work streams by discussing with the business user and base lining the details.

Requirement analysis, Designed and implemented custom business intelligence solutions (Metadata and Dashboards/Reports) using the Siebel / Oracle Business Intelligence (OBI) Analytics platform.

Developed the repository model for the different work streams with the necessary logic that involved creating the Physical, BMM and the Presentation layer, customized the existing model and Created hierarchies, variables, and event poll strategies in the repository.

Developed and customized OTB reports and new Reports, cosmetic changes to Dashboards with different subject matter Views (Drill-Down / Dynamic, Pivot Table, Chart, Column Selector, Tabular with global and local Filters) using Siebel Analytics Web / Oracle Business Intelligence (OBI) Presentation Services for the various work streams.

Created and customized reports with different views - Table, Pivot Table, Charts, Column Selector, etc using Answers.

Administered NQSConfig.ini and Instanceconfig.xml configuration files.

Customized OTB mappings for Financial Analytics and customizing for the new requirements.

Prepared the Test Plans and Test cases for validating the reports/dashboards.

Created the OBIEE environment for Development, QA and Production environment.

Participated in complete life cycle of the project from project initiation, to development, to production support and maintenance.

Environment: Oracle Business Intelligence (OBI) EE 10.1.3.x, Oracle 10g, TOAD, MS Windows XP

Client: Saudi Telecom Company, Mumbai, India

Employer: Tata Consultancy Services

OBIEE/ Siebel Analytics Developer Jul09 – Jan11

Project Title : Enhancement and Outsourcing

Phase : Development

Scope of the Project: Saudi Telecom Company is the largest service provider in the Middle East countries.

As a member of the Business Intelligence team I was responsible for providing the Business Statistics for the management decision making.

Responsibilities:

Worked closely with Business Users and Subject Matter Experts (SMEs), reviewed Functional Design Document, created Technical Design Document and gathered the requirements from different user groups and created the design for the application.

Developed and customized the OOTB OBI EE metadata repository model with the necessary logic that involved creating the Physical, BMM and the Presentation layer.

Customized logical tables and columns, defined the Analytics dimensions, aggregations and levels.

Administered NQSConfig.ini and Instanceconfig.xml configuration files.

Configured iBots to deliver Analytics content and automated iBot queries for daily and weekly reports.

Configured Repository, Presentation and Session variables to get dynamic reports and dashboards.

Executed Informatica SDE/SIL ETL mappings to populate Siebel facts/dimensions.

Involved in developing ETL process i.e., Mappings & Mapplets using various Transformations and Workflows with Sessions / Tasks.

Monitoring DAC Schedules.

Performed the Server Administration tasks of migrating the BI Repository, Webcat between the Development, Testing, and UAT.

Performed all phases of end-to-end testing which includes Unit Testing, Integration Testing, Functionality Testing, and Regression Testing of the application.

Environment: OBI EE 10.1.3.3.1, Siebel Analytics 7.8.x, Siebel CRM 8.1, Informatica 7.1, DAC 7.9.5, Oracle 10g, MS Windows XP

Client: Sony Pictures, Mumbai, India

Employer: Tata Consultancy Services

Business Objects/Quality Stage Developer Nov08 – Jun09

Project Title : BI - Centre of Excellence - Delivery

Phase : Development

Scope of the Project: Sony Pictures is one of the leading Movie Production House and Home Entertainment Company. The Business Intelligence team was responsible for the Overall Business Information for the decision making.

Responsibilities:

Creating Business Objects reports as per requirements.

Creating Quality Stage jobs for the data cleansing and de- duplication.

Creating User documentation for the Quality Stage jobs created.

Testing the reports and jobs created.

Environment: Business Objects, Quality Stage, Oracle 8i, MS Windows XP

Contact this candidate