• • Design and development of Alteryx data workflows, ETL processes, SQL queries, and Visualizations of various clinical and non-clinical databases using JasperSoft. Used Jira as ticketing system and Confluence as knowledge base.• Work closely with Software Engineers to provide data mapping/wrangling expertise and Data Scientist by helping to determine/provide data sets needed for analysis.• Solve problems associated with database integration and messy, unstructured data sets.• Provide clean, usable data, research opportunities for data acquisition and new uses for existing data and provide new uses for existing data Development data set processes for data modeling, mining, and production.• Develop reports, dashboards, and other tools for business users.• QA/peer review team members workflows and reports before and after UVT.• AWS Training.

• Converting/Building Crystal Reports to PL/SQL for automated running by Navisite.• Converting and translating SQL queries between Crystal Reports, Access, PL-SQL and T-SQL.• Supports other analysts with coordination, testing, consulting, and completion of enhancements.• Participate in design sessions with HR professionals. • Work with data warehouse for the coordination and completion of Lawson and Workday projects.

- Works closely with the VP, Information Technology to continuously improve and maintain the data domain and architecture of systems and services to support service levels. - The role provides an opportunity to understand, evaluate and streamline the company's core data development support model and will include interactions with business stakeholders as well as key IT personnel. - Knowledge and experience applying advanced and developing new cloud computing data principles, theories, and concepts. - Demonstrates experience with planning, designing, and engineering enterprise class database and data reporting services. Proven ability to lead change across platforms and functional areas using innovative technology solutions. - Design, implement, and support of MSSQL 2016, including some DBA responsibilities shared across IT. - Designs, implements and supports data ETL transfers and nightly scheduling of jobs, including dependencies, error alerting and health reporting as appropriate. - Supports nightly refresh of data warehouse systems and proactively resolves problems or disruptions in these processes. - Contributes to data driven testing framework, which aides in the stability, integrity, and accuracy of all data operations. - Observe the highest level of confidentiality and a “data security first” approach to all management and development activity. - Occasional after hours availability as needed to support projects and escalations - Implement data models and database designs, data access and maintenance plans. - Employs SDLC and ALM concepts, including source control for all code and object changes. - Performs root cause analysis to identify permanent resolutions to software or business process issues. Hands on technical ability managing Microsoft SQL, including SQL syntax, ETL, SSIS, SSRS, Stored Procedures, data warehousing (SCD), and database cloud platforms (Azure SQL) - Development capability for ETL in Visual Studio

• Create new ad hoc reports using T-SQL to evaluate security volume and flow. Tracking new hires/terminations for security process and automating the various processes.• Document and updating Nacho database including data modeling, data structures, data sources, term testing, and reporting.• Lead analyst on reconciling existing reports, gathering business requirements, and documenting data flow.• Create SOPs for a database that automates a variety of data sources and term testing. • Document Audit and Compliance SOP’s. Automate the process for gathering data on security and audit processes.• Review Active Directory for accuracy. • Supervisor of 2.

• Create new ad hoc reports using T-SQL to evaluate volume and flow. Tracking new hires/terminations for security process and automating the various processes.• Database administration for the compliance/security database. This includes daily backups, data manipulation, and programming.• Document database including modeling, data structures, data sources, and reporting.• Part of the Information Security Office to determine termination are processed in a timely manner.• Lead analyst on reconciling existing reports, gathering business requirements, and documenting data flow.• Create SOPs for a database that automates a variety of data sources.• Review Active Directory for accuracy.

• Create, document, and maintain conceptual, logical and physical data models for large size or high complexity projects. Reverse engineer source system data structures for model sourcing using ERwin. • Convert logical data model into first cut physical database models and coordinate generation of DDL with Data Base Administrators (DBAs).• Interrogate data in existing databases using TOAD to facilitate mapping data structures.• Participate in data architecture sessions and promote integrated systems and controlled data redundancy.• Determine data needs of the enterprise as well as the data needs of the project.• Lead diverse individuals to come to an agreement about the definition, representation, sourcing , and delivery of data• Work with IT application staff to define source-to-target mappings

• Manage and create reports using T-SQL to evaluate membership volume and metrics for internal and external needs. This includes requirements gathering, validation, and testing.• Lead analyst on reconciling member data to identify gaps in care, procedure ratios, and volume metrics.• Perform detailed business and data requirements gathering, analysis, and process and data flow diagramming for processes of moderate complexity, considering the relationship between processes. Identify risks and multiple solutions. • Evaluate and test programs, applications, and operating systems to ensure adherence to operational specifications. Monitor system and business functionality and performance. Document and track product defects. • Provide a formal leadership role in an informal committee who the health plan president is relying on to improve the entire health plan’s engagement as part of her individual performance.

• Identified reporting objectives, meet with end users to determine business goals/objectives, report documentation, translate SQL logic into technical requirements, and report implementation. • Analyzed, designed, and created data mapping of new data feeds from a data warehouse environment.• Extensive use of MS Access in the QA process, testing of new reports, and troubleshooting reports.

• Data reporting analyst used SQL/STAR/QRE to produce ad hoc and recurring reports that met management information needs. Used data models when creating SQL reports.• Identified reporting objectives, contacted end users to determine business goals, report documentation, and report implementation.

• Developed new ETL code/procedures and supporting existing procedure using Monarch Data Pump. The ETL tool is used to extract, transform and load data from multiple systems, transmit data to various internal/external recipients and into Access data warehouse system in a secure manner. • Designed data feeds for a business intelligence system, data warehouse system, and numerous external FTP processes. Used the snowflake schema to identify the data that was to be imported into the business intelligence system. Used dimensional modeling in creating the data warehouse system.• Data reporting analyst used K-SQL/STAR/QRE to produce one-time and recurring reports that meet management information needs. Used SQL queries to evaluate data and determine if the data matched business requests.• Database administrator for the McKesson’s STAR Vista system. • Full life cycle development of database programs using Monarch and Access to automate analysis, scorecards, tracking, work lists and benchmarks. This included creating data models to document data relationships, designing the databases, implementation, and training.• Project manager for numerous customer projects. This position requires identifying project objectives using healthcare knowledge, working with change control procedures, Visio data modeling, coding, testing, training, implementation and working with high level management to meet business goals.• Transformed sizable system generated reports, including complex reports with headers, footer and multiple sort levels into usable data using Monarch report mining features.

Responsible for downloading reports from the main billing system, import into Monarch and then export them into Access. I would perform queries, manipulate data, created databases and created needed financial reports.