Course1:Business Problem Solving & Data AnalyticsCourse2:PowerBI, ETL SSIS and DAX

Environment & Tools:MS Visual Studio 2017 (SSIS), MS SQL Server 2018, Transact-SQL, MS Visio, Jira, Confluence, Microsoft CRM 2013, Microsoft Dynamics Online, Azure ADF Pipelines.

Responsibilities: Developed and documented ETL tasks in confluence for data migration activities. Developed SSIS package for sourcing data from HIVE tables through SSH command and landed in local PDW for reporting. Captured and documented the requirements in Confluence and subsequently, delivered the report data through SSIS/Alteryx packages. Developed ETLs for extracting the competitor scraping data and load into the reporting platform. Queried Kafka streams, topics and created tables from the kafka streams using K-SQL to understand the customer feedback behavior using streaming events. Enhanced the features of the Walmart ticket processing system and rerouted the data flow by sourcing from transactional sources for better analysis rather than aggregated sources. Enhanced the current pricing reports written in SQL scripts with added functionalities and better reporting capabilities.Environment & Tools:MS Visual Studio 2013, MS SQL Server 2014, Apache Kafka, Transact-SQL, Alteryx, MS Visio, MS PDW, R Studio, Jira, Confluence

Responsibilities: Created functional, non-functional, reporting, security requirements and created technical Specs documentation. Liaise with the SMEs to prioritize the requirements and traction the project for the stakeholder approval. Conducted workshops with business to understand the reporting process, current pain-points and subsequently documenting them. Analyzed the DQ issues and applied best practices to address DQ issues within ETL. Created source target mapping for existing EDW sources as well as flat file sources. Created current and future state mappings based on the business process. Created entities in MDS and exposed them to be consumed by ETL and trained business users/SOP plan to carry forward to input reference data. Developed ETL from various data sources like Oracle, SQL db, Flat Files and build data validation logic to ensure there is no data gap. Modeled the data in SSAS and created PowerBI dashboard prototypes based on business feedbacks. Created paginated reports in SSRS by creating various datasets and measures inbuilt in SSRS report. Created R scripts for reading patient data(masked) and understand relationships between different explanatory variables to construct a health model prototype. Data mining using linear regression model, logistic and goal programming algorithms to understand the correlation and optimal resource allocation across different lab facilities. Analyzed the existing Alteryx workflows and documented the process flows to indicate the bottlenecks in data cleansing process. Created DAX statements in MS PowerBI to create business KPIs/measures.Environment & Tools:Microsoft SQL Server 2017, SSIS, Transact-SQL, Alteryx, MS Visio, Master Data Services (MDS), Microsoft Power BI, SSAS, SSRS, DAX, R Studio, MS VSTS.

Responsibilities:▪ Pitched in the dashboard versions of traditional paper-based reports to the SMEs and automated reporting process using alteryx and tableau.▪ Built reporting workflows, data extracts and dashboard samples of the existing paper-based reports.▪ Created ETLs to migrate data from different internal databases and subsequently modeled the data for reporting in SAP BO.▪ Optimized the existing workflows, VB Macros and SQL scripts resulting in run-time savings of 55 %.▪ Gather user requirements, investigate issues/variances and develop prototypes of reporting application model.▪ Lead JAD and brainstorming sessions with business and internal execution team while developing reports.▪ Created new reports and modified existing reports based on the business requirements in the SAP business objects.▪ Support the application support team during issues in report data and conduct extensive root cause analysis during data validation.▪ Created business process flows and data flows for the AR aging reporting and AR Deposits reporting.▪ End-to-End Support for Ad-hoc Reporting requests from other SBUs and business users.Environment & Tools:Alteryx Designer 11.3, Tableau 10.4, SAP Data Services, SAP Business Objects 4.1, Hyperion, MS Access, Netezza, Oracle CC&B, MS Visio.

Responsibilities:▪ Designed and developed BI reports to support reporting requirements for different internal lines of business. ▪ Identified/recommended sales promotions for different products based on regional store specific sales demands and historical data using Alteryx – Tableau.▪ Conducted requirements analysis, documentation, design, implementation and gap analysis of new applications/enhancements to existing ones.▪ Validated functional specifications by modelling business processes, STM and developing proof of concept (POC) prototypes.▪ Conducted workshops with relevant stakeholders to elicit requirements and documented them subsequently. ▪ Facilitated post implementation review meetings in order to seek continuous improvement. ▪ Developed and implemented customer data integration along with master data for consolidating various data sources/flat files into single location eliminating costly errors in accuracy and duplication.▪ Analyzed the performance scorecards of online and offline campaigns/promotions in terms of net sales and ROI using SSIS and tableau.▪ Designed solution for data capture, transformation and loading data into DW to support business KPIs reporting for various internal business lines.▪ Developed VBA-SQL toolkit to report detailed forecasts and information to identify changes or to determine their effect on replenishment activities.▪ Eliminated the bottleneck issues in Walmart ticket processing system [using VBA] thus leading to a 70% more efficient system and slashing the SLA time frame by half.▪ Developed dashboards, reports and KPI scorecards to support ongoing demand forecasting.▪ Designed and Developed MS Access(macro) database applications to analyze market/sales trends in selected regions/categories and report trends to the leadership.Tools:VBA, MS Access, Excel Macros, Teradata, SQL Server 2008, Alteryx 10.5.9, Tableau Desktop, SSIS, SSRS, IBM Reflection HOST Mainframe, Atlassian JIRA, MS Visio

Responsibilities:▪ Acted as SME on application knowledge and trained various banking concepts like Anti-Money Laundering and Payments to new joiners.▪ Trained new mentees within project/technical functions and assisted in knowledge management and to integrate trainees into the project team.▪ Conduct workflow analysis, define user requirements, identify issues and implement solutions.▪ Create system requirement documents and business requirement documents through continuous-iterative interaction with technology and business stakeholders.▪ Created data mapping for migrating data from different external sources into the in-house systems.▪ Developed process flow diagrams for a range of trade processes, and developed data process documentation for complex data flows within a multi-application platform environment using archived transactional data.▪ Facilitated requirements gathering workshops with business stakeholders to elicit business requirements both functional, non-functional and technical specs.▪ Facilitated daily stand-up meetings and weekly tech-review meeting with architect team.▪ Identify and resolve technical issues with the offshore team and make sure all the coding standards are practiced by doing Code review.▪ Assisted in developing data governance plan working alongside project lead.▪ Developed integration packages for data transfer from Oracle sources, DB2, FLAT FILES to SQL SERVER using DTS/SSIS.▪ Developed VB macros to create automated reports that are published in SharePoint on a regular basis.▪ Developed reporting solutions using Tableau, SSRS with 10 million records from multiple data sources and yet achieved faster processing.Environment and Tools: IBM DB2, SQL Server 2008, SSIS, SSRS, Version Control: Microsoft TFS, MS Visio, VBA, C#, MS Access, Excel Macros