Home

Harika - Data Analyst

[email protected]

Location: Chicago, Illinois, USA

Relocation: Open

Visa: Green Card

Harikareddy Kommula Email: [email protected] Mobile: +1 (234)-219-2017 Senior Data Analyst Summary of Experience: Accomplished professional with 10+ Years experience in Reporting, Analysis, Testing, Implementation, and Data Maintenance, enhancing strategic data utilization and organizational performance. Experience in working with different reporting tools (Cognos, Tableau, Business Objects, MicroStrategy). Expertise in writing SQL queries using Oracle and SQL server and managing, validating data into Data warehouse. Experienced in integrating Python with other tools and platforms, such as Snowflake, Power BI to enable end-to-end data processing and analysis. Experienced in tuning SQL Queries for Data Analysis & Profiling and wrote complex SQL queries using joins, sub queries and correlated sub queries. Gained expertise in Data Visualization using matplotlib, Bokeh and Plotly. Hands-on experience in visualizing data using Power BI, Tableau, R (gg plot), Python (Pandas, Matplotlib, NumPy, SciPy). Employed various Tableau functionalities like Tableau Extracts, Parameters, Filters, Contexts, Data Source Filters, Actions, Functions, Trends, Sets, Groups, Calculations and Maps etc. Proficient in understanding business processes/requirements and translating them into technical requirements. Proposed solutions to reporting needs and develop prototypes using SQL and Business Objects that address these needs. Involved in creating and designing reports framework with dimensional data models for the data warehouse and worked with the development team on SQL Server tools like Integrations Services and Analysis Services. Experienced in connecting Power BI to various data sources, including Snowflake, and transforming data to meet business requirements. Hands-on experience on Visualizing the data using Power BI, Tableau, R(gg plot), Python (Pandas, matplotlib, NumPy, SciPy). Strong domain Knowledge in financial sector such has payroll and mortgage. Hands on Experience doing data analytics in Python and proficiency in using libraries like Pandas, Numpy, Matplotlib. Experience with complex SQL queries for data profiling for Data ETL Integration tool. Good Knowledge in machine learning concepts like clustering, decision trees, Linear regression, predictive analytics and time series forecasting. Working knowledge of Extracting, Transforming, and Loading data from Excel, Flat file, various other data sources to MS SQL Server by developing SSIS (SQL Server Integration Services) packages. Create customized SQL Queries using MySQL Management Studio to pull specified data for analysis and report building in conjunction with Crystal Reports. Convert Access databases to SQL design tables, import data, and develop constraints and indexes ensuring data integrity. Hands on Tableau desktop and Tableau server experience by creating visualization dashboards using bars, lines, maps, scatter plots, heatmaps and highlight tables. Excellency in MS Excel with proficiency in lookups, Pivot Tables and understanding of VBA Macros. Strong analytical, problem solving and troubleshooting skills. Technical Skills Reporting Tools Power BI, Tableau, Cognos Database Management Oracle, Microsoft SQL Server, MySQL, DB2, Access, Azure, Data Warehousing, Flat Files Languages/Development Tools SQL, Python, R, PL/SQL, T-SQL IDE Platforms TOAD, Jupyter Machine Learning Classification, Regression, Clustering, Predictive Analysis, Text Analytics Other Tools and Methodologies JIRA, Photoshop, Microsoft Office suite (Word, Excel, PowerPoint), XML, OLTP, ODS, OLAP, ETL, SSIS, SSRS, SSAS, Rational Rose, UML, Microsoft Visio, ADP Data Visualization Tools Matplotlib, Seaborn, Plotly. Additional Tools Microsoft Excel Pivot Sheets Professional Experience Wells Fargo, Santa Clara, CA Jan 2022 - Presmt Senior Data Analyst Responsibilities: Extensive experience in Text Analytics, generating data visualizations using R, Python and creating dashboards using tools like Tableau. Optimization of data sources for route distribution analytics dashboard in Tableau reducing report runtime. Utilized Tableau server to publish and share the reports with the business users. Created Power BI reports using normalized and de-normalized data, created calculate measures and calculated columns. Designed rich data visualizations to model data into human-readable form with Tableau and Matplotlib. Developed and reviewed simultaneous SQL queries in Toad to validate data for data validation. Extensively used Excel such as vlookups, pivot tables and uploading the reports in data warehouse. Analyzing data to provide recommendations and improvements to technical and non-technical teams. Designed and developed various analytical reports from multiple data sources by blending data in a single worksheet in Tableau Desktop and created Tree Map, Heat maps, and background maps. Created different visualizations in the reports using Custom visuals, Bar Charts, Pie Charts, Line Charts, Cards, Slicers, etc. Also, using different transformation inside edit query into clean-up the data using Power BI. Performed Data Analysis and Data profiling using complex SQL on various sources systems including MySQL. Designed and built dashboards for use in monitoring performance metrics while maintaining existing dashboards incorporating changes as per business needs using Tableau. Used advanced chart visualizations in Tableau such as dual axis, box plots, bullet graphs, treemaps, bubble charts, and waterfall charts to solve complex problems and to create interactive dashboards and visualizations. Created interactive dashboards and visualizations of claims reports, competitor analysis, and improved statistical data using Tableau. Analyzing and understanding trends for the business to improve sales. Building dashboards from raw data by pulling reports through SQL queries. Extracting the data from different resources and updating the data warehouse. Involved in developing live, interactive data visualizations, dashboards using Tableau Desktop. Created Rich dashboards using Microsoft Power BI and prepared user stories to create compelling dashboards to deliver actionable insights. Responsible for creating data reports, validation data using Data quality checks to Profile the data then load into a new database for creating data visualizations with Power BI. Developed Tableau visualizations and dashboards using Tableau Desktop, Tableau workbooks from multiple data sources using Data Blending. Created (Extract, Transform, Load) ETL design mapping sheets, data reconciliation strategy, data archival strategy- ETL framework, stored procedures and built SQL query objects to detect data loss. Environment: Tableau, R, Python, Power BI, SQL Server Analysis Services (SSAS), Matplotlib, Toad, Excel, MySQL. CVS Health, Providence, RI Jun 2020 Dec 2021 Senior Data Analyst Responsibilities: Designed, developed and fully Automated Tableau Dashboards which includes the volume completed each day by the team. Data visualizations of scatter plot, countplot, heatmap using matplotlib, seaborn, plotly packages in python, outlier analysis using box plot Worked with cross-functional teams to gather and document reporting requirements and translated them into specifications to use in required reports and dashboards. Utilized Power BI for data visualization and analysis. Worked with Tableau to create dashboards, stories, and other visual displays to provide clear and insightful comments by connecting various data sources. Performed Exploratory Data Analysis and Data Visualizations using python, and Tableau. The same goes for Enterprise data warehouse. Created dashboards using Tableau/Power B| for analysis project by analyzing the historical data and identifying KPis which had a positive impact on the business. Developed various solution driven views and dashboards by creating different charts in Power BI Created Power BI reports by using joins in multiple tables from database using SQL queries. Created numerous dashboards to monitor data by integrating python with Tableau. Extracted data from SQL Server, Flat Files, Excel, and XML using Power BI and cleansed the data. Converted data types using Power query editor. Responsible to extract specific data set from Operation database (ODS) by using PL/SQL query in order to data cleansing process and new feed processing purpose. Work with a team of developers to design, develop, and implement Tableau to measure Point of Sale KPIs at the micro and macro level. Evaluate data models / reports in the ETL process for quality and accuracy and make well-reasoned recommendations backed up by strong data visualizations to support the business team Utilized Oracle databases to extract and analyze data for reporting and decision making. Worked Closely with tax Processing team and build Ad-hoc and recurring reports in Cognos and Toad. Streamlining the ETL process for an Oracle data mart from different data sources (DB2, Access, Oracle, SQL Server, Excel and Text files) Designed rich data visualizations to model data into human-readable form with Tableau. Skilled in using Azure authentication and authorization and experience in using Visualization tools like Tableau, Power BI. Performed Data Analysis and Data validation by writing complex SQL queries using TOAD against the ORACLE database. Maintaining the existing reports by defining business problems and developing changes based on it. Environment: Tableau, Matplotlib, Seaborn, Plotly, Power BI, Python, SQL, Oracle, PL/SQL, Power Query Editor, ETL, Microsoft Excel, XML, Cognos, Toad, Azure, Data Warehousing, Flat Files, DB2, Access. American Century Investments, Kansas City, MO Sep 2018 May 2020 Data Analyst Responsibilities: Working on payrolls by inputting timecard entries and balancing them for each employee and analyze the reports and take corrective actions. Manage workflow to ensure all payroll transactions are processed accurately and timely. Analyzing various logs that are been generated and predicting/forecasting the future outcome with various python libraries. Created/modifying worksheets and data visualization dashboards in Tableau. Developed Data Mapping, Transformation and Cleansing rules for the Master Data Management Architecture involved OLTP, ODS and OLAP. Involved with Data Analysis primarily Identifying Data Sets, Source Data, Source Meta Data, Data Definitions and Data Formats. Worked with the ETL team to document the Transformation Rules for Data Migration from OLTP to Warehouse Environment for reporting purposes. Performed data testing, tested ETL mappings (Transformation logic), tested stored procedures, and tested the XML messages. Built interactive Power BI dashboards with parameters, calculated fields, and table calculations. Created Use cases, activity report, logical components to extract business process flows and workflows involved in the project using Rational Rose. UML and Microsoft Visio Involved in development and implementation of SSIS, SSRS and SSAS application solutions for various business units across the organization. Prepared Monthly Meeting report and presented in MS Excel, Tableau report or PDF.. Wrote test cases, developed Test scripts using SQL and PL/SQL for UAT. Creating or modifying the T-SQL queries as per the business requirements and worked on creating role playing dimensions, fact-less Fact, snowflake and star schemas. Involved in data analysis and creating data mapping documents to capture source to target transformation rules. Extensively used SQL, T-SQL and PL/SQL to write stored procedures, functions, packages and triggers. Analyzed of data report were prepared weekly, biweekly, monthly using MS Excel, SQL. Understand taxation of an employee and their benefits. Calculating the correct amount incorporating overtime, deductions, bonuses, etc. Worked on Iimplementation of new clients to ADP by auditing all the employee earnings, taxes, deductions and direct deposits and ensure that everything is properly inputted to ADP s portal. Responsible in training new joiners with Basics of MS-Excel Environment: Tableau, Python, OLTP, ODS, OLAP, ETL, SSIS, SSRS, SSAS, Power BI, Rational Rose, UML, Microsoft Visio, SQL, PL/SQL, T-SQL, MS Excel, ADP. American Airlines, Fort Worth, TX Dec 2016 Aug 2018 Data Analyst Responsibilities: Reviewing invoices and supporting documentation to ensure they are payable are not. Completed an idea project which has decreased the manual entry and received youngest team award for completing an idea project in the shortest period. Performed data analysis, data manipulation, data transformation and data mapping of source data using SQL server. Wrote simple and advanced SQL queries and scripts to create standard and ad hoc reports for senior managers. Performed Data Manipulation using MS Excel Pivot Sheets and produced various charts for creating the MI Snapshot reports. Performed Exploratory data analysis, trying to find trends and clusters. Also managed the whole assignment procedure for the whole team. Apart from these I worked on other initiations such as Samyuktham, Roadshow, MI snapshot. Environment: Excel, SQL Server, SQL, MS Excel Pivot Sheets. High Points Technologies, India Oct 2013 Sep 2016 Data Analyst Responsibilities: To obtain the data about the customers from different systems and aggregate within the data warehouse using Informatica Developed, and scheduled variety of reports like cross-tab, parameterized, drill through and sub reports with SSRS. Implemented Change Data Capture using Informatica Power Exchange Wrote ETL transformation rules to assist the SQL developer. Written documentation to describe program development, logic, coding, testing, changes and corrections. Developed and tested Store procedures, Functions and packages in PL/SQL for Data ETL. Created complex Cognos reports using calculated data items, multiple lists in a single report. Prepared functional and technical documentation of the reports created for future references Worked with data modelers in preparing logical and physical data models and adding/deleting necessary fields using Erwin Environment: ETL, Cognos, Informatica, PL/SQL, SQL, MS Office, MS Excel, Windows. Keywords: business intelligence active directory rlang information technology microsoft procedural language California Delaware Michigan Missouri Rhode Island Texas Keywords: business intelligence active directory rlang information technology microsoft procedural language California Delaware Michigan Missouri Rhode Island Texas