Data Analyst Cloud

DRASHTI PATEL

community.mis.temple.edu/drashtipatel

Philadelphia PA 19116 Cell: 856-***-**** ************@*****.***

SUMMARY OF EXPERTISE:

Strong familiarity with waterfall development processes in UX projects and process improvement.

Working knowledge of implementing software development projects using methodologies such as Waterfall, Agile, Iterative and UML.

Working knowledge of designing and developing website using WordPress software.

Ability to troubleshoot software system.

Expertise to find and stop computer bugs, viruses and unethical activities.

Capability to protect public and private data from breaches for security purpose.

Excellence in understanding application infrastructure deployment using Amazon Web Services (AWS) cloud computing.

Exposure on AWS cloud technologies such as EC2, RDS and S3.

Project experience with building or maintaining cloud-native applications.

Experience with building Virtual Machine (VM) instance using Google Cloud Platform and Microsoft Azure.

Capable to write, understand and interpret computing languages such as HTML, CSS, JavaScript, Python and SQL Queries.

Good understanding of API integrations and Web Services with hands on experience in business and system analysis for the integration of Web APIs (REST, XML, JSON).

Proficient in creating a website using VS Code and developing API endpoints in Cloud Computing.

Strong proficiency in MySQL database management including writing and optimizing SQL statements.

Experience with building Training and Scoring Predictive Auto ML using MS Azure.

Expertise in building, training and publishing QnA bot using Azure’s QnA Maker.

Proficient in developing Business Requirement Documents (BRD) and Functional Requirement Documents (FRD).

Experience in understanding and interpreting Financial statements sing tools such as S&P Capital IQ, FactSet, Finra and Yahoo Finance.

Excellence in maintaining inventory, stock replacement and product labeling.

Experienced with MS Office including Excel, Word and PowerPoint.

Web Development:

VS Code, BBEdit, File Zilla, WordPress

Languages:

HTML5, CSS, Java Script, SQL, Python, Node JS, AJAX, JQuery, JSON, Bootstrap

Databases:

My SQL, RStudio, Oracle

Operating Systems:

Microsoft Windows, Mac Os, Linux

Project Management:

Amazon Web Services (AWS), Azure, ML, Google Cloud Platform, Power BI, QnA Maker, WordPress, Canva

SDLC Methodologies:

Agile, Waterfall, Iterative, UML

Others:

Microsoft office, Excel, Word, PowerPoint, Assess, Outlook, OneNote

INFORMATION SYSTEMS PROJECTS:

Created Training and Scoring Predictive Auto ML using Azure. Predicted best possible influencers and helped university to make future decisions using historical dataset (2020)

Constructed the systems and cloud applications, Created: load balancer, launch configuration, auto-scaling group, and RDS through AWS; Built Toll Calculator on HTML and JS programs using VS Code and BBEdit; Prototyped the application to display toll information between two interchanges on the Pennsylvania Turnpike, deployed Turnpike Prototype Toll Calculator to AWS VPC (2019)

UX Project - Researched the organization, its mission, products and services, and target market; Defined the problem, designed the prototype, processed the usability test, redesigned a website using WordPress software. (2019)

Served as team lead for data analytics challenge of 2018, analyzed the data of Comcast NBCUniversal, implemented ideas as a solution, designed and developed a graphic design using Canva as a final deliverable for Comcast NBCUniversal (2018)

EXPERIENCE:

SPC Tax & ACCOUNTING, Philadelphia, PA August 2017 – Current

Employee, Accounting Data Analyst

Responsibilities:

Receive data into genius format: JSON, CSV, Excel etc.

Fully responsible to install data into the SQL server database and Excel.

Along with importing data responsible for performance tune existing database query.

Responsible to explore dataset using python and SQL.

Work with client enrollment and taxes eligibility verification payment cycle.

Help clients to achieve the goal to run the query faster which takes about 30-40 minutes to generate the report.

Recommend client the best possible solution regarding the business performance.

E-mail, call and eFax clients for business accounts, performance updates and recommendations.

Pay monthly sales tax and state tax for several businesses depending on the its location.

Prepare Financial statements.

ACTIVITIES AND AWARDS:

1.Certificate of Excellence at AIS, (Temple University), 2019

2.Group leadership at High School Science Fair, 2012

EDUCATION:

TEMPLE UNIVERSITY, Fox School of Business, Philadelphia, PA

Bachelor of Business Administration, Graduation: May 2020

Major: Management Information Systems Minor: Finance

GPA 3.3

COMMUNITY COLLEGE OF PHILADELPHIA, Philadelphia, PA

Associates in Business and Administration, Graduation: December 2017

OTHER SKILLS:

Excellent in time-management.

Excellent decision making and collaborating.

Fluent in English, Gujarati, and Hindi.

Contact this candidate