SUMMARY

• Powered business by creating impactful visualizations on KPIs related to COVID - 19 which helped teh management take key strategic decisions during teh pandemic.
• Seasoned in architecting, designing, developing Business Intelligence solutions across multiple domains like Telecom, Technology, Petrochemicals, Pharmaceutical, Healthcare, Finance, Travel and Hospitality industries.
• Achieved great success in architecting and developing impactful Power BI solutions in Enterprise Environment which included report and dashboard design, development, technical support, troubleshooting, and configuring data security, assigning licenses, publishing and sharing reports and dashboards to different user groups in teh organization.
• Spearheaded many projects as a subject matter expert of Oracle Business Intelligence Enterprise Edition (OBIEE 12C/11g) and over teh years gained extensive experience in repository (RPD) and report catalog design, development, customizations.
• Achieved high proficiency in design, development, enhancement, and support Tableau visualizations including, but not limited to, highly interactive dashboards, advanced geographic maps, scorecards, and reports.
• Gained expertise in writing Parameterized Queries for generating Tabular reports, Sub reports using Global variables, Expressions, and Functions, Sorting teh data, Dashboard, Scorecards, Drill-down and Drill-through reports, Defining Data sources and Subtotals for teh reports using Tableau Desktop and integrating it wif Tableau Server.
• Received tremendous appreciation from teh business community as a testimony to teh comprehensive trainings provided to business users and support team dat focused on leveraging Tableau, Power BI and OBIEE features to efficiently perform their duties.
• Skilled in working wif ETL tools like Informatica PowerCenter for creating data integration solutions.
• Profound understanding of OLAP Systems and dimensional modeling.
• Diverse experience gained from working in projects following Waterfall, Scrum and Agile methodologies.
• Excellent analytical and interpersonal skills and strong ability to work independently and as part of a team to accomplish critical business objectives as well as good decision-

TECHNICAL SKILLS

Technologies: Tableau Desktop, Tableau Server, OBIEE, Power BI, Azure Analysis Services, Informatica

PowerCenter: SQL, Shell Scripting

Operating Systems: Linux, Unix, Windows 2003/NT/XP/10

Databases: Oracle 12c/11g/10g/9i, SQL Server 2008 R2EE

Tools: TOAD 13.1, SQL Developer, OBIEE 12c/11g/10g, Power BI, Tableau Desktop, Tableau Server, Informatica PowerCenter 9.5.1, JIRA

PROFESSIONAL EXPERIENCE

Confidential, Washington DC

Senior BI Consultan

Responsibilities:

• Worked wif business stakeholders and participated in requirement gathering sessions to understand teh business needs and created Power BI dashboards to create visualizations to answer teh business questions.
• Created rich graphic visualization using filled map to enable a fast read on Credit Risk associated wif Confidential credit assistance to foreign countries (rated by Confidential ).
• Created rich graphic visualization using geographical heat map wif bubble size to determine COVID-19 related claim KPIs based on countries, allowing business to understand which countries has more claims vs less claims due to COVID-19.
• Provided training to business users and educated support team on leveraging teh features of Power BI and OBIEE to efficiently perform their duties.
• Utilized a full range of Power BI features to design, develop, enhance and support visualizations including, but not limited to, highly interactive dashboards, scorecards and reports.
• Developed Power BI reports and visualizations using DAX functions like table function, aggregation function and iteration functions.
• Created Power BI scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Density Chart, Pie/Donut chart, Tree Map, Gantt charts.
• Involved in Trouble Shooting, Performance tuning of reports and resolving issues in Power BI Server and Reports.
• Developed large-scale analytical models via Power BI Datasets and Azure Analysis Services to serve as semantic layer for data visualization, report development, and ad hoc analysis.
• Worked wif Power BI administrator in managing Production, Test and Development environments.
• Created dashboard design wif TEMPeffective data visualization of large data volumes from various data sources (SQL server, oracle, spreadsheets etc.).
• Provided customer support to Power BI users and wrote custom SQL to support business requirements.
• Created Reports using transformations available in Power BI query editor.
• Scheduled automatic refresh in Power BI service.
• Created paginated report using Power BI Report Builder.

Environment: Power BI Desktop, Power BI Server, Power BI Report Builder, Azure Analysis Services, OBIEE, Tableau.

Confidential, Fairfax, Virginia

BI Architect

Responsibilities:

• Created dashboard in Power BI for visualizing teh operating status of teh Power Industrial Vehicle (PIV) drawing attention to non-performing/ underperforming PIV across a region.
• Leveraged many features of Power BI to create scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Density Chart, Pie/Donut chart, Tree Map, Gantt charts.
• Participated in and supported teh full project life cycle (initiation, planning, requirement analysis, design, development, Quality Assurance, User Acceptance Testing, Deployment and production support).
• Managed, analyzed and resolved data issues and managed revisions needed to best meet teh business requirements while adhering to teh best practices of business intelligence.
• Produced rich visualization, graphical display of data through Tableau desktop reports and dashboards.
• Built and published customized interactive Tableau reports and dashboards and scheduled on Tableau server.
• Driven reporting optimization through continued improvement in performance and visualization.
• Driven operational and process efficiencies through automation to minimize manual reporting.
• Collaborated wif subject matter experts and data stewards to define and implement data strategy to ensure teh enterprise data is accurate, complete, secure and reliable.
• Created mappings/sessions/tasks/workflows to integrate and load target tables in Oracle from multiple data servers (SQL Server) through Informatica PowerCenter.
• Identified areas for data quality improvement and helped to resolve data issues through appropriate choice of error detection and correction.
• Supported quality assurance and user acceptance testing of production defects and performed analysis to determine teh root cause of those defects and provided resolution.
• Created several technical documents including but not limited to Technical design document, Test specification, user guides/manuals.
• Responsible for teh code migration across Development, Test and Production servers.

Environment: Tableau desktop, Tableau Server, Informatica PowerCenter, Power BI, Oracle 12c.

Confidential, Vienna, Virginia

Senior BI Consultant

Responsibilities:

• Teh project had different data analytics use cases for healthcare payer which provided improvements in health system management.
• Provided insightful ideas for developing TEMPeffective and accurate codes - evaluated latest technologies and made recommendations to clients to integrate new designs.
• Created metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations and complex calculations in Tableau to meet teh business requirements.
• Acted as a Point of Contact in data & analytics, business intelligence and production support issue resolution.
• Was responsible for design, development, debugging code, monitoring data quality, troubleshooting issues and thus supporting BI solutions.
• Built and published customized interactive reports and dashboards and scheduled on Tableau server.
• Implemented advanced geographic mapping techniques and used custom images and geo coding to build spatial visualizations of non-geographic data.
• Resolved end user reporting problems through collaboration wif Support and Operations teams.

Environment: Tableau desktop, Tableau Server, SQL.

Confidential, Dallas, Texas

Senior BI Developer

Responsibilities:

• Developed mappings/sessions/workflows using Informatica Power Center for ETL.
• Performed data transformation using various Informatica Transformations like Filter, Expression, Lookup (Connected and Un-Connected), Aggregate, Update Strategy, Normalizer, Joiner, Router, Sorter and Union.
• Designed workflows wif many tasks like session task, decision task, assignment task, event wait task, command task and used Informatica scheduler to schedule jobs.
• Communicated wif business customers to discuss teh issues and requirements.
• Developed several reusable transformations and mapplets dat were used in other mappings.
• Created and maintained database objects like Tables, Views, Functions, Stored Procedures, Indexes in Oracle.
• Created Post UNIX scripts to perform basic file operations like zip, remove, archive and touch files.
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.

Environment: Informatica 9.5.1, Tableau desktop, Tableau server.

Confidential

Tableau Developer

Responsibilities:

• Analyzed teh existing systems and teh business user requirements for tactical and strategic needs.
• Provided multiple demonstrations of Tableau functionalities and efficient data visualizations approaches.
• Created rich dashboards using Tableau and prepared user stories to create compelling dashboards to deliver actionable insights.
• Generated KPI for customer satisfaction survey results and disease management.
• Collaborated wif end users and other related departments to ensure dat teh application is meeting teh client’s expectations and business requirements.
• Involved in data validation of teh results in Tableau by validating teh numbers against teh data in teh database tables by querying on teh database.
• Developed Tableau dashboards to help managers to identify critical KPIs and facilitate strategic planning in teh organization.
• Developed complex calculated fields for teh business logic, field actions, sets and parameters to include various filtering capabilities for teh dashboards, and to provide drill down features for teh detailed reports.

Environment: Tableau Desktop, Tableau Server, SQL Server.

Confidential, Parsippany-Troy Hills, New Jersey

Senior OBIEE Developer

Responsibilities:

• TEMPEffectively interacted wif teh end users for requirement gathering and created requirement specifications document.
• Identified and created Facts, Dimensions, and Hierarchies of teh business model.
• Helped establish OBIEE architecture and dashboard best practices for all BI reporting initiatives.
• Migrated BI Server repository from development to QA and production environments.
• Performed cache management and performance tuning.
• Administered BI Server repository security for data access.
• Developed RPD and reports and was also responsible for RPD and catalog merging.
• Worked wif cross-functional teams including users, developers and administrators to maintain flow of information and avoid critical issues.

Environment: OBIEE 11g, Oracle.

Confidential

Senior OBIEE Developer

Responsibilities:

• Installed and configured OBIEE tools.
• Provided support in OBIEE architecture of teh organization through database design, modeling and implementation.
• Anticipated teh end-to-end scope of analytical need of teh client and designed valuable BI and ETL solutions accordingly.
• Used teh best practices of business intelligence to design teh analytical solutions.
• Configured OBIEE iBots to deliver Analytics content based on schedule and automated iBot queries to obtain daily and weekly reports.
• Worked using Catalog Manager to migrate Web Catalog from one environment to another.
• Analyzed, designed and developed OBIEE Metadata repository RPD dat consists of Physical Layer, Business Mapping and Model Layer and Presentation Layer.
• Created Star Schema, Time Series Objects, Hierarchies, Level Based Measures and Security using External Table Authentication, Session Variables, and Initialization Blocks.
• Built reports including drilldown objects, union-based reports, formatting and functions wifin teh reports, dashboards, filters, and prompts.
• Developed and debugged many intelligence Dashboards containing Pivot Table, Pie/Bar Chart, and View/Column Selector, Narrative View wif drill-down capabilities.
• Extensively involved in performance tuning of OBIEE reports.

Environment: OBIEE 11g, Oracle.

Confidential

Senior OBIEE Developer

Responsibilities:

• Was responsible for implementing and building teh BI foundation and hence strengthening teh BI platform for teh client.
• Designed and developed OBIEE analytical solutions.
• Trained users and prepared user manuals explaining teh use of reports and dashboards.
• Exposure to working wif customers in Confidential at onsite location.
• Designed teh repository, created and developed reports, charts and dashboards.
• Created Users and User Groups and implemented data level and row level security to assign various privileges to view different dashboards.
• Developed and implemented strategies, policies and standards for BI solutions for teh enterprise data.
• Worked on data models - implement dimensional modelling.

Environment: OBIEE 11g, Oracle.

Confidential

OBIEE Developer

Responsibilities:

• Designed and developed dimensional data models (Star and Snowflake schema) in BI repository.
• Intensified customer satisfaction by providing them wif exciting analytics features like summary, detailed and drill-through reports wif pivoted, tabular and charted view, KPIs, Conditional Formatting, View Selector, Column Selector and dashboards wif user interactions like Action Links, Guided Navigations in web catalog.
• Attained quick turnaround time and thus reduced cost by providing timely fixes to bugs captured in production following teh norms of SDLC.
• Guided business users in navigating dashboards and reports during teh UAT phase by organizing user demonstrations.
• Performed root cause analysis of teh reported issues and incorporated teh required changes.
• Prepared Technical Design Documents (TDD) of teh complete implementation of teh Business Module and User Guides for teh use of Siebel Analytics.
• Implemented Comprehensive Security Model, by creating User Roles, Web Groups and setting up External Table Authentication.

Environment: OBIEE 10g, Oracle.