SQL/SSIS Developer
Resume:
Carlos Parra
McKinney, TX *****
E-mail: *********@*****.***
https://www.linkedin.com/in/parracarlos
OBJECTIVE: To obtain a position in Business Intelligence and/or Data ETL,
which utilizes my problem solving, analytical and
leadership skills along with my total commitment to the
organization's goals.
SKILLS: SQL, SSIS, SSRS, DTS, Business Intelligence, SQL Server 2000-
2012, ASP, CDO, DHTML, HTML, JavaScript, VBScript,, Visual
Studio 2005-2013, Microsoft Office, Windows Platforms,
including Microsoft Small Business Servers, Extensive
knowledge of windows based networking, IIS, FTP Servers,
DNS, Mail Servers
PROFESSIONAL EXPERIENCE:
1/12 - 5/15. Compass Professional Health Services
Senior ETL/SSIS Developer
At Compass I automated all file loads that would come to us
from many different clients. Automating the loads involved
the creation of countless SSIS packages created to download
the files, put files through extensive business rules
tailored to each client, validated the data to make sure
the key components were present, distributed the data to
the right tables in the data warehouse and produced
reports. In order to gather all business rules, I had to
interact with both, senior level executives and various
departments such as client services and business
operations. The SSIS packages are a combination of SSIS
tasks and SQL stored procedures. The packages were created
in Visual Studio 2008 and 2012. I upgraded earlier packages
to 2012. The file sources came in many different formats
such as csv, txt, xls, dat, pgp, zip, EDI files, etc. I
also created automated processes to login to the client's
SFTP sites to report on any files that were uploaded that
were not part of the medical claims files. In addition I
led a team of developers overseas and guided them to create
extra SSIS packages to load other types of files to support
the business. Besides SSIS, I also used SSRS to create
custom reports and TFS to manage package
changes/versioning.
10/09 - 1/12 Data Paradigm, Inc.
Applications Developer
While at Data Paradigm, I worked with their biggest client,
ACN. I maintained ACN's file loads which run twice daily
from compressed comma delimited files through an SSIS
package. I created ACN's Online Representative's Training
Tool using all aspects of the SDLC. SQL Server 2008
backend, Classic ASP and VBScript front end. Extensive use
of views, stored procedures, table triggers. Writing SSIS
packages for data loading from MS Excel for reps who view
training outside the app. Interfaced on a daily basis with
ACN's headquarters in North Carolina, Amsterdam, Australia
and South Korea, handling multiple web projects for each
region. I was also responsible for maintaining ACN's
Independent representatives' websites worldwide in 22
different languages. The sites run on SQL Server 2008.
ASP/VBScript front ends.
06/05 - 10/09 ISIS, LTC
Systems Administrator/Software Developer
At ISIS, I built the company's MS Server 2003. Installed
and configured SQL Server 2000. I was the server
administrator. I setup backups, scheduled jobs, data
replication, etc. Besides the administration tasks, I led
the team in the creation and execution of the company's
Nursing Management Application. I created DTS packages to
manipulate data from SQL server and export it to a
government specific file for EDI transmission to CMS
(Centers for Medicare and Medicaid Services) I wrote many
stored procedures, database views, table triggers, etc.
06/03 - 06/05 Joint Systems, LLC
Systems Administrator/Software Development
At Joint Systems I managed a team to create various IT
projects, including Windows Based Networks and Web
Applications (ASP/VBScript, SQL Server 2000). On Windows
networking projects, I was responsible for managing and
executing projects from start to finish; gathering all
requirements for networks; putting together solutions for
the clients including planning, purchasing and set-up of
all hardware and equipment needed. I implemented both
Hardware/Software based VPN's. For Web Applications:
gathered requirements from client and put together a
project plan for completion. Developed various web
applications including database driven websites for e-
commerce and online cataloging. Responsible for Collocation
of windows servers and hosting of 120 + websites on IIS 6.0
and RedHat Enterprise 3
02/00 - 06/03 ePartners, Inc.
Webmaster/Search Engine Optimizer
I built the web server from the ground up and was
responsible for maintenance and updates of ePartners, Inc.
corporate website http://www.epartnersolutions.com. I also
Created ASP web applications for database entry on SQL
Server 2000. Created graphics using Paint Shop Pro and
Photoshop. Extensive use of JavaScript and DHTML for visual
effects. Established ePartners' CyberCash Account for e-
commerce. Full IIS 5.0 Administration on Windows 2000
Advanced Server. Performed all database tasks such as
creation, back-up, maintenance, scheduled tasks, DTS
packages, updates, etc. Created and maintained the
company's search engine positioning strategy, keeping
ePartners on the top position for key terms such as: Great
Plains Training, SalesLogix Training, ERP comparisons, etc.
Created templates for live reporting of daily website
activity with WebTrends Traffic Analyzer. Created Database
application as an add-on to Onyx for the internal network.
08/97 - 01/00 GTE Corporation (Verizon)
Technical Consultant
I worked as a consultant at GTE Corporation, now Verizon. I
created and maintained GTE's internal electronic library of
documents issued by the Business Response Provisioning
Center (BRPC) staff support. I converted all business
documents to HTML format from multiple sources including
word documents, PDFs and numerous hard copies. I created
downloadable zip files of all documents for offline
viewing; used Photo Shop and Paint Shop Pro for creation of
images and logos and Micrografx Simply 3D for animations
and rotating images. I also helped develop an Access
database to keep track of equipment testing performed by
TBS/Pilot Systems group. In addition to the above, I
supported the local department intranet consisting of 25
PC's running Windows NT 4.0 and Windows 95; and helped to
maintain the local printers, scanners and storage devices.
EDUCATION: Ambassador University
B.S. Degree in Management Information Systems
Minor in Business Administration
Bilingual English-Spanish
Contact this candidate