Learn Data Skills
Beta
Wilfred Castelino

Wilfred Castelino

Data Reporting Analyst

Evernorth Health Services | Connecticut

Technologies

My Portfolio Highlights

My New Course

Introduction to Python

Curious explorer of data landscapes, seeking hidden treasures.

My Work

Take a look at my latest work.

course

Intermediate SQL Queries

course

Introduction to R

course

Introduction to Python

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

My Work Experience

Where I've interned and worked during my career.

Evernorth Health Services | Dec 2021 - Present

Data Measurement and Reporting Lead Analyst

- Developed and enhanced the data sharing governance operation systems and procedures to expand the use and collaborate on various business, IT, and operational activities within the organization. - Developed and produced Excel-based reports based on DB resources used across the enterprise. These reports assure the quality and integrity of the data collected. - Provided critical subject matter and technical programming solutions for several enterprise compliances, data exchange and governance programs and initiatives. - Designed and developed on the go solutions using SQL Scripts to help solve business with custom reporting. - Facilitated review sessions of clinical code set used in healthcare, engaging with appropriate subject matter experts to meet, define and determine resolutions.
Show More

Rang Technologies Inc | Sep 2019 - Nov 2021

Data Analyst

- Developed dashboards and reports using Tableau that would drill down the data for analysis used by the leadership group. - Track, triage and manage data sharing and exception requests through Service Now. - Build Technical resource guides and documentation on program development of new and existing solutions involving a multitude of datasets spanning several data domains. - Created pivot tables, charts, and reports using worksheet data and external resources, modified pivot tables, sorted items, and group data, and formatted pivot tables in Excel.

New Jersey Institute of Technology | Jan 2018 - May 2019

Data System Analyst

- Built web pages and an automatic E-mail notification system that helps the higher management to send predefined emails to mass in seconds at a click of a button. - Developed a common registration website using the MVC architecture that could be used by various departments in the university. Designed the website using Bootstrap 4. - Created a common database structure using MySQL that helps the admin to generate reports.

Accenture | Jul 2015 - Jul 2017

Application Development Analyst

- Developed and maintained complex SQL scripts that significantly improved the user experience of client applications in an agile fashion and used 2-week sprints in collaboration with the UI team. - Developed SQL Scripts using functions, procedures, and triggers to automate the daily processes which would reduce 20 hours of manual work per week. - Worked extensively on advanced SQL concepts - joins, views, subquery, windows functions. - Build reports that would show the trends in capital markets for every month using SQL Reporting Services (SSRS) which helped my client to make business decisions.

Accenture | Aug 2014 - Jun 2015

Application Development Associate

Medium Type Enhancements as per sprints. - Developed SQL Scripts to maintain daily jobs and help build custom ASP.NET Web Pages to improve client experience. - Responsible to handle and supporting critical requests in production. Solved Bugs and queries before the allocated time of resolution.

My Education

Take a look at my formal education

Master of Science - MS,  Information SystemsNew Jersey Institute of Technology | 2019
Bachelor's Degree, Electronics and Telecommunication  · (August 2010 - MayMukesh Patel School of Technical and Management Education | 2014
High School, ScienceSt John the Baptist High School and Junior College | 2010

About Me

Wilfred Castelino

A dedicated and self-motivated individual with good problem-solving skills as well as excellent analytical and critical reasoning abilities along with a proven record of delivering results within timelines.

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free