Sign in

Business Systems Analyst

Edmonton, AB, Canada
October 23, 2019

Contact this candidate


PRATIK PATEL 587-***-**** 2211 22 ST NW, Edmonton, AB – T6T0Z1


2+ years of professional experience as a Business Systems Analyst along with Incident Management in insurance domain.

Experience with Implementing and supporting business systems including business requirements elicitation, analysis and documentation (BRD) for the enhancement of the Financial application.

Developed and Maintained effective working relationships while collaborating with Business Stakeholders, subject matter experts and project team members.

Certified Data Science Professional; Hands-on experience in Data Mining including Data Cleaning, Data Transformation and Data Modeling using statistical techniques and tools including Python and SQL.

Experience working with SDLC methodologies including waterfall and agile for effective delivery of the project.

Achieved the Rewards and Recognition Award for the best team at Aetna Healthcare Inc for 0 defects and timely delivery of work.

Outstanding Academic Standing with Instrumentation Engineering Technology from NAIT looking to utilize the skills and experience acquired as a Business Systems Analyst in the IT Industry.

A quick learner and a team player with an ability to adapt in a fast-changing environment.

Tools & Languages: SQL, Python, MS-Office Suite (Excel, Word, PowerPoint, Outlook, Visio), ServiceNow, Tableau.


Programming: SQL, Python, DB2, RDBMS, C/C++, HTML, CSS.

Analytics: Excel, SQL, Python, Tableau.

Cloud Technologies: IBM Watson Studio, Jupyter Notebook, IBM COGNOS.

Operating Systems: Windows XP, Windows 7/8/10, Linux, Ubuntu

Other Tools: MS-Office Suite, MS Project, MS Visio, IBM Mainframe, IBM DB2, ServiceNow, WebEx, Github.


IBM Data Science Professional Certification, Coursera May 2019 – July 2019

Areas of Study: Open source tools and libraries, Methodologies, Python, Databases, SQL, Data Visualization, Data Analysis, and Machine Learning. Acquired skills in IBM Cloud using data science tools & real-world data sets.

The Project involved Exploring the Geographical dataset, segmenting and clustering neighbourhoods to identify the best location of business and travel. Involved with end-to-end implementation from Data Preprocessing until Evaluating the build Data Model.

Imported the web data utilizing web scraping technique, Used Foursquare API to retrieve location-based data and formatted and consolidated the data from multiple sources by using Pandas methods like replace, drop, value count, group by, one-hot encoding and multiple join table queries and maintained the integrity of data.

Performed data visualization using Matplotlib and Folium Python Library to correlate the consolidated data in Scatter plot overlapped on Geographical Map and identified the best location of Business and travel.

Used K-Nearest Neighbor Statistical algorithm to build data model, cluster and segment different neighbourhoods.

Integrated Github( with IBM Watson Studio to present data analysis and insights.

Tools & Libraries used: Python, SQL, R, Pandas, Numpy, Matplotlib, Folium, Scikit-learn, SciPy.


Business Systems Analyst – Infosys July 2015 – July 2017

Client - Aetna Inc. USA (Healthcare Insurance)

Provided subject matter expertise, designed and implemented appropriate technical solutions for Enterprise Billing system application.

Coordinated with clients to gather the business requirements; reviewed, analyzed and created the business requirement document including detailed functional specifications and user stories.

Developed Workflow diagram and Business data model using MS Visio to understand the business needs and mapped the requirements with the project team.

Created and maintained the project charter including project planning, project scheduling, resource allocation and cost estimation by extensively using MS project.

Conducted User acceptance test (UAT) to ensure the data is integrated and application is running as per the users requirement and obtained the Business sign-off.

Provided a weekly report to the project manager on project status by attending regular team meetings and status review calls.

Supported the QA team to identify bugs and issues in the application and recommended changes to enhance the application performance.

Application Systems Analyst – Infosys January 2015 – June 2015

Client - Aetna Inc. USA (Healthcare Insurance)

Created knowledge articles, user guides and carried out knowledge transition (KT) at the project level and acted as a first point of contact for incident clarification and root cause analysis.

Reviewed and analyzed critical billing issues using SQL queries and IBM Mainframe to identify the root cause.

Designed and developed technical solutions, mapped the solution with the dependent team and tested the changes made in the database.

Evaluated emerging trends of issues and provided recommendations to the project manager to reduce the incidents reported and improve the application performance.

Developed dashboard in ServiceNow to visualize the turn around time (TAT) and managed the resolution of critical incident on priority.

Ensured the tickets are timely updated in ServiceNow with most recent information and provided proper escalations alert to project manager and team members.

Followed Aetna’s compliance with data standards, policies and guidelines throughout IT service management.

Trained by Infosys on SQL, RDBMS, Python, IT Service Management (ITSM) concepts, Tableau and soft skill training including corporate, email and telephone etiquettes.


Instrumentation Engineering Technology, Post-Graduate Diploma Graduated in April 2019 Northern Alberta Institute of Technology, Edmonton, Alberta.

Bachelor of Engineering, Major in Electronics and Communication Graduated in 2015 Gujarat Technological University.

Contact this candidate