Scroll To View More
Vimal Vachhani, ETL Tools Developer in New York, NY, United States
Vimal Vachhani

ETL Tools Developer in New York, NY, United States

Member since April 17, 2019
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.
Vimal is now available for hire

Portfolio

Experience

  • ETL Tools, 14 years
  • SQL Server Analysis Services (SSAS), 14 years
  • SQL Server Reporting Services (SSRS), 14 years
  • SQL Server Integration Services (SSIS), 14 years
  • ETL, 14 years
  • SSAS, 14 years
  • SSRS, 14 years
  • SQL, 14 years
New York, NY, United States

Availability

Part-time

Preferred Environment

SQL Server, Azure, SSIS, SSRS, Data Warehouse

The most amazing...

...project I've helped build was an analytics solution from scratch to help a distressed company find, and correct operational flaws, and become profitable.

Employment

  • 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: SQL Server, SSIS, SSRS, SSAS, Data Modeling, Power BI, ETL, Data Governance
  • 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: SQL Server, SSIS, SSRS, SSAS, Data Modeling
  • 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: SQL Server, SSIS, SSRS, SSAS, Data 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: SQL Server, SSIS, SSRS, SSAS, Data Modeling
  • 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: SQL Server, SSIS, SSRS, Power BI
  • 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: Microsoft SQL Server Suite 2008 R2 (SSMS, SSIS, SSRS), Power BI, Tableau, Informatica, Cognos 10.2
  • 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: SQL Server, SSIS, SSRS, SSAS, Data Modeling, Power BI, ETL, Data Governance
  • 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: SQL Server, SSIS, SSRS, SSAS
  • 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: SQL Server, SSIS, SSRS, SSAS
  • 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: SQL Server, SSIS, SSRS, SSAS
  • 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: SQL Server, SSIS, SSRS, SSAS, Data Modeling, Power BI, ETL, Data Governance, Data Strategy
  • 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, SSIS, SSRS
  • 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

Experience

  • Havenbrook Homes (Development)

    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)

Skills

  • Languages

    SQL, PHP 3
  • Tools

    SSRS, SSAS, Microsoft Power BI, DataViz
  • Paradigms

    ETL, Testing
  • Storage

    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, PostgreSQL
  • Other

    ETL Tools, ETL Development, Data, Data Cleansing, Data Warehousing, Data Warehouse Design, MDM

Education

  • Bachelor of Science degree in Computer Science and Software Engineering
    2001 - 2005
    The University of Texas at Dallas - Dallas, Texas, USA
Certifications
  • Microsoft Data Warehousing
    JANUARY 2010 - PRESENT
    Kimball Group Training
  • Dimensional Modeling
    JANUARY 2007 - PRESENT
    Kimball Group Training
I really like this profile
Share it with others