Managing Principal
2019 - PRESENTPetite 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 LakeDirector (Data Analytics and AI)
2018 - 2019Wipro- 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), AzureSenior Manager
2011 - 2018Accenture- 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 QualitySolutions Director and Program Management
2010 - 2011HCL 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
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 LLCData Analytics, Snowflake, Informatica Data Quality, Informatica ETL...
- WiproSnowflake, Collibra, Amazon Web Services (AWS), Azure
- AccentureData Analytics, Amazon Web Services (AWS), Amazon S3 (AWS S3), Snowflake...
Experience
- Data Analytics 15 years
- PeopleSoft 15 years
- Oracle E-Business Suite (EBS) 15 years
- Informatica Data Quality 8 years
- Informatica ETL 7 years
- Snowflake 6 years
- Tableau 6 years
- Collibra 4 years
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
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 SenseParadigms
ManagementOther
Data Analytics, Informatica Data Quality, PeopleSoft, Leadership, Architecture, Global Project Management, Windows 10, Informatica, Workday, Informatica Cloud, Azure Data Lake, AWS RDS, Financial DataLanguages
SnowflakePlatforms
Amazon Web Services (AWS), Azure, QlikViewStorage
Amazon S3 (AWS S3), Data Integration, Microsoft SQL Server
