Jitender Kumar Singh

Ø Have 7.2 years hands on experience in the software industry and proficient in Microsoft technologies such as MS SQL Server 2008, 2012 and Power BI, SSIS.

Ø Have over all 4+ years proficient experience in creating and building the dashboards in Power BI Desktop and very good in EXCEL 2010/2013.

Ø Proficient in designing/building complex stunning reports/dashboards using Filters (Slicers), Drill-down Reports, Sub reports and AdHoc reports in Power BI Desktop.

Ø Good in writing DAX queries/expressions in power bi desktop.

Ø Skilled at Sql DW using copy transformation/activity and knowledge in Data Analytics.

Ø Created multiple packages for implementing ETL by using various control flow & Dataflow items.

Ø Experience in creating the packages in optimized way, debugging (Data Viewers, Break Points) and deployment the packages in Integrated Servers.

Ø Experience in working with containers like For Each Loop Container, For Loop Container and Sequence Container.

Ø Experience in providing Logging, check points, packages configurations, error handling in SSIS.

Ø Worked with dimensional modeling and create star schema for the given system and good knowledge in development of Snow Flake Schema.

Ø Experience in providing the securities for reports/dashboards by assigning roles.

Ø Proficient in working with SQL Query Analyzer, SQL Server Management Studio and Business Intelligence Development Studio, Indexes and SQL Profiler.

Environment: SQL DW, Power BI, Power BI Service, SQL Server 2012, DAX, MS-Access Database, MS Excel

Description: This project provide different reports for making intelligent solutions based on data available in across the world wide connected over a period of time. The main objective of this project is to collect the data from different sources and dump into data warehouse once reach the requirements then build the dashboards as per client business logics.

Responsibilities:

Ø Responsible for developing and building the Reports/Dashboards.

Ø Responsible build data models and create reports.

Ø Responsible for deploying the dashboards into Power BI.com service(cloud based business analytics service)

Ø Responsible for creating SSIS packages to extract data from different sources consolidate and merge into one single source. (Control flow, Data flow (Transformations)).

Ø Responsible for performed performance tuning on SQL queries and stored procedures

Ø Responsible Enable error handling strategy i.e. transaction isolation to help rollback of transaction when package fails

Ø Responsible for creating calculated members, measures and named sets using Queries.

Ø Responsible for creating databases, tables, cluster/non-cluster indexes, constraints, views, stored procedures

Ø Design star, snowflake schemas in Analysis Services

Ø Responsible for Involved in creating the tables and their relationships in the data warehouse

Ø Responsible for create various files and database validation rules like schema validation, null file validation, invalid file format validation, duplicate file validation and database connection check validation

• Develop Complex Queries according client requirements
• Writing Complex T-SQL queries and sub-queries using complex Joins
• Developed Stored Procedures for storing and retrieving data through forms
• Has good experience in complete ETL cycle including data analysis, data mapping and Conversion and data load
• Experience in importing/exporting data between different sources like SQL/Excel
• Responsible for full cycle of reporting solutions from definition, design and implementation of the
• Data visualization solution
• Upload list on Sales force for Campaign Scheduling
• Cleaning unwanted/Junk Characters
• Atomize Manual Processes
• Suppress all unsubscribe and never mail customers
• Provide Ad-hoc Request and Reports before deadline
• Develop New Reports for Managements
• Develop and create upcoming New Processes for our Organization