Summary
Overview
Work History
Education
Skills
Certification
Management Experience
Technical Experience
Linkedin
Timeline
Generic

Kiran Iyer

Houston,USA

Summary

Senior data engineer with deep expertise in data architecture, cloud platforms, and big data technologies. Skilled in Oracle PL/SQL development on Oracle Cloud and experienced in migrating legacy Oracle systems to AWS S3. Proven ability to optimize data workflows, drive BI initiatives, and deliver scalable solutions using SQL, Python, and Spark.

Overview

26
26
years of professional experience
1
1
Certification

Work History

Sr Data Engineer

JP Morgan Chase Bank
11.2011 - Current
  • Designed scalable architecture solutions to enhance system performance and reliability.
  • Led cross-functional teams in the implementation of new technologies and methodologies.
  • Mentored junior architects, fostering skill development and knowledge transfer within the team.
  • Collaborated with stakeholders to define project scope, ensuring alignment with business needs.
  • Evaluated emerging technologies, providing recommendations for integration into current architectural frameworks.
  • Streamlined development processes by introducing agile methodologies and automating routine tasks.
  • Standardized development methodologies across the organization, increasing efficiency and reducing risk associated with inconsistent approaches.
  • Leveraged technology to automate workflows and streamline processes, resulting in increased productivity and cost savings across the organization.
  • Developed comprehensive documentation detailing system architecture specifications, enabling efficient knowledge transfer among team members.
  • Collaborated with cross-functional teams to ensure seamless integration of new features and updates.
  • Contributed to business growth by actively participating in client meetings, showcasing technical capabilities, and winning new projects.

Associate Data Engineer

MphasiS an Hp Company
09.2004 - 11.2011
  • Designed and implemented data pipelines for real-time analytics, enhancing decision-making processes.
  • Developed scalable ETL processes using Apache Spark, improving data processing efficiency across multiple platforms.
  • Collaborated with cross-functional teams to define data architecture, ensuring alignment with business objectives.
  • Conducted data quality assessments, identifying anomalies and implementing solutions to ensure accuracy and reliability.
  • Implemented automated monitoring systems to track data integrity, proactively addressing issues before impacting stakeholders.
  • Championed the adoption of agile methodologies within the team, resulting in faster delivery times and increased collaboration among team members.
  • Designed robust database architecture that supported seamless integration of new datasets and facilitated rapid analysis capabilities.
  • Mentored junior data engineers, fostering technical skills and promoting best practices in data management.
  • Ensured data quality through rigorous testing, validation, and monitoring of all data assets, minimizing inaccuracies and inconsistencies.
  • Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
  • Established standard procedures for version control, code review, deployment, and documentation to ensure consistency across the team''s work products.

Data Engineer

Keystone Solutions PVT LTD
04.2003 - 09.2004
  • Developed data pipelines to streamline data processing and enhance operational efficiency.
  • Collaborated with cross-functional teams to gather requirements and design scalable data solutions.
  • Implemented ETL processes using tools like Apache Spark for real-time data integration.
  • Conducted data validation and cleansing to ensure accuracy and consistency across datasets.
  • Evaluated new technologies for potential integration into existing systems, driving innovation in data management solutions.
  • Contributed to a global data warehouse project that consolidated disparate sources into a single repository for unified reporting and analytics purposes.
  • Mentored junior engineers on various aspects of data engineering principles while fostering an environment conducive to learning new skills efficiently.
  • Enabled real-time monitoring of key performance indicators through the development of interactive dashboards and visualizations using cutting-edge tools like Tableau or Power BI.
  • Improved data collection methods by designing surveys, polls and other instruments.
  • Applied loss functions and variance explanation techniques to compare performance metrics.
  • Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.

Consultant Engineer

Abyss and Horizon Consultant
11.2000 - 03.2003
  • Developed ETL pipelines using Python and SQL to streamline data processing workflows.
  • Conducted performance tuning of existing queries to enhance system efficiency and speed.
  • Created comprehensive documentation for data processes and workflows used by the engineering team.
  • Reduced data discrepancies by implementing rigorous data validation techniques and automated error detection.
  • Increased automation in reporting processes by designing dynamic dashboards using visualization tools like Tableau or Power BI.
  • Streamlined data storage and retrieval processes with the design of an optimized database schema.
  • Facilitated seamless integration between disparate systems by developing robust APIs for efficient data exchange between applications.
  • Decreased manual intervention in routine tasks through the development of custom automation scripts for monitoring and maintenance purposes.

Trainee Engineer

Sun Pharma
03.2000 - 11.2000
  • Documented technical specifications and user manuals for new software features and updates.
  • Researched emerging technologies, providing insights for potential integration into existing systems.
  • Implemented automated testing procedures, increasing software quality and reducing deployment time.
  • Assisted in debugging and troubleshooting software issues, enhancing system reliability.
  • Conducted code reviews ensuring adherence to best practices and coding standards.

Education

Masters of Commerce - Exports & Taxation

University of Mumbai
Mumbai India
03-2003

Skills

  • ORACLE PLSQL/SQL Development
  • ORACLE Cloud Technologies
  • Data Migration of Large Databases
  • AWS Cerfiied Cloud Practitioner
  • Experienced in migrating data to AWS S3/RDS Oracle/Postgres
  • Data pipeline creation
  • Experience with large-scale data processing
  • Experienced in Python/Java J2EE development
  • Unix/Linux scripting
  • Data flow design
  • Real-time data streaming with Kafka
  • Data storage solutions
  • Application performance enhancement
  • Skilled in utilizing Git for collaborative development
  • Database management with SQL
  • SQL data analysis techniques
  • Relational database expertise
  • Transactional data replication
  • Data analysis programming
  • Large dataset management
  • Expert data analysis

Certification

  • Cloud Practitioner License - August 2026

Management Experience

  • Present periodic Dashboard reports on the current program, future opportunities and client issues
  • Scrum Master / Tech lead role work with the PO(Product owners ) in grooming the stories and application of Agile methodologies
  • Define and initiate projects, and assign Project Managers to manage cost, schedule, and performance of component projects, while working to ensure the ultimate success and acceptance of the program
  • Responsible and accountable for the coordinated management of multiple related projects directed toward strategic business and other organizational objectives.
  • Build credibility, establish rapport, and maintain communication with stakeholders at multiple levels, including those external to the organization.

Technical Experience

  • Hands on Expertise in using Oracle 7.3,8i/9i/10g/11g/Oracle Cloud (19.13.0) enterprise edition
  • Experience in developing Tableau, Cognos & QlikView Reports
  • Experience in working with CORE Java, Scala, Unix shell scripting
  • Working Knowledge of Java,J2EE ,Scala , Python, Splunk, KAFKA & Big Data (Hadoop – Eco System(hive, Impala)
  • Developer 2000 , Forms & Reports 6
  • Proficient in query optimization and effective database management of different Databases (Oracle, Sybase)
  • Working with Partition tables & their maintenance in relation to archiving principles
  • Strong Oracle Apps developer creating packages, functions, procedures, using PL/SQL
  • Data migration experience with migrating upto 200 TB Bytes of data to Oracle cloud
  • Hands on experience with Erwin, Power designer for creating Data Models
  • Experienced in working with utilities like SQL
  • Loader, External Tables, Import, Export, Export data pump extract and load large volume of data
  • UNIX shell scripting
  • Experience in spinning Amazon RDS – Oracle & migrating the data from Private Oracle cloud

Linkedin

www.linkedin.com/in/kiran-r-iyer-dataengineer

Timeline

Sr Data Engineer

JP Morgan Chase Bank
11.2011 - Current

Associate Data Engineer

MphasiS an Hp Company
09.2004 - 11.2011

Data Engineer

Keystone Solutions PVT LTD
04.2003 - 09.2004

Consultant Engineer

Abyss and Horizon Consultant
11.2000 - 03.2003

Trainee Engineer

Sun Pharma
03.2000 - 11.2000

Masters of Commerce - Exports & Taxation

University of Mumbai

Similar Profiles

CREATE PROFILE