Raymond Majewski Email & Phone Number

Brentwood, Tn

• Converted a process originally written in R to SQL. The process involved taking data from 2 government agencies, performing statistical analysis on the data, and storing it in a data mart so it could be reported via Tableau. This was a beginning-to-end project that included all ETL, and the Designed and creation of all staging tables and the data mart.• Documented and stored reports scheduled for deprecation.• Updated SSRS reports, stored procedures, and SSIS packages to accommodate new and changing business needs.

Brentwood, Tn

• Establish and enforce technical standards for deliverables of projects.• Design the data warehouse dimensional model• Audit data content in the BI environment to identify opportunities for improvement.• Develop ETL technical architecture.• Modify and develop ETL packages to support the Data Warehouse • Modify and develop dashboards and reports.• Estimate system capacity to meet near- and long-term processing requirements.• Support the development and validation required through the life cycle of the data warehouse and Business Intelligence (BI) systems and provide adequate security• Conduct design reviews of reporting applications to ensure data warehouse consistency

Brentwood, Tn

• Design, create, and populate datamarts for enterprise reporting with SSRS and Logi reports.• Design ETL packages to populate the reporting datamarts.• Write ad hoc queries for data extraction as needed.• Assist in the maintenance and administration of the security model for the enterprise reporting application.

Franklin, Tn

• Developed business reports to support Care Transitions, Wellbeing Direct, and Diabetes Management systems.• Designed, implemented, and documented a reporting database that resulted in report execution times dropping from minutes to seconds.• Assisted in the design of ETL packages to populate the reporting database.• Wrote ad hoc queries for data extraction as needed.

Franklin, Tn

• Developed ETL packages to move data from individual state databases to a multi-state reporting database for a government agency.• Created a table based framework to hold configuration data allowing the client to add or remove components of the ETL jobs without a need to reprogram. The system also includes auditing and error tracking with real-time email notification of errors.• Created SQL and SSIS packages to update data in multiple databases simultaneously in order to address data issues and allow for consolidation of data between databases.

Nashville, Tn

• Designed and developed a Claim & Order tracking process to eliminate 30 to 40 hours per month of manual processing. This involved working with SQL server and XML data in addition to support personnel at the client. • Implemented and validated a system that would automatically drop subscribers that had two claims in 24 months. This system became the model for all other clients. • Reported various enrollment metrics on a regular and ad hoc basis to management groups in Client Services, Finance, Marketing, and Legal. • Utilized querying tools on database data and multiple text files to track enrollment records through the various stages of processing to ensure the data was processed correctly. • Found and reported problems that were causing duplicate and missed enrollment records. • Documented all data systems, reports, and procedures used by the client.

Memphis, Tn

Data warehouse (OLAP) development with SQL Server 2000/2005. Conversion of ODS to data warehouse. DTS, SSIS, SSAS, SSRS, Crystal Reports.

Bartlett, Tn

Provided reporting services and application support using PowerBuilder and SQL Server. Developed the SQL and stored procedures to support the reports and application.

Memphis, Tn

Provided Crystal Reports support for various clients.

Memphis, Tn

Developed sales and inventory reports, using Crystal Reports and Microsoft Reporting Services for a national tire warehouse.

Memphis, Tn

Supported Vantive CRM for the Customer Care Department. Created modifications to the user interface and modified the application to fit the needs of the industry. Wrote Oracle stored procedures and PL/SQL code.

Memphis, Tn

Contract programmer. Visual Basic 6.0

Bsit, Information Technology

Graduated with honors

Aas, Desktop Applications/Component Programing

Activities and Societies: Phi Theta KappaGraduated summa cum laude