Vicky Kumar

Immediate joining (SQL | T-SQL | Power BI | DAX | ETL | Advanced Excel)

Role
Associate Consultant at Capgemini
Location
Delhi, IN
LinkedIn followers
500 followers
Information TechnologyView LinkedIn profile

About Vicky Kumar

Associate Consultant 6+ years of experience of Advanced Excel, Power Bi and SQL Server Development in SQL Server 2019 with an emphasis on design, development. Created Databases, Tables, T-SQL Stored Procedures, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures. Very good experience in BI development Server Integration Services (SSIS) Creating SSIS packages using various transformations, CDC in Script Task, SCD, Configuration, Deployment, Scheduled the packages to keep extracting the data from. I have work on different domain like Banking, Retail Creating report, Dashboard using Power BI.

Experience

  1. Associate Consultant

    Capgemini

    Apr 2022 — Present · Gurgaon, IN

    Responsibilities Created Databases, Tables, T-SQL Stored Procedures, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures. Extracting huge data from different sources by writing stored procedures and Creating report, Dashboard, Data Visualization using Power BI. Connect power Bi to different data sources, import data and transform data as per project requirements. Good Knowledge of DAX Query, Cleaning the Data on Power Query Editor. Data cleaning, data visualization, Date function, Text function, Conditional formatting, visualization formatting. Using different types of Filters like Drill Through, Page on filters, page all filters, page navigation, Slicers, Updating and maintaining reports. Using Different types of DAX function, Calculated column, or calculated measures Bookmark, RLS function, Publish the reports on workspace. Preparing daily, weekly & monthly reports. SQL server Integration Services (SSIS) Creating SSIS packages using various transformations, CDC in Script Task, SCD, Configuration, Deployment, Scheduled the packages to keep extracting the data from Data source. Regular communication with clients for Query Resolution & Status Updates. Take responsibilities to finish the assigned work timely in order to meet deadlines. Interaction with clients through Email and call.

Education

  • Dr. B. R. Ambedkar Bihar university

    Bachelor of Business Administration - BBA, Accounting and Business/Management

    2012 — 2016

Find verified contacts for anyone on LinkedIn

Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.

Free plan included · No credit card required

This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.

Vicky Kumar — Associate Consultant at Capgemini in Delhi, IN | Unifers