Dheeraj Kumar

 DHEERAJ KUMAR G2/452, Sector - 4, Vaishali, Ghaziabad, 201010 Mob: - - E-mail (P): -- EXPERIENCE (14+ Years) Total of 14+ years of experience as a Lead MSBI, SQL Development & SQL Administration. PRESENT EXPERIENCE: I have been working with Tranistics Data Technologies Pvt. Ltd, New Delhi Since May 2014 to till date as Lead MSBI & SQL Administration. EMPLOYMENT STATUS From To Company Designation May 2014 Till Date Tranistics Data Technologies Pvt. Ltd. Lead MSBI & SQL Administration Nov 2009 May 2014 Alankit Assignment Ltd. Team Lead MSBI Aug 2005 Oct 2009 Alankit Technologies Ltd. Sr. SQL DBA & Developer Jan 2004 July 2005 Devanshee System SQL Developer TECHNICAL SKILL: RDBMS:SQL Server 7.0/2000/2005/2008R2/2012/2014/2016/2017 MS Access, Sybase SQL Server:Azure, SQL, T-SQL, Backup and Recovery, SSAS, SSIS, SSRS Oracle 9i:SQL, PL/SQL, DBA FUNDAMENTAL-1, Tools:SQL Management Studio, Profiler, Backup Utility, SQL LiteSpeed, IDERA, Excel Power View DevOps , GITHub Programming Language:SQL, .NET, VB6 Reporting Tools : Crystal Report, MS Excel, CSV, RDL, PDF, Txt, Tableau, POWER BI Operating System :Win 2k/NT/98/2003/2008/2012 TECHNICAL QUALIFICATION: Master in Computer Application (MCA) from IGNOU Bachelor of Computer Application (BCA) from IGNOU EDUCATIONAL QUALIFICATION: Enter Board (I.sc) from Bihar Education board. 10th Board from Bihar Education board. PROFESSIONAL SUMMARY 14 years of extensive experience in SQL Server database development/MSBI/administration, extensively worked in OLTP, OLAP environment & development databases as a MSBI/Developer/DBA in different domains of Fortune 500 companies including Insurance, Financial, Logistics, Supply and chain Industries. Hands on experience as Microsoft Azure, Devops And GitHub Hands on experience as Business Intelligence Developer and Data Analyst in Production, Development and Staging Environments. Strong Communication & Management skills with Excellent Role playing capabilities. Hands on Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2017/2016/2014/2012/2008 R2/2005/2000/7.0. Extensive experience in MS SQL Server 2017/2016/2014/2012/2008 R2/2005 Business Intelligence in MS SQL Server Analysis Services (SSAS), MS SQL Server Integration Services (SSIS) and MS SQL Server Reporting Services (SSRS). Good experience in writing MDX queries while creating and customizing Cubes using SQL Server Analysis Services (SSAS) 2005/2008/2012/2014/2016/2017. Experience in working with SSAS in creating cubes, data source views, named queries, dimensions and deploying of analysis services projects. Extensive Knowledge in SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL. Strong knowledge of Data Warehousing methodologies, concepts and implementation of star schemas, snowflakes schemas, facts & dimensions. Used Data Flow Tasks in Different Transformations like Lookup, Derived Column, data Conversion, Merge Join, Conditional Split, Union all, Script component, Aggregate and Sort & Execute SQL Task to load data into Data Warehouse. Hands of experience in huge data migrations, transfers and troubleshoot migration issues using utilities like Data Transformation Services (DTS), and SSIS, Bulk Copy Program (BCP) and Bulk Insert. Experience in BI Development and Deployment of DTS, SSIS packages from MS-Access, Excel, Oracle and SharePoint. Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages. Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations. Designing and Deployment of Reports for the End-User requests using Web Interface & SSRS. Extensive experience in Installation, Configuration and Deployment of SSRS using Scale-Out, Scale-Up and Local topologies. Experienced in database administration for MS SQL Server databases, and supported applications with efficient back-end processing. Extensive experience in controlling the User Privileges, Monitoring the Security and Audit issues as per Standards. Expertise in Performance tuning, Optimization, Data integrity and Statistics by using SQL Profiler. Experience in solving Real Time issues with Index fragmentation, DBCC checks, Query Tuning, Error and Event Handling. Expertise in SQL Server Storage Structures and Security Architecture for databases residing on SAN storage. Experienced in programming tasks- Stored Procedures, Indexed Views, User Defined Functions, Triggers, and Distributed Transactions using SQL Server 2017/2016/2014/2012/2008/2005/7.0 with T-SQL. Experienced in SDLC life cycle for Design, Development and Staging phases of the projects with support of Data-Flow, Process Models, and E-R Diagrams. Working knowledge of .Net Framework 3.5 (VB.NET and C#.NET), IIS Web Server. Project experience Company Name: Tranistics Data Technologies Pvt. Ltd.Jun 2014 – Till Date Position: Lead SSAS/SSIS DEVELOPER Project: Transportation Management System (TMS) Client: nVision Global, Atlanta, USA Date: Jun 2014 – Till Date Location: New Delhi, INDIA Tools/Environment: SQL Server 2017, Microsoft Azure Role: Lead SSAS/SSIS Developer Description: A transportation management system (TMS) is a subset of supply chain management (SCM) that deals with the planning, execution and optimization of the physical movements of goods. In simpler terms, it's a logistics platform that enables users to manage and optimize the daily operations of their transportation fleets. Responsibilities: Gathered user requirements. Responsible for Analysis and implementation for DB changes requested by users. Developing reports using efficient data retrieval techniques Updated functional specification and technical design documents. Studied the existing OLTP system(s) and Created facts, dimensions and star schema representation for the data mart Developed Analysis Services Project. Responsible for identifying and defining Data Source and Data Source views. Created cubes and defined the dimensions. Defined attribute properties in a Parent Child Dimensions. Responsible for hiding and disabling attributes hierarchies. Sorting attributes members based on a secondary attribute. Defining relationships between Dimensions and Measure groups. Involved in the design and development of the SSAS cubes and MDX queries Specifying the named sets for calculations using named queries. Responsible for creating reports based on the requirements using SSRS. Identified the database tables for defining the queries for the reports. Defined report layouts for formatting the report design as per the need. Identified and defined the Datasets for report generation. Wrote queries for drill down reports to get the dataset required to build the report. Identified and included report parameters for parameterized report. Formatted the reports using Global variables and expressions. Deployed generated reports onto the Report Server to access it through browser Monitoring the growth of database to ensure smooth running of daily activities. Providing On call production support Importing Source/Target tables from the respective databases by using Execute Package Task using Control Tasks in SQL Server 2017 Integration services. Developing SSIS packages using wide variety of transformations to implement the end user business requirements. Deploying SSIS packages to SQL server using Integration Services Deployment Wizard. Designing and maintaining of SSIS packages for data transferring between heterogeneous data sources Used Control Flow Tasks like For Loop Container, For Each Loop Container, Sequential Container, Execute SQL Task, Email Task, and Data Flow Task Used Data Flow Tasks In Different Transformations like Lookup, Derived Column, data Conversion, Merge Join, Conditional Split, Union all, Script component, Aggregate and Sort & Execute SQL Task to load data into Data Warehouse Developed reports with consistent drill-down functionality including Drilldown report and Summary report. Ensured constraints and writing triggers/linked server scripts to apply the business rules. Performance Tuning, Backing Up & Restoring User Databases. Company Name: Alankit Assignment Ltd.Nov 2009 – May 2014 Position: Lead MSBI DEVELOPER Project: e-Governance Projects (TIN/PAN) Client: Alankit Assignment Ltd., New Delhi, India Date: Aug 2010 – May 2014 Location: New Delhi, INDIA Tools/Environment: SQL Server 2012 Role: Lead MSBI DEVELOPER Description: e-governance TIN Digitization is A Complete Solution to maintain complete tracking of physical form to digitization data and uploading to NSDL server and complete tracking of document management system. Responsibilities: Creating SSAS Cubes and Dimension modeling Creating Dimension, Measures, Facts, calculated members Generating OLAP Reports Using SSAS Analysis services cube development Creating various type of reports like linked reports, Drilldown, cascading etc. Experience in DTS for data flow from one source files like Excel, Tables, and Views to other databases or files with proper mapping. Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task and Data Flow Task etc to generate Reports like Attendance, Payroll, Abilities, Rates and Rule Enhancements etc. Migration is also done using Bulk Insert and dynamically created queries in the job steps. Implemented complex business requirement in backend using efficient stored procedures and flexible functions, and facilitated easy implementation to the front end application Strong knowledge on creating stored procedures and packages. Involved in Enhancement and Maintenance of the application. Project: Healthcare Management System (TPA) Client: Alankit Assignment Ltd., New Delhi, India Date: Nov 2009 – May-2014 Location: New Delhi, INDIA Tools/Environment: SQL Server 2008R2/ SQL Server 2012 Role: MSBI DEVELOPER Description: TPA is A Complete Solution to Maintain Systems, benefit administration, Policy and claim processing software for healthcare. Claims can be scanned from Central TPA or Remote Sites through DMS. Responsibilities: Collaborated with a cross-functional team of developers, project managers, product owners and quality assurance to report and mitigate project risks and ensure timely delivery of the product. Worked closely with the Business users and warehouse team to understand the requirements and analysis. Responsible for task identification, work effort estimates and work schedules for the development. Created project Unit Test Plan, Technical Design Document, Defect Tracker etc to ensure quality deliverable. Responsible for estimation and finalizing testing scope. Responsible for the Creating/change in packages/cubes/Reports. Performed Unit and Integration testing of the SSAS cubes and SSIS Packages and involved in troubleshooting. Developed procedures in database using SQL. Creating schedule batches for tasks. Involved in Ticket Generation project to resolve critical issues in predefined release. Company Name: Alankit Technologies Ltd. Aug 2005 – Oct 2009 Role: MSBI DEVELOPER Project: Share Pro Management System (RTA) Client: Alankit Technologies Ltd., New Delhi, India Date: July 2007 – Oct 2009 Location: New Delhi, INDIA Tools/Environment: MS SQL Server 2005/2008R2 Role: SQL DEVELOPER Description: Sharepro calculates all the client’s payables and receivables and generates each client’s limit that offers services in Financial Services with Annual Total Turnover of 10-100 Crs. Responsibilities: Creation of database, tables, constraints, procedures, triggers etc. Administering the development database. Carrying out backup and recovery scripts and monitoring the backup processes. Created complex DTS Packages for Data Migration and Transformation. Experience in data migration from Oracle/Access/Excel Sheets to SQL Server 2005/2000/7.0 Also created SSIS Packages for Analyzing Data Warehouse. Defined many Cubes for reposting too. Monitor database performance and identify problems and improvements. Maintaining Database Security through user roles. Project: Medical Inventory Management System (MIMS) Client: Alankit Technologies Ltd., New Delhi, India Date: Jun 2006 – Nov 2009 Location: New Delhi, INDIA Tools/Environment: MS SQL Server 2005 Role: SQL DEVELOPER Description: MIMS is A Complete Solution to Maintain Medicine Stock Register Responsibilities: Creation of database, tables, constraints, procedures, triggers etc. Have written many DTS, SSIS Packages for Data Migration Created complex DTS Packages for Data Migration and Transformation. Experience in data migration from Oracle/Access/Excel Sheets to SQL Server 2005/2000/7.0 Creating Linked reports ,Drilldown using SQL Server Reporting Services 2005 Managing report and report files using report manager and report configuration tools Designing and developing SSIS Packages using various transformation like Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction SSIS packages performance tuning. PERSONAL DETAILS: Date of Birth:25th Nov, 1980 Father’s Name:Sri Deo Prasad Singh Marital Status:Married DATE: PLACE: (DHEERAJ KUMAR)