Home

Venkat - Power BI Developer / Engineer

[email protected]

Location: San Francisco, California, USA

Relocation: Anywhere in USA

Visa: H1B

Praneeth Varma Email: [email protected] Phone: 551-228-0376 Summary: I'm a passionate problem solver with over 9+ years of experience as a Data/ BI Engineer/Analyst working with companies like Amazon, Google, Microsoft, First Republic Bank and IBM. Experience working in diverse domains (E-commerce, Banking, Health Care and Services). I want to leverage my acquired skills in Data Analytics, Data engineering and BI to identify opportunities and gain creative insights from large complex data. Extensive knowledge and experience in dealing with Relational Database Management Systems including Normalization, Stored Procedures, Constraints, Querying, Views, Joins, Keys, Indexes, Data Import/Export, Triggers, Cursors. Experience in integration of various data sources like SQL Server, Oracle, DB2, Salesforce and other cloud platforms. Thorough knowledge of addressing Performance Issues and involved in query tuning, Index tuning, Data Profiling, and other database related activities. Strong knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modelling, and reporting tools. Analyze, design, and provide technical solutions in a consultative capacity for business scenarios with strong understanding in Software Development Life cycle. Created new ETL packages to validate, extract, transform and load data into data warehouse. databases, data mart databases using SSIS packages. Well versed with Data Mapping Skills, Data Migration Techniques, Scheduling and Maintaining ETL Framework. Expertise in implementation and maintenance of Business Intelligence tools for analysts and executive dashboards using PowerBI , Tableau. Have expertise in automating deployments in Azure and troubleshooting mechanisms for quick service. Expert in calculating measures and dimension members using multi-dimensional expression (MDX), mathematical formulas and user-defined functions. Have experience in working in a dynamic team setting while holding excellence in leadership skills. well versed in Agile development/SCRUM methodologies. Professional Experience: Amazon, Palo Alto, CA Aug 2022 to Present Business Intelligence Developer/ Engineer Responsibilities: Collaborated with cross-functional teams, including product managers and data scientists, to identify key business metrics and develop KPI dashboards using Tableau. Implemented automated data quality checks and monitoring tools to proactively identify and resolve data quality issues. Developed and implemented several ETL pipelines to derive various search segmentations and revenue data resulting in identification of key uptrends and downtrends in various product categories and regions. Data Analysis and Visualization of key performance metrics using Quick sight and Tableau with curated dashboard. which help track key metrics in Merchant Search across regions and product categories. Worked closely with stakeholders to understand their reporting needs and created customized reports and ad- hoc analyses to support data-driven decision-making at various organizational levels. Conducted in-depth data analysis to uncover customer behaviour patterns and insights, resulting in a 10% increase in merchant engagements. Involved in created stored procedures, views, and custom SQL queries to import data from SQL server to Tableau. Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps. Tested reports and uploaded Tableau dashboards onto the server and provided production support for Tableau users. Ability to work quickly and under tight delivery deadlines with focus on details. Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards. Created Data Integrator mappings to load the data warehouse, the mappings involved extensive use of simple and complex transformations like Key Generator, SQL Query Transform, Table Comparison, Case, Validation, Merge, lookup etc. in Data flows. Work with business owners to identify information needs and develop reporting; primary partners include the management team, finance & accounting, marketing, online retail, merchandising and operations. Environment: Tableau, Quick sight, SQL, AWS suite, ETL Pipelines, Python, Excel, Statistics, DBs First Republic Bank, San Francisco, CA Dec 2021 to Aug 2022 Sr. BI Analyst - Enterprise Data & Client Insights Team Responsibilities: Create Metadata and rule queries for Variance Reporting to identify the discrepancies between MDM and the downstream applications such as Salesforce, PWM, KYC and Lending. Design data architecture and drive database management strategies for complex customer data, feeding crucial reporting and analytics reports with high data quality and low downtimes. Designed and developed complex ETL packages using SSIS to extract, transform, and load data from various data sources into SQL Server databases and data warehouses. Designed and developed SQL Server databases for various applications, ensuring efficient data storage and retrieval. Created and optimized T-SQL queries, stored procedures, views, and functions to support data manipulation and reporting requirements. Implemented complex data transformations and business logic within ADF pipelines to support various data integration scenarios. Utilized Azure Databricks notebooks for data exploration, data wrangling, and data pre-processing tasks. Integrated Azure Databricks with Azure Machine Learning for seamless model training and deployment. Collaborated with business analysts and data stakeholders to gather data integration requirements and translate them into technical specifications. Conducted data profiling and data validation to ensure data quality and accuracy during ETL processes. Implemented data transformations, business rules, and data cleansing operations within SSIS packages. Strategize & defined enterprise data guidelines, data quality requirements, performance and KPI's for data products, that help build customer centric tools (Customer360 &Prospect360) Environment: SQL Server, SQL, Snowflake, Customer360, MDM - Salesforce integration, CRM, Regression Testing Microsoft, Seattle, WA Sep 2020 to Oct 2021 Sr Analyst - Sr. BI Developer Responsibilities: Design data architecture and drive database management strategies for complex customer data, feeding crucial reporting and analytics reports with Power BI with high data quality and low downtimes. Developed and implemented data quality frameworks to assess and improve data accuracy, consistency, and completeness. Implemented ETL processes to ingest and transform large volumes of data from diverse sources into Azure Synapse Analytics and Databricks. Write complex, time-sensitive and performance efficient stored procedures to support customer managers. Experience working in a fast paced and cross functional environment with quick turn-around time. Develop reporting dashboards using Power BI for Microsoft Leadership as part of the Customer Service Manager Program. Helped identify customer revenue potential and operational decision making to drive business. Written optimized queries in SQL, Kusto and DAX and created data pipelines to design customer crucial monitoring dashboards. Designing CI/CD pipelines for a central datahub for Microsoft's Business Application data warehouse and ADL Involved in SSIS Package creation from package design documents to package build. Involved in Unit testing of the SSIS extract packages and also building validation packages to check the accuracy of the migrated data. Built table relationships and wrote stored procedures to clean the existing data. Coordinated with front end developers to put in the business rules. Wrote a stored procedure to check some of the rules at the backend at the time of entering data. Developed SQL Scripts to Insert/Update and Delete data in MS SQL database tables. Developed the project using an iterative approach. Created new SSIS packages according to business rules. Created various ad-hoc SQL queries for customer reports, executive management reports and types of report types like tables, matrix, sub reports etc. Environment: SQL Server, Power BI, Azure DevOps, Linux, SSIS, Azure Data Factory, Azure Functions C#, Data studio, Databricks , Synapse, Flow/Logic and DAX, SCRUM Google Shopping, Mountain View, CA March 2018 to Apr 2020 Data Analyst Responsibilities: Built databases to efficiently store and report key abuse related features across Google Shopping. Application developed to detect abusive orders with a recall of 60% using Python, SQL and App script. Enabled real-time abuse monitoring using tableau dashboards. Developed an auto alerting solution for Payment Abusers with customizable thresholds. This helped drive reduction in transactional losses by 50% Created framework, designed custom SQL queries and databases for investigating 50K+ orders. Took initiative, built consensus and led a team of 4 analysts to create a structured process for order investigations. Led the analysis, design and implementation of projects/solutions that drove improvements in crucial business metrics (Order Defect Rate, Delivery Defects) closely linked with end customer satisfaction. Conducted data profiling and analysis to assess data quality issues and identify improvement opportunities in Order placement Environment: R Scripting, MySQL, Google SQL, Python, JavaScript, Tableau, Google dashboarding, SPARK Arizona State University, Tempe, AZ Dec 2016 to Jan 2018 Sr. Research Associate Responsibilities: Led a collaborative effort between Mayo clinic and ASU focused on early prediction of de-compensated heart failure (DHF) in patients by using sensory data to run Clustering/Predictive models on patient's sensory data. Transformed analytical findings into detailed reports, including future road maps. Managed a team of student researchers to effectively formulate and assign deliverables. Environment: AWS, R scripting, Tableau, Hadoop IBM, Hyderabad, India Aug 2013 to Jun 2016 Systems Engineer/Analyst Responsibilities: Product ownership of Bank's critical batch payment platform. Drove several projects to improve platform load handling capability and reduce product vulnerabilities. System outages cut down by 80% within a year. Enhanced the operational workflows via process improvements and built data warehousing capabilities to drive report automation, improving turn-around time by 50% Collaborated with bank's BPAY, Development, Front End and Product design to derive important customer metrics (Retention Rate) to bolster data- driven decision making. Advanced SQL scripting to store and retrieve user sensitive data and complete several ad-hoc data requests in a time sensitive environment. Environment: MySQL, Splunk, Core Java, Microsoft Suite, SSRS Education: Master s in business Analytics at W.P Carey School of Business, Tempe, USA August Keywords: csharp continuous integration continuous deployment business intelligence active directory rlang microsoft Arizona California Delaware Washington