Mohit Kumar Singh Email & Phone Number

Florham Park, Nj, Us

Florham Park, New Jersey , Us

Florham Park, New Jersey , Us

Florham Park, New Jersey , Us

• Leading a team of 20+ Data Engineers, assigning tasks and handling escalations.• Drive execution of Data Engineering, Big Data & analytics project for Financial services and Life Science domain. • Design and implementing large scale data loading, manipulation, processing solutions on Cloud platforms.• Validate and assess existing system implementation, and planned phases for migration.• Set and monitor performance goals, and objectives, including providing feedback through performance appraisals.• Mentoring the team members in learning and their day-to-day activities.• Handling delivery of the account and Projects.• Delivering Data engineering and Analytics solutions by owing data design, data extracts and transforms.• Analyzed the current ecosystem of the client and designed the architecture for end-to-end data lake migration.• Implemented batch jobs utilizing Apache Spark to convert Map Reduce jobs to execute Big Data Analytics Jobs.• Identified the services to be required for the migration based on the client’s requirements.• Implemented migration of data from HDFS to Azure Datalake Storage Gen2.• Conversion of Data pipelines from Sqoop to Azure Data Factory.• Implementation of Spark Scala code in Databricks.• Drive and establish a plan that meets expectations of management, execute the plan, make changes as needed, analyze project data and provide final report.• Establishing and implementing training processes for all technical personnel.• Holding regular technical team meetings to help address any questions or challenges regarding upcoming projects.• Recruiting and training future employees on Data Engineering Cloud Stack to fulfil posted positions within the technical department.

Florham Park, New Jersey , Us

Tools: Azure Data Factory, Databricks, Azure Data Lake, Power BI, Visual Studio 2017 , Python, Dataframe API, Spark, Scala, Nifi, Python, PySpark.Domain: Financial Services (Data Services Migration Project) Worked on designing the ADF Pipeline for migration Project from On Premise to Azure Data Lake. Worked on designing & implementation of SCD2 using Data bricks (Scala) in the Azure Platform. Worked on implementation of ETL jobs using Active Batch Server for the ADF Pipelines. Worked on implementation of Star schema Model in Azure Analysis Services Tabular Model. Worked on implementation of reporting side using Power BI & connecting to Azure Analysis Services. Worked on implementation of Machine Learning Models in Azure ML service workspace environment, and designing the automated workflow.. Handling Microstrategy BI Projects.

Zug, Ch

• Worked closely with other departmental peers to develop high availability solutions for mission- critical applications. • Collaborated with team members to create applications system analysis based upon client requirements. Performed all testing and troubleshooting methods and documented resolutions in the system. • Worked closely with customers to efficiently resolve issues. • Identified and suggested new technologies and tools for enhancing product value and increasing team productivity. • Implementing a business intelligence strategy within a global network. • Ensuring that all BI projects are successfully delivered on time and to the required professional standards. Design and Plan BI Solution Debugging, Monitoring and troubleshooting BI solutions. • Creating and deploying reports in using various BI Tools (Microsoft BI Stack, MicroStrategy 9.2 – 10.4, and Tableau 8.2 - 9.3). • Creating and maintaining relational and multidimensional databases. • Proficient in ETL (Extract – Transform – Load) using SQL Server Integration Services 2005 / 2008 /2012 (SSIS). • Hands-on experience in design and development of ETL solutions for data warehouses and data marts.• Hands-on experience on SQL Server Reporting Services to design Reports. Configuring, deploying and maintaining SSIS, SSRS, T-SQL codes, MicroStrategy dashboards and Tableau Dashboards. • Delivering SSRS reports using SharePoint. Read and interpret what the customer is saying to proactively identify potential issues and problems Advise the customer on best practice and be able to suggest and deliver product enhancements. • Working on Creating logical data models, recognize source tables and columns, to build MicroStrategy Schema objects including Attributes, Facts, Hierarchies and Relationships necessary to create MicroStrategy project. • Working on Migrations of Objects from one environment to Other Using Object Manager. • Implementing D3 & Vitara Visualizations (third party) into MSTR Web.

Zug, Ch

1. Working on migrating our exisitng BI Reports to Tableau.2. Working on Business Intelligence Microstrategy version 9.2.1/9.3.1Worked as a microstrategy analyst in a team of eight for design and development in the Wealth Brokerage and Retirement sectors for the Bank.Created logical data models, recognize source tables and columns, to build Microstrategy Schema objects including Attributes, Facts, Hierarchies and Relationships necessary to create MicroStrategy project.Experienced knowledge in different types of data modeling, like- star schema modeling, snowflake modeling.Created joins and relationship according to the data model Schema.Studied and modified the attributes, facts and hierarchies based on the requirement. Used MicroStrategy Desktop for creating various application objects.Extensively worked in developing Metrics, Filters, Custom groups and Consolidations for complex reports.Designed Templates and Filters to generate reports in grid and graph mode. Auto prompt filter feature gave end-user a choice of different filtering criteria each time they run the report.Used Transformations for comparative reports like claims this year to last year (year to date and month to date).Proactively created report formats.Created logical views in Microstrategy for complex report creations situations. Created advanced grid reports, consisting of data analysis by combining a template with filters. The end-users were able to generate ad-hoc report by drilling up, down, within and across dimension or anywhere.Used free form SQL editor for complex report creation.Fixed Defects and performed upgrades for existing projects. 2. Working on Microsoft Business Intelligence Platform using SSIS for ETL Process, and SSAS for cube development in Development and production enviourment, and creating repost and dashboards using excel and Microstrategy Web reporting, and Tableau for banks on Financial services domain.

East Rutherford , New Jersey, Us

Working on MSBI technology SSIS,SSRS,T-SQL on designing and deploying the SSIS packages and cubes in the development and production enviourment. Following the SDLC cycle for BI Implementation.

Murray, Utah, Us

Worked on Healtcare domain project on MSBI technology SSIS,SSAS,SSRS, T-SQL

Designing VBA applications with designing data models using visio and database designing.

maintenance of Applications, and designing and Maintenance of OLAP cubes and reports.

Bachelors In Computer Application, Computer Application

12Th, Computers, Maths, Physics

High School, Science In The Year 1999