ALFREDO ESPINOSA DIAZ

Confidential is a Microsoft Certified Technical Specialist andMicrosoft Certified Professionalon Sharepoint technologies with close to fourteen yearsin implementingend to endcollaboration/portal solutions as well as transactional applications based on Microsoft technologies. His main experience lies in SharePoint Products and Technologies on platforms 2007, 2010and 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:

Sharepoint Developer

Responsible for establishing the stability and maintenance of the Infrastructure of different portals/applicationson SharePoint Platform.

Responsibilities:

• Responsible forgathering requirements to provide strategic, technological, technical and architectural solutions according to the needs of the different client's business areaswith corresponding estimates of time and cost according to the client policies
• Developed project plans and coordinatedwith 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.
• 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 theSharePoint 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 ofSharePoint 2007User Interface to meet with the corporative image
• Responsible for analysis and designof 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.
• DevelopedWeb 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 Schemeand 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

Responsibilities:

• Generated the Project Plan.Responsible for analyzing and documenting the client requirements.
• Presented the Status Report to the stakeholders of the project.
• Development of Web Parts inVisual Studio 2010, C .
• Development of Reports using SQL ServerReporting 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.
• Generated batch processes to upload of information in Visual Studio 2010

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

Lead Sharepoint Developer,

• 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 ServerReporting Services 2008 SSRS
• 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 portal to display the recent new of the company to the general public, developed in SharePoint 2007,Visual Studio, C , CSS, JavaScript and Silverlight
• 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.

Responsibilities:

• Development of web pages, web applications, web parts, user controls inVisual 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 ofWeb Parts with Visual Studio 2008 and Silverlight
• Analyze and documenting client requirements.
• Presentation of status reports.
• Generation of technical proposals
• CreatedProject 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, Mobile Information

• 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.
• nologies 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
• 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.

Library Services

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

University's Payroll System

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 programing 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 usingVisual Basic 6.
• Responsible for creating Data layer components using DAO
• 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 migrateto 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.

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

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.