| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Phone: PHONE NUMBER AVAILABLEEmail: EMAIL AVAILABLEProfessional Summary:3 years of Experience as Data Analyst, SQL Developer with a solid understanding of Evaluating Data Sources and a strong understanding of Data Warehouse, SQL, Tableau, Teradata, BI, Python, Aws Redshift, SQL Server, Oracle, SAS, Google Sheets, OLAP, SSIS, Client - Server Applications.Good knowledge in a Python-based environment, along with data analytics, data wrangling and Excel data extracts and Familiar with Pandas, NumPy, matplotlib.Good in developing different Reports, Analytics, Data Mining solutions to various business generating data visualizations using Python, Tableau and Google Sheets.Extensive experience in ETL Design, SSIS for Extraction, Transformation & Loading.Expertise in Excel, Pivot Tables, VLOOKUP and other advanced functions.Expertise in Access Data, Creating SAS table from files, Creating Analytics in SAS.Expertise in writing SQL Queries, Dynamic Queries, sub-Queries and joins for generating Stored Procedures, Triggers, User-defined Functions, Views and importing Data from excel.Developed SQL, Stored Procedures, Views, Indexes and Constraints, Query optimizer.Experience in data analysis using python (Pandas, NumPy).Experience in Data Warehousing applications, responsible for the Extraction, Transformation and Loading (ETL) of data from multiple sources into Data Warehouse.Excellent knowledge in Extraction, Cleansing and Modification of data from/to various Data Sources like Flat Files, Sequential files, Comma Delimited files (.csv), XML and Databases like Oracle, ODBC, Teradata, SQL Server, MySQL etc.Hands on Experience in creating workbooks and dashboards using Tableau that includes tools like Tableau desktop, Tableau server.Good interaction with clients, understanding Business Applications, Business Data Flow and Data Relations.Good understanding of technical trends and architecture and highly motivated to know more about latest technology, new software, and products.Team player with good communication and interpersonal skills. Responsible for interacting with business partners to identify information needs and business requirements for reports.Ability to handle multiple tasks concurrently and meet the deadlines.Technical Skills:ETL / Reporting : Informatica, Business ObjectsBI Tools : Tableau Desktop, Tableau Server, ExcelProgramming : Python (Pandas, NumPy, Matplotlib)Data Visualization : PowerBI, DAX, Tableau, ExcelDatabase : MySQL, SQL Server, Oracle, Teradata, MSAccessMicrosoft Package : Microsoft Excel, Power Point, Word and VisioMethodologies : Agile, WaterfallProfessional Experience:Centific Technologies Inc, Redmond Jan 2023 to Till DateRole: Data AnalystResponsibilities:Developed full life cycle software including defining requirements, prototyping, designing, coding, testing and maintaining software.Created Logical & Physical Data Model on Relational (OLTP) on Star schema for Fact and Dimension tables using Erwin.Performed GAP analysis to analyze the difference between the system capabilities and business requirements.Developing SSIS packages to integrate them intoAzureDataFactoryV2.Used Agile Method for daily scrum to discuss the project related information.Prepared ETL technical Mapping Documents along with test cases for each Mapping for future developments to maintain Software Development Life Cycle (SDLC).Involved in Data flow analysis, Data modeling, Physical database design, forms design and development, data conversion, performance analysis and tuning.Created sampling specification, performed quality assurance, created multiple datasets to communicate with Medicare Advantage plans and analyzed Medicare plans response.Created and maintained data model standards, including master data management (MDM) and Involved in extracting the data from various sources like Oracle, SQL, Teradata, and XML.Designed the data marts using Ralph Kimball's Dimensional Data Mart modeling methodology using Erwin.Proficient in developing Entity-Relationship diagrams, Star/Snowflake Schema Designs, and expert in modeling Transactional Databases and Data Warehouse.Worked on normalization techniques, normalized the data into 3rd Normal Form (3NF).Implemented Forward engineering to create tables, views and SQL scripts and mapping documents.Responsible for all BI Team Azure based solutions along with developing strategy on implementationUsed reverse engineering to connect to existing database and create graphical representation (E-R diagram).Performance tuning and stress-testing of NoSQL database environments in order to ensure acceptable database performance in production mode.Extensively involved in creating graphs by using measures and dimensions data from various databases by using data blending concept.Converted existing BO reports to tableau dashboards.Created different KPI using calculated key figures and parameters.Developed Tableau data visualization using cross tabs, Heat maps, Scatter Plots, Pie Charts and Bar Charts.Provided production support to Tableau users and wrote custom SQL to support business requirements.Involved in data cleaning to rid the system of old, unused data, or duplicate data for better management and quicker access.Extensively involved in analyzing various data formats using industry standard tools and effectively communicating them with business users and SMEs.Involved in Defect Review meetings with Business Core Team and Developed use-case Analysis.Validating the Data files from source to make sure correct data has been captured to be loaded to target tables.Environment:Python, Erwin, SQL Server, Tableau Desktop, Tableau Server, Agile methodologiesLWSD, Redmond Mar 2021 to Dec 2022Role: Data AnalystResponsibilities:Involved in Analysis, design, and documenting business reports such as Summary reports, undefined exception reports e.tc.,Worked in Agile environment, with an ability to accommodate and test the newly proposed changes at any point of time during the release.Filtered inaccurate data from legacy system using complex T-SQL statements and implemented various constraints and triggers for data consistency.Accessing Data, creating table from files, filtering Tables in SAS Creating Analytics in SAS.Generating various reports (graphical) using Python packages like NumPy, matplotlib.Ability to write and optimize diverse SQL queries, working knowledge of RDBMS like SQL Server, MySQL and Oracle.Designed, developed and maintained complex SQL codes for extracting and feeding data in to repositories from various sources, which included flat files, Json files and Oracle tables and SQL server Tables.Imported data from multiple data sources into Excel workbook, created relationships between heterogeneous data, created calculated columns and measures using VLOOKUP and formulas, built PivotTables and Pivot Charts using Power Pivot skill.Expertise in building Tableau reports.Wrote several complex SQL queries to extensively test the ETL process.Delivered data solutions in report/presentation format according to customer specifications and timelines.Execute and maintain reports for external clients and internal support.Support adhoc data analysis requests from business owners and support management teams.Design and develop Tableau visualization solutions.Work on generating various dashboards in Tableau server using various data sources.Analyzed data sources, constructed data decomposition diagrams, provided data flow diagrams, and documented the process.Built and published 15+ customized interactive Tableau reports and dashboards along with data refresh scheduling using Tableau Desktop and Tableau ServerCreated 100+ Tableau scorecards and dashboards using stacked bars, bar graphs, scatter plots, geographical maps, Gantt charts, and other visualizations.Processed industry and company Tableau Best Practices for visual analytics and storytelling to maximize the impact of 3 visualization products.Environment:Python, SQL Server, MS Access, Informatica, Tableau Desktop, Tableau Server, Agile methodologiesEducation Qualifications:Bachelor of Science in Computers from Nagarjuna University, India |
