Data Analyst Information Technology
Resume:
VIKIKUMAR PATEL
BI DEVELOPER / DATA ANALYST
CONTACT
*********@*****.***
Austin, TX
linkedin.com/in/viki5999
EDUCATION
Master
Information Technology
Atlantis University
Miami, FL
2016
Bachelor
Information Technology
Symbiosis International University
Pune, MH, IND
2014
TECHNICAL SKILLS
Cloud Services: AWS
Database Tools: SQL, MySQL, Oracle (Basic)
Machine Learning: Scikit-learn, TensorFlow (Basic), Matplotlib, JUPYTER
Programming Languages: Python (Advanced), R (Intermediate), SQL,
Data Migration and Integration: SSIS, SSAS, SSRS, SSMS, Alteryx
Other Tools: Excel, Google Sheets, GitHub, SharePoint
PROFESSIONAL SUMMARY
Strong analytical and computation skills, with experience managing manipulating and interpreting data drawing conclusions and presenting results.
Process, clean, and verify the integrity of data using Python and develop visualization to communicate data-driven insights using Tableau.
Armed with project, product, operations, and inventory management skills in handling various projects and performing data analysis and design from various industries across multiple locations.
Process, clean, and verify the integrity of data using Python and develop visualization to communicate data-driven insights using Tableau.
Participated in all phases of data mining; data collection, data cleaning, developing models, validation, visualization and performed Gap analysis.
Assist Business Objects Tableau Report Developers to develop reports based on the requirements.
Expertise in building visualization using Tableau.
Strong knowledge of Power BI Desktop and maintaining dashboards.
Write DAX to create calculated columns and measures in providing KPIs with insights.
Good analytical skills and understanding for troubleshooting/problem-solving/predictive data.
Excellent working experience with Microsoft Office (Word, Excel, Power-Point, Access, ect.), MS Power BI and Tableau.
Developed and automated reports using Alteryx, Business Objects, Power BI, SQL server.
Assist Business Objects Tableau Report Developers to develop reports based on the requirements.
Build a dashboard to monitor the SQL server and alert if any process is impacting the performance using Tableau.
Experience with cloud platforms such as AWS and Azure.
Used Python libraries for data cleansing and manipulation and Integrated Python dataset with Tableau to build visual analytics solutions.
Good written and verbal communication skills, Strong organizational skills, and ability to provide efficient, timely, reliable, and courteous service to customers.
Excellent collaborating skill (Teamwork) working with Agile Methodology and always motivated to learn new technology and being a quick learner.
WORK EXPERIENCE
Accenture Austin, TX
Data Analyst MAR 2021 – Present
Implements tools and frameworks for automating report generation, identification of data-quality issues, and data governance.
Support client’s implementation of AWS products through architecture guidance, best practices, data migration, capacity planning, implementation, troubleshooting, monitoring, and more.
Understand Cloud Native applications within AWS.
Provide subject matter expertise for ongoing support of applications deployed to OCC’s nonproduction AWS environments and supporting 3rd party applications.
Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL
Experience with integration between Alteryx Analytics and Tableau to visualize the answers generated in Alteryx.
Explores the data and discovers patterns, meaningful relationships, anomalies, and trends.
Imported and transformed data between databases and external data sources using SQL Server Integration Services (SSIS).
Created sheet selector to accommodate multiple chart types in a single dashboard by using parameters.
Used Python to import data and perform data cleaning and integrated it with Tableau to build visualizations.
Victory Capital San Antonio, TX
Power BI Developer / Data Analyst AUG 2019 – MAR 2021
Gathered initial requirements from the users of various departments and corresponded with them throughout the process.
Wrote Complex SQL to identify and correct data anomalies at request of SME's.
Used pandas, NumPy, seaborn, SciPy, matplotlib, scikit-learn, NLTK in Python for developing various machine learning algorithms.
Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.
Created Power BI dashboards for business expansion on Sales growth, Claims Info and Customer services data from MS SQL Server Source.
Performed data integrity checks, data cleaning, exploratory analysis and feature engineering using R and Python.
Experience with AWS cloud services and collaborating with software development teams to ensure the platform meets their needs.
Experience with AWS cloud infrastructure and Automate software builds, designed, developed, and testing, using Power BI.
Expertise in creating schema objects, Performance Tuning of SQL coding.
Redesigned the data source having data from various sources into one SQL Server and to Power BI.
Involved in developing a Restful service using Python Flask framework.
Used Python and R for programming for improvement of model to optimize services.
Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.
Blue Chip Hotels Austin, TX
BI Developer/ Data Analyst Aug 2017- Aug 2019
Create, maintain, and design database diagram, develop, and deploy BI solutions using SQL Server, Power BI and excel.
Published the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.
Extensively used analytical features in Tableau like Statistical functions and calculations, trend lines, forecasting etc. in many Tableau reports.
Proficient with Microsoft Excel, Microsoft Access and understanding of Structured Query Language (SQL).
Wrote SQL to identify and correct data anomalies at request of SME's.
Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
Good experience on dashboards designing with large data volumes from various data sources (SQL server, tera data, etc.)
Expertise Configuring Repository, Create/Manage Dashboards, Reports/Answers and Building Physical, Business Model and Presentation Layer.
Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.
LYFTEK Solutions Pvt Ltd Pune, MH India
Jr. Data Analyst Jun 2013 -Jun2015
Provided extensive documentation for all the modules/products worked on for SQL Server Databases support and administration.
Troubleshooting for all database related problems and help desk support to different servers in SQL Database Administrator.
System admin activities like creating new users, responsibility, and menu according to the requirement.
Performed System Administration duties like, maintenance, backup, and recovery.
Analyze and manage data from various sources for trouble shoot and resolve data issues.
Data Analyze with Excel Skills: Pivot Tables, VLOOKUP, VBA and Macros
Responsible for technical support to other University campuses Q&A and Assistant to the IT Manager.
Contact this candidate