Summary
Overview
Work History
Education
Skills
Timeline
Generic

Pavana Yanamandala

Dallas,USA

Summary

Results-driven Power BI and Python Developer with extensive experience at Comerica Bank, adept at transforming complex data into actionable insights. Proficient in DAX and SQL, I excel in delivering impactful dashboards and reports, enhancing decision-making processes. A collaborative team player, I thrive in fast-paced environments, driving efficiency and innovation in data analytics.

Overview

22
22
years of professional experience

Work History

Power BI and Python Developer

Comerica Bank
Dallas, TX
09.2022 - Current
  • Gathered data from S3 Bucket into Snowflake with the help of IICS(ETL) and Later developed both Power BI reports, Adenza reports and Snowflake Dashboards for internal purpose and Snowpark Python based SPs for Internal scheduled monitoring for different metrics.
  • Designed, Developed & Deployed Standardized Approach of Counterparty Credit Risk (SA-CCR) reports based on user requirements.
  • Designed reports for both Standard and Advanced Risk Weighted Assets (RWA) for assigned Counterparty credit risk customers.
  • Designed day-over-day analytical analysis reports for Credit Valuation Adjustment reports which helped users for Potential Future Exposure (PFE) risk analysis.
  • Implemented 3 tier hierarchy in Power BI reports to standardize and stabilize reports.
  • Designed Day over Day, Multiple Days & Quarter over Quarter data analytical reports based on user requirements.
  • Created Snowflake stored procs and reporting tables to Denormalize data for generating ad hoc reports on-demand.
  • Developed various solution driven views and dashboards by developing different chart types including Pie Charts, Bar Charts, Tree Maps, Circle Views, Line Charts, Area Charts, Scatter Plots in Power BI.
  • Developed and published reports and dashboards using Power BI and written effective DAX formulas and expressions.
  • Utilized Power Query in Power BI to Pivot and Un-Pivot the data model and data cleansing and data massaging.
  • Worked with table and matrix visuals, worked with different level of filters like report level, visual level filters and page level filters.
  • Created several user roles and groups to the end-user and provided row level security.
  • Designed different types of KPIs for percentage growth in different fields and compared over the period of time and designed aggregations and pre calculations in Analytical services.
  • Troubleshoot and support reports in Power BI workspaces when ever there are issues in production.

Business Intelligence Lead Developer

Humana
Dallas, TX
03.2016 - 08.2022
  • Actively involved in requirement gathering sessions with business analysts, business stakeholders, Subject Matter Experts (SME), developers and sponsors. Involved in complete SDLC life cycle.
  • Design, develop and deploy business intelligence presentation layer solutions in the provider healthcare market focused on analytics and reporting components such as dashboards, scorecards, reports.
  • Held timely meetings with Solution Architect, Business Analysts, and Healthcare Subject Matter Experts to prototype, design and develop solutions to meet requirements.
  • Responsible for pulling complex data sets from disparate data sources to provide information to business stakeholders and serve as a trusted advisor to business stakeholders and helping them to understand key business drivers.
  • Involved in Completion of several Daily/Weekly/Monthly reports for multiple Operations managers with large quantity of data pulled from internal servers.
  • Build custom reports that will help Finance and Datacenter team with their daily task as well as provide business insight. This will include ad-hoc as well as scheduled reports.
  • To automate all the manual efforts the team is putting into the reporting visualization and build an organized Visualization structure which is not people dependent.
  • Implemented a Power BI solution to replace manual processes for increased efficiency, accuracy of information within six weeks of initial engagement with the team.
  • Created calculated columns and measures using DAX queries for ad hoc requests and reporting needs.

Power BI Developer

Cushman & Wakefield
NYC
09.2015 - 02.2016
  • Performed Power BI Desktop Data modeling, which cleans, transforms, mash-up Data from multiple resources.
  • Utilized Power Query in Power BI to Unpivot and Pivot the data model for data cleansing and data shaping.
  • Transform tables in every way by bringing them into the desired view (filter, sort, change the order of columns, transpose, etc.).
  • Implemented complemented DAX expressions, embedded queries, measures, and appropriate relationships to control the filtration of screens from user input as per the requirement.
  • Implemented Row-Level Security, restricted Sharing and Publishing, restricted export and Printing.
  • Created KPIs, Partitions, perspectives, and Calculated measures, used DAX queries, Roles.
  • Published Power BI Reports in the required origination and made Power BI Dashboards available in Web clients and mobile apps.
  • Responsible for Compliance and Auditing, Controlling Access to Power BI, Data privacy and Security.
  • Strong Experience with query editor features like merge & appends query, split column, conditional column, extract, pivot & un-pivot, add column, transpose, write M FORMULA using advanced query editor, delete column, remove null, errors, etc.

Qlikview Senior Developer

US Analytics Group (US Geo Market)
Irving, TX
03.2015 - 09.2015
  • Hands-on Experience creating ‘Extension Objects’ for QlikView Dashboards for Several Clients and created EsriMaps Connector.
  • Created QlikSense Dashboards as a Migration Project and Source change as well, including extension Object.
  • Hands-on experience in the design, development of end user applications for the data presentation and analytics, including scorecards, dashboards, reports, monitors, and graphic presentation (Information Visualization &Analysis) using QlikView 11 BI platform.
  • Worked extensively on data modeling and built QVDs as per business requirement. Optimizing applications by using QVD’s, removing synthetic keys and circular loop.
  • Created dashboard style of layouts using different sheet objects like List boxes, Multi boxes, slider, current selections box, buttons, charts, text objects, bookmarks, etc.
  • Customized and tweaked the scripts and necessary data transformation, created simple and complex expressions (using Set Analysis).
  • Developed QlikView applications based on Incrementally Load Transactions using QVD files.
  • Involved in daily standup with business analysts and data architect to resolve the business issues and Data challenges. Worked independently and capable of multitasking & prioritizing in a fast paced and agile work environment.

QlikView Developer

HYLA Mobile
Irving, TX
11.2013 - 02.2015
  • Gathering business requirements and created functional and technical specs and worked with business clients to confirm and clarify requirements and business logic.
  • Hands-on experience in the design, development of end user applications for the data presentation and analytics, including scorecards, dashboards, reports, monitors, and graphic presentation (Information Visualization &Analysis) using QlikView 11 BI platform.
  • Extracted information from different data sources like Teradata, SQL Server, MS Access and flat files, etc…by using different scripts like add, concatenate, resident, qualify, unqualify etc.…
  • Wrote SQL queries and created ad-hoc queries to perform data validation and analysis.
  • Designed reporting packages for report authors and ad-hoc packages to be used by end users in Query studio.
  • Worked extensively on data modeling and built QVDs as per business requirement. Optimizing applications by using QVD’s, removing synthetic keys and circular loop.
  • Created dashboard style of layouts using different sheet objects like List boxes, Multi boxes, slider, current selections box, buttons, charts, text objects, bookmarks, etc.
  • Customized and tweaked the scripts and necessary data transformation, created simple and complex expressions (using Set Analysis).
  • Developed QlikView applications based on Incrementally Load Transactions using QVD files.
  • Involved in daily standup with business analysts and data architect to resolve the business issues and Data challenges. Worked independently and capable of multitasking & prioritizing in a fast paced and agile work environment.

QlikView Developer

Plandata Gmbh
Vienna, Austria
03.2009 - 12.2012
  • Imported data from multiple data sources including Web files, MS SQL Server and MS Excel through OLEDB and ODBC connections and modeling data as per user requirements.
  • Participate in enterprise DW / BI strategy/Dashboarding.
  • Qlikview 9.0 implementation and integration.
  • Involved in utilizing Qlikview solutions to develop complex reports and executive dashboard.
  • Created Architectural Conceptual documentation and Technical Specification Documents.
  • Create and manage ETL script generation using QlikView Script.
  • Creating complex data models without synthetic tables and circular loops.
  • Developed Qlikview applications creating expressions using set analysis.
  • Created and scheduled Complex reports by leveraging the basic components of Qlikview.
  • Performed different tasks like repeat tasks, reload tasks and distribution tasks using the QlikView publisher.
  • Involved in organizing meetings to know the needs of clients for the Enterprise solution Implementation.
  • Involved in design and development of QlikView Platform integrated with Expandable Databases.

Oracle Developer

Sal Oppenheim jr & Cie
Frankfurt, Germany
01.2007 - 02.2009
  • Participating in the design and analysis phases.
  • Performing the impact analysis and provide inputs to Business manager.
  • Attending meetings with client/Business users to understand and collect the requirements to convert into business logic to develop the application.
  • Participating in unit testing and documentation of requirements.
  • Generating web-based user interfaces (Screens) and reports using Oracle Forms, Reports, Oracle Designer 9i and Oracle Web Tool kit.
  • Attending the weekly meetings and provide updates on the development to Project Manager and team.
  • Tuned SQL queries to improve the application and reports performance.
  • Modifying and writing Unix shell scripts to schedule batch jobs to run on everyday midnight to process large number of records on the database to change the client status based on certification dates.
  • Clearing the log files from the test environment UNIX box on periodical basis to allow space.
  • Working with DBA to identify and resolve the performance and user privilege related issues.
  • Participation on rollout of the new application versions (Both Client server and Web based) to all Business users.
  • Providing application support to end users.
  • Providing support to Business users and QA team for User Acceptance and Beta testing.
  • Participating in all phases of development life cycle.

Oracle Developer/ C++ Developer

Benchmark Capital Management GMBH
Vienna, Austria
10.2003 - 12.2006
  • Prepared the Database Design, Technical Design (Low level Design) of some modules based on the approved functional design document.
  • Enhanced the physical data model using Microsoft Visio.
  • Created database links to transfer data from one database to another.
  • Performed tuning and optimization on SQL queries.
  • Developed automated Korn shell scripts to schedule the loading of flat files.
  • Used composite partitioning schema (Range-Hash partitions) to partition very large transaction tables, range partitioning and hash sub-partitioning.
  • Developed SQL scripts using Sybase to perform data retrieval for a range of business criteria.
  • Produced scripts to cleanse source data, ETL process (Extract, Transform & Load) data with business rules, and built re-usable Mappings.
  • Devised the test strategies and prepared the unit test plans.
  • Used Remedy to log the design defects, bugs or review defects.

Education

Master of Business Administration -

Carlson School of management, University of Minnesota

Master of Science - Information Systems

Aberdeen University
United Kingdom

Bachelor of Technology -

REC
Warangal

Skills

  • Oracle 9i
  • Oracle 10g
  • MS SQL Server 2005
  • PostgreSQL
  • Python
  • C
  • Java
  • SQL
  • PL/SQL
  • Custom DAX queries
  • Custom M code
  • Custom Visuals with Power BI Premium
  • Windows XP
  • Windows 2000
  • Windows 2003 Server
  • HTML
  • XML
  • Java Script
  • VB Script
  • Microsoft Visio 2003
  • SQL Loader
  • Plus
  • Oracle Enterprise Manager
  • Oracle Designer 9i
  • TOAD
  • Autosys
  • Oracle Forms 10g
  • Oracle Reports 10g
  • Office 2003
  • Office 2007
  • Edit Plus
  • Apache Tomcat 50
  • Dreamweaver
  • Visual Basic 60
  • IICS
  • Data Flow
  • Talend
  • Control Flow
  • Transformations in SSIS
  • AWS
  • Azure
  • Snowflake

Timeline

Power BI and Python Developer

Comerica Bank
09.2022 - Current

Business Intelligence Lead Developer

Humana
03.2016 - 08.2022

Power BI Developer

Cushman & Wakefield
09.2015 - 02.2016

Qlikview Senior Developer

US Analytics Group (US Geo Market)
03.2015 - 09.2015

QlikView Developer

HYLA Mobile
11.2013 - 02.2015

QlikView Developer

Plandata Gmbh
03.2009 - 12.2012

Oracle Developer

Sal Oppenheim jr & Cie
01.2007 - 02.2009

Oracle Developer/ C++ Developer

Benchmark Capital Management GMBH
10.2003 - 12.2006

Master of Business Administration -

Carlson School of management, University of Minnesota

Master of Science - Information Systems

Aberdeen University

Bachelor of Technology -

REC

Similar Profiles

CREATE PROFILE
Pavana Yanamandala