Summary
Overview
Work History
Education
Skills
Websites
Certification
Accomplishments
Timeline
Generic

JAYAPRAKASH J

Frisco,TX

Summary

I am an IT professional with 16+ years of experience in Design, Development, Enhancement and Maintenance of Data Warehouse applications. I am playing a role of Cloud Solutions Architect with over 2 years of experience in designing, developing, and maintaining cloud-based solutions. My expertise lies in creating cloud architectures and deploying cloud-native applications. My experience ranges from working with public cloud providers such as Google Cloud Platform (GCP) and Snowflake. I am skilled in developing cloud-based solutions in a cost-effective manner, including the implementation of CI/CD pipelines and automation of various processes. My ultimate goal is to create reliable, secure, and scalable cloud solutions. Effective in developing and optimizing data systems to meet customer needs. Experienced Program Manager operating on multiple project deliverables at onsite/ offshore model.

Overview

17
17
years of professional experience
1
1
Certification

Work History

Solution Architect

Cognizant Technology Solutions Ltd
05.2022 - Current
  • Architected and deployed hybrid cloud solutions across multiple vendors including Snowflake, AWS & GCP; ensuring zero downtime during migration with no impact on customer facing services/applications
  • Developed high performance, scalable infrastructure for the company’s data analytics platform which increased throughput capacity by 30%
  • Developed database architectural strategies at modelling, design and implementation stages to address business and industry requirements
  • Technical architect for Teradata to GCP Migration for the project and responsible for data strategy movement, POCs and microservices development for plug in
  • Developed queries for ad hoc business project requirements, as well as KPI reporting through Pandas and Tableau
  • Created Spark Jobs to extract data from Hive tables and process the same using Dataproc
  • Historical data load to Cloud Storage using Hadoop utilities and load to BigQuery using BQ tools
  • Building metadata system where all available data is maintained and catalogued
  • Responsible for data loading services for the purpose of importing data from numerous disparate data sources, inclusive logs, relational, and non-relational databases
  • Develop and manage scalable data processing platforms that’s used for exploratory data analysis.
  • Monitored and tested application performance to identify potential bottlenecks, develop solutions and collaborate with developers on solution implementation.

AVP, Solution Architect

Bank Of America, NA
10.2016 - 04.2022
  • Responsible for the overall and owning architectural vision of the application
  • Streamlined the operational processes to be more efficient and cost effective (by reducing the costs of tape backups by 60%)
  • Developed computing strategies, which incorporates cloud adoption plans, application design, management and monitoring from existing BigData architecture
  • Historical data load to Cloud Storage using Hadoop utilities and load to BigQuery using BQ tools
  • Worked with solution and system architects (peers) to deliver enterprise class database tier solution and/or integration into custom product development
  • Designed and tested internal process improvements to automate repetitive tasks, shortening data delivery times and to keep track of deliverables through Jira and Jenkins
  • Performed systems and data analysis using variety of computer languages and procedures
  • Core technologies included BigData (Pyspark, Hive),Pandas(AI/ML), Data Mover(Teradata),ETL(DMX, Informatica),Report(Tableau) and SharePoint
  • Automated 3 reports through Pandas – Python(saving of 110+ hrs of efforts overall)
  • Migrated numerous legacy systems(DB2,SQL Server) to newer technologies(BigData, DMX), reducing costs and enhancing efficiency of computing tasks
  • Recruited, hired, and trained initial personnel, working to establish key internal functions and outline scope of positions for new organization and managed a team of 32 tech architects

Senior Analyst - Analytics

Cognizant Technology Solutions Ltd
09.2014 - 10.2016
  • Analyzed/Reviewed data and produced reports to assist in analysis and decision making to prioritize workload and ensure developed solutions met the business requirements
  • Performed Metadata management of the application through ER Studio for performing reverse data engineering
  • Mapped current business and operational processes and recommended areas for improvement for the Technology Migration project(Informatica to Big Data)
  • Building and maintaining SQL(Teradata BTeq) scripts, indexes, and complex queries for data analysis and extraction
  • Identifying data issues and providing recommendations for resolution to ensure optimal database performance
  • Diminished process gaps and encouraged optimal productivity by closely supervising workflows(Informatica,BASE SAS)
  • Established online configuration knowledge base to support functionality by developing robust system application overview
  • Completed data inflow from heterogeneous sources to Data lake through Pyspark, Base SAS Hive and Pig scripts
  • Utilized data visualization tools to effectively communicate business insights.

Technology Lead

UST Global Solutions Private Ltd
05.2014 - 08.2014
  • Participated in verifying compliance with service level agreements by maintaining technical uptime levels
  • Designed documentation protocols and standard operating practices to unify technology management efforts
  • As a Project Manager/Tech Lead for the project, understand and gather the high-level business requirements of the project and guide the team accordingly
  • Set up regular calls with Solutions architects to understand and analyze the data warehouse impact on the project
  • Performed the initial analysis on the database
  • Create business and technical specifications document and use case diagrams to handover to the reporting team to understand the data flow or the data impacts because of the new enhancements
  • Provide walkthrough of the requirement documents to the Reporting team
  • Led a team of 10 members at offshore location.
  • Partnered with architecture team to develop wholistic technology roadmap, accounting for departmental priorities and overall business goals

Software Developer

Tata Consultancy Services
02.2007 - 04.2014
  • Revised, modularized and updated old code bases to modern development standards, reducing operating costs and improving functionality
  • Collaborated on stages of systems development lifecycle from requirement gathering to production releases
  • Collaborated with project managers to select ambitious, but realistic coding milestones on pre-release software project development
  • Gathered and defined customer requirements to develop clear specifications for project plans
  • Supported the MicroStrategy application and the business users and tickets accordingly
  • Created various reports as per the client requirements using BTEQ in data warehouse environment using Teradata and Informatica
  • Project enhancements/POC suggested via Talend
  • Updated old code bases to modern development standards, improving functionality.

Education

PG Diploma - Data Science And Business Analytics

Texas McCombs University
India
02.2022

Master’s in Computer Technology -

Anna University, India
01.2006

Bachelor of Computer Science -

Madras University, India
01.2004

Skills

  • Data Warehouse/Data Lake
  • Machine Learning (Pandas (AI/ML))
  • BASE SAS, Informatica PC , Talend
  • Data mover, SAS EG, DMX
  • SQL(Teradata, SQL Server, DB2,Oracle)
  • Big Data Management(Pig, Hive, SQOOP, SPARK(PySpark))
  • BiqQuery,Airflow,DataProc,Dataflow(GCP)
  • Snowflake, AWS
  • Data Visualization (Tableau Desktop, MicroStrategy 90, BASE SAS)
  • Managing Key performance indicators
  • Migration Strategies and Data Retention
  • Technology Solution Design
  • Analytical(Splunk) and Critical Thinking
  • Agile and Scrum

Certification

  • Completed PG Diploma in Datascience and Business Analytics from Great Learning in collaboration with Texas McCombs University
  • Completed Azure Basics(AZ900), Google Digital Leader Certification
  • Scrum Master Certified Professional from Lean Pitch
  • Certified MDM SaaS Foundation level from Informatica
  • Certified MDM Data Governance Foundation level from Informatica

Accomplishments

  • Designed and Worked on Value add (Automatic Code generator tool) achieving savings of 65K for the project
  • Appreciated by Band 3 Level Manager from CIO for fixing an AISI and closing the project within a span of 4 months delivering a total of 11K code components
  • Led the innovation team and ended up filing 4 patents by the group

Timeline

Solution Architect

Cognizant Technology Solutions Ltd
05.2022 - Current

AVP, Solution Architect

Bank Of America, NA
10.2016 - 04.2022

Senior Analyst - Analytics

Cognizant Technology Solutions Ltd
09.2014 - 10.2016

Technology Lead

UST Global Solutions Private Ltd
05.2014 - 08.2014

Software Developer

Tata Consultancy Services
02.2007 - 04.2014

PG Diploma - Data Science And Business Analytics

Texas McCombs University

Master’s in Computer Technology -

Anna University, India

Bachelor of Computer Science -

Madras University, India

Similar Profiles

CREATE PROFILE
JAYAPRAKASH J