Venkatraman Subramaian, Enterprise Solution Architect and Developer in Austin, TX, United States
Venkatraman Subramaian

Enterprise Solution Architect and Developer in Austin, TX, United States

Member since March 8, 2022
Venkatraman is an enterprise and data architect who focuses on enterprise applications and data analytics. He is a strong leader in managing large IT engagements with experience handling major global programs for Fortune 100 clients across the globe. He managed a team to modernize the platform of a Big 4 advisory firm and drew the roadmap to help a fintech client migrate their 2,500 SQL Server databases from in-house to an AWS platform. He has delivered worth between $30-60 million to clients.
Venkatraman is now available for hire

Portfolio

  • Petite Consulting LLC
    Data Analytics, Snowflake, Informatica Data Quality, Informatica ETL...
  • Wipro
    Snowflake, Collibra, Amazon Web Services (AWS), Azure
  • Accenture
    Data Analytics, Amazon Web Services (AWS), Amazon S3 (AWS S3), Snowflake...

Experience

Location

Austin, TX, United States

Availability

Part-time

Preferred Environment

Windows 10

The most amazing...

...road map I drew for a client helped them migrate from Azure SQL Server to Snowflake, using Talend as an ELT and data management tool Tableau for reporting.

Employment

  • Managing Principal

    2019 - PRESENT
    Petite Consulting LLC
    • Managed a delivery team involved in transformation and modernizing the platform for CDO of a Big Four advisory firm. Moved away from legacy and in-house applications to the modern MDM and Azure Data Lake platform.
    • Served as the architect advisor collaborating with AWS architects to draw a roadmap to help a fintech client migrate their 2,500 Microsoft SQL Server databases from in-house to an AWS platform.
    • Assisted in documenting and planning the transformation to a hybrid model as a data architect for an as-is assessment study for a workers compensation insurance firm.
    • Served as an architect advisor to the public health informatics team within a state agency in streamlining their infectious disease data integration platform (IDDI) that interacts with a local testing agency across the state and reports to the Governor’s office, CDC.
    • Developed the roadmap for the enterprise information management (EIM) transformation that the college decided to embark on as part of the modernization of their information systems and their organizational transformation of the IT.
    • Took responsibility for monitoring the existing financial systems, including the new fare collection system; contributed to the modernization of the revenue of the fare systems and financial applications as the business owner, department lead, and SMEs.
    Technologies: Data Analytics, Snowflake, Informatica Data Quality, Informatica ETL, Amazon S3 (AWS S3), Azure Data Lake
  • Director (Data Analytics and AI)

    2018 - 2019
    Wipro
    • Proposed solutions to accelerators after understanding the client's problems and business challenges as a partner of choice; presented the right approach with various accelerators available and aligned with the right product vendors.
    • Architected a solution on cloud data warehouses, enabling the client to close deals up to $68 million across accounts in mainly new transformation projects.
    • Got Snowflake into four major accounts for consolidation and transformation of the enterprise BI to the cloud while working with vendor teams.
    • Migrated from Azure SQL Server to Snowflake on the Azure platform, Talend for ELT, and Tableau for reporting for a tech client.
    Technologies: Snowflake, Collibra, Amazon Web Services (AWS), Azure
  • Senior Manager

    2011 - 2018
    Accenture
    • Built the company up to 300+ members with a revenue of $190 million a year, showing more than 100% growth.
    • Consolidated and centralized a bank's BI to a data warehouse on the cloud using AWS, Snowflake, Matillion for ELT and Tableau, and QlikView for reporting.
    • Managed a large wholesale profitability program to improve a bank's wholesale's ability to respond to risk management (including regulatory) requirements, serve customers, and grow revenue.
    • Architected a solution for revamping a financial and analytics transformation, replacing its existing financial system in the Americas. This was an opportunity to relook at other applications that integrate into and out of the financial systems.
    • Designed a solution in a data visualization application for helping the wealth management advisors for large global investment management (capital markets) better manage HNI clients' portfolios on their managed accounts.
    • Architected the assessment of the enterprise systems and account of charts for one of the major banks on the West Coast; presented the current issues, lack of governance, and a roadmap; executed the redesign of enterprise financial systems, including the new COA.
    • Led an assessment team to evaluate existing legacy applications at a medium-to-large-scale P&C insurance company in the Northeast; drew as-is and to-be process maps and charted down requirements into three sections: Mandatory, Required, Nice To Have.
    Technologies: Data Analytics, Amazon Web Services (AWS), Amazon S3 (AWS S3), Snowflake, Tableau, Qlik Sense, QlikView, Informatica Cloud, Informatica Data Quality
  • Solutions Director and Program Management

    2010 - 2011
    HCL Technologies
    • Assisted with presales activities and solution design for clients' business needs.
    • Assisted in winning a large deal with a sports B2C retailer for integrating their accounts payable systems to third-party vendors.
    • Presented an improvement plan in streamlining the financial systems for a Capital Market firm in New York and New Jersey.
    Technologies: Financial Data

Experience

  • Infectious Disease Data Exchange

    A public health informatics team within a state agency streams their Infectious Disease Data Integration platform (IDDI), which interacts with many local testing agencies across the state and reports to the governor’s office, the federal CDC for reporting. As part of this program, I provided suggestions re. data collections for the results from various test centers for COVID-19 used to report to the governor and the CDC are also used for contact tracing.

  • Enterprise Information Management for A Community College

    I worked closely with the vice president and CIO of a premier educational institution to develop an Enterprise Information Management (EIM) roadmap. This transformation was part of the IT solution used to modernize the college's information systems.

  • Migration of In-house SQL Server Databased to AWS RDS

    Served as the architect advisor collaborating with AWS architects to draw a roadmap to help a fintech client migrate their 2,500 SQL Server databases from in-house to an AWS platform. I assessed each database in isolation to see the level of complexity and its portability to Aurora or RDS.

  • Financial System Transformation

    I oversaw the existing financial systems, including the new fare collection system. I modernized the revenue of the fare systems and financial applications as the business owner, the department led, and the subject matter expert. I analyzed business requirements for inclusion in system design; maximized efficiencies and effectiveness through a detailed understanding of system functionality; identifying the right resources and tasks needed to design, implement, test, go-live, and maintain the system.

Skills

  • Tools

    Informatica ETL, Oracle E-Business Suite (EBS), Collibra, Tableau, Microsoft Dynamics AX, Qlik Sense
  • Paradigms

    Management
  • Other

    Data Analytics, Informatica Data Quality, PeopleSoft, Leadership, Architecture, Global Project Management, Windows 10, Informatica, Workday, Informatica Cloud, Azure Data Lake, AWS RDS, Financial Data
  • Languages

    Snowflake
  • Platforms

    Amazon Web Services (AWS), Azure, QlikView
  • Storage

    Amazon S3 (AWS S3), Data Integration, Microsoft SQL Server

To view more profiles

Join Toptal
Share it with others