Programmer Resume

PROFESSIONAL EXPERIENCE

Confidential

Programmer

Responsibilities:

Responsible for measuring the growth and trends of the State of Illinois enrollment of Medicare and Medicaid patients.
Ran SQL queries to prepare metric data for reports
Did SQL data mining to verify metric totals for all reports
Created SharePoint presentations for team meetings on goals and future workloads.
Prepared backup and restore utilities to backup Confidential data

Confidential

SENIOR Application Developer

Responsibilities:

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
Used Tableaux for dashboards and scorecards.

Confidential

Senior BI Qlikview and Tableaux Developer

Responsibilities:

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 for 2 years as a BI Developer with Qlikview and some Tableaux.
Created SharePoint presentations for team meetings on goals and future workloads.
Designed 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 and receive feedback to finalize reports.

Programmer

Confidential

Responsibilities:

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. Used 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

Senior Programmer

Confidential

Responsibilities:

Telecom Background needed with 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
Thorough 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