Jerry Garza Email and Phone Number

• Hire and retain top talent for needed positions within startups.• Manage, mentor and support the needs of product managers, architects, developers, and analysts.• Develop and ensure team members are following best practices and collaborating cohesively.• Work on various projects for clients implementing interoperability technologies.• Design and develop, and implement Data Warehouses.• Managed and support the implementation of new technologies for change management.• Engage with clients as a Subject Matter Expert on Education data and data standards.• Engage with clients as Subject Matter Expert on the Ed-Fi Technologies (Ed-Fi Data Standard, Ed-Fi ODS, Ed-Fi Dashboard, Ed-Fi Data Warehouse, MappingEdu, MetaEd).• Ensure projects accomplish the deliverables within the scope and on time by working with the Project or Product Manager.• Participate in all development projects to ensure the data architecture guidelines are applied.

• Manage, mentor and support the needs of architects, developers, analysts, product managers.• Develop and implement career ladders, set employee goals along with performance reviews and monitor progression with team members.• Implemented processes and procedures to define company best practices.• Ensure team members are following best practices and collaborating cohesively.• Introduced and implemented new project tracking application along with team utilization practices.• Supported the implementation of new ERP System and integrated with new project tracking and time management system.• Ensure that resources are properly allocated and monitored team utilization.• Ensure projects accomplish the deliverables within the scope and on time by working with the Project Manager or Product Manager.• Participate in all development projects to ensure standards are followed and applied.• Generate and maintain a network to produce leads and support business development efforts.• Developed onboarding plans, training materials to ensure team members ramped up efficiently and proficiently execute on work in a timely manner. Also provided training to instructs managers, supervisors, and workers• Responsible to development and maintain a budget (including P&L) for personnel, capital expenditures, and day-to-day operations.• Reviewed agreements and proposed agreements for ambiguities, inaccurate statements, omissions of essential terms, and conflicts with possible legal prohibitions.

• Managed, mentored and supported the needs of developers on multiple project teams. • Worked on various projects ensuring team members are following standard processes and procedures. • Engage with clients as a Subject Matter Expert with development technologies.• Coordinated the technical deliverables on various projects ensuring the client’s expectations are met alongside the scope, budget, and timeline of the project. • Monitored internal and external developments and partner/client relationships with regard to both the facility managed and the line of business.• Participate in the Agile software delivery process by working closely with engineers, Product Management and Operations team.• Developed and designed MVP products for client needs.

• Managed, mentored and supported the needs of developers on multiple project teams. • Worked on various projects for the Ed-Fi Alliance and clients adopting the Ed-Fi Technology.• Engage with clients as a Subject Matter Expert with the Ed-Fi Technologies.• Coordinated the technical deliverables to the Ed-Fi Alliance and lead multiple work streams to accomplish the deliverables within scope and on-time.• Estimated, budgeted, and forecasted hours for projects completion time.• Used Kanban method and burn-down charts to manage and track project deliverables.• Designed a module to import data in EDI format without losing any critical information and contents of the files.• Performed troubleshooting and solved the client issues pertaining to EDI application.

• Designed and maintained a material management application in MS Access. • Designed and developed a data warehouse in SQL Server to extract data with SSIS ETL packages to integrate ERP cost data with project schedule activities, for forecasting and analytics in SSAS cubes.• Developed Business Intelligence solutions using SQL Server 2005 tools, including Reporting Services, Analysis Services, and Integration Services.• Designed and developed model report packages using Business Objects including Universe design and complex reporting capabilities.• Developed and maintained reporting infrastructure and documented technical specifications.• Designed and developed project field application in SQL Server for the management of project processes.• Reviewed in-progress and completed work for completeness, quality, and adherence to standards.

• Created, edited and performed Debugging on the Stored procedures for the requirement to handle the errors.• Created and edited reports in SSRS from the custom CIS systems and Data Warehouse for Accounting, Sales and Marketing.• Developed custom scripts and stored procedures for data import and manipulation.• Performed various calculations using complex expressions in the reports and created report models.• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).• Employed Filtered Indexes to improve query performance and reduce the storage and maintenance cost.• Improved processes for documentation through further development of the department SharePoint site.

• Created, designed, and maintained corporate databases as well as create and manage custom reports in Crystal, SSRS for Dynamics SL (ERP System). • Created reports for payroll clerks, cost engineers and project managers to view time entry and approve time before it is posted to a project with correct cost accounts. • Created audit reports to see all open purchase orders, items received and pending. • Created custom invoices and invoice detail reports per customer requirements.• Created Accounts Receivable and Accounts Payable Aging, GL Transactions and Payroll transaction reports.• Created custom checks print reporting for individual bank or country requirements. • Supported the migration of a new office from Microsoft Dynamics GP to Microsoft Dynamics SL. • Created GL Transaction posting, Account Receivable Documents, Accounts Payable Documents, and Time Entry reports for the new office.• Created databases for Estimating, Document Control, HRIS system, Materials Management, and Field Tracking.• Performed cost audits, invoice audits, and custom reporting for a 50mw solar field project with a total cost of $450 million. • Maintained budget, costs, and updated schedule performance with standard Earned Value Management system on several EPC projects.• Created and designed a Change Management system, tracking issues, Request for Information (RFIs), Extra Work Orders (EWOs), and Change Orders in SharePoint.• Created automatic processes to update tracking sheets, cost and scheduling reports for projects.• Administered, analyzed, and maintained Oracle Primavera 6 program, database, and reports.• Created and maintained a data warehouse to integrate Dynamics SL, field tracking sheets and scheduling applications using ETL packages, and Analysis Cubes for reporting.• Created reports in SSRS, which is used to connect and query lists and document libraries as well as created and maintained site collections in SharePoint.

Supported Applications Administrator in management of the Dynamics SL accounting programManage Microsoft Dynamics SL Reporting in Crystal ReportsCreate custom reports for corporate departments in Crystal Reporting Services and SQL Server Reporting Services

Create and Maintain Databases Document Control for estimating projectsAided in estimating, scheduling, and cost for projectsSupport to Project ManagersData Analysis and cost audits for projects

• Implemented a Labor Analysis Business Intelligence solution for a national construction company.• Existing data from diverse data sources were consolidated into a uniform SQL Server 2008 database. ETL capabilities of SSIS were used to define imports of data, build scheduling packages, define integration flow, log data error exceptions and orphaned data and to define Database Maintenance Plans and send emails. • Created cubes, dimensions, and business critical KPIs using SSAS representing aggregations hierarchically and using custom groupings, that the company will use to analyze performance. Created MDX queries according to business requirements. • Developed detail and summary reports, line and pie charts, trend analysis reports and sub-reports according to business requirements using SSRS.• Implemented Business Intelligence dashboards using MOSS 2007 Report Center and Excel Services producing different summary results based on user view and role membership. • Created score cards using Performance Point Server 2007 Dashboard Designer that feature executive summary measures for revenue, overhead costs, material purchases, labor and profitability trends for a construction company extracting data from SQL Server 2008 OLAP data source and deployed to SharePoint sites. The dashboards also contain pages to view performance by employee, by region, and by quarter enabling end-users to make filter selections.• Key product areas utilized also include data modeling, SSRS report subscriptions and data driven subscriptions, SSAS analysis services processing tasks, cube processing options and roles.• Studied and reviewed application of Kimball data warehouse methodology across various industries. Worked with data-handling scenarios, such as multiple hierarchies, data-driven KPI goals, sourced either from dimension attributes or fact tables, handling Type-2 slowly changing dimensions. Possess solid knowledge of writing, tuning and optimizing T-SQL queries.