Home

Veda Anand - Sr. Data Analyst

[email protected]

Location: Bentonville, Arkansas, USA

Relocation: Yes

Visa: H4EAD

Resume file: Hema_Mushkam_DataAnalyst_1762262675950.docx Please check the file(s) for viruses. Files are checked manually and then made available for download.

Hema Damaraju Sr. Data Analyst E-Mail: [email protected] Professional Summary: Overall 12+ years of experience in IT Industry. I am an expert in setup, scale and stabilizing the Data Analytics and Business Intelligence teams according to requirement across Finance and Human Resources Domains. Build visualization platforms and be able to generate quick decision-making insights . Hands on experience of using Looker Studio, Looker ML, Tableau/Power BI, SAS, Python, SPSS, and SQL for building analytical solutions to generate insights . Experience on Developing various Power BI reports using Visuals and Visual Properties including Tree Map, Pie Chart, Funnel, Scatter Bar Chart and Column Charts etc. Expert in writing T-SQL Commands, and in writing Common Table Expressions. Experience in Writing Complex Transact SQL (T-SQL) Queries, Sub queries, Co-related sub queries, Dynamic SQL queries etc., Created complex Stored Procedures, user define functions etc. Strong Knowledge in dimensional Star Schema and Snowflakes Schema. Hands on experience in Performance Tuning, Query Optimization. Created Views in Oracle SQL to use as data sources in Tableau for designing Tableau Reports and Dashboards. Extracting the data from different data sources with the help of cross database joins. Hands on experience on Tableau versions like 8.3,9,10 and 2018, 2020.4., Extensively used Calculations, LOD s, Table Calculations, Date functions. Prepared Dashboards using calculations, Parameters in Tableau and created calculated fields, groups, sets and hierarchies etc. Pulling data from API s using Python and loading into flat files, Writing SQL queries to get the relevant required data to build the Tableau reports. Developed Tableau workbooks from multiple data sources using Data Blending. Generated Tableau Dashboards by using the Extract filters, Data sources filters, Context filters, Parameters and Calculated fields on Tableau reports. Translated business needs into data analysis, business intelligence Data sources and reporting solutions for various clients. Developed stunning Visualizations for Dashboards using the data sources. Blended data from multiple databases into one report by selecting primary keys from each data validation. Strong problem solving and Analytical skills with high aptitude to adopt new tools and technologies with ease and seamlessly integrate skill set into the project implementation lifecycle. Collaborated with Technical teams to build the design and architecture documents and artifacts. Technical Skills: Analytical Tools: Power BI, Tableau, Looker, SSRS, SPSS and Base SAS. Office Suite: MS-Excel, Word, Access, Power Point. Database Tools: Microsoft SQL Server, PostgreSQL, Teradata, Big Query, Teradata, DB2, SQL Server, Oracle 12c/10g/9i and MS Access. Programming Tools: Python, Spark/Scala, PySpark, SAS, Base SAS and SAS/SQL, Macros, SQL, UNIX shells scripting. Education Qualification: Master s in Applied - Statistics from Osmania University Hyderabad, Telangana, INDIA. 2005 2007, Bachelors in Statistics, Mathematics and Computer Science from Osmania University Hyderabad, Telangana, INDIA. 2002-2005. Professional Experience: FRGRISK Sep 2023 Dec 2024 Data Analyst Responsibilities: Retrieved the customers data from Teradata database in to SAS environment using SAS/Access and SQL Pass through facility. Followed business requirement document and communicated with the business user to know the type of reports to be developed and the data that must be shown in the reports. Used SAS BASE for manipulating and modifying the data and for creating the datasets showing the customers data. Experienced in Base Procedures, Graph, Macros, Data Step, SQL and Data Mining, SAS Array Processing extracting internal/external data including cleaning and validation, use of formats and in formats. Involved extensively in Data Extraction, Transformation, Loading, and Analysis. Extract source data from Oracle to SAS data sets by using PROC SQL. Develop, optimize and Extract data create new datasets from raw data files using Import techniques and modify existing datasets using SET, MERGE, SORT, UPDATE and conditional statements. Exported Metadata from Legacy system to Grid environment then modified the code based on the new Libraries, Datasets and Metadata in the new Environment. Executed and validated Code and data in the Grid Server. Developed new jobs, stored processes, and web reports in the Grid server. Migrated jobs from Informatica to SAS D.I. Studio. Recreated connections to web services or APIs using Power BI connectors. Used data transformation tools like Power Query to clean and prepare data for visualization. created charts, graphs, and charts in Power BI that match the functionality and aesthetics of the original reports. Applied formatting and styling to maintain consistency and implement interactive elements like drill-downs or filters in Power BI. Created Rich visualized Pie & Line Charts, Tree Map, Tabular and Matrix Reports Using Power BI. Implement DAX Measures and Calculations for various Accounting Aggregations. Implement DAX Quick Measures for categorizing the data based on given parameters. Used Power BI Gateways to keep the dashboards and reports up to date. Environment: Base SAS 9.4, SAS E.G 6.1/7.1 SAS/Access, SAS/AF, SAS/Connect, SAS/Stat,SAS/Graph, SAS/SQL, SAS/ODS, SAS/Macros, SAS Enterprise Guide, SAS Data Integration Studio, Teradata,DB2, MS Excel, Macros & VBA, MS Access. Renown Analytics IT Solutions, India Sep 2017 Jan 2023 Power BI Developer Responsibilities: Imported data from SQL Server DB, Azure SQL DB to Power BI to generate reports. Created Dax Queries to generate computed columns in Power BI. Generated computed tables in Power BI by using Dax. Created Azure Blob Storage for Import/Export data to/from CSV File. Worked closely with database management team and business analysis team to understand the requirements and develop the Python code to meet the requirements. Worked on Python libraries such as numpy, pandas, scipy, matplotlib, seaborn etc. Used Power BI, Power Pivot to develop data analysis prototype, and used Power View. and Power Map to visualize reports. Published Power BI Reports in the required originations and Made Power BI Dashboards. available in Web clients and mobile apps. Experience on with Column (Field) Grouping, Hierarchies Creations and Usage, experience on with Drill Ups, Drilldowns, Expand Fields to next level and Expand All Levels. Experience on Edit Interactions and Bookmarks including Buttons and Actions, explore data in a variety of ways and across multiple visualizations using Power BI. Experience on various Power BI Modeling Techniques using Power Query [M Language] and have good experience in DAX query Language. Implement DAX Measures and Calculations for various Accounting Aggregations. Implement DAX Quick Measures for categorizing the data based on given parameters. Used Power BI Gateways to keep the dashboards and reports up to date. Installed and Configured Enterprise Gateway and Personal Gateway in Power Bi Services. Published reports and dashboards using Power BI. Experience on Sharing Reports, Dashboards, Organizational Content Packs and App Workspace. Creating and working with IMPORT and UPLOAD options for Dataset Creations, creating new reports from Datasets using Power BI Cloud. Working with Edit Interactions. Generating new insights and performance metrics including Dashboards Customizations. Recreated connections to web services or APIs using Power BI connectors. Used data transformation tools like Power Query to clean and prepare data for visualization. created charts, graphs, and charts in Power BI that match the functionality and aesthetics of the original reports. Applied formatting and styling to maintain consistency and implement interactive elements like drill-downs or filters in Power BI. Created Bullet Chart, Tree-Map, Reports, connection to Big Query, Single-Value Visualization, Bar & Column Chart, Line Chart, Pie Chart, Scatter Plots, Donut Multiples, Geo- Maps etc. Worked on Blending data from multiple tables. Created custom fields in Looker, filters, Boards, Look View-Mode, adding filters to Dashboard, Dimensions & Measures, Joins in Looker etc. Created visualizations reports such as Pie, Donut, Bubble, Time Series, Line & area Charts, Tree Map, Tabular and Matrix Reports Using Power BI. Coordinated with functional users for User Acceptance Testing prior to releasing system changes in production. Developed stunning Visualizations for Dashboards using the data sources. Implement DAX Measures and Calculations for various Accounting Aggregations. Implement DAX Quick Measures for categorizing the data based on given parameters. Used Power BI Gateways to keep the dashboards and reports up to date. IL &FS Technologies company, India Aug 2016 Aug 2017 B.I. Analyst / Data Analyst Responsibilities: Worked in a Project where migrated tableau reports to power bi, configured connections to databases like SQL Server, MySQL, or Oracle, and provided necessary credentials. Recreate custom calculations or expressions using Power BI s DAX language to ensure the same logic and results as in Tableau. Compared key reports between Tableau and Power BI for accuracy and consistency. Data sources are extracted, transformed and loaded to generate CSV data files with Python programming and SQL queries. Involved users in User Acceptance Testing (UAT) for feedback and adjustments. Performed performance testing, especially for large datasets or complex visualizations, and optimized queries and report design for optimal performance. Offered training sessions to facilitate the transition from Tableau to Power BI, set up appropriate access controls, monitor usage post-deployment, and gather user feedback. improved the reports based on user experiences to enhance their usability and effectiveness. Experience on Edit Interactions and Bookmarks including Buttons and Actions, explore data in a variety of ways and across multiple visualizations using Power BI. Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions. Created Rich visualized Pie & Line Charts, Tree Map, Tabular and Matrix Reports Using Power BI. Coordinated with functional users for User Acceptance Testing prior to releasing system changes in production. Developed stunning Visualizations for Dashboards using the data sources. Blended data from multiple databases into one report by selecting primary keys from each data validation. Prepared Dashboards using calculations, Parameters in Tableau and created calculated fields, groups, sets and hierarchies etc. Created Views in Oracle SQL to use as data sources in Tableau for designing Tableau Reports and Dashboards. Scheduled data refresh on Tableau server for weekly and monthly Increments based on the new changes to ensure that the views and dashboards were displaying the changed data accurately. Created Heat Map showing Current service Subscribers by Color that were broken into regions allowing business User to understand where we have most Users vs least users. Worked closely with database management team and SAS business analysis team to understand the requirements and develop the SAS code to meet the requirements. Extensively used macros to increase the efficiency and accuracy of the application. Implemented data cleaning techniques using PROC PRINT, DATA _NULL_, Transpose, NODUPKEY, and PROC SQL. Extract source data from MySQL to SAS data sets by using PROC SQL. Solid foundation in use of SAS macro, SAS/Connect, SAS/Access, SQL, Create reports in Excel spreadsheets using SAS/ODS and implement them in PowerPoint presentation. Access flat files using SAS/ACCESS, create reports in PDF and RTF format using SAS/ODS. The Hackett Group, Hyderabad - India June 2008 Aug 2016 Senior Analyst Responsibilities: Blended data from multiple databases into one report by selecting primary keys from each data validation. Prepared Dashboards using calculations, Parameters in Tableau and created calculated fields, groups, sets and hierarchies etc. Distributed Tableau reports using techniques like packaged Workbooks, PDF etc. Used Oracle as data sources for designing Tableau Reports and Dashboards. Created views in Tableau Desktop that were published to internet team for review and further data analysis and customization using Filters and actions. Facilitating the initial planning, and execution & delivery of process benchmarks in end-to- end processes of Sourcing and recruiting, Payroll and Administration, and Other Human resource Process. Accountable for assisting and supporting senior research directors in setting research hypotheses, carrying out research process that includes analysis and report production, eventually leading to research based advisory services to select clientele Identifying opportunities for improving operational efficiencies and identifying the potential business opportunities with the clients through exceptional reporting Developed, monitored and deployed SSIS packages. worked in transferring the data using SQL Server Integration Services packages Extensively used SSIS Import/Export Wizard for performing the ETL operations. Developed and monitored SSIS Packages for new ETL Processes and upgraded the existing DTS packages to SSIS for the on-going ETL Processes. Created Tables, Views, Indexes, Stored Procedure and Triggers. Used multiple join statements to retrieve data and update the tables. Created Backend validations using Insert/Update and Delete triggers. Involved in the Database design (Logical Data Modeling and Physical Data Modeling) of the system. Implemented Snow - Flakes Schema and Star Schema Identify the key performance metrics which contribute in terms of Efficiency and Effectiveness by using correlation technique. Identify the World Class and Non-World Class companies by calculating efficiency and effectiveness scores of each company participated in the analysis. Identify and cluster the basic characteristics, lifestyle, attitude, and mindsets of persons who are willing to take housing loans using segmentation and cluster analysis. In this project we have identified the clusters using Hierarchical cluster and Non-Hierarchical cluster methods by grouping the observations. Customer demographic and transactional data collection, Data Preparation/ Data cleansing along with Feature selection. Data extraction from various sources, Prepare the data (identify the missing values, imputing values like mean for interval variable, mode for categorical variable). Apply the Data mining models like Multiple Regression and share the insights with stakeholders. Hypothesis setup and Exploration of Data for insight generation, Preparing the presentation and documentation of the project report for actionable. This project mainly focuses on Identify and quantifies the factors responsible for losses in multivariate fashion for Auto insurance company. The database contains loss amount and policy related information. In this process we built Multiple Keywords: machine learning access management business intelligence database information technology microsoft mississippi Colorado Illinois