Sql Server Data Warehouse
Resume:
Kenneth Cevolani
Novato, CA ****7
August 23, 2023
Hello:
I currently hold the position of Senior Business Intelligence Developer within the Verint Corporation. As a Senior Business Intelligence Developer, I am tasked with all aspects of data warehouse design development and maintenance within the MS SQL environment. I am responsible for data modeling utilizing Kimball methodologies, database design, and physical database schema enhancements. I design and develop ETL processes utilizing Transact SQL and SSIS. I am also responsible for the architecture and design of Business Intelligence solutions utilizing PowerBI.
In addition to my SQL Server skill set, I have extensive experience in overall project management, and have been involved in all phases of the software development lifecycle. I consider my database/software design documents, and user documentation to be of the highest quality. I possess excellent oral and written communication skills and have the ability to manage thru multiple priories and or projects. I possess expertise, i.e. 15+ years utilizing the following technologies: MS SQL Server VB.NET, and ASP.NET, Crystal Reports, MS Access, and PowerBI.
I actively collaborate with my colleagues to establish sets of development standards, guidelines, and best practices in terms of database development, version control, code migration, quality assurance, and application deployment.
The accompanying resume provides specific details regarding my career, and project specific particulars.
Thank you for your time and consideration.
Sincerely,
Kenneth Cevolani
Kenneth Cevolani
14290 Skislope Way
Truckee, CA 96161
Education
California State University Sacramento, Bachelor of Science, Computer Science Concentration, Software Engineering
Technical summary
MS SQL server 6.5-20xx, MS SQL Server administration, MS TSQL, query optimization and performance tuning, SSIS package design and development, MSAS OLAP design and development, dimensional data modeling utilizing Kimball methodologies, MS Access, VB.NET and ASP.NET, Java Script, HTML, Crystal Reports, MS Office suite automation, BI development utilizing Power BI, superb oral and written communication skills, highly skilled at overall project management, requirements gathering, the writing of technical and functional specifications and users guides.
Experience
January 2021-Present Verint Corporation, Senior Business Intelligence Developer
As a Senior Business Intelligence Developer, I am responsible for all aspects of data Datamart design development and maintenance within the MS SQL server environment, supporting Verint’s Interactive Virtual Assistant (IVA) Data analysis and KPI data gathering activities.
The IVA DataMart was designed and architected utilizing dimensional data modeling techniques based upon Kimball methodologies. I also design, develop and maintain all ETL processes into and out of the IVA Datamart utilizing SSIS and TSQL. All ETL processes are fully automated and perform at a 99% daily success rate. From an operational perspective I support each of the automation processes and intervene to troubleshoot issues should they arise.
In addition to my SQL development efforts, I am also responsible for the design and development of BI solutions utilizing PowerBI. The dashboards built expose IVA analytic and KPI data to both internal and external facing clients.
Lastly, I am responsible for the publication of design/requirements documents, user guides and operational SOPs.
May 2017-September 2020 Crimson Wine Group, Senior Business Intelligence Developer
As a Senior Business Intelligence Developer, I was responsible for all aspects of data warehouse design development and maintenance within the SQL 2016 environment. The data warehouse and each of the data marts it contained were designed and architected utilizing Kimball methodologies. I also designed, developed and maintained all ETL processes into and out of the Crimson Data Warehouse and each of its data marts utilizing SSIS. Several of the ETL processes interface with external vendors, the internal ETL processes interfaced with the Crimson NAV ERP platform (Microsoft Dynamics) and the BOARD BI platform. Each ETL process was fully automated. From an operational perspective I supported each of the automation processes and intervened to troubleshoot issues when they arose.
In addition to my SQL development efforts I was also responsible for the design and development of BI solutions utilizing the BOARD BI development platform and Power BI. The BOARD platform supports the development of multi-dimensional databases and cube structures. These databases and cube structures are the building blocks from which reporting and analytic capability was created. This capability consists of reports, dashboards and visualizations.
I was also tasked with documenting and implementing an approach to migrating the Crimson on-premise SQL server to a cloud based Azure SQL server. I successfully implemented Phase I of this strategy where the on-premise data warehouse schema and data model was migrated to the Azure SQL server environment and a nightly data synchronization process was developed utilizing Azure Data Factory to copy the on-premise data to the Azure SQL server.
I also managed the Crimson Master Data Management program where non-ERP data was captured via .NET forms that I designed and developed. This data was placed into a SQL staging database where on a nightly basis it was merged with ERP data and moved into the BOARD BI platform.
Lastly, I was responsible for the publication of design/requirements documents, user guides and operational SOPs.
Feb 2011-April 2017 First Republic Bank, Senior Data Warehouse Developer
As a Senior Data Warehouse Developer, I was responsible for all aspects of data warehouse design development and maintenance within the SQL 2008 environment. The data marts within the data warehouse were utilized by the banks BS/AML compliance team for reporting and analysis. In addition to my data warehousing design and development activities I was also tasked with leading the ETL team to design develop and deploy feeds into our vendor supported compliance tool (Actimize). These ETL feeds were designed utilizing SSIS and fed the Actimize application with customer and transaction data to support regulatory compliance and reporting functions required by the FDIC. I was also responsible for developing and maintaining the documentation to support each phase of our development activities throughout the SDLC process.
Mar 2004-Jan 2011 Foster’s Wine Estates, Senior Data Warehouse Architect
As a Senior Data Warehouse Architect, I was tasked with all aspects of data warehouse design development and maintenance in support of the Foster’s Wine Estates retail operations i.e. Wineries, and Wine Clubs. The primary focus of my role was data modeling and the creation of ETL processes that consolidated and aggregated data from various OLTP systems, and the Foster’s Wine Estates JD Edwards ERP system. All of my query design and optimization was performed within the MS SQL 2005, or 2008 environments, utilizing TSQL, and SSIS. I was also tasked with the design and development of ASP .NET applications which exposed warehoused data to each of the retail sites, and to each of the eight Wine Club Managers I supported. Each of the ASP .NET applications I designed and developed made use of the Crystal Reports 11 SDK object model to aid in the design and development of custom user interfaces to support reporting functionality that was custom tailored to each of the business units I supported.
July 2001-Feb 2004 TransWorld Systems Inc., Technical Team Lead/Lead Database Developer
Led team of four developers who were responsible for supporting and enhancing the ONYX CRM system utilized by TransWorld Systems. The ONYX CRM system was used to track and manage customer accounts and orders. The ONYX system was built utilizing the following technologies: MS SQL Server 7.0, MS Access 2000, Visual Basic 6.0, and ASP 3.0. I was responsible for the design, development and enhancement of the ONYX system Visual Basic components and ASP pages. I was also responsible for the design and enhancement of the ONYX system data model, data dictionary, and physical database schema. Additionally, I functioned as the ONYX system Database Administrator, where I was tasked with database tuning, designing ad-hoc queries, and resolving data integrity issues. I created and maintained all ONYX system database feeds i.e. data imports and exports, and created, managed, and monitored all nightly database maintenance jobs. I was also responsible for, or managed TransWorld’s report creation and generation processes.
Aug 1999-July 2001 Fair, Isaac Corporation, Senior Software Engineer, Component Application Development
One of 20 Software Engineers responsible for supporting and enhancing the Fair Isaac Decision System (FIDS). FIDS is a decision engine and application generator that enables users to create, configure, test and deploy decision strategies to either mainframe, NT, AS 400 or UNIX platforms. FIDS was built utilizing the following technologies: Visual C++/COM, MS SQL Server 2000, and Visual Basic 6.0. I was responsible for the design, development and enhancement all FIDS Visual Basic components. The majority of my time on this project was spent making major enhancements to the FIDS Excel interface. The FIDS Excel interface allows users to create and send transactions to the FIDS runtime service for processing via an Excel add-in written in Visual Basic. I was also a member of the team that was tasked to prove XML & the Web could be used to communicate with FIDS. I was responsible for the design and development of the FIDS XML input/output documents and schemas. I wrote a Visual Basic COM component to translate an XML input document into the FIDS input streams, gathered FIDS output results, and created the XML output document which was sent back to the client web page.
Feb 1998-July 1999 Fair, Isaac Corporation Senior Software Engineer, Windows Product Development
One of 12 Software Engineers tasked to design and develop the Sierra Credit Application Processing System. The Sierra System is an N-Tiered transactional Client Server based system, designed to run in the Windows NT environment, utilizing the following technologies: MS SQL Server 7.0, MSMQ, MTS, Visual Basic 6.0, C++ and COM. I was responsible for the design and implementation of the Sierra System data model, data dictionary and physical database schema. I was also responsible for populating the Sierra Systems test environment with appropriate test data via SQL stored procedures and Visual Basic using ADO. (Phase I) All data modeling was done utilizing ERWIN 3.5. In addition to my data modeling responsibilities, I also designed and developed the Sierra Systems User Interface for Credit Application processing and queue management. All User Interface development was done in Visual Basic 6.0 and interfaced with numerous server-side COM objects written in Visual Basic and C++. Since the Sierra project was a new development effort, a percentage of my time on this project was dedicated to high level design, UML-based task analysis, use case design, and requirements documentation.
May 1993-Jan 1998 Bank Of America Corporation, Technical Team Lead, Credit Risk Management
Led team that designed, developed and maintained the Risk Monitoring System (RMS). RMS is a worldwide Client Server system used to track and manage the Credit Examination function at Bank Of America. RMS was developed using MS SQL Server 6.5, Visual Basic 3.0-5.0, MS Access 2.0, and Crystal Reports 4.5-6.0. As the RMS Team Lead, I was responsible for managing the assignments of the RMS development team, consisting of four developers. I worked closely with all team members ensuring they had the appropriate level of direction, support, and tool-sets necessary to successfully complete their projects. I established a set of development standards and guidelines, ensuring that adequate change control and appropriate testing environments were in place. I was responsible for version builds, and monitored system rollouts, trouble shooting and resolving any install related issues. In addition to leading the RMS development team, I also worked as an RMS developer in the following areas: User Interface design and development, RMS report design and development, and RMS database administration.
Contact this candidate