Vipulkumar Patel

VIPULKUMAR PATEL  Ahmedabad, India |  - | - DATA ENGINEER/BI MANAGER Senior professional with over 17+ years of experience in enterprise-wide application integrations. Acknowledged by the senior management and the clients for consistently rendering superior quality service across the professional career. Seeking challenging assignments with a repute organization to utilize acquired skills in accomplishing organizational growth objectives CORE SKILLS EXECUTIVE SUMMARY  Proven 17+ years of expertise in RDBMS including Teradata & Oracle, and ETL tools like BODS & SSIS. and SAP Business Object & Power BI for reporting. SLA Compliance  Skilled in working on Enterprise Data warehousing, ETL, dimensional data modeling, and shell scripting. Requirement Elicitation  Adept at developing complex system implementation plans and development using ETL tools related to various databases. Well-versed in user administration, database security administration, performance tuning, and optimization Conversant with AWS and Azure Cloud technologies. involved in various stages of the physical SDLC environment, ensuring high-quality Project implementation. Strategy Planning Project Management Solution Customization Enterprise Data Warehousing   Database Security Administration Azure Cloud Technologies Liaison & Coordination Team Leadership  Involved in end-to-end management of assigned project phases based on the project SLA parameters.  High mentoring ability with excellent communication and team management skills. Possess an analytical mindset. IT SKILLS    Teradata (DBA and BI), Oracle, Snowflake, Power BI, Unix shell scripting AWS and Azure Cloud technologies, TARA, SQL Assistant, PL/SQL, VBA Netbackup, Viewpoint, TD Administrator PROFESSIONAL EXPERIENCE Accenture Solutions Pvt. Ltd, Mumbai, India Associate Manager / Business Intelligence Manager Jul 2016 – Present Achievements:  Developed end to end Power BI dashboard to give the overview on the Incidents SLA and Major Incidents pattern  Acknowledged for providing a customized solution to mask customer-sensitive data (PII) as per GDPR norms.  Saved approx 45 Hrs/week of batch processing by applying performance tuning on long-running batch.  Introduced a tool to identify the PII data and take appropriate action to mask the data including Python code in the project and developed various automation using it. Responsibilities:  Provide leadership to a team of 30+ members in catering to the strategic design and maintenance of business intelligence applications.  Function as the BI Manager involved in identifying, researching, and resolving complex technical problems to ensure the usage of business intelligence applications to enhance business decision-making capabilities.  Guide team members involved in the design, development, and implementation of Business Intelligence (BI) and analytics systems.  Partner with the technical resources to design and model the data warehouse systems. Render functional and technical guidance to business teams based on requirements.  Explored data in a variety of ways and across multiple visualizations using Power BI. Strategic expertise in design of experiments, data collection, analysis and visualization.         Render support to ETL developers by providing technical assistance, troubleshooting, and alternative development solutions. Prepare technical presentations & proposals, & perform customer presentations. Work as a technical lead for deployment involved in managing the deployment of architecture. Conduct business meetings with customers to determine project requirements and milestones. Define and implement organizational strategies for data integrity validation processes and establish policies and best practices for optimizing ETL data throughput/accessibility. Coordinate with the project managers in developing project plans including budgets, timelines, and forecasts. Ensure compliance with the project delivery schedules and other SLA parameters. Evaluate operational progress against planned project objectives and implement effective remedial measures based on the identified deviations. Implement risk mitigation measures based on the identified risks and opportunities. Set up an alert mechanism to check the system's health or identify impactful queries/sessions. Roll out role strategies along with streamlining User security management, and new codes in production after proper testing in the SIT and UAT environments. Prepare and present new weekly and monthly system performance reports on production using the PDCR toolkit to the key business stakeholders. Capgemini India Pvt Ltd, Mumbai, India Senior Support Engineer Feb 2014 – Jul 2016 Achievements:  Developed an auto space management tool, and reduced multiple failures  Performed tuning of the long-running production batch and saved approx 120 hrs/week of the cumulative run time of batch. Responsibilities:  Liaised with the development team to perform code reviews before implementation in production. Implemented effective role strategies, and streamlined user security management.  Generated and presented performance audit system reports to the client. Resolved Spool out errors in Teradata to minimize resource wastage.  Deployed Production changes, handling data copy using UDM. Performed database maintenance activities on monthly basis.  Worked on MVC analysis for a few production tables for space-saving on production systems. Teradata India Pvt Ltd, Mumbai, India Technical Consultant / Performance Database Administrator Nov 2011 – Jan 2014 Achievements:  Saved 70 Million seconds of CPU time, by tuning bad performing queries. Optimized space utilization by compressing data of 35 TB. Responsibilities:  Involved in identifying bad performing queries from the system and recommended effective remedial measures to enhance performance.  Prepared dashboards for jobs running in a lower environment and passed them to move them to Production. Conducted Viewpoint monitoring to check the system health or any impactful query/session.  Performed QA check on DDLs in lower environments. Prepared audit report of production system quarterly; performed code review before implementation in production.  Created Test and Development environments and granted access/privileges based on requirements without impacting the Security policies including Teradata objects like Databases, Users, Profiles, Roles, Tables, etc. as per application requirement.  Interacted with the developers, Data Architects, and the project DBAs for the SDLC reviews and query tuning assignments. PREVIOUS ASSIGNMENTS Path InfoTech Ltd, Mumbai, India Associate Consultant / Oracle Database Administrator Jan 2011 – Aug 2011 DBAMETRIX Solutions, Ahmedabad, India Associate Consultant / Oracle Database Administrator May 2008 – Jan 2011 EDUCATION   MBA (Finance), Gujarat University B Sc., Sardar Patel University - TRAINING COURSES         AWS Solutions Architect Associate Microsoft Certified: Azure Fundamentals AZ:900 Azure Data Engineer Associate DP‐203 Lean Six Sigma Yellow belt certified TE0-121, TE0-122, TE0-123, and TE0-124 Teradata Certifications Oracle 10g OCP Certified Snowflake Training (Online for 7 Days) Teradata database 12 PERSONAL DETAILS     Date of Birth: 24 Jul 1984 Nationality: Indian Languages Known: English, Hindi, and Gujarati Passport No.: M- valid till Mar 2025