Saturday, January 6, 2024

50 Unreleased Photos of Hawaii's History Part 1

 Hawaii is the fiftieth state of the United States, and it is the only state outside North America. Hawaii is the only U.S. state made up entirely of islands and the only state in the tropics. It is also known as "The Aloha State." Hawaii became the fiftieth state in 1959.

It is the eighth-smallest state. The natural scenery, warm climate, public beaches, and oceanic surroundings make it a popular destination for tourists. The islands are the tops of volcanoes, with some of them still active.

Fireworks in celebration of the unconditional surrender of Japan

Victory over Japan Day, V-J Day, is the day Imperial Japan surrendered in World War II, bringing the war to an end. August 15 is the official V-J Day, and the formal surrender occurred aboard the USS Missouri in Japan. Cheers, celebrations, parades, and tears broke out across Hawaii when the war officially came to an end. For a week straight, they celebrated. 

There was a huge parade, barbecues, and dancing. “Others who could find nothing with which to make noise just shouted and whopped it up with whatever wax they could. Auto horns were honked, radios blared, and conversation buzzed.” ----- Karl Wray

Congresswoman Patsy Mink

Patsy Mink was an American politician; she was born and raised on the island of Maui. She opened her own practice in 1953 and became a member of the Democratic Party. She became the first Japanese-American woman to serve in the territorial House and, two years later, became the first woman to serve in the territorial Senate. In 1964, Mink won a seat in the U.S. House of Representatives. 

She was the first woman of color to be elected to Congress. She served twelve terms and worked on the legislation of importance to women, children, immigrants, and minorities. Mink was also the first East Asian-American woman to seek the presidential nomination of the Democratic Party. Until her death in 2002, she served in the U.S. House.

Vietnam crisis in Hawaii

During the Vietnam War, Hawaii contributed its share. The 25th Infantry Division deployed from Schofield Barracks in early 1966. Many Hawaiians volunteered or were drafted, and over 500 Guardsmen saw combat duty in Vietnam. In 1968, the 29th Infantry Brigade, Hawaii National Guard, was ordered to active duty at Schofield Barracks. 

The Declaration of Honolulu in 1966. In 1967, President Lyndon Johnson presented a personal letter to North Vietnam and petitioned the North Vietnamese leadership to discuss a cease-fire for the upcoming new year. He hoped to resolve the Vietnam civil conflict.

Astronaut Training, Hawaii

The Hawaii Space Exploration Analog and Simulation is on the Hawaiian mountain of Mauna Loa. Hawaii contributed to NASA by housing a tracking station for early human space flights, served as the first port of call for astronauts returning from the moon, provided sites for geology training for astronauts, and landscapes that mimic the surface of Mars. 

The island of Oahu became a focal point for the recovery of Apollo missions returning from the moon. Recovery ships sailed from Pearl Harbor to meet the returning crew and take them to Honolulu. “There were an awful lot of people on the route between where they offloaded us from the recovery ship Hornet and transported us to Hickman. And the astronauts were amazed by the reception of the public.” -----John Hirasaki

John F. Kennedy in Hawaii

In 1963, President John F. Kennedy arrived in Hawaii. Kennedy started the next day by visiting the USS Arizona Memorial and paying respects to the fallen. He went to Hawaii to tell mayors from many U.S. cities that black Americans deserved equal rights. On Kennedy's way back to the airport, he stopped at the Academy of Art to autograph a bowl that is now kept by the Harvard Club of Hawaii.

The 1961 Lincoln convertible that he rode in Honolulu carried him to his death in Dallas five months later. "This island represents all that we are and all that we hope to be. I say they should be equal in their chance to develop their character, their motivation, and their ability." ------ President Kennedy

Fashion show in Honolulu, Hawaii

In the 1960s, fashion was flower power, animal prints, longer hair for men, pale lipstick, dark eyeliner, and groovy patterns. The Aloha shirt or Hawaiian shirt is a style of dress shirt originating in Hawaii. They are buttoned and collared dress shirts, usually short-sleeved and cut from printed fabric. They would be worn as casual wear and informal business attire. 

Traditional Aloha shirts are usually adorned with Hawaiian quilt designs and simple floral patterns. The locals tended to shy away from the “too wild” Aloha shirts. In 1965, Bill Foster led a campaign lobbying for Aloha Friday. It was a day that employers would allow men to wear Aloha shirts on the last business day of the week, a few months of the year. Aloha Friday officially began in 1966.

Hawaii During WWII

From 1941 to 1944, Hawaii was under Martial Law. Civilian government was dissolved, and a military governor was appointed. Under martial law, every facet of Hawaiian life was under the control of the military governor. All residents over the age of six were fingerprinted. Blackouts and curfews were imposed, food and gasoline were rationed, the news, media, and mail were censored, alcohol was prohibited, and business hours were assigned. 

Violations meant punishment without appeal by the military. After the attacks at Pearl Harbor, there were 37% of residents of Japanese descent. The military officials doubted the loyalty of the island’s many Japanese Americans. “I wasn’t supposed to speak Japanese anymore. It was almost like a sin.” ----- Jane Kurahara

Polo in Honolulu, Hawaii

Polo was introduced to Hawaii from Asia through an Australian cowboy visiting from India. Hawaii’s polo fields were like a necklace of emeralds spread across the island chain. The special bond of athletic talents between horse and rider has helped polo evolve into The Sport of Kings. The first recorded polo match in Hawaii was in 1880 on a Palama field. King David Kalakaua enjoyed horse racing and polo, so he turned Kapiolani Park into a race track and a polo field. 

The peak in polo’s popularity lasted about 20 years but gradually faded. However, there is still a faithful following in Hawaii. “They used to play arena polo on Saturday nights in the old termite palace, Honolulu Stadium.” ------Allen hoe

Dillingham Construction Office in Honolulu, Hawaii

Walter F. Dillingham founded Hawaiian Dredging Construction Company, Inc. in 1902. It is the oldest and largest full-service general contractor in the State of Hawaii. Some early projects were the entrance to Pearl Harbor, the Ala Wai Canal, and Honolulu’s waterfront development. They also constructed some landmark projects like the King Kalakaua Building and the Honolulu Museum of Art. 

They completed two five-star hotels, the four seasons Wailea Hotel in Maui and the Hawaii Prince Hotel in Waikiki. They built many of the roads and highways for Hawaii and then Ala Moana Shopping Center. Dredging played an important role in developing Hawaii’s economy and infrastructure and improving the islanders' quality of life.

Molokai Island

Molokai is the fifth most populated island in Hawaii. It lies east of Oahu and north of Lanai. The island's economy has been driven primarily by cattle ranching, pineapple productions, and sugar cane production. The island does not see many tourists. 

Molokai developed from two volcanoes known as East Molokai and West Molokai. Kaunakakai is Molokai's largest town. In 1878, an immigrant from Germany was the first farmer on the island to grow, produce, and mill the sugar and coffee commercially. Ranching began on the island in the first half of the 19th century.

Pearl Harbor

On December 7, 1941, the Japanese attacked the U.S. naval base at Pearl Harbor in Oahu, Hawaii. The surprise attack drove the United States into World War II. There were eight U.S. Navy battleships present, and all were damaged, four sunk. Three cruisers, three destroyers, one anti-aircraft training ship, and one minelayer were also sunk. In the attack, 2,403 Americans were killed, and 1,178 were wounded. 

After six months, five battleships and two cruisers were patched or refloated and sent to shipyards. The Arizona and Utah were too damaged for salvage and remained where they sunk. The Arizona became a war memorial. Japan announced a declaration of war on the United States later that day. December 7, 1941, “a date which will live in infamy.” ----President Franklin D. Roosevelt

Premiere of the movie "Hawaii"

"Hawaii" is a 1966 American drama film about an 1820s Yale University divinity student who becomes a Calvinist Missionary in the Hawaiian Islands. It was mainly filmed on the islands of Kauai and Oahu in Hawaii. Most of the movie props were imported from Mexico, Taiwan, Ireland, Hong Kong, Japan, and the Philippines.

Starring in the film were Julie Andrews, Richard Harris, Gene Hackman, Max Von Sydow, Jocelyne LaGarde, and Carroll O’Connor. The film was released on October 10, 1966, and it was the highest-grossing film of 1966. The film won the Golden Globe Award for Best Supporting Actress and Best Original Score.

Dedication ceremony of the Sheraton-Maui Hotel at Kaanapali Beach

The Sheraton-Maui Hotel opened in 1963 at Kaanapali Beach, Hawaii. A special introductory rate was fifteen dollars per night, and the hotel was the only high rise along the beach. The event drew many celebrities from Bing Crosby to the MacMurray's. It was on a gorgeous beach with its own airstrip and the first 18-hole resort golf course. The Sheraton quickly grew to 240 rooms. The resort held the island’s first Celebrity Golf Pro-tournament and brought the first United Airlines to fly to Maui, delivering the grand opening guests. 

“Sheraton Maui’s distinctive architecture was spectacular and romantic and was applauded throughout the world. It was selected for inclusion by the New York Museum of Modern Art for Architecture—USA exhibition to tour through the Soviet Union and Eastern Europe during the 1960s. Sheraton Maui set the standard for the innovative, luxury, Polynesian resort.” ----Alexis Eaton

David Kalakaua, King of Hawaii

Kalakaua, also called the Merrie Monarch, was the last king of Hawaii. He reigned from February 12, 1874, until his death. He enjoyed entertaining his guests with his singing and ukulele playing. The Reciprocity Treaty of 1875 was during his reign and brought great prosperity to the kingdom. 

Kalakaua wanted Hawaiians to broaden their education, so he instituted a government-financed program to sponsor qualified students to be sent abroad for further education. The Statue of Kamehameha and the rebuilding of Iolani Palace were two of his projects. He was pressured to sign a constitution that made the monarchy mean little; died on January 20, 1891.

1959 Volcano Eruption

The eruption in 1959 of Kilauea Iki Crater was a short-lived event and produced some of Kilauea’s most spectacular lava fountains. Fissures erupted at 10:30 pm on November 14. The lava fountain reached heights of 1,050 ft and the lava pooled like a lake in the crater 365 feet deep. 

The eruption provided the first measurable data about the magma reservoir system at Kilauea. By November 15, only a single vent remained active. There were multiple episodes of eruption between 1959 and 1960.

Staff Sergeant Joe DiMaggio

Joe DiMaggio enlisted in the United States Air Force in 1943 and rose to the rank of Sergeant. He was stationed in Hawaii and was released on a medical discharge in 1945 due to chronic stomach ulcers. He was paid $21 per month and was kept very comfortable during his service. 

He spent most of his military career playing for baseball teams, and he was given special privileges due to his pre-war fame. While in Hawaii, he and other players mostly tanned and drank on the beaches. He eventually requested a combat assignment but was turned down. He was also stationed in California and New Jersey during his service.

The Hula Dance

The Hula is a Polynesian dance form developed in the Hawaiian Islands. The hula portrays the words of the song in a visual dance form. The ancient hula is called Kahiko and is accompanied by chant and traditional instruments. Hula, in the 19th and 20th centuries, is called ‘auana and is accompanied by song and western-influenced musical instruments. Hula dancing is a complex art form.

Many hand motions are used, and foot and hip movements often pull from steps, including the kaholo, ka’o, kawelu, ‘uwehe, and ‘ami. Hula changed in the early 20th century, and there has been a renewed interest in the hula. The Merrie Monarch Festival is an annual one-week long hula competition in honor of King David, who revived hula's art.

Hawaiian Leis

Lei is a series of objects, often flowers strung together with the intent to be worn. The most popular in Hawaii is a wreath of flowers. It is usually presented upon arriving or leaving as a symbol of affection. Common events for leis to be distributed include graduations, weddings, luaus, and dances. There are eight common methods of making a lei: Haku, Hili, Hilo< Hipuu, Humu, Kui, Wili, and Haku mele. 

Ancient Polynesians originally wore leis; Native Hawaiians used them to signify their ranks and royalty. They were also worn as a form of honor to each other and their Gods. On May 1st, Lei Day is celebrated to honor the act of lei making and the custom surrounding it. At the 81st Lei Day, Honolulu set the record for the world’s longest lei.

The State Capital

The Hawaii State Capitol is the official capitol building of Hawaii. The building is located in downtown Honolulu and was opened on March 15, 1969. It replaced the former statehouse, the ‘Iolani Palace. Several capitol building monuments decorate the statehouse grounds. One of the prominent monuments on the statehouse grounds is the Father Damien Statue.

The Eternal Flame is a torch that burns endlessly as a tribute to all men and women from Hawaii who served the United States. The monument consists of 768 black marble pedestals engraved with the names of deceased service members of the Vietnam War. There is a larger marble slab that bears a Hawaiian language inscription of remembrance. A reflecting pool surrounds the capital to reflect the ocean, cone-shaped chambers to reflect volcanoes, columns around the building to reflect palm trees. The architecture is magnificent.

Gatorade Ironman Triathlon

The Ironman Triathlon has been held every year in Hawaii since 1978. The course is three events, the Waikiki rough water swim, around Oahu bike race, and the Honolulu marathon. In 1978, only 15 athletes started the race, and 12 crossed the finish line. Each was rewarded with a trophy. 

The swim is 2.4 miles, the bicycle is 115 miles, and the marathon is 26.2 miles. In 1979, the first woman won the endurance event, Lyn Lemaire. In 1985, Jim MacLaren was the first amputee to finish the Ironman.

Banyan tree

The banyan tree was planted on April 24, 1873, in Lahaina, Hawaii. It was planted to mark the 50th anniversary of the arrival of the first American Protestant mission. It is located in the Courthouse Square and was renamed the Banyan Tree Park. It is the largest in the state and the United States. The tree was a gift from missionaries in India and was only eight feet when planted. 

It is now 60 feet, and the canopy spreads over an area of 0.66 acres. The tree’s circumference is about one-fourth of a mile, and about one thousand people could congregate under it. At night the birds congregate in the branches of the tree, causing a cacophony of bird cries. An irrigation system in the park sustains the tree.

Traditional ceremonial clothes of ancient Hawaii

The basic garments were a malo (loincloth) for men and a skirt for women, and a rectangular shawl or Kihei for both. All of the clothing was made of Kapa, barkcloth made from wauke, mamaki, oloa, and plant fibers. At least 68 individual types of Kapa were produced and used for bedding, sheet material, banner, and wrapping material. 

Ti leaf capes protected against the cold and rain. They wore feather capes, cloaks, helmets, and lei as signs of rank and status. Feathers were taken from live birds and then released, so the feathers needed for one cape could take decades. Most often, the feathers were yellow or red.

Prince Juan Carlos of Spain and his wife Princess Sophia on Their Honeymoon in Hawaii

Juan Carlos, Prince of Asturias, and Princess Sofia of Greece and Denmark were married on May 14, 1962. They were married in three ceremonies at the Cathedral Basilica of St. Dionysius the Areopagite, and the Metropolitan Cathedral of Athens, and the Royal Palace. The bride wore the Belgian lace veil her mother wore at her wedding and a diamond tiara.

She wore a silver and white lame’ gown covered in tulle and antique lace with a 5-meter train. The groom wore his Spanish Army uniform. The couple honeymooned in Hawaii and met with President John F. Kennedy. They reigned as King and Queen of Spain from 1975 until his abdication in 2014. They had three children.  

A Hawaiian Pineapple Plantation

Hawaii is famous for pineapple, or as Hawaiians call it, halakahiki. The pineapple first arrived in Hawaii in 1527, and the import of foreign workers started in the 1850s. The “Pineapple King” John Kidwell was the founder of Hawaii’s pineapple industry. Dole bought the island of Lanai in 1922 and established the largest pineapple plantation globally, which produced 75% of the world’s supply. 

Life on the plantation was hard for immigrant workers. The workers wore heavy protective clothing because of the sharp pineapple leaves, and their wages were less than $20 per month. Today, every single pineapple is planted by hand. A skilled planter can plant about 10,000 fruits a day.

Walter Francis Dillingham

Walter Dillingham was called the Baron of the Hawaii Industry. He was an industrialist and businessman from Honolulu, Hawaii. He served on several commissions for the Territory of Hawaii, including the tax appeal court. Dillingham drained the wetlands of Waikiki and created the Ala Wai Canal. 

He helped suppress Japanese Hawaiian plantation workers’ call for better labor conditions when he was the Hawaii Emergency Labor Commission's chair. In 1948 a small Air Force base in Mokuleia was named for his son Henry Dillingham, who was killed in Japan. In 1961, his son Lowell Dillingham merged the remains of the Oahu Railway and Land Company; he formed the Dillingham Corporation.

American battleship U.S.S. Arizona

The USS Arizona was the second battleship built for the United States Navy in the mid-1910s. Arizona was one of the American ships that escorted President Woodrow Wilson to the Paris Peace Conference. The ship was then sent to Turkey to represent American interests for several months. She was then transferred to the Pacific Fleet and remained there. The Arizona was used for training exercises between the wars. 

In 1940, the Pacific Fleet was transferred to Pearl Harbor, Hawaii. On December 7, 1941, Arizona was hit by a Japanese torpedo; she exploded and sank. 1,177 men died that day on the Arizona. Arizona was irreparably damaged and still lies at the bottom of Pearl Harbor. It now rests under the USS Arizona Memorial, which was dedicated to all killed on December 7th. The memorial floats above but does not touch the ship’s hull. The Arizona was awarded one battle star for its service in World War II.

Lolani Palace

The ‘Iolani Palace was once the royal residence of Hawaiian rulers. It is located in the capital district of downtown Honolulu. It is a National Historic Landmark and is listed on the National Register of Historic Places. In 1893, the building was used as the capitol building for the Provisional Government. The Palace was restored and opened to the public as a museum in 1978. 

It is the only royal palace on U.S. soil and features architecture seen nowhere else in the world. In the basement is a photographic display of the Palace, orders, and decorations given by the monarchs. The palace is one of the only places in Hawaii where Hawaii’s flag can officially fly alone without the American flag.

USO Dance in Honolulu

The USO is an organization focused on providing support, programs, and entertainment to active duty service personnel and their families. The dances, live music, and singing was a staple at many USO centers. In Hawaii, they did it big.































Thursday, January 4, 2024

Resume

 

Charles H. Swartz

2356 Peninsula Drive. Shell Knob MO 65747

(808) 202-6030
charles.h.swartz@gmail.com

 

Successful Information Technology Professional with experience
in providing efficient solutions in a variety of situations

 

 

PROFESSIONAL SKILLS

 

Healthcare Information Technology, Microsoft SQL Server, SSRS, SSIS, DTS, Transact SQL, Stored Procedures, QNXT, Microsoft Visual Studio, Microsoft Team Foundation Server

 

PROFESSIONAL EXPERIENCE

 

 

Delaware Information Systems, Wilmington DE                                                                                            11/22 – 01/23

QNXT Developer

  • Creating/modifying T-SQL Functions and Procedures
  • Creating SSRS reports
  • Creating SSIS Packages

 

Symphony Corporation, Madison, WI                                                                                                 10/21 – 12/21

QNXT Developer

  • Creating/modifying T-SQL Functions and Procedures
  • Creating SSRS reports
  • Creating SSIS Packages

 

Diversified Systems, Westerville, OH                                                                                                   3/21 – 6/21

Data Analyst

  • Creates accurate mapping documents according to the mapping process.
  • Works toward delivering a first draft solution to ETL for coding, by rapidly understanding which details about the mapping can be deferred.
  • Supports DSD creation and response.
  • Presents analysis and design recommendations to lead MITA teams, customer and/or vendors into the acceptance of the design.
  • Supports the ETL developers based on the mappings created.
  • Works closely with configuration team and DBAs to ensure synchronicity of configuration to interfaces and mappings.
  • Refines mapping documents, adding more detail and filling out deferred material as questions are resolved.
  • Uses SQL, data models, data element dictionary and schema to perform data and business analysis.
  • Creates unit test cases for area of responsibility.
  • Validates test plan results that satisfy the detailed design goals.
  • Updates technical specifications and mappings.
  • Supports Unit Testing, System Integration Testing, System Testing, and User Acceptance Testing.

 

 


Valley Health Plan, San Jose, CA                                                                                                          7/18 – 4/20

Senior Management Information Systems Analyst

  • SSRS & SSIS specialist
  • Creating Transact SQL Stored Procedures and Functions
  • Creating custom Datastores for use by junior developers
  • Primary focus is on the QNXT Claims Processing System
  • Integrating with other systems including Milliman MedInsight, Truven Health Analytics/ IBM Watson Health, MedImpact, Navitus Health Solutions, Medi-Cal (CalHEERS), CMS, and Valley Express
  • Parse 834 and 837 data to aid in resolution of failures loading enrollment and claim information into QNXT.
  • Creating reports for various HEDIS measures
  • Assisting upgrade of QNXT from 4.2 to 5.6

 

 

HealthTECH Resources, Inc. Phoenix, AZ                                                                                          4/16 – 7/18

Senior SQL Developer, SSRS, SSIS & QNXT Specialist

Aiding Valley Health Plan in San Jose after their conversion from Diamond to QNXT

  • Gather business and technical requirements for SSRS reports or Interface file extracts
  • Create and analyze T-SQL reports, scripts, views, tables, procedure for various areas: Member, Enrollment, Finance, Provider, UM, audit (NCQA, HEDIS), and interface files extracts
  • Subscribe reports using SSRS or SSIS package and upload reports on SharePoint for customer self-service
  • Perform data analysis to ensure accuracy of SSRS reports or SSIS integration efforts
  • Analyze existing SSRS reports and stored procedures to improve performance and accuracy
  • Correct and standardize various SQL jobs/stored procedures that were incorrectly creating entries in the QNXT Process Logs
  • Work with vendor to develop file exacts and ensure the data set works with the vendor’s application
  • Correct and simplify archiving processes using stored procedures and SSIS
  • Assist in testing and quality assurance of various custom applications
  • Develop SQL ETL solutions utilizing SSRS and transferring of data via SFTP
  • Develop ETL solutions for integrating among various system: QNXT, Valley Express, Diamond, Data warehouse
  • Instruct junior developers in proper gathering of business rules and requirements
  • Develop best practices, principles and methods of analysis, software development and validation techniques
  • Implement a set of reference tables or views to aid in the speed, accuracy and consistency of development efforts
  • Provide knowledge and expertise of the QNXT claims processing system to coworkers, business users and vendors
  • Aid in the transition of existing reports from the Diamond claims processing system to QNXT
  • Develop troubleshooting and debugging techniques and standards

 

 

 

TEKsystems Honolulu, Hi                                                                                                                      9/15 – 11/15

SQL Developer

  • Working with IntrapriseTechKnowlogies LLC to aid 7-Eleven in upgrading their Microsoft SQL Servers from 2005 to 2008

·        Analyze and modify VB .Net and VB Script programs

·        Analyze and modify VBA programs in Microsoft Access

·        Analyze and modify T-SQL Stored Procedures and SQL Agent Scheduled Jobs

·        Analyze and modify SSIS and SSRS Packages

·        Replace deprecated sp_makewebtask procedure used for creating HTML Reports with custom code

·        Languages utilized include VB .Net, VB Script, VBA for Access, PowerShell, HTML, XML, and DOS Batch Language

 

 

Solutions Consultants, Inc. Chesterfield, Mo                                                                                    6/15 – 9/15

SQL Developer, QNXT Integration Specialist

  • Aid Corizon Healthcare in supporting QNXT 5.2 healthcare management system and custom processes for claims processing and system integration

·        Create custom reports using SSRS and stored procedures as well as scheduled SQL jobs that run the reports and send them to email distribution lists

·        Create and modify various EDI interfaces and SQL jobs with Corizon clients using SSIS and stored procedures

·        Trouble-shoot and correct various stored procedures that were returning erroneous results and/or performing poorly

·        Assist in testing and quality assurance of various custom applications

·        Correct and standardize various SQL jobs/stored procedures that were creating entries in the QNXT Process Logs incorrectly

·        Clean up various reference data such as HCPCS codes incorrectly entered into the Diagnosis Code tables

·        Correct and simplify archiving processes using stored procedures and SSIS

·        Create or modify utilities written in Visual Basic .Net

·        Perform code review for submitted Reports and/or Stored procedures providing recommendations for improving performance

·        Automate various processes to relieve support personnel of daily, weekly or monthly tasks

·        Corizon processes claims for the Department of Corrections as well as Jails so these are Medicare & Medicaid claims

 

 

HMSA, Honolulu, Hi                                                                                                                               1/09 - 12/13

SQL Developer

  • Supporting QNXT 4.7 healthcare management system and custom processes for claims processing

·        Coordinate, correct and standardize the HCPCS, CPT, ICD9, HIPPS and DRG codes across all Lines of Business using SSIS and stored procedures

·        Update Fee Schedules and RBRVS using SSIS & stored procedures

·        EDI interface with Medco Health Solutions using SSIS, stored procedures, and Tumbleweed SecureTransport

·        EDI interface with First Databank and Medi-Span as well as stored procedures for combining data from the two drug information databases using SSIS, stored procedures, and Tumbleweed SecureTransport

·        Create and maintain MS T-SQL scripts, stored procedures, and functions

·        Custom reports with SSRS

·        Scheduled tasks using Cisco Tidal Enterprise Scheduler

·        Work includes Private Line of Business, Medicare & Medicaid

 

Ajilon Consulting, Town & Country, Mo                                                                                             7/06 - 9/08

Computer Consultant

  • Aid Mercy Health Plans in migrating from Diamond to QNXT

·        Update HCPCS, CPT, ICD9, HIPPS and DRG codes using DTS and stored procedures

·        Update Fee Schedules and RBRVS using DTS & stored procedures

·        Software written in VBA for Access and Excel to aid in the maintenance of benefits, plans, and contracts and report discrepancies between Diamond and QNXT

·        MS T-SQL scripts, stored procedures, and functions for maintaining benefits, plans, and contracts

·        Reports using SSRS

·        Scripts for adding, changing or deleting records from Diamond using TinyTerm CScript Language

·        Work includes Private Line of Business, Medicare & Medicaid

 


Top Shelf Systems, Ash Grove, MO                                                                                                      1/03 - 4/06

Director of Development

  • Develop and maintain CyberBOS Point of Sale software written in Visual Basic using MS Access or MySQL Server as the database

·        Automatic updating CyberBOS and database schema via the Internet

·        Enable the use of MySQL Server as the database source while still supporting MS Access for smaller installations

·        Ability to connect to databases via the Internet for companies having multiple sites

·        Utilities for importing and exporting data to and from SelJax

·        Allow companies to archive databases to file servers or CD ROM

·        Beta releases and major upgrades of CyberBOS

·        Empower users to create custom reports via intuitive selection criteria

·        Interfaces with signature pads, storing and printing signature images on statements, invoices and cash slips

·        Oversee development and maintenance of:

·        Interfaces with Quick Books accounting software

·        PDA interfaces for inventory and purchasing

·        Interfaces with SuperCharge and NovaLink for clearing credit and debit cards over the Internet

·        Conversions from multiple competitors and training in the use of Monarch for conversions

·        Implement the use of Visual Source Safe, standards for error trapping and logging, and code review standards and practices

 

Creditor Resources Inc, Indianapolis, In                                                                                             5/98 - 12/02

Field Support Engineer

  • Installations and Technical Support for Credit Unions

·        Programming in MS T-SQL, VBA, and WinBatch

·        MS Windows/NT Server, SQL Server, and CRI Products

·        MS-DOS or Windows workstations with CRI Products, MS Office, and other end-user applications

·        Forms and reports using Crystal Reports and CRI software

·        Terminal emulation with Core Bridge, Rumba, and IBM eNetwork

·        Installing and configuring network hardware

·        Support end-users on site or via phone and remote control software

 

Financialware, Indianapolis, In                                                                                                             1/97 - 5/98
Installations and Support

  • Installations and Support of item processing and image processing systems for financial institutions

·        Programming in MS Visual Basic, MS T-SQL, and COBOL

·        Creating and maintaining forms and reports using Crystal Reports

·        MS Windows/NT Server, SQL Server, Kofax Optical Server, and Financialware Products

·        Windows workstations with Financialware Products and other end-user applications

·        Programming and supporting NCR 7770 and 7780 Proof Machines

 

Reilly Industries,  Indianapolis, In                                                                                                        1/92 - 1/97
Computer Programmer

·        MS Visual Basic, VBA, Borland C, and MicroFocus COBOL

·        Creating and maintaining forms and reports using Crystal Reports

 


EDUCATION

 

Professional Careers Institute, Indianapolis, In                                                                             1/ 83 - 12/83

Computer Science: COBOL, BASIC, and RPGII on IBM System 34.

 

Carmel High School, Carmel, In                                                                                                           11/76 - 6/81

Hawaii