We provide IT Staff Augmentation Services!

Bi/it Technology Lead Resume

3.00 Rating

Jersey City, NJ

AREAS OF EXPERTISE:

  • Business Intelligence / Data Analytics
  • Dashboards, KPI’s, Reporting
  • Archer Risk Management
  • Regulatory Compliance Reporting
  • Healthcare Rev. Mgmt
  • IBM Sterling Order Mgmt
  • E - Commerce
  • Supply Chain Mgmt
  • HMO / Clinic IT
  • Mortgage Securities
  • Financial Services
  • Shareholder Proxy Mgmt

BUSINESS INTELLEGENCE & WEB TECHNOLOGY PROFICIENCIES:

SQL Server

SSIS, SSRS, SSAS

DWBI, Datamarts

OLAP Cubes, ETL

Power BI

Power Pivot

Power Query

Power View

Excel

Crystal Reports

Active Reports

Database Design

Stored procedures

Functions, Triggers

SQL Tuning

DB2, Oracle

Data Migration

VB.net, VB v4-6

ASP.net, ASP

C#, Java

Web Services

FoxPro 2-6, VFP 2-9

HTML, DHTML

Javascript, VBscript

PL, AR, AP, GL

OCR Processing

XML, DLL, COM, IIS

ASPStorefront

Dokustar Design

837 / EOB’s

TFS

TECHNICAL PROJECT MANAGEMENT PROFICIENCIES:

Application Deployment

Release / Change Management

Configuration Management

Database Migration

Data Gap Analysis

Functional Specifications

Technical Specifications

SLA Trouble Shooting

Onshore/Offshore Mgmt

Business Liaison

Testing & Reporting

HP App Lifecycle

PROFESSIONAL EXPERIENCE:

BI/IT Technology Lead

Confidential, Jersey City, NJ

Responsibilities:

  • Worked with BOA BI/IT onshore and offshore teams supporting current and future enhancements, deployments, and troubleshooting of over sixty enterprise wide ETL Archer Risk Management and Compliance Regulatory Reporting applications. As the primary liaison for a key division I added value by:
  • Guiding business and IT teams on ETL and database release change, testing, and deployment strategies.
  • Managing meetings and interactions between end users, sponsors, and internal team members.
  • Leveraging my BI development, database, and reporting know-how to trouble shoot issues.
  • Driving and coordinating technical support on BI issues to resolutions guided by an SDLC framework.
  • Directing teams on change requirements, SSIS implementation, and application testing.
  • Owning SSIS and database development support on enterprise projects.
  • Integrating and configuring third party XML base enterprise reporting applications.
  • Programming, configuring, and deployment of SSIS ETL packages and related interfaces,
  • Integrating and deploying SQL Server database and stored procedures updates.
  • Documenting application workflow, data design, data dictionary, and data dependency mapping.

Tools: used included Visual Studio BIDs SSIS 2008r2 - 2012, SQL Server 2008 - 2014, XML, Team Foundation Server, HP Application Lifecycle Management

BI/IT Technology Lead

Confidential, Atlanta, GA

Responsibilities:

  • Worked with onshore and offshore resources supporting a client’s revenue cycle health care management division to create a POC for an EOB Claims data extraction application.
  • Client based EOB OCR image processing and data extraction
  • Rules based financial management and billing verification
  • Agent User Interface, 837 claims matching, batch and Lockbox management
  • Exception Reporting, Data Integration and Export of 835 payment file

Tools: used included Visual Designer, Dokustar Design Studio, Art Training Client, .Net, SQL Server, XML.

Confidential, Confidential, Newark NJ

BI technology lead

Responsibilities:

  • Application support, product development road mapping
  • Value added oversight to senior managers and technical directors toward future application expansions
  • Act as a liaison between client, onsite tech teams, and offshore development resources
  • Working with members of the Dashboard steering committee to provide strategic and operational updates
  • Manage the SDLC while articulating and prioritizing needs, benefits, and objectives
  • Planning meetings to discuss and enforce the scope of the work is aligns with clients timelines

Used: VS BIDS 2008r2, VS 2010, SS 2012, SQL Server 2010, SQL Server 2012, ETL, SSIS, SSAS, SSRS

Confidential, Virginia Beach, VA

Technology Lead / Business Intelligence Consultant

Responsibilities:

  • Established a roadmap for the development of an Web Based Ad-Hoc Report Writer
  • Spearheaded the design, development, and implementation of the Healthcare Dashboard
  • Managed the design and development of Healthcare Data Mart
  • Evolved the client eReporting experience with the implementation of data and cube driven report solutions
  • A web based Healthcare Management Dashboard with mutli - divisional statistical reporting and messaging
  • Healthcare centric eReporting using OLAP cubes with operational Measures, LOB and Market Dimensions
  • A healthcare Data Mart repository for operational and strategic planning
  • Design and deployment of Ad-Hoc user generated reporting
  • Led a team of developers that implemented Business Intelligence/Data Warehousing tools and artifacts

Used: VS BIDS 2008r2, VS 2010, SS 2012, SQL Server 2010, SQL Server 2012, ETL, SSIS, SSAS, SSRS

Confidential, Framingham, MA

Technology Lead / Systems Data Consultant

Responsibilities:

  • During the go-live implementation and configuration of the Yantra - IBM Sterling Order Management System OMS, I spearheaded and delivered the successful data migration of AS400 legacy reporting and ETL processes to DB2/MS Access for divisions supporting finance, financial planning, inventory, inventory deployment, logistics planning, reverse logistics, replenishment, lost cargo, fraud protection, wholesaler, transportation, and price matching.
  • Worked with the Shared OMS technical team to provide technical support and maintenance to the IBM Sterling OMS for online, direct, kiosk, and phone order transactions. In this role I provide efforts to identify and fix errors, bugs, and defects, as well as root cause analysis for sales orders, wholesaler transactions, returns, coupons, and financial adjustments. This OMS interfaces with Financial Posting Systems, Warehouse Management Systems, and Client Relation Management Systems.

Used: SQL, DB2, Oracle, MS Access, IBM Sterling Yantra OMS, Visual Studio.Net, Java, XML

We'd love your feedback!