Sandip Patel
New York,NY
Summary
Results-oriented BI/Data professional with over 15 years of experience specializing in the end-to-end development and delivery of business intelligence solutions. Proficient in designing, coding, and implementing robust BI systems using tools such as QlikView, Tableau, MicroStrategy, Sisense Prism, Tibco Spotfire, MS BI and Excel VBA. Adept at collaborating with diverse stakeholders, including end users, business analysts, project managers, and IT managers, to identify data sources, analyze business processes, and gather requirements. Extensive knowledge of Data Warehousing, ETL and BI Architectures, concepts, and frameworks. Proven ability to work across various industries, including sales, marketing & advertising, banking/finance, legal insurance, call center, public transportation and supply chain. Known for providing training, assistance, and support to team members and clients on BI tools. A reliable professional with a track record of delivering impactful dashboards, scorecards, reports, and data analysis solutions.
Overview
18
18
years of professional experience
Work History
Lead Software Engineer
EPAM Systems
02.2014 - 12.2023
- Conducted comprehensive gathering and understanding of business requirements and processes, performing meticulous data analysis and validations
- Proficiently designed, coded, developed, and delivered robust BI solutions.
- Actively engaged with end-users, providing valuable support for their self-service reports and dashboards.
Business Intelligence Consultant
Visvero Inc
05.2011 - 01.2014
- Skillfully designed, developed, and delivered BI solutions using QlikView and Sisense Prism
- Successfully set up servers and installations at client sites, ensuring seamless implementation
- Provided effective training and guidance to team members on BI and BI tools
- Played a key role in the evaluation of different BI tools like Sisense Prism, Tibco Spotfire
- Actively contributed to various proof of concept (POC) and other projects, showcasing problem-solving skills
- Engaged in comprehensive requirement gathering, scripting, Set Analysis, ETL, data cleansing, Section Access, server setup, and documentation.
Business Intelligence Consultant
Business Intelligent Pty. Ltd
07.2009 - 12.2010
- Designed dashboards, scorecards, and reports using QlikView, fostering effective communication with end-users, business analysts, project managers, stakeholders, IT managers, and decision-makers
- Spearheaded the identification of different data sources, analysis of data and business processes, and collection of requirements, resulting in the creation of QlikView data marts (QVD files) and data modeling
- Successfully dealt with the conversion and linking of data from various sources as per specific requirements
- Provided comprehensive support, maintenance, and setup of QlikView Server/QlikView Analyzer/QlikView Desktop.
Business Intelligence Consultant
Excel Integration Pty. Ltd.
05.2006 - 06.2009
- Successfully developed Alchemex containers, reports, OLAP cubes, ETL processes, and data modeling
- Designed and implemented SQL joins, queries, SQL expressions, Excel formulas, scripts, VBA for enhanced data processing
- Proficiently designed Excel Templates, Pivot Tables, Charts & Graphs, Executive Dashboards, and Scorecards for various CRM, Financial, POS, and Accounting Packages
- Developed and designed Excel VBA Programs, showcasing programming proficiency
- Led the development and design of OLAP Cubes, Reports, ETL processes, Drill-through, Drill-down actions in MS SQL Server 2005 SSAS, SSRS, SSIS
- Actively participated in strategy thinking and planning projects, showcasing strategic planning skills
- Conducted planning and feasibility studies for new projects and opportunities
- Collected specifications for new reports from clients and suggested different deliverable options
- Provided comprehensive training and assistance to team members and clients
- Documented and evaluated all processes and results, ensuring transparency and accountability
- Provided crucial support to marketing and sales teams with POCs and demos, contributing to business development
- Effectively managed projects and teams, showcasing strong project management skills.
Education
Bachelor of Science -
The Institute of Business Management And Research, Pune, India
Pune01.2002
Skills
- QlikView
- Tableau
- MicroStrategy / Power BI
- SQL
- ETL / DWH
- Data Modeling / Analysis
- SDLC / Agile Methodologies
- MS Excel / VBA
Timeline
Lead Software Engineer
EPAM Systems
02.2014 - 12.2023
Business Intelligence Consultant
Visvero Inc
05.2011 - 01.2014
Business Intelligence Consultant
Business Intelligent Pty. Ltd
07.2009 - 12.2010
Business Intelligence Consultant
Excel Integration Pty. Ltd.
05.2006 - 06.2009
Bachelor of Science -
The Institute of Business Management And Research, Pune, India
Similar Profiles
Shari AlkhazalehShari Alkhazaleh
Associate Sales Development Representative at EPAM SystemsAssociate Sales Development Representative at EPAM Systems
Aniellia ArnoultAniellia Arnoult
Business Analyst at EPAM SystemsBusiness Analyst at EPAM Systems
Ankit SinghAnkit Singh
Senior Software Engineer at EPAM SystemsSenior Software Engineer at EPAM Systems
Hemalatha VenkatesanHemalatha Venkatesan
Database Administrator at EPAM systemsDatabase Administrator at EPAM systems
Jewel ConyersJewel Conyers
Patient Coordinator at Mount SinaiPatient Coordinator at Mount Sinai