SUMMARY

• Over 12 years of strong technical IT experience in Finance, Health Care, Banking industries with ETL Data warehousing background using Informatica Power Center 10x,9X, Data Stage 9.0, OBIEE 11g/12C and Tableau 10,2018.2,2019.2
• Experience in OBIEE Administration, configuring MUDE, OBIEE Schedule, usage tracking. Repository Sever and Presentation Server configuration changes, Cache management, space management using OBIEE 12c/11g/10g.
• Expertise in Business Model development with Dimensions, Hierarchies, Measures, Partitioning, Aggregation Rules, Time Series, Cache Management.
• Experience in configuring OBIEE Reports & Dashboards, OBIEE Agents/Delivers, Narrative views.
• Involved in Upgrade process from OBIEE 10 g to OBIEE 11g and from OBIEE 11g to OBIEE 12c.
• Extensive experience in using Web logic server and Enterprise Manager in OBIEE 11g.
• Experience in Installation, Configuration, and Administration of OBIEE Suite on Windows Server environment.
• Effective working relationships with client team to understand support requirements, and effectively manage client expectations.
• Excellent communication & interpersonal skills; very proficient in leveraging technical and business acumen to communicate effectively with executives and respective large, diverse and cross - functional teams of North America
• Business strategist; plan, manage & implement multimillion-dollar projects aligning business goals with global and scalable technology solutions to drive process improvements and bottom-line gains
• Experience in using Informatica Power Center tools such as Source Analyzer, Transformation Developer, Moppet Designer, Mapping Designer, Workflow Manager, Workflow Monitor and Repository Manager
• Extensive experience in developing complex mappings from varied transformations like Router, Filter, Sorter, Connected and Unconnected lookups, Normalizer, Expression, Aggregator, Joiner, Union, Update Strategy, and Sequence Generator.
• Extensive experience in Production support dealing with support escalations from Level 1 team, including complex user and monitoring support queries, with as minimal as possible escalations to L3 teams by planning and execution of proactive non-ticket tasks.
• Performed configuration of Oracle BI Processes, Data sources, Presentation services and Scheduler.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema modeling, Snowflakes modeling, fact and dimension tables modeling of data.
• Actively Interacted with project managers & team members to discuss timely deliverables, project status & documented technical specifications from functional specifications in reporting point.
• User requirements identified various fit-gaps on existing Oracle analytics warehouse and developed solutions to meet requirements and loaded the user required data into the OBAW.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameterized using Tableau 10.0/2018.2/2019.3
• Facilitate meetings with data users, data stewards and other stakeholders to ensure data governance rules and standards are applied to data related changes/projects.

TECHNICAL SKILLS

Operating System: Windows XP, Windows 7

Tools: Service Now, Quality Center, Global answers Ticketing System, GitHub

Database: Oracle11g, SQL Server 2005, Oracle LSH

Reporting Tools: OBIEE 10.1.3.4 & 11.1.1.7.0 , 12.2.1.1 and BI Publisher 10g/11g, Tableau 10.0/2018.2/2019.3

BI Apps: Supply Chain Analytics, Procurement & Spend Analytics, HR Analytics, Financial Analytics.

ETL: Informatica Power Center 9.x/8.x(Source Analyzer, Data warehousing Designer, Mapping Designer, Mapplet Designer, Transformations Developer, Repository Manager, Workflow Monitor, OLTP, OLAP., DataStage 11.5, ODI 12.2.1

Data Modeling Tools: Erwin (Star Schema Modeling, Snow Flake Schema Modeling, Fact Tables and Dimension Tables).

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Developer

Responsibilities:

• Created/Modified Metadata repository, Customized BI Repository, defined/developed Physical Layer, Business Model and Presentation Layer using BI Administration Tool.
• Developed dashboard pages like FPM Processing Validations.
• Involved in Repository Configuration, Troubleshooting and Migration.
• OBIEE Admin work: New User, Application Role, Account modification of existing users.
• Implemented OBIEE Security (Object Level and Data Level Security in the OBIEE Repository and Answers) using Repository Variables, Session Variables and Initialization Blocks.
• Worked on MUD Environment.
• Created Dashboards by embedding reports and providing intuitive drilldowns and links to exploit the full benefit of Analytics.
• Security management for users, groups and web-groups using the various authentication systems such as LDAP authentication using Session Variables, as well as Dashboard / Report-level security.
• Developed Complex mappings from different transformation logics like Unconnected /Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Union, Update Strategy and more.
• Extensively used Informatica client tools like Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer.
• Scheduling the Workflows in Informatica.
• Increased performance of loads by applying proper Hints, Indexes, and Analyzing master tables and explain plans to check cost.
• Performed Business Process mapping for new requirements.
• Implemented the installation and configuration of OBIEE 12.2.2.1 in Development, Test and Production environment.
• Worked in production issues and resolved those within SLA.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Restricted data for particular users using Row level security and User filters.
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Developed Tableau workbooks from multiple data sources using Data Blending.
• . Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Generated context filters and data source filters while handling huge volume of data.
• Built dashboards for measures with forecast, trend line and reference lines.
• Published Workbooks by creating user filters so that only appropriate teams can view it.

Confidential

Lead, Developer

Responsibilities:

• Gathered the Business Requirements from various analysts like Clinical and Safety Personnel Leads.
• Identifying the gaps and the customizations required in order to achieve the Compliance and Medical Safety Dashboards.
• Created/Modified Metadata repository(.rpd), Customized BI Repository, defined/ developed Physical Layer, Business Model and Presentation Layer using BI Administration Tool.
• Developed dashboard pages like Demographics, Events, Indication, Outcome, Special Events, and Compliance Metrics. etc.
• Involved in Repository Configuration, Troubleshooting and Migration.
• OBIEE Admin work: New User, Application Role, Account modification of existing users.
• Implemented OBIEE Security (Object Level and Data Level Security in the OBIEE Repository and Answers) using Repository Variables, Session Variables and Initialization Blocks.
• Knowledge of working in MUD Environment.
• Created Dashboards by embedding reports and providing intuitive drilldowns and links to exploit the full benefit of Analytics.
• Security management for users, groups and web-groups using the various authentication systems such as LDAP authentication using Session Variables, as well as Dashboard / Report-level security.
• Developed Complex mappings from different transformation logics like Unconnected /Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Union, Update Strategy and more.
• Extensively used Informatica client tools like Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer.
• Scheduling the Workflows in Informatica.
• Increased performance of loads by applying proper Hints, Indexes, and Analyzing master tables and explain plans to check cost.
• Performed Business Process mapping for new requirements
• Implemented the installation and configuration of OBIEE 11.1.1.7.1 in Development, Test and Production environment.
• Worked extensively on OBIEE 11 G for RPD and Webcatalog upgrade and also created new reports.
• Worked on worksheets in Tableau environment.
• Supported the Tableau Desktop/Server and worked on few issues raised by Business.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Restricted data for particular users using Row level security and User filters.
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Developed Tableau workbooks from multiple data sources using Data Blending.
• . Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Generated context filters and data source filters while handling huge volume of data.
• Built dashboards for measures with forecast, trend line and reference lines.
• Published Workbooks by creating user filters so that only appropriate teams can view it.

Confidential

Lead, Developer

Responsibilities:

• Experience in creating reports in OBIEE 11 g.
• Gather Business Involved in full project life cycle implementation.
• Involved in Upgrade process from OBIEE 10 g to OBIEE 11g and apply patches on 11g.
• Created OBIEE 11g Repository (.rpd) which involves Schema Import, Implementing the business logic, requirements from Client, Create High level design documents.
• Review the detailed design documents and identify the gaps.
• Provided Technical Assistance by responding to inquiries regarding errors, problems, or questions with programs/interfaces.
• Created Dashboards, Answers, Charts.
• Worked on few reports on Oracle BI Publisher 11.1.1.6 after migrating from 10.1.3.4.1
• Involved in setup and configuration of Oracle BI Publisher 10.1.3.4.1
• Involved in Setting up of users/roles in OBIEE 11g.
• Used the Totals/Subtotals/Group/Sort features of BI Publisher to make data intense operations happen at the template level.
• Interacted with business representatives for GAP Analysis and to define Business and Functional Specifications. Participated in the Design team and user requirement gathering.
• Involved in OBIEE Project development in all the phases (Development, UAT and Production) .
• Extensively used ETL to load data from multiple sources to Staging area (Oracle) using Informatica Power Center 9.1.1.
• Involved in the Development of Informatica mappings and mapplets and also tuned them for Optimum performance, Dependencies.
• Loaded the data in incremental fashion by using batches & sessions on Informatica Server Manager.
• Created Several Informatics Mappings to populate the data into dimensions and fact tables.
• Worked on Aggregation, filter, router, lookup, unconnected lookup, expression, sequence generator transformations according to Business requirements.
• Analyzed the source data, coordinated with Data Warehouse team in developing Relational Model. Designed and developed logical and physical models to store data retrieved from other sources including legacy systems.
• Involved in Unit testing and documentation.
• Worked on worksheets in Tableau environment.
• Supported the Tableau DeskTop/Server and worked on few issues raised by Business.

Confidential

Lead, Developer

Responsibilities:

• Gather Business Requirements from Client, Create High level design documents.
• Review the detailed design documents and identify the gaps.
• Involved in OBIEE Project development in all the phases (Development, UAT and Production)
• Involved in installing and configuring of Financial Analytics.
• Analyzed the source data, coordinated with Data Warehouse team in developing Relational Model. Designed and developed logical and physical models to store data retrieved from other sources including legacy systems
• Designed and developed General Ledger, Payables, Receivables and Profitability dashboards in OBIEE.
• Developed Dashboard pages like GL Balance, Cash flow and Balance Sheet in General Ledger Dashboards.
• Developed Dashboard pages like AP Balance, Overview, Payments Due, Supplier Details and Invoice Details in Payables Dashboards.
• Created AD hoc reports in Account Payables.
• Analyzed technical requirements and used metadata design principles to design repository and followed best practices.
• Extensively used ETL to load data from multiple sources to Staging area (Oracle) using Informatica Power Center 8.1.
• Involved in the Development of Informatica mappings and mapplets and also tuned them for Optimum performance, Dependencies.
• Loaded the data in incremental fashion by using batches & sessions on Informatica Server Manager.
• Created Several Informatics Mappings to populate the data into dimensions and fact tables.
• Worked on Aggregation, filter, router, lookup, expression, sequence generator transformations according to Business requirements.
• Worked extensively on OBIEE security for users and groups based on the individual and group responsibilities.
• Created several reports including table view, pivot table view and chart views in OBIEE Answers.
• Knowledge of working in MUD Environment.
• Created Dashboards by embedding reports and providing intuitive drilldowns and links to exploit the full benefit of Analytics.
• Worked on Write back functionality of OBIEE to update the database values with the user updated values at the presentation.
• Worked on worksheets in Tableau environment.

Confidential

Developer

Responsibilities:

• OBIEE Installation, Configuration, and Administration on Client/Server environment.
• Created OBIEE Repository (.rpd) which involves Schema Import, Implementing the business logic by customization, Dimensional Hierarchies, Aggregate Navigation, Level Based Measures, Security Management (Data level/Object level security), Variables, Initialization blocks and cache management.
• Incorporating Analytics will help users especially Sales and Installation Managers to analyze the performance of Sales Rep, Installers and Leads generated by Market.
• Successfully implemented OBIEE delivers/Created Proactive agents (iBots) and configured Interactive dashboards to alert the Business/Field users as per the requirements.
• Extensively worked on global filters for use in exercising dashboard wide control over requests that are embedded into a dashboard page.
• Created complex reports by using Set operations and direct database request.
• Worked extensively on security for users and groups based on the individual and group responsibilities.
• Developed dimensional hierarchies based on the business requirement of an attribute.
• Developed security matrix for dashboards/Answers users based on Individual responsibilities and LDAP Authentication type.
• Extensively used ETL to load data from multiple sources to Staging area (Oracle) using Informatica Power Center 8.1.
• Involved in the Development of Informatica mappings and mapplets and also tuned them for Optimum performance, Dependencies.
• Loaded the data in incremental fashion by using batches & sessions on Informatica Server Manager.
• Created Several Informatics Mappings to populate the data into dimensions and fact tables.
• Worked on Aggregation, filter, router, lookup, expression, sequence generator transformations according to Business requirements.
• Interacted with business representatives for Need Analysis and to define Business and Functional Specifications. Participated in the Design team and user requirement gathering.
• Analyzed the source data, coordinated with Data Warehouse team in developing Relational Model. Designed and developed logical and physical models to store data retrieved from other sources including legacy systems.
• Involved in Unit testing and documentation.
• Designed the RTF Template and created the reports using BI Publisher 11g.