Alexander Vargas Email and Phone Number

Send Word Now – Database Development.- Developed new features/code, involving but not limited to: Tables, Triggers, Indexes, Functions and Stored Procedures.- Improved current features/code, involving but not limited to: data types, performance tuning and data structures.- Understanding of TSQL, OLTP, performance tuning, Service Broker, TFS, SSDT, Design, SQL Server 2008/2012, XML, XPATH; was a must.

- Activities involved fixing data in the production environment by creating TSQL (Transact-SQL) to update/insert information (customer and configuration data).- Worked in the indexing strategies to make sure that the querying (for the stored procedures, functions and data extraction) was being done in the optimum way. - Led an initiative to get the entire team sped up with the learning curve, which required planning, designing and conducting investigations and presentations.- Good understanding of Microsoft SQL Server 2008R2, Serena Dimensions for source control and Serena Team Track for the ticketing (defects, new features, data extractions, data modification and more) system.

Database Administration for more than 120 databases.- Monitored hardware performance; performed “backup and restore” strategies, disaster recovery, performance tuning, indexing strategies, installations of new servers and instances.- Provided consulting to the other teams (Support, IT, Engineering, Business Analysts, and Quality Insurance) in the company regarding the administration of the servers and their configuration software (SQL Server Engine) and hardware related (server, storage, memory).- Our servers were using Microsoft Windows 2003 and 2012 Editions. Microsoft SQL Server 2000, 2005, 2008R2 and 2012. - Used IDERA SQL Diagnostic to keep track of the performance counters (memory usage, page life expectancy, CPU usage) and IDERA SQLSafe for backup strategy (Full, Differential and Log). Development and Production code handling.- Code review and enforcement of coding best practices (error handling, commenting, using of indexes, programming techniques).- Worked in design, architecture proposals, and decisions for current and new features (this involved using techniques as table partitioning, partitioned views, normalization and denormalization, star and snowflake schemas, datawarehouse design, staging and dimensions, and ETL techniques).- Performance tuning, indexing strategies and consultant in all these matters for other teams (Support, Information Technology, Engineering, Business Analysts, and Quality Insurance) and TSQL (Transact-SQL) development (including DML/DDL).- Database engine used for all these tasks: Microsoft SQL Server 2005, 2008R2 and 2012. - Tools used: Red Gate Developer Bundle (Source Control, SQL Data Compare – used for data, SQL Compare – used to compare structure), SQL Sentry Performance Advisor – to detect performance issues and Plan Explorer – to study, troubleshoot and improve execution plans, Microsoft Team Foundation Server (TFS – used for source control, integrated to the Red Gate Source Control and Visual Studio 2010).

- Maintained RSA database. Created, deleted, updated and reset user’s information. Created security policies for groups to access web systems (administration sites to control the settings of RealTimeGaming system).- Offer support for Microsoft SQL Server 2000, 2005 and 2008. Involved troubleshooting slowness, connection errors, timeout errors, scripting for errors or bugs as well as coding to user defined reporting.- Assisted with installation of new software versions, upgrades, art, testing and debugging. Involved knowing how to troubleshoot IIS, .NET, VB, Microsoft SQL Server (2000, 2005 and 2008).- Assisted on server migrations and moves (DB, Web and APP). Required knowledge of Microsoft Windows Server 2003, Microsoft SQL Server 2000, 2005 and 2008, IIS configuration and troubleshooting.- Worked three weeks from Manila, Philippines (December 2010) on a special installation project for one of the Tier 1 clients.

LeapFrog – Algebra 2007 and Writing 2.0- Two projects developed in a proprietary language of LeapFrog and based on Ansi C, code was uploaded and executed on the Fly PenTop Computer.- Role included coding/developing and offering ideas on how to implement the different routines required to achieve the goal of teaching algebra, more specifically for the “System of Linear Equation” in the Fly System.- Designed the database that was going to be used to store all the Flyctionary (Dictonary)- Designed and developed logic that took care of reading the strokes given by the user and converted to a lexicon to be reviewed by the system for its grammar and spelling.Lafise – Banking Administration and Client Module.- Created the maintenance for clients, users, administrators and roles used by the banking system.- Created the pages for the Account statements, transfers between clients/users/accounts.- Systems developed in JavaScript, Java Server Pages, Sun Java with Java Entity Framework, CSS, HTML, DHTML and XHTML. - Database communication used Hibernate technology with Microsoft SQL Server. - Used Eclipse for the Java, Perforce and Tortoise SVN for the source control.Palmetto – BalanceATS- Health care software that predicted patients’ sickness based on a set of answers to a set of questions predefined in the system.- Created the design and gathered the requirements from stakeholders. Involved understanding what was needed and provided technical solution of how to store information into a database that was used later on to make decision analysis.- Developed in Adobe Flex and coded in ActionScript language (Adobe’s proprietary). - Database created in Sun MySQL. Adaptive Planning – Java Migration- Migrated all code in webpages from VBS to JavaScript. - Participated in Quality Assurance process for other areas of the system that were migrated by other team members.

- Took calls from clients in the Florida area and helped configured their internet service.- Received calls from clients in the Florida area that needed help with their telephone service, coordinated and assisted with any maintenance required or requested technicians in place.