Sr. Solution Architect

Venkata Veluguri

Title:

Bigdata and Talend Solution Architect

Location:

VA, USA

Certifications:

Talend Data Integration and Big Data

Experience Summary

Venkata has over 19+ years of consulting experience (13 yrs. in US, 1 yr. in AU, 2 yrs. In CA, 3 yrs. in India). Over the years he has managed projects as Project Manager, Lead Analyst, Talend Architect, Big Data Architect, Data Quality Architect and as Systems Analyst, application Developer, Off- Shore Facilitator, Team Lead, and Delivery, Data Warehousing, Architect along with experience with executive presence at client executive leadership levels

He has a proven track record and has demonstrated many successes within the areas of planning, designing, and implementing various information systems and IT solutions spanning different industries to name a few are Finance, Banking, Healthcare and Retail chain.

KEY SKILLS:

Functional: Project Management, Delivery Architect, Team Building, Team Leader, Business Analysis and Development, Excellent Communication and Interpretation skills

Technical: Hands-on experience in ETL, Big Data, Cloud. Building extensive data warehouse, data migration using industry leading tools (Talend family of products, Informatica family products), Big Data (Cloudera, Hortonworks, HDInsight) BI Reporting (Power BI), Cloud (AWS, MS Azure), Databases (Oracle, Teradata, SQL Server and DB2) Dimensional Modeling, Data migration in Enterprise Architecture environments.

In addition, Venkata has been involved with

Estimating and planning on new projects

Being a solution advisor on new technologies

Executing initial proof of concepts

Estimating ROI

Cross training team using Talend Tools

Experience

Assist in defining scope and sizing of work; and anchor Proof of Concept developments.

Provide solution architecture for the business problem, platform integration with third party services, designing and developing complex features for clients' business needs.

Provide technology direction, ensures project implementation compliance, and utilizes technology research to innovate, integrate, and manage technology solutions.

Collaborate with some of the best talent in the industry to create and implement innovative high-quality solutions, participate in Sales and various pursuits focused on our clients' business needs.

Mentor Junior Architects and /or development team members

01

Type of Industry:

Media / Film

Project Description:

Client seeks to establish a Data Warehousing platform on both cloud and on primis to process and analyze digital media for the business continuous improvement of advertisement and sales.

Role/Title:

Sr. Solution Architect

Project Duration:

Jan 2018 till date

Responsibilities:

Performed assessments and independently led Architecture definitions for Bedrock to Talend initiatives using Talend;

Installed and configured Talend Tools in both on-prem and cloud.

Predicted and advised on business requirements, processes, application systems for the program;

Mentored and lead complex initiatives, well versed with technology trends;

Strong technical expertise in Talend, Hortonworks, Azure / AWS, Big data skills set;

Completed template jobs / accelerators / reusable frameworks;

Participated in requirement gathering, analysis, translating functional requirements to technical requirements, BI Architecture, Data modeling, Design and validation;

Operating Systems:

UNIX & Windows

Software / DB/Languages:

Teradata, Snowflake, MYSQL, SQL Server, Hortonworks, Microsoft Azure, GitHub etc.,

Special Tools:

Talend 7x

02

Type of Industry

Health Care

Project Description:

Client seeks to establish Microsoft Azure Data Lake to load data from multiple business units. Later cleanse, validate and derive data to create reports, and ability to obtain data quickly and easily and displayed in various formats as needed.

Role/Title:

Delivery Architect

Project Duration:

One year (Jan 2017 to Dec 2017)

Responsibilities:

Liaised with offshore team and clients to resolve technical dependencies, issues, and risks.

Mentored and provided architectural guidance to multiple teams building innovative applications

Driven common vision, practices and capabilities across teams.

Hands on experience using various ETL tools like (Talend and Informatica), and Big data (Cloudera, Hortonworks). Also proficient with SQL, Complex SQL Tuning, Stored Procedures, SQL Server Data Warehousing best practices etc.,

Implemented ETL framework to audit, balance and control data (ABC) and supported the ETL platform on a day-to-day basis to insure high availability

Operating Systems:

UNIX and Windows

Software / Languages:

HDInsight, Microsoft Azure, SQL Server

Special Tools:

Talend 6.4x

03

Type of Industry:

Chemical Industry

Project Description:

Client seeks to establish a big data platform and data science infrastructure in multiple business units to enable empirically-driven business insights for continuous improvement of manufacturing, marketing, and procurement processes

Role/Title:

Solution Architect (Talend and Big Data)

Project Duration:

Six months (June 2016 to Dec 2016)

Responsibilities:

Provided architectural solutions/designs to project execution teams for implementation.

Provided technology architectural assessments, strategies, and roadmaps for Talend and Big Data technology domains

Worked with Client/Business Analysts to understand functional requirements and interact with other cross-functional teams to architect, design, develop, test, and release features.

Developed Proof-of-Concept projects to validate new architectures and solutions.

Supported multiple Agile Scrum teams with planning, scoping and creation of technical solutions for the new product capabilities, through to continuous delivery to production.

Operating Systems:

UNIX & Windows

Software / Languages:

JAVA, Databases (Oracle, SQL Server), Hortonworks and HDInsight, MS Azure

Special Tools:

Talend 6.5x

04

Type of Industry:

Cable and Digital Industry

Project Description:

Client seeks to establish a National Data Warehouse (NDW) for reporting and analysis of its subscriber activity information and to receive a 360 degree view of the billing information

Role/Title:

Solution Architect (Talend and Big Data)

Project Duration:

Two years (June 2014 to June May 2016)

Responsibilities:

Used Teradata EDW and Flat files as sources and ingested to Edge Node using File Transfer tools (Flat Files), Storm (Realtime Data) and Sqoop (for Database Tables).

Created different workflows for different types of loads (Insert Only, SCD 1 and SCD 2)

oIngestion: Loading data into the HDFS using either Storm or Sqoop

oPreparation: Data cleansing and data transformation. This data is used for reporting and data analysis purpose.

oDispatch: At the end of preparation job the Dispatch Data is created to be exported to Teradata ICDW (Semantic Layer). Sqoop export used to transfer data to TD.

In a high level, created three set of jobs 1. Ingestion 2. Preparation and 3. Dispatch

Supported code/design analysis, strategy development and project planning

Operating Systems:

UNIX & Windows

Software / Languages:

Informatica, Talend, Databases (Teradata, Oracle, SQL Server), Cloudera and Hortonworks, AWS

Special Tools:

Informatica 9.5x, Talend 6.1x

05

Type of Industry

Finance / Banking / Insurance / Auto

Project Description:

The Debt Manager Replacement project will provide a replacement for the existing Debt Manager application (in Oracle) with the RECOVERY application (in SQL Server).

Role/Title:

Data Warehouse Architect

Project Duration:

10+ Years (Sep 2004 to May 2014)

Responsibilities:

Audit data of various functional areas and create quality dashboards

Assist with data management activities within the data and analytics area

Lead issue identification, investigation, ownership, communication and resolution process

Analyze application systems and programming logic problems and if necessary, revises logic and procedures

Define the overall BI data architecture including ETL processes, ODS, EDW and data marts

Work with the data architect to ensure that logical and physical data models support the analytic needs of the business

Understand client’s requirements, creating data lineage documents

Day to day co-ordination with development and QA team, data base/support team and third-party clients

Operating Systems:

UNIX and Windows

Software / Languages:

Oracle, SQL Server, DataStage, Tidal, HP Quality Center

Special Tools:

Informatica 9.5x

Training, Certifications & Affiliations

Certifications: Talend data integration and big data.

Trainings: Talend Data Quality and Administration,

Engagement Management, The Open Group Architecture Framework (TOGAF)

MS Azure, AWS, Hortonworks, Spark

Higher Education

Masters Degree in Systems Engineering (Major Computer Engineering)

Contact this candidate