Uploaded File
add photo
Debbie
d.campano@att.net
908-685-0738
116 Choctaw Ridge Rd
Branchburg, NJ 08876
Data/Business Analyst
33 years experience W2
0
Recommendations
Average rating
2
Profile views
Summary

Experience
Data/Business Analyst
Jan 2021 - present
at United Health Group/Optum
  • Participate in Data Governance activities and responsible for data integrity.
  • Create source-to-target mapping based on requirements.
  • Create rules definitions and transformation logic from data source to CDF.
  • Gather and prepare analysis based on information from internal and external sources to evaluate and demonstrate program effectiveness and efficiency, and problem solving.
  • Conduct analyses/detailed data profiling.
  • Research complex functional data/analytical issues.
  • Gather business requirements for analytical applications in iterative/agile development model.
  • Responsible for data integrity among various internal groups and/or between internal and external sources.
  • Provides source system analysis.
Business Analysis Data Governance Data Integrity Data Profiling System Analysis
Remove Skill
Business Analyst Consultant
Jan 2018 - Jan 2020
at MetLife
  • Improved MetLife digital strategy and customers experience by improving the Change and Release Management Processes.
  • Designed Project Artifacts and Templates for the MetLife Data Hub (MDH) and designed the Project Artifacts Library in SharePoint.
  • Improved the Data Quality of the data used by the Call Center to provide a 360 view of the Customer's Data. Defined data curation processes and rules as well as improved MDM (Meta Data Management) matching processes to ensure the Call Center and Customer APIs provided a full view of the coverage and claims for the entire family.
  • Designed and managed multiple Share Point Share Sites. Including granting access.
  • Designed, documented, and implemented process for MDH including Change and Release Management.
  • Investigate and managed Data Issues reported by the Call Center to resolution.
  • Set up JIRA Projects to tracking Data and Issues for MDH and Change Requests. Presented JIRA backlog in Daily review calls and approved changes in all environments: Development, QA and Production.
  • Facilitated Daily Meetings and reported on Daily Changes for and deployment of APIs and Data Loads from the Systems of Record (SOR
  • Mainframe).
  • Created work instructions for Change and Release Management and Creating Task and Stories in JIRA.
  • Triaged Data Issues reported in Service Note (SNOW), routed to appropriate group for analysis and root cause. Update and reported metrics to the Business.
  • Compiled Data Load Metrics and reported to Upper Level Management Daily. Reported on Successful, Failure, Near Real Time (NRT) and Recon Data Loads.
  • Attended Change Control Review and Approval meetings prior to a release.
  • Provide Metrics for Active Party Counts between the source, Global Party Management (GPM) to the Active Parties in the landing zone, MDH and the Enterprise On-Line Store (EOS). Technology: Big Data, HBase, Titan/Janus, SOLR, APIs, Informatica, Collibra
Business Analysis
Remove Skill
Systems Analyst
Information Technology
Jan 2015 - Jan 2017
  • Systems Analyst for the Consumer Database (CDB) Application. CDB houses all the members' data including coverage eligibility, coverage timelines and PCP information.
  • Operated in a Mainframe (TSO) and COBOL environment, APIs, SQL, USEC, Big Data/Data Lake
  • Worked with the Business to define dashboards and reports to access Patient Eligibility data in Tableau.
  • Designed and configured user dashboards and reports in Tableau based on the calling application, the user's role and security profile.
  • Updated data models and views to export Patient Eligibility data from TSO database to Data Lake.
  • Wrote Business Requirements, Data Modeling, Process Flows and Technical Specifications
  • Worked in both Waterfall and Agile methodologies
  • Extensive use of SharePoint for housing all project related documentation
  • Used Rally for tracking Agile tasks, estimates, progress and blockers
  • Responsible for Security including Offshore restrictions, Application and User Access
  • Worked on a project to send data to the Data Lake
  • Mentor for the junior System Analysts on the CDB team
  • Completed Internal Scalable Agile Method certification training.
  • Used Service Now to track issues.
Agile Methodology System Analysis Waterfall
Remove Skill
IT Project Management/Analyst
Information Technology
Jan 2012 - Jan 2015
  • Reported to the CIO of the IT Department.
  • As Change Control Manager tracked and report on all system changes
  • Produced Business Requirements, Technical Specifications, Process Flows and Database Models.
  • Project Management and Tracked team of 10+ programmer and analysts.
  • .Net/SQL/Oracle Applications: Aggregate Spend, Sample Accountability, Pharmacy Service DTP, Signature Audits, Alternative Sampling and Learning Management System
  • Produced and executed Test Script using Visual Studio Test Manager 2013.
  • Provided IT Support
  • BMC Track-it v11.2 including tracking and assigning trouble tickets.
  • Reported KPI for IT Support weekly to the CEO.
  • Utilized Microsoft TFS 2012, Visual Studio 2013
  • Member of the Project Management Organization
Auditing Project Management SQL
Remove Skill
Computer Instructor/Technical Support/System Administrator
Information Technology
Jan 2008 - Jan 2010
System Administration
Remove Skill
Jan 2007 - Jan 2008
Highland Park Schools
No skills were added
Remove Skill
Computer Instructor/Technical Support
Information Technology
Jan 2006 - Jan 2007
Randolph BOE, NJ - Computer Instructor
No skills were added
Remove Skill
9th - 12th Computer Instructor/System Administration/School Web Site Development
Information Technology
Jan 2005 - Jan 2006
  • Worked as a computer science technology instructor and provided technical support and system administration for schools.
  • Duties Included network user administration and email, Internet security, software updates, trouble shooting, website maintenance and server administration.
  • Taught Web Design using Front Page, Java Virtual Machine, PhotoShop, Dreamweaver, Flash, Fireworks, ActionScript, JavaScript, CCS, Templates and HTML.
  • Taught database development using Access.
  • Taught Architectural Design using Google SketchUp.
  • Taught MS Office including Work, Excel, PowerPoint and Publisher.
  • Worked with other teachers to integrate technology into class instruction.
  • Lesson planning and Curriculum development working with the other Technology Resource Instructor and Grade level teachers.
  • Provide technical support and trouble shooting.
  • Modify lessons for Special Education Students.
  • Worked with other teachers to integrate technology into class instruction.
  • Network user administration and email, Internet security (Fortes), software updates, trouble shooting, website maintenance and server administration.
Adobe Dreamweaver Adobe Flash Adobe Photoshop JavaScript System Administration
Remove Skill
Project Leader, Systems Analyst
Information Technology
Jan 2003 - Jan 2003
  • Environment included: Visual Elks, Visual Studio, Panorama, SQL Server
  • Project Manager and System Analyst for Client Services Department.
  • Worked with Pharmaceutical Companies to define the requirements to customize Visual Elk application.
  • Visual Elk is a Customer Relationship Management system that can be configured to meet user requirements
  • Produced the requirements definition and documentation.
  • Tracked project development, testing and implementation.
Project Management SQL SQL Server System Analysis
Remove Skill
Project Leader, Systems Analyst/Programmer
Information Technology
Jan 2000 - Jan 2002
  • Environment included: UNIX/Solaris, Windows NT, Window ME, HTML with Style Sheets, ASP, PERL, Oracle 8, Shell, KSH, Power Point Presentation
  • Removed Duplicate user accounts in the People Database and user's system accounts.
  • Collected password files for Unix system accounts and verified information in the People Database using PERL scripts.
  • Created facility for sharing of information to enable systems to resolve problems.
  • Preformed all changes to People Database and tracked the teams progress.
  • Coordinated requests for changes and provided requirements to Administrative Computing Services Department.
  • Web Master for several University Web Sites, written in HTML using CSS.
  • Provided third-tier support for Help Desk relating to database updates.
  • Web Master of the web site for the interactions of the People Database and the Rutgers Account Tools and Service (RATS) application. RATS is the University's account creation tool. These were written in HTML using the standard Rutgers University style sheet.
Project Management System Analysis UNIX Windows
Remove Skill
Manager/Business Analyst/Programmer
Information Technology
Jan 1988 - Jan 2000
  • Environment included: Microsoft Visual Studio (.Net), SQL Server, Unix, Window NT, Window 98, Visual Basic, Java, HTML, ERWIN, Visio, Microsoft Word, Microsoft Project, Software Development Framework, Microsoft Visual Interdev
  • Worked with many AT&T divisions defining and building software applications.
  • Provided overall project management and leadership for team of analysts and developers.
  • Provided web-based and client/server application analysis and development.
  • Developed user front-end interfaces and created data models, scripts and databases.
  • Directed and led development efforts and responsible for analysis, development, installation and production support.
  • Set up servers and installed software.
  • Set up user accounts and access rights.
  • Worked on a Government System to track buildings and billed divisions of the Government based on building use.
  • Total Integrated Business Solutions (TIBS) division. As Project Manager, responsible for providing the Project Plans and Project Costs for five internal projects to upper management on a weekly basis. Communication with the customer and the development team was key competency in this project.
  • Project Leader of the development of the TIBS Associate Profile System Interface (TAPSI).
  • The TAPSI project was implemented using the Software Development Framework Process. Developed using Microsoft Visual Interdev and Microsoft SQL Server database.
  • Responsible for the software releases and system and database access.
  • Used ERWIN to design and create the data model used to create and update the SQL database.
  • Lead Analyst on the System for Tracking and Administrating Real-Property (STAR). This is a Client/Server System with a CENTURA/SQL Windows front end, which communicates with a UNIX server, and a Sybase Database through TUXEDO views.
  • Member of a technical team for Global Client Support Center TRU, a Client/Server development and deployment platform. Responsible for Inventory and provisioning functions on a client/server windows application.
  • Work as an internal consultant on the PROMPT project for Global Real Estate starting in 1994 as a developer/analyst working in the Billing Module using UNIX/C, SQL Windows, writing TUXEDO views and writing Stored Procedures in Sybase for this Client/Server environment.
  • Project Leader in 1995 for the Billing and Projects Modules. Supervised a total of eight programmers. Led the effort that resulted in the cloning of the system for the AT&T/Lucent divestiture.
  • From 1988
  • 1994 work for AT&T Billing Systems as a Project Leader.
  • Directed and led the development of a UNIX/INFORMIX system.
  • Responsible for the analysis, development, and production support.
  • Was an active member of various quality teams including Change Management, Maintenance Requests and Inter-System Testing and Quality Improvement.
Business Analysis Change Management Java M&A MS Project MS Visio Production Support Project Management Project Planning SQL SQL Server Stored Procedure Visual Basic Visual Studio
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Continuing Education Computer Science
William Paterson College
New Pathways to Teaching in
New Jersey City University
Certifications
Master Certificate, Project Management, George Washington University
Scalable Agile Method certification Tableau
Skills
Project Management
2015
17
SQL
2015
15
Business Analysis
2021
14
Change Management
2000
12
Java
2000
12
M&A
2000
12
MS Project
2000
12
MS Visio
2000
12
Production Support
2000
12
Project Planning
2000
12
SQL Server
2003
12
Stored Procedure
2000
12
Visual Basic
2000
12
Visual Studio
2000
12
System Analysis
2021
4
Auditing
2015
3
System Administration
2010
3
Agile Methodology
2017
2
UNIX
2002
2
Waterfall
2017
2
Windows
2002
2
Adobe Dreamweaver
2006
1
Adobe Flash
2006
1
Adobe Photoshop
2006
1
JavaScript
2006
1
Data Governance
2021
1
Data Integrity
2021
1
Data Profiling
2021
1