Devangi Pandya Email & Phone Number

Chicago, IL, US

Schaumburg, Illinois, US

Chicago, IL, US

Chicago, IL, US

Chicago, IL, US

• Migrate SQL Server Databases to AWS EC2 servers using SSMS functions and AWS S3 instances in the agile system.
• Developed an automated process to monitor server performance and create dynamic alerts for high resource utilization using VB.net and PowerShell.
• Developed reports and dashboards using data visualization tool Tableau for Email data analysis and used Eloqua tool to get Email data.
• Developed automated ETL process to clean SPSS, Delimited Files, Word files and insert in SQL server Data warehouse using SSIS, SQL stored procedures, queries, and functions.
• Developed product reviews report using reviews on social and marketing media. In order to get data from websites using web scraping in Python.
• Developed and maintain SQL Agent Jobs from scratch to run automated SSIS packages.

Lisle, IL, US

• Developed ad hoc reports, drill through and drill down reports, dashboards in SSRS to provide better visibility of data to the executives.
• Developed SSIS packages using Lookup Transformations, Merge Joins, Fuzzy Look Ups, and Derived Columns with Multiple Data Flow tasks.
• Developed SQL stored procedures, queries and functions for data cleansing and transformation.
• Worked on front end solution like HTML, JQuery, and JavaScript for dashboards to provide better UI.
• Used C# for building solutions to provide better interactivity with dashboards.
• Worked in an agile environment to provide continuous delivery.

• Developed and maintained SSIS packages by utilizing extensive data transformations, mappings, and scripting in Python to load customer, and fleet data, into the Data Warehouse.
• Identified and resolved performance bottlenecks at various stages using techniques like Database tuning and Session Partitioning.
• Developed tables, stored procedures, triggers, cursors, views and indexes for the design specifications.
• Developed mappings using connected/unconnected lookup, router, joiner, expression, filter, sequence generator transformations.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Created procedures, functions and triggers within SQL Server to implement altered data capture within ETL processes.

• Designed Property Portal System to manage client owned real estate data and mortgage liabilities.
• Implemented search property module using C#, third-party omnibox plugins and Angular.js.
• Worked with existing development infrastructure to create and update use cases, sequence diagrams, class diagrams, and relevant UML diagrams.
• Integrated multiple vendor APIs to retrieve and analyze client's credit reports, property insurance requirements, and employment information.
• Integrated property portal with features like geolocation and online payment systems using Google Maps and PayPal API.
• Analyzed and optimized existing stored procedures and triggers in SQL Server 2008.

Master Of Science (Ms), Information System

Bachelor Of Technology (B.Tech.), Information Technology

Diploma Engineering, Information Technology