Data Analyst Power
Resume:
NEEL PATEL
**********@*****.***
Summary:
• Experience in Database Design Developed and Deployed reports in MS SQL Server environment using SSRS.
• Proficient in designing and developing cubes using SQL Server Analysis Services (SSAS).
• Created SSIS packages for importing the Excel layouts into the database using SSIS.
• Wrote T-SQL scripts to validate and correct inconsistent data in the staging database before loading data into database.
• Expert in data visualization using Tableau to create complex, intuitive and innovative dashboards.
• Expertise in SQL Programming.
• Designed, developed, implemented and supported Tableau dashboards. EDUCATION
Master's in Information Systems California State University - Los Angeles, CA Bachelor's in Information Technology Gujarat Technological University – India WORK EXPERIENCE
Kaiser Permanente - Pasadena, CA Jul 2019 to Present Data Analyst/SQL
• Created SSIS packages for data integration from various data sources like Access, and SQL Server 2012 into the operational SQL Server and deployed them by using configuration tools.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS.
• Developing reports and dashboards using Power BI stack, Power Pivot, Power View, Power Query.
• Using various SSIS tasks such as Conditional Split, Multicast, Fuzzy Lookup, which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Built the report models, created a wide variety of interactive reports for business users in SSRS and deployed the reports in various formats depending on the user requirements.
• Designed and created SQL Server Tables, Indexes, Stored Procedures, Views, and Triggers.
• Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis.
• Written complex SQL statements using joins, sub queries and correlated sub queries.
• Worked on Power BI on how to import, shape (info graphics) and transform data for business intelligence
(BI), Visualize data, and author reports, schedule automated refresh of reports and create and share dashboards based on reports in Power BI desktop.
• Proficient in designing and developing cubes using SQL Server Analysis Services (SSAS) and leveraging the advanced BI Functionality of SQL Server.
• Wrote T-SQL scripts to validate and correct inconsistent data in the staging database before loading data into database.
• Created traces using SQL server profiler to find long running queries and modify those queries as a part of Performance Tuning operations.
• Performed data migration and query validation from Teradata to Exadata. Fixed defects by comparing and validating outputs in Excel files and assigned to respective teams.
• Expertise in SQL Programming (Transact SQL statements / Stored Procedures) and SQL SERVER Jobs creation.
Environment: Microsoft SQL Server 2012/2014, MS Access, Visual Studio 2010/2013, IIS, Windows server 2008R2, TSQL.
VNURTURE- India Jun 2016 to May 2017
Data Analyst
• Created ETL design specifications, performed unit testing, data validations, integration testing and UAT and deployed SSIS packages to development and test environments.
• Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel and created SSIS packages to load excel sheets from PC to database.
• Created and Designed a Multi-Dimensional Analysis (Configured OLAP Cubes, Dimensions, Measures, MDX Queries, Data mining, Data Source and Data Source Views and Star schema) using SQL Server Analysis Services (SSAS).
• Worked with SSAS tabular model (BISM) and created dashboards and reports using power view, power pivot and SSRS.
• Retrieved and analysed data by writing ad hoc SQL queries across large scale dataset.
• Created SSIS packages for importing the Excel layouts into the database using SSIS.
• Used Tableau Desktop to design interactive reports and data visualization.
• Developed Tableau reports and dashboards from multiple data sources using data blending.
• Explored data in a variety of ways and across multiple visualizations using Tableau. Strategic expertise in design of experiments, data collection, analysis and visualization.
• Used SSIS script tasks, look up transformations and data flow tasks using T- SQL, C# and VB scripts.
• Deployed and scheduled reports using SSRS to generate all daily, weekly, monthly and quarterly reports including status.
• Expert in data visualization using Tableau to create complex, intuitive and innovative dashboards. COMPUTER SKILLS AND INTEREST
Programming Languages/Frameworks: SQL, PL/SQL, MYSQL, R, HTML, CSS/CSS3, Python, JavaScript, JSTL, Android
Databases: Oracle & Microsoft, MySQL, PostgreSQL
Web Servers: Apache Tomcat, Apache Web Server Operating System: Windows, Mac OS Tools: POWER BI, TABLEAU, MySQL, ORACLE, Spyder, R Studio, Android Studio ACADEMIC PROJECT
1. Oracle database implementation and designing Used: Oracle, SQL Mar 2018 to May 2018 Evaluated, tested, compared and validated those different models before selecting the best model for prediction by using SQL.
2. Naukri.com Used: Power BI Jan 2018 to Mar 2018
Developing, maintaining and supporting operational reports, dashboards and scorecards using Microsoft Power BI.
Explore data in a Variety of ways and across multiple visualizations using Power BI. The analysis will show hiring trends across industry sectors, geography and functional areas. 3. UK Traffic Accidents Used: Tableau Jan 2018 to Mar 2018 Designed, developed, implemented and supported Tableau dashboards. Created special spreadsheets using VBA coding to be able to upload information quickly and accurately. Involved in trouble shooting of performance issues associated with Tableau reports. Build various charts like Bar Graphs, Pie charts, Funnel charts, Scatter plots, Donut chart, Bubble charts etc. per the requirements.
Contact this candidate