PROFESSIONAL SUMMARY:

• 8+ years of Industry experience as a Business/Data Analyst with solid understanding of Business Requirements Gathering, Business Intelligence, Data warehousing, Data Mapping, Data Validation, Data Integrity, Master Data Management (MDM), Reporting, and Data Modeling.
• Strong knowledge of Pharmaceutical, Life Science and Health Care Industry.
• Experienced in data analysis, data modeling, Conceptual logical modeling and physical database design for Online Transactional processing (OLTP) and Online Analytical Processing (OLAP) systems.
• Good Understanding of Coordination of Benefits and Explanation of Benefits.
• Experience in developing project plan and estimating project timeline.
• Excellent working knowledge in Project Life Cycle and clear understanding of Project Management.
• Experienced in performing Gap analysis by identifying existing technologies, documenting the enhancements to meet the end - state requirements.
• Excellent business communication and presentation skills. Adapt at creating, editing, and coordinating extensive communication networks, to keep executive staff and team members apprised of goals, project status, and resolving issues and conflicts.
• Conducted successful projects with the help of teams to achieve deadlines timely and proficiently AND worked on claim management system.
• Experienced in Requirement Gathering, Project Planning, Controlling, Technical Writing, SDLC (Systems Development Life Cycle), Change management,, requirement analysis, SWOT Analysis, Recruiting.
• Understanding of the cloud platforms, Business Process Modeling, Process flow diagrams.
• Forecasting workforce requirements, establishing/redesigning organizations, and influencing/leading the work of individuals and groups in change initiatives
• DevelopmentJAD sessions with clients and referring to accessible documentation and procedure.
• Exposed to Medicare and Medicaid domains of the healthcare systems and industry for inpatients, outpatients, Reimbursement Methodology and Medicaid Management Information System MMIS.
• Knowledge ofdata migration tools.
• Experienced in data analysis, data modeling, Conceptual logical modeling and physical database design for Online Transactional processing (OLTP) and Online Analytical Processing (OLAP) systems.
• Extensive experience in conducting Market Research, Feasibility Studies, Data Analysis, Data Mapping, Data Profiling, Gap Analyses, Risk Identification, Risk Assessment, Risks Analyses, and Risk management.
• Researched data issues and identify the root cause in source systems, data warehouse and data marts using various data analysis techniques, data profiling and data mining activities.
• Expertise in broad range of technologies, including business process tools such as Microsoft Project, MS Excel, MS Access, MS Visio, technical assessment tools, Data Warehousing concepts and web design and development.
• Expertise in Business Process Modeling, Business Process Re-design and in designing Process Architecture.
• Experienced and professional employee with knowledge in regulatory compliance, GMP, Quality.

TECHNICAL SKILLS:

Methodologies: Agile, Water Fall, RUP, Hybrid

Test management tools: JIRA, ALM, SoapUI

Programming Languages: HTML, JAVA, C++

Databases: MS SQL, DB2, Oracle

Operating Systems: Windows XP, 7, 8, 10, Linux

Office Suite/Data Modeling Tools: Microsoft Office (Word, Excel, Visio, SharePoint, Power Point, Project, Outlook) Erwin Data Modeler, Power Designer and ER/Studio.

PROFESSIONAL EXPERIENCE:

Confidential

Business Analyst

Responsibilities:

• Analyzed the problem domain, specified features, established baseline architecture, developed the Project plan, and risk analysis.
• Worked on creating wireframes for the front-end application using balsamic cloud.
• Consulting with other departments on the management of content and design of pages.
• Complying with the consistent development and maintenance of the healthcare industry databases, health care insurance and health care industry related aspects with adherence to HIPAA compliances.
• Wrote SQL scripts for reporting and analysis purpose
• Provide reporting to management via excel reports of workload and work completion on a daily, weekly, and monthly bases
• Liaison and coordinated in resolving HIPAA/EDI mapping issues arising from the third-party systems.
• After successful development and testing of the product, participated in product release and deployment to End-User.
• Worked closely with the deployment team for roll out the project - external releases, packaging, distributing, installing, user assistance, beta testing, migration of software and data.
• Conducted User Acceptance Testing (UAT).
• Requirement gathering, prepared project plan and execution strategy for the requirement gathering stage.
• Elicit requirements using interviews, document analysis, requirements workshops, surveys, site visits, business process descriptions, use cases, scenarios, business analysis, and task and work flow analysis.
• Critically evaluate information gathered from multiple sources, reconcile conflicts, decompose high-level information into details, abstract up from low-level information to a general understanding, and distinguish user requests from the underlying true needs
• Participated in Business Modeling by documenting the needs of the Business.
• Designed a new matrix covering all the conceptual parameters of the new system.
• Extensive knowledge on relevant cross-industry data and messaging standard organizations and HIPPA/EDI industry-specific organizations to maintain a point of view as to the current applicability and risks associated in implementing standards or new technologies to client environment.
• Created Project management plans for managing on-time delivery using MS Project along with writing test cases, unit and systems integration test plans in Test Director.
• Conducted User Acceptance Testing (UAT).
• Documentation of Material for the implementation and the maintenance of the application.
• Research and Implementation of Web Portal for provider enrollment.
• Consulting with other departments on the management of content and design of pages.
• Developed applications to track risk exposure.
• Created Process flow diagrams, use case diagrams and sequence diagrams to view the system from different perspectives using MS Visio.
• Identified and analyzed trends in EDI failures, collaborating with new EDI partners to develop innovative solutions.
• Got involved in designing future state processes for HIPAA 5010 transaction processing EDI's 837,835, 270, and 271.
• Prepared Business Process Models that include modeling of all the activities of the business from the conceptual to procedural level.

Confidential - Jersey City, NJ

Business Analyst/ Data analyst

Responsibilities:

• Participated in the development and review of RFPs for the HCL’s/Clients new product developments and system implementations.
• Led the development of a B2C SaaS product for Chain Retail stores.
• Worked with the Program Manager to develop the product roadmap.
• Determined MVP and planned sprints on the product roadmap.
• Creating data profiling and understanding data related opportunities.
• Worked with business units and other stakeholders to gather, analyze and document requirements using techniques like interviews, work sessions, brainstorming, and storyboarding.
• Translated requirements into appropriate user stories, and ensured stories met acceptance criteria.
• Participated in all Scrum ceremonies including sprint planning, daily stand-ups, sprint review, and sprint retrospective.
• Managed the product lifecycle from requirements to prioritization to product release.
• Reported status of the features and stories to Program Management, periodically.
• Conducted demos and sessions with internal and external groups.
• Ensured proper product documentation including user guides, use cases, implementation guides, and release notes.
• Designed and conducted product discovery and optimization experiments using quantitative research techniques like A/B tests.
• Developed prototypes of the product using InVision.
• Advocated for the end user by influencing decisions to ensure product features are in alignment with user needs and expectations.
• Prioritized the product backlog to maximize business value delivered while maintaining a sustainable pace for the team.
• Continuously collected user feedback and collaborated with the UI/UX team to enhance user experience.
• Used Jira to manage the product backlog.
• Prioritized dependencies by working with other Product Owners and Project Managers.
• Defined KPIs/metrics and measured performance/adoption of features using analytics & user surveys.
• Collaborated with the CTO, Program Manager, and the Architect to ensure the product strategy fit within the overall vision of the program
• Led integration efforts between several internal and external applications: implementing real-time (APIs) and batch (HIPAA EDI transactions and flat files) processing.
• Oversaw integration of web/mobile apps with the commonwealth’s Single Sign-On (SSO) solution, for user authentication and authorization.
• Implemented various Cloud-based solutions using Azure.
• Queried and reported data using tools like SQL, Power BI, and Excel.
• Participated in the development of Statement of Work (SOW), Trading Partner Agreements (TPAs), Service Level Agreements (SLAs), Memoranda of Understanding (MOUs), etc. with vendors and other agencies.
• Collaborated with the Test Manager to develop the test plan and End-to-End (E2E) test cases.

Confidential

Business Analyst/ Data Analyst- Facets

Responsibilities:

• Business analyst for the health care (Health science) organizations to make sure all the Clinical trial organizations requirements are taken care before submitting to USFDA approval by performing data analysis.
• Performed requirement analysis, impact analysis and documented Business Requirements Document (BRD) and Functional Specification Document (FSD) using Microsoft Visio and Microsoft suits for the USFDA approval with Facets configuration.
• Experienced with ERP product implementation support- Project Management and/or System Administration.
• Prioritized deliverables, identified gaps, tracked defects, defined system requirements, created artifacts for testing and development with Facets configuration with Compliance Builder.
• Worked on all activities related to the development, implementation, administration and support ofETLprocesses by performing data mapping and data modeling with master data management (MDM) and quality management.
• Worked on data cleansing, data Extraction, Transformation and Loading design, development, source to target mappings, data warehouse transformations, performance tuning, testing and documentation (Facets &Informatica) with Labware.
• Designed, developed and supported ETL processes for data staging, extraction, transformation, and loading of fact tables, data cleansing, automating ETL and master data management (MDM) processes
• Collected, organized and generated new documentation for ETL and MDM projects including technical specifications, ETL test scripts, change control, implementation checklists, and data flow diagrams with data mapping and data modeling (MDM).
• Experienced with Medicare and Medicaid policies and documented policy requirements for Clinical trials.
• Audit Medicare cost reports for accuracy. Analyze and determine applicability of financial data and provided
• Recommendations.
• Provide a full range of financial, compliance, and operational audits related to Medicare Funds.
• Assist in determining funds due from fraudulently distributed Medicare reimbursement monies.
• Worked on SAP ERPS for the resource planning and test scripts.
• Created Data mappings and done gap analysis to Identify and quantify data issues within the organization and assist in the development plans to resolve Claims Encounters data issues.
• Involved in EDI Transactions utilizing MFT file protocol to integrate with AWS.
• Worked with the following module suites: Oracle Financials (GL, AP, AR), Discrete Manufacturing (INV, BOM, WIP, Cost, PO), Supply Chain (Order to Cash, Procure to Pay, WMS), Advanced Planning (ASCP, DP, MRP), CRM, Human Resources.
• Developed test scenarios and implemented test plan, providing key input in working with users in defining project and system requirements.
• Great Knowledge onOracleCloud (Fusion)HCM in all major FusionHCMOfferings: Workforce Deployment (Global HR, Payroll, Workforce, Compensation, Security and Workflows Time and Labor (OTL), Absence Management) and Workforce Development (Talent Review, Performance, Goal and Succession managements). Compensation Management (benefits, Incentive and Total Compensation) in version R8 to R12 andOracleEBS HRMS (E-Business Services) consultant.

Confidential

Business Analyst

Responsibilities:

• Senior Business Analyst for the department of Pharmacy in 16 Hancock groups of pharmacies. Worked with User Experience Architect designing and developing a newly introduced ecommerce experience with Facets. Produced interactive prototypes displaying conceptual functionality for desktop, tablet and mobile (responsive) designs in an agile environment.
• Gathered requirement for the Ecommerce website implementation and performed solution analysis along with Facets production values.
• Performed the requirement analysis, impact analysis and documented Business Requirements Document (BRD) and Functional Specification Document (FSD) using rational toolset Requisite Pro for Mobile website development including responsive design using Bootstrap and Zurb Foundation.
• Experienced in writing use cases for UI teams’ C#, Java, Drupal, SOAP UI and JSON along with User experience design (User stories, Blueprints, Visual design and user requirements).
• Prioritized deliverables, identified gaps, tracked defects, defined software requirements, created artifacts for testing and development.
• Interacted with customers and established new corporate business. Fast paced customer service and sales driven work environment with salesforce.
• Experienced with Salesforce Admin and SFDC Cloud technology and documented technical specifications along with requirements for SFDC (Salesforce.com) integration.
• Conducted clinical database adverse event review to ensure coded terms are clear, appropriate and complete according to established coding guidelines and conventions, using global medical data dictionaries.
• Documented requirements and wireframes for the website creation utilizing HTML, CSS, and JavaScript, JSON, jQuery, AJAX and ASP.NET framework.
• Executed SQL queries to perform Backend Testing for Data Validation
• Emphasized cleanliness, readability, and objectivity in the content of an interface. I work on UX teams where I focus on making functional design elegant, visually compelling, and easy to perceive the intended interactions.
• Assisted and led in the creation of inspiring mood boards and style frames.
• Translated mood boards into tangible visual design UI elements, and design comps.
• Created and produced visual assets for interactive prototypes that help iterate and evolve design concepts.
• Delivered production-ready design assets and developed comprehensive Visual Design Standards and Guidelines.
• Worked closely with Engineers and Developers during the product build to ensure design quality and integrity.

Confidential

Business/Data Analyst

Responsibilities:

• Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and SQL Server.
• Performed in depth data analysis identifying data issues in legacy system and worked with business to develop resolutions to those issues.
• Experienced working in the area data management including Data Modeling, Metadata, Data Analysis, Data Integrity, Data Mapping and Data Dictionaries.
• Used Data Integrator to load data from various sources such as MS Access, MS Excel, CSV files to MS SQL Server.
• Extensive knowledge of RDBMS, Web and SQL along with MS SQL administration, SQL Enterprise Manager, Data analysis and reporting.
• Experienced in utilizing statistical tools like MS office suite, MS projects, MS Visio and requirement management tools.
• Implemented Master Data Management MDM for all entities in the project by maintaining a master hub for improving the data quality by following various data governance techniques and data dictionary standards.
• Extensively used Tableau features like Data blending, Extracts, Parameters, Filters, Calculations, Context Filters, Hierarchies, Actions, and Maps etc.
• Reviewed IMS data for new market entrants and changes in competitive landscapes.
• Acted as a Technology Alignment Group lead for IMS issues assigned and worked in liaison between the IT team working on the issue, and the issue owner(s) on the business side.
• Commercial batch size estimation based on IMS and market share.
• Created high quality functional requirement specifications and supporting documents for business systems.
• Supported and customized First Docs R&D application, CMC and Regulatory submission.
• Responsible for assisting clients in resolving various network and systems management problems using ITIL.
• Extensive worked in creating Functional Specifications, UI specifications and UI prototypes.
• Design, develop, test, debug and implement new functionalities in SQL*LIMS by coordinating with business users and client manager.
• Involved in Prioritization of the requirements from the Product Backlog maintained in JIRA.
• Developed project document templates based on SDLC methodology.
• Ensured quality, safety and environmental standards and procedure compliance, and coordinated monthly OSHA Environmental, Health and Safety meetings
• Experienced in evaluation, customization, and implementation of various Commercial Off the Shelf packages (COTS)
• Understand the As Is system and develop the To Be system concept and also prepare the System Process Maps.
• Generating Requirement Traceability Matrix (RTM) to ensure requirement coverage.
• Worked in an AGILE delivery model involving multiple scrum teams and daily stand-up meetings
• Environment:Java, UML, Requisite Pro, Clear Case, Clear Quest, HL7, Agile/Scrum, Rational Clear Case, Windows NT, PL/SQL, UNIX, Oracle, LIMS Basic, OOAD, Windows

Confidential

Data Analyst

Responsibilities:

• Performeddata analysisanddata profilingusingcomplex SQLon various sources systems and answered complex business questions by providing data to business users.
• DevelopedSQLandPL/ SQL scriptsfor migration of data between databases.
• Extensively usedETL methodologyfor supporting data extraction, transformations and loading processing, in acomplex EDWusingInformatica.
• CreatedSSIS packageto extract data fromOLTPtoOLAPand scheduled jobs to call the packages and stored procedures.
• Participated inUAT sessionsto educate the business users about the reports, dashboards and theBI System.
• Involved in Analysis of functional and non-functional categorized data elements for data profiling and mapping from source to target data environment.
• Used the automated process for uploading data in production tables by using UNIX.
• Performeddata reconciliationbetween integrated systems.
• Documented data dictionaries and business requirements for key workflows and process points
• PerformedBackend Testingby executingSQL queries.
• Involved withdata cleansing/scrubbing and validation.
• Worked withT-SQLto create Tables, Views, Triggers and Stored Procedures.
• Effectively useddata blendingfeature intableau.
• Extensively worked with MicrosoftBusiness Intelligence Servicessuch asSSISandSSRS.
• Involved indata mining, transformationandloadingfrom the source systems to the target system.
• Generated multiple enterprise reports likeSSRSandCrystal reports.