Data Architect Business Intelligence

VENKAT VALLATHARASU

Acton, Massachusetts ***** 781-***-**** *************@*****.***

U.S. Citizen

SUMMARY

An experienced, highly insightful technical leader, data architect, and senior consultant with comprehensive global and domestic expertise in data governance, information architecture, staff coaching and mentoring, data modeling, and cloud computing. Applies keen skills and insights across several diverse industries, including the banking, financial services, CRM, and service sectors. Works to bridge the gap between business and technology interests by conducting more formalized business functionality requests. Proven success in delivering business value and providing technical teams with the resources to achieve key goals and foster technical excellence.

Team Management Technical Advisory Multi-Cloud Data Platforms Data Warehouse Design MDM Reference Architecture Software Engineering Data Modeling Master Data Management Business Intelligence Cybersecurity Management Product Development Solutions Delivery Platform Development Client / Stakeholder Relations TECHNICAL SKILLS

Cloud Platforms: AWS, EMR, EC2, S3, DMS, RDS, Glacier, IAM, Redshift, CloudWatch, Lambda, Glue, Athena, DynamoDB, Azure, Azure Synapse, Snowflake, Aurora PostgreSQL

Big Data Ecosystem: Hadoop, MapReduce, Spark, Elasticsearch, Hive, HBase, Cloudera, Hortonworks, Kafka Tools: Talend, Informatica, Jaspersoft, Cognos, Tableau, MicroStrategy, BIRT, ER/Studio, Erwin, Power Designer, Clay Database Platforms: RedShift, Teradata, Oracle, MySQL, PostgreSQL, SQL Server, DB2, Informix, Ingres Software Development: Python, UNIX Scripting, SQL, C, C++, Perl EXPERIENCE

CDW (SIRIUS COMPUTER SOLUTIONS), Remote Managing Consultant, 2021-2024

Provided cloud data architecture solutions for modern data platforms.

Applied technical expertise and guidance to migrate data into modern data platforms under cloud technologies.

Worked with various executives and stakeholders to plan and estimate the timelines, budgets, and platforms for data modernization.

Led many data discovery, analysis, architecture, and roadmaps for the Data Lake solutions.

Acted as a liaison between technical and non-technical partners, translating business requirements into actionable data solutions.

Built, collaborated, iterated, and presented architecture and strategy to enterprise architecture and security.

Provided mentorship, coaching, and professional development opportunities to team members, fostering a culture of continuous learning and growth.

Built BI platform on AWS, using Redshift for the seaboard client, consolidating different forms of data sources into Snowflake for a fitness club client, BI solutions, using Azure Synapse analytics for a Financial Solutions client, logical reference architecture for a healthcare client, and BI solution for the mattress client by consolidating various source systems into Snowflake.

Environments: AWS Redshift, Glue, Snowflake, Talend, Azure Synapse, ADF, Aurora PostgreSQL, Power BI INFOLAYERS, Boston, Massachusetts Cloud Data Architect / Consultant, 2018-2021

Operated as big data architect/consultant for various pharmaceutical and information technology solutions clients.

Acted as a data architect for a healthcare client to analyze current state architecture and developed and proposed future state architecture with roadmaps in Azure cloud platform.

Served and operated as data architect for Sunovion Pharmaceuticals on project with groups to include medical affairs and managed market insights.

Performed and facilitated analysis on the entire data lifecycle by interacting with all stakeholders, current architecture, systems involved, and implementation flow.

Provided roadmaps to future state architecture (solution involved process governance, data governance, and AWS Data Lake to support all business functionalities).

Managed and completed a data governance architecture project for Biogen, with involvement from the marketing strategy and marketing operations group handling digital marketing.

Highlighted and evaluated ETL architecture, various source systems, data pipelines, underlying business logic, transformations, and targeted audiences.

Venkat Vallatharasu, Page 2

Documented the complete lifecycle of the current data flow. Facilitated strategies and solutions for data correctness to improve the effectiveness of campaign metrics, process flows, and data governance.

Generated updated blueprint of data architecture and suggested roadmaps for the future.

Fostered AWS solution architecture for SessionM. Built analytical platform for airline client to include customer data management, customer data analytics, campaigns and engagement, POS offer management, and loyalty management, including leading migration from Teradata to AWS Redshift.

Implemented MDM solutions for various sources and governed customer data for the same client.

Oversaw and managed reverse engineering of existing architecture and developed future state architecture with roadmaps and gap analysis for project proposals across multiple clients.

Involved in the generic design of data injection metadata-driven framework.

Environments: Linux, Talend, Informatica 10.2, Oracle 11g, Teradata, Hadoop, Hive, Spark, Python, AWS, EMR, AWS Redshift Spectrum, DynamoDB, AWS Lambda, AWS Glue, AWS S3, Airflow, Jenkins INFOGROUP, Burlington, Massachusetts Data Architect (Big Data and Analytics), 2012-2018

Managed offshore teams, supported enterprise-wide data initiatives, and participated in overall data warehouse/business intelligence strategy. Worked with customers, business analysts, and technical staff to design, develop, and enhance data warehouse components and business intelligence solutions involving big data AWS cloud environments.

Implemented custom-made business intelligence solutions for enterprise clients. Designed data model and ETL framework. Participated in business requirements gathering, BI design, and initial analysis. Led global development team.

Designed and implemented analytical Data Lake for retail clients.

Involved in redesigning EDW as a Central Database platform for Yesmail Enterprise reporting and analytics product(s).

Assumed lead in several key business initiatives, including the architecture of a new data engineering platform, omnichannel marketing, and analytics solution strategies, utilizing AWS Cloud Computing and Big Data for Marketing Platform.

Designed and implemented a digital data onboarding process for clients.

Cultivated hands-on experience with three client-specific project implementations, using AWS solutions involving AWS EMR, EC2, S3, Glacier, Redshift, Hadoop, Hive, and Athena.

Gained hands-on experience in setting up AWS clusters, configurations, and sizing while providing access.

Environments: Linux, AWS, Hadoop, Cloudera, EMR, Hive, Elasticsearch, Python, AWS Redshift, DynamoDB, MySQL, AWS S3, Glacier, IAM, Python, Jaspersoft, Tableau, Talend, Oracle 11g, ER / Studio, Jira, Git ADDITIONAL EXPERIENCE

INFOLAYERS, Boston, Massachusetts, Data Architect / Consultant, 2004-2012. Acted as information architecture consultant for various financial companies and information technology solutions companies, including serving as data modeler for projects on centralized common portfolio reference data management (Fidelity); and data architect to provide architectural solutions for new data access layer (Putnam Investments); data architect for evaluation of business intelligence architecture roadmap (Harte- Hanks); data architect for project IT strategy for CRM Services (Bank of America); data architect for WIM-BI team and WIM lines of business (Bank of America). Drafted current state versus future state architecture roadmap. SPSS (f.k.a. NETGENESIS), Boston, Massachusetts, Senior Database Architect, 1999-2004. Provided data architectural blueprint from the standard product model to the enterprise product model. Facilitated product extension, incorporated new technologies, led Oracle 9i product evaluation, drove knowledge transferring, provided successful deployment, and developed tuning guidelines for high-end customers (various business environments). Designed database standards and best practices for performance benchmarks and guidelines for performance tuning. Set up standards for data warehousing and high-performance data marts and ETL processing.

EPSILON, Burlington, Massachusetts, Database Architect / Systems Engineer, 1997-1999. Performed requirements gathering from business and technology areas as well as high-level design and physical design and logical and physical database modeling for very large databases (including terra bytes data warehouse environment). Involved in key initiative framework database standards, ETL development process design, and database development standards. Implemented best practices and methodology for data warehousing environments. Provided architecture design for implementation of multiple decision support system databases for various customers (i.e., retail, consumer, financial, telecommunications, nonprofit, and technology). EDUCATION

NATIONAL INSTITUTE OF TECHNOLOGY Tiruchirappalli, India, Master of Computer Applications

Contact this candidate