Meru R. Patel

**** ******* ******, ******, ** ***39 • adco3s@r.postjobfree.com • LinkedIn • 315-***-****

EDUCATION

Drexel University Philadelphia, PA

Bachelor of Science in Business Administration March 2019 Majors: Management Information Systems & Business Analytics PROFESSIONAL EXPERIENCE

Aspen Dental Management Inc Syracuse, NY

Business Intelligence/BSA January 2020 – March 2020

§ Documenting business processes while identifying improvements regarding BI procedures to effectively find solutions and complete projects.

§ Integrated new version upgrade of Tableau Sever 2019.4.1 and continued administrative maintenance and support.

§ Implemented process for BI support tickets utilizing TFS and ServiceNow to ensure proper management of support for business needs.

§ Developed queries in Microsoft SQL Studio 2016 for data needs such as creating SSRS reports, Logi dashboards, ETL procedures, and data connectivity to various internal and external applications.

§ Coordinated various IT projects across teams which resulted in updated tools, enhanced metrics, and new applications.

§ Designed an AI model utilizing data from SQL server to predict show rate for patient appointments and effectively increasing revenue.

Biscovery Hong Kong

Data Analyst June 2018 – September 2018

§ Created reports for corporate clients utilizing business intelligence tools such as Tableau and Qliksense on a regular basis for analysis, presentations, and consulting.

§ Developed machine learning and artificial intelligence algorithms in R and Python to analyze gender based on name, image recognition, and decision forecasting.

§ Implemented forecasting methods such as Monte Carlo, ARIMA, and Prophet within business reports to conduct predictive analysis based on client needs.

§ Integrated a R based tool with a GUI for decision analysis regarding tax and tariff data for clients that export and import products from Asia.

§ Collaborated with team members to transition and optimize legacy software from Oracle to SQL Server. SBC Digital Health Berlin, Germany

Business Analyst April 2018 – June 2018

§ Optimized and maintained an investment portfolio database consisting of digital health companies to provide efficiency and to create metrics for analysis.

§ Analyzed and scouted investment opportunities in the fields of medtech, digital health, and ehealth to gather potential clients and expand the investment portfolio.

§ Hosted and attended digital health events to communicate with clients, mentors, and partners around Europe to create channels for scouting.

§ Developed a web and file scraper tool using Python to improve efficiency in data collection and generating a data repository consisting of business needs.

§ Designed and developed specific databases for collection, tracking and reporting of data.

§ Designed, coded, tested and debugged custom queries using SQL Reporting Services.

§ Modified and maintained SQL Server stored procedures, views, ad-hoc queries, and SSIS packages used in the search engine optimization (SEO) process.

Bristol-Myers Squibb Hopewell, NJ

Information Security Analyst April 2017 – September 2017

§ Monitored and analyzed network traffic using SIEM to ensure security and respond to incoming threats

§ Created tickets and acknowledged threat alarms ranging from low to severe prior to assignment for analysis and remediation.

§ Maintained and modified security system rules to remove gaps in the network infrastructure and control access to sensitive data and assure information security.

§ Led project regarding whitelist proxy management to implement a new procedure for requesting and tracking un-block requests in the global environment.

§ Developed and updated threat management procedures in correspondence to the improvement and creation of new security threats and protocols.

§ Monitored and tuned database resources and activities for SQL Server databases.

§ Performed and automated SQL Server version upgrades and patch installs. Designed, developed and maintained relational databases.

PJM Interconnection Audubon, PA

IT Service Management & Compliance Analyst April 2016 – April 2017

§ Completed, monitored, and reviewed the execution of CIP checklists to ensure compliance of assets with NERC CIP requirements.

§ Coordinated the gathering of compliance evidence with internal departments for an annual IT audit.

§ Conducted reconciliation to detect unauthorized changes within the production environment to reduce imperfections and ensure security for supported applications.

§ Involved in extensive DATA validation by writing several complex SQL queries and Involved in back- end testing and worked with data quality issues.

§ Employed Agile Methodology (JIRA) for management of team projects and to maintain sprints.

§ Deployed, supported, and retired assets residing in the data center based on business requirements.

§ Implemented Application Lifecycle Management in order to develop a centralized process for request, build, and retirement procedures.

SKILLS

Microsoft Word, Excel, VBA, Power Point, SharePoint, SEIM, SQL, RSAM, Java, R, Python, Tableau, Tripwire, BMC Remedy, ClearQuest, QlikSense, Pipedrive, STATA.

Contact this candidate