Sql Server Information Technology

ALLAN ARCIA

*** ** *** *****, *****, FL ***** ● Cell: 786-***-**** ● Email: **********@*****.***

Sr. Information System Analyst / Developer / Project Manager

Motivated IT Professional, eager to contribute to the transformation of business and industrials processes into cost-effective information systems applications that can support your firm’s ability to increase growth, profitability, and efficiencies. My goal is to apply and enhance my managerial expertise in Information Technology projects and my proven knowledge of software engineering methodologies for the design, development, and implementation of successful information systems.

PROFESSIONAL PROFILE

Seasoned IT Professional with comprehensive business/technical skill set with 15+ years of continuous advance and experience in the Information technology industry, including the areas of automation and management of information Systems, enterprise application integration, project management, process improvement, systems integration, requirements analysis, team development design, processes and data modeling, testing/quality assurance, software development, contingency plans, customer service and support.

Proactive self-starter with track record of initiative, personal responsibility and ownership of work in both individual and team settings.

Ability to focus on results and customer/user satisfaction.

Proven leadership and people skills, highly committed to quality and on-time completion of assignments.

Multicultural experience through coordination and development of IT Projects in Latin America.

Enthusiastic team player and learner, open to share knowledge and experience and facility to quickly grasp new concepts and technical skills.

TECHNICAL SKILLS

IT Process Engineering

IT Projects Supervision & Coordination

IT Process Design, Measurement, Improvement & Optimization

Information Systems Analysis, Design & Management

Windows and Web Application Development

Enterprise Application Integration

Reusable IT Processes Flows

Requirements Analysis & Data and Process Modeling

Database Design and Maintenance

Data Warehouse Design & Management

Data Management and Analysis

Programming Languages and Applications

MS-Visual Studio .NET

VB, C, C# & C++, Java, COBOL

HTML, XML & ASP

SQL, SSIS (SQL Server Integration Services)

Salesforce

Informatica

WTS Paradigm (ERP, Quoting & manufacturing system)

Reporting: SSRS, Active Reports, Crystal Reports

MS Office: Excel, Word, Visio, Project, Power Point

Operating Systems: Windows, Unix, VMS

Databases: SQL Server, Oracle, Informix, MS Access

PROFESSIONAL EXPERIENCE

IT Supervisor \ Sr. Computer System Analyst & Developer, CGI Windows and Doors, Inc. (Apr 2005 – Jun 2016)

Miami, Florida.

Design, development, Implementation, and maintenance of an application to monitor and controls the painting of custom colors for Aluminum extrusions, shipping and receiving. This was a windows forms application, and VB6 was used as development tool with MS access as database. The application was maintained since 2005 to 2009.

Design, development, Implementation, and maintenance of a Manufacturing Windows Server\Client application. This is a windows forms application, VB6 and C# was used as development tool, SQL server as database, store procedures. Crystal Report was used as report tool. The application was maintained since 2005 to 2009.

Participation in the selection of a new Manufacturing ERP system, WTS paradigm, modules Centerpoint & Masterpoint

Direct support and assistant to IT auditors: data preparation for SOX reports, performing security vulnerability scans, reviewing application and operating system access controls, and analyzing physical access to the systems. Tracking user actions data or software access and modifications. We used SQL server store procedures and SSRS as report tool.

Data preparation, transformation and migration to WTS paradigm. We used VB.Net to create the ETL background applications, so, SQL server store procedures, functions, and jobs. This was one year project.

Management and modifications of WTS paradigm system configurations.

A.Arcia – page 2 of 3

Design, Implementation, and Maintenance of quoting and manufacturing reports for the WTS modules. We used SSRS a report tools and SQL server store procedures and functions. WTS Reports implemented since 2009.

Design, Implementation, generation, and subscription of reports for direction staff, using SSRS as report tool, SQL Server store procedures and jobs. They have been used since 2009.

Design, Implementation, and printing of scanning labels to control and optimize different manufacturing processes, like cutting, assembly, glazing, material pick list, materials receiving, shipping, etc. We used SQL server as database and store procedures, so, Active Reports as report tool. Reports implementation since 2009.

Implementation of different reading scanning processes using the barcode modules of WTS. The front-end were implemented using VB.Net and Web Services to access the SQL server database. Barcode applications implemented since 2009

Design and Implementation of a reporting web platform for our rep salesmen, Salesforce, it was used to accomplish this task in combination with Informatica to bridge data between Salesforce and WTS. We implemented the SQL server store procedures, functions and jobs. This application has been used since 2009.

Design and Implementation of the WTS data warehouse. Creation and implementation of SQL server jobs, SSIS, store procedures and functions. This application has been used since 2009.

Creation, Design and Implementation of applications to manage additional tasks using the WTS database as data source. We used VB & C# .Net as front and back end development. Besides SQL server as database, creation of store procedures and functions, and XML management. Applications developed and maintained since 2005:

Creation, Design, and Implementation of a front end application for Scanner Devices, Motorola MC300, Windows embedded 7. The finished products location information is updated in real time using web services to connect the device application with the WTS database.

Background and front-end application to send glass orders to providers, EDI Xml files sent via FTP\eMail.

Automation of delivery of open orders report for dealers via eMail\Fax.

Application to Manage and monitor orders with custom finish painting.

Maintenance of a clock-in-out application. It used MSAccess as database.

Maintenance and optimization of WTS paradigm database, SQL server database

Creation, Modification, and new add-on of products in WTS paradigm.

Planning, Testing, and release of new PK (product knowledge) versions of WTS paradigm.

Technical support of WTS paradigm for CGI dealers.

Web Application Coordinator, University of Florida, Institute of Food and Agricultural Science, IFAS (Dec 2003 – Jan 2005)

Gainesville, Florida.

Web development and maintenance, gathering system requirements, system design, codification, and testing. We use VB ASP.Net as front and back end. SQL server as database.

Participated of development of web service to handle the system user authentication, implemented with VB.Net

Design and implementation of a team development environment and source control using Visual Source Safe, VSS.

Implemented the automation of the building process for applications and versions control using the tool BuildIt.

Participated on Creation of programs & Data Transformation Services, DTS, for the loading data process from external systems.

Participated of staff meetings to gather new user information requirements and define their system solutions.

EDUCATION

Universidad Nacional de Ingenieria (UNI) - Managua, Nicaragua.

Bachelor of Science in Computer Systems Engineer, Information Technology concentration, July 1993.

TRAINING

SQL Server 2010 Business Information Course

Managing SQL business Intelligence operations, Analyzing data with SQL Server Reporting Services.

Implementing SQL Data Warehousing.

ACTIVITIES AND PROFESSIONAL AFFILIATIONS

IEEE Computer Society, Active member, http://www.ieee.org

PROFFESIONAL REFERENCES

Jeremy Schweickert

IT Manager at CGI Windows 2015-present

CGI Windows and Doors, Inc

Telephone: 305-***-****

eMail: ***********@*******.***

Jorge Santaella

Former COO at CGI Windows 2005-2015

General Manager TM Windows & Doors, LLC.

Telephone: 954-***-****

eMail: **********@********.***

Contact this candidate