Sadgun P
Bi Tableau Da @Firstcare Health Plans
Signup · Get unlimited contacts
WORK HISTORY
Bi Tableau Da @Firstcare Health Plans
Austin, TX, US
Designed several business dashboards using Tableau Desktop, Tableau server and hosted them across the client servers.• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server• Responsible for complete development of database structure to support major projects, Medicaid & Commercial for BSW health plan. This involved requirement gathering, analysis, development, deployment & support of all the tech & business teams across various organizations. This saved the organization time and resources. • Constantly updating senior management & working with mid-level management to resolve & mitigate any blocking items to ensure everybody on the same page of the projects progress. This has facilitated a much smoother, efficient and effective management of company’s 20••••20 health plan integration and expansion goal.• Designed ETL packages dealing with different data sources (SQL Server, Flat Files) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).• Responsible for coding SSIS processes to import data into the Data Warehouse from Excel spreadsheets, Flat Files and OLEDB Sources.• Worked on various tasks and transformations like Execute SQL Task, Execute Package Task and conditional split, Script Component, Merge and Lookup while loading the data into Destination.• Created stored procedures, Triggers, User-defined Functions, Views for both Online and Batch requests handling business logic and functionality of various modules.• Created SSIS/DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle.• Created complex SQL queries by joining multiple tables, dynamic SQL and sub queries in TSQL. • Worked on migrating data from non-relational database to relation database. • Data migration (Import & Export using BCP) from text to SQL Server 2016.
EDUCATION
TKR College of Engineering & Technology
Bachelor's degree JNTU , Computer Science
ABOUT SADGUN P
9+ years of experience in the analysis, design, development, implementation, testing, maintenance, Business Intelligence projects and documentation of Database and Client Server applications.• Good experience in Finance, Banking and healthcare industry. • Expertise in Conversion of extreme level design specifications to detailed technical, functional specifications and interacted with business users for gathering requirements for Tableau Workbooks and Dashboards.• Experience in installing Tableau Server on both on-Premise as well as the Cloud, using Amazon EC2 instances in Amazon Web Services (AWS).• Exploratory data analysis with R, Python.• Worked on pre-upgrade checklist and what has changed from the previous versions for an upgrade to 2021.1/2020.x/2019.x/2018.x/10.x, 9.x • Experienced with Installing, upgrading and patching in Tableau server and implemented in required conditions in upgrading experienced on backup, recoveries, security, configuration setup etc.• Designed and developed stored procedures, queries and views necessary to support SSRS reports• Designed new reports and wrote technical documentation, gathered requirements, analyzed data, developed and built SSRS reports and dashboard, supported more than 20 client companies\' general business reports and benefit plan administration processes.• Ported Data into the Alteryx enabled SQL Server and Amazon Redshift data warehouse, 40 gigabytes of data going back.• Experience in integrating Alteryx and tableau, publishing data extracts from Alteryx to tableau server, Pulling data from Alteryx App on server though Web data connector into tableau Desktop.• Good Experience in Data Warehouse development starting from inception to implementation and ongoing support, Strong Understanding of BI application design and development principles• Excellent command with MS SQL Server 2016/2014/2012/2008/2005 worked on Integration services (SSIS), Reporting services (SSRS) and Analysis services (SSAS).• Expertise with performance tuning for the Tableau Visualizations and Tableau server• Used Tableau with AWS cloud connecting to AWS EMR and AWS redshift.• Experience in Tableau report developing, testing and deploying reporting solutions using Tableau Server.• Responsible for data aggregation, data pre-processing, missing value imputation and descriptive and inferential analysis with R, Python, Tableau prep, Tableau desktop• Skillful in creating Tables, Views, Indexes and other SQL joins and complex query writing• Experience in ETL from & to SQL Server Databases using utilities / tools.
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.