Home

venkat - Data Analyst

[email protected]

Location: Cincinnati, Ohio, USA

Relocation: yes

Visa: H1b

Resume file: Venkat- Software engnieer_1767116528843.docx Please check the file(s) for viruses. Files are checked manually and then made available for download.

Venkat MS BI/SQL Server Developer / Data Engineer Ph. no: +1 774-461-1668 Email: [email protected] ________________________________________ PROFESSIONAL SUMMARY: Over 9+ years of experience in various streams includes Data Analysis, Design, Development and Execution of IT solutions for complex business problems. Expert in Healthcare, ERP systems (like Infor M3, Oracle RMS, Softrax), retail business process. Expert in implementing Business Intelligence Solutions for Enterprise Decision support systems using Microsoft suite products like ADF, ADLS, SSIS, SSRS and SSAS, and Power BI. Experience in database design and development using SQL Azure, Microsoft SQL Server, Microsoft Access. Experienced in creating and populating data warehouses OLTP data with various ETL packages with transformations, containers, variables, configurations, and schedules. Debugging knowledge with loggers and event handlers. Experience in database migration from OnPrem to Cloud services. Expert in creating different formats of reports for internal and external reporting purposes. Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Functions, User Defined Datatypes, Rules, And Defaults. Experienced in performance testing and query optimization for faster data access. Experience using Power BI tools for highly interactive ad-hoc reporting needs. Knowledge of identifying, designing, and implementing processes related to data mining and complex data sets using python scripts. TECHNICAL SKILLS: Operating Systems Windows 2000 Server, Windows 2003 Server, Windows XP, Windows Vista, 7, 8, UNIX. Scripting Languages T-SQL, PL-SQL, .NET script, Python RDBMS MS SQLServer2014/2012/2008, SQL Server Management Studio (SSMS), Oracle 9i/10g/11g/12c/19c ETL Tools Azure Synapse, Azure Data Factory (ADF), SQL Server Integration Services (SSIS), Azure Analysis Services (SSAS). Reporting Tools Power BI, SQL Server Reporting Services (SSRS), SharePoint 2007 Data Modeling Tools MS-Visio, Visual Studio 2015/17 Database Query Tools MS SQL Server Query Analyzer, SQL Profiler PROFESSIONAL EXPERIENCE: Client: Gold Kidney Health Plan Mar 2024 to Till Date Role: Sr. Data Analyst Responsibilities: Utilized in-depth knowledge of Medicare claims, Medicare risk adjustment, patient diagnosis, and cost-model development to drive strategic initiatives and improve organizational outcomes. Applied strong analytical skills to extract meaningful insights from quantitative and qualitative data, supporting data-driven decision-making processes. Worked extensively with claim structure data components, understanding their relationships with 834s and 837s and ensuring accurate data representation. Leveraged solid working knowledge of administrative claims data and medical coding systems, including CPT, HCPCS, ICD-9/10, and NDC, to facilitate accurate and efficient data processing. Collaborated with business teams to identify and address missing CMS payments, providing guidance and support to enhance payment accuracy and compliance. Experience working with MCMD, TRR, MMR and Full enrollment files to validate the active population with CMS. Managed provider or payer data warehouses, identifying data sources and executing extraction, transformation, and analysis for comprehensive quantitative and qualitative insights. Conducted and reported on claims-based analysis, population health, Medicare risk adjustment, and quality metrics (STARS), contributing to the overall improvement of healthcare services. Utilized SQL for data warehousing and data management, including T-SQL tasks like creating temp tables, fact and dimension tables, derived tables, subqueries, and stored procedures. Intermediate skills with T-SQL temp tables, fact and dimension tables, derived tables, subqueries, and stored procedures Demonstrated advanced proficiency in Excel, employing PivotTables, linked worksheets, graphing, and other reporting features for effective data presentation and analysis. Strong verbal and written communication skills. Designed and configured Azure Cloud relational servers and databases, analyzing current and future business requirements to ensure optimal performance. Worked on migration of data from On-prem SQL server to Cloud databases (Azure Synapse Analytics Environment: SQL Server 2016/14, SQL Server Integration Services (SSIS), Power BI, Visual Studio 2015, MS-Office Client: 7-Eleven/Speedway Mar 2022 to Feb 2024 Role: Database Engineer Responsibilities: Designed and Configured Azure Cloud relational servers and databases analyzing current and future business requirements. Worked on migration of data from On-prem SQL server to Cloud databases (Azure Synapse Analytics (DW) & Azure SQL DB). Developed ETL pipelines to extract billing and contract data from APIs and load into SQL Server for downstream analytics and compliance reporting. Have extensive experience in creating pipeline jobs, scheduling triggers, Mapping data flows using multiple Microsoft ETL tools. Designed SQL views and materialized tables to support finance dashboards and audit trails, improving visibility into deferred and recognized revenue. Worked on creating tabular models on Azure analysis services for meeting business reporting requirements. Designed SSIS Packages using Business Intelligence Development Studio (BIDS) to extract data from various data sources and load into SQL Server 2012 & 2016 database for further Data Analysis and Reporting by using multiple transformations. Worked on creating correlated and non-correlated sub-queries to resolve complex business queries involving multiple tables from different databases. Used SQL stored procedures and SSIS packages to transform Softrax data into revenue schedules aligned with ASC 606 standards. Perform analyses on data quality and apply business rules in all layers of data extraction transformation and loading process. Perform validation and verify software at all testing phases which includes Functional Testing, System Integration Testing, End to End Testing, Regression Testing. Have good experience in logging defects in Jira and Azure DevOps tools. Involved in planning cutover strategy, go-live schedule including the scheduled release dates of Portfolio central Datamart changes. Client: CareFirst March 2021 to March 2022 Role: Azure Data Engineer Responsibilities: Participate in the team business requirements gathering and analyze, understand, and convert them into database solutions with solid exposure to analysis, design, testing, development, documentation & implementation. Create Source to Target Mapping for the SSIS Package Development. Design ET/SSIS packages to process data from various sources to target databases. Create SQL Server Configurations, Performance Tuning of stored procedures, SSIS Packages. Develop Azure POC for Marketing Data Research. Developed pipelines to move the data from Azure blob storage/file share to Azure SQL Datawarehouse and blob. Worked extensively on Utilization management data preparation and creating reports on KPIs. Created an automated process to move files from SFTP servers to SharePoint for the business to access the files/reports from the Vendors using Azure logic apps. Part of the Agile Team and work on weeks sprints, daily sprint Status, sprint demo preparation and stakeholder demo and signoff. Built a model using Databricks to segment the members into high-risk, low-risk or chronic disease groups using historic member population. Worked on developing predictive models to foresee the members are likely to be hospitalized, experience complications, or need care management, and deploy proactive measures to reduce costs and improve outcomes. Work on package configuration to setup automated ET load processing for one time and incremental Data Loads Setup Metadata Management in SQL Server DB to manage the Full, Incremental load. Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports. Developed SSIS packages bringing data from diverse sources such Excel, SQL server, flat files, Oracle B for the daily load to create and maintain a centralized data warehouse. Designed and configured SIS packages to migrate the data from Oracle, legacy System using various transformations. Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps. Involved in creating dynamic well-organized, accurate and insightful Power BI reports/dashboards to support strategic decisions. Worked on end-to-end project in Azure Environment by pulling the source data from SQL Server and storing the data in Azure SQL Server using Blob Storage and creating reports using Power BI Desktop. Client: CareSource (HealthCare) Dayton, OH August 2019 to March 2021 Role: BI Developer Responsibilities: Developed moderately to complex reports and graphics-based BI solutions using SSIS, SSRS and Power BI. Contributed to the team and department solution design, architecture, and the development and implementation of appropriate standards and strategies. Ensured all HIPAA and other regulatory compliance rules are addressed in all solutions. Design, develop, test and deploy dashboards, reports and alerts/notifications for the presentation of business metrics according to business user requirements consistent with integrated BI applications and warehouse structure. Extensively worked on healthcare - clinical and member data, created various visuals and dashboards. Assist with performing various analyses relating to Medicaid and Medicare engagements, including the analysis of medical and pharmacy claims data. Defined and implemented best practices for ETL design, developed and implemented data modeling standards including element naming conventions. Utilized Power BI to create various analytical dashboards that depict critical KPI, along with slicers and dicers enabling end-users to make filters. Implemented Power BI gateway for different sources to match analysis criteria and further modeling for Power pivot and power view. Manage end-to-end complex data migration, conversion and data modeling. Crafted and collated data from legacy systems. Worked with DBAs for specifications, documentation, and development of data migration mappings and transformations for Data Warehouse and downstream integration systems. Performed data sourcing analysis and data dictionary administration, to include developing new data dictionaries. Created reports with Case management, Claims, claim line and member enrollment data. Experience writing T-SQL scripts, stored procedures, functions and indexes using various DDL and DML commands. Experience in performance tuning of the stored procedures and packages in order to reduce the costs and running time of the scripts. Actively participated and supported development, testing, and analysis activities to ensure quality solutions are delivered following department guidelines and standards. Provided input on the architecture and integration within an Enterprise Data Warehouse environment as and when required. Environment: SQL Server 2016/14, PL-SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Power BI, Visual Studio 2015, Azure TFS, Tortoise SVN, Power Pivot, MS-Office Client: Speedway LLC April 2017 to August 2019 Role: BI/SQL Developer Responsibilities: Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations. Designed and implemented Data Integration and ETL processes with SSIS packages to make data available for reporting purposes within a data warehouse. Designed and built backend architecture for Accounting applications used internally for balancing the accounts. Wrote stored procedures and User Define scalar Functions (UDFs) to be used in the SSIS packages and T-SQL scripts. Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio Used Execution Plan, SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability. Rebuilding the Indexes at regular intervals for better performance. Manage data migration workstream within the established project budgets and advise Project Manager of potential deviation. Proficient in creating and managing Database(s) on SQL Azure. Primarily involved in Data Migration using SQL, SQL Azure, Azure storage, and Azure Data Factory, SSIS Proficient in Subscribe SQL Azure Cloud services. Developed Power BI reports and dashboards from multiple data sources using data blending. Generated ad-hoc reports in Excel Power Pivot and shared them using Power BI to the decision makers for strategic planning. Power BI data visualizations utilizing cross tabs, maps, scatter plots, pie, bar and density charts. Involved in writing scripts to check for duplicate records, delete/modify them depending on the business rule. Created complex Stored Procedures and other SQL Joins and Statements for Applications by using T-SQL. Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes whenever necessary. Environment: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Power BI, VSTS, Azure SQL, Azure Storage Explorer, TFS, Jira, Power Pivot, MS-Office Client: NCP Solutions LLC, Birmingham, AL Nov 2016 April 2017 Role: SQL BI (SSAS SSIS SSRS) Developer Responsibilities: Created ad-hoc reports using SQL server 2014. Involved in requirement gathering, analysis, design, development, change management, deployment and user training. Migrated COBOL conversion programs to SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SQL Server Integration Services. Migrated data from different sources (text-based files, Excel spreadsheets, and Access) to SQL Server databases using SQL Server Integration Services (SSIS). Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent. Before doing any migration, by using the various functions of log shipping backup, copy and restore the database to different kind of servers. Implemented complex business requirements in backend using efficient stored procedures and flexible functions and facilitated easy implementation to the front-end application. Used ADO.NET objects to access data from SQL Server 2014 database by using Stored procedures and queries in T-SQL. Expertise in writing complex DAX functions in Power BI and Power Pivot. Used various sources to pull data into Power BI such as SQL Server, SAP BW Scheduled and maintained routine jobs, tasks, and alerts. For instance, an alert would be sent to the manager of the Sales department, if the entire field were not entered by the data entry person regarding screening using SQL Server Agent. Used custom .NET assemblies for Script Task in SSIS. Optimized the performance of queries with modification in TSQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created clustered/non-clustered indexes wherever necessary. Loading data from various sources like OLEDB, flat files to SQL Server database Using SSIS Packages and created data mappings to load the data from source to destination. Performed troubleshooting operations on the production servers. Worked on complex data loading (implemented the batch data cleansing and data loading). Extensively used joins and sub queries to simplify complex queries involving multiple tables. Environment:SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Management Studio 2014, MS Visual Studio.NET# 2012/2015, TFS, GIT, Rally and Windows 2008 Server. EDUCATION: Master s Degree Information Management - Missouri, US Keywords: business intelligence database active directory information technology golang business works microsoft mississippi procedural language Alabama Ohio