SUMMARY

• 8+ years of Industry experience as a Business Data Analyst wif 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 noledge of Pharmaceutical, Life Science and Healthcare Industry.
• Experienced in data analysis, data modeling, Conceptual logical modeling and physical database design for Online Transactional processing (OLTP) & Online Analytical Processing (OLAP) systems.
• Experienced in Good Manufacturing Practices (GMP) making sure quality, safety and effectiveness designed and built into teh products.
• Experienced in Facets by improving critical business processes and automated manual tasks by streamlining teh delivery of work
• Good business experience in management responsibilities & ability to plan and manage complex projects by prioritizing teh project plans and timelines as demanded.
• Experienced in performing gap analysis by identifying existing technologies, documenting teh enhancements to meet teh 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 wif teh halp of teams to achieve deadlines timely and proficiently on claim management system.
• Experienced in requirement gathering and analysis, planning, controlling, technical writing, SDLC (Systems Development Life Cycle), Change management, training, requirement analysis, SWOT Analysis, recruiting.
• Understanding of teh Cloud platforms, Business Process Modeling, Process flow diagrams.
• Forecasting workforce requirements, establishing/redesigning organizations, and influencing/leading teh work of individuals and groups in change initiatives
• Development JAD sessions wif clients and referring to accessible documentation and procedure.
• Exposed to Medicare and Medicaid domains of teh healthcare systems and industry for inpatients, outpatients, Reimbursement Methodology and Medicaid Management Information System MMIS.
• Knowledge of data 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 Analysis, Risk Identification, Risk Assessment, Risks Analyses, and Risk management.
• Researched data issues and identify teh 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 wif noledge in regulatory compliance, GMP, Quality.

TECHNICAL SKILLS

Methodologies: Agile, Waterfall, RUP, Hybrid

Test Management tools: JIRA, ALM, Soap UI

Programming Languages: HTML, JAVA, C++, ASP.NET

Databases: MS SQL, DB2, Oracle, SAP HANA

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

Office Suite: Microsoft Office (Word, Excel, Visio, SharePoint, Power Point, Project, Outlook)

Data Modeling Tools & Others: Erwin Data Modeler, Power Designer and ER/Studio, SharePoint, Power BI, Tableau, Snowflake

PROFESSIONAL EXPERIENCE

Confidential - Washington, DC

Business Analyst

Responsibilities:

• Analyzed teh problem domain, specified features, established baseline architecture, developed teh Project plan, and risk analysis.
• Worked on creating wireframes for teh front-end application using balsamic cloud.
• Consulting wif other departments on teh management of content and design of pages.
• Complying wif teh consistent development and maintenance of teh healthcare industry databases, health care insurance and health care industry related aspects wif 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
• Trained on Snowflake to halp built visualizations and reports in tableau using Snowflake data
• Worked under teh Agile project framework to define scope of reporting required by key business stakeholders to support ECC Account-based COPA implementation and to expand teh current native HANA reporting capabilities
• Worked closely wif stakeholders to develop SAP HANA tables, procedures to extract from SAP ECC, transform and load in SAP HANA
• Liaison and coordinated in resolving HIPAA/EDI mapping issues arising from teh third-party systems.
• After successful development and testing of teh product, participated in product release and deployment to End-User.
• Created reports from various Info providers using BI tools and present to stakeholders as needed
• Worked closely wif teh deployment team for roll out teh 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 teh 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 workflow analysis.
• Critically evaluate information gatheird 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 teh underlying true needs
• Participated in Business Modeling by documenting teh needs of teh Business.
• Designed a new matrix covering all teh conceptual parameters of teh new system.
• Extensive noledge on relevant cross-industry data and messaging standard organizations and HIPPA/EDI industry-specific organizations to maintain a point of view as to teh 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 wif writing test cases, unit and systems integration test plans in Test Director.
• Conducted User Acceptance Testing (UAT).
• Documentation of Training Material for teh implementation and teh maintenance of teh application.
• Research and Implementation of Web Portal for provider enrollment.
• Consulting wif other departments on teh 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 teh system from different perspectives using MS Visio.
• Identified and analyzed trends in EDI failures, collaborating wif 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 dat include modeling of all teh activities of teh business from teh conceptual to procedural level.

Confidential - Jersey City, NJ

Business Analyst/ Data analyst

Responsibilities:

• Participated in teh development and review of RFPs for teh Confidential ’s/Clients new product developments and system implementations.
• Led teh development of a B2C SaaS product for Chain Retail stores.
• Worked wif teh Program Manager to develop teh product roadmap.
• Determined MVP and planned sprints on teh product roadmap.
• Creating data profiling and understanding data related opportunities.
• Worked wif 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 teh product lifecycle from requirements to prioritization to product release.
• Reported status of teh features and stories to Program Management, periodically.
• Conducted demos and training sessions wif 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 teh product using In Vision.
• Advocated for teh end user by influencing decisions to ensure product features are in alignment wif user needs and expectations.
• Prioritized teh product backlog to maximize business value delivered while maintaining a sustainable pace for teh team.
• Continuously collected user feedback and collaborated wif teh UI/UX team to enhance user experience.
• Used Jira to manage teh product backlog.
• Prioritized dependencies by working wif other Product Owners and Project Managers.
• Defined KPIs/metrics and measured performance/adoption of features using analytics & user surveys.
• Collaborated wif teh CTO, Program Manager, and teh Architect to ensure teh product strategy fit wifin teh overall vision of teh program
• Experienced in SAP HANA data modeling using Attribute, analytic and Calculation views
• 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 wif teh 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 teh development of Statement of Work (SOW), Trading Partner Agreements (TPAs), Service Level Agreements (SLAs), Memoranda of Understanding (MOUs), etc. wif vendors and other agencies.
• Collaborated wif teh Test Manager to develop teh test plan and End-to-End (E2E) test cases.

Confidential - Indianapolis

Business Analyst/ Data Analyst- Facets

Responsibilities:

• Business analyst for teh health care (Health science) organizations to make sure all teh 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 suite for teh USFDA approval wif Facets configuration & used Facets for claim processing, billing purposes
• Experienced wif 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 wif Facets configuration wif Compliance Builder.
• Documented requirements and wireframes utilizing HTML, CSS, and JavaScript, JSON, jQuery, AJAX and ASP.NET framework.
• Worked on all activities related to teh development, implementation, administration and support ofETLprocesses by performing data mapping and data modeling wif 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) wif Lab ware.
• 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 wif data mapping and data modeling (MDM).
• Experienced wif 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 teh resource planning and test scripts.
• Created Data mappings and done gap analysis to Identify and quantify data issues wifin teh organization and assist in teh development plans to resolve Claims Encounters data issues.
• Involved in EDI Transactions utilizing MFT file protocol to integrate wif AWS.
• Worked wif teh 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 wif 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 teh department of Pharmacy in 16 Confidential groups of pharmacies. Worked wif User Experience Architect designing and developing a newly introduced ecommerce experience wif Facets. Produced interactive prototypes displaying conceptual functionality for desktop, tablet and mobile (responsive) designs in an agile environment.
• Gatheird requirement for teh Ecommerce website implementation and performed solution analysis along wif Facets production values.
• Performed teh 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 wif 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 wif customers and established new corporate business. Fast paced customer service and sales driven work environment wif salesforce.
• Experienced wif Salesforce Admin and SFDC Cloud technology and documented technical specifications along wif 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 teh 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 teh content of an interface. me work on UX teams where me focus on making functional design elegant, visually compelling, and easy to perceive teh intended interactions.
• Assisted and led in teh 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 dat halp iterate and evolve design concepts.
• Delivered production-ready design assets and developed comprehensive Visual Design Standards and Guidelines.
• Worked closely wif Engineers and Developers during teh product build to ensure design quality and integrity.

Confidential - Lyndhurst, NJ

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 wif business to develop resolutions to those issues.
• Experienced working in teh 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 noledge of RDBMS, Web and SQL along wif 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 teh project by maintaining a master hub for improving teh 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 teh IT team working on teh issue, and teh issue owner(s) on teh 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 wif business users and client manager.
• Involved in Prioritization of teh requirements from teh 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 teh Shelf packages (COTS)
• Understand teh As Is system and develop teh To Be system concept and also prepare teh 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 Confidential, HL7, Agile/Scrum, Rational Clear Case, Windows NT, PL/SQL, UNIX, Oracle, LIMS Basic, OOAD, Windows

Confidential - Iowa City, IA

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 teh packages and stored procedures.
• Participated inUAT sessionsto educate teh business users about teh 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 teh 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 wifdata cleansing/scrubbing and validation.
• Worked wifT-SQLto create Tables, Views, Triggers and Stored Procedures.
• Effectively useddata blendingfeature intableau.
• Extensively worked wif MicrosoftBusiness Intelligence Servicessuch asSSISandSSRS.
• Involved indata mining, transformationandloadingfrom teh source systems to teh target system.
• Generated multiple enterprise reports likeSSRSandCrystal reports.