Resume Details
A. A.

Location Stamford, CT  
Contact Click to View Contact
Source Vendor Candidate
Salary N.A.
Rate N.A.

Resume


Andres Avila

 

 

SUMMARY:

 

§  System Engineer with over ten years computer analyst experience, six years university professor.

§  Over ten years experience in software development, systems analysis, and project management utilizing the Microsoft Solutions Frameworks.

§  Over four years of experience developing in ASP.NET, C#.NET and VB.NET and JAVA.

§  Crafting and optimizing ANSI SQL relational databases and stored procedures, using Oracle, SLQ Server and mainframe database products, such as DB2 and others.

§  Developing and implementing very sound Backup and Recovery Strategies.

§  Extensive Knowledge of System Security.

§  Demonstrate capability for fine turning and enhance performance for a fine grain Database.

§  Application development experience in Banking, collateral management, finance, manufacturing, warehousing, insurance, utilities, health care, retailing and other software development process.

§  Highly motivated, versatile Software Engineer specializing in Object-Oriented Design and Analysis with extensive experience in the full life-cycle of the software design process including requirements definition, prototyping, proof of concept, design, implementation, testing and maintenance.

 

 

SKILLS:

 

App. Servers:   JRun, BEA WebLogic, Tomcat, JBoss, Ant, iPlanet, Oracle9iAS OC4J.

Web Servers:    Microsoft IIS, Apache

Databases:       Oracle 8i, Oracle 9i, SQL Server 7, SQL Server 2000,            

                        SQL Server 2005, MS Access, Visual FoxPro Server.

Software:          Visual Café, Borland JBuilder, Rational Rose, IBM Visual Age, SQL Navigator, MS Office, JDeveloper, TopLink, Oracle, SQL Server, OOA/OOD (UML, Design Patterns, Recapturing), CVS/PVCS/ClearQuest, Macromedia DreamWeaver.

Languages:      Visual Studio .NET (Visual Basic .NET,C# .NET, ASP.NET), C++, Java 2SDK( AWT, Beans, Servlets, JSPs, Threads, JDBC, SQLJ,  EJBs), JavaScript, JavaBeans, JMS,  HTML, XML, PHP, XSLT, Oracle  PL/SQL, Visual FoxPro 3, 5, 6, 7 and 8 Version, MySQL, FoxPro 2.5+ for Dos.

APIs:                Swing, JavaDoc, Servlets, JDBC, SQLJ, JavaBeans, Collections, JSP, EJB, JNDI, Tag Libraries, XML/XSLT (Xeres, Xalan), RMI, JMS, ODBC, ADO, IIS.

OS:                  Windows (95, 98, 2000, 2003, NT, XP), MSDOS, UNIX,

                        Solaris 8.

 

EXPERIENCE:

 

McLagan Partners, Inc. Stamford, CT                                                                                 6/04 – Present

DBA/Senior Program Analyst

           

§  Develops project plans for simple to complex projects that include a limited number of dependencies.

§  Provides supporting information for the formulation of IT strategies with effective structures for guidance to employees with complex initiatives.

§  Provides input to the annual planning process and develops work plans & budgets for individual initiatives.

§  Lead Web developer for all Compensations applications.

§  Identifies the appropriate approach for gathering a project’s requirements.

§  Supports and incorporates best practices into daily work.

§  Design and create relational Database in SQL Server 2005 for difference projects.

§  Design tree tier architecture and Web development in ASP.NET 2.0; middle tier (BLL), data tier (DLL) and User interface component developed in VB.NET and C#.NET with SQL backend.

§  Analyzed the current state of development for an enterprise-scale compensation process application.

§  Develop and integrated a multiple environments into a large reporting tool using SQL Server Reporting Services 2.0.

§  Develop and implement Backup and Recovery Strategies for SQL Servers Databases.

§  Writing and reviewing store procedures for all projects in the SQL Server 2000 and 2005.

§  Heavy emphasis on logic performed for optimization in SQL Server (e.g. lots of calculations and rollups; many large tables in the database; complex keys and indexing strategies).

§  Support an OLAP application developed in Visual Studio with SQL Analysis Services Backend.

 

 

TENASKA, Omaha NE                                                                                       9/03 – 6/04

Operations DBA &

Programmer Analyst (consulting for Bass & Associates)         

           

§  Consulting, design, and implementation of custom system solution.

§  Import and export with DTS packages of business critical data into SQL Server database from a variety of sources (EDI Feeds, DBF, MDB, ODBC, etc).

§  Design, create and drop views and SQL Cursors.

§  Design a client/Server architecture using SQL Server 2000 and Microsoft Visual FoxPro v.7.0.

§  Develop and implement Backup and Recovery Strategies.

§  Develop a Credit system, and redesign the Accounting system, interface-based code written in C#.NET and VB.NET.

§  Writing and reviewing store procedures in the SQL Server.

§  Import of business critical data into SQL Server 2000 database from Visual Foxpro free tables.

§  Designed from the ground up multi-tiered application with extensive object model.

§  Consulted and assisted development of SQL Server 2000 relational database.

§  Responsible for periodic builds to development, systems test and staging environments.

§  Install and setup Microsoft VSS as a version control system in my computer use for development.

 

 

VERINOW CORPORATION, Millburn NJ                                                             6/03 – 9/03

Operations DBA &

Programmer Analyst (consulting)        

           

§  Writing and reviewing store procedures in the SQL Server.

§  Shared Network application development of a client/Server architecture using SQL Server 7.0, updated to SQL Server 2000 and Microsoft Visual FoxPro v.7.0

§  Develop and Maintenance existence systems using Visual Foxpro 7.0.

§  Develop a back order system for one of the company client.

§  Design, create and drop views and SQL Cursors.

§  Install and setup Microsoft VSS as a version control system and Visual Maxframe.

 

 

Media Networks, Inc., CT (http://www.mni.com)                                                 8/99 – 4/03

A Sub-company of (AOL Time Warner) - Programmer Analyst

 

§  Responsible including database administration tasks for OLTP and OLAP databases.

§  Develop and design PL/SQL procedures, functions and packages.

§  Establish and maintain user roles, user access and privileges.

§  Import of business critical data into SQL database from a variety of sources using DTS packages.

§  Develop and design T-SQL procedures, functions and packages.

§  Integrated XML and XLST technology parsing using DOM and SAX APIs, which played a vital role in data transmission between Home-Link and its B2B and B2C clients.

§  Updating SQL analysis, tool implementation, forecasting, developing and implementing upgraded for the database.

§  Mentored a staff of developers through the development of a critical component with strict schedule deadlines.

§  Responsible for fine turning and enhancing performance for a fine grain Oracle Database.

§  Creating a new intranet system from scratch using Java, JavaScript, HTML, XHTML PHP, Apache web server, with Oracle 8i and SQL Server 2000 as backend database.

§  Managing the upgrade of the system migration to Oracle 9i.

§  Develop and design PL/SQL procedures, functions and packages.

§  Develop Web Pages using software tools such as HTML, MS, PHP, Dream Weaver, Image Composer and Acrobat Reader and JavaScript.

 

 

AT&T, NY                                                                                                         5/97 – 8/99

Programmer Analyst

 

§  Develop and Maintenance existence systems using Visual Foxpro 5.0.

§  Develop front-end/client applications in Swing Using JBUILDER version 4.0.

§  Established well-defined coding standards and code reviews for development team.

§  Evaluated and integrated new tools that enabled increased productivity and reduced time to market by 30%.

§  Develop software applications using Visual Studio, Java & C++.

§  Diagnose computer problems using utilities software.

§  Repair, install, upgrade, and maintain Personal Computers and networks.

§  Develop lesson plan in Microsoft software for personal computer training.

§  Develop Web Pages using software tools such as HTML, MS FrontPage 98, MS Image Composer and Acrobat Reader and JavaScript.      

 

 

Deloitte & Touche Tohmatsu International, Dominican Republic                      2/94 – 2/97

Programmer Analyst/Operations DBA

 

§  Programmed with various computer languages such as COBOL, Foxpro2.5, MS Access, C++, Oracle PL/SQL, Oracle SQL DML and DDL & Visual Foxpro 3, Visual BASIC4.

§  Functioned as private computer consultant and auditor for various companies.

§  Managed 10 consultant programmers.

§  Training staff in computer most common software.

§  Develop base plane test Web Pages using FrontPage, and Image composer.

§  Installed and administered Oracle 7.

§  Extensive use of PL/SQL in determining that the flow of data within the WIC.

§  Installed and administered Novell and Windows NT 4.0 Networks.

§  Responsible including database administration tasks for OLTP and OLAP databases.

§  Analyze and design data warehouse to accommodate new standard materials handling documents for various costumers.

 

 

PUCMM University, Dominican Republic                                                          5/94 – 2/97

Computer Professor

 

§  Taught computer programming Visual FoxPro, FoxPro, C++, Java and others.

§  Wrote student evaluations and recommendations for job placements.

§  Provided technical support services and installed software and hardware.

§  Responsible for troubleshooting software and hardware problems.

§  Developed programming lesson plans and wrote programming manuals.

 

 

CODETEL Telephone Company, Dominican Republic                                      1/90 – 2/94

A Sub-company of (Verizon) (http://www.codetel.com.do) - System Analyst/Oracle DBA

 

§  Install and administered Novell Network.

§  Develop Software Applications with such technologies as: Oracle PL/SQL, Oracle SQL DML and DDL & Visual Foxpro4, Visual Basic4 COBOL MANTIS, RPG & C++.

§  Develop and design PL/SQL procedures, functions and packages.

§  Advised users on data communication problems.

§  Responsible for troubleshooting software and hardware problems.

§  Installed and administered Oracle Server.

§  Maintained large marketing and analysis database.

 

 

EDUCATION:

 

UNAPEC University, Dominican Republic                                                         1990

Bachelors, Computer System Engineering

 


No Similar Candidates Found