Post Project
  • Search
    • Buyers can
    • Search offers to buy now
    • Search freelancers to request a proposal
    • Freelancers can
    • Search projects to quote on
  • How it works
  • Log in
  • Sign up
  • Freelancer?
Browse by Category
    Technology & ProgrammingWriting & TranslationDesignDigital MarketingVideo, Photo & ImageBusinessMusic & AudioMarketing, Branding & SalesSocial Media
    Jkm Hoffman

    Jkm Hoffman

    vba,database,teradata,qlikview

    Palm Harbor, FL, United States

    English speaking

    Jim Hoffman 727-7858-8361 jkmhoffman@gmail.com Us citizen No temple terrace,brandon,riverview,sabal park ,mcdill to far to commute from palm harbor,fl https://www.linkedin.com/in/jkmhoffman/ Experience: Humana...Read moreJim Hoffman
    727-7858-8361
    jkmhoffman@gmail.com
    Us citizen
    No temple terrace,brandon,riverview,sabal park ,mcdill to far to commute from palm harbor,fl
    https://www.linkedin.com/in/jkmhoffman/

    Experience:
    Humana March 2014 - January 2018
    Programmer
    ● Responsible for measuring the growth and trends of the State of Illinois enrollment of Medicare and Medicaid patients.
    ● Produce reports to show populations metrics for the state of Illinois
    ● Ran SQL queries to prepare metric data for reports
    ● Did SQL data mining to verify metric totals for all reports
    ● Prepared backup and restore utilities to backup Humana data
    Matrix Medical September 2013- January 2014
    Application Developer
    ● Development & Automation of Metric Reports.
    ● Gathers requirements, converts them to technical specifications, develops, tests, releases and maintains reports
    ● Lead the design of software architecture specifications and technical interfaces.
    ● Create table views, KPI data pulls from primary sources.
    ● Development Projects, automation of performance metrics Contest Scorecard & Deliverables, Rewards Scorecard & Deliverables
    ● Career path Scorecard & Deliverables Automation of daily Production Metrics
    ● Create a new Dashboard Automation of KPI Trends & Charts currently being used Planning and Integration of the KPI & Scorecards with any IT Server changes
    Granite Services, Inc. January 2011 - March 2013
    BI Qlikview Developer
    ● Experienced with excel using formulas, conditional formatting, pivot tables, v-lookups, building macros and linking data or able to acquire the skill. Develops tools (e.g., databases, spreadsheets) that facilitate preparation and presentation of business metrics and business analytics related to divisional benchmarks and the Balanced Business Scorecard.
    ● Hands on experience with BI Qilkview Technology.
    ● Design dashboards reports that display key performance indicators (KPIs), scorecards and
    ● drill down details





    Jim Hoffman
    727-7858-8361
    jkmhoffman@gmail.com
    Experience:
    Humana March 2014 - January 2018
    Programmer
    ● Responsible for measuring the growth and trends of the State of Illinois enrollment of Medicare and Medicaid patients.
    ● Produce reports to show populations metrics for the state of Illinois
    ● Ran SQL queries to prepare metric data for reports
    ● Did SQL data mining to verify metric totals for all reports
    ● Prepared backup and restore utilities to backup Humana data
    Matrix Medical September 2013- January 2014
    Application Developer
    ● Development & Automation of Metric Reports.
    ● Gathers requirements, converts them to technical specifications, develops, tests, releases and maintains reports
    ● Lead the design of software architecture specifications and technical interfaces.
    ● Create table views, KPI data pulls from primary sources.
    ● Development Projects, automation of performance metrics Contest Scorecard & Deliverables, Rewards Scorecard & Deliverables
    ● Career path Scorecard & Deliverables Automation of daily Production Metrics
    ● Create a new Dashboard Automation of KPI Trends & Charts currently being used Planning and Integration of the KPI & Scorecards with any IT Server changes
    Granite Services, Inc. January 2011 - March 2013
    BI Qlikview Developer
    ● Experienced with excel using formulas, conditional formatting, pivot tables, v-lookups, building macros and linking data or able to acquire the skill. Develops tools (e.g., databases, spreadsheets) that facilitate preparation and presentation of business metrics and business analytics related to divisional benchmarks and the Balanced Business Scorecard.
    ● Hands on experience with BI Qilkview Technology.
    ● Design dashboards reports that display key performance indicators (KPIs), scorecards and drill down details
    ● Capable with complex queries using multi-table joins (inner, outer, and full) and use of scalar and columnar functions. Deliver reports to end users, receive feedback to finalize reports.
    MS Access 2003/2007 – Creating forms, reports, queries, and VBA/modules. Includes updating existing and implementing new Access DBs from start to finish. I produced Access queries to be exported into Excel as a report. I programmed an employee tracking system using VBA with an Excel multi-sheet back end. This system tracked late employee dates and other employee information Report writing Excel macro-enabled workbook Design and code screen layouts, graphical user interfaces, printed outputs, and interfaces with other systems.
    ● Email and calendaring functions Experience with Teradata client software and utilities. Functional Design Testing
    Auditz
    2011 – Jul 2011
    • Reporting Analyst using MS Access and MS Excel for creating user reports for advanced payer search and reimbursements for a company that contracts with hospitals to increase cash flows on unpaid accounts
    • Testing including: Performance, stress, capacity and benchmark
    • Experience in data mining, scrubbing and data cleansing(de-duplication strategies)
    • Development, Design, Test & Production Support
    • Table, Query, Form and Report design.advanced knowledge of MS Excel including pivot tables, V-lookups and Macros.
    • Data Analysis – experience reviewing report and query results to identify issues with data and/or query components

    Programmer
    Verizon Wireless - January 2010 - February 2010
    (2 months) Ability to use and create multiple worksheets, linking of data (inside/outside of Excel)
    ● Telecom Background Technical Experience Billing Experience (a plus) Functional expertise in business process reengineering, transformation, organizational design/change management, implementation planning and execution, migration and conversion, testing and/or training Through understanding of relationships and linkage between tables (primary/secondary keys). Through knowledge of the creation and use of Access Tables, Queries, Forms, Reports, Macros and Ability to "build" an application from the ground up. Ability to review and troubleshoot existing Access Databases.
    ● Excel skills. Specific needs and skills for the position are detailed below.
    ● Excel 2007, specifically VBA code for Excel
    ●
    ● MS Access 2007
    Completing a prototype Access database to follow loose specification followed by importing multiple Excel
    files to populate database
    Fundamental query/screen/report routines to facilitate with data review/edits
    SQL Experience with Reporting and building reports
    • Understanding of data warehousing/reporting concepts/terminology
    ● GUI application design Client/server databases Strong researching, organization, computer skills, and internet search engine experience (Boolean search strings, etc MS Access Report/Query Optimization software testing disciplines and methodology; software development lifecycles test practices and QA; or various areas of software testing (i.e. Functional, System, Integration, Data Validation, Scalability, Performance, Stress and Load). General knowledge of System Architecture and Design principles required. Automated testing tools required. Used DML statements (i.e. Inner Join, Outer Join, Cross Joins, Self Joins, aggregate functions etc). Solid grasp of object-oriented principles and event-driven programming
    programmer
    Verizon Wireless April 2002 - February 2009 (6 years 11 months)
    ● Created User Interactive screens with checks and balances to ensure proper data is captured. Approved Process Validation Reports. Experience extracting data from multiple data sources like flat files, SQL Server, DB2 UDB, etc. Hands-on experience with configuring data sources for source and target within the mappings. · Heavy conversions of doctor practices that used EXCEL to hold practice information. All of these were demographics conversions from EXCEL to SQL Server. Data Access Using Microsoft SQL Server 2008, MS SQL EXPRESS Data Format/Claims Scrubs and edits
    ● Medical Information Management Experience in physical structure and functional capabilities of data bases, data back-up/recovery specifications. Carefully examines data and reports to make sure conversion is proceeding correctly, runs test scripts with various data to see how new or customized transactions process through the software and verifies and validates accuracy of data through the generation of a variety of reports.
    ● SQL Server 2005/2008 – Experience designing, implementing, and administering SQL Server databases. Includes advanced queries, Backup and recovery planning. Manual re-indexing, integrity checking, database shrinking and etc report writer,medical conversions provider profiling or episode treatment grouper experience manual address cleansing healthcare experience (PAYER)
    table maintenance codes Used and coded appointment schedulers
    ● Experience with computerized physician AR, scheduling or other related medical billing/management systems/or electronic health record.
    · Processes of programming such as compiling, source code editing, debugging, testing and deployment
    hard coded routines user access and system configuration Designs conversion procedures connectivity tests Utilizing SQL server Management studio Database Backup/Restore/Recovery management
    database/programmer
    Visionary Medical January 2001 - February 2009 (8 years 2 months)
    ● Senior Programmer - Full-time This project involved extensive database conversion coding using Visual Basic 6.0 of a Btrieve medical billing system to a SQL Server 2000 Data center database in Orlando. I was heavily involved in on-line retrieval and testing and end-user testing. Also extensive use of SQL Server Enterprise Manager 2000/2005 for database creation, backups, restores, stored procedures, T-SQL, DTS imports/exports. Over 300 clients with 1800 databases were converted from 60 different Medical Billing systems to 1 common system. Our data center model was the ASP model using Microsoft Remote Desktop and also involved transmitting SQL Server backups to the AT&T data center over a VPN (Virtual Private Network). Used MS Active Directory to modify remote site parameters. Performed 100 SQL Database Recoveries for SQL 2000, 2005. Extensive use of SQL Scripting for maintenance imports. Also used Pervasive Map Designer to map ODBC, SQL, Binary, clarion,Btrieve databases to Visionary SQL databases. Used Web-ex for customer dialins.Set up ODBC connectivity and Citrix connectivity. Good experience in Test Automation, writing test scripts, creating test plans/scenarios. Used Visual FoxPro as it is related to medical conversions. Running SQL scripts for database upgrades and schema changes. Provided go-live support to end users. Knowledge of CPT, ICD-9, HCPCS, DRG coding. Knowledge of HL7 formats.
    ● Knowledge of Healthcare EDI (834,835,837) transactions. Created User Interactive screens with checks and balances to ensure proper data is captured. Experience with business data transfer; consolidation and validation techniques. Familiar with the database design, development, and normalization using the Microsoft SQL Server database management system (DBMS). Created formulas to map data tables to match vendor specified file formats. Encrypt files for secure file transitions between clients. Requirement gathering.

    (1 year 1 month) Senior Software Engineer. - Sept 2001 (8 months)s
    ● Heavy new development coding and design for a national workman's comp and managed-care provider company. This project written in Visual Basic 6 (with OLE documents, ADO data controls and grids and heavy use of server (network) based Access tables) is a complete front-end customer view of manager care providers with all demographics and repricing data. Approximately 40 different modules and approximately 20,000 lines of VB 6 code. Also extensive use of SQL Server 7 linked tables and extensive use of VB SQL commands. Also heavy installation coding using Wise Install Master 9.0. Used Full Development Life Cycle for this project. Customized commercial databases to fit specific needs. End-to-end development experience
    Programmer
    Verifone January 1997 - January 2001 (4 years 1 month)
    ● Senior Software Engineer - laid off due to merger In charge of designing, coding, testing, POS (point of sale) PC-based systems for the convenience store and gas-station industry. I also developed communications software for both serial and modem communications between a PC and the POS terminal. I used Visual Basic 6, Visual Basic 4 (Sheridan,InstallShield , Videosoft Controls) and Crystal Reports 7 extensively with some light VC++. I also developed installation programs using Wise Install Master to test/install the software on all variants of Microsoft Windows from Windows 95, 98, NT 4, 2000. Also I developed an Engineering Tracking system in Visual Basic 6.0 that interfaced with a server-based Clarify database. Extensive use of Visual Source_Safe (VSS) for source check-in and Visio for Flowcharts, diagrams. Also Used IM for contacts/chats. Experience with functional system, integrated, regression, and security testing. Developed system documentation. Prepared detailed workflow charts and diagrams that described input, output, and logical operations. Design and develop end-user documentation. used of GUID data type for some index fields Crystal report design and development Scanning, manipulating files, version control Help files Experience with source code management tools Seagate Crystal Reports version 7.0 - Used for point-of-sale reports at Convenience store registers - reporting on in-store sales and gas pump sales.
    ● 4 reports designed and implemented for c-stores over 2 year period.
    ● Features used: High Level reports , Detail reports , Drill downs , Formulas , Data groups Conditional formatting Highlighting Expert , Charting Expert , Report Distribution Expert, Performed bug fixes. End-to-end development experience
    Provide complete documentation in the form of commented code, problem status information, and design documents. retail POS

    programmer(contract)
    World Color Press April 1987 - August 1997 (10 years 5 months)
    ● Oracle Database Engineer/Internet Engineer -downsized This job entailed creating dynamic HTML web sites using Platinum SQL Station embedded inside of HTML, CGI and JavaScript. Our clients included Lucent Technologies, Paradyne and Spiegel catalogues. We used extensive data modeling (S-Designer) using physical data models and Oracle packages. These web sites allowed customers to place orders for telephone, routers, etc. in a shopping cart using an extensive search of online database with graphics images and catalogues. The web site ran on Sun Solaris servers. Used MS Exchange for internal email. Trained subordinates in programming and program coding. Developed web site maps, application models, image templates, or page templates that meet project goals, user needs, or industry standards. Wrote, designed, and edited web page content, and directed others producing content. Wrote supporting code for web applications/web sites and Database-backed websites.
    programmer(contract)
    Florida Power ( January 1997 - April 1997 (4 months) (3 month cont temp position)
    ● Senior Programmer Analyst, Systems Development I programmed in MS Access 2.0 tied in with Oracle databases on Windows NT 3.51 servers. I also programmed many graphs of Florida Power loads and temperatures, and performed many maintenance changes on existing systems. I worked for the Power Marketing Dept. in their trading room and their energy control center.
    programmer(contract)
    William Huff January 1997 - January 1997 (1 month)
    ● Analyst/Programmer Responsible for coding, testing, and documentation of a new security processing system. This system would allow account executives to review security positions, trades, production and customer account balances for securities such as Municipal bonds, equities, mutual funds, etc.
    (1 year) Oracle Developer 2000 Programmer
    Gatorbait Software--
    laid off due to company bankruptcy
    ● Developed conversion/load procedures for Oracle Accounting Software for the Nursery/Greenhouse Industry. Extensive use of Oracle 7.1 Developer 2000 in Windows 95 environment. Interaction with Novell Netware
    ● 4.1 and SCO Unix Servers. Extensive SQL Conversion coding using SQL * Plus and PL* SQL scripts, SQL Loader, Procedure Builder (Triggers), and Oracle Browser. Some Oracle forms (4.5) development and also Delphi 2 development. Design and development of scalable queries, stored procedures and functions in support of interactive and batch application systems. · Extensive use of cursors and stored procedures. · Used Veritas Backup Exec for storage backups. Work as part of a project team to coordinate database development and determine project scope and limitations. *Form level PL/SQL * Procedures, Functions, Packages, Triggers
    ● Ensure design & code reviews of stored procedures, schema design Object Code libraries referential constraints
    ● Assist in the Physical and Logical Architecture and Design of relational database schemas Status reporting
    ● Constructing database normalization .Responsible for the modeling, definition, creation, and maintenance of the database resource. Works closely with a team of developers and is involved in design decisions.
    ● Provides developers consulting on performance and optimizing SQL scripts. Managed client Apps and Non-Apps Oracle databases. Plsql was used here.
    Programmer
    Morton Plant January 1993 - January 1995 (2 years 1 month)
    ● Micro Computer Analyst - laid off due to merger Designed, developed, and implemented three complete financial applications for the Home Health subsidiary of Morton Plant. The applications were Payroll, Purchase Orders, and Human Resources. * All applications were written in Borland Paradox for DOS, and were installed on both Novell 3.1 networks and stand-alone . Symantecs PcAnywhere was used extensively to communicate data from office to office. * Developed employee wellness database using Microsoft Visual 3.0 and VB. 4.0 (Prof. Edition) and Microsoft Access 2.0. We used Crystal Reports for reporting.Also used Novell Network
    ● I designed gui interfaces and toolbars and menus Wrote a payroll interface using Quickbooks Graphical User Interface design and Event-driven programming
    programmer(jmh) January 1992 - January 1993 (1 year 1 month) home business wrote lottery software
    Senior Programmer Analyst
    ● First Florida- laid off due to merger Maintenance of Marshall & Isley banking code and conversion of correspondence banks to this vendor’s system.
    ● Converted seventeen banks from different vendors: C & S, NCR, FIS, Burroughs, · Extensive use of CICS, IMS DB/DC, Roscoe, Intertest, Easytrieve with IBM 3090 system. · NAFS to M & I deposit systems. · Converted 110,000 accounts and $600 million in balances for DDA, Savings, CD, IRA. Prepare portions of design documents for large-scale projects Account Reconciliation EBCDIC format
    Programmer laid off due to merger
    First Florida January 1986 - January 1990
    ● Senior Programmer Analyst, Systems Development 1986-1990 · Designed, developed, and installed a complete PC-BASED deposit and consumer loan branch automation system for First Florida branches. Saved millions of dollars in duplicate data entry, printing, and transmission costs to host and increased accuracy and efficiency. Co-Lead on project management and timeline was developed in MS Project. · Designed, programmed, and implemented the real-time transmission of customer information from PC’s to an IBM 3090 host using 3270 emulations. · Developed complete deposit and consumer loan reporting system in FoxBASE. The reporting system contained daily and monthly consolidated reports. · Analyzed, designed, coded, tested, implemented, maintained, and documented mainframe computer system software. Usually worked on one or more specific software applications and this includes operating systems, compilers, utilities, job control language, and other control modules.
    ● Performing roll out testing and productions. · Experience managing timelines and task priorities. · Requirement gathering · Write, analyze, review, and rewrite programs, using workflow chart and diagram, and applying knowledge of computer capabilities, subject matter, and symbolic logic. Consult with managerial, engineering, and technical personnel to clarify program intent, identify problems, and suggest changes.
    ● Created project plan, project schedule Heavy use of GL, Accounting for banking conversions.
    ● Spool file management
    ● Evaluates, designs, codes, implements, optimizes, and modifies databases and database applications with respect to JCL, access methods, access time, device allocation, validation checks, organization, protection and security, documentation, and statistical methods.
    ● Assist with project planning, project definition, requirements definition, analysis, design, testing, system documentation worked with subsysterm(cics calls)
    Programmer
    Collier Jackson January 1984 - January 1986
    ● Senior System Analyst Programming and installation of newspaper circulation software throughout the United States. This software was installed on HP 3000 and DEC. VAX mini computers. * Installed three newspaper circulation systems throughout the Midwest.
    Programmer
    Southeastern Computer January 1978 - January 1984
    ● Systems Analyst/Programmer-- laid off due to merger Programming, design, and installation of taxation and appraisal systems for county governments throughout the United States. All systems were on Burroughs small and medium systems. * Programmed and installed five taxation and appraisal systems in the United States. * Programmed complete taxpayer billing for ten county government clients.
    Maintenance and support of existing source code
    Programmer
    Gamma Systems January 1975 - January 1978
    ● Programmer Analyst Conversion of service bureau patient accounting system to in-house system. Development of on-line real time patient accounting system for patient charges, admitting, and insurance billing. Developed G/L system. * Converted service bureau to in-house in fifteen months for all charges and accounts receivable. * Developed real-time system in Burroughs DMS II for admitting, patient charges, and insurance charges, and insurance billing in thirty-six months. Analyzed, designed, coded, tested, implemented, maintained, and documented mainframe computer system software. Usually worked on one or more specific software applications and this includes operating systems, compilers, utilities, job control language, and other control modules.
    Education
    Bellarmine Prep School, Tacoma, Washington,
    University of Washington bs, physics,
    Iecubed -Ocp classes

    Us citizen
    No temple terrace,brandon,riverview,sabal park ,mcdill to far to commute from palm harbor,fl

    • $40
      /hr
    Contact

    Skills

    microsoft excelcrystal reportsoracle serverstructured query language (sql)Microsoft SQLServerdatabase developmentCOBOL programming languagedata visualizationmicrosoft accessmicrosoft excel powerpivot +5
    qliktech qlikviewsocial media strategyVBA programming languageVisual Basic programming languagevlookup tables

    Insights

    Freelancer Buyer
    Projects listed
    0
    Freelancers worked with
    0
    Last active
    Aug 21 2021
    Response time
    instantly

    Insights

    Freelancer Buyer
    Projects worked on
    0
    Buyers worked with
    0
    Last active
    Aug 21 2021
    Response time
    instantly

    Skills

    microsoft excelcrystal reportsoracle serverstructured query language (sql)Microsoft SQLServerdatabase developmentCOBOL programming languagedata visualizationmicrosoft accessmicrosoft excel powerpivot +5
    qliktech qlikviewsocial media strategyVBA programming languageVisual Basic programming languagevlookup tables

    Insights

    Freelancer Buyer
    Projects listed
    0
    Freelancers worked with
    0
    Last active
    Aug 21 2021
    Response time
    instantly

    Insights

    Freelancer Buyer
    Projects worked on
    0
    Buyers worked with
    0
    Last active
    Aug 21 2021
    Response time
    instantly
    Skills Insights

    Insights

    Freelancer Buyer
    Projects listed
    0
    Freelancers worked with
    0
    Last active
    Aug 21 2021
    Response time
    instantly

    Insights

    Freelancer Buyer
    Projects worked on
    0
    Buyers worked with
    0
    Last active
    Aug 21 2021
    Response time
    instantly
    Skills Insights
    microsoft excelcrystal reportsoracle serverstructured query language (sql)Microsoft SQLServerdatabase developmentCOBOL programming languagedata visualizationmicrosoft accessmicrosoft excel powerpivot +5
    qliktech qlikviewsocial media strategyVBA programming languageVisual Basic programming languagevlookup tables
    • Portfolio (1)
    • Reviews
    • Purchases
    • Endorsements
    Hide feedback
    The user has no activity as a Freelancer

    Product

    • About
    • Team
    • Careers

    Support

    • How it works
    • Trust & Safety
    • Help Centre

    Discover

    • GuidesStoriesNews

    Resources

    • Customer Stories
    • Business Cost Calculator
    • Startup Cities

    Browse

    • Freelance Services
    • Freelance Services By Country
    • Freelance Skills
    • Terms
    • Privacy
    • Sitemap
    • Company Details
    • © 2023 People Per Hour Ltd
    We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
    Cookie Settings
    Accept All Cookies