Business Intelligence Developer Resume
Danville, PA
SUMMARY:
I have several years of IT experience in analysis, design, development and testing of Business Intelligence applications in healthcare and federal domain using Microsoft technologies and Agile SDLC methodology. Have expertise in security administration of BI software, development of complex BI dashboards and MS SQL Server ETL solutions. In addition, experience in developing reports, Confidential Packages and writing SQL queries and stored procedures in MS SQL Server. Practical experience in PLSQL+Unix+Informatica environments. Outside of the Microsoft stack, I recognize open - source solutions and advocate where possible.
TECHNICAL SKILLS:
Languages: C, VB, (PL)SQL, PHP
Software: SSMS, SSRS, SSIS, BIDS, Visual Studio, SharePoint, Business Objects, Informatica
EXPERIENCE:
Confidential, Danville, PA
Business Intelligence Developer
Responsibilities:
- Working as both business analyst and technical lead for provider network data
- Align technical solutions through rapid prototyping with stakeholder involvement
- Aid in retirement of legacy systems in favor of streamlined analytics (Qlik, SAP BO)
- Develop data quality rules in Informatica Analyst/Developer with Qlik front-end
Confidential, Wilkes-Barre, PA
Business Systems Analyst
Responsibilities:
- Contracted to United States Postal Service - Achieved and maintained ‘Sensitive’ Security Clearance
- Worked in rigorous Scrum deployment cycles supporting Confidential package tracking interfaces
- Technical lead on Expected Delivery Window pilot and executive Microstrategy dashboard
- Produced cost-benefit analysis leading to retirement of outdated manual reporting in favor of dashboards
- Data loading/evaluation, business requirements assessment, overhead assessment
Confidential, Danville, PA
Data Solutions Architect
Responsibilities:
- Technical Lead on customer-facing web portal initiative using open-source Confidential solutions as well as SharePoint
- Responsibilities as Javascript programmer utilizing various API calls to communicate with SharePoint 365
- Facilitate all Enterprise Information Management projects including scoping, profiling, database design, analysis
Confidential, Danville, PA
Business Intelligence Developer
Responsibilities:
- Consolidate disparate source system data (Oracle, SQL, Teradata, Flat file, legacy systems) into BI platform
- Worked with cross-functional teams in Agile/Scrum
- Actively participate in proof-of-concepts including Qlikview, Tableau, Hadoop, Drupal, Joomla
- Routinely work with large volumes of PHI and BSI, implement cleansing methodologies when needed
- Administrator role on 20+ web servers (IIS, Apache) and SQL instances (MSSQL) 2008R2, 2012
- Integral team member during departmental “Best Use of Business Analytics 2014” honor awarded by Kofax
Confidential, Danville, PA
Technical Analyst
Responsibilities:
- Primary security administrator of BI software for over 4,000 users (Altosoft, SAP BO)
- Configure web and SQL servers to support BI software
- Routine troubleshooting ranging from SQL logs to dashboard queries and design
Confidential, Kreamer, PA
Application Programmer
Responsibilities:
- Maintain and modify inventory tracking software in a .NET environment
- Internal SQL Reporting using Confidential Packages and Stored Procedures
- Deliver timely and accurate report data to facilitate purchase orders and financial initiatives
Confidential, Selinsgrove, PA
Student Technician
Responsibilities:
- Triage, repair and maintain University computers
Confidential, Wilkes-Barre, PA
Level 1 Technician
Responsibilities:
- Confidential Pharmaceuticals help desk support for in-the-field Sales Reps and Medical Liaisons
