Melissa Roche

Melissa Roche Email and Phone Number

BI Developer / Data Architect / DBA / ETL Developer @ Oklahoma Farm Bureau
Shawnee, OK, US
Melissa Roche's Location
Shawnee, Oklahoma, United States, United States
Melissa Roche's Contact Details

Melissa Roche personal email

Melissa Roche phone numbers

About Melissa Roche

Professional Summary I have over 24 years experience as a Crystal Reports Administrator/Developer with over 24 years experience working with SQL Server, Data Modeling and Data Integration, and Data Design. Highly motivated to achieve the best possible result for my clients, I'm known for my attention to detail and my hands-on approach to management. My intense standards and strong work ethic achieve excellence from my entire department. I work remotely (on-site if needed) until the work is done. My exacting standards do not allow anything less than perfection, with all specifications and tolerances checked and double-checked for complete precision. I'm flexible and open to using new ideas and concepts whenever possible. Seeking new opportunities in Oklahoma. Looking for remote but not mandatory. Open to relocation.

Melissa Roche's Current Company Details
Oklahoma Farm Bureau

Oklahoma Farm Bureau

View
BI Developer / Data Architect / DBA / ETL Developer
Shawnee, OK, US
Melissa Roche Work Experience Details
  • Oklahoma Farm Bureau
    Oklahoma Farm Bureau
    Shawnee, Ok, Us
  • Oklahoma Farm Bureau
    Sr Dba / Bi Developer / Etl Developer
    Oklahoma Farm Bureau May 2016 - Present
    Develop, Create, and Maintain Stored Procedures in SQL 2019/2017Develop, Create, and Manage all Reports through Business Objecs Enterprise/ Crystal Reports Enterprise / Crystal Reports XIManage and Maintain all users in Crystal Management ConsoleCreated and Maintain documentation of all Crystal Reports XI/Crystal Reports EnterpriseImplemented a new blasting application (Visual Cut) to work with Crystal XICreated/Maintained all .bat files for Visual CutManaged all aspects of Visual CutCreated and Maintain documentation of all SQL 2019/2017 proceduresDevelop, Create, and Manage SSRS through Visual Studio 2019/2017Develop, Create, and Manage all SSIS through Visual Studio 2019/2017Build .rpt for IMIS reportingDevelop, Create, and Manage all Stored Procedures, Indexes, Security, Jobs in SQL 2019/2017
  • University Of Texas Health Science Center At San Antonio
    Data Architect
    University Of Texas Health Science Center At San Antonio Aug 2009 - Apr 2016
    San Antonio, Tx, Us
    Manages the design and development of IS databases and OLAP Cubes. Oversees contributions by Systems, Operations, and Technical Support to develop and improve databases and cubes. Guarantees the performance integrity and quality of databases and cubes. Controls system capacity for existing requirements and plans for future needs. Design data architectures and build rational databases.Develop strategies for data acquisitions, archive recovery and implementation of databases. Translates business requirements to system specifications and highlight opportunities for re-engineering to improve efficiencies. Write documentation, including data standards, procedures and definitions for the data dictionary ('metadata'). Communicate and collaborate with the Decision Support and Finance team members to develop and manage Microsoft SQL Server applications while insuring high levels of data integrity and availability.Schedule and monitor SQL Server jobs.Build and maintain scheduled data sets, fact tables, and dimension tables.Develop, schedule, maintain and monitor ETL's (Imports/Exports), using SQL Server SSIS and DTS.Address issues of Data Migration/Validation. Responsible for data analysis, data migration, data modeling, data integration, data warehousing, and database design. Responsible for hands-on support of implementation and on-going support, detailed functional testing of software upgrades, enhancements and maintenance releases.Design, Develop, and Manage all, aspects of Visual Cut.Manage all security within SharePoint.
  • Sirius Computer Solutions
    Crystal Report Administrator
    Sirius Computer Solutions Sep 2007 - Aug 2009
    San Antonio, Texas, Us
    Develop, Create, and Maintain Stored Procedures in SQL 2000/SQL 2005 to build with our Crystal Reporting platformDevelop, Create, and Manage all Reports through Crystal Management ConsoleManage and Maintain all users in Crystal Management ConsoleCreated and Maintain documentation of all Crystal Reports 10Implemented a new blasting application (Visual Cut) to work with Crystal 10Created/Maintained all .bat files for Visual CutManaged all aspects of Visual CutCreated and Maintain documentation of all SQL 2000/SQL 2005 proceduresCreate DME calls out of LawsonWork with our Lawson Administrator to implement new processes for our Crystal Reports with the Lawson 9x conversionConverted all of our Lawon 8x Crystal Reports for the Lawson 9x conversionWorked side by side with our QAC Department to convert all Siebel Reports to our new CRM (Oracle on Demand)Develop, Create, and Maintain Oracle Reports through Oracle on Demand Report Writer
  • Rainmaker Systems
    Reporting Administrator
    Rainmaker Systems Jan 2007 - Sep 2007
    Develop, Create, and Maintain Stored Procedures in SQL/Oracle Responsible for the creation of Reports in Crystal Reports XI/Crystal Enterprise/Business ObjectsImplemented a new blasting application (Visual Cut) to work with Crystal XI ReportsCreated/Maintained all .bat files for Visual CutManaged all aspects of Visual CutDevelop standard processes for proactively monitoring the enterprise reporting system. Identify issues related to the enterprise reporting system and then escalate proactively. Work with production systems DBA's, system administrators and other technical resources to maintain and/or install reporting-related systems and software upgrades. Participate in Client Integration activities to incorporate new business requirements into the enterprise reporting system from the data warehouse and enterprise reporting perspectives, as well as client data loading perspectives
  • Lower Colorado River Authority (Lcra)
    Customer Service Support Analyst/Database Administration
    Lower Colorado River Authority (Lcra) Jan 2005 - Jan 2007
    Austin, Tx, Us
    Database Design, Maintenance, and Development Develop, Create, and Maintain reports in Crystal XI Reporting / Business ObjectsManage and Maintain Virtual Ticket & Job Manager Create Forms and Reports in Virtual Ticket Complete Daily/Weekly/Monthly Reports for Corporate Implemented a new blasting application (Visual Cut) to work with Crystal XICreated/Maintained all .bat files for Visual CutManaged all aspects of Visual CutCommunications & Customer Service in Access, Excel, and Crystal Reports XI ReportsProvide full support for Virtual Ticket & Job Manager to EmployeesMaintain Macro Writing/Editing Help in all administration aspects as possible Troubleshoot software applications (Virtual Ticket, Job Manager, Pipeline) Responsible for the creation of Pipelines Reports in Crystal Reports XI/Business Objects
  • Calmco Servicng Llp
    Reporting Supervisor
    Calmco Servicng Llp 1998 - 2002
  • Olympus Servicing Llp
    Reporting Supervisor
    Olympus Servicing Llp 1998 - 2002

Melissa Roche Skills

Databases Crystal Reports Analysis Business Intelligence Database Design Software Documentation Data Warehousing Sharepoint Sql Process Improvement Visio Business Objects Microsoft Sql Server Access T Sql

Melissa Roche Education Details

  • The University Of Texas At San Antonio
    The University Of Texas At San Antonio
    Computer Science
  • New Horizons Computer Learning Center
    New Horizons Computer Learning Center
    Microsoft Sql Server Certifications
  • Austin Community College
    Austin Community College
    Accounting

Frequently Asked Questions about Melissa Roche

What company does Melissa Roche work for?

Melissa Roche works for Oklahoma Farm Bureau

What is Melissa Roche's role at the current company?

Melissa Roche's current role is BI Developer / Data Architect / DBA / ETL Developer.

What is Melissa Roche's email address?

Melissa Roche's email address is mi****@****ail.com

What is Melissa Roche's direct phone number?

Melissa Roche's direct phone number is (405) 523*****

What schools did Melissa Roche attend?

Melissa Roche attended The University Of Texas At San Antonio, New Horizons Computer Learning Center, Austin Community College.

What skills is Melissa Roche known for?

Melissa Roche has skills like Databases, Crystal Reports, Analysis, Business Intelligence, Database Design, Software Documentation, Data Warehousing, Sharepoint, Sql, Process Improvement, Visio, Business Objects.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.