Home

Venkat - Sr Power BI Developer

[email protected]

Location: Princeton, New Jersey, USA

Relocation: New Jersey

Visa: GC

Venkat Chintalpati SUMMARY Over 18 years of demonstrated strengths and success in making software technology the key to organizational and business success bringing high impact innovation, strategic vision and business-to-technology, technology-to-business approach. Worked on the Power BI reports & dashboards on BIG Data Environment on premises and Cloud platform. Advanced Dashboards in Power BI for KPIs and Drill Through Reports. Working Knowledge on Tableau Visualizations. Hands-on experience with DAX functions filters, Parameters, Aggregate, Mathematical Functions, etc. Experience in writing Programs for implementing Stored Procedures for different tasks(Mid-Level). Worked with Development teams in relation to Reporting application tuning. Experience in MS Business Intelligence and Analytic tools like Power BI, SSIS. Working knowledge of ETL Processes. Working Knowledge of MS Fabric. Data mart databases, and process SSAS cubes to store data to OLAP databases. Design and develop tabular, Matrix, Drill down and Parameterized reports in SSRS using stored proc. Use of custom code, Expressions in SSRS. Enhance Complex Stored Procedures. Developed Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc Reports, and distributed Reports in multiple formats using SQL Server Reporting Services (SSRS). Report creation skills using Microsoft Reporting Services (SSRS) 2008R2/2012. Excellent communication, presentation, interpersonal skills, strong troubleshooting, and organizational skills. SKILLS SET TECHNICAL SKILLS BI Tools: SSRS, Power BI, Tableau, Cognos 11.x, Framework Manager, Cognos Workspace Advanced. Databases: Oracle 19C, Netezza, SQL Server, MS Access, Teradata, SQL Developer, TOAD. Cloud Platform: Snowflake, Microsoft Azure. Languages: SQL, PL/SQL Methodologies / Techniques: Agile, Service Now, JIRA. Operating Systems: Windows (All Versions), UNIX Database Supporting Tools: DBeaver, TOAD, Aginity Workbench, Putty. WORK EXPERIENCE Role: Worked on large scale, highly visible, strategic Business Intelligence projects in an extremely complex and evolved technical business environment on Clinical Trails Data like Xponent, Sales and Marketing, Supply Chain units. Worked on HRA(Human resource Administration), HRMS, HRIS including Benefits, Payroll, workers Compensation, Absence and Time Off, Time Tracking and Talent Management. Provided work direction to offshore team members to design, analyze, and document software applications across multiple project teams and applications. Analyzed, defined, and documented requirements for data, workflow, logical processes, hardware and operation system environments as well as interfaced with other systems, internal and external checks and controls, and outputs. Customized Power APPS for the Dashboard integration on Enterprise Portal. Converting reports or dashboards from Excel, Qlikview, Cognos, Tableau to Power Bi Gathered information about the datasources of each reports Identified relationships between the facts and dimensions tables Identified transformations done on those tables Gathered all the KPIs and insights shown on each of those reports Consolidated all these information and built Power BI datamodels (Cube) Developed Reports, Dashboards, Various Visualizations in Power BI from Scratch and customized existing visualizations. Automation of Power Reports by using Power Automation Met software design requirements to determine feasibility, cost, time, and compatibility with current solutions, architectural standards, and the legacy environment. Consulted with clients to prototype, refine, test, and debug programs to meet requirements. Highlights: Interact with Stake holders, Product owners and Sr. Executives. Understanding the capabilities of various BI Tools and Convert from BI Application to another. Extensive experience working on BI tools like Power BI, Tableau, Cognos. Tested the Report Performance, Security, Batch Process, Report schedules in Power BI, Tableau and Cognos BI environment. Mid-Level experience in Writing SQL (DDL, DML AND DCL), developing/creating new database objects such as Tables, Views using SQL server, Oracle. Essayed a key role in implementing several measures to ensure that applications were in line with requirements specified by clients. Worked on HR People Data, Ethics & Compliance, Sales Data on Regional and Global level, Clinical trials, Payroll, Social services, Finance, Telecom, etc. Played a key role in handling major escalations and resolved successfully. Educational Qualifications: Master s in business administration MBA (Graduated in 2000) / IME, Pune, India Bachelor s degree in commerce /Andhra University, AP, India Post Gradate Diploma in Computer Science/ DataPro, Pune, India Professional Experience: Client: CBRE, Texas Oct 2020 Till date Role: Sr. Power BI Developer ____________________________________________________________________________________________ Working on the Projects for Ethics & Compliance, People Soft(HRIS), Talent Coach, Tesla and Data Quality driven data globally supporting (NA, LATAM, APAC & EMEA) Regions. Data analytics from source applications like Talent Coach, NAVEX, Tesla and People soft data applications to deliver to meet the Organization goals and Employee contribution to the Organization ethically. Support HR & Compliance officer teams to automate the Reports from legacy systems by using Power BI Tools. Re-engineering the existing Tableau reports to design and automate reports, Dashboards, Visualizations onto Power BI Platform. Responsibilities: Involved in reviewing the HR systems, NAVEX and Training Data applications and interacting with business users to understand the user requirements. Convert Tableau reports/Dashboards to Power BI. Worked on Power BI Premium Capacity service account & provide BI best practices. Create POC on Power BI to connect to Snow flake database to consume data for Data analytics. Developed Reports & Dashboards like Executive Summary, Talent health Scorecard, People Case Management, Employee Performance management, Annual Turnover, Ethics & Compliance, Learning & Development, Data Quality, etc. Developed reports and Dashboards on HRIS data. Create key metrics, KPIs on Payroll, workers compensation and Medicare benefits data. Attend Daily Scrum and BI-Weekly Sprint planning and Retrospect meetings. Gathered user requirements, analyzed, and designed software solution. Extract data from OLAP systems and create Power BI Dataflow and Datasets. Transferred data from various OLTP data sources, such as SQL, Oracle, MS Excel, CSV files on to Data mart. Good understanding of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables. Worked on Custom Visualizations like (Bump Chart, Multi info cards, Smart filter, Rotating Tiles, Tornado, etc). Worked on MS Fabric to POC on integrating the web application onto client system. Create Pagination Reports on master-Detail Drill-through. Developed Complex Dashboards by using advanced features like Bookmarks and followed company branding standards for better user experience. Used different types of Data load methods like Import, Direct query & live connection. Created New Calculated Columns and Measures using DAX Expression. Optimized DAX Expressions and Dashboard Performance tuning for better user experience. Implemented RLS on Power BI Dashboards. Perform Administration activities like Creating Dataflow, Workspace, Deployment Pipeline, User Access with Premium capacity and interact with Microsoft Support team to troubleshoot Environments issues. Worked on setting up Parameters to all DEV, UAT & Production Environments in Power Query. Transformation of data in Power Query and Advanced Editor. Working Offshore, On-site Model. Managed offshore team by providing technical as well as nontechnical support and mentored junior team members. Involved in Power BI Service Admin activities like, setting up PBI workspace, RLS Roles, Parameters and Deployment Pipelines on PBI premium capacity Service. Connect Power BI Desktop to Azure Data bricks to Analyze data visualizations. Conducted weekly status review and daily sync up meetings. Trained end users to create and use Power BI applications. Environment/Tools: Power BI, Tableau, GitHub, Jira, SQL, Excel, Azure SQL, Oracle 19C, PeopleSoft, HRMS, Agile, Service Now, Snowflake, SharePoint, Power Apps, ADF, Power Automate, DAX Studio, Tabular Editor. Client: Department of Social Services (DSS/HRA) Brooklyn, NY Sep 16 Sep 20 Role: Sr. Power BI Developer ____________________________________________________________________________________________ Worked on the Projects for Work Tracking System Phase 3 on HRIS systems for Sales performance analysis by the field officers with in assigned boroughs for Commissioner Office, Paperless Office System (POS) team to automate the Reports on Budget allocation by using Power BI Tools. Re-engineering the existing Management Console reports (IBM Power Builder) and HRA systems to design and automate reports, Dashboards, Visualizations onto Power BI Platform. Responsibilities: Involved in reviewing the POS application and interacting with business users to understand the user requirements. Convert Cognos Analytics to Power BI. Gathered user requirements and analyzed and designed software solution and database. Extract data from OLTP and OLAP systems and Scheduled Jobs to call the packages and Stored Procedures. Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat files, CSV files into SQL Server 2012. Worked on the Power BI reports & dashboards with SQL Server/Tabular SSAS sources. Worked on Payroll and Medicare benefits for the field officers. Used Table, Matrix, Bar, Gauge, Slicer s visualizations. Worked on Custom Visualizations like multi slicer and Hierarchy slicer. Worked on DAX expressions like filters, Aggregate, Mathematical Functions etc. Created New Calculated Column and Measure using DAX Expression. Data exploration in Looker to built data sets for better visualization and decision-making. Responsible for implementation of creating SSIS packages using proper control and data flow elements with error handling. Design and development of SQL Server Integration Services (SSIS) packages and using various control flow task and data flow transformation. Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities. Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks. Designed and developed matrix and tabular reports with drill down, drill through and drop-down menu option using SSRS. Environment/Tools: Power BI, Cognos, MS SQL Server, Excel, GitHub, Jira, Snowflake, Oracle 19C, SQL Server 2019, EDW. Client: JP Morgan Chase New port, NJ Oct 15 Sep 16 Role: Sr. Power BI Report Developer Worked on the Projects for GCRM, CATTS & ELA team to automate the Reports using Power BI. Converting the Reports from QlikView onto Power BI. Roles & Responsibilities: Performed development activities from gathering requirements, designing solutions, through developing code / reports, to testing and release / deployment. Acting as an expert in Data Interoperability, Analytics and BI. Involved in creating dashboards by extracting data from different sources. Created Dashboards from Data Models to help managers to identify critical KPIs and facilitate strategic planning in the organization for better sales analysis. Designed and developed multiple chart types, Trends, custom requests for Worked with building Dashboards to Track sales data and works to meet quotas or sales team goals for Commissioner Office. Create Visualizations on Analyses trends, data, demographics, pricing strategies, and other information that can potentially improve marketing and sales performance. Worked on the Sale quota data to build advanced visualizations for better decision making. Environment/Tools: Power BI, Oracle 12g, SQL Server, Windows 2012, SQL Server, JIRA, EDW. Client: Johnson & Johnson - Raritan, NJ Sep 14 Sep 15 Role: Sr. Power BI Developer Worked on the Projects for LIMS & GLIMS Retirement for Various Sites in Malvern, Vacaville, Raritan and Brazil. Key Responsibilities are to convert the reports from Crystal Reports, onto Power BI Visualizations. We re supporting the Power BI Software Application by Developing Complex and simple reports, resolving the reports data and performance issue in Production, fixing the bugs on the application side by coordinating with the third-party vendors, Scheduling, monitoring and delivering the reports and jobs. As Admin work involved in Deployment, Setting up data sources user groups. Worked on enhancements and Tickets. Analyzing the data for Power BI Reports by using Crystal Reports Application. Roles & Responsibilities: Working knowledge on Prescription data like Xponent for better visualizations Worked on the Power BI data modeling, reports & dashboards. Administer user, user groups, and scheduled instances for reports in Power BI. Optimized DAX Expressions and Dashboard Performance tuning for better user experience. Implemented Row level security on Power BI Dashboards. Defined best practices for Power BI report development. Developed Dashboards on Clinical Trial data to bridge gap between marketing and Supply chain units. Developed KPI for better decision making. Participated in daily stand-ups with clients on daily design and development effort. Support Offshore team. Migrate Crystal reports to Power BI. Environment/Tools: Power BI, Oracle, Windows, Crystal Reports XI, Sample Manager, Oracle 11g, SQL Server, TOAD, EDW. Client: Avaya - Basking Ridge, NJ Apr 11 to Sep 14 Role: Power BI Roles & Responsibilities: Work directly with business customers to build Business Layer, Portals, reports, dashboards with the COGNOS BI authoring suite (Framework Manager, Report Studio and Transformer). Worked with Relational & Dimensional Database. Worked with the Distribution channel to Automating the Weekly and monthly partner credential status changes from Sales Force. Built Advanced Visualizations for Regional marketing and Sales Team. Interacted with Business Analysts and data modelers and defined Mapping documents and Design process for various Sources and Targets. Analyzing the data based on the requirements and implementing the BI best practices. Built Segmentation and DMR Model and published through Framework Manager for HR Team. Set up Data Level and Object Level Security in Framework Manager using macros. Responsible for implementing best practices on Cognos Dashboards, Scorecards, Portal, report design, development and testing. Writing & Modifying PL/SQL code for loading data and logical implementation for metadata model. Created a custom prompt page by enabling system driven cascade options, dynamic dimension selection and conditional display of prompts. Involved in Deploying reports, cubes and packages from Development to UAT to Production environment. Environment/Tools: Cognos 10.2,8.x, Components like DQM, Framework Manager, Report Studio, Query Studio, Analysis Studio, Teradata 13, Oracle 10g, TOAD, PL/SQL, Access Manager, Windows 2012, SQL Developer, Share point., BO, SAP EDW, SFDC, Informatica. Client: Verizon Wireless - Orangeburg, NY Jun 08 to Mar 11 Role: Sr. Power BI Report Developer This Project has been working on HRDW, Learning Modules, Payroll and Training Analytics & Data Certification to support Sales & Customer Service business groups in automating the simple & complex reports with Cognos Application. I am involved in gathering business requirements for developing Drill Down reports to fulfill the business needs on Talent Management for employee skill benefits. Roles & Responsibilities: Developed DMR Framework model to bring the HR Hierarchy. Analyze the existing Data sources to the Packages and document them. Functional Requirements Documentation and Test Cases. Gather and analyze the requirements of the users. Participated in design and code walk-through with project team. Retired all the Cognos packages, reports and cubes from Report Net to Version 8. Developed drill through reports based on Analysis studio reports. Maintain User sign on information and auto access privileges for data sources. Optimize the Cognos 8 reports performance. Create Analysis Reports thru metric studio for workers compensation and benefits. Create Standard Reports in Report Studio. Migrating reports through different environments. Face to Face and online User Training for Adhoc Users to develop their own Adhoc reports in Report Studio & Query Studio. Defined object level security & Data level security. Environment/Tools: Oracle Client 11g, Toad, Cognos Series 8.4, Transformer, Peoplesoft, HRMS, WINSCP, PUTTY, Teradata, UNIX, Windows, EDW. Client: Pfizer New York, NY Jan 07 to May 08 Role: Sr.BI Developer This Project has been developed to provide the users with the ability of creating their own ad-hoc reports by creating an enterprise framework model. This solution also aims in retiring all their current reporting applications and provides them with the newly developed reports in Cognos 8.3. Worked on Data analytics to develop advanced reports on Internal product analysis for better Sales Strategy. Roles & Responsibilities: Translates business needs into Report specifications. Functional Requirements Documentation and Test Cases. Gather and analyze the requirements of the users. Analysis of data necessary to resolve issues uncovered relating to source data. Participated in design and code walk-through with project team. Study the Current BI System Framework Packages, Cognos 8 reports. Proposed and Designed Dimensional Framework Model. Create Folders, Filters, Calculations, Prompts, User Groups and User Classes. Maintain User sign on information and auto access privileges for data sources. Optimize the Cognos 8 reports performance. Defined, stored and maintained security information using Access manager. Develop Dimensional Framework model in conjunction with the Database Architects. Analyze the existing Data sources to the Packages and document them. Create a DMR Business view out of the query subjects for Query Studio Users. Establish Join relationships between the Query Subjects. Create Standard Reports in Report Studio. Create Dashboard Reports for Sales Team. Publish Framework Packages to Dev. Configuring the Web servers and the App Servers Installing the Content Store Environment/Tools: Oracle Client 10g, Toad, Cognos Framework manager, Cognos Series 8.3, Metric Studio, Access Manager, Informatica CIGNITI - Irvine, TX Jan 06 to Jun 06 Programmer Analyst _______________________________________________________________________________________________ This Project (Scepter) has been developed to provide the users with the ability of creating their own ad-hoc reports by creating an enterprise framework model. This solution also aims in retiring all their current reporting applications and provides them with the newly developed reports in Cognos 8 Roles & Responsibilities: Impact and Risk Analysis during Upgradation to Cognos series 8 Training the users in creating ad-hoc reports after migrating from series 7 to 8. Translates business needs into Report specifications. Functional Requirements Documentation and Test Cases. Gather and analyze the requirements of the users. Participated in design and code walk-through with project team. Optimize the Report Net reports performance. Analyze the existing Data sources to the Packages and document them. Create a Business view out of the query subjects for Query Studio Users. Create Standard Reports in Report Studio. Creating User Classes in Access Manager and adding users to those user classes Environment/Tools: Oracle9i, Cognos Transformer, Cognos Powerplay, Cognos Framework manager, Cognos Series 8, Cognos Report Net .1.1 Access Manager, Informatica. HDFC Standard Life Insurance -Pune, India Aug 04 to Dec 05 System Analyst ___________________________________________________________________________________________________ This Project has been developed to provide the users with the ability of creating their own ad-hoc reports by creating an enterprise framework model. This solution also aims in retiring all their current reporting applications and provides them with the newly developed reports in report net. Also involved in creating new reports using Impromptu, Customized powercubes Roles & Responsibilities: Maintain User sign on information and auto access privileges for data sources. Optimize the Impromptu report performance. Defined, stored and maintained security information using Access manager. Troubleshoot and resolve functional issues to meet user requirements. Designing and developing approaches to acquire data from new sources. Build OLAP cubes using Cognos Transformer, views using Power Play. Create the Calculations, conditions and prompts in catalogs. Prepare Impact associated documentation and logic flow charts applied to business. Publish the Visualizations, Cubes and Reports to the PPES. Develop Framework models in conjunction with the Database Team. Environment/Tools: Oracle8i, Cognos Impromptu, Cognos Transformer, Cognos Powerplay, Cognos Impromptu Web Report Administrator, Cognos Visualizer Administrator, Cognos Deployment Manager, Cognos Framework manager, Cognos Report Net (Report Studio & Query Studio), Cognos Access Manager, Informatica. Keywords: access management business intelligence active directory microsoft procedural language New Jersey New York Texas