Data Technical Support

RANDY SARRAZIN

Qualifications

I am a skilled System/Data Analyst and Developer and Technical support analyst, and have worked within many environments and languages. I adapt well to a company’s business practice and am always excited about new learning experience and combining my years of data processing knowledge in building and maintaining systems for the success of the company and end users. I enjoy working with a team or independently when gathering functional and technical specifications and information from end users and have an open mind when discussing best approaches and practices with my peers and management. I have the ability to learn new tools and techniques with and without formal training. A self-starter with the ability to be flexible with job duties as a business evolves.

Skills:

Languages:

SQL: Proficient in query building stored procedures and views. T-SQL PL/SQL, I-SQL and MYSQL, have used ssis, dts, and bids as etl tools, C#, C, C++, have used data modeling for defining the flow in developing systems.

Crystal Reports 11: I have developed from simple to complex reports creating custom function and formulas. Creating stored procedures for data extraction and used advanced grouping and formatting techniques. Really excited about the business object architecture and the many way of content and delivery of the data

Unix Scripting: Unix Shell Scripting( BOURNE and POSIX shells) and Perl, XML

Other: Visual Basic, .NET 2003 C#, USCRIPT, MISDESIGNER, BUSSINESS OBJECTS, DTS, SSIS, ETL, HTML,XHTML,CSS, HIPPA,HL7, X12 ansi, functional/technical specification and data modeling. Office 365, SharePoint. PowerBI(PowerPiviot, PowerQuery, Q&A). Citrix Sharefile, Share Point.

Platforms:

Unix Platforms: HP9000, AIX, SCO, Sun

Microsoft Windows Platforms: XP, Server 2000-2012, Windows XP 10, NT 5.0, .NET 2003

Sequel server 7 – 2012

Microsoft: Office Suites 2000 - 2012

Linux

Databases: SQL Server 2000- 2012, ORACLE 8I, Informix, Unisys (UNIDATA), ISAM, VSAM

Experience:

Jaco Incorporated 2015 - 2016

Administrator/BI Developer

Administered Oficce365 for internal customers (Creating new users and maintaining current users), Active directory

Developed PowerBI reports for external customers using PowerPivot, PowerQuery, PowerView and Q&A. Created SharePoint sites for external customer’s access.

Developed complicated queries for data analysis and troubleshooting data issues, for external customers.

Salesforce/Exacttarget 2014 - 2015

Platinum Support Engineer

Provide post-implementation product support to Platinum Support customers

• Manage customer support cases on a daily basis, which includes verifying cases, analyzing data, isolating and diagnosing the problem, resolving issues including:

• Responding to Customer-reported issues in a timely manner and/or per service level agreements

• Communicate progress of resolution/status to the customer in a timely fashion and/or per service level agreements

• Manage escalations and expectations for both the customer and Internal personnel

• Coordinate with Product Management, Product Operations, and Development teams in identifying, reporting, and resolving product issues.

• Author, edit, publish and maintain solutions of known issues/solutions

• Achieve subject matter expertise in the ExactTarget platform including

• API - REST, WebServices, XML

• Partner Integrations

• AMPScript (our proprietary language)

• Server Side JavaScript

• Custom Product Lines

Self Employed 2012

Worked on a part time basis for companies Talyst, Silicon mechanics, RPM doing routine server upgrades and builds reporting using crystal and sql server 2008 r2, Technical support on Talyst packager and medication carousel,or any task that needed to be done.

Navos

2009-2011

Senior System Analyst

Developed and Maintained an ADT(Admit Discharge Transfer) for the hospital inpatient system, from (initial analysis to the development of and testing to implementation and user acceptance) . Developed all interfaces to the (pharmacy, billing, created scripts to test and compare data from all data sources to insure the patient information was correct . systems, and (EMR)electronic medical records system. compliance/credentialing) using the HL7 coding standards. Developed and maintained reporting for the pharmacy using Crystal Reports, used ETL tools(DTS, SSIS, SSRS) and business objects for creating reports and data integrity checks, developed test case to insure data quality. Developed and Maintained all aspects of the outpatient systems using, Unix shell scripting and MisDesigner, from billing to notes and reporting to the county services, worked with claims processing and interfaces using the hippa (835,837,270,271,277,278) interfaces, IDC 9, IDC10.

Unified Grocers

2008 - 2009

Programmer Consultant

Helped build an interface between Corporate and Seattle Item Maintenance process using Unix Shell Scripting and Sequel Cards in an Informix environment.

Hewllet Packard Services

2007 – 2008

Programmer Consultant

Working for H/P Services, helped convert CIS(College Information Services), HP3000 to a client server environment using ACU COBOL by performing regression testing, and Sequel Performance tuning, using Sequel Server 2005, and Sequel Profiler.

Union Tribune

2006 - 2007

Programmer Consultant

Maintained and enhanced current Order Entry Billing System/Accounts Payable during the migration from VAX COBOL to SQL Server 2005

Developed T-SQL queries for reporting and data mapping/migration of the Vax data to the sequel data base.

Created test scripts to ensure the data being migrated was migrated properly to the new system by pulling data from both sources and comparing the patterns to the new database being used.

Responsible for daily production and operational procedures on the VAX using DTR a DCL

N.C. Transit District

2005 - 2006

Programmer Consultant

Developed and maintained the companies, ACORS (Automated Coach Operators System) Scheduling and Bid Processing and Attendance

Maintained the (I.P.PS.) Union Payroll/ Earnings System

Maintained and enhanced in house Human Resource and OCERS/PERS Retirement System

Prime Operating environment using Prime Cobol

Kelly Paper

2000 - 2004

Programmer

Sole programmer on staff maintaining and troubleshooting the 50+ stores in California, Nevada & Arizona on a standalone COBOL Point of Sales system running SCO UNIX

Maintained the uploads of the Sales, Taxes, Orders and Inventory management

Provided analysis on how to replace the daily uploads to give instant Inventory management and deliveries

Created a Counter Billing system to alleviate the uploads so stores could check inventory place orders for next day deliveries and all sales were recorded

Maintained the corporate Distribution Inventory system running on SUN UNIX platform using Micro Focus COBOL

Replaced a paper based picking system by implementing a RF Picking and Put-away system using Micro Focus COBOL

Created all algorithms Picking and Put-away trained warehouse staff procedures

Maintained the Road Show logistics routing software

Developed an intranet to help communication within the company using Front Page and .NET with SQL Server backend

Liaised with department managers on a weekly basis to determine any new business needs and find solutions for those needs

Orange County Transit Authority

1995 - 2000

Programmer/Analyst

Provided analysis and worked with Operations Management defining the rules of the Union Attendance contract

Created an Attendance Tracking System for the Drivers and Mechanics

Created the nightly process of all the rules and policies previously defined

This program processed each Union Employee on a daily basis and there attendance on a 365 day rolling calendar, and determined Letters and Disciplines for each Union employee. This program was about 25000 lines of code.

Troubleshot program and provided enhancements, working with the end users (Managers, Payroll and Human Resources) on a daily basis to solve their business needs

Created all downloads for the Data Warehousing system

Worked with team of programmers to determine how to convert the current system to be Y2k compliant, and then make the changes

Work was performed on a UNIX HP9000 and Micro focus COBOL

Exact Tax

1994 - 1995

Programmer

Enhanced and maintained Federal and 10 individual states new tax codes changes for Partnerships Returns

Analyzed on how to extract data from an individuals current return and created a file to be downloaded to individual states, and the Fed system

Designed the EDI standards with the IRS and Local and State government

Developed an EDI file to dynamically update and download the returns of each individuals to the appropriate State agencies and Federal government

Worked in COBOL, AcuCOBOL, Delphi and Windows environment

Somerset Automation

1993 - 1994

Programmer/Analyst

Provided service and maintenance to Columbia Sportswear and Indiana Corporation

Worked with management and end users to find solutions to daily needs of Inventory Management and Distribution

Provided end user training and process improvement, enhancing and simplifying all aspects of their business needs

Worked in AcuCOBOL, Windows Environment

COBOL running on IBM AIX UNIX platform

Education

AA, Computer Science, Long Beach Business College

Contact this candidate