Puja Bishwal Email & Phone Number

Ontario, Canada

Chennai, Tamil Nadu, India

Designed and developed workbooks, dashboards, a global filter page, and intricate parameter-based calculations using Tableau Desktop as the front-end BI tool and Microsoft SQL Server as the back-end database.Spearheaded the end-to-end reporting process, encompassing data analysis, SQL table creation, and Tableau visualizations, resulting in comprehensive dashboards that offered actionable insights to stakeholders.Created SQL tables and stored procedures to encapsulate transformed data… Show more Designed and developed workbooks, dashboards, a global filter page, and intricate parameter-based calculations using Tableau Desktop as the front-end BI tool and Microsoft SQL Server as the back-end database.Spearheaded the end-to-end reporting process, encompassing data analysis, SQL table creation, and Tableau visualizations, resulting in comprehensive dashboards that offered actionable insights to stakeholders.Created SQL tables and stored procedures to encapsulate transformed data required for reporting purposes.Implemented user filters when publishing workbooks to ensure that only relevant teams could access them.Utilized Tableau to craft risk assessment dashboards, providing stakeholders with an effective way to visualize and evaluate risk factors.Optimized SQL scripts into efficient stored procedures, contributing to a 30% improvement in query performance for Tableau dashboards.Addressed multiple performance issues and established best distribution practices for several clients, streamlining processes and aiding power users in Tableau dashboard development.Worked closely with Business Analysts to comprehend requirements and translate them into impactful data visualizations and reports within Tableau.Conducted Tableau and Data training sessions for internal teams, enhancing their proficiency in data visualization and analysis.Proficient in updating and resolving issues effectively in JIRA, demonstrating a keen eye for detail in capturing comprehensive information and context for each problem. Show less

Chennai Area, India

Data Management Prod SAS : This process involves troubleshooting of errors occurred during any of the production processes. Validating the logs and fixing the errors.Validating the Actual and Coverage percentages of data received as Eligibility, Medical & RX files.Implementation SAS : This… Show more Data Management Prod SAS : This process involves troubleshooting of errors occurred during any of the production processes. Validating the logs and fixing the errors.Validating the Actual and Coverage percentages of data received as Eligibility, Medical & RX files.Implementation SAS : This process involves implementing new carrier or new group layout.Involves reviewing the raw data and mapping the existing carrier layout to the new group and warehouse it.Warehoused data loaded into SCIO applications for Patient Profile creation where business logics are run against the data. Proof of Concept - Business Intelligence AnalystResponsible for design, architect and development of reporting Medicare datasets in SAS. Performed data merging, cleaning by analysing and eliminating duplicate and inaccurate data using data step, PROC FREQ, PROC SQL.Worked on Medicare data which includes claims, plans, contract & demographic information. Created SAS datasets to create the Tableau reports to analyse the STAR Ratings.Involved in Full Life Cycle Development of Reporting Projects, includes Requirements gathering/analysis, Design, Development, Testing and Production rollover.Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.Involved in Troubleshooting, Performance tuning of reports and resolving issues with Tableau Server and Reports.Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, side by side bars, Heat Maps according to deliverable specifications. Show less

Chennai Area, India

Provide SAS Programming and data analysis support for multiple Market Analytics and Outcomes Research (OR) Studies.Process Commercial, Medicare and Medicaid healthcare claims data to provide evidence of benefits, risks, and results of treatments marketed by various pharmaceutical and medical organizations.Using detailed research project specifications, write SAS DATA STEPs, PROCEDUREs, and MACROs to retrieve raw data from the Truven Health MarketScan database encompassing of over 200… Show more Provide SAS Programming and data analysis support for multiple Market Analytics and Outcomes Research (OR) Studies.Process Commercial, Medicare and Medicaid healthcare claims data to provide evidence of benefits, risks, and results of treatments marketed by various pharmaceutical and medical organizations.Using detailed research project specifications, write SAS DATA STEPs, PROCEDUREs, and MACROs to retrieve raw data from the Truven Health MarketScan database encompassing of over 200 million records and 100+ variables in an UNIX environment.Comprehensively prepared reports using SAS report generating procedures like PROC PRINT, PROC REPORT, PROC TABULATE, PROC FREQ, PROC MEANS, PROC TRANSPOSE and PROC SQL.Considerable experience in Data Merging, Data Sub setting with the use of PROC SQL, MERGE and SET statements.Automating the Day to Day activities such as Printing SAS dataset, finding the Freq for SAS dataset variables, scheduling the jobs sequentially etc. using SAS and Unix Commands. Show less

Chennai, Tamil Nadu, India

Proficient in analyzing and translating business requirements to technical requirements.Acquire data files, transfer files securely, validate the contentExtensive experience in reviewing Business Requirement Documents, Software Requirement Documents and DataStage Jobs.Worked in Extraction, Transformation and Loading of data from multiple sources into Data Warehouse using Oracle 10g and 11g.Extensively worked with different data sources non-relational databases such as Flat… Show more Proficient in analyzing and translating business requirements to technical requirements.Acquire data files, transfer files securely, validate the contentExtensive experience in reviewing Business Requirement Documents, Software Requirement Documents and DataStage Jobs.Worked in Extraction, Transformation and Loading of data from multiple sources into Data Warehouse using Oracle 10g and 11g.Extensively worked with different data sources non-relational databases such as Flat files, XML files, and other relational sources such as Oracle.Implementation of full lifecycle in Data warehouses and Business Data marts with Star Schemas, Snowflake Schemas, SCD & Dimensional Modelling. Show less

Chennai, Tamil Nadu, India

Configuring SOHO Wireless Routers, WLAN NIC, Range Extenders, Switches, Repeaters etc. Providing technical support and resolving network-related issues for users and clients.Collaborating with cross-functional teams to implement network solutions.Simulating cases in the labs to troubleshoot the network problemsReceived positive feedback from clients for exceptional technical support and problem-solving skills.

Bachelor Of Engineering - Be, Computer Science

Education record