NARENDRA AWASTHI
DATA ENGINEER
NOIDA
Summary
9+ years of extensive experience in Big Data integration with extensive handson on AWS cloud, JIRA Cloud, CA Workload Automation, Airflow, Postman, Github, Big Data Intg via Hadoop, TWS, Tidal, Hive, PySpark, analytics, testing, IDD, IDQ, MDM and troubleshooting of data driven business critical applications. Creates linux scripts to streamline data flow across different (ETL/Oracle/Reltio) platforms; Provides timely and accurate updates to internal stakeholders and management via POC driven approach; Maintains documentation; Minimizes company exposure to risk by understanding and following all recommended processes. Also having Beginner Level Handson Power BI Reporting/MSTR Developer.
Overview
9
9
years of professional experience
2016
2016
years of post-secondary education
Work History
Senior Tech Analyst
AMERIPRISE FINANCIAL LLP
12.2022 - Current
- Role: Leading Financial Technical Operations on Big Data
- Technologies: AWS (All Products S3, EC2, EMR, Athena, Cloudwatch, Cloudformation, Glue, Events, Subnets, Rules, Lambdas), Informatica, Linux, Oracle, Data Warehousing, PySpark.
- Providing Top Notch Innovative solutions for Financial Processes using AWS Tools, PySpark & streamlining existing processes in Legacy Tech such as Informatica, Oracle, Linux.
Information Technology Analyst
TATA CONSULTANCY SERVICES LIMITED
03.2016 - 12.2022
- Client- Eli Lilly & Co
- Projects involved are as follows:
- A) Role: Associate
- Project: TCS BIPM (Business Image Process Management) Training
- Duration: Mar 2016 - Aug 2016
- Description: Learnings and various trainings at TCS ILP Centre.
- Technologies: ETL Development in Informatica (PowerCenter), Unix Shell Scripting in PuTTY, Oracle PL/SQL Dev in SQL Developer & Python.
- B) Role: Module Lead (from Jan 2020) previously Senior Associate
- Project: Enterprise Attribute Alignment (Client: Eli Lilly & Co.)
- Duration: Aug 2016 - Present
- Description: Mapping Geographies. Products and sales representatives of the client with each other.
- Technologies: Citrix, ETL Development in Informatica (PowerCenter, IICS Application Integration and Data Integration, API Management, MDM, EDC), Jira Cloud, Unix Shell Scripting in PuTTY, ServiceNow, CA Workload Automation, SQL & PL/SQL Dev in SQL Developer, Postman, Airflow, Big Data Development in PySpark and Python ingestion with Big Data tools and platforms such as Hadoop, Hive, Spark, Python Web knowledge usage, AWS Cloud, AWS Redshift, AWS S3, Dynamo, Glue, Cloudtrail, CloudWatch.
- C) Role: Module Lead
- Project: Veeva CRM (Client: Eli Lilly & Co.)
- Duration: Aug 2020 - Present
- Description: Managing Client Relationships/Affiliations and interactions with the representatives along with maintaining cross platform declarations and consents.
- Technologies: Citrix, ETL Development in Informatica (PowerCenter, IICS Application Integration and Data Integration, API Management, IDQ, IDD, MDM, EDC), Jira Cloud, Unix Shell Scripting in PuTTY, ServiceNow, CA Workload Automation, SQL & PL/SQL Dev in SQL Developer, Big Data Developer in PySpark and Python ingestion with Big Data tools and platforms such as Hive, ERP Basic, AWS Cloud, AWS Redshift, AWS S3, Dynamo, Glue, Cloudtrail, CloudWatch.
- D) Role: Module Lead
- Project: Customer MDM (Institution Profile Catalogue/Hub) (Client: Eli Lilly & Co.)
- Duration: October 2020 - Present
- Description: Managing profiles of clients, representatives, events, publications in a holistic manner in by leveraging various tools, ideologies, business logics of and for the client at a single place.
- Technologies: Citrix, ETL Development in Informatica (PowerCenter, IICS Application Integration and Data Integration, API Management, IDQ, IDD, MDM, EDC), Reltio UI and RDM, Jira Cloud, Unix Shell Scripting in PuTTY, ServiceNow, CA Workload Automation, Azure, SQL & PL/SQL Dev in SQL Developer, Postman, Airflow, Big Data Development in PySpark and Python ingestion with Big Data tools and platforms such as Hadoop, Hive, Spark, Python Web knowledge usage, AWS Cloud, AWS Redshift, AWS S3, Dynamo, Glue, Cloudtrail, CloudWatch, Power BI.
- Tools Used- BIG DATA, MSTR Development, ETL Developer in Informatica (Powercenter, IICS Application Integration and Data Integration, Adhoc API Management, IDQ, IDD, MDM, EDC), JIRA Cloud, Unix Shell Scripting in Putty, Service now, CA Workload Automation, SQL & PLSQL Dev in SQL Developer, Postman, Reltio UI, Airflow, Big Data Developer in PySpark and Python ingestion with Bid Data tools and platforms such as Hadoop, Hive, Spark, Python Web knowledge usage, GCP Integration, AWS Cloud, AWS Redshift, AWS S3, Dynamo, Glue, Cloudtrail, CloudWatch, Basic ERP Domain knowledge.
- Created, analyzed, debugged Informatica mappings, workflows and SQL Procedures, Triggers.
- Azure Databricks extraction from data lakes.
- Default Aggregated Reports for clients using Power BI.
- Creation, configuration & troubleshooting of critical business Linux applications using Putty.
- Performing Environment (Informatica and Linux) Checks for the Client on everyday basis to ensure the service is up and running without any critical alarms.
- Close Coordination with different ITIL teams like Problem Management, Change Management, Capacity Management & Project Management as and when required.
- Escalate issues when necessary to ensure timely delivery of services.
- Timely Escalations to Upstream providers and ensure resolutions as per the SLAs committed to the customer.
- Providing extensive service, support and on site instruction to system engineers to streamline bottlenecked services ASAP.
- Collaborated with colleagues on the improvement of support infrastructure in order to increase quality, reliability, effectivity, and reduce expenses.
- Monitoring application performance and troubleshooting via CA Workload Automation and tool specific analytics.
- Manage incidents and network performance within SLA's, OLA's and KPI's.
- Provided security incident triage and response, including end to end ticketing process within SLA.
Education
Bachelor Degree in Engineering - Computer Science & Engineering
Krishna Engineering College
Ghaziabad, Uttar Pradesh08.2015
Skills
AWS
Personal Information
Date of Birth: 04/14/93
Timeline
Senior Tech Analyst
AMERIPRISE FINANCIAL LLP
12.2022 - Current
Information Technology Analyst
TATA CONSULTANCY SERVICES LIMITED
03.2016 - 12.2022
Bachelor Degree in Engineering - Computer Science & Engineering
Krishna Engineering College
Similar Profiles
Harsh KaushikHarsh Kaushik
Financial Planning Analyst at Ameriprise Financial LLPFinancial Planning Analyst at Ameriprise Financial LLP
Nisha KanwarNisha Kanwar
Service and Operations Professional Analyst at Ameriprise Financial LLPService and Operations Professional Analyst at Ameriprise Financial LLP
Sumit KumarSumit Kumar
Team Lead Speech Analytic Professional (Voice Quality Analyst) at Ameriprise Financial LLPTeam Lead Speech Analytic Professional (Voice Quality Analyst) at Ameriprise Financial LLP
Sunil BhatSunil Bhat
Business Head IDBI Vertical at Ageas Federal Life Insurance Company LtdBusiness Head IDBI Vertical at Ageas Federal Life Insurance Company Ltd
Chetna SinghChetna Singh
Assistant Manager-Strategic Bid Management at HCL TECHNOLOGIES LTD.Assistant Manager-Strategic Bid Management at HCL TECHNOLOGIES LTD.