Adonis Villanueva

Mobile Phone: 916-873-7070
E-mail: adonis_abril@thedynamiclight.com

SUMMARY

  • Possesses over 10 years of comprehensive Information Technology experience as a Database developer and administrator, as well as experience with web architecture, development, and project management.
  • Experienced in development and management of various versions of SQL server Databases
  • Extensive development experience using web technologies such as ASP.NET/C#, JQuery, JavaScript, ColdFusion, HTML5, and Ajax.
  • Experienced with ensuring database disaster recovery of the entire database environment which includes managing a timely SQL backup schedule to protect the integrity of the information / data stored.
  • Experience with ensuring databases is available to end users at all times and implementing enhancements and updates to ensure technology is most current.
  • Expert in Content Management implementation, development, and administration including SharePoint 2010, Ektron, and Mura.
  • Experienced leading large scale multi-tiered projects to completion.
  • Skilled at analyzing functional needs and problems related to Information Technology and compiling solutions to meet those needs.
  • Knowledgeable about industry best practices for e-mail privacy and regulatory compliance, routing, filtering, monitoring, tiered storage, backup, and disaster recovery.
  • Extensive support and development experience with IIS and .NET application architecture.
  • Strong interpersonal, written, and oral communication skills.

TOOLS

  • Database: Microsoft SQL Server 2000/2005/2008/2008 R2.
  • Reporting: Crystal Reports, Cognos ReportNET, and SQL Server Reporting Services (SSRS).
  • Web: IIS 5/6/7, ASP.NET 1.1/2.0/3.5/4.0, CSS, Ajax, SOA, HTML, ColdFusion, PHP
  • Languages: C#, VB.NET, VB, JavaScript, ColdFusion, JQuery.
  • Content Management: Ektron, Mura, DotNet Nuke, SharePoint Foundation, SharePoint Server
  • Other: Visual Studio 2003,2005,2008,2010, Visual SourceSafe, Dream Weaver, Photoshop.

WORK EXPERIENCE
Senior Web Developer/Project Manager/CMS Implementation Consultant
October 2010 - present
US District Courts, Eastern District | Sacramento, CA

  • This role required an all-in-one Senior Web Developer, Project Manager, and CMS Implementation Consultant.
  • Design database schemas for dynamic integration into the web environment and integrated existing database systems into web development.
  • Develop dynamic web sites in ASP.NET/C# with database integration to provide administrative content management.
  • Develop UI framework, and integrate with backend, making them compatible with the backend code.
  • Design and develop operational and SQL Server database systems utilizing data modeling and ETL concepts to integrate with CMS.
  • Provide production support for SQL Server databases including on-call support as required.
  • Develop new tools, or used existing tools, to monitor and report website utilization to maximize the efficiency of the court’s websites.
  • Ensure cross-browser and platform compatibility.
  • Develop database objects and structures for data storage, retrieval and reporting according to project specifications.
  • Evaluate emerging Internet development technologies for possible use and benefit for the court.
  • Establish and track priorities, dependencies, and completion dates, then monitored the progress. 
  • Develop project work plans and use project management software, to accomplish all project management activities.
  • Design original graphics and logos for the web sites based on court recommendations using common graphic editing tools.
  • Work with an internal user group and a team of IT professionals to gather and assess end users functional requirements; this included surveying and assessing both internal and external users/customers to identify their specific needs and requirements for using the internet and/ or intranet web sites.
  • Conduct content management analysis and recommend a structure for the court's web sites.
  • Design comprehensive system charts and reports for presenting information gathered from stakeholders for review by the user group.
  • Create test plans for parallel testing and User Acceptance Testing (UAT)
  • Develop process maps to present functional designs of modular web processes and coding ASP.NET dynamic web pages for product demonstration and proof-of-concept.
  • Train/Instruct users in the various uses of SharePoint.
  • Develop business case(s) for projects by collaborating with customers.
  • Report the progress of projects and related activities in meetings and in written reports.
  • Develop rich, responsive W3C Compliant pages and User Interface utilizing modern client side tools such as AJAX, CSS, JQuery, DTHML, XHTML, and JavaScript.
  • Identify and achieved performance improvements as well as made current applications more secure by refactoring and improving legacy code.
  • Work extensively with JQuery to integrate existing calendar application and secure sensitive US Court’s data.
  • Create SQL stored procedures, functions, reports, and automated processes using SSIS or DTS. 
  • Provide SQL Server database administration/management and apply advanced performance tuning techniques.

 

Senior Web Architect, .NET Developer, Database Developer
March 2008 - October 2010
Intercare Insurance Solutions | Roseville, CA

  • This role required an all-in-one Database Developer, Web Architect, and .NET Developer.
  • Consult with CIO, clients, programmers and end users to gather information about program intent, functions, features, data requirements, input requirements, output requirements, internal and external checks and controls, hardware and operating system environment, and interfaced with other systems. 
  • Develop ASP.NET UI framework, and integrated with backend, making them compatible with the backend code.
  • Utilized Visual Studio 2003/2005/2008/2010, .NET 1.0/2.0/3.5, SQL Server 2000/2005, Microsoft InfoPath, XML, HTML, and JavaScript in maintenance and development of new web applications.
  • Maintain web front-end servers and database servers by monitoring performance, creating disaster recovery plans, routine backups, and overall database integrity.
  • Design and develop back-end database interface to ASP.NET/C# web applications.
  • Develop programmer guides, maintenance plans and train end users or technical support staff to use and support program.
  • Create test plans for parallel testing and User Acceptance Testing (UAT).
  • Write and maintain documentation of changes to computer code, programs, and specifications.
  • Create SQL stored procedures, functions, reports, and automated processes using SSIS or DTS. 
  • Develop database objects and structures for data storage, retrieval and reporting according to project specifications.
  • Recommend, schedule, and perform software improvements and upgrades.
  • Identify and achieved performance improvements as well as more securing current applications by refactoring and improving legacy code.
  • Review user and technical documentation written by others to confirm consistency with program operations.
  • Revise program for corrections, enhancements, or system environment changes.
  • Produce manuals and train end users or technical support staff to use and support program.
  • Design, create, and organize site collections that support efficient business process workflows; this included participating in user interface design.
  • Continually strived to improve the efficiency and usability of our SharePoint solutions, leveraging ongoing research and understanding of business needs.



Web Developer/Database Developer/Project Manager/ CMS Implementation Consultant
January 2007 - February 2008
Solutions 3x (Sub-Contractor) | Sacramento, CA

  • This role required an all-in-one Database Developer, Web Developer, Project Manager, and CMS Implementation Consultant.
  • Acted as a lead developer and project manager in implementing a Content Management System (CMS) for the California State Capitol Museum website; utilized Ektron CMS 400.
  • Design, maintain, and implement a SQL Server 2005 database as backend the CMS.
  • Develop custom SQL Stored Procedures to add new functionality to the CMS.
  • Develop inbound and outbound data services within SQL server stored procedure, SSIS, SSRS, SSAS and.Net Visual Studio C#.
  • Ensure a secure and sound SQL Server backend system to support the order execution.
  • Established and tracked priorities, dependencies, and completion dates, then monitored the progress. 
  • Used project management software, to accomplish all project management activities.
  • Develop ASP.NET custom modules for web application and User Interface. 
  • Use graphic tools to design web application - Photoshop/Illustrator.
  • Utilize various migration tools to import data from various systems.
  • Perform User Acceptance Testing.
  • Perform additional development in ASP.NET/C#.
  • Recommend, schedule, and perform software improvements and upgrades.
  • Establish and maintain end-user access policy and permissions.
  • Develop robust, responsive User Interface with AJAX, CSS, DHTML, JavaScript, DHTML and XHTML, HTML5.
  • Debug, test, and fix the existing bugs in the JavaScript Framework and add new features to the application.
  • Create SQL stored procedures, functions, reports, and automated processes using SSIS or DTS. 
  • Provide SQL Server database administration/management and apply advanced performance tuning techniques.

Programmer Analyst (Data Modeling and Database Development)
October 2005 - January 2007
California Department of Justice, CMS | Sacramento, CA

  • Develop custom data models and cubes based on current datasets from Case Management Software by utilizing Cognos BI tools (Framework Manager) and SQL Server Analyzer.
  • Produce/Optimize complex, customized reports as well as Ad Hoc queries, including tuning queries in SQL Server as well as Cognos ReportNet and Cognos 8 (Report Studio, Query Studio, and Analysis Studio).
  • Create SQL stored procedures, functions, reports, and automated processes using SSIS or DTS. 
  • Troubleshoot and analyzed data to ensure that delivered data and reports were accurate.
  • Analyzed, validated, and documented user requirements and design and Cognos-based implementation solutions to meet them.
  • Test installed applications according to Integration Test Plans created.
  • Develop IIS intranet/extranet application utilizing ASP and ASP.NET/C#.
  • Develop and maintained procedures to integrate department data to be used with the ProLaw Case Management Software.
  • Perform query optimization, performance tuning, report designing and publication.
  • Develop and maintained documentation and training material.
  • Gather business requirements and translated into technical specifications.
  • Modify SQL database including creating tables, finding the proper indexes and primary keys based on their entities and relations (normalization).
  • Query, retrieve, manipulate and display SQL data for the purpose of internal or ad hoc reporting as requested by the customer or project managers.


Programmer Analyst (Database Design and Development)
June 2004 - October 2005
Department of Fish and Game (Office of Oil Spill and Prevention) | Sacramento, CA

  • Develop database applications utilizing MS Access and SQL.
  • Develop web applications utilizing ASP.NET/C#.
  • Create T-SQL Stored procedures to automate import/export process.
  • Administer several SQL Servers in a production and development environment.
  • Act as the senior SQL Server database administrator.
  • Administer load balanced Citrix server that hosted several MS Access applications.
  • Administer an IIS web server that hosted several web applications.
  • Translate user needs to technical requirements.
  • Assist in validating information back to the data source systems and marrying that data to the business requirements.
  • Provide production monitoring and user support for the reporting systems.
  • Modify SQL database including creating tables, finding the proper indexes and primary keys based on their entities and relations (normalization)

Programmer/Systems Analyst (Database Development and Web Applications)
March 2003 - June 2004
CA State Parks | Sacramento, CA

  • Program T- SQL stored procedures, triggers, cursors, and advanced SQL queries.
  • Develop IIS intranet/extranet applications using ASP.NET, C#, Visual Basic, MS SQL Server, and MS Access.
  • Create VBScript classes to encapsulate business functionality and used the #include command to access the functionality.
  • Procure Systems Analysis and design of the Proposition 40 web site/Project.
  • Assist SQL Server DBA in leading technology challenges and the support of high number of production and lower lifecycle Instances.
  • Learn features of SQL Server newest versions and assist Lead DBAs with implementing production changes that will improve overall database performance.
  • Develop and maintained procedures to integrate department data to be used with Prop 40 project.
  • Develop and maintained documentation and training material.
  • Optimize stored procedures, queries, and various web pages to increase server efficiency.
  • Assisted in preparing materials for Joint Application Design (JAD) sessions, training, and presentations.
  • Maintain project status on project management web and intranet site.
  • Modify database including creating tables, finding the proper indexes and primary keys based on their entities and relations (normalization)

Database Developer & Administrator/ Web Developer
March 2002 - March 2003
Confi-Check | Sacramento, CA

  • Develop ad-hoc management reports using T- SQL stored procedures and queries.
  • Design/developed database and e-commerce web applications with ASP/ADO and ASP.NET/ADO.NET.
  • Produce Daily maintenance review, SQL Server optimization, testing and database import/export support with DTS.
  • Acted as a backup DBA to ensure 24 hours, 7 days a week support of all databases.
  • Provide expert level database advice and support to development team. 
  • Design web pages using Photoshop and other graphic tools. 
  • Develop User Interface.
  • Develop potentially long-running database queries to clean and scrub data.
  • Reverse engineer existing database schemas, stored procedures, queries, and triggers.
  • Implement and wrote stored procedures in Transact-SQL to query databases.
  • Optimize queries to increase server efficiency.
  • Utilize Perl script to scrub data for import.



Database/Web Developer
April 2001 - March 2002
California Air Resources Board | Sacramento

  • Support development of state agency client-server web application utilizing XML/XSL and DTS.
  • Be involved in Database development, design and administration.
  • Ongoing Web and client server development projects utilizing Visual Basic 6.0, Active X, ADO, Microsoft SQL Server 2000, Access, and Windows 2000 Advanced Server.
  • Develop Web electronic applications for scientist lab data inquiry; Extranet Customer Support and Activity Tracking Systems; build and maintain the Web FTP site relational database modeling.
  • Participate in upper management committees on new development, research, organization strategy.



Junior Developer
March 2000 - April 2001
California Energy Resources | Sacramento, CA

  • Develop custom applications for a client/server, multi-user environment in MS Access 97.
  • Troubleshoot compilation errors and performance issues in MS Access 97 and researched new technology for implementing an online Geographic Information System.
  • Develop small database applications using MS Access VBA and modified Excel applications for departmental use.
  • Saved organization time and money by taking on diverse job responsibilities.
  • Create an MS Access database to consolidate data from disparate and mutually incompatible data sources.
  • Create screens for data entry and for querying.
  • Write both technical and user documentation.

 

EDUCATION
California State University of Sacramento | Sacramento, CA
Bachelors, Management Information Systems (MIS)

 

SAMPLE PROJECTS

United States District Court Website:
http://www.caed.uscourts.gov/caednew/

California Eastern District Conference Website:

http://www.caed.uscourts.gov/conference/

California State Capitol Museum Website:
http://capitolmuseum.ca.gov/

Intercare Holdings Insurance Services, Inc.  Online 5020 Claims Form:
https://www.intercareins.com/WebLogin/Account/Login.aspx

California Proposition 40/50 Awards Website:
http://4050bonds.resources.ca.gov/Default.asp

 

REFERENCES
Glenn Fowler
IT Director. United States District Court Eastern District of California
Office: 916-930-4074
Cell: 916-264-4734
gfowler@caed.uscourts.gov

Kou Moua
IT Supervisor. United States District Court Eastern District of California
Office: 916-930-4009
Cell: 916-599-1315
kmoua@caed.uscourts.gov

Frank Young
Senior Programmer.  United States District Court Eastern District of California
Office: 916-930-4079
fyoung@caed.uscourts.gov

Jennifer Fry
Product Support Manager.  IHI Services, Inc.
Office: 916-677-2101
Cell: 916-616-5807
JFry@IHIServices.Com

Oscar Vasquez
Systems Analyst CA State Parks
916-835-0253
ovasq@parks.ca.gov

Melissa Glipa
Analyst State Parks
916-657-4448

Mike Flores
Supervisor CA State Parks
916-651-6722
mflores@parks.ca.gov

Nadine Reid
System Specialist Department of Justice
(916) 324-3849
Nadine.Reid@DOJ.CA.GOV

John Petersen
CEO Solutions 3x
916-765-2195
john@solutions3x.com