Amitsinh Nakoom

About Amitsinh Nakoom

Sr. BI/ETL Developer over 13 years of solid experience as Business Intelligence Lead & Healthcare data/Business Analyst on onsite/offshore model• 7 years of Excellent testing experience in all phases and stages of Software Testing Life Cycle and Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling.• Excellent skills in developing code for database applications extensively using ODBC, MS Access, SQL Server 2005, 2008 R2 and MySQL and Oracle 8i• In house expert in designing, developing and deploying various ETL packages (SSIS) and schemas in SQL Server and developing of SSRS Reports• Solid command in Migration of DTS packages to SQL server 2008R2 and newer versions• Very good skills in development/administration and Framework model/Cognos transformer design using Cognos 8.2, Cognos 8.4 and Cognos 10.2.2• Expertise in development of reports using Precision BI, SSRS and Tableau• Extensive knowledge in database maintenance, SQL query optimization & performance tuning using performance tools like SQL Profiler, Index Tuning Wizard, and Database Engine Tuning Advisor.• Working very closely with various Healthcare entities like Health plans (end to end process of HCC data submission), PQRS (data extraction), HEDIS (end to end process), LabCorp (Data extraction), Pharmacy (Data extraction), ACO (Extraction and cube development)• Effective communication and interpersonal skills with complete fluency and understanding of work culture and professional environment in the USA• Magnificent data Analysis skills on various Healthcare data (HMO, PPO), Insurance sales data• Hands on experience in database Normalization from 1N to 3NF

Experience

1. Sr Data Engineer

   Teesnap

   Apr 2023 — Present · Glenview, IL, US

   Snowflake,Sigma Computing,Tableau,Data Engineering,Python,Hevo

Education

• Sardar Patel University

  Bachelor’s Degree, Information Technology

  2003 — 2007

Skills

• Powerplay Transformer
• Performance Tuning
• Pl/Sql
• Healthcare Industry
• T-Sql
• Database Design
• Troubleshooting
• Oracle
• Requirements Analysis
• Dimensional Modeling
• Data Integration
• Etl
• Database Administration
• Sql Server Integration Services (Ssis)
• Relational Data Modeling
• Data Analysis
• Etools
• Ssrs
• Sql
• .net
• Cognos
• Microsoft Sql Server
• Ssis
• Ssas 2008
• Databases