SUMMARY

• Senior Business/ Data Analyst with twenty years of experience in Information Technology, in the healthcare, pharmaceutical, utility and financial industries.
• Works closely with both Business and Technical teams to understand business needs, develop and prepare complex reports, and interpret data across divisions and departments.

PROFESSIONAL EXPERIENCE

Confidential, Philadelphia PA

Business Analyst/Data Warehouse Analyst

Responsibilities:

• Work closely with Subject Matter Experts to develop a thorough understanding of how data is maintained in the Enterprise Data Warehouse (EDW) structure and how it interfacing with corporate systems.
• Communicate, facilitate, and document meetings to gather business requirements.
• Create, communicate, and maintain mapping documents to create new and modify existing tables/views in the EDW structure.
• Create data files to support internal and external data requests.
• Work with business utilizing screen shots from the corporate systems to tie into data elements in the EDW.
• Identify and resolve requirements and design issues, working closely with the business and technical areas.
• Conduct significant data analysis to support requirements gathering and to validate mapping rules.
• Extract, analyze, and interpret data from the EDW to satisfy internal and external requests.
• Analyze and interpret files of various data types (e.g., txt, csv, delimited, data, etc ) from external sources for implementation into the EDW structure for business use.

Confidential, Philadelphia, PA

Business Analyst/Data Reporting

Responsibilities:

• Work closely with Subject Matter Experts to develop a thorough understanding of how data is maintained in the Enterprise Data Warehouse (EDW) structure and how it interfacing with corporate systems.
• Communicate, facilitate, and document meetings to gather business requirements.
• Create, communicate, and maintain mapping documents to create new and modify existing tables/views in the EDW structure.
• Create data files to support internal and external data requests.
• Work with business utilizing screen shots from the corporate systems to tie into data elements in the EDW.
• Identify and resolve requirements and design issues, working closely with the business and technical areas.
• Conduct significant data analysis to support requirements gathering and to validate mapping rules.
• Extract, analyze, and interpret data from the EDW to satisfy internal and external requests.
• Analyze and interpret files of various data types (e.g., txt, csv, delimited, data, etc…) from external sources for implementation into the EDW structure for business use.

Confidential, Somerset, NJ

Business Analyst/Data Reporting

Responsibilities:

• Develops queries for data extraction and data analytic purposes using systems such as Hyperion, SQL and Microsoft Access for internal/ external customers.
• Performs analysis tracking trends in customer behaviors, such as usage and payments habits.
• Creates queries, Microsoft Access databases and reports in Excel (Pivot Table/ Dashboards utilizing various Excel functions such as VBA, VLOOKUP and If statements), for various levels of management to analyze performance (financial and/ or customer level).
• Interacts with stakeholders to gather functional requirements, identify reporting needs and define business usage via meeting or user stories.
• Supports macro - based tools to support business process within Microsoft access or Excel.
• Participates in a multi-level, multi-team daily telephone statistical reporting calls.
• Works within established deadlines and time constraints.
• Develop an understanding of front end systems such as CIMS, PragmaCad, Field & Meter Services Tracking, Probe etc.

Confidential, Radnor, PA

Business System Analyst

Responsibilities:

• Worked in parallel with the Business and Technical teams to understand, document and communicate business needs and requirements associated with the design and development of business systems to support Health Care Reform (Affordable Care Act) initiatives.
• Remediated business systems and processes to align with mandates due to Health Care Reform, Center for Medicaid/ Medicare Service (CMS) and other government regulations such as ICD10.
• Perform gap analysis to evaluate the impacts of systems integration. Initiate actions to close the gaps or develop work process in lieu of data.
• Gathered requirements and assisted in the analysis and planning and design of business solutions.
• Worked to achieve project goals and objectives within various Project Management methodologies, such as Waterfall, Agile and JAD.
• Interacted with stakeholders to gather functional requirements, identify reporting needs and defining business usage via meeting or user stories.
• Prepared analysis based on information from internal/ external sources to evaluate/ demonstrate various types of performances effectiveness/ efficiency.
• Developed scalable reporting processes and querying data sources to conduct ad-hoc reports and analysis within Teradata and Microsoft Access.
• Developed and prepared complex reports and provided/ interpreted information and data across divisions and departments.
• Extracted and analyzed data from various source systems (Teradata, SAP ERP, SQL, Oracle and Microsoft Access) to clarify/ validate the accuracy/ completeness of data reports for the purpose of internal/ external review.
• Prepared documentation of requirement specifications, addressing deliverables and establishing metrics in joint efforts with the Project Management team.
• Worked with the Program Manager and other team members to plan business analysis activities and manage the requirement plan.
• Performed and participated in continuous improvement of business analysis processes and templates.
• Created queries, Microsoft databases and reports in Excel (Pivot Table/ Dashboards, utilizing various Excel functions such as VBA, VLOOKUP and If statements) for various levels of management and for the purpose of system enhancements or system re-platform.
• Work with project lead to develop test plans as well as assist the tester with the execution of test plans.
• Worked as a Jr. Project Manager/ Lead BSA to assist in setting milestones, developing work plans, understanding/ developing work scope and guiding the team in meeting deliverables, and served as a User Acceptance Tester.

Confidential, Blue Bell, PA

Sales Force and Alignment Specialist

Responsibilities:

• Executed Sales Force changes/ alignment on an "on-demand" basis.
• Maintained consistency within multiple internal systems regarding changes/ alignments.
• Performed analysis to ensure that the structure met the business needs and profitability/ accurate personnel alignment.
• Extracted data from several platforms to perform analysis utilizing Excel and Microsoft Access.
• Maintained SharePoint team site data/ reports for collaboration purpose and field access.
• Served as a Subject Matter Expert (SME) on a transition team between an outside vendor and business team.
• Ensured data accuracy and performed testing.
• Answered alignment questions from various levels of management.

AlphaNumeric, Raleigh, NC

Data Analyst and Data Reporting

Responsibilities:

• Worked closely with Business and Technical teams to understand, document and communicate business needs and requirements associated with the design/ development of statistical reports in MS Excel.
• Worked with Technical and Project Management teams to gather requirements and to assist in the analysis, planning and design of business solutions.
• Interacted with others to gather functional requirements, identify reporting needs and defining business usage.
• Prepared analysis based on information from internal/ external sources to evaluate/ demonstrate sales performance effectiveness/ efficiency.
• Developed scalable reporting tools and processes to assist in driving business. Extracted and analyzed data from various source systems (Business Objects, SharePoint and other internal databases) to clarify/ validate the accuracy/ completeness of data reports for the purpose of internal/ external review.
• Worked with the Program Manager and other team members to plan business analysis activities and manage the requirement plan.
• Create queries, Microsoft Access databases, reports in Excel (Pivot Table, Dashboards and Scorecards utilizing various advanced Excel functions such as VBA, VLOOKUP, Nested and If statements) for various levels of management and Oncology team personnel.

Confidential, Radnor, PA

Financial Business Analyst

Responsibilities:

• Worked closely with Business and Technical teams to understand, document and communicate business needs and requirements associated with the design/ development of financial reports.
• Worked with Technical and Project Management teams to gather requirements and to assist in the analysis, planning and design of business solutions.
• Developed and prepared complex reports and provide and/ or interpret information and data across divisions and departments.
• Extracted and analyzed data from various source systems (SAP ERP, Oracle and Microsoft Access) to clarify/ validate the accuracy/ completeness of data reports for the purpose of internal/ external review.
• Created queries, databases and reports for various levels of management and Sales Force.
• Generated month-end, ad-hoc reports utilized by various levels of management, the Sales Force team and external customers (vendors).
• Gathered business requirements and extracted data through various systems (SAP, Oracle Browser and Access) and data sources.
• Performed data analysis for trends and made recommendations to increase profit loss/ gains and examine the client base.
• Prepared various materials for review, including data reports and PowerPoint presentations utilizing Sales tools for both internal/ external reviews/ meetings.
• Developed and documented processes/ work flow for efficiency.
• Developed small application tools in Microsoft Access and Excel utilizing VBA and macros to increase functionality.
• Trained other personnel on software to increase the user’s proficiency and enable them to have ready access to Sales data.

TECHNICAL SKILLS

Software/ Applications: Business Objects XI; Teradata Client and Assistance 13.0; Hyperion; SharePoint; SAP ERP 7.0; Oracle Discover; Microsoft Office 2010/ 2007 (Access, Word, Outlook, Excel, PowerPoint, Publisher, Project and Visio); Abode Professional 8.0; Lotus Notes 7.0; Procomm Plus v.4.7; Photoshop CS 7.0; Final Cut Pro; Abode Premier; Dreamweaver; Macromedia Flash; SNAG 8.0

Network Software: Windows Small Business Server 2003/ 2000; MS Exchange Server; VERITAS Backup Exec Ver 8.6; Symantec Antivirus Corporate Edition; Computer Associate E-Trust Antivirus; Microsoft Back Office Small Business Server 4.5

Programming Languages/Databases: Teradata Client 13.0; MS SQL 2000/ 2005; MS Access; VBA (Visual Basic for Application); Visual Basic 6.0; Oracle Platforms