Juman J. Shawi
Beaverton, OR 941-***-**** firstname.lastname@example.org linkedin.com/in/jumanshawi2019
CLINICAL DATA AND INFORMATION ANALYST
Innovative and analytical business partner with experience in applications and data technology to support business functions across clinical health and procurement. Recognized for a “can do” attitude and strengthens in analysis (reporting), coding, support and data modeling. Collaborate with others to ensure projects are completed on time and under budget.
Development Applications: Tableau 2018.2.3, TOAD Data Point 4.1, SQL Server Mgmt. Studio 2012, Oracle SQL Developer (3.04), Visual Studio (SSIS, SSRS, SSAS), Lawson add-in, PowerPivot, Power Query, DAX Studio, DTS, MS Report Builder 2.0, MDX, ACCESS 2013, PL/SQL Developer, Crystal Reports ver 9,10,11, Advantage Data Architect. Servers: Tableau, Oracle and MS SQL.
Software / Servers: EPIC Clarity, SAP BI [Callisto, Infoview (Webi and Crystal Reports)], Insights, MSOffice Excel (VBA, Macro, PowerPivot, Pivot tables, Vlookup)], Image now, QuestSQLoptimizer.
Languages: VBA, PL/SQL (Oracle), T-SQL (using SQL 2000 and 2005, SQL Plus 8.0), SQL (using MS Access), Clipper, HTML, Java, FOXPRO, RPG, CL, COBOL and 2E.
PROVIDENCE ST. JOSEPH HEALTH (Providence Health & Services)
Clinical Information Analyst – Clinical Programs, January 2018 – Present
In charge of the development of reporting and analytics solutions by gathering mainly executive needs, analyzing requirements and recommending appropriate applications.
Lead quality improvement in clinical management (Acute Medicine and Surgery) with strong understanding of the characteristics of data in sources including EPIC Clarity and EDW.
Develop and implement advanced data analysis, data analytics and solutions to support clients.
Identify, analyze and interpret trends, patterns and relationships in complex data sets.
Meet with customers and stakeholders to identify data sources, data manipulation (ETL), and data analysis with coding techniques (VBA) to enable full realization of clinical health / operational data value.
Create functional and approachable data visualizations with automated reporting.
Design and deliver metrics dashboards for team members and leadership.
Strong SQL (wrote custom and ad-hoc queries), Tableau and Excel formulas (PowerPivot/DAX).
Create appropriate databases from multiple data sources including the electronic medical record, as well as survey, patient-entered data, hospital, and health plan data.
Demonstrated ability to clearly and concisely communicate ideas, facts, and technical information to senior management, as well as other internal/external customers both verbally and written.
MMIS Data / Business Analyst – Supply Chain Data Analyst, October 2015 – January 2018
Supported Infor/Lawson access for the supply chain ERP modules. Managed third party vendor ordering access. Managed, developed, and distributed recurring/on demand reports. Liaison among business groups for SharePoint Portal process. Hands-on Data Analysis for Supply Chain productivity (REH group).
Automated time saving workforce daily process with substantial savings (Backup Data Mine Order).
ETL work in TOAD data Point, used MS Access creating tables and linked to Tableau desktop for Visualization.
Researched, interviewed internal customers / end-users, stakeholders to understand customer / end-user requirements.
Performed analysis and presented results using SQL, MS Access, Excel, and Visual Basic scripts.
Developed data integration solutions (MS Access to Oracle) across multiple applications.
Served as a liaison to support IS requests for third party vendors.
AP and Ad hoc Reporting. Ran specific Jobs e.g. AP252 (Unmatched Invoice listing).
Trained staff on TOAD (Automation), MS Excel (add-ins, DAX), writing Macro’s (VB) and Infor/Lawson (Access support).
Researched and problem-solved to provide accuracy and timeliness of all REH with analysis and reporting (Complex SQL coding and SSRS).
INTEL CORPORATION March 2015 – July 2015
Data Analyst (BI) / Developer (Contractor)
PowerPivot/Excel Data modeler. Designed and enhanced the structure of the data model, resulting in the QA Dashboard xls working with static table of HSD tickets.
Improved project QA Dashboards by making them show ASIC and Custom quality for F7** projects.
Optimized performance of PowerPivot model identifying the best ways to improve performance.
Time performance for Dashboard went down from 5 minutes to 3 seconds.
Added DES DA env release data to the NGS (Next Generation SPEED) DB and generate reports for DES DA planning (SSIS).
Implemented the QA data model using PODS for measures and cube for performance (SSAS).
SUNQUEST INFORMATION SYSTEMS June 2010 – August 2014
Application Support Specialist
Remote Technical Support of the PowerPath application, modules and Epic via direct connection to customer environment servers or interactive sessions with clients.
Triaged system, performance, databases, connectivity (basic understanding of TCP/IP and networks).
Performed QA testing of new software versions and to file bugs.
Provide training on PowerPath Client and systems. Provide ad hoc reporting using SSRS (BI), SQL Script code and Crystal Report design.
CARECENTRIX June 2009 – September 2010
Data / Reporting Analyst (BI)
Extracted, transformed and analyzed large sets of data, designed reports, databases and dashboards based on user requirements. Excel, Flat file reformat, and cleansing to load it into another database in timely and efficient manner.
Conducted system analysis recommendation and application modification to support business. Strong Excel, Access, SQL and quantitative data management with analysis skills.
Managed, analyzed, migration and data maintenance (to insure data integrity by writing Quality Assurance queries which vary from simple to complex that are run on weekly basis).
Helped re-engineer reporting processes for greater efficiencies across all business units.
Defined and cleansed data from various sources to present data in easily readable reports using MS Access and MS Excel.
Wrote complex SQL sub-queries, views as part of several projects in the automation process of reports.
Created ad hoc reports using SQL, imported / exported data between several environments / databases.
Assisted in the evaluation and error detection of data in the data repository creating ODBC data source.
Built Access dbase, using Salesforce.com Administrator applications for mapping and deployment of data into Salesforce database.
CERIDIAN CORPORATION 2008 – 2009
SQL Developer – Production
Created and troubleshoot complex T-SQL and PL/SQL queries and stored procedures. Designed, coded, and deployed reports (using SQL Server 2005 Reporting Services). Sorted, merged, imported / exported between databases and with production support of batch job processes. File Manipulation Requests, First Letter configuration issues. Implemented change requests. Ran internal audit queries and daily ad hoc reports (using SQL and Oracle scripting).
Developed strategies for enhancement of report procedures through research / analysis for efficiency.
Designed month-end, weekly election packets report that formatted into readable Excel files.
Supported in the resolution of system problems, GPA Processing, NH notices and invoice Oracle cases.
Proactively generated reports with recommended improvements/new requirements for business processes, operational procedures, methodology development, data modeling client’s corresponding reporting structures.
Installed patches, restored data, created CUSPs and routines to achieve best practices.
UNIVERSAL HEALTH CARE GROUP 2004 – 2008
Projects in Medicare and Medicaid (OE, Claims and Quality Assurance process). Developed optimized stored procedures to solve complex problems in SQL. Tuned dbases for peak performance (Spool Operator); implemented scripts in PL/SQL.
Wrote VB macros, then integrated or run in Excel that had to correct results from SQL scripts.
Dbase coding for business applications Sybase T-SQL, clipper.
Maintained descriptions / documentation of application configuration including tracking, documenting changes to environment.
Transitioned from Excel, Access and crystal reports to SQL.
Prepared unit test plans, execute unit testing, participated in system user acceptance testing tasks.
MEDICO ENGINEERING CORP. 2001 – 2004
Developed, maintained applications in support of computer processes design and implementation. Provided high-quality analytical and problem-solving skills, assessing possible systems impacts and recommending technical solutions on computers and software.
Created production ready software focused on security, quality, performance and costs.
Coordinated the implementation of new/modified programs. Analyzed logic to determine best method of accomplishing required changes.
Customized and trained individuals in the daily operation packages (integrated with each other).
Organized, setup, configure company’s software. Coordinated company’s advertising / marketing, and test systems.
Converted and designed database interfaces. Built labels, logos, business cards and brochures.
Master of Science – Computer Science (MS), University of Auckland
Bachelor of Science – Computer Science (BS), University of Technology
Volunteer, AOET-USA, 2019
Zenger Farms, 2016