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