Kanchi

About Kanchi

• Overall 6+ years of experience in IT as a SQL BI and Teradata Developer/Data Analyst with expertise in Database Design, Programming, Development and Implementation of Client-Server Applications & Database systems using Microsoft SQL Server, Teradata, Oracle databases and SQL Server BI Suite of Products SSIS, SSAS, SSRS and Power BI in various domains like Finance, Retail, HealthCare and Insurance. • Expertise with Relational Database Management System (RDBMS) and Data Warehouse Concepts (OLTP & OLAP). • Extensively worked on System analysis, Design, Development, Deployment, Testing, Performance tuning, and Implementation of projects Software Development Life Cycle (SDLC) and Relation Database Architectures for database design, data warehousing using Business intelligence concepts, Star Schema and Snowflake Schema methodologies. • Expertise in MS SQL Server suite of products like SSRS, SSIS and SSAS of MS SQL Server 2012/ 2014/2016. • Understand rules and regulations of HIPAA as imposed during Electronic Data Interchange (EDI). • Expertise in using Teradata utilities such as Fast Load, MultiLoad, Tpump, Fast Export Teradata Parallel Transporter, and BTEQ using Teradata SQL Assistance for export and import of data. • Expertise in using Set, Multiset, Derived, Volatile, Global temporary tables in Teradata for larger Ad-hoc requests. • Experience in installation and upgrades of/to SQL server2012/2014/2016 and its service packs, database migrations, backup, recovery and maintenance of SQL Server databases in Cluster environment. • Experience in creating complex Stored Procedures, Macros, DTS packages, Triggers, Cursors, Tables, Indexed Views, Table Partitioning and other SQL Joins and Statements to facilitate efficient data manipulation and to maintain data consistency. • Designing, creating, and tuning physical database objects (tables, views, indexes, PPI, UPI, NUPI, and USI) to support Normalization/Denormalization, Normal Forms and Dimensional data Modeling. • Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions. • Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager &Monitor. • Experience in developing Stored procedures for .Net applications and SQL Server Data Tools. • Built, published and customized interactive reports and dashboards, and worked on report scheduling using Power BI and Tableau server. • Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau. • Expertise in Excel - Pivot table, Power Query, Power View Dashboards generation and maintenance. • Developed ETL packages to Load data from various sources to SQL server and SQL Azure Data Factory (ADF). • Good knowledge and understanding on Informatica Power Center tools which includes Designer, Workflow Manager, Repository Manager and Workflow Monitor. • Experience on Database Migration from SQL Server On-Prem to Azure Datalake Store Using Azure Data factory and SQL Server Integration Services • Develop ETL programs using SQL Server in SSIS and Informatica to implement the business requirements. • Experience in data migration from various data sources like Excel, SQL Server, Oracle, XML files, Flat files using SSIS packages and SQL commands. Monitoring, debugging and tuning ETL jobs and workflows. • Good knowledge in deploying applications on Windows Azure. • Developed Ad hoc reports using SQL, PL/SQL, and UNIX to fulfill business analysts, Operations Analysts, and Financial analyst’s data requests. • Performance Tuning of sources, targets, mappings, and SQL queries in transformations. • Responsible for Query Optimization and Performance Tuning using SQL Profiler and Index Tuning Wizard. • Proficient in performance analysis, monitoring, and SQL query tuning using EXPLAIN and Execution Plan, Collect Statistics, Hints in Teradata as and with SQL Trace in SQL Server.