Kumar Ranjan Email & Phone Number

Sydney, New South Wales, Australia

Gurgaon, Haryana, India

I am Technical Lead at Centric Consulting. We are a full-service management consulting firm based out of United States, over 750 strong focused on Business Consulting and Technology Solutions. Within the Data and Analytics service offering, I focus on BI Implementation for Tabular cubes(SSAS/AAS), Power BI, Power apps and I thrive in learning new things and training others across multiple technology platforms. Across the company we have a wide array of technology and customer vertical experience across a range of company sizes from the Fortune 100 down to a 2 person startup.

Noida Area, India

Worked in MIND as a data analytics with manufacturing as domain and SSAS and Power BI as tech stack over the tenure there .• Created SSIS Packages for Incremental Loading and slowly changing dimensions. • Dimension and Fact table design and cubes for KPI, Defining hierarchies and rollups.• Identified Dimensions and Facts, Used DAX extract data from cubes and Created DAX script for representing Cube Calculation.• Enhance SSIS packages to perform dynamic functionalities from static configuration and changed many of the packages • Created & modified TABLEAU reports depend on the requirement on the priority basis from the DW & BW bug tracker applications.• Worked on the performance and high priority critical issues to meet deadlines for SSIS package execution and for SSRS reports rendering.• Created usage-based aggregations in cube to minimize time for query retrieval from client tool Targit• Created Advanced Reporting Services Programming Using the Reporting Services Web Service.• Creating, Modifying SSAS Measures, Dimensions Attribute relationships and Hierarchies. • Designed SSAS Cubes, Named Calculations for Dimensions.• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.• Created Development and Production support documents.• Used Subversion for centralized storage within the Data Warehouse department.

Noida Area, India

Have worked here as a Data Analyst with expertise in SQL Server development, SSIS, SSAS ,Power BI and Tableau.Worked on and implemented the below :- • Star and Snowflake schema modelling in SSAS tabular and building report on the top of it.• Expertise in applying correct filters/slicers on the Power BI report based on business need. Experience in consulting with IT, Business Users & Business Analysts for building reports and dashboards based their needs. • Created ETL packages with different data sources ( SQL Server, Flat files, Excel source files) and loaded the data into target tables by performing various kinds of transformations using SSIS• Used Team Foundation Server as Source Control to store Packages, Reports and SQL Scripts and share it among team members. • Responsible for developing, monitoring and deploying SSIS packages.• Configured SQL mail agent for sending automatic emails when a SSIS package is failed or succeed. • Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).• Created Drill-through, Drill-down, Cross Tab Reports and Sub-Report using RDL.• Created queries for generating drill down reports in SSRS 2012. Formatted the reports using the Global variables, expressions and Functions.

Noida Area, India

Worked in Birlasoft as a Software Engineer on SQL Server development ,SSAS and Power BI• Actively involved in all stages of Software Development Life Cycle from requirement gathering to maintenance of databases. • Implemented one to one and one to many relationships between the tables in the database. • Identified and implemented the tables with Primary Key, foreign Key and Identity columns. • Created and manipulated the indexes for faster access of database tables. • Wrote several SQL Scripts to query the tables to enforce constraints on tables with Identity and Primary Key. • Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio. • Reduced the T-SQL overhead successfully by avoiding unnecessary use of the UNION, statement & using the TOP operator to limit the Select Statement in certain Queries. • Created views to use in SSAS tabular cube or for direct import to Power BI for report and dashboard construction.