Venkatraman is currently unavailable
Venkatraman Subramaian
Verified Expert in Engineering
Enterprise Solution Architect and Developer
Austin, TX, United States
Toptal member since March 8, 2022
Bio
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.
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
- Data Analytics - 15 years
- Informatica Data Quality - 8 years
- Azure - 7 years
- Informatica ETL - 7 years
- Tableau - 6 years
- Snowflake - 6 years
- Amazon S3 (AWS S3) - 5 years
- Collibra - 4 years
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.
Work Experience
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, Software Architecture
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, Collibra, Tableau, Microsoft Dynamics AX, Qlik Sense
Paradigms
Management
Platforms
Azure, Amazon Web Services (AWS), QlikView
Languages
Snowflake
Storage
Amazon S3 (AWS S3), Data Integration, Microsoft SQL Server
Other
Data Analytics, Informatica Data Quality, Leadership, Architecture, Global Project Management, Software Architecture, Technical Leadership, Windows 10, Informatica, Workday, Informatica Cloud, Azure Data Lake, Amazon RDS, Financial Data
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