Sujith Kumar Email & Phone Number

Toronto, Ontario, Canada

Remote

• Designing and developing packages for a Data Warehousing and Data Migrations projects using Integration Services (SSIS) on different Data Sources (Oracle, Teradata, MS SQL Server etc.). • Configured Azure platform for data pipelines, ADF, Azure Blob Storage and data lakes. Build workflows to automate data flow using ADF.• Design of the data source and data flows, data quality analysis and incorporated business defined transformation logic to load tables into SQL Server. • Actively participated in migration of on-premises SQL Server schemas to cloud on Azure SQL Server DB and Azure VM and developed and maintained databases across both on-premises and cloud deployments.• Built complex ETL packages, using both SSIS and Azure Data Factory ADF2 pipelines for processing Fact and Dimensions tables using various transformations.• Experienced in building end to end Data Pipeline that is capable to copy the data from the Azure Data Lake storage(containers) and convert the Json Data into Parquet format from source to sink and created Azure Databricks to perform an analysis using Spark SQL• Developed complex programs in T-SQL, writing Stored Procedures, Trigger sand Queries with best execution plan. • Explore data in a variety of ways and across multiple visualizations using Power BI. • Designed and created data extracts, supporting SSRS, Power BI, Tableau, or other visualization tools reporting applications. • Extracted data from Oracle, Teradata, Flat Files, Excel, and XML using SSIS and cleanse the data. • Involved in De-Normalization of existing tables for faster query retrieval. • Created SSIS Packages using Fuzzy Lookup, Derived Columns, Pivot Transformation, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access, and CSV files to data warehouse.

Toronto, Ontario, Canada

• Identified the required data objects in the database and created various T-SQL, PL/SQL, and OLAP data structures complex queries to pull data for reports.• Experience working with healthcare-related EDI files (834, 835, 837).• Working knowledge of the health care industry EDI transaction sets including the 5010 file layouts.• Analyze business requirements and data sources from Salesforce, Excel, Oracle, SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Power BI Desktop.• Fine-tuned SQL Queries for maximum efficiency and performance.• Used SQL and Excel to cleanse and perform calculations against data.• Utilized Performance Analyzer tool to detect how each of the report elements such as DAX formulas and visuals are working.• Wrote complex DAX functions in Power BI and Power Pivot. Used various sources to pull data into Power BI such as SQL Server, SAP BW, Oracle, SQL Azure.• Created new app workspaces through which internal and external users collaborated on reports, dashboards, and other content.• Developed various types of transformations that are available in Power BI query editor• Created stored procedures and SQL queries to pull data into PowerPivot model.• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.• Created new reports for marketing teams using SAP Business object and Crystal reports.• Transformed complex business logic into Database design and maintaining it by using SQL objects like Stored Procedures, User Defined Functions, Views, T-SQL Scripting and Jobs.• Created Jobs Performance report that queries system tables to track the duration of each job and weekly-average duration using SSRS.

Hyderabad, Telangana, India

• Installed and configure servers and clients using SQL Server 2012, Upgraded SQL databases. • Created database maintenance planner for the performance of SQL Server, which covers Database integrity checks, update Database statistics and re-indexing.• Gathered report requirements and determined the best solution to provide the results in either a Reporting Services report or Power BI.• Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources. • Setting up Power BI Environment, creating app workspaces, publishing apps, and setting up Power BI Gateway.• Created complex Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.• Used Data manipulation language (DML) to insert and update data, satisfying referential integrity constraints.• Developing and maintaining/modifying complex T-SQL queries, stored procedures and SSIS packages to load the data into warehouse.• Designed and developed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet and flat files into SQL server 2016 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge, and union all.• Developed T-SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.• Created SSIS packages to retrieve data from Legacy sources and to retrieve user data from the Flat files on monthly and weekly basis.• Managed SQL user logins, database user accounts, server roles, database roles and its permissions. • Monitor SQL Error Logs /Schedule Tasks/database activity/eliminate Blocking & deadlocks user counts and connections/locks etc. Implement automated Index Maintenance strategy run as SQL Jobs daily.