Wesley B. Marshall Email & Phone Number

Sugar Land, Texas

• Develop complex ETLs for data warehousing from multiple source systems• Build SSAS tabular data models to generate analytics and reports for various corporate needs• Reverse-engineered large, deprecated SSAS multidimensional model from vendor ERP system and created an in-house solution from scratch to replace it• Design OLAP database solutions for company's project management and financial data• Produce Power BI reports on company financials and project management for C-Suite executives and other levels of management, • Serve as in-house consultant for developers, BAs, PMs, and other key stakeholders on various reporting, data visualization, and data integration initiatives• Manage source control repositories and establish policies for database development lifecycle • Lead code reviewer for all database development• Mentor other members of data team• Design and implement data security solutions and protocols• Serve as interim/backup DBA for all company database servers

Sugar Land, Tx

• Maintained and enhanced robust import/export solution in SQL server to support data needs for company's flagship web application• Directly generated >$50K billable revenue for services rendered managing several custom data migration projects to map client data exported from competitors' systems into CLS application databases• Developed SSIS packages to automate client data integration from various sources• Established data cleansing/validation processes to ensure system data integrity• Responsible for creation and upkeep of procedures to restore production databases from various environments to lower tiers for development and support teams

Sugar Land, Tx

• Maintained suite of SSRS reports to complement company's proprietary web application for land data management• Built and deployed many SQL Server database objects, including procedures, views, functions, triggers, cursors, agent jobs• Wrote, enhanced, and maintained complex T-SQL scripts to build a variety of solutions• Developed dashboard reports for both client-facing applications and corporate employees• Established process for standardizing client estimates for custom service requests• Created indexes and reviewed execution plans to improve system performance• Developed in-house tools for maintaining and deploying reports, datasets, and data sources to report server, incorporating Powershell, .NET, VB, HTML• Configured and administered report portals• Generated monthly client invoicing reports for Accounts Receivable department• Supported ad-hoc requests for various data extracts, analyses, and reports within the corporate office

Weslaco, Tx

• Leveraged SQL Server and SharePoint to centralize all district student achievement reporting• Created database to house student assessment results• Forecasted state accountability performance using VBA/Excel files• Produced Power Pivot reports for self-service assessment reporting• Performed middle tier troubleshooting of instructional data system issues• Generated ad-hoc reports as requested by CEO, Chief of Schools, Chief Program Officer, and COO• Created custom reporting catalog in instructional management system• Led requirements/user feedback sessions with Superintendent, CPO, VPs, and principals to improve district reporting• Trained campus users on SharePoint and assessment management reporting• Worked with Race To The Top grant manager to establish and report against goals and performance targets• Collaborated with assessment team/vendors to improve efficiency for assessment configuration & results reporting

Weslaco, Tx

• Directly managed district office team responsible for student data file submissions to state agencies• Wrote PL/SQL scripts to ensure data integrity for student information system• Generated weekly data quality reports from SQL for gradebook, attendance, enrollment• Proposed and later led project to implement geo-coding of student addresses in our student information system to facilitate bus route planning for Transportation department• Led district-wide class scheduling process for entire district student population• Established and trained campus staff on organizational best practices for data management/entry

Weslaco, Tx

• Oversaw simultaneous setup/implementation of new computer labs and independent reading rooms at 10 campuses for start of '11-'12 school year• Provisioned personalized learning software user accounts for 8,000 students across 11 different third-party applications

Irving, Texas

• Supported ad-hoc reporting and analytical needs of SVP of HR and Board of Directors• Wrote program to scrape compensation data from third-party applications• Developed compensation file processing procedures in VBA• Created models to simulate various executive compensation plans• Built Excel performance evaluation tool used by every manager company-wide• Established Human Resources Sharepoint site and administered site security• Collaborated with IT to plan, test, and implement new system configuration and custom development• Project contributor and tester for company's ERP migration to SAP• Generated company-wide government compliance reports from scratch for 200+ US locations

Dallas, Texas

• Performed various administrative HR and benefits functions for multiple clients, including Sara Lee and Dr. Pepper/Snapple. • Created spreadsheets to generate calculations for insurance benefit payouts.• Established and improved processes for sorting and filing documents.