Yeta Nahto
Summary
MS Certified Power BI Professional with 13+ years of experience in IT application integration, designing, developing, and maintaining databases/BI applications with SQL Server and BI Stack (Power BI, Tableau, SSIS, SSAS, and SSRS). Experienced within multiple industries including healthcare, manufacturing, and insurance. Proficient in Microsoft Technologies Power BI, SSRS, SSIS, SSAS, SQL, Azure, C#, and Web API. Skilled in providing integration solutions on Microsoft Azure (IaaS, PaaS, & Hybrid). Adept at extracting and managing large amounts of data in multiple formats, conducting data analysis, and effectively communicating findings to support decision-making processes. Strong ability to translate stakeholder requirements into report deliverables, coordinate with multiple stakeholders, and drive the end-to-end reporting process. Experienced in data modelling, business intelligence tools, collaboration tools, and source control.
Overview
13
13
years of professional experience
1
1
Certification
Work History
BI Lead / Power BI, SSRS
CHLA Children’s Hospital
Los Angeles, CA
01.2016 - Current
- Developed Leadership Power BI dashboards to analyze the population health payer health, cost, and care quality for informed decision-making
- Designed and documented the entire Architecture of Power BI reporting workflows
- Expertise in writing complex DAX functions in Power BI and Power Pivot
- Automated Power Query refresh using power shell script and windows task scheduler
- Used various sources to pull data into Power BI such as Sql Server, SAP BW, Oracle, SQL Azure
- Installed and configured Enterprise gateway and Personal gateway in Power bi service
- Created Workspace and content packs for business users to view the developed reports
- Scheduled Automatic refresh and scheduling refresh in power bi service
- Wrote calculated columns, Measures queries in power bi desktop to show good data analysis techniques
- Weekly presentation to the business users about the reports and their changes as required
- Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily
- Worked on all types of transformations that are available in Power bi query editor
- Created stored procedures and SQL queries to pull data into power pivot model
- Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution
- Database creation (DDL, DML, DCL), database tuning, SQL tuning, performance planning
- Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables
- Developed tabular queries for efficient analysis of report using Pivot/Un pivot in T-SQL
- Transformed complex business logic into Database design and maintaining it by using SQL objects like Stored Procedures, User Defined Functions, Views, T-SQL Scripting and Jobs
- Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions, and Triggers as required
- Created Jobs Performance report that queries system tables to track the duration of each job and weekly-average duration using SSRS
- Designed and created data extracts, supporting SSRS, POWER BI, Tableau or other visualization tools reporting applications
- Creating data blending in case of merging two different datasets using Tableau
- Created Datasets in T-SQL, stored procedures for SSRS
- Developed Excel Power View, Power Query and PowerPivot dashboards for data analysis
- Developed confidential proprietary analytical tools and reports with Confidential Excel, and Power Pivot and Power Point
- Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard
- Created SSIS packages to import data from Access, Excel, XML, OLE DB Source and Flat Files
- Filtered bad data using Derived column, Lookups, Fuzzy Lookups, Conditional split
- Designed SSIS packages to import and transform data between databases and external data sources using various transformations like Data conversion, File system task, Row counts, OLE DB Source, OLE DB Destination, OLE DB Command, Merge Join, Look up, Sort, Data flow task
- Designed and created data extracts, supporting SSRS, Power BI, Tableau or other visualization tools reporting applications
- Debugging SSIS packages, Performance tuning on Slowly running SSIS Packages
- Created Reports using Charts, Gauges, Tables, matrix
- Created Parameterized Report, Dashboard Report, Linked report and Sub Report by Year, Quarter, Month, and Week
- Created Drill Down Reports, Drill Through Report by Region.
ETL/ SSRS Developer
Molina healthcare
Long Beach, CA
11.2014 - 01.2016
- Gathered HEDIS requirements and coordinated with the business to assure satisfactory data content, quality, data integrity and receipt of desired information with HIPPA Standards
- Created database objects like stored procedures, Triggers, User-defined Functions, Views for both Online and Batch requests handling business logic and functionality of various modules
- Created complex stored procedures to perform Index maintenance, data profiling, metadata search, critical staging procedures for loading data marts and reporting database
- Refined the performance of various SQL scripts and stored procedures by using UDFs, CTEs and System stored procedures along with usage of tools like SQL Profiler and Database Tuning Advisor
- Created Triggers to update master tables in order to authenticate the transactions depending on business logics
- Created partitions on tables, indexes and indexed views as well as querying and managing partitions from optimization point of view according to the business requirements
- Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost
- Involved in Designing, Developing and Testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS
- Transferred data from flat files, Excel spreadsheets and heterogeneous data to and from SQL Server using SSIS, BCP and Bulk Insert
- Implemented error & failure handling in SSIS packages using event handlers, row redirects, checkpoints, and used loggings for monitoring the execution
- Identified and maintained slowly changing dimensions, heterogeneous Sources and determined the hierarchies in dimensions
- Created SSISDB catalog with SQL 2012 to support SSIS package deployments in SSMS with Environment variables respective to each environment
- Created several calculated members, KPI’s as well as perspectives in support of analytical reporting applications and dashboards
- Created cubes from relational data warehouses and created KPI’s for the reporting needs
- Designed, developed and deployed reports in MS SQL Server environment using SSRS
- Created complex reports that include multiple data sources and stores procedures with nested tabular and matrix forms and formatted the reports using the Global variables and expressions (conditional formatting)
- Generated Dashboards, Sub-Reports, Drilldown-Reports, Summary reports, and Matrix reports using both T-SQL variables and MDX
- Designed ad hoc SSRS reports in the test environment for data validation using SQL Server 2008R2
- Generated reports using SSRS and Excel Spreadsheets with Power pivots and deployed then in SharePoint integrated mode
- Designed strategies for securing the reports created depending upon the level of sensitivity of information that the report contained
- Configured deployment of SQL Server Reporting Services to work with deployment of Microsoft SharePoint Foundation 2010 or Microsoft SharePoint Server 2010
- Used push method of delivering reports – subscriptions by scheduling the reports to deliver on time using MS SQL server Agent in different formats viz
- Excel, Pdf, Text, etc.
Tableau Developer / ETL Analyst
Classic Party Rentals
Inglewood, CA
06.2011 - 11.2014
- Lead a team of Developers, QAs, and BAs in Data Integration and System Integration
- Building and maintaining suitable tracking dashboards and metrics using Microsoft SQL Server SSRS , Tableau and PowerBI
- Design and develop interactive and visually appealing Tableau dashboards and reports
- Create and maintain data connections and data sources for Tableau projects
- Extract, transform, and load (ETL) data from various sources into Tableau for analysis
- Optimize Tableau performance by fine-tuning data queries and dashboard design
- Implement security and access controls to protect sensitive data in Tableau
- Conduct data analysis to identify trends, patterns, and insights using Tableau
- Automate and schedule data refreshes and report generation processes
- Document Tableau solutions, data sources, and best practices
- Collaborate with data engineers and analysts to ensure data accuracy and consistency
- Troubleshoot and resolve Tableau-related technical issues
- Stay updated on Tableau features and best practices to leverage new capabilities
- Provide training and support to end users on Tableau usage
- Manage Tableau Server deployment and monitor server performance
- Perform version upgrades, patches, and server maintenance tasks
- Implement backup and disaster recovery strategies for Tableau Server
- Assist in capacity planning and scalability efforts for Tableau environments
- Lead IT DevOPS team, Business, SaaS vendors and Support team to automate application builds for current and future products
- Work extensively on system analysis, client requirement analysis, gap analysis, design, development, testing and implementation of projects (Complete SDLC)
- SME in Eligibility, Healthcare Provider, Medical Claim, Pharmacy Claim and Lab Data
- Handled both standard health care data files, such as HL7, CALINX, EDI 837, CMS 1500, UB04, and Proprietary files
- Analyze, Design and Develop SSIS Packages and Complex Stored Procedures to Intake, Medical Claim Data, Pharmacy Data, Lab Results Data, Member Enrollment Data and Provider Data
- Enforced business rules by creating constraints in both the production and relational data warehouse databases
- Developed new processes to determine and handle Adjustments for both Medical Claims and Pharmacy Claims
- Responsible for Code reviews and Pair programming with Developers
- Generate SSIS Packages to process Inbound and Outbound Data files for Internal Business Users and External Vendors
- Perform Detail Data Analysis on files received from clients and files submitted to downstream applications/ clients
- Responsible for Production Support and/or Provide Data Support to Internal Business Units and Third-Party Vendors
- Implement Batch Tracking in SSIS Packages for file inbound file received or outbound files transferred
- Design and Develop Validation and Reconciliation Reports to track Data Flow
- Create detail process documentations, such as, dataflows, workflow, functional specifications, data specification, mapping documents, data dictionaries, and process flows
- Identify, design, and implement internal process improvements: automating manual processes and optimizing data delivery
- Build the infrastructure required for optimal extraction, transformation and loading of data from a wide variety of data sources using SQL and Azure technologies
- Migrate On-Prem Databases, Data Warehouses, and SSIS Packages to Azure Managed Instance and Azure Data Factory
- Design Complex SSRS Reports, such as, Dashboards, Chart Reports, Cascading Reports, Sub-Reports, and Ad-hoc reports
- Assisted QAs in Testing multiple data source systems and downstream applications
- Work with QAs to design Test Plan and Test Cases
- Develop Validation Scripts for both QAs testing and UAT testing
- Trouble shoot and Optimize SQL Queries, SSIS Packages and Stored Procedures in Production.
Education
Skills
- SDLC: Agile, Scrum, Waterfall, and Spiral
- Databases: MS SQL Server, Oracle, MySQL
- Microsoft Azure (LogicApp, FuncApp, Data Factory), AWS Redshift
- Programming: T-SQL, PL/SQL, C#, VBNet, Python
- Data Modeling: ER-win, MS Visio
- Business Intelligence Tools: Power BI, Tableau, OBIEE
- Collaboration Tools: SharePoint, Office 365
- Integration Services (SSIS), Tibco, ADF
- Analysis Services (SSAS, OLAP Cubes)
- Reporting Services (SSRS, Report Builder, Crystal Report)
- Development Tools: BIDS, SSDT, SSMS
- Source Control: Azure DevOps, Team Foundation Server (TFS)
Certification
- Certified Microsoft Power BI Data Analyst PL-300, https://learn.microsoft.com/en-us/users/yetagesunahto-3818/credentials/9c494f989ff57fa3
- Certified Microsoft Azure Data Engineer Associate DP-200, https://learn.microsoft.com/en-us/users/yetagesunahto-3818/credentials/C25AC8E1B9E89C6D
- Certified Microsoft Power Platform Developer Associate PL-400, https://learn.microsoft.com/en-us/users/yetagesunahto-3818/credentials/8c5f15eea67f7542
Timeline
BI Lead / Power BI, SSRS
CHLA Children’s Hospital
01.2016 - Current
ETL/ SSRS Developer
Molina healthcare
11.2014 - 01.2016
Tableau Developer / ETL Analyst
Classic Party Rentals
06.2011 - 11.2014
Similar Profiles
Khalid AhmedKhalid Ahmed
Financial Counselor at Children's Hospital Los Angeles (CHLA)Financial Counselor at Children's Hospital Los Angeles (CHLA)
Liliana TorresLiliana Torres
Infection Prevention Intern at Children's Hospital Of Los Angeles (CHLA)Infection Prevention Intern at Children's Hospital Of Los Angeles (CHLA)
Daniel PerezDaniel Perez
Hospital Service Technician at Children's Hospital (CHLA)Hospital Service Technician at Children's Hospital (CHLA)
Sambasivarao TangellaSambasivarao Tangella
SSRS, Power BI Developer at Varsun E technologies Pvt LtdSSRS, Power BI Developer at Varsun E technologies Pvt Ltd
Md Nur HossainMd Nur Hossain
SQL Server /ETL/SSIS/SSRS/Tableau/Power BI Develop at Tech ShavySQL Server /ETL/SSIS/SSRS/Tableau/Power BI Develop at Tech Shavy