SHEETAL SHAH

Data Analyst, Data Architect, Data Analytics & Visualization,

Business Intelligence Analyst, Product Owner

Naperville, IL 60564 - 630-***-**** (C) - ad3lqn@r.postjobfree.com

www.linkedin.com/in/sheetal-shah-6bb958283 - Status: US Citizen

Technical Skills:

BI tools/ Visualization tools : Tableau, Microsoft Power BI, Qlik Sense, SSRS, Crystal Reports

ETL Tools : Alteryx, SSIS

Databases : MS SQL server, Oracle 8i, MS Access.

Programming Languages : Python, SQL, T-SQL, PL/SQL, UNIX, API, C#, C, C++, COBOL.

Microsoft Technologies : C#.net, VB.NET, ASP.NET, Visual Basic

Low-Code/ No-code (PaaS) : Unqork

Automation Tools : UiPath (RPA)

Scripting : XML, HTML, JavaScript, VBScript, ASP, Ajax

Environments : MS Visual Studio .NET framework 1.1/2.0/3.5/4.0/4.5/6.0

Project Management : Jira

Document Management : Confluence, Visual SourceSafe (VSS), TortoiseSVN, TFS (Team

Foundation Server)

Experience Summary:

Detail-oriented data analytics and visualization specialist with 15+ years of experience using a variety of software to effectively represent datasets. Proficient in data formatting with a passion for learning new tools and models of Automation and Data Visualization.

Experience in all phases of SDLC, focusing on conceptualizing business needs and translating them into viable technical solutions.

Experienced in Business Intelligence (BI), Visualization tools, Automation tools, Data Modeling and Data migration.

Excellent knowledge in Data Analysis, Data Validations, Data cleansing, Data Verification and identifying data mismatches.

Good understanding of Data Modeling (Dimensional and Relational).

Trained and worked as an Unqork Associate Configurator and implemented an application in low-code/no-code platform.

Extensively used Alteryx for Data Analytics, Data migration as well as ad-hoc reporting

Developed story telling dashboards in Tableau and published them on to the server.

Utilizing company offered trainings to learn Microsoft Power BI, Python and UiPath

Used JIRA for project planning as well as to track issues.

Utilized Confluence for knowledge sharing and documentation.

Expert in developing T-SQL codes, Stored procedures, User-defined functions [UDF], triggers, Scripts, indexes.

Experienced in the practice of extracting, cleansing, transforming, and loading data from OLTP databases and other data sources into Data Warehouse for Analysis using SQL Server Integration Service (SSIS).

Experience of Data migration from Oracle database to SQL server.

Extensively used Red Gate tool to speed up and simplify SQL Server development and ensure that the database changes are safe. Used Oracle SQL Developer tool to query on Oracle database.

Experience in Web application development with .Net, .net CORE, C#, VB.Net, ASP.Net.

Proficient in Web Services, REST API, HTML, AJAX, JavaScript, jQuery, VBScript, CSS, XML, LINQ and Entity Framework.

Experience in Troubleshooting and Technical Problem Solving.

Providing technical support to the client and solving customer queries.

Effective in working independently and collaboratively in teams.

Professional Experience:

JP Morgan Chase & Co (Private Bank) (Apr ‘16- Present)

Data Analytics/Data Visualization specialist, Operations Automation Lead Chicago, IL

Roles:

Operations Automation Lead, Intelligent Automation (Nov 2022 – Present)

Data Management Lead, Mortgage Operations MIS (February 2020 – November 2022)

Associate - Data Analytics / Data Visualization specialist (October 2016 – February 2020)

Contractor - Data Analyst (April 2016 – October 2016)

Certifications & Achievements:

Alteryx Designer Core

Unqork Associate Configurator Bootcamp (PaaS)

Participated in 2019 Associate Forum (New York)

Awarded as Employee of the quarter multiple times

Have been promoted

Responsibilities:

As an Automation engineer, responsible for collaborating with cross-functional teams and senior stakeholders to identify and understand key business challenges, manual processes/User tools (UTs), problem statements, business requirements and translating them into data-driven insights and actionable recommendations and/or identifying a better solution to automate any repetitive process/tasks.

Establish architecture and technical design as well as data cleansing to make it usable for analysis and developed methods to automate data processing with the help of Alteryx.

Develop data models and frameworks to organize and structure data effectively and create visually appealing and informative reports, dashboards, and presentations.

Present complex data in a simplified and understandable format for non-technical stakeholders, using data visualization tools such as Tableau and Qlik Sense to enhance data storytelling.

Single handedly developed an Analytics Catalog application in Unqork (low-code/no-code system platform-as-a-service (PaaS)) that consolidates all enterprise reporting into a single reporting data catalog. It provides users with a single self-service data interface that can access all reporting and dashboards irrespective of the underlying BI Tool Technology.

Performed feasibility analysis and created Unqork schemas, data workflows and APIs.

Managed end-to-end complex data migration, conversion, data modeling using Alteryx/SQL) and created visualization using Tableau to develop high quality dashboards.

Utilized Alteryx for Data Analytics, Data transformations for automation and ad-hoc reporting.

Automated Monthly Scorecard process by developing an application and supporting the data model which resulted in saving approximately 40 hours/month of manual process.

Supported 350+ Scorecard application users from US, Manila, UK and India.

Developed Tableau dashboard for Scorecard to display KPIs of metrics like productivity, Quality, Competencies and Overall, which was viewed regularly by upper management.

Participated in Server upgrade and Data center Migration for two consecutive years. As part of the project, worked on 2 key areas of Improvement such as Application Modernization (Upgraded applications) and Data Visualization (Redevelop Legacy Reports).

Automated application deployment process.

Developed OCR dashboard (Optical Character Recognition) in QlikSense for classification and extraction details.

Developed a Proof of concept (POC) with .Net/SQL server as a part of legacy quality control system decommission.

Took advantage of JPMC available trainings to enhance the skill set.

Self-learning automation tools and technologies such as Python and UiPath.

Develop data analytics and visualization skills within the Data Analytics community through knowledge sharing sessions and training.

Extensively worked and Collaborated with IT partners on various projects.

HGS (USA), LLC (Apr ‘15-Jan’16)

Business Intelligence Analyst Peoria, IL

Responsibilities:

Clean and maintain the database by archiving old data and modified stored procedures to speed up the processes and to meet the business requirement.

Developed Stored procedures to Merge and purge Accounts, BTNs and Wireline information.

Created and executed scripts to correct bad data in AT&T live database.

Monitored scheduled SQL Agent jobs, SSIS packages and data verification.

Created various database objects such as tables, indexes and views based on the requirement.

Extracting, Cleansing, transforming and loading data from different sources into Lifeline database using SSIS.

Assisted business leads almost on daily basis by pulling required data with T-SQL scripts by joining multiple tables based on different conditions and gives them in Excel format for the analysis.

Implemented the error handling in the Stored Procedures and Objects and also modified existing Stored Procedures.

Monitored performance and optimize SQL queries for maximum efficiency.

Did Performance Tuning of the Stored Procedures

Infogix INC. (Jan ‘14-Apr ’15)

Implementation Consultant (SQL Server/BI Developer) Naperville, IL

Responsibilities:

Hands on experience in development of Infogix controls using Infogix Assure and Infogix ER.

Involved in requirement gathering phase. Held meetings with HCSC business people to identify and gather functional requirements on sub-systems, sub-processes, and interfaces in Financial Operations processes.

Experience in creating reconciliation reports.

Rebuilding the indexes at regular intervals for better performance.

Wrote complex T-SQL Queries and stored procedures in SQL Server 2008 to sort data and analyse the large set of data during project life cycle.

Involved in creating tables, indexes, views, and triggers.

The product has four different types of automated controls for each identified interface to validate and notify HCSC of information integrity issues within RMAS Fin Ops process.

Worked in Services team that provides services to Infogix clients to maintain their data warehouse.

Created variety of SSIS packages (.dtsx files) using SSIS to validate, extract, transform and load data to data warehouse databases and data mart databases for the client.

Designed the connection methods with XML configurations, variables and parent package configurations.

Designed and worked on various Control Flow Tasks such as Execute SQL task, Execute Package Task, Bulk Insert Task, Data Profiling Task, Script Task, Send Mail Task, XML task, For Loop and For Each Loop Containers.

Lawson Products (Employer: TekSystems) (Nov ‘13- Jan ’14)

Software Developer Chicago, IL

Responsibilities:

Built C# .Net UI connected to their SAP Sybase Database.

Create a labeling diagram for cabinets as well as bins and display as a two-dimensional grid to represent labeling positions for the bin or cabinet. Also, Material numbers are entered into the desired label position in the grid indicating the position for the label information.

Send Label printing request to WebService via XML and the webservice provides the method to pass all labeling directions to the Print Engine.

Wells Fargo (Employer: TekSystems) (Apr’11-Feb’12) SQL Server BI Developer Roanoke, VA

Responsibilities:

Created SQL Server Integration Service (SSIS) packages to extract data from Excel File, Flat Files, Text Files and Comma Separated Values (CSV) files using various transformations like Pivot, Conditional Split, Data Conversion, Derived Column, Multicast, Aggregate, Merge, Sort, Merge Join and Lookup and different kinds of tasks including Execute SQL Task, Data Flow Task and Execute Package Task.

Developed Stored Procedures using iterative processing with Loop, Case statement, Exception Handling, Records, Collections and DML operations.

Developed and executed T-SQL queries for various ad-hoc reports requested from management teams.

Developed Functions, Views, and indexes for use in Analysis and Reporting using Microsoft SQL Server.

Designed and implemented ETL processes for enterprise migration system.

Designed and developed the mappings using various transformations according to business partners' requirements.

Designed and implemented queries to extract data to new data warehouse.

Creating SQL Server Agent Jobs and scheduling them effectively to populate the tables daily.

Generated Matrix Reports, Drill Down, Drill Through, Sub-Reports, Chart Reports using SQL Server Reporting Services (SSRS).

Did Performance Tuning of the Stored Procedures.

Worked on remote use of Linked servers, FTP, SQL Server Agent Job, Windows task Scheduler, Indexes, RDP (Remote Desktop Connection), Database maintenance, bug tracking and resolve.

Extensively used Red Gate tool to speed up and simplify SQL Server development.

Worked with SSMS Query Analyzer, Tuning Advisor. Understanding of Query Execution Plans.

Worked with maintenance, back-up and restore of databases using SQL Server 2008.

Version controlled by TortoiseSVN source control software.

Certifications and Educational Qualifications:

Alteryx Designer Core Certification

Unqork Associate Configurator – (Bootcamp training)

Microsoft Certified Technology Specialist (MCTS: Microsoft .NET Framework 4, Web Applications Development)

Master of computer application (MCA), India

Bachelor of Commerce (B.COM) in Accounting, India

Contact this candidate