Arun Singh Email & Phone Number

India

Maharashtra, India

Mumbai Area, India

1. Extensive experience as a solution architect for business information systems, focusing on database architecture, data modelling, data analysis, software design, programming and application integration.2. Very good knowledge of Data Warehouse/Data mart concepts and Expertise in data modelling for OLAP & OLTP systems from design and analysis to implementation including the conceptual, logical and physical data models.3. Experience with Relational and Dimensional data modelling, understanding of, Star and Snowflake Schemas. Thorough understanding of DW concepts like Facts, Dimensions, Surrogate keys, drill down and drill across approach.4. In-depth knowledge of large database design techniques; experience in data analysis, data cleansing, data transformation and migration using SSIS.5. Design and develop the technical/functional specification for ETL development and implement using SSIS. 6. Analyse dependencies for workflow for various ETL processes, handle exception, and maintain logs.7. Parsing, merging and processing the data and putting them into Azure SQL warehouse using python based apache spark modules.8. Designing and developing reports, Sankey charts, dashboards, KPI and tiles using Power BI.9. Generating various health reports (dashboards, drill through reports, Built different kind of reports using SSRS like parameterized reports, Ad hoc reports, Drilldown reports, Drill through report, master detail relationship reports)10. Managing users groups and security in the Azure platform.11. Requirement gathering, estimation, end-to-end project lifecycle management, and Implementing best practices & standards.12. Automated the deploying process of the embedded power bi reports through power shell script.Tech Stack:Processing Frameworks: Apache Spark, Apache Yarn, Azure Data factory, Azure HDinsightDatabase: Azure data warehouse, MS SQL 2016/2012/2008R2Languages: Python, Shell ScriptingReporting: Power BI

Mumbai Area, India

1. Designed, developed, implemented, and maintained business intelligence semantic layers and reporting solutions in an enterprise environment.2. Assisted in the development and implementation of data warehouse and data marts.3. Designed SSIS package that extract financial data from a SQL Server Database by using Lookup task, Foreach Loop Container. Used the slowly changing dimension task and its accompanying wizard to load a new dimension.4. Provided data validation, data cleansing, data transformation as well as writing and scheduling complex ETL jobs.5. Created and/or upgraded Structured Query Language (SQL) stored procedures, tables and queries.6. Designing and developing end to end BI solutions like design and developing KPIs, scorecards, dashboards based different use cases.7. Partnered with project manager, dev manager, and business owners to proactively understand ongoing projects (business and technical changes) and identify project impacts on BI.8. Built different kind of reports using SSRS like parameterized reports, Ad hoc reports, Drilldown reports and Drill through report.9. Improved the performance of existing SSRS reports. Ran the stored procedure from SSMS and viewed the query, checked and eliminated unnecessary joins, unneeded selected columns etc.10. Published reports on to SharePoint instance and created Web Parts in SharePoint to show various reports generated from SSRS and Excel in one page.11. Responded to daily ad hoc reporting requests from various organizational teams.12. Refreshed, reviewed, updated, and enhanced weekly worldwide detailed management information reports.

Mumbai Area, India

1. Requirement gathering, estimation, end-to-end project lifecycle management, and Implementing best practices & standards.2. Helped team in designing the data warehouse schema and database objects.3. Designed SSIS package having logical workflow that extract data from different channels like CQ, TFS, SAP-PPM and Jira.4. Designed and implemented stored procedures views and other application database code objects.5. Maintained SQL scripts indexes and complex queries for analysis and extraction.6. Developed and deployed many SSRS reports on reporting server and SharePoint.

Mumbai Area, India

• Implementation architect of SharePoint 2007 to SharePoint 2010 in 2011.• Part of Implementation team of ASP.Net based web-accessible reporting system for our customers to obtain information and reports regarding the status of their Diebold services.

Pune, Maharashtra, India

1. Assisted team in developing custom field types and field controls, custom list definitions, and site columns.2. Developed many SharePoint type definitions, templates, custom features, and web parts.3. Developed event receivers, themes and application pages, and custom content types.4. Custom site definition.5. Feature stapling, web templates.Tools &TechnologiesASP.NET 2.0, C#, MOSS 2007, and SharePoint designer 2007

Mumbai, Maharashtra, India

Over the next one year, we developed the portal into a secure intranet portal. As we were new, a lot of research was required to put in place new features and additional functionality. This was a truly enriching experience and this was the period where I gained exposure to a varied range of technologies.1. Requirement Analysis.2. Designing & developing various screens in InfoPath.3. Created Web service for sending and retrieving data from database and InfoPath forms.4. Created Image uploading custom control.5. Implemented many business-related workflows through SharePoint designer 2007.Technologies involved – SharePoint 2007, Web Programming (HTML, CSS, ASP.Net, JavaScript), XML/XSLT

Pg Diploma In Advanced Computing (Pg-Dac), Computer Programming, A Grade

B.E, Mechanical Engineering, First Class

Diploma, Mechanical Engineering, First Class

This was my diploma course in mechanical engineering. Here, I learned machine design, Strength of Material, Metallurgy, Dynamics.