Business Intelligence Power Bi

Kavya Pandra

Dallas, TX

Summary:

• * years of experience in Data warehousing and Business Intelligence technologies

• Over 5 years of working experience with Tableau Development. Experience with Tableau 2020.3, 10.X, 9 Versions of Tableau, and Tableau Desktop 2018, 10 and 9 versions.

• Experienced Power BI Developer with 4+ years of experience in gathering data from various sources and transforming it into insightful reports and dashboards.

• Experience in analysis, design, development, testing and implementation of Business Intelligence Applications using Qlikview and over 2+ years of experience as Qlik Sense Application Developer.

• Proficient in design and development of various dashboards and reports utilizing Tableau.

• Visualizations like bar graphs, scatter plots, pie-charts, donut chart, geographic visualization (Integrated Google maps in a dashboard) and other making use of actions, other local and global filters according to the end user requirement.

• Experience with blueprints and CAD drawings.

• Over 6 years of working experience with Cognos 11/10.2/10.1/8.x BI Suite (Framework Manager, Cognos connection, Report Studio, Metric Studio, Analysis Studio and Query Studio).

• Expertise in developing and testing Complex reports (List, Cross tab, Charts, Maps, Drill-through, Master-Detail, and Cascading) and Dashboards using Report studio.

• Expertise in gathering business requirements and creating models, reports and dashboards to meet the requirements.

• Handling complete range of BI capabilities: reporting, analysis, dashboards and business event management

• Experience and expertise in understanding existing business processes, data analysis requirements, business systems analysis and design, converting requirements specifications into functional specifications

• Extensive experience in Multiple Relational Databases including SQL Server, Oracle & DB2

• Experience with writing SQL queries, Oracle PL/SQL Stored Procedures, Functions, Cursors and Triggers

• Coordinated technical reviews, developed functional requirements. Developed test requirements, test plans, scripts, test conditions and test data. Supported status reporting and test execution for Unit testing, Integration testing, System testing, Regression testing, and user acceptance testing (UAT)

• Provide best practices for daily operations, performance analysis, tuning and capacity planning

• Have clear understanding of Business Intelligence and Data Warehousing concepts with emphasis on ETL and Life Cycle Development

• Involved in training end users and providing technical support and documentation. Ability to adapt and learn new technologies and to get proficient very quickly with them

Education:

Bachelor’s in computer science, Jawaharlal Nehru Technological University, India, 2008

Technical skills:

BI tools: Tableau Desktop 10.3,10.4,10.5,2018.1,2018.3,2020.4, Power BI, Cognos 11/10.2/10.1, 8.x (Report Studio, Framework Manager, Qlik View, Qlik Sense, QlikView Publisher, Analysis Studio, Query Studio, Business Insight), Alteryx 2021.2

ETL Tools: Informatica 8.X, Data stage 7.X, Ab Initio

Databases: Google Big Query, Microsoft SQL Server 2019, Teradata, DB2, Netezza, Data Lake, Oracle 9i/10g/11g/12c.

Languages: C, C++, Java, Cobol, VB.net

Scripting: VB Script, Java Script, HTML, CSS.

DB Tools: SQL *Plus, SQL *Loader, TOAD 8.3

Professional Experience:

Talent Systems, Dallas, TX Aug 2023 - Present

Senior BI Developer

• Worked with Business users to gather requirement specifications for new reports and legacy reports.

• Developing Tableau interactive dashboard using large volumes of data from various data sources (SQL server, oracle, spreadsheets Tera data, Snowflake)

• Developed and optimized Tableau Online Dashboards connected to Google BigQuery to provide actionable insights for stakeholders.

• Converted Tera data SQL to GCP code.

• Used Action filters (Filters, highlight, URL Actions) along with shapes as buttons to navigate between dashboards.

• Developed Table of Contents to navigate between dashboards

• Assisting users with questions and issues using Tableau. Working with various infrastructure teams and Tableau support team to help improve dashboard response time.

• Testing Tableau Dashboards using Kinesis.

• Hands on building Groups, Hierarchies, sets to create detail level summary reports and Dashboard using KPI’s and involved in creating a dual axis bar chart with multiple measures.

• Schedule Data refresh on Tableau Server for daily, weekly, and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.

• Distributed Tableau reports using Techniques like Packaged Workbooks, PDF to different user community.

• Published Tableau Workbooks in Tableau Dev, UAT and Prod Servers.

• Worked closely with ETL/DBA teams to troubleshoot data issues and enhance database performance.

• Worked in Agile methodology environments and involved in scrum meetings.

Environment: Tableau Online, Tableau Desktop 2021.4, Tableau Server, Power BI, QlikView, QlikSense, QlikView Publisher, SQL Server 2014/2017, Micro strategy Desktop 10.11, Share point, Cognos Analytics, Cognos 10.2.2.

Charles Schwab, West Lake, TX Mar 2022 – Aug 2023

Senior Business Intelligence Developer

• Working with Business analysts to understand the requirements and its dependencies on various teams working on the project and monitoring the existing reporting system and develop the most efficient system upon conducting technical analysis for senior executives.

• Developing Tableau interactive dashboard using large volumes of data from various data sources (SQL server, oracle, spreadsheets Tera data, Snowflake)

• Migrated Tableau dashboards that use Tera data and Snowflake as data source to Google Cloud Platform data source.

• Analyze existing Tera data SQL code for better performance.

• Converted Tera data SQL to GCP code.

• Writing and testing of SQL code in Google cloud Platform and Tera data.

• Optimizing exiting queries for better performance.

• Testing Tableau Dashboards using Kinesis.

• Utilized Tableau Server to publish and share the reports with the business users and created story using tableau dashboards for presentations.

• Performed Admin duties such as providing access to the users and adding them to the specific group.

• Distributed Tableau reports using Techniques like Packaged Workbooks, PDF to different user community.

• Assisting users with questions and issues using Tableau. Working with various infrastructure teams and Tableau support team to help improve dashboard response time.

• Worked in Agile methodology environments and involved in scrum meetings.

• Wrote requirements for the project, designed and developed prototype of the dashboard.

• Published Tableau Workbooks in Tableau Dev, UAT and Prod Servers.

Bank of America, Richardson, TX Apr 2021 – Mar 2022

Senior BI Developer

Responsibilities:

• Worked with Business users to gather requirement specifications for new reports and legacy reports.

• Migrated Tableau Workbooks from Tera data to Google Cloud Platform.

• Testing Tableau Dashboards using Kinesis.

• Designed and developed Qlik View and Qlik Sense dashboards by extracting data from different sources like sales force, Sql Server, Oracle, SAP, Flat flies, Excel Files and XML files.

• Provided continued maintainence and development of bug fixes for existing and new Power BI reports twice a month for 2 years.

• Wrote requirements for the project, designed and developed prototype of the dashboard.

• Converted existing BO and SSRS reports to Tableau dashboards.

• Worked with various data sources and developed Tableau Dashboards.

• Published Tableau Workbooks in Tableau Dev, UAT and Prod Servers.

• Utilized Tableau Server to publish and share the reports with the business users and created story using tableau dashboards for presentations.

• Performed Admin duties such as providing access to the users and adding them to the specific group.

• Schedule Data refresh on Tableau Server for daily, weekly, and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.

• Distributed Tableau reports using Techniques like Packaged Workbooks, PDF to different user community.

• Assisting users with questions and issues using Tableau. Working with various infrastructure teams and Tableau support team to help improve dashboard response time.

• Worked in Agile methodology environments and involved in scrum meetings.

Environment: Tableau Desktop 2020.4, Tableau Server, Power BI, QlikView, QlikSense, QlikView Publisher, SQL Server 2014/2017, Micro strategy Desktop 10.11, Share point, Cognos Analytics, Cognos 10.2.2.

Wells Fargo, Charlotte, NC Apr 2020 – Apr 2021

Senior BI Developer

Responsibilities:

• Market Share Analysis Dashboards, ETS Dashboards, Open Season Dashboards, PMF Dashboards.

• Working with Business Users/Business Analysts to understand the requirements and its dependencies on various teams working on the project and monitoring the existing reporting system and develop the most efficient system upon conducting technical analysis for senior executives.

• Converting existing BO and SSRS reports to Tableau dashboards.

• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Dropdown menu option and Parameters using Tableau.

• Developed highly interactive Data Visualization TABLEAU reports for E-SDLC Governance team using multiple data sources and custom SQL queries.

• Created different KPI using calculated key figures and parameters.

• Hands on building Groups, Hierarchies, sets to create detail level summary reports and Dashboard using KPI’s and involved in creating a dual axis bar chart with multiple measures.

• Provided Production support to Tableau users and wrote Custom SQL and stored procedures to support business requirements.

• Worked closely with ETL/DBA teams to troubleshoot data issues and enhance database performance.

• Utilized Tableau Server to publish and share the reports with the business users and created story using tableau dashboards for presentations.

• Involved in administration tasks such as Setting Permissions, managing ownerships and providing access to the users and adding them to the specific group.

• Schedule Data refresh on Tableau Server for daily, weekly, and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.

• Distributed Tableau reports using Techniques like Packaged Workbooks, PDF to different user community.

• Assisting users with questions and issues using Tableau. Working with various infrastructure teams and Tableau support team to help improve dashboard response time.

Environment: Tableau Desktop 2018.3, Tableau Server, SQL Server 2014/2017, Micro strategy Desktop 10.11, Share point, Cognos 10.2.2

Southwest Airlines, Dallas, TX Sep 2019 – Apr 2020

Senior BI Developer

Responsibilities:

• Worked with Business users to gather requirement specifications for new reports and existing reports

• Communicating with the users about their requirements, converting the requirements into functional specifications and developing advanced reports using IBM Cognos technology

• Responsibilities include developing the metadata model, coordinating with SQL developers and retrieving the necessary data and develop the reports accordingly.

• Educated the business users on the technology and application.

• Working with database team to gather data required for the business reports.

• Developing reporting metadata model using IBM Cognos Framework Manager tool.

• Using several reporting tools available in the IBM Cognos Environment to develop advanced reports for the business.

• The tools include Report studio, Query Studio, Event Studio, Cognos Workspace Advanced etc.

• Performed several Cognos administrator duties to publish packages and reports in our environments.

• Monitor and maintain all our Cognos reporting environments.

• Working with Our Cognos team to upgrade Cognos 10.2.2 environment to Cognos 11 version.

• Developed dashboard reports to display all the information related to environment using Summary reports.

• Created Master Detail reports, drill through and custom prompting reports, and Scheduled reports for efficient resource utilization.

• Created optional filters/prompts in report studio using Java Script and HTML.

• Taking care of the enhancement issues and fixing them according to the priority.

• Worked with various versions in Tableau, Tableau Server, Tableau Public, Tableau Reader and Tableau Online. Developed Tableau visualizations and dashboards using Tableau Desktop.

Environment: Tableau Desktop 2018.3, Tableau Server, SQL Server 2014/2017, MicroStrategy Desktop 10.11, MicroStrategy Intelligence Server, Cognos Analytics, Cognos 10.2.2, SharePoint.

Wells Fargo, Charlotte, NC Apr 2019 – Sep 2019

Senior BI Developer

Responsibilities:

• End to end development and implementation of the project.

• Wrote requirements for the project, designed and developed prototype of the dashboard. Used Dashboard inside Tableau Dashboard. Used Action filters (Filters, highlight, URL Actions) along with shapes as buttons to navigate between dashboards.

Developed Table of Contents to navigate between dashboards

• Designed Drill up and Drill down, Detail and Summary reports

• Wrote custom SQL queries to validate the reports.

• Preparation of Unit test plans & Unit test results for the reports.

• Published reports on to tableau server, created users, groups and projects on tableau server.

• Scheduled weekly subscription of report when data changes.

• Designed automated report sent to resource manager on weekly basic. Migrated Cognos existing dashboards to Tableau Environment.

• Developed QlikView and Qlik Sense objects like Multi boxes, Straight tables, Containers, Line charts, Scatter charts, Line objects, Pie charts, Buttons.

• Performing unit testing on QlikView 11 application development.

• Worked in Agile methodology environments and involved in scrum meetings.

Environment: Tableau Desktop 2018, Alteryx 2019.4, IBM DB2, Data Lake, QlikView, Qlik Sense, Cognos Analytics, Cognos 10.2.2

TIAA, Charlotte, NC Apr 2017 – Apr 2019

Senior BI Tableau/Cognos Developer

Responsibilities:

• Worked with Business users to gather requirement specifications for new reports and existing reports.

• Communicating with the users about their requirements, converting the requirements into functional specifications and developing advanced reports using IBM Cognos technology

• Responsibilities include developing the metadata model, coordinating with SQL developers and retrieving the necessary data and develop the reports accordingly.

• Educated the business users on the technology and application.

• Working with database team to gather data required for the business reports.

• Developing reporting metadata model using IBM Cognos Framework Manager tool.

• Using several reporting tools available in the IBM Cognos Environment to develop advanced reports for the business.

• The tools include Report studio, Query Studio, Event studio, Cognos Workspace Advanced etc.

• Performed several Cognos administrator duties to publish packages and reports in our environments.

• Monitor and maintain all our Cognos reporting environments.

• Working with Our Cognos team to upgrade Cognos 10.2.2 environment to Cognos 11 version.

• Developed Dashboard reports to display all the information related to environment using Summary reports.

• Created Master Detail reports, drill through and custom prompting reports, and Scheduled reports for efficient resource utilization.

• Created optional filters/prompts in report studio using Java Script and HTML.

• Taking care of the enhancement issues and fixing them according to the priority.

• Worked with various versions in Tableau, Tableau Server, Tableau Public, Tableau Reader and Tableau Online

• Developed Tableau visualizations and dashboards using Tableau Desktop.

• Developed Tableau workbooks from multiple data sources using Data Blending.

• Expert level capability in Tableau calculations and applying complex, compound calculations to large, complex data sets

• Created custom Function's Date range, Time functions, array functions, and Conditional formatting functions in the reports.

• Scheduled extract refresh for weekly and monthly reports.

• Worked on workbook Permissions, Ownerships and User filters.

Environment: Cognos 11/10.2.2 (Framework Manager, Transformer, Report Studio, Query Studio, Cognos

Workspace Advanced), Tableau, Power BI, Oracle 12c, Cognos SDK, WAS, SQL Server 2008, TOAD, PL/SQL, Java

Script.

Dovel Technologies, Rockville, MD Jan 2015 – Mar 2017

Senior Cognos Developer

Responsibilities:

• End to end development and implementation of the report migration project.

• Wrote requirements for the project, designed and developed prototype of the dashboard.

• Designed Drill up and Drill down, Detail and Summary reports

• Wrote custom SQL queries to validate the reports.

• Preparation of Unit test plans & Unit test results for the reports.

• Published reports on to tableau server, created users, groups and projects on tableau server.

• In depth interaction with Client Architects, Project Manager, Subject Matter Experts, and Developers for solution implementation.

• Responsible for converting functional requirements into technical specifications.

• Responsible for the architectural design and detailed design of reporting and obtaining sign off from the business.

• Discussed with clients about their present reporting system and understand their current reporting issues to meet their needs.

• Involved in Designing models with Relational Data using Framework Manager and published packages to the Cognos Reporting Servers.

• Responsible in creating reports using Active Reports in Cognos 10.2.2, using Report Studio.

• Implemented data level, object level and package level security in framework manager to achieve highly complex security standards.

• Created Database Layer, Intermediate layer and Presentation Layer, defining appropriate relationship between query subjects and Fact Table in Framework Manager.

• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts in Report Studio.

• Worked with performance tuning of the Cognos reports.

• Trained the end users to effectively use the reporting tool to build and customize their ad-hoc reports

• Coordinated with functional users for User Acceptance Testing prior to releasing system changes in production

• Deploying models and reports from Development to Production and administering users/groups/roles.

• Assisted Quality Assurance Team in documenting and analyzing their current process and then make recommendations for improvements in their functional areas

• Created documentation for the complete project life cycle and mentored the End Users and Provided the Technical Support.

• Worked in Data Stage tool and created summary tables for reporting purposes. These summary tables are then used in Cognos to create summary level reports.

Environment: Tableau Desktop 9, Cognos 11/10.2.2 (Framework Manager, Transformer, Report Studio, Query Studio), Power BI, Oracle 11g, Cognos SDK, WAS, SQL Server 2008, TOAD, PL/SQL, Java Script, Netezza, Data Stage

SAHMSA, Rockville, MD Jun 2012 – Dec 2014

BI Developer

Responsibilities:

• Developed BI analytics strategy for Cognos suite of products for SAMSHA (Substance Abuse and Mental Health Services Administration). The project also involved migrating reports from Cognos to Tableau.

• Wrote custom SQL queries to validate the reports.

• Preparation of Unit test plans & Unit test results for the reports.

• Published reports on to tableau server, created users, groups and projects on tableau server.

• In depth interaction with Client Architects, Project Manager, Subject Matter Experts, and Developers for solution implementation.

• Developed Tableau visualizations and dashboards using Tableau Desktop.

• Developed Tableau workbooks from multiple data sources using Data Blending.

• Expert level capability in Tableau calculations and applying complex, compound calculations to large, complex data sets

Environment: Tableau Desktop 9, Cognos 11/10.2.2 (Framework Manager, Transformer, Report Studio, Query Studio), Power BI, Oracle 11g, Cognos SDK, WAS, SQL Server 2008, TOAD, PL/SQL, Java Script, Netezza, Data Stage

B.V.N Technologies, Pune, India Jan 2010 – May 2012

Cognos Consultant

Responsibilities:

• Worked with business users, functional lead to understand and document the Business requirements.

• Installed and Configured Cognos 8.4 BI in single server Environment.

• Designed Functional Requirement Specifications for report development, modified relationships between different database tables and building models using Framework Manager.

• Developed functional and technical specs based on requirements.

• Worked jointly with the data management team members to understand data domains, values, cardinalities and other dimensions of data needed to support BI solutions.

• Created Metadata Modeling by using multiple databases in Cognos Framework Manager.

• Created and Published packages from Cognos Framework Manager.

• Created Complex Reports in Report Studio.

• Created Powerplay Reports by using Analysis Studio.

• Developed multiple page reports with page-breaks based on the first page of the report using Master-detail relationship.

• Scheduled the reports and bursted reports according to user requirements in Cognos.

• Deployed Packages and Reports from DEV Environment to UAT and PROD Environments.

• Imported metadata from various sources such as Relational Databases, Report Net models, Impromptu Catalogs into the Framework Manager.

• Did Unit Testing for all reports and packages.

• Creating report views with saved prompts and schedule according to the business requirement.

• Created Jobs to Schedule multiple reports in Cognos Connection.

• Personalized Cognos Connection, Specified display options, regional options and personal information.

Environment: Cognos 8.4, Transformer 8.4, Report Studio, Query Studio, Metric Studio, Oracle 10g, Sybase IQ 12, Erwin 4.0, TOAD, PL/SQL, SDK, Informatica 8, UNIX (Sun Solaris).

Contact this candidate