Summary
Overview
Work History
Education
Skills
Certification
Projects
Personal Information
Languages
Timeline
Generic

Manoj Manoharan

Berkeley Heights,USA

Summary

A seasoned Onsite Team Lead at Axtria LLC, I excel in ETL and Informatica Power Center, demonstrating exceptional leadership by spearheading projects that halved job run times. My proactive client engagement and adept problem-solving skills ensure project deliverables exceed expectations, showcasing a blend of technical prowess and team management acumen.

Overview

12
12
years of professional experience
1
1
Certification

Work History

Onsite Team lead

Axtria LLC
04.2023 - Current
  • Working as Onsite Team lead
  • Requirement gathering from Clients/Stake holders, prioritize the monthly tasks and effort estimation
  • Handling the daily stand-up call with the offshore team and making sure there is no delay/risk in the deliverables
  • Creating/maintaining the JIRA Stories/tasks and assigning the tasks to the team accordingly
  • Recurring technical discussions with the data steward
  • Frequent in-person meetings with clients to provide updates on the current CR/SOW status
  • Code review among the team and provide valid review comments to the team to deliver the code to meet exact business expectations
  • Examine the code and data to resolve the clarifications or issues raised by multiple downstream processes, root cause analysis (RCA), and corresponding fixes
  • Collaborate with the Infra Admin team to address any issues in the cluster and monitor the server health
  • Developed Python scripts to automate the sending of referral emails to clients on a daily basis
  • Worked as a POC on a streamline project that successfully reduced overall job run time by 50%
  • Working with multiple source teams and understanding upcoming changes
  • Worked on performance tuning in Redshift and PySpark which helps the jobs to run faster and efficiently
  • Managing the performance ratings and helping the team members with their career improvements
  • Conduct interviews for internal project recruitment

Sr. Full Stack Engineer

Cognizant technology solutions US Corp
Nashville, USA
07.2022 - 04.2023
  • Analysis, design and develop Data Models, Extract-Transform-Load and premeditated solutions based on heterogeneous data sources for data acquisition and integration projects in Healthcare Medicare and Medicaid business domains
  • Works on Informatica Mappings, Teradata Stored procedures, SQL Server, Active Batch, Python, AWS S3 and Redshift etc
  • To load the data from source to staging, staging to DataMart layer and DataMart layer to provisioning layer to provide the data to the business users as per requirements
  • Interacts with DBA team for database objects creation required for Dev and other higher environments
  • Responsible for higher environments deployment and ETL Jobs custom and dependency scheduling
  • Test and validate the code and Data in lower environments using Informatica and Teradata utilities to ensure there is no data leakage/code error which will result zero/minimal defects
  • Coordinate with the production support teams to identify any potential failures or issues in the system and suggest workaround and recommendations
  • Identify memory leakage and performance bottlenecks and involve in fine-tuning of SQL overrides and Informatica code to guide the team
  • Code review among the team and provide valid review comments to the team to deliver the code to meet exact business expectations
  • Code and Data review with the Senior Architect to get the sign off
  • Daily Meeting/Discussions with the development and Production support team for the smooth application deliverables

Sr. Full Stack Engineer

Cognizant technology solutions
Coimbatore, India
08.2020 - 07.2022
  • Analysis, Design, Development and Unit Testing of the HI2 – P2P Project requirements
  • Interaction with the stakeholders to understand the changes needed to meet business needs and convert those to technical requirements and to devise & deliver a robust solution
  • As part of HI2 – P2P Project, he will be developing Jobs using Teradata Tools & Utilities, Informatica Power Center, and Python, as well as writing the Unit & Integration Test Scripts
  • Besides, Responsible for Production data validation upon migration and to support during warranty period
  • Documenting the design and architecture and keeping the specification documents up to date along with required sign-off from Product Owner and other stakeholders
  • Ensure that the data pipelines are developed and deployed according to the functional requirements
  • BCP Coordinator, POC for the access requests and working as a mentor for the new joiners in the team

Sr. Developer (Technical Lead)

Cognizant technology solutions
Coimbatore, India
10.2017 - 07.2020
  • Team-lead of the offshore team consists of more than 10 members which leads to the successful implementation of R1 to R10 releases
  • Part of the Design phase of TranZform data store module to build the data lake using Hive, Cloudera, Informatica BDM and Run Deck scheduler tool
  • Good knowledge in Beeline and Impala and worked on configuring Oracle Golden Gate to configure HDFS files from Oracle transaction logs which is used as a source for hive external tables
  • Good knowledge in Hive and HDFS file handling & Hands on experience in HDFS Text, Parquet and ORC file formats
  • Worked in Informatica BDM mapping using HDFS as source and executed using Map Reduce engine, then fixed the performance related issues using Spark engine and gained a good understanding in setting up the spark driver, executor memory and cores in Informatica BDM
  • Trained the team members to learn Informatica BDM 10.2 quickly which eases the deliverables and provided technical strategies and directions to offshore Informatica developers with the past ETL experiences

Technical Lead

Cognizant technology solutions
Coimbatore, India
04.2017 - 09.2017
  • ETL developer in the project XEROX - EBT - XSBI Lift & Shift Migration
  • Worked in the VMware Setup and Installation of Software’s in Dev/QA/PROD Box and handled VPN & Firewall Setup
  • He was handing in pilot development (DEV, QA, PROD) - Test Network connectivity, Server Availability (web servers, app Servers, Db), UNIX & ETL Code Migration, Post deployment code validation, ETL Testing, Prepare data balancing report, Data copy & balance reconciliation, Daily and Monthly load scripts, State User Post Prod Validation Support, Support for Alteryx & R tools for data security
  • Coordinated with DBAs to schedule the Attunity tool as part of ETL jobs
  • Worked on the changes for ETL mappings, complex UNIX scripts and PL/SQL blocks, granular level unit testing and prepared detailed test document for SAT team

Technical lead

Cognizant technology solutions
Coimbatore, India
06.2014 - 03.2017
  • Handled all the lead activities from Offshore – Task Assignment, Release Management POC, Development POC and POC for Scrum and other Status calls
  • Involved in the requirement gathering from stakeholders and design data models and participating in concept session to gather the requirements for each user stories and directs the offshore team to create the mapping documents
  • Worked on End-to-End coding in functional areas like Provider, Member, TPL and Claims, preparation of Mapping specification sheet using LLD and HLD documents, Design medium to complex Inbound/outbound/DB mappings/mapplets using expression, filter, router, Normalizer, rank, update strategy, Lookup, SQL transformations in mapping/mapplet designer, all SCD type methodologies and loaded DataMart and OLAP
  • Involved in additional logics implemented using advanced SQL procedures, PL-SQL, Views and Triggers in oracle 10g and worked extensively in creating sessions, workflows, command tasks and other objects like decision task in Workflow manager
  • Prepared and delivered CSD (COTS Software Deployment) Document, handled Version One tool to update all the CA activities on a daily basis
  • Part of Xerox mock audit team and a POC for Cognizant automation tool – Platinum (Code Reviewer and Data generator)

SSIS/ETL Developer

Cognizant technology solutions
Coimbatore, India
07.2013 - 05.2014
  • Key resource in the project and was a part of both analysis and development part
  • Worked on DTS packages and developed SSIS packages
  • Part of preparing requirement analysis, Technical Design document, UTC and Code drop documents and also done LLD and HLD (Activity and sequence diagrams) by using the IBM tool RSA and performance tuning for each SSIS packages
  • Handled WLM job set up, sanity test in DEV and other regions, converting inline SQL queries to Stored Procedures and handled maintenance/Production support

Informatica ETL Developer

Cognizant technology solutions
Coimbatore, India
10.2012 - 06.2013
  • Worked on Manual Data Setup – MDS is a data that would normally be entered into the system manually through the UIS (User Interface Screens)
  • Prepared the Balancing Report (BR) and Mapping for BR and developed BR Automation
  • Worked on complex code development in Informatica and has delivered complex defects with proper RCA
  • POC for maintaining the Code Parameterization and documented Defects/CR trackers, CR graphs, UTC's, Resolution Document preparation and Release document preparation
  • Helped the team with different Environment Dry runs and he also experienced working in Schema Comparison tool (TOYS)

Education

Master of Computer Applications (MCA) -

Amrita Vishwa Vidyapeetham
India
03-2012

BSc - Mathematics

NSS College
India
03-2009

(XII) - Computer Science

GV HSS Cherpulassery
Kerala, India
03-2006

(X) - SSLC

HSS Katampazhipuram
Kerala, India
01.2004

Skills

  • ETL
  • Informatica Power Center
  • Informatica BDM
  • Oracle Warehouse Builder
  • DTS
  • SSIS
  • Tableau
  • Cognos
  • Oracle
  • MS SQL
  • SQL Server
  • Hive
  • Beeline
  • Impala
  • Teradata
  • Toad
  • UNIX Shell Scripting
  • Python
  • PySpark
  • AWS
  • Redshift
  • Athena
  • S3
  • EC2
  • DynamoDB
  • Dataiku
  • Clear case
  • Clear Quest
  • GIT
  • JIRA
  • Visual Studio
  • Attunity
  • UML Rational Rose
  • Visio
  • Control-M
  • Run Deck
  • Active Batch
  • Golden Gate

Certification

  • Informatica University certified professional in Power Center Data Integration 9.x: Developer Specialist
  • AWS Cloud Practitioner Certified professional
  • Oracle Cloud Infrastructure Foundations Associate Certified professional
  • External Certification in ComEx and Global English

Projects

Commercial Data Platform Development and Enhancements, Project Leader, 04/2023 - Ongoing, Berkeley Heights, New Jersey, AWS (Redshift, S3, EMR etc.), Python, PySpark, Unix Shell Scripts, Control M, JIRA, Dataiku, MS SQL Server Cigna SI ETL Development, Sr. Full Stack Engineer, 07/2022 - 04/2023, Nashville, Tennessee, Informatica Power Center 10.x, Teradata, Python, Unix Shell, Active Batch, GIT, SQL Server, JIRA, Service Now, AWS - Redshift, Athena, S3, EC2, EMR, DynamoDB, Python, PySpark Cigna C - Offshore Health Spring Execution POD, Sr. Full Stack Engineer, 08/2020 - 07/2022, Coimbatore, Tamil Nadu, Informatica Power Center 10.4, Teradata, SQL, Unix Shell/Active Batch scripting, Python, Active Batch, GIT, SQL Server, JIRA Emblem Health, Sr. Developer (Technical Lead), 10/2017 - 07/2020, Coimbatore, Tamil Nadu, Informatica BDM, Spark/Scala, SQL/PL SQL, Unix Shell scripting Xerox - EBT - XSBI Lift & Shift Migration, Technical Lead, 04/2017 - 09/2017, Coimbatore, Tamil Nadu, OWB, Attunity/Golden Gate, SQL/PLSQL, Shell Scripting Xerox – Global healthcare solutions (NH/CA/NY - TMSIS), Technical lead, 06/2014 - 03/2017, Coimbatore, Tamil Nadu, Informatica Power Center 9.x/8.5.1, Informatica Power exchange9.x, SQL/PLSQL, Unix Shell Scripting Medisys DTS and VB Conversion – WellPoint - Health care, SSIS/ETL Developer, 07/2013 - 05/2014, Coimbatore, Tamil Nadu, RSA, SSIS, SQL, PLSQL, Unix Shell Scripting ACS DW Phase 2 - Health care, Informatica ETL Developer, 10/2012 - 06/2013, Coimbatore, Tamil Nadu, Informatica Power Center 9.x, Informatica Power Exchange 9.x, Oracle SQL developer, Putty, FileZila Client, MATT tool

Personal Information

Visa Type: H1B

Languages

English
Full Professional
Hindi
Limited
Malayalam
Full Professional
Tamil
Professional

Timeline

Onsite Team lead

Axtria LLC
04.2023 - Current

Sr. Full Stack Engineer

Cognizant technology solutions US Corp
07.2022 - 04.2023

Sr. Full Stack Engineer

Cognizant technology solutions
08.2020 - 07.2022

Sr. Developer (Technical Lead)

Cognizant technology solutions
10.2017 - 07.2020

Technical Lead

Cognizant technology solutions
04.2017 - 09.2017

Technical lead

Cognizant technology solutions
06.2014 - 03.2017

SSIS/ETL Developer

Cognizant technology solutions
07.2013 - 05.2014

Informatica ETL Developer

Cognizant technology solutions
10.2012 - 06.2013

Master of Computer Applications (MCA) -

Amrita Vishwa Vidyapeetham

BSc - Mathematics

NSS College

(XII) - Computer Science

GV HSS Cherpulassery

(X) - SSLC

HSS Katampazhipuram

Similar Profiles

CREATE PROFILE
Manoj Manoharan