Laura Robbins Email & Phone Number

• Create, maintain, document, and optimize stored procedures, functions, inline SQL, database structures, and ETL processes to adapt to changes in needs and requirements• Test coded program routines and makes revisions to eliminate errors• Analyze and document how the business requirements fit into existing systems• Create reports to support the business using T-SQL and SSRS• Develop technical specifications to resolve business client questions, problems, and to address enhancement needs• Translate detail program specifications for complex problems into coded computer instructions• Interface with all IT and business teams to determine/communicate impacts• Troubleshoot production issues, identifying root cause and implement sound technical resolutions in a timely manner• Plan, develop, test and install systems solutions• Integrate, query, and validate data from external sources for input into SQL based databases for client-facing business intelligence tools and internal analysis• Lead the business on EMR data collection, processing, archiving, and distribution • Maintain internal data warehouse and monitor input/output procedures

Rochester, New York Metropolitan Area

Currently working on a project to aid in the reporting of population health that extracts data in real time using SSIS from EMRs (EPIC, Medent, Allscripts), stores data for GRIPA in a SQL database that I built and maintain, and transmits data to 3rd party vendor.• Move member, provider, claims data from EPIC, Medent, AllScripts EHRs in real time to flat files using SSIS• Filter data from flat files to only import subset of members into database using SSIS• Record number of records imported, new records and invalid records• Alongside with SSIS, create SQL databases, T-SQL queries, jobs, and stored procedures to pull member, provider, claims data from EPIC, Medent, AllScripts EHRs• Create monthly jobs using T-SQL Gather GRIPA members from data warehouse using T-SQL• Research EPIC data model to determine source tables and columns in order to build queries• Work with EPIC affiliate to determine workflow and best practice to retrieve data• Document all pieces pertaining to the ETL process, gathering requirements, and various pieces of information using Confluence• Test and debug ETL process • Familiarity with GIT• Familiarity with Confluence

Rochester, Ny

Maintain ETL processes for client data prior to clinical reviewExecute standard reports as requestedCreate new reports to support the business using T-SQL and SSRSSupport client/user management on secure FTP siteCreate RAPS/alternate format submission files for clientsAnalyze data received from clients to ensure it's complete and in proper formatMaintain processes is in-line with CMS announcementsTroubleshoot issues presented by usersCreate process documentation

Rochester, New York Area

Worked with the business to create reports

Rochester, Ny

• Managing & manipulating databases based on the needs of the business• Manipulating data based on Client/Internal needs• Data cleansing based on internal needs• Configured application for panel migration

Rochester, Ny

• Develop SQL configuration standards for new servers• Develop, implement, and maintain change control and testing processes for modifications to databases. • Work with deployment coordinator to push database modifications to test and production environments• Installed and configured 3rd party tool to aid in potential performance issues on SQL servers• Provide support and troubleshooting to end usersusers

Design, install, monitor, maintain, and performance tune production databases and data warehouse while ensuring high levels of data availability. Also, develop, implement, and oversee database policies and procedures to ensure the integrity and availability of databases and their accompanying software.

• Provide 24x7 administration, production support and deployment activities in order to maintain corporate databases using MS SQL 2000/2005/2008• Maintain database performance through scheduled upgrades • Administer database privileges and security policies within corporate standard operating procedures• Provide business systems support and troubleshooting to end users in Transact SQL

Create and maintain databases based on clients needs. These databases were used in the aide of gathering information for market research purposes

Bs, Computer Science

Activities and Societies: SBURFC -- St. Bonaventure University Rugby Football Club Computer Science Department High School Programming.

High School Diploma

Activities and Societies: Cross Country, Indoor Track, Outdoor Track