Jim S.

Senior Consultant

Venice , United States

Experience: 20 Years

Jim

Venice , United States

Senior Consultant

124800 USD / Year

Immediate: Available

20 Years

Now you can Instantly Chat with Jim!

Chat Now

About Me

Seeking position utilizing Microsoft SQL Server technologies. Over 20 years of extensive consulting experience in Information Technology providing dedicated, self-directed support to multiple local and remote clients ranging, both domestically and in...

Skills

Positions

Business Analysts

Software Engineer

Data Engineer

Portfolio Projects

Description

Automated a manual security clearance approval process at the Department of Energy Nuclear facility at Battelle Pacific National Laboratories using Microsoft SQL Server 4.3 and 6.0. The system provided analysis and statistical data tracking for Counter Intelligence personnel in support of national tasking. As sole source consultant decreased manual approval process from four weeks to less than one day and eliminating three clerk positions. System designed utilized SQL Server backend with multiple synchronized servers throughout the U.S.

Show More Show Less

Description

Over a one-year period, designed and implemented a high-profile analysis project using ASP and SSRS on the front end for management and reporting of derived securities. Analysis used to drive off-shore hedge fund trading of over 9 billion dollars and provided immediate feedback for determining risk/reward ratio of packaged security products. Aggressively monitored the ETL processes to reduce load times and ensure data integrity. System designed using SQL Server SSIS and hundreds of different data sources; programmed and dynamically switched scripts to change sources and to isolate errors in data stream during data cleaning and importing.

Show More Show Less

Description

Served as IT Lead for the American Express Project Office. Retrieved and analyzed all Travel Related Services projects over a 5-year time span. Documented requirements, created design specifications, and analyzed data. Identified projects that were not being completed and associated costs, resulting in 40+ projects being dropped over a 10-month time span for a savings of over $300M.

Show More Show Less

Description

Designed and developed custom CRM/billing integration package for technical staffing firm to manage contacts, bill clients/projects and prepare employee timesheets using ASP.NET (C#) frontend with SQL 2016 database. Integrated with Google maps for client and employee tracking. Imported data from retired system via SSIS and generated new custom drill down reports using SSRS.

Show More Show Less