Michael D. Ceranski

An information technology professional with a strong blend of leadership skills, technical depth and business acumen. My passion for technology combined with a strong understanding of key business concepts allows me to bridge the gap between the Business and Information Technology worlds.

Technical Skills

• Programming Languages >> Microsoft Visual C#, Visual Basic.NET, Silverlight, AJAX, ASP.NET, Classic ASP, PHP, Java, Ruby and Borland Delphi (Pascal)
• General >> Microsoft Visual Studio, Business Intelligence Developer Studio, Toad, Visual Source Safe.
• Methodologies >> Object Oriented Programming, Test Driven Design, Agile, Extreme Programming
• Other >> XML (XPath, XQuery, XSLT), UML, Click Once, Web Services, VBA, RMAN, T-SQL, DTS, SQL Server Integration Services, SQL Server Reporting Services, SQL Server Analysis Services, LINQ, Sharepoint, Crystal Reports, HTML, JavaScript, CSS

• Serve a technical lead in the creation of a new .Net based applications, including software architecture, design, coding and team coaching. Hands-on development of all parts of the application: GUI, business object layer, database. Utilized C#, ASP.NET, ADO.NET, JavaScript, SQL, XML.
• Work with clients to address performance problems with in-house applications. This includes a detailed analysis of the application code, the database layer and the underlying hardware in order to determine the root cause of the problem.
• Converted a legacy website written in classic ASP to a ASP.NET MVC application utilizing jQuery, LINQ and SQL Server. During the conversion, the data model was redesigned which required a custom migration tool to be developed in order to transform and normalize the data. 

• Developed web based applications using jQuery, LINQ, AJAX, ASP.NET, MVC and C#.
• Design, implement and develop database schemas. This includes the creation of foreign keys, indexes, views, stored procedures and functions.
• Review all development projects to ensure reliability, effectiveness and ROI. Develop all implementation processes, including estimating process, staffing, implentation, training and post-implementation support.
• Developed several utilities to manage and maintain server inventory for Corporate IT. The applications tracked key components such as: server patch levels, license allocation, application contacts, passwords, disk space and security permissions. A multi-threaded NT Service was developed in order to capture server information by using a variety of technologies such as WMI, SQL DMO and T-SQL. The web front end was developed in ASP.NET MVC and utilized jQuery and AJAX in order to enhance the user experience. 
• Communicated with customers on design principles in order to develop solid and intuitive user interfaces. The process included collecting software requirements, formalizing business rules and auditing existing software packages. The design documents generated served as the blueprint during the implementation phase of development.
• Developed reports using SQL Server Reporting Services. Reports were developed against a variety of data sources which included SQL Server, Oracle and Analysis Services.
• Perform code reviews on software developed by corporate employees. This was done to ensure that source code complies with company coding conventions and standards which enhances source code management and increases maintainability. 
• Converted legacy applications written in classic ASP and Visual Basic into modern .NET applications. Conversion processes often included tasks such as data migration, end user training and report generation.
• Developed an automated performance monitoring tool for SQL Server. The tool consisted of several SQL Agent Jobs which started, stopped and aggregated perfmon counters into a collection of database tables. The collected data was then used to generate reports which were archived on disk. A installer was built so that less experienced DBAs could deploy the application and start collecting performance information without any advanced knowledge of SQL Server or Performance Monitor. 

• Participated in database administration procedures including backup and restore. Created and managed database objects such as tables, procedures, triggers, constraints, indexes, functions, views and user security. Setup replication in order to provide our satellite office with a means of accessing our critical data.
• Developed flagship applications which utilized object-oriented development methods and mechanisms to their utmost, including data hiding and encapsulation, single and multiple-inheritance, polymorphism, etc.
• Developed several database migration utilities that imported data from competitive software packages. During migration, data was transformed and normalized.
• Webmaster of MJWs corporate site and several small project related sites. Sites originally developed in ColdFusion and eventually ported to PHP and ASP.NET with a SQL Server backend.
• Redesigned a behavioral analysis tracking system originally implemented in MS Access in order to provide customers with an enterprise scalable solution. The application was available either as a fully hosted solution ASP.NET solution or as a non-hosted windows form application. A Pocket PC module was also developed that allowed users to collect data in the field and synchronize it to the database when they returned to their office.
• Evaluated third party software packages in order to accommodate various business needs. During this process I acted as the liaison between the vendor and the end users. When problems were identified I would document the issues and escalate them with the vendor until a resolution was found. Once an application was approved by management I was responsible for working with the procurement and infrastructure staff in order to get the solution implemented.

Medaille College

• Master of Business Administration (Magna Cum Laude - 3.85 GPA)

Buffalo State College

• B.S, Computer Information Systems Graduated with honors (3.7 GPA)