We provide IT Staff Augmentation Services!

Senior Business System / Data Analyst Resume

SUMMARY

  • Experienced Senior Business Data Professional with 11 years’ experience in managing and implementing enterprise grade Data Solutions. Expert in gathering, analyzing, and defining and leading data - modeling and process-mapping initiatives, identify trends and opportunities to inform, influence and support the decisions with excellent leadership, communication, and organization skills
  • Excellent knowledge in data extracts, manipulating, cleansing & processing data using Excel, Access, SQL & HQL (Hive Query Language).
  • Worked on both old and new technology Data Warehouse, Big Data Platform, HADOOP/HIVE, Azure, Web Applications
  • Covered many Business Intelligence (BI) tools for various projects including MicroStrategy, Microsoft Power BI, Business Objects (BO), Tableau.
  • Experience working in various profiles within ATT/Optum due to initiating and ownership skills, such as Business Analyst, Data Analyst, Systems Analyst, QA Lead, Tester, Report Developer, Program Specialist.
  • Strong experience in Business and Data Analysis, Data Mining, Data wrangling, Data Profiling, Data Lineage, Data Migration, Data Integration and Metadata Management Services

TECHNICAL SKILLS

Database: Oracle, MySQL, Microsoft SQL Server, DB2, Teradata, Hive, Microsoft Azure SQL Database

Database Tools: Oracle SQL developer, PL/SQL, Visual Studio code, SQL server Management Studio, Teradata, Aqua Data Studio, Zeppelin, Redshift, Azure Synapse, Azure Databricks

Languages: SQL, HQL, Python (NumPy, SciPy, Matplotlib, Pandas, Seaborn)

BI Tools: Tableau, MicroStrategy, Microsoft Power BI, Business Objects (BO)Big Data Hadoop, Spark

Cloud: Microsoft Azure, AWS

PROFESSIONAL EXPERIENCE

Confidential

Senior Business System / Data Analyst

Responsibilities:

  • Data Compilation Project
  • Created Excel based Data Dictionaries which includes information from table structure (DDL) level to the details up to when and which DB Views the column is exposed to.
  • Meta Data (Data above the Data), Source data info (column definitions etc) > dw info > transformations > which views data is going to > valid values
  • Created BA Runbooks for the assigned subject areas which includes information from what that subject area is, the data refresh frequency, data load process steps, things to remember while working on the subject area, links or SharePoint information related to subject area, all in one document from perspective to help bring someone on board who doesn’t know anything about the subject area.
  • Facilitated the solution design with the architecture & development team by authoring the functional design document for end-to-end ETL process, which served as an input for the development team’s technical design document.
  • Gathered Functional requirements for ongoing Application Level implementation and Enterprise wide Data effort.
  • Created mapping (Source to Target Mapping) documents to support each subject area
  • Created Process Flow Diagram for data lineage information which tells users from where the data is flowing and what transformations are done during the process. (Some data sources were all the way from Gateway to the DW). It also included the data drops from point A to point B.
  • Extracted data from different data sources; integrated, aggregated and implemented various calculation measures to create financial data analysis in Big Data HIVE environment (Used Platform as front end)
  • Supported large scale projects where the work starts from vision and goes to Data Discovery and then followed by the rest of the project development.
  • Negotiated project deliverables, consistency met deadlines while managing multiple priorities and maintaining excellent internal and external customer service relationships.
  • Assisting in Design, develop and maintain an automated test strategy that fully exercises end-user workflows and provides a framework for ongoing endurance/load tests
  • MMM (Manage Member Movement) application is built to provide a web interface for business users to track and manage member movement in case of a provider organization moving out of service from Mobile & wireline network. This application was developed to provide business capability to track any provider termination request as well as manage the member movement from a terming provider to a new provider organization.

Confidential

Senior Business Systems Analyst

Responsibilities:

  • Streamlining business requirements from cross-functional stakeholders in a matrix environment
  • Doing so by setting up pre-defined agenda meetings, followed by meeting minutes, action items and follow ups
  • Creating and maintaining Data Models for each domain area I owned; Claims (Encounter, Charges, and Payments), Pharmacy, Non-Members Claims (Pharmacy & Medical), Unbilled, Membership, Clinical
  • Gathering and documenting reporting requirement for building Dashboards and ad-hoc Business Intelligence Reports needed to support organization’s LOB progresses and trends using Tableau
  • Performing reconciliation of the claim payments against claim charges
  • Implemented Historical data extracts and designed incremental data loads
  • Deep diving into data analysis on cross-regional extracts and creation of their data integration design documentation
  • Presented complex data findings to cross-functional program management and to senior leadership
  • While doing this, lot of complexities were seen to integrate cross regional data, to which I defined/developed a process to execute corrective actions and implement quality controls before integration design begin
  • Data profiling activities using tools, ORACLE SQL Developer, PL-SQL, Ab-Initio, SAS, Todd etc.
  • Built hashing logic for PHI elements.
  • Recommending design changes for process improvement and better-quality product
  • Also performed UAT on VIEW creations in HIVE by Data Integration Team which I was part of before.
  • Created UAT Test Plan, Test Cases, Test Execution Summary and Report to update IT team
  • Worked closely with key stakeholders to understand the vision and transformed the same into functional requirements
  • Managed multiple domains Confidential the same time to refine requirements and created necessary project artifacts to support new team members
  • Finalized data extraction rules for Claims, Pharmacy, Non-Members Claims (Pharmacy & Medical), Unbilled, Membership
  • Worked closely with Source system SMEs to discover data available within KAISER for different regions
  • While doing this, Created and managed procedural documentation, process flow diagrams, workflow analyses
  • Negotiated project deliverables, consistency met deadlines while managing multiple priorities and maintaining excellent internal and external customer service relationships.
  • Work with Product and Development teams to develop and execute test plans
  • Assisting in Design, develop and maintain an automated test strategy that fully exercises end-user workflows and provides a framework for ongoing endurance/load tests

Business Data Analyst

Confidential

Responsibilities:

  • Created documentation: Functional Requirement Document, Source to Target Mapping, Release Notes etc.
  • Performed analysis of upstream changes to make sure all impacted upstream changes are considered before next data loads and communicated to development teams
  • Studied elements of electronic health system and related application changes.
  • Evaluated and documented clinical workflows and requirements for EMR database development
  • Completed full conversion from two EMR Databases into one Database
  • Maintained and updated data dictionary per monthly/quarterly changes
  • Improved certain processes in place by suggesting automation
  • End to end implementation of 3 new views supporting CMS Research View project
  • Worked closely with compliance to make sure none of the element exposed to data users that could allow linkage to an individual.
  • Managed delivery of Healthcare Effectiveness Data & Information Set (HEDIS) measures for the National Committee Quality Assurance (NCQA) submission for national ranking of health plan organizations.
  • Worked with AWS Cloud platform and its features, which included EC2, S3 and few more

Confidential

Sr Business Data Consultant

Responsibilities:

  • Data profiling on MDW (Membership Data Warehouse) and EDW (Enterprise Data Warehouse)
  • Data Process Flow document using Visio
  • Data Metrics for subject areas, data patterns, data drop counts trends etc

Hire Now