A motivated and proactive IT professional with 6+ years of expertise in the Healthcare, Banking and Financial domains able to learn unfamiliar material and techniques quickly, exhibit great attention to detail. Very passionate about projects and able to carry out tasks that are time sensitive in an efficient manner. A wonderful team player who values collaboration, working efficiently with diverse groups and possess a very strong work ethic.
Skills
Operating Systems: Win XP, Vista, 7, Windows Server 2003, 2008(X32, X64)
Databases: Google cloud, MS SQL Server 2005/2008/2012, Teradata 12/13, MySQL 52, 57, Oracle 9i, 10g, 11g, DB2
Business Intelligence Tools: Tableau 91, 92, 93, 104, 105, 20191, Excel and Power BI
Good knowledge of portfolio analysis, management, and customer segmentation
Possess strong computer and office administration skills with a vast knowledge of Windows and Microsoft Office Suite (Word, Excel, PowerPoint, Access, and Visio)
Experience in Data Management, Data Analysis, Data Manipulation for loading enormous amounts of data
Great understanding of SDLC methodologies such as Waterfall and Agile (specifically SCRUM)
Frequent update and exposure to new technologies and new business lines
Work History
Senior Business Intelligence Analyst
TELUS(Contractor)
07.2022 - Current
Provided recommendations on reports to operations team that informed critical decision making by senior management
Creating Project plans, project schedules and timelines with inputs from project scope, high level requirements and collaborations with business team stakeholders
Managing and developing the consolidation of individual project plans into a program level integrated plan and deliver progress reports
Helping with the analysis and communications of critical path and periodic risk assessment on the schedule identifying potential risks/opportunities and recommend mitigation strategies/contingency
Documenting data migration requirements with multiple stakeholders, technical security services team, Key SMEs from Audit, Legal and HR to document challenges, requirements and help articulate project outcome for delivery following all standard protocols
Analyzing and acquiring data from primary and secondary data sources- creating mapping specifications for use by ETL development resources
Facilitating the weekly JIRA review meeting to review and update Risks, Issues, PCRs, and Dependencies in JIRA with the Technical Leads and PMs for update
Examining data from web traffic, My TELUS app usage, and other sources to provide insights to business performance and customer behavior
Evaluating and identifying critical metrics and leading indicators to drive feature adoption, cleaning and consolidating data as required to design, implement, and report on Operations scorecard
Developing self-servable dashboards and visualizations to promote automation of information delivery as well as effective and timely reporting practice
Using technology and analytics tools to develop models and analyze our data collected from various sources including web and internal channels
Using data to tell the story of our operations and find opportunities to improve our practices and enhance our decision-making processes
Understanding and translating problems and needs into recommendations and actionable tasks for the team
Measure the efficiency of our existing programs through analysis of available data which will include identifying issues, forming hypotheses, and synthesizing conclusions into recommendations
Actively seek opportunities to constantly improve our processes and perform scenario-based testing to support your recommendations.
Data Strategist
Scotiabank (Contractor)
06.2021 - 06.2022
Assisted the Program Manager in the implementation & delivery of a regulatory project – Bill C-86
Delivered insights that informed critical decision making by senior management
Developed Power BI visuals used in analyzing customers complaints by predicting and modelling future outcomes
Employ Tableau best practices formulating reports, developing SQL queries, and creating advanced Tableau dashboards — improved KPI by 15% within 2 months
Defined access control levels for different types of users for publishing reports to Tableau cloud
Create Technical / design specification based on business requirements in clear and concise format
Implement several DAX functions for various fact calculations for efficient data visualization in Power BI
Utilized Power BI to design multiple scorecards and dashboards to display information required by different departments and upper-level management
Provide maintenance and development for the existing and new Power BI reports
Analyze SQL queries using joins and sub-queries involving multiple tables for validating the data against different kinds of reports
Using technology and analytics tools to develop models and analyze our data collected from various sources including web and internal channels
Understanding and translating problems and needs into recommendations and actionable tasks for the team
Measure the efficiency of our existing programs through analysis of available data which will include identifying issues, forming hypotheses, and synthesizing conclusions into recommendations.
Tableau Developer
American Express (Contractor)
11.2019 - 05.2021
Developed Tableau visuals for core engineering team mapping out their portfolios to be used in presentations for senior leadership
Developed direct connection between the backend couch base server and Tableau desktop which increased efficiency by 70%
Generated Tableau dashboards with data source/ action filters, calculated fields, and parameters on tableau reports
Created tableau dashboards with interactive views, trends, and drill downs along with user level security and permissions
Created outstanding visualization and scorecards for controls and compliance team mapping banking regulations to internal policies, standards, and processes for senior leadership teams
Analyzed data to identify trends and share insights ensuring normalization and consistency
Conducted and participated in meetings with the Business owners, Product Owners, and Product sponsors to understand the metrics for any project
Created cascading filters to filter the data within the hierarchy and prompt to specific filter that is applied by cascading
Maintaining the server to fetch data to different databases while controlling access permissions, security and understanding the existing schema
Designing and implementing database in accordance to end users’ information needs and views.
Snr. Data Analyst /Tableau Developer
Cigna Health (Contractor)
07.2016 - 06.2019
Recovered $12m by initiating self-directed research to uncover outlier payments in Medicare made to variety of providers including physicians, hospital, and rehabilitation facilities
Developed reports to operations team to drive results which increased customer satisfaction by 42%
Generated various monthly, bi-yearly, yearly reports by different type of reports using SSRS
Pulled data from Tri-Zeto claims systems to create operational reports for applications
Created ad hoc queries, stored procedures, and programming scripts with SQL
Created Tableau dashboard for displaying monthly inventory analysis
Produced member eligibility data, demographic data, claims (Medical, Dental, Pharmacy) data, premiums data by pulling from data warehouse and generating day-to-day reports in support of the Actuarial Finance department for pricing, catastrophic actuarial analysis and other purposes
Used data visualization tools to provide an easy-to-understand interface for end users to quickly identify key themes within their data
Supported the company’s healthcare software functions, implementation and training in data governance.
Nursing Clinical Student Practical Nurse at Humber River Hospital- Inpatient Surgery UnitNursing Clinical Student Practical Nurse at Humber River Hospital- Inpatient Surgery Unit