Post Job Free

Resume

Sign in

Project Sql Server

Location:
Carrollton, TX
Posted:
April 27, 2016

Contact this candidate

Resume:

Roberto E. Sarzata

Contact Information

Email Address: acujec@r.postjobfree.com:acujec@r.postjobfree.com

Mobile No: +1-469-***-****

Summary

With 10+ years’ experience in IT industry mainly focus on software development.

Very much involve in different stages of system development from system analysis, requirement definition, system design, database design, implementation, integration, testing, deployment and support.

Experience on the following industries: Auto Insurance / Manufacturer / Pharmaceuticals / Ecommerce.

Design and develop database applications and enterprise solutions using Microsoft Technologies such as ASP.NET / MVC / C# / VB.NET / WCF / SSIS / SSRS / MS SQL for windows and web platforms

Experience in creating front end web-applications using ASP.Net / MVC / JQuery / AngularJS / ColdFusion.

Knowledgeable in SDLC and agile methodologies.

Graduate of Bachelor of Science in Computer Science.

Microsoft Certified Professional

Technical Skills

Skill

Proficiency

Experience Age

(Indicate unit if less than a year)

Year Last Used

VB.NET

Advanced

11

2016

ASP.NET

Advanced

11

2016

C#.NET

Advanced

10

2016

MS SQL Server

Advanced

15

2016

WCF

Proficient

10

2016

SSRS/SSIS

Proficient

8

2016

Certifications

Professional Society/Certification

Member Since/Date Certified

Passed exam Microsoft SQL Server 2005 Business Intelligence Development

Jun 18, 2009

Microsoft Certified Professional Developer (MCPD): Enterprise Application Developer

Apr 11, 2008

Microsoft Certified Professional Developer (MCPD): Web Developer

Jan 28, 2008

Microsoft Certified Professional Developer (MCPD): Windows Developer

Jan 21, 2008

Microsoft Certified Technology Specialist (MCTS): Net Framework 2.0: Distributed Applications

Mar 29, 2008

Microsoft Certified Technology Specialist (MCTS): Net Framework 2.0: Windows Applications

Jan 28, 2008

Microsoft Certified Technology Specialist (MCTS): Net Framework 2.0: Web Applications

Jan 21, 2008

Microsoft Certified Application Developer (MCAD)

Jun 23, 2006

Microsoft Certified Professional (MCP)

Dec 15, 2005

Work Experience

Confie Seguros Holdings, Inc. (07/01/2015 – 04/25/2016)

Confie Seguros Holdings, Inc. (Confie) is a leading national lines and small to midsize commercial insurance broker. Confie continues its growth through acquisition and AFFM is one of the company acquired by Confie. I was retained during acquisition and have the same responsibilities describe below.

Affirmative Holding Inc. (07/22/2013 – 06/30/2015)

Affirmative Insurance Holdings, Inc. (AFFM) is an integrated insurance holdings company that produces and provides non-standard automobile policies and complementary products and services to individual consumers.

Team Size: 3

Roles and Responsibilities

Conducts code reviews to ensure that the code satisfies the design specifications and complies with company standards, translated business concepts to technical design.

Coordinates directly with the business end user concerning execution and implementation/roll out of release.

Performed analysis, code modification and database design as required meeting the change requests from the end users.

Delivered system documentation such as Requirement Document and Technical Design Document that provide detailed information on key implementation details.

Provided configuration guidance for the .Net development environment execution.

Participated in the user requirement gathering and consulting with the project stakeholders

Supported the deployment of the system to the production servers

Performed code change for project enhancement and break fixes using Microsoft technologies such as MS SQL, VB.NET, ASP.Net, C#, WCF, etc.

Technologies Used

MSSQL SSRS

MSSQL 2008 / 2012

C#/VB.NET

WCF / MVC / JQuery / AngularJS

MSSQL SSIS

Accenture –Manila Delivery Center (10/15/07 – 07/19/2013)

Accenture is a global management consulting, technology services and outsourcing company. Committed to delivering innovation, Accenture collaborates with its clients to help them become high-performance businesses and governments. With deep industry and business process expertise, broad global resources and a proven track record, Accenture can mobilize the right people, skills, and technologies to help clients improve their performance.

Project Name: Affirmative Insurance – Application Outsourcing (06/01/2008 – 07/19/2013)

Affirmative Insurance Holdings, Inc. (AFFM) is an integrated insurance holdings company that produces and provides non-standard automobile policies and complementary products and services to individual consumers. Accenture was tapped in by Affirmative to support it applications both Accenture assets and 3rd party vendor which includes the following team: Claims, Retail, Common Services and Business Intelligence and Point of Sales Policy Administration Integration (POSPA Integration).

Team Size: 9

Roles and Responsibilities

Act as Project Manager to ensure that each phase of the software development life cycle is completed and signed-off

Act as Lead of the development teams - ProClaim, CSBI, Retail, POSPA - Integration

Mentored junior developers and fellow developers regarding claims system process.

Conducts code reviews to ensure that the code satisfies the design specifications and complies with company standards, translated business concepts to technical design.

Supervised work of team members, allocating tasks to effectively leverage available skills and resources, give performance feedback, and create status reports.

Coordinates directly with the client as well as on-shore business analyst, concerning execution and implementation/roll out of release.

Performed analysis, code modification and database design as required meeting the change requests from the end users.

Delivered system documentation such as Requirement Document and Technical Design Document that provide detailed information on key implementation details.

Met with application end users to discuss change impact, delivery schedules, and obtain clarification for change requests.

Generate estimates for project enhancement proposals and change request made by the client.

Provided configuration guidance for the .Net development environment execution.

Participated in the user requirement gathering and consulting with the project stakeholders

Supported the deployment of the system to the production servers

Performed code change for project enhancement and break fixes using Microsoft technologies such as MS SQL, VB.NET, ASP.Net, C#, WCF, etc.

Technologies Used

MSSQL SSRS

MSSQL 2008

C#/VB.NET

WCF / MVC

Project Name: Affirmative Insurance Project Revolution (10/29/2007 – 5/31/2008)

The objective of Project Revolution is to position Affirmative to dominate the highly fragmented personal non-standard auto market in the 15 largest non-standard auto states through streamlined, low-cost operations and systems, continued acquisitions, and strategically unique distribution model. The key attributes Affirmative plans to utilize to achieve this are to have streamlined, low-cost operations and systems, continued acquisitions, and a strategically unique distribution model.

Team Size: 4

Roles and Responsibilities

Major responsibilities for Senior Developer for Project Revolution:

Responsible for programming application software designs

Responsible for testing application software codes

Responsible for demonstrating the awareness of how own program links with those of other developers and of the overall system

Responsible for informing supervisors as far in advance as possible of potential difficulties in meeting scheduled milestones and being able to provide explanation(s)

Configure, build, and test the application or technical architecture components.

Work with other programmers, designers, and architects to make sure that the configuration and custom components meet application requirements and performance goals.

Participate in code reviews

Responsible for fixing any defect and performance problem discovered in testing

Document the application to facilitate maintenance

Ensure that changes to scope are identified and raised to the Team Lead

Ensure that quality is never overlooked in developing modules

Major responsibilities for Senior Software Engineer for Reports module:

Support users: Providing rapid and error free transfer of data to and from the database to support user activities; providing timely responses to all client requests, including on-call support outside normal business hours; meeting deadlines and budgets.

Handle change requests: Effectively handling client change requests by proposing and supporting the design, development and testing of solutions, including ensuring that change requests entrance criteria and documentation is complete, conducting impact analysis and following through on execution of changes.

Support other developers: Providing support for others involved in the development and testing of solutions, including programming, technical, and functional assistance, reviewing changes and code

.

Technologies Used

MSSQL SSRS

MSSQL 2005

C#/VB.NET

TechStars.Net (Philippines) Inc.

TechStars.Net is a global consulting, technology services and outsourcing company. TechStars.Net integrates powerful business knowledge with technologies specifically designed to make its client business purpose a success.

Project Name: Fraud Alert System (07/12/2007 – 09/30/2007)

The Fraud Alert System is a consumer subscription to the identity shield provided by different credit bureaus.

Team Size: 3

Role and Responsibilities

Performed system analysis and design.

Participated in the user requirement gathering and consulting with the project stakeholders

Assigned in the creation of web service that will accept the consumer information in xml string format.

Assigned to create a window service that generates a text file based on the schedule time.

Technologies Used

ASP .NET on C# platform

Web/Windows Services

XML

MS SQL Server 2005

Project Name: Articles (05/06/2007 – 07/12/2007)

Article is designed to make the health information available and viewable to the general public and health practitioners.

Team Size: 3

Role and Responsibilities

Assigned to implement the Single Sign On module for managing user information.

Participated in the user requirement gathering and consulting with the project stakeholders

Part of the web development team

Technologies Used

ASP .NET on C# platform

MS SQL Server 2005

Community Server 2007

Project Name: Product Management and Inventory System (April 2007 – July 2007)

Product Management module basically administers the creation and editing of products information which are displayed in the store front. It also has the capability to make Kit products, composed of similar or different products. Inventory System module manages the stock quantity of products.

Team Size: 1

Role and Responsibilities

Performed bug fixes and customizations

Maintains and enhances the application

Implements the MagicAjax control to improve the performance of the web application

Add Product Line Module that manages the creation and editing of product line records

Technologies Used

ASP .NET on C# platform

MS SQL Server 2005

Magic AJAX

Project Name: Knowledge Base (March 2007 – April 2007)

A web application where CSR could create, browse and search articles to assist the customers.

Team Size: 1

Role and Responsibilities

Performed system analysis and design.

Participated in the user requirement gathering and consulting with the project stakeholders

Created the tables, stored procedures

Created the whole application.

Technologies Used

ASP .NET on C# platform

MS SQL Server 2005

Full Text Indexing

Project Name: WebTrends Sales Conversion (February 2007 – March 2007)

WebTrends is a third party company that provides robust reports based on the activity of the website.

Team Size: 1

Role and Responsibilities

Performed system analysis and design.

Implements necessary WebTrends metatags that generate a sales conversion report

Technologies Used

ASP .NET on C# platform

WebTrends MetaTags

TeeBone (Philippines) Inc

TeeBone is a service broker company that focuses on golf course and hotel reservation in the US.

Project Name: TeeBone Consumer and Admin Sites (May 2006 – February 2007)

Consumer Site is a web application where customers can book hotel and golf courses. Admin Site is the backend of the consumer website where all the based tables of the database are populated. This also handles the itineraries created by the consumers/agents in the consumer website

Team Size: 5

Role and Responsibilities

Transfer the existing admin site to the new TeeBone Admin Site.

Maintains and enhances the administrator websites

Part of the web development team

Technologies Used

Macromedia Dreamweaver

Macromedia ColdFusion

MS SQL Server 2000

Indigo8 (Philippines) Inc

Indigo8 Solutions have created Enterprise Management Software for Garment and Apparel Companies. Specialize in integrating all departments and functions across the organization into a single computer system

Project Name: Enterprise Management Software (July 2004 – May 2006)

An enterprise software which integrate all department and functions across the organization of Garment and Apparel companies.

Team Size: 5

Role and Responsibilities

Handled the data build up of materials used in creating a garment.

Created reports like Bill of Materials (BOM) and Samples.

Created the tables, stored procedures

Technologies Used

ASP .NET on VB.Net platform

Crystal Report bundled in .Net Studio

MS SQL Server 2000

Project Name: Shipment Tracking System (January 2005 – February 2005)

All materials from warehouse which need to be ship are encoded in this system.

Team Size: 1

Role and Responsibilities

Performed system analysis and design.

Participated in the user requirement gathering and consulting with the project stakeholders

Created the tables, stored procedures

Created the whole application.

Technologies Used

VB.Net (WinForm)

XML Web Services

MS SQL Server 2000

MediData Inc

MediData is a local consulting, technology services and outsourcing company.

Project Name: Electronic Territory Management Systems (October 2003 – June 2004)

The system is used by different field forces to manage their itineraries.

Team Size: 6

Role and Responsibilities

Performed system analysis and design.

Participated in the user requirement gathering and consulting with the project stakeholders

Created the tables, stored procedures

Technologies Used

Macromedia Coldfusion MX

MS SQL Server 2000

Project Name: Nestle Web Based Report (August 2003 – October 2003)

An online report dedicated to Nestle Middle East.

Team Size: 2

Role and Responsibilities

Performed system analysis and design.

Participated in the user requirement gathering and consulting with the project stakeholders

Created the tables, stored procedures

Created the whole project.

Technologies Used

Classic ASP

Crystal Report

MS SQL 2000

Project Name: Call System (July 2002 – August 2003)

Team Size: 5

Role and Responsibilities

Responsible for optimizing performance and fine-tuning of the system.

Create additional management reports as per client request.

Assigned to develop a program that will transform the data from Excel to MS SQL Server 2000

Technologies Used

Visual Basic 6.0

MS SQL Server 2000

Trainings/Seminars

Technical

MSDN Channel 9

InnerWorkings Hands On Laboratory

Pluralsight

Microsoft Virtual Academy

Education

•University of the East – Manila / Bachelor of Science in Computer Science



Contact this candidate