Summary:

• An experienced Senior Data/Business Analyst and holds a Master's Degree.
• Over 15 years of senior level experience, providing project management, reporting, systems and business analysis to various healthcare, insurance, business and government environments
• Extensive experience of performing data analytics on large multi-variant data sets and metadata, advanced knowledge of SQL to extract data from a data warehouse and mapping source to target data where necessary for complex reporting.
• Intensive experience of querying and analyzing provider and membership data in order to further scrutinize outliers using SAS, SQL, Business Objectives, and Excel as querying, data mining, and analysis tools.
• Skillful in leading efforts to reverse engineer pharmacy data for the purposes of data modeling and future cost and benefit plan configurations.
• Experienced in QAs data through all stages of develop---development, test, staging, materialized views and reporting layers by heavy usage of SAS and SQL are used as tools
• Proficient in creating and implementing, test plans which include test cases, test scenarios, tests identities, and test data for User Acceptance Testing UAT .
• Proficient in Six Sigma, Waterfall, Agile iterative SCRUM UML, and BABOK methodologies, creates functional/non-functional requirements documents as wells as Requirements Traceability Matrix RTM .
• Extensive experience of operating business intelligence IBM Fraud and Abuse Management System and used CPT codes in order to setup and run through models.
• Excellent experience of preparing various internal managerial reports, presentations, and analyses to support monthly operating processes and management strategic decision-making.
• Strong experience of acting as liaison between IT, upper management, sales, implementations, customer service, training and reporting departments to provide feedback and recommendations on data management, software deficiencies and possible enhancements.
• Solid experience of acting as liaison with the marketing and implementation teams to identify potential market interests and gaps for the Sales department.
• Efficient in assisting payroll clientele in retrieving financial data via use of SQL or ORACLE functions and relational databases, troubleshooting windows/hardware issues including SAP, Oracle and PeopleSoft former clients via phone support.

Skills:

• Business Intelligence S/W: Business Objects, Cognos, IBM Fraud and Abuse Management System, Oracle BI Discoverer and SAS
• Databases: SQL Server 2008, DB2, MS Access, Oracle, Paradox
• EMR: Epic, Health-Pro, Quadra-Med
• Methodologies: Agile, Six Sigma, Waterfall, Scrum, BABOK
• Operating Systems: MS-DOS, Windows - 98, 2000, NT, XP, Vista, 7
• Payroll: ADP PC Payroll for Windows, ADP CSS HRizon Auto link Tables , ADP EV4, ADP, Report Smith., ADP Pay expert
• Programming: HTML, SQR, Visual Basic
• QA Tools: Test Director, Quality Center
• Spreadsheets: Excel, Lotus
• Text Editor: KEDIT 5.0
• Word Processing: Word, WordPerfect
• Statistical Software: SPSS 8.0, SYSTAT 9.0
• Others: AQT, Audit stage , AutoCAD, Aventail, Citrix, Crystal, Desktop Streaming, E-time, ERP Munis , Live Meeting, MS Project, HP Service Desk, Issue Tracker, Outlook, OpenEMR, PC Anywhere, PowerPoint, Query Analyzer, QMF, Report Writer, Right Fax, RFFlow, SAP, SAS, Scanning, SharePoint, Snagit, SQL Developer, SRSS, Toad, Visio, WebEx

Experience:

Sr. IT Business Analyst

• Participating in efforts to reverse engineer pharmacy data for the purposes of data modeling and future cost and benefit plan configurations.
• Lead document management efforts to house data resources.
• Responsible for conducting data profiling and analysis
• Liaises with SME key stakeholders to gathers requirements and works closely with product and marketing teams to identify trends and frequencies within data in order to make strategic decisions.
• Maps data from source to target in alignment with requirements
• Liaises with data architects and ETL developers to identify transformations, logic/business rules.
• QAs data through all stages of develop---development, test, staging, materialized views and reporting layers.
• Heavy usage of SAS and SQL are used as tools

Business/Data Analyst Consultant

• Leading grant analytics and reporting initiatives to support NCQA/CMS- HEDIS, UDS, and QARR clinical measures.
• Conduct detailed requirements gathering sessions for projects and authoring use cases, designing mock ups, and writing Business Requirements Documents BRD .
• Consults with key stake-holders to gain buy in and sign-offs on requirements.
• Creates functional/non-functional requirements documents as wells as Requirements Traceability Matrix RTM .
• Assists in translating BRDs to Systems Requirement Specifications SRS .
• Provide expertise to requirements projects on business processes, products, and/or supporting systems.
• Partner with BI leads to identify BI IT needs and consult on Business Intelligence solutions to complex business problems.
• Perform assessments / gap analyses to identify opportunities for new projects.
• Lead testing and implementation of new and existing systems capabilities.
• Create and implement, test plans which include test cases, test scenarios, tests identities, and test data for User Acceptance Testing UAT .
• Build and implement processes and procedures to support SDLC and new EMR and BI platform.
• Analyze, evaluate and deliver special reporting for Hospital-Medical Home Demonstration /PCMH/ACO program.
• Create dashboards, metrics and reports for upper management.
• Assist in creation of metrics and data dictionary and do cross analysis for enterprise-wide usage.
• Perform clinical data analytics on large multi-variant data sets and metadata.
• Advanced knowledge of SQL to extract data from a data warehouse.
• Mapping source to target data where necessary for complex reporting.

Confidential

Sr. IT Business Analyst Consultant

• Lead as the Consultant for complex, multifaceted IT projects defining scope, tasks and timelines to meet deliverables.
• Assisted in implementing readiness for corporate Private Exchange to support Health Insurance Exchange
• Solid understanding of benefit summaries as it relates to health care mandates.
• Conduct detailed requirements gathering sessions for projects.
• Provide expertise to requirements projects on business processes, products, and/or supporting systems.
• Partner with leads to identify IT needs and consult on solutions to complex business problems.
• Perform assessments / gap analyses to identify opportunities for new projects.
• Lead the testing and implementation of new and existing systems capabilities.
• Provide input to project plans as they pertain to requirements.
• Apply expert knowledge of systems capabilities, processes, and tools to business issues.
• Lead the analysis of current state and future state capabilities for IT, including user interfaces and delivery options and the tools necessary to support them.
• Partner with Information Architecture and Solution Architecture to create a well-rounded view of the IT capabilities and needs.
• Provide expertise to others on the techniques and tools that the Delivery Methodology recommends for requirements modeling, review, documentation and management of IT initiatives.
• Identify and exploit opportunities for enhanced systems that align with business architecture and roadmaps.

Confidential

Sr. Business Intelligence IT BA Consultant

• Lead as the Business Intelligence Consultant for complex, multifaceted BI IT projects.
• Simultaneously manage 3 work stream engagements- Property Technical and Development, Claim Legal, and Investigative Services.
• Utilize Cognos and SharePoint as web-based tools use SharePoint as primary documenting and project tracking tool and use SQL and Excel as querying, data mining, and analysis tools.
• Conduct detailed requirements gathering sessions for projects and authoring use cases, designing mock ups, and writing Business Requirements Documents BRD .
• Consults with key stake-holders to gain buy in and sign-offs on requirements.
• Creates functional/non-functional requirements documents as wells as Requirements Traceability Matrix RTM .
• Assists in translating BRDs to Systems Requirement Specifications SRS .
• Provide expertise to requirements projects on business processes, products, and/or supporting systems.
• Partner with BI leads to identify BI IT needs and consult on Business Intelligence solutions to complex business problems.
• Perform assessments / gap analyses to identify opportunities for new projects.
• Lead testing and implementation of new and existing systems capabilities.
• Create and implement, test plans which include test cases, test scenarios, tests identities, and test data for User Acceptance Testing UAT .
• Provide input to project plans as they pertain to requirements.
• Apply expert knowledge of systems capabilities, processes, and tools to business issues.
• Lead the analysis of current state and future state capabilities for BI IT, including user interfaces and delivery options and the tools necessary to support them.
• Partner with Information Architecture and Solution Architecture to create a well-rounded view of the BI IT capabilities and needs.
• Provide expertise to others on the techniques and tools that the Delivery Methodology recommends for requirements modeling, review, documentation and management of BI IT initiatives.
• Identify and exploit opportunities for enhanced systems that align with business architecture and roadmaps.