RADHIKA GUPTA

Chicago,IL Looking for H*B transfer 708-***-**** adfhs0@r.postjobfree.com LinkedIn SUMMARY:

A technical developer with four plus years of professional experience in Data analytics and ETL development. Proficient knowledge in data transformations, statistics, data reporting and database development. Experienced in migration of data using ETL tools. Worked in manufacturing, pharmaceutical and retail domains.

PROFESSIONAL SKILLS:

Languages/Scripting:

Databases/ ETL Tools:

Reporting/Data analytics tools:

Cloud Platforms:

SQL, Shell scripting, R, Core-Java, Python

Oracle, Ab-Initio, Talend, SQL Server

Tableau, Micro-Strategy, Qlik-View, Excel

Amazon Web Services (EC2, RDS, SNS, SQS, S3,Redshift) EDUCATION:

MS in Information Technology & Management

Illinois Institute of Technology GPA: 3.6 Duration: Aug 2015- May 2017 BTECH in Computer Science

Punjab Technical University, India GPA:3.9 Duration: Aug 2010- May 2014 EXPERIENCE:

Wavicle Data Solutions Chicago, IL

Project 1: Next Gen Transaction Detail Analysis (NGTDA) Title: Data Analyst Client Name: McDonald’s Duration: June2019-April2020 Description: Business Intelligence team wants to see 360 view for store level transactions, orders, sales, menu items details for enhanced reporting. Our team build Talend jobs to combine data from various sources to develop store-level transaction records for analysis. We designed a process to gather raw data (XML files) from various sources in S3 buckets and then clean it using map reduce code and processed the clean data in Talend jobs to achieve analytic view for sales transaction.

• Created complex dashboard using parameters, sets, groups, and calculations and drill down and drill up in worksheets and customization using filters and actions.

• Developing various tableau dashboards prototype for the future uses and conversion of current excel reports into tableau.

• Developed Tableau reports geographically for calculating most-sellable products in a particular region.

• Interacted with business stakeholders to understand their decision-making parameters, analyzing the available data to build Tableau Dashboards and managing the delivery.

• Involved in designing physical and logical data models to implement 360 view of transaction.

• Extracted XML files from Hadoop and AWS S3 and created Sales Reports in Tableau for predicting maximum sales in a region.

• Involved in reviewing business requirements and analyzing data sources from Flat file, Excel, SQL Server for design, development and analysis projects within Tableau Desktop.

• Developed and reviewed SQL queries with use of joins clauses (inner, left, right) in Tableau Desktop to validate static and dynamic data for data validation.

• Published the developed dashboards into production and refreshed the scheduled extract, tuned the performance of the dashboard, and created tableau functional design document. Technology Used: Talend, SQL, S3, Redshift, Excel, Tableau, Unix, PuttyGen, WinScp,PySpark,Databricks Project 2: Talend Upgrade from 6.5 to 7.1

Title: ETL Data Analyst Client Name: True-Value Duration: April2019-June2019 Description: TrueValue is a hardware wholesale store. Aim was to create a website where buyers can see detailed view for all hardware products and can order directly via website. Project was to create reports for business to maintain track of sales, discount, and products for different buyers and stores in Talend.

• Worked with business analysts and other stake holders to understand business/system requirements to design and develop effective solutions for fetching data from different API’s.

• Created Projects in TAC and Assign appropriate roles to Developers and integrated SVN (Subversion)

• Worked on migration of data from Talend 6.5 to Talend 7.1.1. Was responsible for handling an offshore team and communicating requirements to them.

• Worked as a team leader for handling an offshore team. Was responsible for completing the project on deadline.

• Created test cases for Talend (6.5,7.1 version) and worked on modifying jobs in Talend 7.1.1 to perform same functionality as 6.5

• Created data dictionary for Active Dash – a reporting tool. Working on fetching data from Point of Sales system API’s.

• Led weekly project status meeting with both client and project team to track progress towards established milestones.

• Performed migration of mappings and workflows from Development to Test and to Production Servers.

• Development and modifications of mappings according to the client requirements related to the data flow. The objective is to extract data stored from different sources (web search engine, xml files, ftp servers) and to load finally into Talend Technology Used: Talend, SQL, Excel, Putty, SQL Workbench, FileZilla, Oracle, SQL Server. Garan Inc. New York, NY

Project: Extraction of data from Walmart dashboard to SQL Server Duration: Sep 2018 – Dec 2018 Title: SQL data developer/Tableau developer

Description: Project was to perform inventory management reporting in SQL by creating a SQL database to automate reporting. Our team increased the sales of baby department clothes by 7% in two months. Earlier they were using Visual Basic scripts to gather data. Our team took the initiative to move to Tableau.

• Created database for my team by fetching queries from Walmart Retail Link (analytical platform) in SQL.

• Extracted data from Walmart dashboards and loaded into SQL Management Studio and performing ETL operations using SSIS tool

• Was responsible for building tools in Excel and SQL server for distributing 500 SKU’s to various Walmart Stores.

• Analyzed sales and forecasted information to manage and maintain optimal inventory levels at the chain/store level using RIM system (Retail Inventory Management) using SQL Server and Excel.

• Conducted Design reviews with the business analysts and the developers to create a proof of concept for the reports.

• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.

• Implemented a new system for tracking containers overseas and increasing visibility by 60%.

• Identified, analyzed, and interpreted trends or patterns in large data sets.

• Processed detach and cancel manufacturing orders, also changing, canceling, and adding part numbers to manufacturing orders.

• Collected various data for the creation of KPI metric reports for the efficient tracking of company metrics, and produced specific reporting based on needs.

• Implemented customer dataset to visualize data in Tableau for monthly report Technology Used: SQL Server 2008, SSIS,Excel, Tableau Concepts IT New York, NY

Project: Migration of Data from Blue Analyzer to Micro-Strategy 10.5 version Title: Micro-Strategy Report Develoepr Client Name: Tory Burch Duration: May2018-Sep2018 Description: Project was to see 360 view of customers example their purchase history, contact details etc. for detailed analysis. CRM team wants to automate the process of emailing customers latest campaigns and ads for different products. Earlier data was stored in terms of purchase history but now we need to modify ETL jobs to produce data gathering all customer data from various sources like salesforces data, XML data and Custora and SQL database.

• Worked with CRM managers to gain knowledge of processes for getting an idea of data flow in the project.

• Worked with ETL teams as an ETL tester to develop test cases of ETL development jobs in Informatica for testing business requirements.

• Used SQL extensively to pull data to perform reports on inventory management and procurement to figure out top product in last year by getting data information from Sales.

• Writing test plan documents according to BRDS and performing unit testing on the data. Built reports on inventory management.

• Analyzing the data to figure out top customers. Worked with senior data analyst to write strategies for reward program.

• Conducting meetings with ETL, IT, marketing and QA departments to analyze the current requirements of project. Prioritizing and defining critical and non- critical tasks in UAT tracker document to complete project on time. Worked as end-user to perform UAT testing to ensure that application works according to business requirements.

• Designed the required Data Model which is compatible for the Micro-strategy Reporting System.

• Conducting Gap Analysis and recommending changes to Data model for updating required Business reporting.

• Translating customer requirements into technical design documents with specific solution and directing programming and User Acceptance Test.

Technology Used: Micro-Strategy, SQL, Excel, Blue Analyzer, Jira Bitwise Inc. Chicago, IL

Project: Migration of data from Ab-Initio to Talend 6.3 Title: ETL Data Analyst Client Name: Walgreens Duration: Oct 2017-March 2018 Description: Project was to implement 360 view of customers, stores, and transaction details for enhanced reporting. In ab-initio customers data was not mapped with store and transaction data. Gathering customer data from different sources and then mapping it in Talend ETL jobs increased the sales of BI team by 9% a year.

• Worked closely with all levels of management to maintain reports and systems to effectively analyze, improve, track and evaluate departmental performance. Performed A/B testing of data by gathering data in Talend and AB-Initio

• Involved in reviewing business requirements and analyzing data sources form Excel/Ab-Initio/Talend for design, development.

• Designed mapping logic in Talend by reviewing ETL development jobs on production server in AB-Initio.

• Identified errors in data to ensure accurate reporting in Tableau and used Excel to compare data from different tools for checking missing data.

• Document flowcharts for the ETL (Extract Transform and Load) flow of data using Microsoft Visio and create metadata documents for the Reports.

• Assisted with use-case, test-case development along with encouraging business users to participate in UAT.

• Involved in designing the procedures for getting the data from all systems to Data Warehousing system.

• Worked on Context variables and defined contexts for database connections, file paths for easily migrating to different environments in a project.

• Implemented Error handling in Talend to validate the data integrity and data completeness for the data from the Flat file.

• Involved in migrating objects from Dev to QA and testing them and then promoting to production.

• Responsible for developing, support and maintenance for the ETL using Talend integration suite. Technology Used: AB-Initio, Shell Scripting, Talend, Excel, JIRA, WinSCP Data Modeler Wekaw Technology (Chicago, IL) May 2016-Dec 2016 Description: Project was to design an e-commerce website in PHP for 24-hour emotional support service. It is service where customers can connect with therapists online and buy packages online to connect them via phone, in-person meet or email.

• Database Development: Designed the database of company from scratch in PostgreSQL like creation, insertion, deletion of tables.

• Data Modeling: Designed ERD model, flow chart of database and UML diagrams using MS Visio according to changing patterns in company. Worked on TwilMl development using Twilio services to set up a call arrangement for company.

• Google Analytics: Used Google Tag Manager and AdWords to optimize the company website.

• Translated the business requirements into workable functional and non-functional requirements at detailed production level using Workflow Diagrams, Sequence Diagrams, Activity Diagrams and Use Case Modelling.

• Developed and maintained data dictionary to create metadata reports for technical and business purpose.

• Created data model with required fact and dimensions. Technology Used: PHP, MS Visio, TwilML, Google Tag Manager, PostgreSQL Data Analyst/ETL SS Hitech (India) Jan 2014-June 2015

• Analyze data sets and trends for anomalies, outliers, trend changes, and opportunities and created Microsoft Access reports for management.

• Developed Ad-hoc and analytical reports on monthly basis depending upon business requirements in SQL and Excel. Performed data cleaning, slicing and dicing of data using R and Excel Pivot tables, V-lookups.

• Defined key facts and dimensions necessary to support the business requirements along with Data Modeler.

• Analyzed and extracted relevant information from large amounts of both structured and unstructured data to help automate and optimize key processes.

• Analyzed problem and solved issues with current and planned systems as they relate to the integration and management of order data.

• Analyzed reports of data duplicates or other errors to provide ongoing appropriate inter-departmental communication and monthly or daily data reports.

• Monitored for timely and accurate completion of select data elements.

• Collected and evaluated market data and built dashboards to gather competitors’ intelligence, determine which products to purchase based on profitability.

• Extensive data cleansing and analysis, using pivot tables, formulas (v-lookup and others), data validation, conditional formatting, and graph and chart manipulation.

• Create visually impactful dashboards in Excel for data reporting by using pivot tables and VLOOKUP

Contact this candidate