Sandeep J K Email & Phone Number

Strong Power BI experience in data sourcing decisions and analyze the data in Query Editor. Familiar with enhanced DAX and other Power BI manipulative functions such as joins, transformations, aggregations, data modelling, relationships, etc.Hands on Experience with DAX Expression and functionsStrong Power BI experience for data sourcing decisions and analyze the data in Query Editor.Must be familiar with enhanced DAX and other Power BI manipulative functions such as joins, transformations, aggregations, data modelling, relationships, etc.Knowledge of Power BI Gateway for automating the data refresh procedures in Power BI.Hands on experience on MS Power BI development that includes Power BI, Power Pivot, Power Query, Power viewExperience creating Power BI reports based on business requirement Experience optimizing Power BI dashboards for performance.Extensive use of Qlikview 11 features such as AdHoc reporting for customers to generate custom reports, Set analysis, Alternate States for comparative analysis, Dimension Limits, Container and Mapping load from QVDs.Presented Proof of Concepts (POC) for Tableau as a project lead to the business leadership for Purchase Order (PO)Improved Industrial Process Using Lean Six Sigma saving $18000 annually, developed standard op.Excellent T-SQL development skills to write complex queries involving multiple tables, great ability to develop and maintain stored procedures, triggers, user defined functions.Created test cases during two week sprints using agile methodologyDesigned data visualization to present current impact and growthDeveloped complex Tableau reports and dashboards as well administer Tableau ecosystem.

New Delhi Area, India

Developed Visual Data Analytics Solutions for Fraud and Risk, Bureau with over 3 billion data records.Migrated complex T SQL scripts, built queries and Stored Procedures, and Views from SQL Server to Oracle database system.Best Data Quality Award- increased acceptance rate of credit Bureau to 98% which is the highest among all NBFCs in India.Used Agile Methodology and SCRUM Process.Created reusable, testable, and efficient Python code using best programming structures, flowcharts and algorithms as well as assisted in designing and implementing Python modules to load data from various sources such as SQL Server, DB2 and Oracle to PostgreSQL databaseDeveloped and owned Dashboards for Urban and Rural Commercial Loan Credit information and created macros to export the visualization tables in TUEF data format and upload it credit Bureaus CIBIL, Experian, Equifax, Highmark.• Developed “Daily Delinquency” Report used by the Collection team to keep track of delinquent customers.• Developed “Net Credit Loss (NCL)” Report used by the collection team to keep track of customers turned from NPA to NCL.• Migrated SQL scripts, Stored Procedures, and Views from SQL Server to Oracle database system.• Migrated data models from SQL Server Integration Services (SSIS)/SQL Server Reporting Services (SSRS) to QlikView for the Extract, Transform,Load (ETL) and Reporting process.

Hyderabad Area, India

L2 QlikView support for leading telecom industry, developed reports using organizational aspect of the key performance indicator (KPIs).• Database Support Engineer, Created/Updated T SQL Queries, Stored Procedures, Views, and Tables and maintained data integrity throughout the system.• Created and monitored weekly, monthly, and quarterly reports in SQL and QlikView.• Prepared the test scenarios on PLSQL/TSQl programs, assisted the Java development team in writing the SQL queries for the application.• Developed and modified triggers, packages, functions and stored procedure for data conversion and PLSQL procedures to create database objects.• Maintained Data governance dashboard and customer access license (CALs) in Qlikview.

Chennai Area, India

• Involved in requirement analysis in support of data warehousing efforts to define both business and technical requirements.• Created databases and schema objects including tables, indexes and applied con-straints, connected various applications to the database and written functions, stored procedures and triggers.• Provided valuable suggestions to users in terms of database design and new appli-cation implementation to overcome existing performance and reliability issues.• Performance tuned long running lengthy SSRS reports and optimized rendering time by 10 times of the actual time.• Developed complex SQL queries using stored procedures, common table expres-sions (CTEs), temporary table to support Power BI and SSRS reports.• Developed complex calculated measures using Data Analysis Expression language (DAX).• Closely worked with Data Quality team and Data Architects to identify bugs in the new Data Models and automated the Data Quality process which involved lot of T-SQL programming like Functions, User Defined Functions, Stored Procedures and Views. • Involved in fixing the bugs in new Data Model and also Data Warehouse worked very closely with Data Architects. • Gathered all requirements from Business Analysts and documented whole process of Data Flow and Data Analysis process from all the source systems.

Hyderabad Area, India

• Involved with Data Architects in designing New Data Model, EDW (Data Warehouse) andOLAP Data Model. • Created SSIS Packages to load Data from Existing Data Model to new Data Model and DataWare House.• Involved in designing complex packages moving data from various servers and environmentsusing SSIS.• Performance tuning the SSIS Packages by understanding the Data Flow Buffers and by designing for parallelism.• Involved in loading Dimensions and Facts in newly built data ware house which also involved in Type 1 and Type 2 slowly changing dimensions using SSIS. • Deploying SSIS Packages on respective server and effectively using configuration files for using same packages on other environments. • Scheduling the SSIS packages by creating a Job using SQL Agent in SSMS. • Worked with various transformations like Lookup, Fuzz Lookup, Merge, Sort, Multicast,• Conditional Split, Loop Containers, Execute SQL Task and lot more using SSIS

Bachelor Of Engineering - Be, Computer Engineering

Master'S Degree, Business Analytics And Information System