Intelligence Analyst Database Administrator

RESUME

SRIYANI SARAM EPIC &

**** ****** ***** ** • High Point NC, USA • 336-***-**** • ************@*****.*** Senior Business Intelligence Analyst

EPIC ~ SAP Business Objects ~ Power BI ~ SSRS ~ ServiceNow ~ Tableau ~ Crystal ~ Oracle ~ ETL ~ Data Warehousing EPIC and SAP Certified Senior Business Intelligence Analyst with over 20+ years of experience in consultative, contract, and independent projects creating highly polished, tightly integrated, maintained consistency with technology and information management operational processes required to deliver more effective services to the business. Strong background in Manufacturing, Government, Health Care and Oil & Gas industries. Skilled at applications system analysis and increasing productivity by identifying gaps that lead to a measurable improvement and creating sound technical infrastructures through development, implementation, and management of advanced systems. Adept at designing IT solutions that give users more power with less complexity. Coaching and mentoring junior developers. Well suited to positions requiring strong leadership and technical skills. Highly knowledgeable of IT Project Management. Skilled problem solver with a passion for simplifying business processes utilizing technology transparent to the business. Fluent in English. Available for travel if needed. Areas of Expertise Include:

EPIC and SAP Certified

EPIC Certified in (Cogito, Caboodle, Clarity, Inpatient, Procedure Orders) • SAP Business Objects • Power BI • Crystal • SAS • Data Services • Tableau • Database Performance Tuning • Oracle DBA • Data Warehousing • Data Modeling • Applications Development • Team Leadership • Database Analysis Multi-Project Management • Web-based Programs • Performance Management Information Security • Software/Application Testing • Client/Server Support Technology Infrastructure Design

TECHNICAL SKILLS

Programming Languages: SQL, SAS, PL/SQL, T-SQL, JAVA, HTML, XML, C, C++, UNIX Shell, SQR, Visual Basic, Fortran, Cobol DBMS: DB2, SAP HANA, Oracle 7.0, 8.x, 9i, 10g, 11g, SSRS/SQL Server 2005, 2008, Microsoft Access, Operating Systems: Progress9.Unix, Linux, 1 Windows 3.1, Win NT 4.0, Win95/98/2000, MS-DOS Reporting/Analysis Tools: EPIC (Cogito, RW, Dashboards), SAP Business Objects (Information Design Tool, CMC, WebIntelligence, BI Launch Pad, Desktop Intelligence, Dashboards, Explorer, Crystal Reports, Universe Designer) Cognos, Metadata modeling, Data flow diagrams, SQR Internet Technologies: HTML, DHTML, ASP, Java Beans, Java Script, Corba & JSP Data Management

Technologies:

EPIC Clarity, Caboodle, SAP, Data Warehouse, SQL*Loader, EXP, IMP, Toad, Microsoft Office Suite

(Word, Excel, PowerPoint), Visio, Project, VMware, RMAN, Backup & Recovery, Performance Tuning, Scripting

PROFESSIONAL EXPERIENCE

Senior Business Intelligence Analyst, Novant Health, Inc., – Winston-Salem, NC, USA • 06 /2018 – 01/2023 The Novant Health is a non-for-profit organization, operates North Carolina’s largest care system was formed July 1, 1997, by the merger of Carolina Medicorp of Winston-Salem, North Carolina and Presbyterian Health Services of Charlotte, North Carolina. We are integrated system of physician practices, hospitals, outpatient centers and more. We strive every day to bring our mission, vision, and values to life.

Role and Responsibility:

• Support day-to-day service now requests where need any new development solutions or modifications to existing reporting products such as Epic workbench, Epic Dashboard, SQL extracts or Power BI products.

• Design and implement business solutions using EPIC products, such as workbench reports, EPIC Dashboard, CDMs, SQL driven products, Power BI, and other analytic solutions.

• Implement EPIC medical system release updates to ensure workflows and processes are functioning with each epic updates to the system with correct configuration

• Design solution to help organization to provide remarkable patient care more effectively and efficiently RESUME

SRIYANI SARAM • Page 2 • 336-***-**** • ************@*****.***

• Conduct testing in each environment to ensure system work as desire without any failure before the production move

• Responsible for securely managing information system throughout the lifecycle, within the scope

• Gather requirements and understand the business case from the end user perspective

• Understand what sensitive data stored, transmitted, or processed on those information systems Communicate, translate, and deliver business intelligence content across the enterprise

• Design and implement new system solutions using EPIC Cogito Framework, and or other deliverables

• Support the healthcare system to ensure the organization is having the necessary support as they needed within the healthcare system

Major Projects – Epic SDoH Coordinated Care in Market Areas (Charlotte, Rowan, Forsyth) Currently there are high demand on community health worker within the Novant Health market area. Having access to patient data or how to manage the service in the community become an important factor. This project helps to identify the issues and give proper guidance solutions.

Key Accomplishments:

• Delivered successfully EPIC Dashboard that demonstrates the data on each market area

• This solution provided management to better understanding of their own market and take necessary solutions

• The data was on-time driven, directly from the EPIC system

• Provided better patient care to the community and support the patient needs

• Used Agile methodology in the process of development

• Tested and verified the data by using SSRS to ensure the accuracy of the data before the production move Major Projects – Patient Survey Data

This group of project evaluates the Survey data based on the patient experience after receiving the care what they need. This helps to provide detail analysis to identify how strong relationship that each patient has, and what to expect in the future. It helps to predict the company growth, and needs etc. Survey has become a very important factor in the business growth. Key Accomplishments:

• Delivered SQL written extracts, and Power BI products to present patient care experiences

• Provided management to understand how we are doing our services to our patients, and the successes as well as the area that need to improve based on the patient comments

• These analytics data help to see the trending in our business on timely manner

• Tested and verified the data to ensure the accuracy of the data before presentations Computer Systems Analyst, TEKsystems Inc. – Novant Health – Winston-Salem, NC, USA • 01/2018 – 05/2018 Major Projects – Survey Answers

Currently there are high demand on the Survey data where most users are having manual effort to produce any reports relating to Survey area. As a solution, we are providing a Universe using SAP Business Objects within the Caboodle Data Warehouse where business can report on Survey data and satisfy the demand. Key Accomplishments:

• Created the Survey Answers Universe using SAP Business Objects under Caboodle Data Warehouse

• Applied the security layer to the appropriate user group

• Completed the testing under POC using SSRS to ensure the accuracy of the data

• Currently released to UAT for user testing

Computer Systems Analyst, TEKsystems Inc.–Volvo Group – Greensboro, NC, USA • 02/2016 – 12/2017 The Volvo Group is one of the world’s leading manufacturers of trucks, buses, construction equipment and marine and industrial engines. We also provide complete solutions for financing and service. We are close to 100,000 colleagues and our plants in more than 20 countries and sell our products in more than 190 markets. Role and Responsibility:

• Gathering the requirements, understand the business case from the end user perspective RESUME

SRIYANI SARAM • Page 3 • 336-***-**** • ************@*****.***

• Research and do a gap analysis on the system process, tools, and data what’s available to satisfy the solution deliverables

• Based on the research gap analysis, provide a solution estimation plan for management approval

• Responsible for capturing the relating information and manage tasks by communicating with responsible party

• Prepare necessary documents to fulfill the requirement in detail levels

• Provide technical knowledge to appropriate team to act on specific task what takes to fulfill each task either on ETL or Universe changes or directly relating to database issue or to the management support

• Implement the solution by prioritizing, planning to the user expectation

• Provide the right reporting tool solution either on SAP Business Object / Power BI

• Develop Reports / Dashboard and Execute UAT or Pilot testing

• Provide the security solution and plan the deliverables accordingly, and support guidance or training on the solution Major Projects (I) – Mack Operational Reporting (MOR) The project purpose was to provide District Managers with easy access and accurate information to their Dealer visit. Previously they had to go through several systems and pull the information and generate the reports, which was very time consuming, and the accuracy of the data was unsure.

Key Accomplishments:

• Designed and delivered an SAP Business Objects 4.x solution

• Automated daily refresh report link to the user’s inbox based on their own Region

• Applied security measure within BO where everyone’s information can be access securely

• This solution mainly provides with one shop painless solution with easy access in more effective way to fulfill their duty

• Contains 17 different reports for all subjects’ areas with information levels of summary and details

• Provided UAT testing and data validation

• Currently it has been roll-out to all the District Managers within the USA and Canada Market Major Projects (II) – Head Quarter Operational View (HQMOR) The purpose of this report was to provide VIP and upper-level Managers to access the data on daily basis. It provides data for all subject area including Quote, Orders, Inventory, and Retails to give wealth of information to their operation within the business. Key Accomplishments:

• Designed a similar setup as MOR with an SAP Business Objects 4.x solution

• Included more KPI’s with more complex logics and wealth of information has been delivered on this report

• Provided UAT testing and data validation and scheduled daily refreshed reports directly into their inbox

• Assist with Business Objects Administration in setting-up the distribution solution with secured access to the data

• It has been roll-out to all the VIP and higher Management within the USA and Canada Market Major Projects (III) – Microsoft Power BI / Qlik (POC) Volvo Connected Vehicle Team has identified the need to make fleet data available to their Sale and Service team in reliable way and in near real time to improve the relationship with customers. Having data-driven conversations instead of engaging discussions based on impressions of both sides.

Key Accomplishments:

• Participate with Microsoft in building Power BI cloud base solution

• Supporting to select on the correct tool set compared to Qlik and Power BI

• Coordinate, setup meetings and communication

• Perform UAT test on Azure

• Explore into Data Lakes and Data Service Analysis

• Explore into Machine Learning

• Provided feedback on the outcome

Major Projects (IV) – ORDM Database vs. BCS Financial System Data Validation Every month our Marketing team is reporting data to our competitors and the supporting information involved several parties in each month. Manual process and was very inconvenient. The big question was to identify if the numbers are matching in our both production system and the financial system (BCS). This was done to verify the accuracy of the data and to gain the trust in our data RESUME

SRIYANI SARAM • Page 4 • 336-***-**** • ************@*****.*** Key Accomplishments:

• Completed a Gap analysis in both systems based on the process and the data availability

• Reduced the manual processes by improving the process to achieve the results with one truth

• Validated both ORDM (Production Database) and BCS financial system

• Provided solution BO report to run at every end of month to identify the data where the validation can take place compared to BCS data on all business subject areas

• Proven confidence in our data accuracy to the management Other Projects – Automated Manual Processes

There are many area users were running extensive manual processes in every day, week, or month. Identifying those areas and bringing them into the automated process as well as save time and money in area was the gain on these focuses Key Accomplishments:

• Gathered requirements and provided analysis solutions

• Improved the process by automating with easy access

• Used SAP Business Objects to produce necessary reports

• Assist with secure access level with Administration

• The end results driven with strong customer focus to achieve their goals Consultant, Quartech Systems – Insurance Corporation of BC (ICBC) – Vancouver, BC, Canada • 04/2015 – 12/31/2015 The Insurance Corporation of British Columbia (ICBC) is a provincial crown corporation in British Columbia created in 1973 by the NDP government of British Columbia. The original purpose of ICBC was to provide universal public auto insurance in British Columbia.

Major Projects (II) – BC Services Cards II (ICBC)

BC Services Card II project was implemented with a central data warehouse using agile methodology. It was designed under DB2 database and using SAP Business Objects BI Platform 4.1 SP 5 for front-end tool. Used SAS to create datasets and to provide data analysis from multiple sources. This project was responsible to deliver several major reports to help the ICBC Driver License Provincial Programs and the Driver License Support Services Departments to monitor the production of BC Driver Licenses, BC Identification Cards, Enhanced Driver Licenses/Identification Cards, and BC Services Cards. Key Accomplishments:

• Designed star schema Universe using Information Designed Tool within SAP Business Objects and developed required report deliverables using SAP Business Objects Web Intelligence 4.1.SP5 successfully at a given timeline using an agile methodology.

• Due to the large volume of records, ensured the performance of the reports and applied performance tuning. As results, those reports were able to run within seconds which was a big plus to the project and added smile on business and the confidence of the project continuation.

• Created datasets by using SAS for data analysis and for the validation of the data before the implementation into the new environment in order ensure the statistics of the data

• Applied business logic based on the SAS code and converted them into SQL Code to validate data accuracy

• Executed SQL Codes within the DB2 and analyzed the measures accuracy

• Implemented those measures in SAP Business Layer which available for SAP Business Objects reporting

• Planned and ensure the promotion completion from Development environment to QA Environment and to PROD Environment

• Ensured the accuracy of the data and the presentation of the reports are acceptable to the business

• Client interaction, identified the requirements, gap analysis, and ensured as per the scope of the project’s deliverables

• Ensured the security and the end user accessibility of the final products as well as the version control within the CMC

• Setup automated daily scheduling to meet the business requirements within the BI Launch Pad

• Documented all deliverables within the project for the future use and transfer knowledge for Business Insight Major Projects (I) – Business Insights Projects (ICBC) Business Insights Projects was involved day to day operational reporting requirements within the ICBC. Any new, enhanced, or existing reporting requirements are handled in this project. Key Accomplishments:

• Designed, developed, and implemented driver licensing regional reports using SAP BI solution under SAP BusinessObjects Web Intelligence

RESUME

SRIYANI SARAM • Page 5 • 336-***-**** • ************@*****.***

• Ensured the accuracy of the data and the presentation of the reports acceptable to the business

• Involved executing the promotion plan from development to production as well as having end user interaction to ensure the smooth process

• Ensured the security and the end user accessibility of the final products within the BI Launch Pad

• Setup automated scheduling to meet the business requirements Computer Systems Analyst, TEKsystems – Client: BAYLOR COLLEGE OF MEDICINE – Houston TX, USA • 03/2014 – 12/2014 Baylor College of Medicine in Houston is recognized as a premier health sciences university and is known for excellence in education, research, and patient care.

Role and Responsibility:

• Support utilizing standard tools SAP BusinessObjects, Tableau, and Crystal Reports to present meaningful data driven solutions within the system, effectively implementing business intelligence solutions to improve operation efficiency.

• Wrote reports and coordinates reporting tasks across all Epic applications.

• Serves as a resource the Epic implementation stall and decides the reporting tools to use as new reporting needs arise.

• Coordinates the project team’s reporting, analysis, and validation process.

• Determines process workflows and implements them across BCM.

• Works collaboratively with other groups across IT, escalating issues to the appropriate teams.

• Monitoring, and troubleshooting Crystal Reports, Tableau, and Business Objects business intelligence solutions.

• Supported relational and multidimensional database queries.

• Maintained a high degree of focus on reported issues and works closely with project managers, project stakeholders and College leadership to identify areas with risk potential.

• Ensures implementations are properly tested, approved by affected stakeholders, and documented for support. Key Accomplishments:

• Provided POC based on the current environment gap analysis how business can gain more profit, saving time & money by using current advanced technologies in Tableau or SAP BusinessObjects products that connect to multiple data sources

• Created complex reports by using SAP tools Crystal, BusinessObjects and Tableau visuals based on the user requirements

• Extracted files and created reports for BCM Auditors and help with the process to accomplish the auditing goals

• Identified and created the current master reporting inventory across the Baylor College of Medicine Integration Consultant, GROUNDSWELL GROUP INC. – Calgary Alberta, Canada • 02/2012 – 03/2014 Delivering integrated information management services for businesses. Providing expertise in information management followed by the standards and guidelines.

Integration Consultant, CENOVUS (Client) - Calgary Alberta, Canada Integrated Oil Company with oil sands operations, established natural gas and oil production and a 50 percent ownership in two U.S. refineries

Major Project - DODD-FRANK Act Compliance - (Risk Management) DODD-Frank Act is a regulatory change; therefore, the primary business driver is compliance to avoid penalties. As a result of this project, client will be able to provide, and report related transaction information to be in compliance with the DFA. Key Accomplishments:

• Client interaction, identify the requirements, gap analysis, and ensure scope of the projects and documentation

• Designed, developed, and implemented an SAP BI solution with SAP BusinessObjects universe and Web Intelligence reporting where business can understand and analyze data to fulfill the requirements under DODD-Frank Act

• Ensured the security and the end user accessibility of the final products within the BI Launch Pad

• Automated scheduling and publication to meet the business requirement RESUME

SRIYANI SARAM • Page 6 • 336-***-**** • ************@*****.*** Major Project - HSIR (Health and Safety)

Developed multi source Rapid Mart Oracle database solution to where it captured the health and safety information. Multiple data marts were populated including dimensions, facts, and CDC. Provided Scheduling, Publishing and LCM support within the Admin. Worked on SAP DataServices (ETL), Crystal Reports and SAP BusinessObjects 4.0 as BI reporting solution. Key Accomplishments:

• Identified the requirements, gap analysis, ensured the scope of the projects and provided recommendation

• Worked on ETL process with SAP Data Services from source to Stage to target ensuring the accuracy

• Designed and developed SAP BI solution by providing data marts and SAP Business Objects 4.0

• Worked on SAP BusinessObjects 4.0 Universe, Web Intelligence, BI Launch Pad, Dashboards (Xcelsius) and Analysis

• Provided training on SAP BusinessObjects 4.0 suite (Information Design Tool, WebIntelligence, Crystal Reports, BI Launch Pad and Explorer). The Audience were managers, SBA, power users and end users in total of 40 members within Cenovus

• Participate in project “Go-Live” activities and delivered 100% deliverables within the budget and timeline Integration Consultant, ENMAX Corporation (Client) – SAS, BW with SAP BOBJ 4.0 – Major Project Introduced SAP BusinessObjects 4.0 technology to overcome the reporting backlog requirements by connecting to SAP business warehouse (BW). The new solution was able to reduce the cost and resources and fulfill the requirements in more effectively. Provided SAS solution to interpret data, analyze results using statistical techniques to overcome some ongoing reports. Key Accomplishments:

• Identified the requirements and provided gap analysis and documentation within the budget and timeline

• Delivered separate statistical data solution by using SAS to their part of the critical reporting

• Provided quality products with SAP BusinessObjects 4.0 by connecting to BW

• Ensure the training on SAP BusinessObjects 4.0 within Enmax power users to meet technical solution for their business

• Designed and developed a single source relational connection Universe by presenting Business Layer

• Successfully delivered number of reports including dashboards (Xcelsius) with SAP BusinessObjects 4.0 solution Assistant Manager, Sobeys – Calgary, Alberta Canada • 04/2010 - 11/2011 Sobeys is Canada’s second largest grocery chain and service through their focus on food, innovation, and quality customer service. Key Accomplishments:

• Over watched the inventory, build reports, and aim to achieve day-to-day sales targets

• Managed staff and lead a team of associates to improve sales strategies

• Assisted in the production and presentations of products more appealing to customers

• Communicate and help to build better customer relation that help to achieve company goal SAIT Polytechnic (Southern Alberta Institute of Technology) – Calgary, Alberta Canada • 01/2008-12/2009 Provides specialized technical education courses and degrees for 77,000 students per year. Database Administrator (DBA) - Oracle

Provided oversight and direction for Oracle Data Warehousing, Data Modeling, and Project Management utilizing SQL Server 2005. Installed, configured, monitored, tuned, and troubleshot Oracle databases running on UNIX, LINUX, or Windows platforms. Planned, maintained, security, and backup/recovery strategies. Modeled databases using MS Visio 2007. Key Accomplishments:

• Developed a prototype database for Travel Experts Agency in Oracle 10g.

• Resolved production issues with minimal down time for users

• Served as technical subject matter expert and liaison between client and technical staff

• Created and managed MS Project plans with detailed tasks Business Intelligence Analyst, ReedHycalog (Div. of CAMCO, SCHLUMBERGER, GRANTPRIDECO) – Calgary, AB • 04/2005-10/2007 Develops drill stem technology, manufactures, and sells oil and gas drilling bits. Business Intelligence Analyst (2005-2007)

Provided gap analysis by gathering information based on the business needs to achieve day to day business requirement with most cost-effective solution for major business critical applications and servers. RESUME

SRIYANI SARAM • Page 7 • 336-***-**** • ************@*****.*** Key Accomplishments:

• Supported on day-to-day IT SAP Business Objects requirements from universe solution to BI reporting solution

• Provided solution design based on technical requirements to ensure the business needs

• Worked on IT implementations in scale of smaller to larger development within the Oracle and SAP BW

• Provided gap analysis within the system provided dashboard (Xcelsius) and SAP Business Objects reporting solution

• Provided automated processes to capture field data into oracle system follow by ETL process EDUCATION & CREDENTIALS

Cogito Certified – EPIC, Verona, WI USA

Caboodle Data Model Certified – EPIC, Verona, WI USA Clarity Data Model Certified – EPIC, Verona, WI USA Clinical Data Model Certified - EPIC, Verona, WI USA EpicCare Inpatient Procedure Orders Certified - EPIC, Verona, WI USA SAP Certified Application Associate – SAP, Canada

Database Administrator (DBA) Certificate with Honors – SAIT, Calgary, Alberta Canada B.Sc. in Mathematics/Computer Science – University of Colombo, Sri Lanka

`

Contact this candidate