ALFREDO ESPINOSA DIAZ

Alfredo is a Microsoft Certified Technical Specialist and Microsoft Certified Professional on SharePoint technologies with close to fourteen years in implementing end to end collaboration/portal solutions as well as transactional applications based on Microsoft technologies. His main experience lies in SharePoint Products and Technologies on platforms 2007, 2010 and 2013.He has covered all the project phases, since the analysis to the post production support including the management of teams on projects of this technology. Alfredo has worked extensively on tools such as SharePoint Designer 2007/2010, Infopath 2007, .Net Framework 2/3.5/4, Visual Studio 2005/2008/2010.Net, ASP.net, Active Directory, Project Server and Silverlight as well as languages such as C , Visual Basic .Net and HTML including CSS. He has worked extensively on SQL Server 2005/2008 with good experience in SQL Server Reporting Services SSRS and SQL Server Integration Services SSIS . Alfredo has good communication and interpersonal skills.

TECHNICAL SKILLS:

Languages C , VB.Net, SharePoint Object Model, Visual Basic, Lotus Notes

Web Technologies SharePoint 2007/2010/2013, ASP.NET, JavaScript, HTML, CSS, XM, Project Server 2007

Database SQL SERVER 2000/2005/2008,SQL Server Integration Services

Project Tools Project Professional 2007/2010/2013/Team Foundation Server, Visio 2007/2010/2013

Operating Systems Windows 9X/Vista/XP/7/8/Server2000, Server 2008

GUI Tools MS Visual Studio.NET 2005/2008/2010, SharePoint designer 2007/2010, InfoPath 2007

PROFESSIONAL EXPERIENCE:

Lead SharePoint Developer, Confidential Responsible for establishing the stability and maintenance of the Infrastructure of different portals/applications on SharePoint Platform

Cronos Project

Built for the company, from analysis to implementation and production support. Developed in SharePoint 2007/2013, C , InfoPath 2007 and SQL Server 2005/2008

Responsibilities:

• Responsible for gathering requirements to provide strategic, technological, technical and architectural solutions according to the needs of the different client's business areas with corresponding estimates of time and cost according to the client policies
• Developed project plans and coordinated with the resources involved in the project, obtained the approval of the architecture area, generated the requirements to the infrastructure area
• Responsible for the development, code review and providing technical support to the development team and responsible to obtain the approvals of enterprise architecture and security areas of the client.
• Generated the technical and architectural design of the solutions provided
• Responsible for performing the feasibility analysis and proof of concept of the applications migration to the SharePoint 2013 version.
• Responsible for monitoring and maintaining the stability of the applications in the SharePoint farms
• Co-ordinated with suppliers of third party applications installed in the client company such as WebTrends and QlikView in order to solve all the implementations issues and pending tasks.
• Customization of SharePoint 2007User Interface to meet with the corporative image
• Responsible for analysis and design of the data source scheme, rules, validation, and embedded code of the InfoPath 2007forms both from new and existing forms as needed
• Used CSS and customized application pages using SharePoint Designer 2007/2013
• Modified JavaScript views and master pages. Involved in modifying the portal to maintain compatibility across all the browsers in the market when a new version came into the market, in order for smooth functioning of the InfoPath 2007 forms of the application.
• Developed Web Parts, Event handlers, Work Flows in Visual Studio 2008, C
• Developed console applications to automate recurring processes in Visual Studio 2008, C
• Responsible for the design the Relational database schema and stored procedures related to the requirements in Microsoft SQL Server 2008
• Designed the DataMart Scheme and documented this schema in Visio 2010
• Responsible for modifications as needed of the ELT in order to transferring the information from the relational database to the DataMart database, developed in SQL Server Integration Services SSIS

Environment: SharePoint 2007/2013, Visual Studio 2008, C , SharePoint Designer 2007/2013, CSS, JavaScript, Project Professional 2010/2013, Visio 2010/2013, SQL Server Integration Services SSIS , SQL Server 2008, InfoPath 2007.

Lead SharePoint Developer,

This project is aimed to being a unique access point to find the learning resources of the company.

Responsibilities:

• Generated the Project Plan. Responsible for analyzing and documenting the client requirements and presented the Status Report to the stakeholders of the project.
• Development of Web Parts in Visual Studio 2010, C .
• Development of Reports using SQL Server Reporting Services 2008 SSRS
• Customization of the SharePoint 2010 User Interface to meet the image of the client using SharePoint Designer, CSS, JavaScript.
• Implementation of Forms authentication using the asp membership provider and generated batch processes to upload of information in Visual Studio 2010
• Review of third party packages like Handshake, Lighting Tools and AmreinEngineering to evaluate if are suitable for the project and improve the release time.

Environment: SharePoint 2010, Visual Studio 2010, C , SharePoint Designer 2010, CSS, JavaScript, SQL Server Reporting Services SSRS , Project Professional 2010.

Lead SharePoint Developer,

Worked as a SharePoint technical lead for various projects. Participated in the complete life cycle development for the clients of Extend Solutions. Involved in the project proposal, planning, designing, development, and delivery to the clients, in order to generate the solution for the business necessity

Development of a site template for SharePoint 2007 with the aim of count with a standardized look and feel of the products that the company offers developed in Visual Studio 2008 with C and SharePoint Designer 2007

Development of a portal to display the recent new of the company to the general public, developed in SharePoint 2007, Visual Studio, C , CSS, JavaScript and Silverlight

• Migration of the client's intranet to a new SharePoint 2007 Server farm including the InfoPath 2007 forms and the reports that they had in SQL Server Reporting Services 2008 SSRS
• Installation and configuration of a new instance of Microsoft Project Server 2007 in which also was given a two days training course of how to operate the platform.
• Development of Web Parts, Custom Pages with Visual Studio .Net, C , SharePoint Object Model, Excel Services and LinQ

Responsibilities:

• Development of web pages, web applications, web parts, and user controls in Visual Studio 2008, C , SharePoint Server 2007.
• Customization of the SharePoint 2007 User Interface to meet the requirements of the client using SharePoint Designer, CSS, JavaScript.
• Configuration and administration of SharePoint Server2007 Portals.
• Installing development environments for SharePoint 2007 Server
• Development of Web Parts with Visual Studio 2008 and Silverlight
• Analyze and documenting client requirements.
• Presentation of status reports.
• Generation of technical proposals
• Created Project Plans for the projects assigned.
• Migration of intranet with its InfoPath 2007 forms and reports to a new SharePoint 2007 Farm
• Implementation of a new instance of Project Server 2007 and configuration of the indicators requested by de client, and training to the user of how to operate the platform.

Environment: SharePoint 2007, SharePoint Designer 2007, Project Professional 2007/2010, Visual Studio 2008, C , CSS, JavaScript, Silverlight, InfoPath 2007, Microsoft Project Server 2007.

Sr. Programmer Analyst

• Documents integration module in Visual Basic 6 with Databases in SQL Server 2000
• In SharePoint 2007, modification of workflows and InfoPath 2007 forms with code in C . Responsible for migration of Lotus Notes to SharePoint 2007
• Analysis and development of projects assigned for the company both in Mexico City and Monterrey Mexico. Performing functional analysis, architectural designs, technical design, develop and delivery of the solution. All developed in Microsoft platform.
• Development of an appointment system web based in Visual Studio 2008 C , SQL Server 2008 Design and Store Procedures and Telerik controls.
• Development of Portal in SharePoint 2007 and customizing in SharePoint Designer and Visual Studio 2008 with access to SharePoint Web Services and custom pages with C code.
• Development of Portal in SharePoint 2007 and customizing in SharePoint Designer and Visual Studio 2008 with access to SharePoint Web Services
• Analysis and develop of the project Project Server Integration , using the Project Server 2007 databases as well the web services of the tool and also including tables and Stored Procedure, developed in Visual Studio 2008 C and SharePoint Object Model.

Responsibilities:

• Development of components in Visual Basic 6, Visual Studio 2008, C , SharePoint Server 2007, Project Server 2007.
• Consumed SharePoint 2007 Web Services, Modification of SharePoint Workflows developed in Workflow Foundation.
• Development of InfoPath 2007 forms with web browser compatibility that starts workflows.
• Designed relational database schemas and Stored Procedures to be consumed by ASP.Net applications in MS SQL Server 2008.
• Customized SharePoint lists, Site, templates and Pages in SharePoint Designer 2007.
• Generated architectural documentation and technical design documentation.

Environment: SharePoint 2007, C , InfoPath 2007, Visual Basic 6 , SQL Server 2000/2008, SharePoint Designer, SharePoint Web Services, Project Server 2007 , SharePoint Object Model.

Development of new requirements and changes in pages in productive systems of Grupo Salinas using ASP.Net, ASP 2.0, SQL Server 2000 2005 and VB.Net

Responsibilities:

• Development of Change Requests to productive applications in ASP 2.0.
• Development of Change Requests to productive applications in ASP.Net and applications in Visual Basic .Net.
• Documentation of requirements made to the assigned Area
• Developed and modified Stored Procedures in SQL Server 2000 and 2005 to be consumed in the components developed and modified.

Environment: ASP 2.0, ASP .Net, SQL Server 2000/2005, Visual Basic .Net,

Programmer Analyst,

This project was aimed to perform modifications to the current product that Adam Technologies had, in order to meet the specific requirements of his client

Responsibilities:

• Analysis of the requirements assigned. Developed components for the requirements assigned in Visual Basic 2005 for the payroll desktop application.
• Developed and modify Stored Procedures in SQL Server 2005 to be consumed in the components developed. Developed reports requested by the client in Crystal Reports

Environment: MS Visual Basic .Net 2005, SQL Server 2005, Crystal Reports.

designed to control the merchandise traffic between branches and transport means among the Mexican territory.

Responsibilities:

• Responsible to develop functional prototypes assigned by the project manager.
• Responsible to develop custom user controls to being reused by the rest of the development team in VB 6
• Responsible to control the source control in conjoint with the project manager to maintain an extract control of the components giving access to the rest of the development team of specific resources only through Microsoft Source Safe.
• Responsible of develop and modify store procedure in Oracle 9i once the DBA was removed of the project.
• Responsible of review the code developed by the rest of the development team.
• Responsible of coordinate the Quality Cycle, and solving the issues reported by the QA resources.

Environment: MS Visual Basic 6, Oracle 9i, Crystal Reports.

• Project designed to manage all the collections that the area does by the service that provides such as photocopies, penalties, and locker's rent developed in Visual Basic 6 and Access 97
• The purpose of the project was to create a payroll system specifically to meet the characteristics of the university due to it has about four schemes of payments and there wasn't a system that covers all the characteristics required by the university.

Responsibilities:

• Analysis and design of the requirements provided by the presidency and the accounting department.
• Responsible for development the application and lexis analyzer in Visual Basic 6 and Access 97 in order to provide a flexible application.
• Creation of reports for both Accounting and Presidency
• Support and Training to the Accounting Personnel regarding the application.

Environment: MS Visual Basic 6, MS Visual Basic .NET, Windows 98, MS Access 97, Crystal Reports.

Project aimed to update the actual system developed in Visual Basic 6 and Access 97 to Visual Studio 2002, SQL Server 2000 in a Client Server environment, this system was designed to manage all the material included in the university library and as well to request material to the personal in charge, for that reason was divided in two modules: the consultation module in which students, teachers and general public can request for materials for in site consultation, and in the case of students and teachers, for take home the materials if the material policies allows it. The second module was designed specifically for the personnel working in the library, and is there where they can add new material, consult the material requested by the users, check the material not returned in time, and perform inventories for mention some tasks.

Responsibilities:

• Responsible to analyze the current functionality of the current application to meet completely the requirements in the new version.
• Responsible to analyze the current database scheme in order to reutilize as possible the structures of the relations scheme.
• Responsible to make the changes in the database relational scheme in order to improve the performance and utilize the benefits that the new RDBMS provides MS SQL Server 2000 .
• Responsible to develop the new version of the library system in Visual Basic .Net
• Responsible to develop the reports of the application in Crystal Reports.
• Integration of bar codes into the system.

Environment: MS Visual Basic 6, MS Visual Basic .NET, Windows 98, MS Access 97, SQL Server 2000, Crystal Reports.

The purpose of this project was to provide to the general public with the information about the admissions, educative offer and general information, and at the same time, provide to students a means of consultation of their academic records and other relevant information provided by the university. This project had to function with a touch screen monitor, and for that reason, it had to contain a rich multimedia interface accordingly to the University image.

Responsibilities:

• Responsible for development of POCs of User Interface to be approved by the University Presidency.
• Responsible for Desktop application in VB 6 and third party OCX controls.
• Responsible for Data access using DAO and Access 97.
• Developed reports of the application in Crystal Reports. Responsible for performing the Unit Test.

Environment: MS Visual Basic 6, Windows 98, MS Access 97, Third party OCX, Crystal Reports.

The purpose of this project was to create a product which the company could to commercialize among their clients and the general public. It was designed to be a comprehensive tool that satisfied the requirements that organizations and individuals have regarding information backup. It has the capabilities of store the backed up information in different storage mediums such as CD, Tape and disk, and this processes can be programmed to functioning in an autonomous way without user intervention.

Responsibilities:

• Analysis of the requirements of the product. Components design and feasibility analysis of current and new requirements.
• Responsible of the development of the product in VB 6
• Feasibility analysis of compression components in order to comply with the industry standards both regarding to compression and storage backup in CDR/CDRW .Responsible to perform unit test.
• Responsible to implement third party components for compression and burn CDR/CDRW
• Involvement into compatibility testing in order to provide compatibility among all the Windows Operating Systems in the market at that time Windows NT/95/98/2000
• Responsible of creating an installer friendlier for the product with compatibility with all Windows Operating Systems in the market at that time Windows NT/95/98/2000 , through using the included tool in Visual Basic 6.

Environment: MS Visual Basic 6, XCEED Software, OCX Controls, Windows NT, Windows 95, Windows 98, Windows 2000 Server

The purpose of this project was to automatize the Point of Sale of a money exchange facility through a Desktop application and at the same time, to have reports regarding the operations performed and the cash flow at different periods of time.

Responsibilities:

• Performed meetings with users both managers as operatives, who were involved for gathering and analysis of the business requirements at operational level and in order to review and approval the documentation generated.
• Analysis, Design, Development and Implementation of the Solution including relational database schema, components, modules and graphic interface, the programming components were developed in Visual Basic 6 and the Relational Database in Access 97.
• Performed POC previously the end of analysis with a functional prototype in order to clarify the requirements and give to the client better understanding of what to expect at the delivery of the project.
• Responsible for creating Business layer components using Visual Basic 6.
• Responsible for creating Data layer components using DAO and responsible for conducting the implementation, training and post production support and monitoring
• Unit Testing

Environment: MS Visual Basic 6, MS Access 97, OCX Controls, Windows 98, Windows 2000 Server.

The purpose of this project was to migrate to a new platform the current company's product considering in this migration the RDBMS SQL Server 2000 and Visual Basic .NET.

Responsibilities:

• Involvement in the analysis of requirements for the new version of the product.
• Involvement in the definition of the user interface in the new platform.
• Involvement in the design of the Database Schema in MS SQL Server 2000.
• Involvement in the development of the product in Visual Basic .NET 2002.

Physical Inventory Module

The purpose of the development this module was to provide to the product developed by the company with the functionality of performs physical inventories through a wireless data collector which had embedded Windows CE.

Responsibilities:

• Analysis and development of a web form in Visual Basic .Net to perform physical inventories in a Windows CE device.
• Connection to an MySQL Database to store the information collected in the Web Form

Environment: MS Visual Studio 2002, MS Visual Basic .NET, MySQL, Windows CE.