Ranjit S M

• As PeopleSoft technical consultant designs, develops, and supports applications to meet client needs
• Conducting technical research and evaluation of tools to ensure that designs adhere to current industry, client and company standards
• Assisting in developing technical documentation; participating in test-plan development, integration and deployment
• Understanding client requirement and developing project from scratch
• Participated in client calls to understand requirement and give updates
• Designed front-end and dataflow from front-to-backend and vice-versa
• Working closely with our client's project management and other Professional Services Consultants to ensure customer's and client's interests are best served at all levels
• Providing production support parallel to other tasks
• Expertise in upload of data for HCM modules using Excel to CI
• Extensive Client facing and management reporting experience
• Tech-Stack: Peoplecode, SQL, SQR, PS-Query, UC4 Scheduler, Application engine, App packages, UC4 Scheduler, Excel to CI
• Duration: 9 Plus years

• Understanding client requirement and developing project from scratch
• Participated in client calls to understand requirement and give updates
• Handled front-end validations and debugging if any issue
• Providing client support and technical issue resolution.

• • Role requires gathering business requirements from client on system changes/enhancements, developing Business Requirement Documents (BRD), Functional Requirement Documents (FRD) and Technical Specification Documents (TRD).
• • Finding root cause to live defects and providing solution to fix it.
• • Preparing PS-query for internal audit and reviewing code for optimization.
• • Preparing use cases, developing test strategies and ensuring alignment of implementation with requirement.

• This project offers about analyzing credit card payment transaction records of customers
• The credit card payments made by the customers in all the channels / modes are captured and processed for the storage and further analysis
• While doing the credit card payments, the offers availed by the customers and the mode through which the online transaction is made are analyzed by the analytics team to provide further benefits to the customers
• Handling multiple file formats such as text file, CSV, ORC, Parquet, Avro, JSON
• Performed cost saving by storing the annual data in a segregated fashion
• Creating DAGs to schedule and orchestrate the entire pipeline using Airflow
• Export processed data set to GCS layer for further consumption
• Creation of views and expose those to Data Governance team for further analysis
• Worked on building real-time data visualization and dashboards using Looker Studio
• Co-ordinate with team to get features/bugs to be solved, prioritization, Jira (story points, creating subtasks, epics, issues), planning, task deviation analysis
• Tech-Stack: GCS, Big-query, Cloud Composer (Airflow)
• Duration: 12 Months

• This project offers about getting large scale data in drugs transactions, where it can be collected in different regions across globe
• By using external table which is going to run in cloud spanner and with help of query we are bringing data to Big query layer
• Conducting technical research and evaluation of tools to ensure that designs adhere to current industry, client and company standards
• Worked on building pipelines by applying Data spanner tool, curated layer, customization, analytical and windowing techniques
• Tech-Stack: GCP, Big query and Data spanner
• Duration: 3 Months

• Assisting in developing technical documentation; participating in test-plan development, integration and deployment.

• Providing production support parallel to other tasks. Expertise in upload of data for HCM modules using Excel to CI.