SUMMARY

• Over 20 years of IT experience in enterprise architecture, design and development of integrated business systems,
• Microsoft SQL Server, Microsoft SSIS, Microsoft SSRSIn Data Warehouse Design Data Modeling, Data Architecture and Design including Confidential .
• Participated in executing projects in various levels, such as an Architect, Lead Consultant, Business Analyst, and Senior Consultant.
• Practiced at winning Customer confidence.
• Experience is gained in variety of industry sectors including Aerospace, Utilities, Retail, Health Care/Pharma, Insurance,
• Banking/Financial, Education, Construction, Real Estate, IT Services & Products.
• Microsoft SQL Server TSQL Versions 6 - 2014 (15+ years Experience) Microsoft SQL Server SSIS, SSRS (4+ years Experience) Oracle PSQL Versions 8i - 11g (8+ years Experience) Leading Team, Initiative, Client facing skills, Liasoning, Prepare Business Blueprint, Write Functional Specs, Create Technical Design Documents (15+ years Experience) SAP Data Services (9+ years Experience) SAP Data Services Workbench (1 Year+ Experience) SAP ECC (4+ years Experience) SAP HANA (1 Year Experience) SAP Migration Best Practices (3 Year Experience)

PROFESSIONAL EXPERIENCE

Confidential, Tempe AZ

Senior SAP Data Migration Developer

Responsibilities:

• Senior Technical Data Lead for Confidential work stream.
• Developed ETL with Pre-Vals and Post-load reports for
• C HSC 016-Transport Units, C HSC 009-Routes, C HSC 015-Vehicles, C HSC 013-TSW Location,C HSC 010-Transport System, C HSC 017-Partner Roles, C HSC 034 Open Contracts(Product Excahnges), C HSC 039 Pricing Condition Records (Transfer Pricing), C HSC 022 Open Freight Agreements, C HSC 033 Open Deals (Commercial & MM-PRA Contracts), C HSC 036 Open Throughput/Terminal Logistics Agreements, C HSC 037 - Pricing Condition Assignment (Exchanges & Freight, C HSC 024 Inventory Balance, C HSC 023 Open Exchange Balances, C PTP 110-Batch numbers
• Extracted data from multiple legacy sources and loaded into SAP 4 HANA using SAP BODS 4.2 SP9.

Confidential, Phoenix AZ

Microsoft/Salesforce EDW Consultant

Responsibilities:

• Developing SQL Server 2016 SQL Queries/SSIS ETL Packages to pull data for the MACRA ( Confidential Access and CHIP Reauthorization Act of 2015) and load the data in to Salesforce 2017 Using Dataloader.

Confidential, Los Angeles CA

Microsoft SQL Developer/ ETL Lead EDW Consultant

Responsibilities:

• Re-architected current ETL loads to save over 3 hours on load time utilizing SAP Data Services best practices with bulk inserts, Server Memory Configuration.
• Converted many slow running SQL server stored procedures to ETL interfaces.
• Target Data SQL Server 2012.
• Mentored staff on Best practices for ETL Development, Administration, and Server Configuration for SAP Data Services.
• Created tables/views/SPs/Indexes in SQL Server.
• Performance tuned EDW in SQL Server.
• Was user facing with many Customers requiring system development.
• Did On Call support and troubleshooting of job failures.
• Created SQL test scripts to validate data.
• Migrated ETL Code in Data Management Console from dev to qa to prod.
• Migrated table structures/Views from dev to qa to prod.
• Created SQL scripts to migrate new changes to existing table structures.

Confidential, Phoenix AZ

Microsoft SQL Developer/ ETL Lead EDW Consultant

Responsibilities:

• Developed over 100 SAP Data Services interfaces staging data from SAP ECC on Hana, S ales Force, MySQL, Multiple Legacy SQL Server 2012 Sources, Cloud, and Flat files into a Reporting EDW on SQL Server 2012.
• The EDW was built with a Staging, Acquisition Layer, Core Normalized Layer and CORE BI denormalized layer for reporting.
• Created tables/views/SPs/Indexes in SQL Server.
• Performance tuned EDW in SQL Server.
• Held workshops with users to go thru requirements.
• Was user facing with many Customers requiring system development.
• Did On Call support and troubleshooting of job failures.
• Created SQL test scripts to validate data.
• Migrated ETL Code in Data Management Console from dev to qa to prod.
• Migrated table structures/Views from dev to qa to prod.
• Created SQL scripts to migrate new changes to existing table structures.
• Developed a POC to pull Salesforce Account data directly into SAP ECC via RFC Call.

Confidential, Irvine CA

Microsoft SQL Developer/ ETL Lead EDW Consultant

Responsibilities:

• Developed SAP Data Services jobs to load source data from Prowess MLM Software, Oracle 11i EBS Accounting and other disparate sources as well.
• Designed EDW Star Schemas and did the ddl using SQL Server 2012 as the database.
• Created tables/views/SPs/Indexes in SQL Server.
• Performance tuned EDW in SQL Server.
• Mentored other ETL developers on SAP Data Services.
• Worked with Business Users on validation of data and EDW needs requests.
• Did all of the SAP Data Services 4.2 Administration and code migration.
• Architected the ETL Solution.

Confidential, Renton WA

SAP Lead Data Migration Consultant

Responsibilities:

• Developed SAP Data Services jobs to do both Pre load and Post load validations of data being loaded from legacy sources into SAP ECC.
• Created jobs for work streams:
• Profiled data, created master records using the match wizard. Created Workbench jobs from the Data Quality Advisor in Information
• Steward based on choices made during Data Quality Advisor.
• IMWM(Material Master, Stock Balance, Storage Bins)
• PDM(Material Master, BOM, Document Info Records, Classification, Equipment).
• OTC(Open Releases)
• MRO( Confidential Requirements, Routing Recipe)
• P2P(Vendor Master, Source List, Request For Quote, Contract, Inbound Shipping Notification, Purchase Info, Purchase Order)
• Developed ABAP data flows to stage SAP data to be used in Post Load Reconciliation Reports.

Confidential, San Francisco CA

SAP Lead Data Services Architect

Responsibilities:

• POC to show how the process to convert 1000 Data Stage ETL Jobs to SAP Data Services.
• Developed Jobs in SAP Data Services Workbench 4.2 utilizing data mapping templates and mass flat file loading to allow faster development.
• Profiled data using the Data Quality advisor in Information Steward 4.2 to help optimize the Data Services Jobs.
• All jobs took advantage of SAP Data Services 4.2 speed/efficiency techniques including
• Bulk loading of new data, merging of updates with Auto Correct Load with full pushdown,
• Degrees of parallelism which allowed extracting from very large dimension tables > 1 million rows data very quickly.
• Data stage processes that took 32 jobs to execute were rewritten in SAP Data Services in 4 jobs.
• Environment SAP Data Services 4.2 sp1. Oracle 11g, SAP ECC.
• Created Tables, Views, Stored Procedures in Oracle 11g. Wrote Oracle SQL statements to test ETL jobs.

Confidential, Tempe AZ

Senior Data Warehouse Consultant

Responsibilities:

• Architected and developed the ETL processes to move data to and from Salesforce CRM using the Salesforce Adapter in
• SAP Data Services 4.1 to a SQL Server 2012 Data Warehouse.
• Created Microsoft SSIS packages to load data into SQL Server 2012 Data Warehouse.
• Created Tables, Views and Stored Procedures in SQL Server 2012 and Oracle 11g.
• Wrote Microsoft SSRS reports.
• Converted and migrated existing .unv universes to .unx universes.
• Updated corresponding .unx universes using the Information Design Tool.
• Created/modified reports using Web Intelligence, Crystal Reports and Crystal Enterprise Reports .
• Developed SAP Explorer Information spaces for user consumption.
• Promoted users, Confidential and Relational connections and reports with the promotion management tool.
• Wrote SAP Data Services ETL processes to load into a SAP Hana Instance from multiple disparate sources.
• Modeled Attribute Views, Analytic Views and Calculation Views for report consumption.
• The environment is SAP Data Services 4.1, BOBJ 4.1, SAP Hana SP05, Oracle 11g, SQL Server 2012.

Confidential, Huntington Beach CA

Senior Data Warehouse Consultant

Responsibilities:

• Extracting SAP Customer, Vendor, Material, Billing, Purchasing, and Purchase Order,
• Sales Order Retail data using SAP Data Services ABAP data flows and loading into a SQL Server 2008 R2 Data Warehouse.
• Created Microsoft SSIS packages to load data into SQL Server 2008 R2 Data Warehouse.
• Created Tables, Views and Stored Procedures in SQL Server 2012 and Oracle 11g.
• Wrote Microsoft SSRS reports.
• Created Tables, Views and Stored Procedures in the Oracle 11g staging area.
• Updated corresponding universes, modified reports using Web Intelligence.
• The environment is SAP ECC 6.0, Data Services XI3.2, 4.1, BOBJ XI 3.1, SQL Server 2008 R2, Oracle 11g.

Confidential, Tempe AZ

SAP Principle Data Migration Consultant

Responsibilities:

• Customized Sap Data Migration Toolkit Data Services 4.0 ETL Jobs for Customer
• (CM), Vendor(VM), Material Master (MM) and ITD Costs objects.
• Cleansed and de-duped Customer Master data using SAP Data Services and the Global address Cleanse with the Best Match transform.
• The environment is SAP ECC 6.0, Data Services 4.0 and Information Steward 4.0.
• Mentored other developers on Data Services best practices.
• Administered all code migrations from development to test to prod.
• Developed Data Services jobs to create legacy to SAP Reconciliation reports for Customer, Vendor, Material Master, Sales Contracts and PO's.
• Created Crystal Reports to display reconciliation data for user consumption.
• Assisted in creating the security structure for Information Steward.
• Assisted SAP Basis resources troubleshoot BODS system issues.
• Created Tables, Views and Stored Procedures in the Oracle 11g staging environment.

Confidential

Business Objects Architect/Developer

Responsibilities:

• Supported 4 different BOBJ XI 3.1 Reporting environments.
• Administered the reporting servers, configured security, and migrated changes from dev to pre-prod to prod.
• Developed new BOBJ XI 3.1 Universes and Web Intelligence reports for each of the reporting environments.
• Mentored power users on Web Intelligence Reporting best practices.
• Created/Maintained the SQL Server 2008 R2 Stored Procedures and Jobs that were executed twice a day to load the reporting Data Warehouse/Data Marts.
• Created/Maintained the SQL Server 2008 R2 views that were used in the BOBJ XI 3.1 Universes.
• Configured both field level and row level security in the universes as well.
• Made all bug fixes and re-deployments of the BOBJ XI 3.1 universes.
• Mentored SAP developers on using Crystal Reports/Web Intelligence using BICS.
• Developed SSRS 2008 R2 Reports for 3 Different applications reporting on SSAS CUBES, SQL Server 2008 R2 Stored Procedures, Views.
• Developed all of the TSQL code used by the Business Objects Reports as well as the SSRS 2008 R2 Reports.

Confidential, San Diego CA

Business Objects Architect/Developer

Responsibilities:

• Developed BOBJ XI 3.1 Universes and Web Intelligence reports to track business diversity allocation.
• The reports tracked how the company donated funds to Diverse Business Enterprises to qualify for government funding.
• Environment was SAP BW 7.1, BOBJ XI 3.1 Sp2

Confidential

Business Objects Architect/Developer

Responsibilities:

• Created a self serve reporting environment for Daily, WTD, MTD, YTD for KPI’s including Sales, Store traffic, Associate Efficiency and profitably etc.
• This environment included Business Objects XI 3.1 SP 2 with Confidential designer, Web Intelligence, Confidential .
• The Back-end database was SQL Server 2008.
• This SQL Server Environment consolidated many different data extracts into one data mart and using Confidential designer and
• Web Intelligence has the tools for the self server reporting.
• Worked with the SAP BW 7.1 BOBJ XI 3.1 Sp2 installation they had and designed with the SAP BI the beginnings of the strategy to utilize the BOBJ reporting environment with SAP BW and BWA. The future would be to eliminate all of the SQL Server 2008 reporting marts and pull directly from SAP BW or BWA in version 7.3 utilizing BOBJ Data Services.

Confidential

Business Objects Architect/Developer

Responsibilities:

• Lead Data Services XI 3.2 Developer on a team that created ETL scripts to pull disclosure data from world wide entities into SQL Server 2005 Data Warehouse/Data Marts ( Confidential ) utilized Business Objects Data Services XI 3.2.
• Modeled the data for the marts/warehouse.
• Created all SQL scripts for tables, views and stored procedures as well as all ETL.
• Built universes and reports based on the marts/warehouse utilizing Web Intelligence

Confidential, San Jose Ca

Business Objects Architect/Developer

Responsibilities:

• Lead Data Services XI 3.2 Developer on a team that created ETL scripts to pull worldwide data from the US and load into Sql Server 2005
• Data Warehouse/Data Marts ( Confidential ) utilizing Business Objects Data Services XI 3.2
• Mentored staff on methods of Data Integrator ETL scripting to the most efficient processing of the information.
• Modeled the data for the marts/warehouse.
• Created all SQL scripts for tables, views and stored procedures and created all of the ETL.

Confidential

Business Objects Architect/Developer

Responsibilities:

• Loaded member company information and load into Sql Server 2005 Data Warehouse/Data Marts
• Confidential ) utilizing Business Objects Data Services XI 3.1
• Wrote extensive SQL Server 2005 TSQL.
• Mentored staff on methods of Data Integrator ETL scripting to the most efficient processing of the information.
• Modeled the data for the marts/warehouse.
• Created all SQL scripts for tables, views and stored procedures and created all of the etl.
• Built universes and reports based on the marts/warehouse utilizing Web Intelligence/ Confidential Designer XI 3.1

Confidential

Business Objects Architect/Developer

Responsibilities:

• Lead Data Integrator 11.7 Developer on a team that created ETL scripts for a system that processed over 750+
• Confidential data every night and load into Oracle 10g Data Warehouse/Data Marts ( Confidential ) utilizing Data Integrator Accelerated .
• Wrote extensive Oracle P/L SQL.
• Mentored staff on methods of Data Integrator ETL scripting to the most efficient processing of the information.
• Web Intelligence/ Confidential Designer XI R2

Confidential

Sr Consultant

Responsibilities:

• Data Modeled Confidential Data Mart in Sql Server 2005.
• Wrote ETL to stage data from there STOREIS Operational Store System
• Wrote all of the Data Integrator scripts to load the Data Mart from the production system via Confidential UNidata ODBC.
• Created Business Objects Confidential and web Intelligence reports for the Sales Order system.
• BOE XI 3.0 Enterprise
• Web Intelligence/ Confidential Designer 3.0
• Data Integrator 11.7.3

Confidential, Washington

Business Objects/Crystal Reports Developer

Responsibilities:

• Developed 12 Crystal Reports XI R2 Reports for Confidential & Industries.
• Utilized Cascading prompts and Business Views with a SQL Server 2005 Back-end database
• Wrote SQL Server Command Objects to use for data sources for the reports.
• Mentored staff on Crystal Reports Development.
• Mentored users on Infoview use.
• Made BOE XI R2 configuration recommendations to staff.
• Created Demo installation of BOE XI 3.0 and crystal reports 2008.

Confidential, Chicago Illinois

Business Objects Architect/Developer

Responsibilities:

• Used Data Integrator 11.7 to stage data from Mainframe and SQL Server 2000 database and integrated the two into a new data warehouse used for reporting.
• Major report development moving key reports from the Confidential Mainframe to Crystal Reports XI R2 Server environment.
• Extensive Confidential DB2 SQL development used for the data sources for key production reports utilizing Advanced Query Tool (AQT).
• Crystal Reports XI R2
• Confidential DB2 Version 9.1.0.356
• Utilized Confidential ODBC connection for the reports.
• Mentored staff on Crystal Reports Development.
• Mentored staff on Confidential SQL development and how to use with Crystal Reports the most effectively.

Confidential

Business Objects Architect/Developer

Responsibilities:

• Installed BOE XI R2 SP3 Premium Server on Virtual development and test environments.
• The environment included Web Intelligence XI R2
• Performance manager XI R2
• Crystal Reports XI R2
• Migrated current Crystal Reports CE 10 environment to BOE XI R2.
• Configured Windows AD with Java environment Tomcat web server.
• Created dimensional Data marts.
• Created universes connected to the data marts in Confidential DB2 environment.
• Created Web Intelligence reports off of the universes.
• Stress tested the reports with large datasets.
• Provided training related to the administration, installation and management of the Crystal Reports solution for staff.
• Trained developers in new features of CR XI R2.
• Documented the installation process.

Confidential

Sr Consultant

Responsibilities:

• Installed Business Objects BOCD XI R2 Server
• Installed and configured Crystal Xcelsius for Workgroups.
• Created Business Views for report development.
• Created reports with CR XI Developer.
• Created Xcelsius dashboards using crystal reports as the data sources.
• Provided Crystal Report training focused on report writing to selected Confidential employees.
• Review, discuss and provide documentation associated with the use of Web based report publishing of Crystal Reports / Business Objects BOCD XI R2 Server.
• Provided training related to the administration, installation and management of the Crystal Reports solution.

Confidential, San Diego CA

Sr Crystal Reports Developer

Responsibilities:

• Migrated there Confidential to Business Objects XI R2 Server.
• Installed and configured Crystal Xcelsius for Workgroups.
• Created Business Views for report development.
• Created reports with Crystal Reports XI R2.
• Created Xcelsius dashboards using crystal reports as the data sources.
• Wrote Sql Server 2000 Stored Procedures as data source for the reports.
• Provided Crystal Report training focused on report writing to selected Heartland employees.
• Provided training related to the administration, installation and management of the Crystal Reports solution.

Confidential, Scottsdale AZ

Sr Consultant

Responsibilities:

• Managed major Business Objects Initiative for the company to utilize all the new Business Intelligence technology ( Confidential, Dashboards etc.)
• Interviewed and hired BO support personnel to support customer base on BO training and tech support issues.
• Developed the support process utilizing issue tracking software to manage customer call tracking and completion including escalation process etc.
• Managed other BO developers and mentored them on good techniques with all the software in the BO/Crystal XI R2 suite.
• Created procedures and prototypes to migrate existing customer’s universes from BO 5.1/6.5 to BO XI R2. Trained other BO personnel on the process.
• Trained BO on-site customer support staff on B XI R2.
• Wrote Desktop Intelligence and WEBI Ad-Hoc reports for customers.

Confidential

Sr Crystal Reports Developer

Responsibilities:

• Migrated Crystal Enterprise 9 to Confidential .
• Migrated all Business Views, Users, Groups and over 300 reports
• Reports databases used on this project PeopleSoft Queries using DB2, SQL Server 2000, Oracle 9i
• Wrote all views, stored procedures used as report data sources utilizing PL/SQL for Oracle 9i and TSQL for Sql Server.
• Configured Windows AD and Peoplesoft Single sign-on authentication.
• Mentored reporting staff (5 people) on Crystal Enterprise duties.

Confidential

Sr Business Objects Consultant

Responsibilities:

• Installed Crystal Reports Server XI, created users and groups, configured security for system for 100+ users to access reports that were scheduled as well as ad-hoc.
• Created Business Views complete with row and column security.
• Assisted Java developer team on how to deploy reports via Java Viewer.
• Reports databases used on this project Sybase Oracle 10g.
• Mentored reporting staff (5 people) on advanced Crystal Reports XI development, Creating Business views, Configuring report, row level, column security,
• Worked with tech writer to create documentation of this as well.

Confidential, Phoenix AZ

Sr Business Objects Integrator Consultant

Responsibilities:

• Designed Business Objects Data Integrator 6.5 - XI R2 Interfaces with SAP R/3 Version 4.7 and Oracle 9i Backend Data Warehouse.

Confidential

Sr Business Objects Consultant

Responsibilities:

• Rewrote 1 key report.
• Knowledge Transfer with 5 users.
• SAP R/3 Tables data source.
• Developed all the reports in Crystal Reports Xi R1.
• Reports were deployed using Business Objects XI Enterprise.
• Assisted another BO employee in installing Crystal Reports XI R1, BO XI R1 Enterprise framework and SAP Toolkit on dev servers.

Confidential, Irvine CA

Sr Crystal Reports Developer

Responsibilities:

• Rewrote 3 key reports that took 30 minutes to run they took 2 minutes to run.
• Knowledge transfer to their key Crystal Reports XI employee.
• SQL Server 2000 stored procedures were the data sources.
• Developed all the reports in Crystal Reports Xi R1.
• Reports were deployed using Business Objects XI Enterprise.

Confidential, Los Angeles Ca

Sr Crystal Reports Developer

Responsibilities:

• Converted 150 Reports written with Crystal Reports 8 using Sybase Store Procedures as data sources to Crystal Reports XI utilizing universes as data sources.
• These reports were then brought into BO XI Enterprise utilizing universes and enterprise level security.
• AD Hoc reporting off of universes were created using BO XI Web Intelligence software.
• Developed reports in Crystal Reports XI.
• Reports were deployed using Business Objects XI Enterprise.

Confidential, Washington D.C

Sr Crystal Reports Developer

Responsibilities:

• Wrote Oracle PL/SQL script and created flat file which included all reporting data needed.
• Database Design (Tables, Relations, Indexes, Stored Procedures, Views using Oracle 10g.
• Developed all the reports in Crystal Reports XI.
• Wrote all views, stored procedures used as report data sources utilizing PL/SQL for Oracle 10g.
• Reports were deployed using Business Objects XI Enterprise.

Confidential, Scottsdale AZ

Sr Crystal Reports Developer

Responsibilities:

• Wrote Dashboards, management reports for this land development company.
• Database Design (Tables, Relations, Indexes, Stored Procedures, Views, DTS Packages) using SQL Server 2000 for a financial application.
• Developed all the reports in Crystal Reports XI

Confidential

Sr Crystal Reports Developer

Responsibilities:

• Writing Partner Reports.
• Confidential / Business Views/ User Configuration.
• Oracle 8i/9i Data Warehouse fed by Siebel
• Wrote all views, stored procedures used as report data sources utilizing PL/SQL for Oracle 8i/9i.

Confidential, Phoenix, AZ

Sr Crystal Reports Developer

Responsibilities:

• Responsible for Crystal Enterprise 9/Report Definition and deployment.
• Designed the Tables, Relations, Indexes, Stored Procedures, Views, DTS Packages using SQL Server 2000.
• Developed all the reports in Crystal Reports 9.

Confidential, Tempe, AZ

Sr Crystal Reports Developer

Responsibilities:

• Completed Business Loan Application Reporting System
• Designed the Tables, Relations, Indexes, Metrics database, Stored Procedures, Views, DTS Packages using SQL Server 2000.
• Used Oracle 8i/9i.
• Wrote all views, stored procedures used as report data sources utilizing PL/SQL for Oracle 8i/9i.
• Responsible for Confidential /User Configuration/Report Definition and deployment.
• Developed all the reports (25 of them) in Crystal Reports 10.
• Documented all of the system level documentation.
• Performed extensive testing on the Report Metric Calculations

Confidential, Phoenix AZ

Sr Crystal Reports Developer

Responsibilities:

• Responsible for Crystal Enterprise 9/User Configuration/Report Definition and deployment.
• Wrote all views, stored procedures, User Defined Functions used as report data sources utilizing PL/SQL for Oracle 8i/9i.
• Developed Business Reports for Airplane tracking system.
• Developed all the reports (15 of them) in Crystal Reports 9.
• Performed all of the report level documentation.

Confidential, Phoenix, AZ

Sr Crystal Reports Developer

Responsibilities:

• Developed Report Extract System for a large Confidential Company in Phoenix, in which 200 reports were run daily from.
• SQL Server 2000 Back-end.
• Wrote over 50 SQL Server Stored Procedures and Views utilizing TSQL for SQL Server.
• Wrote many Visual Basic 6, ASP, ASP.NET, VB.NET interface programs that extracted data from the main Confidential Software (Interact from Alltel).
• Wrote over 150 reports in Crystal Reports 8.5.
• Performed all testing and system documentation on my projects.
• Developed Access 2000 front-ends, this application was for users to print accounting reports in a fund accounting charter schools system.
• System consisted of Access 2000, Crystal Reports 8.5, SQL Server 7 Stored Procedures Called from ACCESS.
• Developed Inventory Management System.
• System consisted of VB6, Crystal Reports 8.5 using Access 2000 Back-End.
• Performed all testing and system documentation on my projects.

Confidential

Consultant

Responsibilities:

• Developed complete Reporting System for Casino Floor Accounting System.
• System consisted of Crystal Reports 8.5, SQL Server 7 Stored Procedures, views, DTS Packages.
• The Reports were designed to monitor Game coin inflow and outgo.
• All Crystal Reports were scheduled with Crystal INFO.
• Performed all testing and system documentation on my projects.

Confidential, Scottsdale AZ

Consultant

Responsibilities:

• Developed Reports for Patient Financial System.
• System consisted of Crystal Reports 7, SQL Server 7 Stored Procedures, views, DTS Packages.
• The Reports were Patient Billing Tracking Reports.
• Mentored Mayo Business Analysts on Crystal Reports 7.
• All Crystal Reports were scheduled with Crystal INFO.
• Performed all testing and system documentation on my projects.

Confidential, Scottsdale AZ

Consultant

Responsibilities:

• Developed Reports front-end to allow users to run reports on the internet.
• System consisted of VB6, ASP, Crystal Reports 7 and Oracle 8i.
• Wrote all views, stored procedures, User Defined Functions used as report data sources utilizing PL/SQL for Oracle 8i from VB utilizing ODBC.
• Performed all testing and system documentation on my projects.

Confidential, Scottsdale AZ

Consultant

Responsibilities:

• Installed, configured and supported SQL Server 7 Back-End database for Goldmine Software.
• There were six client installs in all, total with a minimum of ten users per install and one client system with twenty.
• Performed all testing and system documentation on my projects.

Confidential, Phoenix AZ

Consultant

Responsibilities:

• Developed a system for a restaurant equipment company to handle all invoicing, inventory, quoting and reporting
• System consisted of VB6, ASP, Crystal Reports 8 and Access 97/2000.
• Performed all testing and system documentation on my projects.

Confidential, Phoenix AZ

Consultant

Responsibilities:

• Developed a system that Confidential 's paper flow from proposal to contract to job order, including special features to automatically insert industry specific descriptions, pricing etc.
• System consisted of VB5, SQL Server 6.5, Crystal Reports 7.
• The System has since been rewritten in VB6, SQL Server 2000, Crystal Reports 9.
• Performed all testing and system documentation on my projects.

Confidential, Phoenix AZ

Consultant

Responsibilities:

• Developed specialty programs that their canned software Sasixp did not cover.
• Programs consisted of VB6, Access 97, Crystal Reports 7 using ODBC.
• Performed all testing and system documentation on my projects.

Confidential, Phoenix AZ

Consultant

Responsibilities:

• Developed accounting and inventory reports for all departments using Crystal Reports 6.
• Mentored 25 staff members on Crystal Reports 6.
• Performed all testing and system documentation on my projects.

Confidential, Phoenix AZ

Consultant

Responsibilities:

• Developed 3 financial applications, including one multi-lingual application.
• Systems consisted of VB4, SQL Server6/6.5, and Crystal Reports 5 using ODBC.
• Involved in testing and system documentation on my projects.

Confidential, Phoenix AZ

Consultant

Responsibilities:

• Developed federal medical and financial applications for this Scottsdale blood bank.
• All systems had to pass strict FDA guidelines.
• Programs consisted of Access, VB4, Confidential, dbase.
• Involved in testing and system documentation on my projects.

Confidential, Scottsdale AZ

Responsibilities:

• Multiple Client Systems.
• Systems consisted of Access, Confidential, dbase.
• Performed all testing and system documentation on my projects.

Confidential, Scottsdale AZ

Lead Programmer

Responsibilities:

• Lead Programmer on a major revision of existing Confidential package sold nationwide.
• Responsible for customer support via telephone for many of the software users.
• Systems consisted of Confidential, dbase.
• Performed all testing and system documentation on my projects.

Confidential

Lead Programmer

Responsibilities:

• Lead Programmer and backup tech support person for an insurance package sold nationwide written in Confidential .
• Wrote custom software additions to SBT Accounting software for company clients.
• Systems consisted of Confidential, dbase.
• Performed all testing and system documentation on my projects.

Confidential

Sr Consultant

Responsibilities:

• Wrote custom Confidential applications to interface with CYMA accounting software.
• Did extensive custom support for existing client base.
• Systems consisted of Confidential, dbase.
• Did all testing and system documentation on my projects.

Confidential

Consultant

Responsibilities:

• Wrote custom applications for clients.
• Projects included a court reporting system written in Confidential and miscellaneous applications written in dBase dialects
• Did extensive custom support for existing client base.
• Systems consisted of Confidential, dBase III+, dBase IV, and FoxBASE.
• Performed all testing and system documentation on my projects.

Confidential, Phoenix AZ

Systems Analyst/Programmer Analyst

Responsibilities:

• Wrote real-time update attendance and registration systems for the 13 schools (99 users).
• Previously the system required 4 people per school 8 hours a day to manage.
• Results after rewrite, it took only 2 people 4 hours per day to manage, saving each school the equivalent of 1.5 people.
• Wrote the class scheduling system. All systems were written in DEC VAX BASIXC on 2 Vax 11/780’s
• Wrote system functions that accelerated the other programmer’s development cycles.
• Trained staff programmers in VAX BASIC.
• Systems consisted of VAX VMS 11/780 using VAX Basic.
• Performed all testing and system documentation on my projects.

Confidential, Phoenix AZ

Responsibilities:

• Developed Software for a PC-based vertical-market accounting software package.
• Systems consisted of Cromemco Basic.
• Performed all testing and system documentation on my projects.