Summary
Overview
Work History
Education
Skills
Certification
Languages
Timeline
Generic

Philip Manalel Jose

Boise,ID

Summary

Dynamic ETL Developer with a proven track record at Cognizant Technology Solutions, excelling in problem-solving and teamwork. Successfully migrated legacy ETL architectures to Azure, optimizing SQL queries and enhancing data integration processes. Adept at managing multiple projects while delivering exceptional results under tight deadlines, demonstrating strong communication and technical documentation skills.

Overview

9
9
years of professional experience
1
1
Certification

Work History

Senior Associate

Cognizant Technology Solutions, US
01.2024 - Current
  • Analyzed existing on-prem ETL architecture to migrate to Azure cloud architecture.
  • Provided solutions to configure DB connections via Tidal scheduler by eliminating the use for existing configuration files.
  • Facilitated in code refactoring to enable environmental variables and version upgrade for Azure cloud 2022.
  • Assisted in Managed File Transfer (MFT) Shared services for file movement in cloud.
  • Worked in Informatica PowerCenter for cloud migration.
  • Worked with Facets team to migrate core facets jobs to cloud.
  • Participated in cloud job migration with DevOps, Terraform and Tidal team for SSIS, Informatica and SSRS reports.
  • Got appreciation email from CEO for successful completion of MF2 Migration project.
  • Worked well in a team setting, providing support and guidance.
  • Skilled at working independently and collaboratively in a team environment.
  • Proved successful working within tight deadlines and a fast-paced environment.
  • Resolved problems, improved operations and provided exceptional service.
  • Used strong analytical and problem-solving skills to develop effective solutions for challenging situations.
  • Demonstrated strong organizational and time management skills while managing multiple projects.

Senior Associate

Cognizant Technology Solutions, CTS
03.2022 - 12.2023
  • Redesigned legacy Sybase scripts to SQL scripts for migration.
  • Worked with Facets team to understand facets tables for SQL query optimization,
  • Designed integration tools to combine data from multiple, varied data sources such as RDBMS, SQL and big data installations.
  • Streamlined data flow between multiple systems through the creation of efficient ETL pipelines and APIs.
  • Wrote and optimized in-application SQL statements.
  • Assisted in the migration of legacy systems to modern platforms, ensuring seamless integration with existing workflows.
  • Utilized code versioning systems such as GitLab to reduce development times.
  • Interpreted data models for conversion into ETL diagrams and code.
  • Mentored junior developers on best practices in ETL development, fostering a culture of continuous learning within the team.
  • Enhanced ETL processes by optimizing complex SQL queries and streamlining data extraction procedures.
  • Reduced processing time for ETL tasks through the implementation of parallel execution strategies.
  • Documented technical specifications and designs, facilitating knowledge sharing among team members and supporting future development efforts.
  • Documented and communicated database schemas using accepted notations.

Associate Consultant

Flextronics
04.2021 - 03.2022
  • Worked as an ETL Lead in a team of five members for ETL design and implementation.
  • Built numerous SSIS packages for Incremental and full load data transfer.
  • Have worked on different transformations such as Data Conversion, Merge, Merge Join, Multicast, Sort, Aggregate, Lookup, Conditional Split, Derived Column, Union All, etcetera.
  • Created SSRS reports with subscription for month-end and yearly reporting for customers.
  • Have experience in different reporting types like Parameterized Reports, Linked Reports, Cached Reports, Clickthrough Reports, Subreports, etcetera.
  • Developed custom scripts for SFTP file transfer.
  • Collaborated closely with cross-functional teams to devise effective strategies and action plans for clients'' businesses.
  • Managed multiple projects simultaneously while maintaining attention to detail, organization, and adherence to deadlines.
  • Delivered high-quality presentations showcasing key findings and recommendations to both internal stakeholders and clients.
  • Maintained database systems to track and analyze operational data.
  • Provided reporting for forecast analysis and ad-hoc reporting in support of decision-making.
  • Collected, arranged, and input information into database system.
  • Evaluated staff performance and provided coaching to address inefficiencies.

Systems Analyst

Flextronics
05.2016 - 03.2021
  • Built and optimized SQL queries for faster performance and efficiency.
  • Developed custom scripts for SFTP file transfer.
  • Worked in Automation testing in ASP.NET web application.
  • Created detailed documentation for both internal reference and client-facing presentations, improving communication between stakeholders.
  • Conducted thorough requirements analysis to ensure software solutions met business needs.
  • Identified and resolved system bottlenecks, leading to more efficient operational workflow.
  • Developed custom scripts to automate routine tasks, saving valuable team hours.
  • Enhanced team collaboration by implementing shared documentation platform for project tracking and communication.
  • Optimized database performance, which allowed for quicker data retrieval and reporting.
  • Provided expert technical support, reducing system downtime and minimizing disruptions to daily operations.
  • Collaborated with upper management to drive strategy and implement new processes.
  • Communicated and explained business requirements to team members to understand and implement functional demands.

Education

Master of Computer Applications - Computer Science

Loyola Collge
Chennai, TN
03-2016

Skills

  • SQL Server Integration Services (SSIS)
  • SQL Server Reporting Services (SSRS)
  • Informatica PowerCenter
  • SQL
  • PL/SQL
  • Teamwork and collaboration
  • Problem-solving
  • Multitasking
  • Excellent communication
  • Adaptability and flexibility
  • Interpersonal skills
  • Time management abilities
  • Technical documentation and reporting

Certification

  • Azure DevOps Training - [Internal]
  • Microsoft SSIS Training - [Internal]
  • AX D365 SSRS Reporting Training - [Internal]
  • Generative AI Training - [Internal]

Languages

English
Full Professional
Malayalam
Native or Bilingual
Tamil
Full Professional

Timeline

Senior Associate

Cognizant Technology Solutions, US
01.2024 - Current

Senior Associate

Cognizant Technology Solutions, CTS
03.2022 - 12.2023

Associate Consultant

Flextronics
04.2021 - 03.2022

Systems Analyst

Flextronics
05.2016 - 03.2021

Master of Computer Applications - Computer Science

Loyola Collge

Similar Profiles

CREATE PROFILE
Philip Manalel Jose
Want your own profile? Build for free at LiveCareer.com