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. Microsoft Intune(MDM), SCCM, creating complicated queries.

Platforms:

• Unix Platforms: HP9000, AIX, SCO, Sun
• Microsoft Windows Platforms: XP , Server 2000-201 2, Windows XP 10, NT 5.0, .NET 2003
• Sequel server 7 - 2012
• Microsoft: Office Suites 2000 - 201 2
• Linux

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

EXPERIENCE:

Administrator/BI Developer

Responsibilities:

• 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.

Platinum Support Engineer

Responsibilities:

• 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

Responsibilities:

• 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.

Senior System Analyst

Responsibilities:

• 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.

Programmer Consultant

Responsibilities:

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

Programmer Consultant

Responsibilities:

• 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.

Programmer Consultant

Responsibilities:

• 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

Programmer Consultant

Responsibilities:

• 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

Programmer

Responsibilities:

• 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

Programmer/Analyst

Responsibilities:

• 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

Programmer

Responsibilities:

• 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

Programmer/Analyst

Responsibilities:

• 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