We provide IT Staff Augmentation Services!

Business Data Analyst Resume

SUMMARY

  • Senior IT professional with more than 20 years of experience in Business Consulting, Business Data Analyst and Solution Architect in HealthCare and Life Science. Experienced in business consulting to provide solution for the business need using state of art technologies like AWS, Big Data, Teradata, Informatica, Talend.
  • As lead Business Data Analyst, worked on various Pharma dataset; datasets are analyzed, mapped and customized based on the Business Analytical and Commercial group requirement.
  • Working in Data Warehousing project both on in - premise and cloud (AWS).In house data warehousing involved technologies and tools like Teradata (DB), Informatica (ETL) tool. Cloud data warehousing comprises of multiple technologies and tools like AWS Redshift, AWS EC3, AWS S3,Talend, Snowflake, HDFS, Waterline and Trifacta . Experienced in implementing datasets from CRM system (Calls and Direct Sales), Digital Market Mix, Claims, Patient, Google Analytics into on premise and cloud Data warehouse.
  • Strong experience in HealthCare domain (Managed Care business process - HMO, POS, Medicaid and Medicare), worked in major Healthcare project like HIPAA 5010, ICD 10, CMS reforms (Medicare and Medicaid). Experience in 4010 to 5010 and ICD9 to ICD 10 conversion by doing analysis and design of the system to comply with the HIPAA requirements.
  • Proficient in Business Analysis methodologies and knowledge area. Used BA knowledge area by doing Requirement Elicitation, Analysis, Solutioning, doing GAP analysis. Used various techniques like Brainstorming, Creating Data Flow Diagram, and Process Modeling etc.
  • Strong experience in Data Modeling, Data Mapping, Data Mining and Data Profiling using SQL. Expertise in Healthcare and Pharma data profiling and data proofing. Created Data Model for Pharma Dataset like IMS, Symphony and from other sources. Extensively worked on Data Profiling, Data Modeling and Data Mapping.

TECHNICAL SKILLS

  • Cloud AWS-S3,Redshift
  • DWH Tools Informatica 9.6, Talend, Redshift, Snowflake
  • Databases: Teradata, SQL, Oracle RDB, SQL Developer, SQL, SQL Assistant, SQL Workbench
  • Big Data Ecosystems: Hadoop, HDFS, Hive, Pig.
  • Languages: C, Cobol, DCL, ACMS, Java
  • Web Services Soap UI, REST, JSON
  • Project Management: MS Office Suite, MS Project, Project Dashboard, Estimation, JIRA
  • Business Modeling Tools: MS Visio, UML

PROFESSIONAL EXPERIENCE

Confidential

Business Data Analyst

Responsibilities:

  • Worked with different BU in life science; like Oncology, Women’s health Care, Radiology, Specialty, marketing mix Digital data, CRM and Salesforce datasets.
  • Analyzed the different data from discrete sources and products; like Kyleena, Xofigo, LARO,DARO, Betaseron, TKI, Adempas etc., and create source to target mapping for migration.
  • Analyze Women Health Care (WHC) sales and call data and evaluate Confidential product performance with its competitive products. Discuss and Strategize with Sales and Business team to promote the products.
  • Working with new vendor PHM - Publicis Health Media to ingest all Media related dataset (Online Video, Search, Social etc.) into Confidential DWH environment and after mastering make it available to DataMart for business consumption.
  • Worked on the Rep alignment and affiliation and create report for Outbound source like Verix and IC.
  • Design, Develop and Implement Relational and Dimensional Data Model using Erwin.
  • Maintain project status and Dashboard on JIRA.
  • Worked on Data Profiling and Data Mapping in different environment like Hadoop and Teradata .

Environment: Agile with Scrum, Teradata, SQL Assistant, JIRA, Informatica 9.6, Shell scripts, Unix . Hadoop, Amazon S3, Redshift, Talend, Waterline, Trifacta, Snowflake.

Confidential

Big Data Analyst

Responsibilities:

  • Act as a liaison between Business, Technical Architect and the Scrum team in analysis, design, configuration, testing and maintenance.
  • Analyzed Pharma Datasets and mapped with the Big Data environment. Customized Datasets as per Analytical team need.
  • Evaluated tool like Denodo, Alteryx, Trifacta to meet the Data Visualization need for Analytical team.
  • Created a Data Lake using Hadoop to analyze and process IMS and other Pharma data for the Analytics team.
  • Architected the Hadoop Cluster to have 3 layers, RAW - For landing zone, DSL - Data Mastering, ASL - Data Preparation for Business team.
  • Created Data Model for IMS Datasets. Worked on Data Profiling and Data Mapping.
  • Develop BRD, System mapping document and Solution document for the Scrum team.
  • Define and document Business Process flow using Swim lane and DFD.

Environment: Agile with Scrum, Hadoop, PIG, Impala, SQL Workbench, Hive, Data Visualization. ER Diagram, JIRA.

Confidential

Solution Architect/Business System Analyst

Responsibilities:

  • Act as a liaison between Business, Technical Architect and the Scrum team in analysis, design, configuration, testing and maintenance of Optum Integration Layer services.
  • Develop BRD, System mapping document and Solution document for the Scrum team.
  • Analyze the feasibility of, and develop requirements for OIL team; ensures the system design fits the need of Consumers.
  • Define and document Business Process flow using Swim lane and DFD.
  • Create qualitative and quantitative business case for making changes to the existing environment to improve operational efficiencies and reduce cost.

Environment: Agile with Scrum, Web Services, ELDM/ECMM, Java, Big DATA, SoapUI, REST, XML, Web services, JSON, Swagger, Hadoop, PIG, Scoop, Hive.

Confidential

Business System Analyst

Responsibilities:

  • Meet various stakeholders and gather requirement using JAD, Brainstorming and Documentation.
  • Performed GAP analysis by preparing AS - IS analysis document.
  • Understand the business requirement and transform it into Functional/ Solution Summary Document.
  • Prepared Business BRD, SSD, IET, SRI.
  • Capture functional and non-functional requirements, user stories, etc.
  • Create and Maintain Mapping documents.
  • Managed and deliver major Healthcare projects like HIPAA 5010, ICD10, P2 Fraud Detection, Claim Check, Migration of PHS Member to UP Platform, Claims Highway.

Environment: RSA Methodologies, UML, EDI X12, HL7, MS Visio, MS Office, VMS, UNIX, COBOL, SoapUI, XML, Web services.

Confidential

Technical Lead

Responsibilities:

  • Responsible for leading a project team in delivering solution to our Business.
  • Deliver new and complex high-quality solutions to clients in response to varying business requirements.
  • Responsible for managing scope, planning, tracking, change control, aspects of the project.
  • Trained other team members on various aspects of healthcare, and conducted walkthroughs for other health care teams. Have extensively worked on claims adjudication application, and gained claims and members SME (Subject Matter Expertise) certification.
  • Worked on CMS (Centre for Medicare and Medicaid services) mandate projects, ICD 10 (International Classification of Diseases), HIPAA (Health Insurance Portability and Accountability Act) transactions, revenue driven projects.

Environment: Open VMS, UNIX, COBOL, VB, Oracle RDB, Java, SoapUI, XML, VB, Web services.

Confidential

Technical Manager/Lead

Responsibilities:

  • Responsible for managing scope, planning, tracking, change control, aspects of the project.
  • Prepare technical Design document.
  • Coding and Unit testing.
  • Responsible for leading a project team in delivering solution to our Business.

Environment: Open VMS, FORTRAN, SQL DEVELOPER, CONFIGURATOR.

Hire Now