Jitesh Parwal

Associate Software Engineer, Accenture March 04, 2014 - May 03, 2016 Software Engineer -1, MAQ Software May 04, 2016 – Jan 19, 2018 Software Engineer, Sapient Mar 19, 2018 - Current PROFESSIONAL EXPERIENCE ~5 Years Roles and Responsibilities Worked in Agile environment as Data warehouse, Business Intelligence and ETL developer for marketing data of a tech giant based out of US Created ETL using sqoop and shell script to fetch data into Hadoop from different sources Used different connectors such as Impala and Spark to connect PowerBI and Hadoop/HDInsight and developed reports. Handled millions of rows using aggregation feature in PowerBI Implemented Incremental Refresh in PowerBI Premium Designed and developed PowerBI reports, PowerPivot models for Sales Data of a tech giant Implemented row level security in PowerBI Blended data from multiple sources to create interactive dashboards in Power BI desktop Created calculated columns, measures and time/date related columns utilizing DAX in Power BI desktop Published reports on to respective workspaces in Power BI services Scheduled data refreshes in Power BI services utilizing data gateways to automate process Installed gateways on server to fetch on premise data to PowerBI service Did POC to embed PowerBI report using Iframe, native app method and embedded capacity. Have designed complex models in PowerBI Architecture PowerBI end to end solution Worked on PowerBI Rest API and PowerShell to automate refresh and other tasks Worked on Hadoop and HDInsight to create PowerBI reports Trained more than 5 resources in and out of organization Fetched data from Azure Cosmos Database and Azure blob to Azure Data lake using Azure Data factory Processed unstructured data to table structured into Azure data lake analytics by writing u-sql Created Azure data factory to fetch data from Azure data lake to On-Premise SQL Layer Written PowerShell scripts to deploy Azure solution online Scheduled pipelines to automate data refresh Designed and developed ETL packages to extract data from multiple data sources Worked on ETL to cleansing data and processing data through different methods Worked on ETL to create different packages and integrating into jobs Worked on SQL to process data at Mart level Worked on SQL to optimize stored procedures and to gain max throughput Configured SQL Server 2016 and hosted SQL databases Created reporting layer cubes using SSAS Created macros based excel for automatic refresh of Excel Reports Created calculated measures by writing MDX and DAX Worked on dynamic partitioning and aggregation to improve cube performance Implemented data masking in cube Have hands on experience in Pentaho, MicroStrategy and pivot4j. Created jobs to schedule daily refresh of databases. Worked in SharePoint Online to enhance UI reports Migrated UI reports from SharePoint on premise to SharePoint Online 2013. Configured Release Management Online and deployed on different environments Analyzed user stories and created design documents to cater to the reporting teams/client requirements Migrated code base from TFS to GIT. Hands-on experience in GIT repository for maintaining large code base Created Build Verification Test cases (BVT), Functional Verification Test cases (FVT) and automated the test cases using scheduled jobs to detect any failures Worked on Visual Studio Online (application management tool) for logging efforts, creating tasks and issues. Attended daily scrum meeting to deliver progress of the project work Handled daily meetings as scrum master to gather requirements from Redmond POC and solving issues Delivered 5+ projects from scratch to reporting Certification Introduction to Computer Science CS50x1, Harvard university, Edx.org Business Intelligence, University of Colorado’s, Coursera.org Design and Analysis of Algorithms, Standford University, Coursera 70-461 (Microsoft SQL Server- (Microsoft SQL Server- (Developing SQL Databases) 70-767 (Microsoft SQL Server 2016 Data Ware House) 70-768 (Developing SQL Data Models) 70-774(Azure Machine Learning) 70-778 (Developing dashboards using PowerBI) Computer Hardware & Networking Management - July2013 Languages and Technologies SSIS (ETL), T-SQL, Pentaho Hadoop, HDFS, Spark, Impala and Hive PowerApps Data Warehouse, SSAS (Tabular and MultiDimensional) PowerShell Scripting Azure Data Factory, Azure Data Lake PowerBI, Tableau, Advanced Excel, Microstratgey MDX, DAX HTML, CSS, JavaScript, SharePoint Online Data structure and algorithms Core Java, C#, C Versioning Tools: Git-Hub and Team Foundation Services (TFS) Power BI Tools: Visual Studio 2015, SQL Server Data Tools 2015, SharePoint Designer, Pentaho, SSMS, MicroStrategy, SAP, Pivot 4J Agile Methodology Networking in Linux and Windows V Model Industry Projects Sales Insights (April 23, 2016 – June 30, 2016) Client: US Client (Tech giant) Environment:T-SQL, SSIS, TFS, SharePoint Online Methodology:Agile Role: UI Developer, SQL Developer, Manual Tester, ETL Developer Marketing Insights (June 30, 2016- July 31, 2016) Client: US Client (Tech giant) Environment:SharePoint On Premise, SharePoint Online, PowerBI Methodology:Agile Role: UI Developer, Manual Tester Managed Partner Reporting (August 1, 2016 – October 31, 2016) Client: US Client (Tech giant) Environment:T-SQL, SSAS, SSIS, GIT Methodology:Agile Role: Full Stack Developer, Manual Tester Hosting BI (October 31, 2016 – March 31, 2017) Client: US Client (tech giant) Environment:T-SQL, SSAS, SSIS, GIT, PowerBI, PowerPivot Methodology:Agile Role: POC, ETL Developer, BI Developer OCP (March 31, 2017 – Sep 31, 2017 ) Client: US Client (tech giant) Environment:T-SQL, SSAS, SSIS, GIT, PowerBI, PowerPivot Methodology:Agile Role: Full stack developer (ETL, SSIS, SSAS, PowerBI) Referral data stage (October 01, 2017 – Jan 19, 2018) Client: US Client Environment: Azure Cosmos Database, Azure Data Lake, Azure Data Factory, Azure Blob Storage, PowerBI Role: Lead (Offshore), Developer Cosmos (Apr 01, 2018 – Current) Client: US Client Environment: Azure HDInsight, Hive, PowerBI Role: Lead (Offshore) Inventory Planning (June 01, 2015 – April 23, 2016) Client: AT&T Environment:SAP Methodology: V-model Role: BI developer Industry Achievements Got Outstanding performance Award in Accenture foundation training program Got Star of the month award in MAQ Software Got outstanding performance award in Sapient within first 2 months Academic Project SMS & E-mail Alert Notification System (Jan 14 – May 14) Technology: C#, MS-Access Description: It is a single desktop application which takes all required data from admin to record details of course, departments, staffs & students either manually or by importing an excel sheet. Then it filter database according to need & requisites of college administrator & alert all filtered candidates either by mail or by SMS through a GSM Modem Device. Role: Team Lead, C# Developer Linux Server Configuration (Sep 13 - Dec 13) Technology: Red Hat 6.2 Description:Client required complete automated server configuration, with just a simple Text-based user interface (TUI) software which configures the basic servers (DHCP, FTP, SAMBHA, YUM) for a simple use & implements security. Role:Server Configuration Strengths Flexible to adopt new environment and technologies Initiative and ability to lead a team. Welcoming attitude towards new challenges. Quick at work and manage time efficiently to meet deadlines. Workaholic and dedicated to work ACADEMIC PROFILE B.Tech(CSE- Govt. Engg. College, Ajmer 66.67% Class XII (PCM) 2010 Kendriya Vidyalaya 75% Class X 2008 Kendriya Vidyalaya 87.8% Place: Noida Jitesh Parwal