Hephzibah K

• With overall 11years IT experience and 5.1 years of experience in providing analytical and reporting solutions using various ETL and Visualization tools to solve various business problems.
• Extensive knowledge and hands-on experience in Power BI & Tableau Development designed and developed custom power Bi & tableau dashboards.
• Providing expertise on Data Migration, Data Storage Structures, and Data Cleansing.
• Importing and verifying data from multiple data sources into Power BI.
• Experience in Data transformation like pivot, unpivot, conditional split, filter, sort, adding and removing columns, rows whenever necessary in power query editor.
• Experienced in creation of Appending and Merging. Dashboards apply the filters Drill down and Drill through functions and created tooltip on sheet level as per requirements.
• Developed Dashboard KPI’s using MS Power BI platform and publish schedule reports and dashboards to meet business requirement.
• Created and designed dashboard formatting and Alignment. Analyzed, designed, developed, tested, debugged, implemented, maintained and/or enhanced existing or new systems that are reliable and efficient.
• Expert at designing and customizing document types, lifecycles, objects, and workflows. Demonstrates exceptional knowledge in Data modeling.
• Hands-on experience in developing source to target mapping specifications.
• Experienced in executing successful migrations using loaders and other migration tools.
• Ensured compliance with support processes such as incident management, problem management, and change management.
• Dedicated professional with a proven track record in delivering high-quality solutions in the team environment.
• Developed and managed strong relationships with Business Team members to help prioritize work effectively to meet strict delivery timelines.
• Experience in Creating Charts, Table Calculations, Trend lines and calculated measures.
• Involved in development of interactive data visualization reports using Calculated Field, and LOD Expressions.

Baseline & Play zone 

• Players Data Management, Designed and implemented data models in SQL Server to store and manage financial data from trading platforms and market feeds.
• Developed complex financial reports and visualizations in Power BI to track key metrics such as portfolio returns, market volatility, and asset allocation.
• Utilized advanced DAX calculations to measure risk-adjusted returns and conduct scenario analysis for investment strategies., Automated report generation and distribution using Power BI service, enabling stakeholders to access real time financial insights.
• Implemented data governance frameworks and security measures to protect sensitive financial information and ensure regulatory compliance.

Rcopia, Healthcare

• Extracted and integrated data from Electronic Health Records (EHR) systems and operational databases using SQL Server.
• Developed interactive dashboards in Power BI to visualize key performance indicators (KPIs) such as patient wait times, bed utilization rates, and readmission rates.
• Implemented predictive analytics models to forecast patient admission rates and optimize resource allocation., Collaborated with healthcare professionals to translate data insights into actionable strategies for enhancing patient care and operational workflows.
• Conducted data quality assessments and implemented data cleansing processes to ensure accuracy and reliability of reporting.
• RPO, Mortgage Banking, Extracted and transformed sales data from SQL Server using SQL queries and ETL processes.
• Designed and developed interactive dashboards in Power BI to visualize sales trends, customer segmentation, and product performance across regions.
• Implemented machine learning algorithms to improve sales forecasting accuracy and optimize inventory levels based on demand fluctuations.
• Integrated external data sources such as weather patterns and social media trends to analyze their impact on consumer behavior and sales performance.
• Collaborated with cross-functional teams to implement data-driven strategies for promotional campaigns and inventory replenishment, resulting in increased sales and reduced stock outs.

AFS – iGates Application

• Banking, Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Gathered business requirements from users and converted them to technical specifications by building dashboards and reports.
• Created relationships between data and develop tabular and other multidimensional Models.
• Implemented row-level security in Power BI workspaces depending on the type of access required.
• Involved in creating calculated fields, mapping and hierarchies.
• Building Tableau Dashboard's., Restricting data for particular users with help of User filters.
• Involved Agile Scrum methodology., Involved in generating dual-axis bar chart with multiple measures and data blending in case of merging different sources.
• Using Excel, CSV, and Oracle -Server as data source for designing Tableau Report and Dashboard., Created Action filters and Apply filters.

Wall Street, Banking

• Collected and managed detailed records for over 1500 employees using SQL databases, ensuring data accuracy and integrity.
• Conducted comprehensive analysis on wage distribution and employee experience, highlighting trends in high and low wages across departments.
• Performed department-wise wage calculations and monthly salary cost assessments, optimizing financial tracking and reporting.
• Developed SQL queries to identify employees taking frequent leaves (with and without permission) for improved attendance management.
• Implemented processes to determine department sizes and associated staffing costs, contributing to workforce planning strategies.
• Enhanced data processing efficiency, achieving a 15% to 27% reduction in time compared to legacy software, streamlining data access and analysis.,
• Utilized advanced SQL techniques to support complex data analysis, facilitating data-driven decision-making and reporting for HR and finance teams.,
• Developed and implemented sophisticated customer segmentation strategies using SQL & Excel, markedly accelerating stock clearance rates and enhancing sales efficiency.

ADCHN

ACIMP