Vimal is currently unavailable
Vimal Vachhani
Verified Expert in Engineering
ETL Tools Developer
New York, United States
Toptal member since July 15, 2019
Bio
Vimal is a senior enterprise data architect with an extensive background in database and business intelligence fundamentals. He has over 14 years of experience across industries as a user experience architect, data modeler, data architect, solutions developer, and business analyst. Vimal brings in-depth knowledge to projects with BI tools, including SQL Server, analysis, integration and reporting services, as well as big data fundamentals.
Portfolio
IT Consulting Firm
Data Governance, ETL, Microsoft Power BI, Data Modeling, SSAS...
Real Estate Company
Data Modeling, SSAS, SQL Server Reporting Services (SSRS)...
Mortgage and Loan Processing
Data Modeling, SSAS, SQL Server Reporting Services (SSRS)...
Experience
- SSAS - 14 years
- ETL Tools - 14 years
- SQL - 14 years
- ETL - 14 years
- SQL Server Integration Services (SSIS) - 14 years
- SQL Server Reporting Services (SSRS) - 14 years
- SQL Server Analysis Services (SSAS) - 14 years
Work Experience
Senior Solution Architect and Director, Data and Business Intelligence
2015 - 2019
IT Consulting Firm
- Created development and deployment architecture. I was the lead data architect for the enterprise data warehouse build.
- Designed and developed the ETL framework, data model, and architecture for the data warehouse.
- Built the ETL and data transformations to load models and feed analytic reports.
- Built reports and KPI to service C-level suite and operational resources.
- Configured and deployed the Visual Studio Team Foundation server, and source control for the code repository, and disaster control.
- Designed and defined long, and short-term business and data strategies. I was the thought leader in business intelligence, analytics, and big data modern data architecture.
- Developed new business with existing clients across products and industries.
- Acquired new clients through developing relationships with network and software partners.
- Built and established data and analytics credibility with existing and new clients to secure, and expand the business.
- Acted as an advisor to clients utilizing thought leadership and innovation.
Technologies: Data Governance, ETL, Microsoft Power BI, Data Modeling, SSAS, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Microsoft SQL Server, SQL, Database Design, Databases, MySQL, Data Engineering, Data Architecture, Architecture, Roadmaps, Big Data Architecture, Data, Python, Data Visualization, Business Intelligence (BI), Reports, Data Analysis, Data Analytics, Analytics, ETL Development, ETL Implementation & Design, Transact-SQL (T-SQL)
Senior Data Architect
2017 - 2018
Real Estate Company
- Created a solution to create a replica of the Yardi database locally, using the log shipping methodology.
- Designed and developed an ETL framework, data model, and architecture for a data warehouse staging environment.
- Oversaw the QA testing to verify all queries baselined against the production system perform efficiently against the new staging environment.
- Ran the performance testing for the database and server administration.
Technologies: Data Modeling, SSAS, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Microsoft SQL Server, SQL Server 2015
Senior Data Architect
2017 - 2018
Mortgage and Loan Processing
- Created development and deployment architecture. I was the lead data architect for the enterprise data warehouse build for a loan servicer.
- Designed and developed an ETL framework, data model, and architecture for a data warehouse.
- Built the ETL and data transformations to load Excel models for the Capital Markets team to calculate margin.
- Configured and deployed the Visual Studio Team Foundation server, and source control for code repository and disaster control.
Technologies: Data Modeling, SSAS, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Microsoft SQL Server, Database Modeling
Senior Data Architect
2016 - 2017
Global Private Equity Firm
- Built the interface between the loan servicer Situs, TRT data warehouse, and Liquidity model. I was the lead data architect on the project.
- Designed and developed an ETL framework, data model, and architecture for the data warehouse.
- Built the ETL and data transformations to load Excel models for the Finance team to calculate IRR across deals and funds.
- Configured and deployed the Visual Studio Team Foundation server, and source control for the code repository, and disaster control.
Technologies: Data Modeling, SSAS, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Microsoft SQL Server
Senior Data Architect
2015 - 2016
Real Estate Company
- Developed the scope, and set up the AWS Cloud architecture. I was the lead data architect for this enterprise data warehouse build-out.
- Designed and developed the ETL framework, data model, and architecture for the data warehouse.
- Defined and implemented development standards and processes for Agile BI development.
- Led a team of internal and consultant developers in all business intelligence initiatives.
- Partnered with a C-level organization to define and align technical and business goals, and requirements.
Technologies: Microsoft Power BI, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Microsoft SQL Server
Senior Data Strategy Architect
2014 - 2015
Advent Software
- Designed a short, and long- term organizational road map for a client around business intelligence focusing on gap-closing strategies across data, analytical, organizational, and governance workstreams. I was the primary technical architect in a cross-functional business intelligence assessment and strategy project.
- Interviewed key organization team members from business units, and executive management team to understand initial goals, company directions, current pain points, and the future wish list for business intelligence.
- Created high-level scalable data architecture to support continued data growth from current operational needs, to future big data requirements for customer-centric reporting with the Hadoop framework back end, and supporting the intersection of big data and operational reports.
Technologies: IBM Cognos, Informatica, Tableau, Microsoft Power BI, Management Systems, Microsoft SQL Server, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), R2
Lead Data Architect
2013 - 2014
Government: Transportation
- Responsible for all pre-development deliverable documentation from data discovery, data profiling, logical data models, physical data models ,and ETL architecture documents.
- Developed the ETL from multiple data sources from different business units across government organization.
- Developed a full ETL build to support the date extract and load, leveraging best practices, and MDM techniques.
- Oversaw the full project life cycle from requirements gathering, development, testing, through to deployment.
Technologies: Data Modeling
Senior Consultant and Manager
2011 - 2014
Hitachi Consulting
- Designed short, and long-term organizational road maps for the client around business intelligence focusing on gap-closing strategies across data, analytical, organizational and governance work streams. I was the primary technical architect in the cross-functional business intelligence assessment and strategy projects.
- Interviewed key organization team members from business units and executive management team to understand initial goals, company directions, current pain points, and the future wish list for business intelligence.
- Created high-level scalable data architecture to support continued data growth from current operational needs to future big data requirements for customer-centric reporting with a Hadoop framework back end supporting the intersection of big data and operational reports.
- Oversaw full ETL builds to support data extraction, and load, leveraging best practices and MDM techniques.
- Ran the full project life cycle from requirements gathering, development, testing, and deployment.
Technologies: Data Governance, ETL, Microsoft Power BI, Data Modeling, SSAS, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Microsoft SQL Server
Senior Consultant and Architect
2011 - 2013
Financial Services
- Developed an SSAS solution build-out supporting new product development and sales. I was the technical lead on the creation of the front and back end of the Loan Risk Grade and Reserve Analysis tool.
- Migrated the legacy General Ledger processes to an existing SQL Server Data warehouse.
- Integrated the BAI file format data into an existing ETL process to retire old reference data stores.
- Built Microsoft SQL Server Integration Packages in conjunction with SQL Stored procedures to perform ETL of all data from existing sources to the new environment.
- Ran full project life cycle from requirements gathering, development, testing, and deployment.
Technologies: SSAS, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Microsoft SQL Server
Senior Consultant and Architect
2011 - 2011
Global Payment Processor
- Developed a back-end BI solution for a financial reporting dashboard.
- Architected a data warehouse and reporting layer to support a front-end Silverlight application.
- Created an ETL solution for the nightly extraction of substantial amounts of data.
- Created a cube solution to house a reporting environment for dynamic queries.
- Implemented dynamic security on the cube level to be leveraged by a front-end Silverlight application.
- Developed the full project life cycle from requirements gathering, development, testing, and deployment.
Technologies: SSAS, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Microsoft SQL Server
Senior Business Intelligence Analyst
2010 - 2011
Consumer Packages Company
- Participated in the creation and implementation of daily sales ETL and cube.
- Built Microsoft SQL Server Integration Packages in conjunction with SQL stored procedures to perform ETL of all data from existing sources to a new environment.
- Designed the physical and logical model architecture to support daily sale cube extracting and reporting.
- Oversaw the full project life cycle using Agile methodology starting at requirements gathering, and ending at deployment and training.
- Utilized Microsoft SQL Server Analysis Services and MDX to redesign existing cubes for a new environment.
- Mentored junior staff with development and project tasks.
Technologies: SSAS, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Microsoft SQL Server
Senior Business Intelligence Analyst
2007 - 2011
LiveLogic, LLC.
- Participated in the creation and implementation of daily ETL and data cubes.
- Built Microsoft SQL Server Integration Packages in conjunction with SQL Stored procedures to perform ETL of all data from existing sources to new environments.
- Designed the physical and logical model architecture to support extracts and reporting.
- Oversaw the full project life cycle using Agile methodology starting at the requirements gathering and ending at deployment and training.
- Utilized Microsoft SQL Server Analysis Services and MDX to redesign existing cubes for a new environment.
- Mentored junior staff with development and project tasks.
Technologies: Data Strategy, Data Governance, ETL, Microsoft Power BI, Data Modeling, SSAS, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Microsoft SQL Server
Senior Business Intelligence Analyst
2007 - 2009
Global Services Firm
- Participated in a full upgrade of SQL 2005 from existing SQL 2000 environment.
- Built Microsoft SQL Server Integration packages in conjunction with SQL Stored procedures to perform ETL of all data from existing sources to a new environment.
- Utilized Microsoft SQL Reporting Services to rewrite all existing report as well as use new 2005 functionality to design updated and more useful reports for the clients.
- Created stored procedures to be used by both reporting integration services for extendable and maintainable data views.
- Utilized Microsoft SQL Server Analysis Services and MDX to redesign existing cubes for a new environment.
Technologies: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Microsoft SQL Server
Computer System Technical Analyst
2006 - 2007
US Oncology
- Participated in contract management and portal software design and implementation.
- Assisted with requirements gathering, analysis, testing and support of proprietary software built on an existing Oracle database and application.
- Represented BPI at weekly status meetings. Organizational lead in day-to-day project activities.
- Utilized SQL to create scripts and extract data used in full system validation.
- Oversaw simulations of day-to-day activities in development and user acceptance environments in preparation for production go-live.
- Worked in a large team including business process development, analyst and training teams.
Technologies: Oracle
Computer System Technical Analyst
2005 - 2005
Global Cosmetics Company
- Participated in full supply chain software design and implementation lifecycle. This included requirements gathering, design, testing, data conversion and implementation of four separate phases spanning two years.
- Primarily responsible for designing the user end of JDE OneWorld, (purchased by PeopleSoft ) and Sapphire LIMS three-tier computer systems.
- Met with users to gather requirements for the system design.
- Designed, tested and implemented full data conversions and ETL from the JDE database to Oracle.
- Utilized SQL to develop label creation applications to be used with laboratory data stored in the Oracle database.
- Worked with the business intelligence group to create reports interfaced with data from Sapphire LIMS and JDE OneWorld systems using SQL reporting and Cognos 8.
- Created entity relations diagrams in VISIO to map data, classes and user pages.
- Worked in a large team including the business process development, analyst and training teams.
Technologies: JD Edwards
Project History
Havenbrook Homes
I was the lead data architect for an enterprise data warehouse build-out. Developed the scope, and set up the AWS Cloud architecture. Designed and developed the ETL framework, data model, and architecture for the data warehouse. Defined and implemented development standards and processes for Agile BI development. Led a team of internal and consultant developers in all business intelligence initiatives. Worked with a C-level organization to define and align technical and business goals and requirements. Technologies used: Microsoft SQL Server Suite 2012 (SSMS, SSIS, SSRS)
Education
2001 - 2005
Bachelor of Science Degree in Computer Science and Software Engineering
The University of Texas at Dallas - Dallas, Texas, USA
Certifications
JANUARY 2010 - PRESENT
Microsoft Data Warehousing
Kimball Group Training
JANUARY 2007 - PRESENT
Dimensional Modeling
Kimball Group Training
Skills
Tools
SSAS, Microsoft Power BI, DataViz, JD Edwards, Tableau, IBM Cognos
Languages
SQL, Python, Transact-SQL (T-SQL), PHP 3
Paradigms
ETL, Testing, Database Design, Business Intelligence (BI), ETL Implementation & Design
Platforms
Azure Synapse, Azure, Oracle
Storage
Microsoft SQL Server, SQL Server 2017, Azure SQL, Azure Blobs, SQL Server DBA, SQL Server 2014, SQL Server 2016, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SSAS Tabular, SQL Server Analysis Services (SSAS), SQL Server 2005, Database Modeling, Databases, MySQL, PostgreSQL
Other
ETL Tools, ETL Development, Data, Data Cleansing, Data Warehousing, Data Warehouse Design, Azure Data Factory (ADF), Data Engineering, Data Architecture, Architecture, Roadmaps, Big Data Architecture, Data Visualization, Reports, Data Analysis, Data Analytics, Analytics, SQL Server 2015, MDM, Data Modeling, Data Governance, Data Strategy, R2, Management Systems, Informatica, JD Edwards CNC
Collaboration That Works
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
1
Share your needs
Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2
Choose your talent
Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3
Start your risk-free talent trial
Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.
Top talent is in high demand.
Start hiring