Data Analyst Management

Pabitra (Pabi) Phuyal Omaha, NE (***) -***-**** ***************@*****.*** LinkedIn

Dynamic Data Management and Process-Oriented Analyst with extensive expertise in data integration, analytics, and system analysis. Highly proficient in gathering, interpreting, coding, and organizing data to deliver actionable insights. Driven by curiosity, continuous learner, and a passion for data and data management tools.

Technical Qualifications/Skills List

Data Platforms: T-SQL, Snowflake, Big Query, Azure SQL

Programming Languages: SQL, PL/SQL, Python

Data Visualization: Google Looker, Looker studio, Snowflake, Tableau, Power BI, Metabase, SSRS.

Project Management Tools: Jira, TFS/Azure DevOps Server.

Cloud Platforms: Google Cloud Platform (GCP), Snowflake

Query optimization, Data Cleaning, Data Accuracy, and focus on detail.

Microsoft Office (Outlook, Word, MS Excel, MS Access, SharePoint), Bitbucket, Datahub, Visual studio, DBT.

ETL/ELT: SSIS, Air Byte, Databricks

Machine Learning: Implemented predictive models using Python (e.g., Scikit-learn, TensorFlow) and SAS for regression, classification, and clustering tasks.

Operating System: Windows

NTT DATA – Contract Position for CCNC Program Evaluation Data Analyst February 2024 to Present

At NTT DATA, I am responsible for assisting the CCNC as a Program Evaluation Data Analyst involves analyzing large datasets and measuring the impact of innovative healthcare initiatives. By leveraging advanced statistical methodologies and tools, the program focuses on enhancing healthcare delivery and improving patient outcomes. As a Data Analyst, I play a pivotal role in consolidating diverse data sources, applying statistical analysis, and presenting actionable insights that guide critical decision-making for the program.

Conduct comprehensive data analysis and author detailed program evaluations to measure the impact of CCNC initiatives.

Consolidate data from multiple sources into unified datasets, ensuring accuracy and consistency for evaluation purposes.

Apply advanced statistical techniques, including regression modeling, to analyze raw claims data and derive actionable insights.

Present findings through compelling visualizations and written reports, aiding stakeholders in informed decision-making.

Utilize tools such as SAS, Excel, SQL, and Python for data management and analysis, ensuring efficiency and precision.

Technical Environment:

SAS: Using for regression modeling, including logistic regression modeling.

Excel, SQL and Python: Utilized for data management.

Business Qualifications/Skills List

Data Integration, Visualization, Analytics, Analysis, Quality

Worked independently or in Team assignments

Excellent debugging and troubleshooting skills

Agile Scrum Master certified

Agile Ceremonies, Sprint Planning, Daily Stand-up, Sprint Review and Sprint Retrospective

Strong analytical, problem solving and decision-making skills

Fast learner, always curious to learn

Adept at managing end-to-end data projects

Known for delivering compelling presentations to varied audiences

Informed decision-making

Foster data-driven cultures

Employments

DENTALXCHANGE (EDI HEALTH GROUP) – Irvine CA (initially contracted via York Solutions, transitioned to full-time employment)

SQL Developer and Data Quality Analyst

Feb 2023 to

June 2024

DentalXchange connects the dental industry and empowers dental practices with cutting-edge online services. These services enhance efficiency, reduce costs, and accelerate revenue cycles. DentalXchange has been providing Claims Services, Attachment Service, Real-Time Eligibility, Secure and cost-effective credentialing solutions. Merchant Processing Services and Patient Statements.

At DentalXchange, our team capitalized on my Data and SQL development skills to advance data analytics, propelling us towards informed strategic decisions within the healthcare technology landscape, enabling us to improve data management systems significantly.

Collaborated with diverse stakeholders to understand business needs and provided data-driven recommendations and documentation.

Worked closely with cross-functional teams (developers, analysts, business users) to ensure data accuracy and alignment with business goals.

Analyzed trends, patterns, and anomalies in data and ensured data accuracy and consistency across various systems. Collected, cleaned, and transformed raw data into usable formats.

Created and managed databases, optimized queries, automated ETL processes, extensive ETL testing, deployed ETL\ELT packages and fixed unexpected job failures.

Proficient in SQL and database modeling. Expertly tuned SQL queries, indexes, and database performance to ensure efficient and rapid data retrieval, optimizing overall system functionality.

Ensured data accuracy through rigorous testing (QA testing and UAT) and validation processes.

Created stored procedures, views, indexes, and user-defined functions in T-SQL and views on Big Query platforms.

Worked under HIPAA rules and regulations and ensured all data handling and reporting practices comply with the highest standards of privacy and security especially in organizing and manipulating claims and ensuring payment reliability.

Collaborated with cross-functional teams (Production, Marketing, and Sales) and led solution delivery by consistently applying project management phases.

Utilized and manipulated DentalXchange’s ClaimConnect data to submit claims to Medicaid Medicare and to other payers.

Gathered requirements, prioritized tasks, analyzed business processes, selected tools, and applied various project management techniques.

Created comprehensive test plans, including component, assembly, product, performance, user acceptance, and technical architecture tests. Developed detailed testing strategies, scripted test cases, and generated input data to ensure thorough coverage and validation.

Used DBT for peer review on Bitbucket (like Git), ensured that the data transformation code is thoroughly tested and reviewed before being deployed.

Managed Agile ceremonies, including Sprint Planning, Daily Stand-ups, Sprint Reviews, and Sprint Retrospectives.

Developed dynamic, interactive visualizations, SSIS packages and automated report distribution to 1000s clients every morning, based on the previous day's claim submissions, significantly saved time and increased efficiency.

Technical Environment: Jira, SQL, Python, Juypter Notebook, Visual studio, Tableau, SharePoint, Bitbucket, Word, Excel, SQL Server, SSIS, SSRS, Google Looker, Big query (GCP), Metabases, Data Hub, Snowflake, Databricks.

OMAHA PUBLIC SCHOOLS – Omaha NE

System & Data Analyst / SQL Developer

Feb 2020 to

Jan 2023

At Omaha Public Schools, our team refined data interpretation for educational insights. We harnessed abilities and delivered robust business analytics solutions. These efforts supported our overarching goal of achieving operational excellence and delivering value.

Created SSIS Packages, implemented mapping documentation in SSIS ETL processes and ended the manually updating data for special education supervisors.

Designed, developed and tested ETL packages to extract, transform, and load data from various sources into the target data warehouse. Ensured data quality through extensive testing.

Gathered and analyzed business requirements and translated them into meaningful documentation.

Wrote complex SQL queries, interpreted results, and effectively communicated with non-technical users.

Participated in designing logic, query optimization, and troubleshooting.

Created custom reports, including budgeting, special education services, attendance department, and transportation.

Created customized interactive reports and dashboards (tabular, matrix, charts, dashboard, and sub-reports) and deployed them to the report server.

Mentored junior developers and ensured data accuracy throughout the SSIS Package development processes.

Technical Environment: SQL, Tableau, Excel, SQL Server, SSIS, SSRS, SharePoint, TFS.

MITS – Omaha NE

SQL/SSIS Developer/

Data Analyst

Apl 2017 to Jan 2020

MITS delivers networking services along with application services, infrastructure services, and business process outsourcing (BPO) services. MITS provides an integrated communication platform to connect its clients with their customers, offering conferencing services through a combination of technology expertise, domain knowledge, and process excellence. MITS serves clients in banking and capital markets, insurance, manufacturing, and healthcare.

Utilized Python programming to implement variables, data structures, branching, loops, functions, and object-oriented principles, enhancing software functionality and performance Analyzed, designed, developed, implemented, and tuned SSIS 2014/SSIS 2016 packages for ETL processes.

Designed ETL packages to handle different data sources (SQL Server, flat files) and loaded data into the target data warehouse, applying various transformations.

Utilized SSIS Tester, an automated tool, to test packages, tasks, and precedence constraints.

Created database tables, sequences, views, stored procedures, cursors and triggers on SSMS.

Utilized various SQL Server constraints (primary keys, foreign keys, defaults, checks, uniqueness).

Leveraged advanced features such as object types, collections, and dynamic SQL.

Understood complex SSIS packages and effectively communicated their functionality to the team.

Created customized interactive reports and dashboards using (tabular, matrix, charts, dashboard, and sub-reports).

Technical Environment: Python, SQL, Power BI, Excel, SQL Server, SSIS, SSRS, SharePoint, TFS.

ALZHEIMER’S ASSOCIATION – Omaha NE- Intern and volunteer

SSIS Developer

Mar 2016 to Mar 2017

The Alzheimer's Association provides services and help all those facing Alzheimer’s disease and other dementias by providing support groups and educational resources, while advancing crucial research and public policy initiatives.

Conducted database administration, execution estimation, and execution tuning for new databases and existing databases by utilizing SQL Profiler and Data Engine Tuning Advisor.

ELT testing, such as system, unit, regression, load, and acceptance testing methods, test any existing or new functional requirements ETL packages and let the original developer or the team.

Developed complex projects in T-SQL, composing Stored Procedures, Triggers, and Queries with the best execution design.

Created reports utilizing SSRS, Excel services, and Power BI and deployed them on SharePoint Server as per business requirements.

Used the SSIS Import/Export, relocated the Heterogeneous Database, for example, Oracle and Access database, and leveled documents to SQL server 2018.

Configured SQL mail operator for sending programmed messages when an SSIS bundle is fizzled or succeeds.

Contact this candidate