Kshitiz K — Data Engineer

• Around 4 years of professional experience in Database Design, Programming, Development, and Implementation of Client-Server Applications &Database systems using SQL Server 2012/2016 and Pentaho Data Integration (PDI)& Power BI, Azure • Experience with software development life cycle (SDLC), Agile / Scrum and Project Management Methodologies. Extensively involved through the Software Development Life Cycle (SDLC) from initial planning through implementation of the projects. Capable of handling responsibilities independently as well as a proactive team member. • Extensive experience in interacting with business users, gathering requirements, data analysis, data mapping, gap analysis and documentation. • Experience in designing and deploying the application by utilizing Azure Services (Virtual Machines, SQL Database, Azure Storage, Azure Active Directory, Network Virtualization, Content Delivery Network). • Experience in coordinating with users in gathering source data files, defining data elements, business rules, data and process flow documentation, prepare High level and Low level design documents. • Experience in installation, configuration of MS SQL Server 2000, 2005, 2008, 2008R2 and 2012. • Hands on experience in monitoring SQL Server Performance tuning in SQL Server 2000/2005 /2008 using SQL Profiler, Query Analyzer, Enterprise Manager, Index Tuning Wizard, and Windows Performance Monitor. • Knowledge of Relational Database Management systems. • Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance. • Experience in creating and managing fragmentation of Indexes to achieve better query performance. Experience in Performance Tuning and Query Optimization. . • Expert in developing SSIS packages. Experience in DTS Migration and Metadata Management: Migrating DTS packages to Package Migration Wizard, and Storage Management. • Proficient working experience with SQL, PL/SQL, Database objects like Stored Procedures, Functions, Packages, Triggers and using the latest features to optimize performance like Bulk Binds, Inline views and Global Temporary Tables. • Very good experience in Oracle tools like SQL*Plus, SQL*Loader, SQL Developer using TOAD in secure databases. • Very good knowledge of SQL, PL/SQL especially writing queries with Joins, Sub-Queries, Rollups, Cubes, Set Operators. • Extensive experience in using Oracle seeded packages like DBMS_OUTPUT, DBMS_SCHEDULER, UTL_FILE, DBMS_SQL and DBMS_STATS. • Expertise in handling errors using Exceptions with RAISE application clause.

Stackforce AI infers this person is a Data Engineer specializing in ETL processes and database management within SaaS and Fintech industries.

Location: Toronto, Ontario, Canada

Experience: 1 yr

Skills

Sql Server
Ssis
Azure
Ssrs
Dax

Career Highlights

Expert in SQL Server and SSIS development.
Proven track record in data migration to Azure.
Strong experience in performance tuning and optimization.

Work Experience

Sitecore

SQL Developer (4 yrs 3 mos)

TD

Business Intelligence Developer (1 yr 1 mo)

Nagarro

SQL Developer (1 yr 8 mos)

Education

Bachelor’s Degree at Netaji Subhas Institute of Technology

Postgraduate Degree at Conestoga College

Kshitiz K

Data Engineer

Toronto, Ontario, Canada1 yr experience

Key Highlights

Expert in SQL Server and SSIS development.
Proven track record in data migration to Azure.
Strong experience in performance tuning and optimization.

Stackforce AI infers this person is a Data Engineer specializing in ETL processes and database management within SaaS and Fintech industries.

Contact

kshitiz.kvr@gmail.com LinkedIn

Skills

Core Skills

Sql ServerSsisAzureSsrsDax

Other Skills

Data AnalysisData ModelingData VisualizationData WarehousingETLJob Search StrategiesLeadershipManagementPerformance TuningProject ManagementPublic SpeakingPythonRReporting ServicesResearch

About

Experience

Sitecore

SQL Developer

Dec 2021 – Present · 4 yrs 3 mos · Toronto, Ontario, Canada

Assisted in the definition of the database requirements; analyzed existing models and reports looking for opportunities to improve their efficiency and troubleshoot various performance issues.
Developed highly optimized stored procedures, functions, and database views to implement the business logic and also created clustered and non-clustered indexes.
Involved in performance monitoring, tuning and capacity planning.
Advised optimization of slow performance queries by looking at Execution Plan for better tuning of the database.
Translated business requirements into BI application designs and solutions.
Created SSIS package to load data from Flat Files, Excel and XML Files to Data warehouse and Report-Data mart using Lookup, Derived Columns, Sort, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
Used various SSIS tasks such as Conditional Split, Multicast, Fuzzy Lookup etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
Responsible for implementation of data viewers, Logging, error configurations for error handling the packages. Involved in complete life cycle in creating SSIS packages, building, deploying, and executing the packages in both the environments (Development and Production).
Created and maintained data flow diagrams for existing and future ETL processes.
Designed, deployed, and maintained complex canned reports using SQL Server 2008 Reporting Services (SSRS).
Migrating the current projects from SQL Server, PDW to Azure and ensuring a smooth go-live Azure operations.
Redesigned the on-prem functionality in the Azure Data Lake, Azure Data Factory.
Customized reports by adding Filters, Calculations, Prompts, Summaries and Functions. Created reports to retrieve data using Stored Procedures that accept parameters.
Created Parameterized Queries, generated Tabular reports, sub reports, Cross Tabs, Drill down reports

SQL ServerSSISAzurePerformance TuningData WarehousingReporting Services

Td

Business Intelligence Developer

Nov 2020 – Dec 2021 · 1 yr 1 mo · Toronto, Ontario, Canada

Created reports using SSRS from OLTP and OLAP data sources and deployed on report server
Created tabular, matrix, chart, drill down reports, parametric, cascaded reports, dashboards, and score cards reports (SSRS) according to business requirement.
Created reports by dragging data from cube and wrote MDX scripts.
Used SSIS 2008 to create ETL packages (dtsx files) to validate, extract, transform and load data to data warehouse, data mart databases, and process SSAS cubes to store data to OLAP databases
Improved the performance of long running views and stored procedures.
Improved performance by adding indexes, removing unnecessary columns in the inner views and adding conditions to get only required data.
Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
Extensive use of DAX (Data Analysis Expressions) functions for the reports and for the tabular models.
Identified slow performing views, stored procedures and queries using SQL Profiler, by running simultaneously while browsing the application.
Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
Experienced in using Data Analysis Expressions DAX to creating custom calculations in PowerPivot for Microsoft Excel workbooks and Analysis Services tabular model projects.
Extracted the data from Oracle, Flat Files, transformed (Implemented required Business Logic) and Loaded into the target Data warehouse using SSIS (SQL Server 2008).
Tuned the queries using Execution plan, to get index seek from table scan and index scan. Improved the performance of many queries by 90%.
Worked with Erwin data modeling tool
Created Database objects including Tables, Views, Stored Procedures and UDF.
Developed User defined functions, stored procedures, indexes, Triggers.
Extensively involved in writing database scripts.

SSRSDAXSQLETLData Visualization

Nagarro

SQL Developer

Mar 2018 – Nov 2019 · 1 yr 8 mos · Hyderabad, Telangana, India

Developing and Management Database for Collateral Management and Hedging
Writing Triggers, Stored Procedures, Functions, define User Defined Data Types, TSQL, and Create and maintain physical structures.
Working with Dynamic Management Views, System Views for Indexing and other Performance Problems
Create / Manage Table Indexes, Query Tuning, Performance Tuning, Deadlock Management
Defect tracking and closing by using HP Quality Center
Design and Deploy SSIS Packages
Creating SSIS Packages, Configure SSIS packages for different environments using DTSConfig
Produce CSV, utilize CSV files as part of ETL Process
Used .Net Scripts
Produce XML
Experience in building Star schema and Snowflake schema depending on the business data requirement.
Event Handling, Logging, Batch Checks for data accuracy
Code deployments / configurations/ config management in various environments
Implement Security, Roles, Logins, and Permissions
Extract-Transform-Load data into SQL Server 2008 Normalized database from various sources
Maintain Users / Roles / Permissions, Security
Scheduling SSIS packages using Autosys, writing JIL Scripts
Enhance existing applications to meet new business requirements
L3 Production Support on Rotation basis
Enhance existing stored procedures, views, functions, database objects to meet additional requirements of latest releases
Experience in data modeling, designing star schema (identification of facts, measures and dimensions), Snowflake schema for Data Warehouse, ODS Architecture by using Erwin Data Modelling tool.
Capacity Planning DBs, Disk Requirements
Deploy the code in various environments i.e. DEV/SIT/UAT