SUMMARY

• Business Intelligence (BI) Specialist wif over 14 years of successful experience in various Reporting/Visualization tools like OBIEE 12c, IBM Cognos Analytics, Tableau, Power BI, Data modeling tool ER Studio, databases like SQL Server, Teradata & Oracle, and Robotic Process Automation (RPA) tool UiPATH. Recognized consistently for performance excellence and contributions to success in Retail, Supply Chain & Airlines industry. Meticulous, logical and TEMPhas experience of taking a lead role in developing and managing complex technical projects from concept through to implementation.
• 14 years of IT experience wif successful multi cross - functional experience. Experienced BI Specialist having multiple Business Intelligence project exposure performing vital roles.
• Played important roles such as BI Specialist, Data Modeler (Relational & Dimensional Models) (Conceptual, Logical & Physical), Technical Lead, Developer, Customer Support Executive & Quality Analyst.
• Technically Proficient in ORACLE Business Intelligence 12c (OBIEE), Data Modeling (ER Studio Data Architect), Tableau, IBM Cognos Analytics, Power BI, Teradata, SQL & UiPath. The key strength is designing technical solutions to adapt to continuously changing business needs, technologies, and Industry standards.
• Extensively worked on Retail (Supply Chain & Sales) & Airlines domain wif good functional noledge.
• Well versed in Waterfall, Iterative and Scrum (Agile) methodologies.
• Building Analysis Services reporting models and developing visual reports, dashboards and KPI scorecards using Power BI desktop.
• Able to implement row level security on data and understand application security layer models in Power BI.
• Proficient in making DAX queries in Power BI desktop.
• Thorough wif Requirement Gathering, Analysis, Design, Development, Quality Assurance, End User Training, Production Support and on OBIEE Upgrades & Maintaining Data Models & Gathering and Publishing the Data Dictionaries.
• Lead a project team of 20 members and has worked on projects collaborating wif teams from multiple disciplines and locations.
• Closely worked wif Business, End User, Vendor & Product Teams for 7+ years of Experience (Onsite)
• Strong Data Modeling experience using ER diagram, Dimensional data modeling, Star Schema modeling, Snow-flake modeling using tools like EMBARCADERO ERStudio.
• Expertise in design and development of OBIEE Repository (.rpd), Reports & Interactive Dashboards, Security, Usage Tracking & Performance Tuning.
• Strong experience in creating and publishing packages in Framework Manager along wif developing reporting applications using Cognos Business Intelligence components like Report Studio, Framework Manager, Query Studio, Analysis Studio, Metric Studio and Cognos Connection.
• Deploy RPA components including bots, robots, development tools, code repositories and logging tools.
• Used UiPath Orchestrator for deployment, monitoring, and management of UiPath Robot automation activity.
• Expertise in using REFramework to build the robots to perform various kind of automation like Web Scraping, Excel Automation, Email Automation etc.
• Expertise in development of Tableau visualizations which includes preparing dashboards using various reporting objects such as facts, attributes, transformations, filters, prompts, calculated fields, parameters, groups, sets and hierarchies along wif solution driven dashboards by developing different chart types including Crosstabs, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop.
• Has been strong in effective communication, relationship management, organizational skills, dedicated, result-driven and customer focused IT professional wif strong work ethics.
• Good in analytical, decision-making, problem solving and management skills wif ability to organize activities in fast speedy team environment.
• Proven attributes in mentoring/evaluating technical skills in potential candidates / new recruits.

PROFESSIONAL EXPERIENCE

Confidential, Chicago

OBIEE/Tableau/Cognos/Data Modeler

Responsibilities:

• Created Data Models using ER diagram, Dimensional data modeling, Star Schema modeling, Snow-flake modeling using EMBARCADERO ERStudio.
• Created robots (using REFramework) for distribution of Invites to Customers for Survey, Scraping the Comments from Social Media sources.
• Gathering reporting and analysis requirements, documenting the report specifications, implementing the metadata (.rpd) layers including Physical, Business Model and Mapping, and Presentation layer using Administration Tool.
• Configured OBIEE Metadata Objects including repository, variables, interactive dashboards, and reports.
• Designed customized interactive dashboards in OBIEE using drill down, guided navigation, prompts, filters, and variables.
• Used OBIEE Answers to create queries, format views, charts, and add user interactivity and dynamic content to enhance the user experience.
• Used Variable Manager to define session and repository variables and initialization blocks.
• Defined Key Performance Metrics (KPIs) and developed Dimensional Hierarchies, Level Based Measures, and adding multiple sources to business model objects.
• Created and scheduled Agents in Oracle BI Delivers to provide real-time, personalized, and actionable intelligence data to subscribers.
• Configured and set up of OBIEE Security using LDAP and External Database Tables and object level and database level security.
• Worked wif DBAs and BAs towards performance tuning in OBIEE and Data Warehouse environment using cache management, aggregate tables, and indexes.
• Created and publishing packages in Framework Manager.
• Extensively used Framework Manager, Query Studio and Report Studio for model design, ad-hoc reporting and advanced report authoring.
• Created relational & dimensional modeling of Star Schemas, Snow-Flake Schemas Methodologies for building enterprise data warehouses.
• Implemented Drill-Through, Cross-Tabs, Summary Reports, Burst Reports.
• Performed Unit Testing and provided Support to External Quality Testing and User Acceptance.
• Provided End User Training on the Solution Developed.

Confidential

OBIEE/ Tableau /Cognos/Data Modeler

Responsibilities:

• Created Data Models using ER diagram, Star Schema modeling using EMBARCADERO ERStudio.
• Gathering reporting and analysis requirements, documenting the report specifications, implementing the metadata (.rpd) layers including Physical, Business Model and Mapping, and Presentation layer using Administration Tool.
• Configured OBIEE Metadata Objects including repository variables, interactive dashboards, and reports.
• Designed customized interactive dashboards in OBIEE using drill down, guided navigation, prompts, filters, and variables.
• Used OBIEE Answers to create queries, format views, charts, and add user interactivity and dynamic content to enhance the user experience.
• Used Variable Manager to define session and repository variables and initialization blocks.
• Developed Dimensional Hierarchies, Level Based Measures, and adding multiple sources to business model objects.
• Created and scheduled Agents in Oracle BI Delivers to provide real-time, personalized, and actionable intelligence data to subscribers.
• Configured and set up of OBIEE Security using LDAP and External Database Tables and object level and database level security.
• Worked wif DBAs and BAs towards performance tuning in OBIEE and Data Warehouse environment using cache management, aggregate tables, and indexes.
• Created solution driven dashboards by developing different chart types including Crosstabs, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau.
• Developed visualizations which includes preparing dashboards using various reporting objects such as facts, attributes, transformations, filters, prompts, calculated fields, parameters, groups, sets and hierarchies.
• Designed and created various analytical reports and Dashboards to halp users to identify critical KPIs and facilitate strategic planning in the organization.
• Worked extensively on joining tables, multiple data connections using data blending, worked on Data Extracts, and managing queries.
• Worked on Performance Tuning of Tableau Dashboards and Reports built on huge Data sources.
• Communicated the requirements to offshore & get the closed the understanding gap & queries answered by Business.
• Managed the Admin activities related to the Application.
• Groomed Offshore Associates wif Analytical, Functional and Technical skills.