|
|
|
Crystal Reports Writer / Program Developer
OBJECTIVE:
United States resident with over 13 years of report writing and programming experience.
Team player with a willingness to travel and relocate anywhere for a contract. Currently
looking for contract work in 2010.
CORE COMPETENCIES:
- Crystal Reports development focusing on website/email tracking,
database queries and accounting.
- Oracle, SQL, MySQL, Paradox and Access database development and maintenance.
- Product development and custom report writing for property management
software such as Yardi.
- Java and Perl scripting to extract stock quotes, price history, charts, options,
indicators and patterns.
- Excel development using Visual Basic to streamline financial/accounting
processes.
- Perl, Curl and VB scripting to parse through large data files and
mailing lists.
- Delphi and InfoPower GUI development that utilize databases and
the Window’s registry.
- Developed programs to integrate with systems such as Remedy, ADP and Ceridian.
- XML coding to create sitemaps complying with Google‘s UTF-8 encoded
specifications.
- Internet development using Java, Perl, CGI, XML, DOM, DHTML, CSS and HTML.
EXPERIENCE:
January 2008 to December 2009 (Remote Work)
JDR Consulting
– Yardi, SQL, YSL, Ad Hoc, Custom Analytics, and Crystal Reports 9
- Designed reports in Crystal Reports, Yardi Scripts, YSL, Ad Hoc, and Custom Analytics.
- Created stored procedures, triggers and ran queries against SQL databases.
- Setup, scheduled, maintained, in addition to troubleshooting reports for Conductor.
- Customized Cover Page and Table of Contents for report packets.
- Built signature image files in Crystal Reports that would insert a signature on
a Purchase Order based on approver.
- Created manuals and conducted training sessions.
June 2008 to July 2008 (Anchorage, Alaska)
Cook Inlet Housing Authority
– Yardi and Crystal Reports 9
- Created an affordable report that calculates Program and Tribal Affiliation for
Native Americans of Alaska.
- Satisfied the user requirement to pulling data by household or by person.
- Program is associated on a Property level, Affiliation is associated on Resident/Tenant/Family
Memeber level (compensated for more than one affiliation assigned to the same Resident/Tenant/Family
Member).
February 2007 to November 2007 (Lyndhurst, New Jersey)
Ernst & Young
– SQL*Plus, Oracle, VB, Html, Delphi, InfoView and Crystal Reports Developer
XI
- Created Oracle stored procedures to extract data from Remedy tables.
- Scheduled and maintained the automatic generation of reports using InfoView.
- Interviewed reporting stakeholders and operators to gather insights, perspectives
and opportunities to streamline or enhance the state of automation for the reports.
- Developed a GUI application to store, edit and execute over 100 SQL queries.
- Updated worklog checklist from Remedy according to design specifications.
- Wrote VB scripts to properly format the Crystal Report extract into Excel.
- Published manuals and executed knowledge transfer and training with client staff.
Crystal Reports Highlights
- Created cross-tab eight-day weekly reports based on current week and previous week.
- Highlighted start/end times that exceed the sla_gmt time.
- Set the font color to red for start/end times that are within the “slack” time.
- Used Report Custom Functions to converted Epoch dates.
May 2006 to September 2006 (Sydney, Australia)
Fairfax Publishing
– SQL, VB, Java, Perl, Html and Crystal Reports Developer
- Sales & Marketing reports for AFRAccess.com
- Used Crystal Reports to tracked logins, mouseovers, click-throughs, session durations
and demographical comparisons with SQL database of customer information.
- Email tracking reports from Lyris software
- Used Crystal Reports to tracked successful/unsuccessful sent emails, emails that
were read, click-throughs and demographical comparisons with SQL database of customer
information.
- Verification of 40,000 records mailing list
- Verified cities (16,000) and states (8) with zip codes from the Australia Post Office.
- Country code analysis with addresses around the world.
- Auto-corrects common data entry mistakes such as transposed letters, abbreviations,
etc.
- Summary count/percentage of gender, state and corrections.
Crystal Reports Highlights
- Created cross-tab seven-day weekly reports based on current date.
- Successfully combined report data from different software and data types.
- Combined log reports from AFRAccess.com with databases from Lyris
- Used Crystal Reports as a testing tool for website of AFRAccess.com.
April 2000 to April 2006 (Tempe, Arizona)
Mikayla Corp
– Outsourced computer contracts for the following companies:
BRIC International
(Mexico/Panama) – Java, Perl, Cgi, Html, Delphi and Crystal Reports Developer
- Extracted stock prices, quotes, news articles and other information from the following
websites:
- Earnings by date or individual stock from www.marketwatch.com or www.yahoo.com
- Largest % Price Gain/Loss of AMEX, NYSE, NASDAQ from www.marketwatch.com
- Option contracts of an individual stock from www.marketwatch.com or www.yahoo.com
- P&F Price Pattern/Objective of an individual stock from www.stockcharts.com
- Quotes and news of an individual stock from www.marketwatch.com or www.yahoo.com
- Used Crystal Reports to graphically chart stock prices and trends based on pre-market,
in-market and post-market gains/losses.
- ROI calculations based on amount invested and filters such as volume, average volume,
volume ratio, patterns, price objective and top moves in market.
- Database storage of price history, prev/open/close, day low/high, 52 week low/high,
volume, average volume, volume ratio, previous occurrences, patterns, trade dates
and price changes.
Crystal Reports Highlights
- 38x34 Report Table
- 67 Formula Fields
- 2 Parameter Fields
- 66 Running Totals
- Summary section with highlighting parameters that meet certain conditions.
Footprints Concierge Service
(Playa del Carmen, Mexico) – HTML, XML and Delphi Developer
- Designed a website to list all restaurants (221), bars (49), activities (117), transportation
(31), and lodging (182) for Playa del Carmen, Mexico.
- Created mirrored sites for Playa del Carman, Playa del Carma, Playa de Carmen, Playa
de Carman, Playa de Carma, Playa Carmen, Playa Carman and Playa Carma.
- Randomly generated top picks for businesses chosen based on 4 different priority
sequences.
- Developed Google sitemaps in XML for over 10,000 webpages to efficiently crawl the
site.
Patron Stats
(Tempe, Arizona) – Delphi and Crystal Reports Developer
- Created an importation process that would download and store driver’s license data
from any hardware device in any data format (*.txt, *.cvs, *.db).
- Data could be imported and categorized from an unlimited number of locations.
- Use Crystal Reports to build demographical reports and mailing lists.
- Designed the help manual, reports manual, scenario pamphlet and marketing materials.
Crystal Reports Highlights
- Reports and mailing lists could be pulled from all locations or select a combination
of locations.
- Any combination of filters could be applied such as Date, Gender, Age, Region and/or
Repeats.
- Created Flag reports if there were an abnormalities outside of the acceptable range
of the baseline data.
Modern Industries
(Phoenix, Arizona) – Delphi, Crystal Reports and Excel Developer
- Developed SQL queries to combine data from two different database formats.
- Tracked labor and job cost from Paradox and MS Access databases.
- Performed calculations and set parameters for accounting ledgers using Visual Basic
in Excel.
- Extracted history data from ADP software to be imported into Ceridian software.
- Used Crystal Report to create a paperless verification of time punches from Unitime
that would automatically email to supervisors on a weekly basis.
Intel
(Chandler, Arizona) – Perl, Curl and VB Developer
- Wrote Perl/Curl scripts to parse through exported log files.
- Developed VB scripts in Excel for formatting, graphical layout and revisions.
- Created a clustering program in Perl that distributes programs among a group of
computers.
United States Census Bureau
(Phoenix, Arizona) – Delphi and Perl Developer
- Created a program to integrate with Oracle’s SQL Plus.
- Stored commonly used SQL statements in the Window’s registry for click point execution.
- Wrote Perl scripts to streamline cluster work flow.
Southwest Computer Technologies
(Tempe, Arizona) – Delphi and Crystal Reports Developer
- Developed a GUI interface to input and tracked equipment, repairs, hours and parts.
- Used Crystal Reports to export specific data into an excel spreadsheet.
September 1997 to February 2000 (Tempe, Arizona)
Technovation
– Outsourced computer contracts for the following companies:
Greenkeeper
(Mesa, Arizona) – Delphi and Crystal Reports Developer
- Created a program to input and track jobs, call tickets and work performance.
- Worked on a one to many relationships between customer, sites and site invoices.
- Printed reports on postcards, letters, receipts and invoice detail on pre-printed
carbon copies.
Tucson Unified School District
(Tucson, Arizona) – Delphi and Crystal Reports Developer
- Created national scheduling software for high schools’ athletic departments.
- Software would randomly generate schedules based on pre-established patterns and
criteria.
- Used Crystal Reports to print out report for games, schedules and contracts.
Arizona School of Real Estate
(Scottsdale, Arizona) – Delphi and Crystal Reports Developer
- Multi-user interface that tracked students, money and classes using Paradox databases.
- Converted a DOS application to Delphi for the top real estate school in Arizona.
- Used Crystal Reports for print out class schedules, accounting and bookkeeping purposes.
Arizona Journal of Real Estate
(Scottsdale, Arizona) – Delphi and Crystal Reports Developer
- Set up a user interface to input and tracked ads, money and contracts for their
publication.
- Printed contracts and reports from Quick Reports and Crystal Reports.
- Used Crystal Reports for sales tracking, advertising renewals and billing purposes.
|
|
|