Over 20 years of experience in Enterprise Data Management in the role of developer, modeler, architect, and manager. Extensive proficiency in the planning, design, development and deployment of Business Intelligence, Analytic and reporting environments at the Enterprise and Corporate level. Directed multiple assessments providing analysis of the current state development and a roadmap to future development of a data management program. Organized, goal-oriented, highly-motivated with excellent analytical, troubleshooting, and problem solving expertise.

Manager of Business Intelligence Competency Center @ Work with Program managers, Data Governance leads, MDM leads, Architects as well as Business users to transform emerging business needs into data solutions. Manage team composed of data architects, senior and mid-level ETL developers, business analysts, QA developers as well as closely collaborating with database administrators. • Provide guidance and direction in modeling business domains, creating complex relational databases, data repositories and star schemas that meet project expectations • Lead resources in providing conceptual and logical data modeling services to different business units throughout the Health System • Develop and publish data management standards, policies and procedures, data architecture patterns, naming conventions and data design best practices • Development of data acquisition strategies and processes around data modeling and architecture • Manage department workload and resources to ensure equal distribution of work and that timelines are met • Coaching and counseling team members to minimize and resolve conflicts • Interface frequently with other department managers, directors and executives to keep abreast of their respective environments and data needs • Collaborate with AVP and VP to oversee management of operating and capital budgets associated with analytics, reporting, data warehousing and associated projects • Collaborate with Data Governance Committee to establish data standards, guidelines and policies • Partner with leaders in the Health System’s executive offices, and analytics community to ensure proper planning to address data delivery From February 2014 to Present (1 year 11 months) Data Architect/Lead Business Intelligence Engineer @ Shaped the technical direction of the team to meet the Health System’s most complex clinical analytic challenges. Led and developed strategies for warehouse implementation and data acquisition. • Led architecture and design of data processing, warehouse and analytics initiatives • Collaborated with product management, operations, finance and application leads, to understand and develop business use cases • Managed data design, modeling and deployment of database schemas using ER Studio • Mentored junior and mid-level ETL developers • Established and maintained data structures and database environments to support production and development activities • Defined and designed implementation of standards and best practices involved in modeling, data entities and relationships, and supporting Metadata • Designed the ETL process to ensure optimal data flow, incorporated error handling strategies and unit test cases From March 2013 to February 2014 (1 year) Data Architect / BI Engineer @ Worked with business and technical subject matter experts to develop strategies for data acquisition and collection. Provided strategic direction, guidance and integration of data-related products and services. • Developed and maintained conceptual, logical and physical data models • Identified and analyzed source systems to locate and understand existing subject areas across the enterprise • Worked with business users, subject matter experts and developers to determine data layer requirements. • Designed, developed, implemented and supported ETL processes using SSIS • Developed various SQL Scripts, T-SQL Stored Procedures, Triggers, UDF’s, Views and modified tables for data extraction, transformations and data loads • Database Design using ER Studio and Visio • Expanded existing Data Mart schemas, created and maintained ODS to support business needs From February 2012 to March 2013 (1 year 2 months) Business Intelligence Engineer/Data Modeler @ Strategically designed and implemented BI software and systems, including integration with databases. This encompassed selecting, blueprinting, gathering requirements, designing, and rolling out BI solutions to end users. Designed and modeled star schemas to support reporting and OLAP needs. • Designed Enterprise Data Warehouse using data vault methodology • Analyzed data requirements, conducted data mappings and developed program specifications • Assisted in the design of databases and data warehouses to ensure interoperability with BI solutions • Worked with project managers to ensure that data entry, retrieval, change and delete functions met business requirements • Designed, developed, implemented and supported ETL processes for LMS system • Developed various PL/SQL Scripts, T-SQL Stored Procedures, Triggers, UDF’s, Views and modified tables for data extraction , transformations and data loads • Created various database objects such as Tables, Indexes and Views based on the requirements • Mentored and provided leadership to junior members of the team • Database Design using ER Studio From August 2010 to January 2012 (1 year 6 months) Greater New York City AreaDatabase Engineering Manager @ Managed a team composed of data architects and developers. Led the analysis and specification of major product features, development of databases across one or more product subsystems, coordinating the analysis, debugging, and patch distribution for field issues, design and implementation of stored procedures, ETL processes and writing supporting documentation. • Provided guidance and direction in modeling business domains, creating complex relational databases, data repositories and star schemas that met project expectations • Led resources in developing and maintaining Replication, SQL Server Jobs and SSIS packages • Coached and counseled team members to minimize and resolve conflicts • Collaborated frequently with other departmental leaders and executives to keep abreast of their respective environments and data needs • Developed data acquisition strategies and processes around data modeling and architecture • Managed DBA activities such as Installation, Backup and Restore for MS SQL Server • Performed database optimizations via indexes, SQL Server Configurations, de-normalization • Developed and published data management standards, policies and procedures, data architecture patterns, naming conventions and data design best practices From March 2006 to August 2010 (4 years 6 months) Greater New York City AreaSenior Database Administrator/Developer @ Reviewed logical and/or physical designs of existing databases and oversaw the installation of new databases. Provided technical guidance to developers in the utilization, performance, hardware configuration selection, access methodologies, performance tuning and operating system level security of the database management application and other packages related to database management. • Reviewed client requirements and developing database design and application architecture • Provided consultation on SQL Server to development teams • Administered and secured the production servers • Developed Custom Tailored backup/restore and disaster recovery plans for production servers • Performed Data Transformation from heterogeneous data sources to SQL Server 2000 by writing stored procedures and scheduling jobs • Troubleshot performance issues and fine-tuned database, queries and stored procedures • Wrote code and creating jobs to automate repetitive tasks From February 2005 to March 2006 (1 year 2 months) Greater New York City AreaSoftware Engineer/SQL Database Administrator @ Responsibilities include performing data analysis for database and database conversions, providing second level-support by participating in problem resolution for any escalated Help Desk request, developing and maintaining all applications written in Visual FoxPro. • Provide administration support of SQL Server Databases • Network administrator for windows 2000 servers • Create stored procedures, Triggers, and DTS packages in SQL Server • Lead developer of Point of Sale and Inventory Software written in Visual FoxPro • Lead developer of reservation system designed for Flea Markets written in Visual FoxPro • Development and Implementation of Timeshare Reservation System, Timeshare Sales System and Maintenance Dues System written in MS Access, Visual Basic, VB .Net and SQL Server 2000 • Create financial, Inventory and Statistical Reports using Active Reports or Crystal Reports From February 2001 to February 2005 (4 years 1 month) Miami/Fort Lauderdale Area

BS, Computer Information Systems @ Nova Southeastern University From 1997 to 2000 Jamezy Cesar is skilled in: SSIS, Microsoft SQL Server, Data Warehousing, SQL, SSRS, Business Analysis, XML, Oracle, T-SQL, TFS, HTML, Business Intelligence, Database Design, ETL, Data Warehouse Architecture, Databases, Data Modeling