Vandit Patel Email & Phone Number

Ann Arbor, Michigan, United States

• Design and develop ETL (Talend) / SQL / Python / Linux based processes to perform complex data transformation processes.• Design, code, and test major data processing features, as well as work jointly with other team members to provide complex software enhancements for the enterprise data storage platforms (RDBMS and No-SQL platforms)• Build Data Integration solutions to handle batch / streaming / IoT (Hadoop/Confluent/ActiveMQ) / REST API (Datatron) data on ETL, Big-Data platforms (Couchbase, S3)• Work jointly with Data Science team on ML operation automations alongside developing automated EDAs to convey to leadership how ML model changes would affect our final results• Manage changes in the Enterprise Data Warehouse according to Data Warehousing best practices• Provide thought leadership to deliver creative and efficient data related technical solutions• Gather requirements and construct documentation to aid in maintenance and code reuse in accordance with team processes and standards• Design, code, and test major data processing features, as well as work jointly with other team members to provide complex software enhancements for the enterprise data storage platforms• Monitor scheduled jobs and improve reliability of ongoing processing• Monitor, measure, and enhance ways to improve system performance• Conduct interviews to fill positions within my core data engineering team, leading them to success within the company, following industry best practices

Ann Arbor, Michigan, United States

Ann Arbor, Michigan, United States

Greater Detroit Area

• Consulted with clients to gather and analyze requirements and create the technical design specifications to build out optimal solutions• Lead SSIS developer for both client and internal complex ETL data transformations to provide a seamless, automated operation• Developed an automation system to handle importing feeds in real time, transforming a 40-hour manual process to a 4 hour self-regulating process making the overall data handling techniques time and cost efficient• Utilized exceptional SQL Server scripting skills to process immense data sets and develop automatic data cleansing techniques providing the company with more advantageous resources• Implemented new systems to expand the tool for global usage of client’s data to bring in higher profits worldwide• Optimized storage and processing speed with strong expertise in designing database architecture in accordance to key Data Warehousing principles• Acted on ETL failures in a high-pressured environment in order to analyze the issue and apply an effective solution in a timely manner in order to meet our target timeline• Provided process improvement analysis, using process modeling and simulation techniques on development servers, to understand the impact of process changes before launching to production to increase data flow efficiency and minimize adverse effects being launched to our production environment• Attended technology design meetings and provided thought leadership on security and dataflow improvements

Greater Detroit Area

Greater Detroit Area

Preserve the veracity of AlixPartners CRM database using LexisNexis InterAction software to guarantee that the cardinal function of communication is successful by having contact information accessible, systematic, and current.Enhance quality of firm and contact information by:• Processing and examining contact information change requests• Categorizing and classifying companies for industry information• Pinpointing and heightening database inefficiencies by probing and merging duplicate contacts• Administering company association cleanup• Researching and editing ‘returned’ mailings

Greater Detroit Area

Designed a dynamic Web Application Natural Language recognition system to streamline an existing system for Urban Science utilizing SQL Server, C#, HTML5/CSS(BootStrap)/JavaScript, and Microsoft Cognitive Services* Instilled excellent software engineering practices, involving Software Requirement Specification, Design Document, Test Documentation, Incremental Prototypes, and Deployment, and led quality assurance of deliverables* Led communications between client, instructors, and team members and organized meetings* Met frequent deadlines with heavy workload consisting of documentation and prototypes* Performed product demos for clients and instructors and received/incorporated feedback

Greater Detroit Area

As a Sales Consultant, I exceled at selling products and services, working closely with other members of the sales team. I accumulated the appropriate knowledge and expertise through continuous learning and self-development. Then, armed with the right tools and knowledge, I created ease and added value to the Best Buy shopping experience, ensuring customers’ end-to-end needs are met. Everyday responsibilities were as follows:• Engage customers using selling skills to build complex, connected solutions in a fast-paced, dynamic environment where customers feel supported and leave delighted.• Inspire customers by showing them what’s possible with technology.• Use innovative training tools to stay current, confident and complete, driving profitable growth and achieving individual and department goals.• Accumulate and apply the appropriate knowledge and expertise through continuous learning and self-development, enabling you to provide an excellent customer shopping experience.• Maintain your department’s merchandising and readiness to serve customers. Back up the sales team for phone and store pickup.• Perform other duties as assigned by management.