JAYAPRAKASH J
Summary
Dynamic Solution Architect and Data Engineer with a proven track record at Cognizant Technology Solutions, specializing in enhancing data analytics platforms and cloud solutions on AWS and GCP, leading to a 30% increase in throughput. Demonstrates expertise in BigQuery and excels in cross-functional team leadership, driving efficient and innovative business solutions. Combines resourcefulness with strong client rapport-building skills to deliver impactful solution implementation support. Experienced in evaluating database performance and developing actionable strategies for continuous improvement.
Overview
18
18
years of professional experience
1
1
Certification
Work History
Solution Architect/Data Engineer Lead
Cognizant Technology Solutions
Richardson, USA
05.2022 - Current
- Company Overview: Client: CVS/AETNA – Richardson, TX
- Architectured 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
- Develop 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
- Oversee, design, and develop logic/algorithms for real-time data processing within the business and to create the frameworks that enable quick and efficient data acquisition
- 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
- Client: CVS/AETNA – Richardson, TX
AVP, Solution Architect
BA Continuum Private Solutions Ltd
Charlotte, USA
10.2016 - 04.2022
- Company Overview: Client: Bank of America – Charlotte, NC
- 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 60+ hrs of efforts overall)
- Migrated numerous legacy systems(DB2,SQL Server) to newer technologies(BigData, DMX), reducing costs and enhancing efficiency of computing tasks
- Responsible for a Data architect/Developer team of 26 people–oversight of hiring, training, and performance evaluation
- Client: Bank of America – Charlotte, NC
Senior Analyst - Analytics
Cognizant Technology Solutions
Hartford, USA
09.2014 - 10.2016
- Company Overview: Client: Aetna Healthcare – Hartford, CT
- 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
- Quickly learned new skills and applied them to daily tasks, improving efficiency and productivity
- Client: Aetna Healthcare – Hartford, CT
Technology Lead
UST Global Solutions Private Ltd
Indianapolis, USA
05.2014 - 08.2014
- Company Overview: Client: Wellpoint Healthcare – Indianapolis, IN
- 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
- Client: Wellpoint Healthcare – Indianapolis, IN
Software Developer
Tata Consultancy Services Ltd
Charlotte, USA
02.2007 - 04.2014
- Company Overview: Client: Bank Of America – Charlotte, NC
- 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
- Client: Bank Of America – Charlotte, NC
Education
Master’s - Computer Technology
Anna University
India01.2006
Bachelor - Computer Science
Madras University
India01.2004
Skills
- Data Warehouse Optimization
- Data Lake
- BigQuery
- Airflow
- DataProc
- Dataflow
- EC2
- AWS
- Redshift
- Snowflake
- Machine Learning
- Pandas
- BASE SAS
- Informatica PC
- Talend
- Data mover
- SAS EG
- DMX
- SQL
- Teradata
- SQL Server
- DB2
- Oracle
- Big Data Management
- Pig
- Hive
- SQOOP
- SPARK
- PySpark
- Solution development
- Data Visualization
- Tableau Desktop
- MicroStrategy
- Managing Key performance indicators
- Analytical
- Splunk
- Critical Thinking
- Agile
- Scrum
- Component integration
- DevOps implementation
- Technical project management
- Application modernization
- Database performance
- Performance optimization
- Client engagement
- Business solutions prowess
- Process analysis
- Enterprise architecture design
- Client relationship management
- Migration strategies
- Security and compliance
- Cross-functional team leadership
- Microservices architecture
- Data integration strategies
- Serverless architecture
Certification
- PG Diploma in Datascience and Business Analytics, Great Learning in collaboration with Texas McCombs University, MM/DD/YY
- AWS Cloud Practitioner, MM/DD/YY
- Azure Basics (AZ900), MM/DD/YY
- Google Digital Leader Certification, MM/DD/YY
- Scrum Master Certified Professional, Lean Pitch, MM/DD/YY
- MDM SaaS Foundation level, Informatica, MM/DD/YY
- MDM Data Governance Foundation level, Informatica, MM/DD/YY
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/Data Engineer Lead
Cognizant Technology Solutions
05.2022 - Current
AVP, Solution Architect
BA Continuum Private Solutions Ltd
10.2016 - 04.2022
Senior Analyst - Analytics
Cognizant Technology Solutions
09.2014 - 10.2016
Technology Lead
UST Global Solutions Private Ltd
05.2014 - 08.2014
Software Developer
Tata Consultancy Services Ltd
02.2007 - 04.2014
Master’s - Computer Technology
Anna University
Bachelor - Computer Science
Madras University