Senior Data Analyst with 8+ Years Experience

David Jampana Abraham Luther

Phone: +1-484-***-****

Email: **************@*****.***

Senior Data Analyst

PROFESSIONAL SUMMARY:

Senior Data Analyst with 8+ years of experience in transforming complex datasets into actionable business insights across financial, retail, and healthcare domains.

Proven expertise in data visualization, statistical analysis, and predictive modeling, supporting data-driven decision-making for executive and operational teams.

Skilled in building interactive dashboards and reports using Power BI, Tableau, and Excel, improving visibility into KPIs and performance metrics.

Strong proficiency in SQL, Python, and R for data extraction, transformation, automation, and advanced analytics.

Having good experience in requirement analysis and design the requirement definition document.

Having good experience in design the data models of various data warehouse Projects.

Adept at designing and maintaining ETL processes, collaborating with data engineers to streamline data pipelines and enhance reporting efficiency.

Expertise in data modeling, cleansing, and governance, ensuring compliance with corporate and regulatory standards (SOX, GDPR, HIPAA).

Experience in developing Dashboard Report, Parameterized Reports, Linked reports, Sub reports by Region, Year, Quarter, Month and Week.

Experienced in enhancing data warehouse with extensive knowledge of Data mapping, Data Modeling, Snowflake, Star Schemas and ETL jobs.

Maintain existing Python Scripts that are being used to generate Glossary Assets and linkage Files that provide a relation between Physical & Glossary Assets.

Designed different types of reports like drill down, drill through, sub reports, parameterized reports and cascading reports in Power BI.

Experience in configuration of report server and report manager scheduling, Subscriptions and give permissions to different level of users in SQL Server Reporting Services (SSRS).

Working Knowledge in Cloud Azure Portal, Azure Data Lake store, Azure Data factories and Azure SQL databases.

Having good knowledge on Data warehousing concepts; Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.

Experience on creation and scheduling of SQL Server Agent jobs.

Working experience on Teradata and expert in creating Power pivots, Power views and SSRS reports using tabular model (DAX), Cubes (MDX) and SQL queries.

Used DAX (Data Analysis Expressions) functions for the creation of calculations and measures in the Tabular Models.

Worked closely with management, applications development Team, and users on database solutions to resolve business problems.

Skilled in automating manual workflows using Python, Power Query, and Alteryx, reducing reporting time and human error.

Strong communicator with a talent for visual storytelling, translating technical findings into business recommendations for senior leadership.

Experienced in data-driven project leadership, mentoring junior analysts, and implementing best practices for analytics and reporting frameworks.

TECHNICAL SKILLS:

Programming languages

Python, SAS, R programming, SharePoint, PL/SQL, T-SQL

Data Science skills

Machine Learning

Query Languages

SQL

Reporting Tools

SSRS, Crystal Reports, Report Studio

Visualization tools

Tableau, Power BI

Operating Systems

Windows, Linux

Cloud Technologies

Microsoft Azure, Amazon Web Services (AWS), Salesforce.

Design Tools

Erwin, MS Visio, Rational Rose

Other Tools

Putty, Oxygen, Postman, SharePoint, Git, Jira, Bit Bucket, Confluence

PROFESSIONAL EXPERIENCE:

Costco Issaquah, Washington Nov 2023 - Present

Senior Data Analyst

Responsibilities:

Designed and developed interactive dashboards and reports using Power BI and Tableau, delivering key insights to executive leadership and business stakeholders.

Conducted data profiling, cleansing, and validation to ensure accuracy, integrity, and consistency across enterprise datasets.

Collaborated with cross-functional teams — including IT, finance, and merchandising — to define data requirements and KPIs for performance tracking.

Utilized SQL, Python, and Excel to extract, transform, and analyze structured and semi-structured data from multiple data sources.

Performed sales trend analysis, pricing optimization, and customer segmentation to identify growth opportunities and improve profitability.

Partnered with data engineering teams to enhance data pipelines, implement ETL processes, and improve data availability within Snowflake and Azure Synapse environments.

Applied statistical modeling and forecasting techniques to predict inventory demand, reduce stockouts, and optimize warehouse distribution efficiency.

Architected, built, and maintained scalable ETL pipelines to ingest and integrate data from legacy systems into the new EHR environment, ensuring near real-time synchronization.

Developed and optimized SQL Server stored procedures, views, functions, and triggers to transform, cleanse, and aggregate complex clinical and operational datasets.

Wrote high-performance SQL queries and scripts for bulk data extraction, cleansing, reporting, and adhoc analysis across large data volumes.

Gathered, analysed, and documented business requirements from stakeholders to translate into Power BI dashboards, reports, and visualizations.

Created interactive reports and dashboards (drilldowns, drillthrough, filters, custom visuals, bookmarks, tooltips) that deliver actionable insights.

Built, deployed, and maintained SSIS packages and SSRS reports using Microsoft Visual Studio and Report Builder to support operational dashboards and analytic reporting.

Automated routine data workflows and system integrations using PowerShell and Unix/Linux shell scripts, reducing manual effort and streamlining interoperability.

Managed version control, branching, and collaboration using GitHub for ETL and database code, enforcing coding standards and peer reviews.

Supported extraction and reporting from Meditech data repositories using built-in Report Designer tools and custom SQL-based solutions.

Collaborated with cross-functional stakeholders—including clinical, operations, analytics, and IT teams—to validate data accuracy, resolve discrepancies, and ensure on-time delivery.

Environment:MS SQL Server 2017/2019 · SQL Server Integration Services (SSIS),· PowerBI, SQL Server Reporting Services (SSRS) · GitHub · ConnectETL · Meditech

Cigna Bloomfield, Connecticut Dec 2021 – Oct 2023

Senior Data Analyst

Responsibilities:

Develop, design, and analyze data architecture and data warehouses using SQL, SSIS, SSRS and Power BI.

Optimizing existing data models including changing load scripts to load data in an optimized way to achieve a reduction of loading time, simplifying complex expressions in the front-end, improving layout structure.

Led ingestion and transformation of data via ConnectETL from multiple legacy health systems into modern relational and analytical targets.

Exercised strong analytical thinking, time prioritization, and clear communication in a fast-paced, compliance-driven healthcare environment.

Working with the business to document and develop KPIs for the calculations in the Power BI and SSRS apps.

Developed Power BI reports and dashboards from multiple data sources using data blending.

Extensive experience in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User-Defined Functions.

Experience in using all kinds of Constraints, managing Indexes, Locks, troubleshooting deadlocks, and handling the Isolation Levels.

Created and maintained Database Objects (Tables, Stored procedures, functions) in SQL.

Identified and worked with multi-value parameters for parameterized reports in SSRS and Power BI.

Scheduled, maintained, and supported the distribution and access to reports at the Server level.

Analyze, select, acquire, support, and maintain standardized clinical code sets, clinical data representation systems, clinical ontologies and healthcare data related.

Configured and maintained Report Manager and Report Server for Power BI Gateway and SSRS.

Involved in creating the external and internal tables in Azure SQL Datawarehouse and created stored procedures to move the data from external to internal tables.

Created datasets, linked services, Azure key vault services in Azure Data Factory.

Timely marking up new codes in vocabularies so that the Personal Health Record (PHR) is updated with new codes.

Create Collections and Bundles of codes for well-organized data, which is used by wellness products.

Maintain expertise in legally mandated and de facto standards for transfer of health-related information and participate in assuring the business meets or exceeds standards as required.

Cleaning up datasets using merge queries, append queries, and sort data columns to properly fit our reports.

Created Dax Queries to generate computed columns in Power BI, also applied DAX calculated measures and columns.

Develop efficient and high performing ETL solutions using SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS)

Assess and profile, source and target data (data structure, quality, completeness, schema, nulls, etc.) and requested business use cases.

Summarize testing and validation results and communicate and make recommendations/decisions on the best course of action to remediate.

Participate in agile work environment, attend daily scrum meetings, and complete sprint deliverables on time.

Support practices, policies and operating procedures and ensure alignment to departmental objectives and strategy.

Ensure each level of the organization has the information needed and the context needed to produce favorable results.

Build strong relationship with IT operational leaders to ensure connectivity to the business.

Environment: MS SQL Server 2019/2017, Power BI, SQL BI Suite (SSAS, SSIS, SSSRS), Shell Scripting, Azure, ETL, SQL, T-SQL, PL/SQL, Oracle, MS Word, MS, Excel, UNIX, Windows OS.

Truist Financial Charlotte, NC Aug 2019 – Nov 2021

Data Analyst

Responsibilities:

Create various schema objects like Tables, Views, Indexes, Stored Procedures depending on user requirements and convert them into technical specifications.

Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.

Published Power BI Reports in the required originations and made Power BI Dashboards available in Web clients and mobile apps.

Design and develop Dimensional Modeling using SSAS cubes and involved in designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX query in writing queries and defining measures.

Collaborated with stakeholders in finance, credit risk, operations, and compliance to translate business requirements into analytical solutions.

Performed trend, variance, and root-cause analysis on key financial and operational metrics to identify performance drivers and improvement opportunities.

Supported regulatory and compliance reporting (CCAR, FDIC, SOX) by ensuring accuracy, completeness, and audit readiness of data submissions.

Partnered with data engineering teams to design and validate ETL workflows, ensuring smooth data integration and transformation across systems.

Conducted data validation, profiling, and reconciliation to ensure data integrity and reliability for analytics and reporting.

Analyze detailed datasets, transforming it into meaningful financial information in preparation for revenue review.

Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.

Perform Extract Transform Load (ETL) tasks, develop and maintain relational databases and SQL-based data loading scripts.

Participate in operational and strategic planning for data handling to optimize company products and services for maximal end user benefit and client satisfaction.

Participate in creation and oversight of proprietary ontology development and maintenance, as well as alignment with related departments such as content collections and indexing.

Participate in ongoing support of clinical informatics tasks and staff; working to generate timely and up-to-date documentation of databases, clinical algorithms, project plans and outcomes, user guides for proprietary tools, and similar artifacts for the informatics group.

Implement security, privacy, and compliance requirements and expertise in working on a Agile team.

Utilized Python and Excel (Power Query, VBA) for automation, predictive modeling, and statistical analysis to improve reporting efficiency.

Worked closely with business analysts and data governance teams to standardize data definitions, metrics, and documentation across enterprise reporting platforms.

Provided ad-hoc analytical support for risk modeling, credit analysis, and performance forecasting to aid in strategic decision-making.

Partnered with IT and security teams to maintain data confidentiality and compliance with regulatory frameworks including GLBA and SOX.

Environment: SQL Server 2016/2014, SQL BI Suite (SSAS, SSIS, SSSRS), MS Power Shell, MS Excel, Git, Jira, Bit Bucket, Confluence, OLTP, OLAP, MS Project, MS Access, Oracle, SharePoint

Hitachi Solutions India Pvt. Ltd. India March 2017 – April 2019

Data Analyst

Responsibilities:

Extract data for reporting from multiple data sources like SQL Server, SQL Server Analysis, Service, Azure SQL Database, Azure SQL Data Warehouse, Salesforce, etc.

Extract data from data warehouse server by developing complex SQL statements using stored-procedures and common table expressions (CTEs) to support report building.

Use Data Analysis Expressions (DAX) to create measures and calculated fields to analyze data and to create time intelligence.

Extensive use of DAX functions for the Reports and for the Tabular Models.

Automated recurring reporting and data preparation tasks using Power Query, Python scripts, and Excel macros (VBA) to reduce manual efforts.

Created detailed data models and visualizations to track key metrics such as sales performance, supply chain efficiency, and customer engagement.

Collaborated with Microsoft Dynamics 365 and Azure Data teams to integrate analytics solutions with enterprise systems.

Use Data Analysis Expressions DAX to create custom calculations in PowerPivot for Microsoft Excel workbooks and Analysis Services tabular model projects.

Create PowerPivot models and PowerPivot reports, publish reports onto SharePoint, and deploy models into SQL Server SSAS instance.

Assist in creating SQL database maintenance logs and presenting any issues to the database architects.

Acquire, manage, manipulate, and analyze data to create meaningful reports and dashboards that contain performance results, targets, benchmarks, opportunities, predictions, and risks for all business units.

Data conversions, data mapping, data definitions and data lifecycle management is completed with the assistance from business process owners.

Design queries and manipulate large volumes of data to create reporting to identify and interpret revenue trends.

Collect master data and maintain it through monthly monitoring of data quality KPIs for each data domain.

Generate ad-hoc reports and regular datasets or report information for end-users using system tools and database or data warehouse queries and scripts.

Perform customer service tasks by interacting with vendors and providers an supported them by trouble shooting issues.

Provided training to providers and other healthcare professionals in data entry and how to make use of the data efficiently.

Environment: SQL, Power BI Desktop, Power BI Service, SQL Server 2016/2017, SSRS, SSIS, SSAS, DAX, Windows, Microsoft Azure, SharePoint, HL7, XML, MS Excel, MS Access, Python

Contact this candidate