Sr. Programmer Analyst @ Ajilon Consulting From 2002 to 2010 (8 years) Sr. IT Consultant Solutions @ Kaiser Permanente Pasadena, CaliforniaSr IT Engineer Applications @ Kaiser Permanente Hadoop Subject Matter Expert at Kaiser Permanente, Pasadena, CA• Currently focused on building data solutions in Hadoop using Cloudera Distribution toolset such as using HDFS, Hive, Hue, Beeline, Impala, Oozie,...
Sr. Programmer Analyst @ Ajilon Consulting From 2002 to 2010 (8 years) Sr. IT Consultant Solutions @ Kaiser Permanente Pasadena, CaliforniaSr IT Engineer Applications @ Kaiser Permanente Hadoop Subject Matter Expert at Kaiser Permanente, Pasadena, CA• Currently focused on building data solutions in Hadoop using Cloudera Distribution toolset such as using HDFS, Hive, Hue, Beeline, Impala, Oozie, Spark SQL and Bash scripting on Linux• Experienced in Big Data, Cloud Technologies, Data Modeling, Data Warehouse systems built using Star and Snowflake schema.• Working with a newly formed development team comprising of onshore/offshore team members to implement a new project called the Enhanced Consumer Information Management platform for Kaiser Campaign management.• Worked on multiple data warehouse, data mart projects to move data from on premise data sources to on premise Big Data environment.• Requirements gathering from users, prepared development specifications based on source to target mapping documents for phase of the project.• Defined development guidelines, error handling processes and success criteria. Conducting design sessions, code review sessions, optimization strategies, data quality and overseeing product testing and deployment.• Worked with QA resources to define test scenarios and test cases and test plans.• Mentor junior team members to bring them up to speed.• Involved in all stages of code development from DDL and DML scripts, ETL design, code and Unit testing.• Developed numerous re-usable ETL processes that cut down development time for repeated tasks including a robust error handling process, re-usable data load process for loading data from FTP files into Raw tables.• Developed release notes, restatement scripts and deployment plans, participated in the deployment, smoke testing and validation.• Comfortable working with the business, giving presentations highlighting the teams accomplishments.Environment: Big Data on Hadoop, Oracle, Redshift, SQL Server, Linux, GitHub Enterprise, Jenkins From December 2017 to November 2019 (2 years) Pasadena, CaliforniaLead Datawarehouse Engineer @ Cox Automotive Inc. • Designing & developing Big Data solutions for Marketing• Lead for data migration projects from on premise data warehouse to Big Data in the cloud• Implemeting data ingestion patterns and strategies for ingesting data into AWS• Developing test strategies• Building cross team relationships• Working with business partners, architects and product managers• Mentor junior team members• Peer review development work of junior team members• Oversee deployment and production support procedures From December 2014 to December 2017 (3 years 1 month) Irvine, CaliforniaSenior Data Warehouse Engineer @ Kelley Blue Book • Designing & developing data warehouse solutions• Implemeting ETL solutions• Developing test strategies• Working with business partners and product managers• Mentor junior team members• Peer review development work of junior team members• Oversee deployment and production support procedures From December 2012 to November 2014 (2 years) Irvine, CAData Warehouse Engineer @ Kelley Blue Book Extensive ETL development in Informatica 9.1 in a Data Warehouse environment using Netezza database appliance.Worked on bringing data into the Data Warehouse from diverse data sources such as vehicle auctions, third party vehicle data, website related statistics from third parties, online ad management systems, insurance companies, vehicle registrations, vehicle rental information, etc.Played the role of story lead for Agile scrum stories, managed story tasks and health of story, participated in daily stand up scrum meetings, provided story updates at Sprint checkpoints.Requirements gathering from users, prepared development specifications and source to target mapping documents for each story.Defined development guidelines, error handling processes and success criteria.Participated in design sessions, designed and developed ETL processes using Informatica.Developed database scripts and data models in NetezzaWorked with QA resources to define test scenarios and test cases and test plans.Mentored junior developers during coding, Peer Review and testing stages.Involved in all stages of code development from DDL and DML scripts, ETL design, code and Unit testing.Developed numerous re-usable ETL processes that cut down development time for repeated tasks including a robust error handling process, re-usable data load process for loading data from FTP files into Raw tables.Developed release notes, restatement scripts and deployment plans, participated in the deployment, smoke testing and validation.Developed presentations for the business for the sprint stories during the Sprint Review highlighting the purpose of the story, the major tasks accomplished and the key business benefit of the story.Providing On-Call Production Support and ensure business as usual. From August 2011 to November 2012 (1 year 4 months) Irvine, CAApplication Support Lead for IBM @ The Walt Disney Studios Managed support activities to Walt Disney’s Treasury applications including all Business as usual activities, bug fixes, enhancements, vulnerability management, Sarbanes Oxley compliance and user requests.Product administration, user maintenance, maintain SOX compliance and reporting.Key role in legacy application’s fortification project.Resolved a major issue encountered after implementing the hardware/software fortification project for the Sierra Application.Developed automated processes for SOX requirements and monthly Vulnerability Management tasks.Primary SME for the Sungard products (Sierra and Integrity).Provided support on Informatica ETL mappings for other applications within IBM’s Application Development services team including troubleshooting Informatica data maps, workflows, fixing bugs and helping in the design of new Mappings, Applets and workflows.Application support, creation and modification of ETL Data mappings using SunGard’s Avantgard Integrity to load Bank Transaction information from flat files into Integrity Database in order to perform sophisticated risk analysis, improve cash management and interface with external systems.Enhancements, production migration and bug fixes for new and existing Integrity Data Maps.Liaison with business users to understand new requirements and update existing requirements for changing Bank transaction and translating requirements into actual ETL Data Map changes in Integrity.Worked on optimizing file transfer using SFTP/SCP.Modification of data maps when Banks changed the data format/ data content in the data files. Conduct code walkthroughs and peer reviews.Administration and maintenance of Integrity server.Providing On-Call Production Support and ensure business as usual for the Treasury applications.Training offshore resources in the Application Development services team. From August 2010 to June 2011 (11 months) Sr. Programmer Analyst @ Capital Group Member of development team experienced in both Waterfall and Agile environments and implementing SOX controls.Facilitated complex ETL Data Transfer process using Informatica Powercenter, Unix shell scripts, Sybase/Oracle stored procedures, indexes, triggers and Autosys (Unicenter).Experience converting data into flat files and using SFTP/SCP for file transfer and then loading data from flat file into data warehouse.Experience working with high volume data from multiple sources in both Oracle and Sybase in a Data Warehouse/ Data Mart environment.General Informatica server maintenance, repository creation, migration, job monitoring and maintenance.Requirements analysis and design, estimates, impact analysis, code and unit testing, P2P testing, integration testing, etc as required.Designs, design enhancements, database optimization, conduct code walkthroughs and peer reviews.Source code control, implementation procedures and documentation.Participated in product, process and technology upgrades and migrations.Replaced legacy application’s batch and reporting components with Informatica and Actuate.Developed reporting solutions for Business Intelligence as per requirements, developed automated migration process for reporting and database components.Led the Actuate upgrade project from Actuate 4.0 reports to Actuate 8.0. Integrated the entire Reporting solution into Capital Group’s product using Actuate SDK.Developed the automatic report generation process for in house application.Developed automatic migration scripts to merge two Oracle databases using Oracle Bulk Data Loader running within shell scripts.Provide ETL (Informatica), batch and reporting (Actuate) production support for the application.Providing On-Call Production Support and training Production Support Services Team. From February 2002 to August 2010 (8 years 7 months) Programmer Analyst @ Evolve Software Primary Reporting solution developer using Actuate Reporting tool.Conversion of existing Crystal reports to Actuate reports.Converting existing Actuate 4.0 reports to Actuate 5.0Supporting reporting architecture, bug fixes, migrationsConverting existing query/view based reports to stored procedure based reports for Oracle and SQL server databases.Created custom browser friendly Actuate Reports in HTML. From December 2000 to December 2001 (1 year 1 month)
Sr. Programmer Analyst
2002 to 2010
Sr. IT Consultant Solutions
Sr IT Engineer Applications
December 2017 to November 2019
Cox Automotive Inc.
Lead Datawarehouse Engineer
December 2014 to December 2017
Kelley Blue Book
Senior Data Warehouse Engineer
December 2012 to November 2014
Kelley Blue Book
Data Warehouse Engineer
August 2011 to November 2012
The Walt Disney Studios
Application Support Lead for IBM
August 2010 to June 2011
Sr. Programmer Analyst
February 2002 to August 2010
December 2000 to December 2001
National Institute of Information Technology
PGDCM, Computer Science
1997 to 1999
Siebel Customisation, Siebel Professional Training
1999 to 2000
Bachelor of Engineering, Industrial Production
1985 to 1990
DAV Higher Secondary School
High School Diploma, Mathematics, Physics, Chemistry
1972 to 1984
What company does Ravinder Patyam work for?
Ravinder Patyam works for Ajilon Consulting
What is Ravinder Patyam's role at Ajilon Consulting?
Ravinder Patyam is Sr. Programmer Analyst
What industry does Ravinder Patyam work in?
Ravinder Patyam works in the Hospital & Health Care industry.
Enjoy unlimited access and discover candidates outside of LinkedIn
One billion email addresses and counting
Everything you need to engage with more prospects.
ContactOut is used by
76% of Fortune 500 companies