Shailesh Patel

Cell Phone: 314-***-**** **** Trinity Road,

E-Mail: ad2g3l@r.postjobfree.com Carol Stream, IL 60188

Summary:

Over 20 years of experience in designing and developing solutions for data collection, processing, and business intelligence. Experience with many business domains including retail inventory management, supply chain management, finance, and accounting. Have the ability to manage a team, work as a team as well as individually to achieve results using various skills and knowledge analyzing raw data, developing, and maintaining datasets, improving data quality and efficiency, and building various data visualizations.

Excellent communication and interpersonal skills coupled with the ability to lead and motivate personnel in quality management and continuous data quality improvement.

Dedicated with a positive attitude and problem solver and critical thinker.

Fluent in statistics, datasets, and scripting and learn new skills outside of comfort zone

Self-motivated and effective at managing multiple tasks and a team of professional individuals.

Strong work ethic with the ability to coach others, recognize strengths, and encourage them to take ownership.

Excellent organizational and communication skills with follow-up abilities and understanding of data modeling, data schemas

Transform datasets and quantitative analysis into compelling visuals helping management make informed decision-making.

Technology & Tools:

Reporting Tools: Tableau, PowerBI, Crystal Reports, MS Access Reports

Database Management: SQL Server 2000 – 2016, MS Access 97-2013

Worked with Datawarehouse (Azure Data warehousing), Azure Cloud, TSQL

Office Admin: MS Excel, MS Word, MS PowerPoint, Visio 2010

Strong analytic skills and knowledge and understanding capability

Experience:

Sr. Reporting Analyst

Society of Actuaries Chicago, IL Mar 2016 to Nov 2023

Getting custom data to clients for analytical and other routine uses as per business requirements.

Create Tableau dashboards and lead the team in all the Tableau projects.

Worked with clients to understand the requirements and then designed and created Tableau dashboard and published them and then maintained and enhanced them to meet the constant changes in the requirements.

Started creating dashboards for Organization in Excel, and then moved to Tableau and led the team.

Managed Tableau server giving access to end users, creating folder structures, and other functionalities on Tableau servers.

knowledge of SQL, store procedures, and development ad-hoc queries and as per business requirements.

Created Crystal Reports for end users for to be used in Personify as per client’s requirement.

BAPS Shri Swaminarayan Mandir Chicago, IL July 2005 - present

Lead - National Database and Visualization - Volunteer

Manage a team of 10 Database administrators managing different databases for the organization, supporting different systems used by the organization.

Managing and overlooking the Project of PowerBI dashboards for the Organization since 2018. Initially developed the dashboards and now work with a team to create dashboards for the organization.

Serve as a lead Database coordinator for BAPS in North America managing and helping in requirements analysis, designing and implementing Database system to be used by all 125 centers of BAPS in North America.

Worked as Business Analyst/Project manager with a team of 3 developers, one DBA, and a system engineer and developed an online fundraising and tracking website which was used by 50 centers of BAPS USA.

Served on the team of a think tank collecting information to create a global database for the organization about personal information, their involvements, financial support, volunteerism, and their participation in different organizational events and activities.

Work with a team of DBA and ASP.Net programmers to develop an internet-based application for BAPS.

Point of Care Data Analyst

University of Chicago Medical Center Chicago, IL July 2005 to March 2016

Created various MS Access databases to maintain all the operators of the Point of care test and the areas where they are performed and all the operators’ competence and compliance requirements for the accrediting agency.

Designed and developed forms, tables, queries, and reports to collect, process, and report data about point-of-care tests and their outcomes.

Wrote complex queries, VBA functions, and formulas. Used SQL queries to prepare reports for management using various grouping and sorting

Used Database systems like Data Link, ITC-IDMS, EDM, Configuration Manager & Report Maker, Hemocue Database, and EPIC. Also Knowledgeable about the middleware Telcor.

Developed an on-line tool for glucometer competencies

Responsible for external quality assurance through proficiency testing for glucometers. This includes all aspects of PT. Timely enrollment, timely testing and submission of results, reviewing the evaluation reports, and responding to Pt exceptions summary reports if required.

Provided key support to Physicians in understanding and evaluating the Glucose results the patterns of the results and the trends.

University of Chicago July 2004 - July 2005

Research Data Technologist

GCRC core Laboratory

Designed a database for sample tracking as well as specimen management for the CRC laboratory

Worked on designing a barcoding system for samples to meet standards of HIPPA compliance

Designed a database to manage and maintain Genomic DNA extraction and concentration information.

Designed and maintained the database for all the patient information, and results of the CRC laboratory.

Working on QA/QC of YSI (Glucose Measuring Instrument) supervised the work of other technicians and maintained daily QC records in a complex Excel spreadsheet.

Software Product:

Designed, developed, and marketed a retail store management software using Microsoft Access. This allows business owners to maintain inventory, execute transactions, and produce various reports to help them successfully operate and manage their business.

Custom Database applications:

1.Genetic Pedigree tracking for knock out mouse in thyroid research

2.DNA Research Bank for Clinical Research Center

3.Specimen tracking for the Clinical Research Center

4.Glucometer Program Operating Database

5.Walkathon for BAPS temple

6.Pledges & Donation tracking for BAPS Temple

7.Spiritual Retreats programming for BAPS Temple

Special Skills:

Created Institutional Magnet Document Master Spread Sheet for capturing raw data.

Final formatting and finalization for printing of Magnet Document for UCMC.

Proficient in Word, Excel, PowerPoint, Publisher, Access, Visio and MS Project, SQL Database.

Training in Oracle for Learning Management System at the University of Chicago Medical Center.

Education:

Bachelor of Science and Technology

Gujarat University, Ahmedabad, India

References:

Available upon request

Contact this candidate