Kumar Sudhansu Rathour

• About Company: HCL Technologies Ltd. is a leading global IT services company, working with clients in the areas that impact and redefines the core of their businesses. HCL focuses on 'transformational outsourcing', underlined by innovation and value creation, and offers integrated portfolio of services including software-led IT solutions, remote infrastructure management, engineering and R&D services and BPO

Project name :

• Merck Application Management Services (Merck AMS) is a global IT organization that provides business application Maintenance, Support, and Operations, globally, through DevOps and traditional models based on application maturity and strategic importance. AMS helps Merck Business and IT colleagues to achieve their end-to-end objectives from capability development, through operations, and ultimately to retirement.

Project application assignment :

• Clinical Data Repository (CDR)
• Controlled Terminologies Impact Analysis Tool (CTIAT)
• Analysis and Reporting Submissions Translation (ARST)

Clinical Data Repository (CDR) : The Clinical data repository project is a key component of the Merck collaborative clinical development technology platform initiative within Clinical and Regulatory Information Services (CRIS). The high-level goals of the strategy are to improve productivity and reduce cycle time for all stages of clinical trials through improved processes and a move towards industry standards. The Clinical data repository is constructed in a coupled manner to both publishing and subscribing applications to support ‘plug-and-play' access to tools and services with the help of TIBCO system. Full and Incremental patient data flow is designed in five stages (schema) with following ETL & ELT data warehouse concept to published data into SDTM formate for FDA submission.

• Tool & Technology used : Oracle (Exadata), Pl/SQL, Toad, Linux, shell script, S3, AWS Glue, AWS Redshift, Snowflakes, HP ALM, Service Now, BMC Remedy, Dynatrace, and MongoDB

Controlled Terminologies Impact Analysis Tool (CTIAT): The CTIAT is focused around reducing the time it takes to implement new terms published by CDISC. CTIAT is used to generate Reports to compare a new CDISC Controlled Terminology version with existing data, which are obtained from different SharePoint sites, to determine what forms/terms need to be updated.

• Tool & Technology used: AWS Cloud, AWS Glue, S3, IAM, SMS, Terraform, REST API, Git, Bitbucket, Jira, Jenkins, Python, AWS Lambda, HP ALM, Service Now, Dynatrace, and DynmoDB

Analysis and Reporting Submissions Translation (ARST): The ARST system is intended to support Study Level Define file translation from English to Local Language Term through Data Translation Management (DTM) Module. The application is only support Chinese Simplified translations.

• Tool & Technology used: AWS Cloud, AWS Glue, IAM, SMS, AWS CloudFormation, s3, REST API, Git, Bitbucket, Jira, Jenkins, Python, AWS Lambda, HP ALM, Service Now, Dynatrace, and DynmoDB

Role & Responsibility :

• Primary role is to support Clinical data repository application as Level 3 with following change management, problem management and incident management
• Attend daily meetings with application owner and provide daily status update of application
• Attends all meeting related to application which I manage and support as technical lead
• Manage all vulnerability of application including server, database, and application level
• Coordinating with Business regarding downtime of application to support DB patch upgrade, OS patch upgrade, Network patch upgrade, non-person account provisioning, Disaster recovery, Release implementation
• Leading and Managing team including 10 members and assigning and distributing task with following service now portal
• Targeting to meet compliance for application support with following SLA
• To support application, I use to work on troubleshooting, performance tuning, maintenance, and technical support
• Experience in Writing RDBMS SQL Queries for data validation at the row and table level, Multiple-Column Sub queries, Scalar Sub queries and correlated Sub queries in Oracle, Snowflake, MySQL, Amazon Aurora also having good knowledge in MongoDB
• Attending meeting with business and understanding new requirement as well as existing requirement related code change to improve application productivity and functionality
• Planning for new release as release management following waterfall as well as Agile methodology with Jira ticket
• Prepare effort estimation presentation deck for new release to present with business representative, technical unit as well as quality unit and update into to tracker
• Drafting project plan document and coordinating with scrum master to create project in Jira confluence page so that I can manage that page as well as release
• Attending Scrum development Meetings on daily basis
• Involved in Impact Analysis and Design documents (High- and Low-level design),
• Code design, development, Unit Testing, System testing support, UAT Support, Release management, Project management.
• Delivered high level of service to clients to both maintain and extend relationship for future business opportunities.
• Supported senior managers and department leaders by completing projects and problem resolution under tight budgets and schedule demands.
• Maintained tactical control of project budgets and timelines to keep teams on task and achieve schedule targets.
• Partnered with project team members to identify and quickly address problems.
• Updated customers and senior leaders on progress and roadblocks.
• Generated weekly and monthly status reports for helpful progress tracking.
• Identified and resolved risks to minimize project disruption.
• Documented project progress to fulfill project requirements and establish traceability.
• Mentored and guided staff to enhance performance and exceed customer expectations.
• Planned, monitored and analyzed project costs to meet financial goals.
• Devised and implemented attainable schedules, timelines and milestones for on-track projects.
• Monitored and tracked project metrics and collected data to share with project members.
• Led team meetings to assess project progress and plan appropriately to meet delivery targets.
• Developed and maintained project documentation for reliable records.
• Scheduled and facilitated meetings between project stakeholders to discuss deliverables, schedules and conflicts.
• Verified quality of deliverables and conformance to specifications before submitting to clients.
• Tracked project and team member performance closely to quickly intervene in mistakes or delays.
• Monitored project progress, identified risks and took corrective action as needed.
• Reported regularly to managers on project budget, progress and technical problems.
• Maintained open communication by presenting regular updates on project status to customers.
• Worked with customers or prospective customers to develop integrated solutions and lead detailed architectural dialogues to facilitate delivery of comprehensive solution.
• Guided and influenced existing partners on recommended upgrades and enhancements to integrated solutions.
• Managed and delivered advanced customization and configuration for oracle and AWS solutions.
• Conducted research to evaluate systems design and process efficiency.
• Presented roadmap and technology infrastructure to customers, demonstrating deep familiarity with APIs, platform infrastructure, security and integration capabilities.

• About Company:- A leading global software powerhouse providing innovative and pioneering products and software solution since 1986. Its core competence is wholly focused in banking and financial services spanning across solution in the areas of core banking, Retail & Corporate Banking, Credit Cards, Cash Management, Relationship Banking, Financial CRM, Credit Risk & Appraisal, Trade Finance, EAI, Internet Banking, Data Warehousing and Analysts. Nucleus Software has a strong quality culture, reflected in SIX Sigma initiatives.

Project assignment

• Philippines onsite support lead : Worked as onsite engineer for multiple bank to provide technical support and build very good relationship with customer, i worked for Bank of Philippines Island (BPI) and Banco de Oro (BDO), China Bank and Bank of Makati.
• Onsite engineer in Singapore for Client Citi Bank : I worked as Developer to design two new screen for Citi bank in module PPM (Payment Processing Module) under Cash Management.
• Product support: CAS retail, Collection retail , Credit card system and Payment processing.
• Tool & Technology used: Oracle 10 G, Pl/SQL , Oracle forms 10g, Toad and clear case.

Role & Responsibility:

• Understanding the business requirement from client and coordination with team.
• Develop the project as an enhancement based on prepared requirement and Program specification document.
• Writing stored procedures, functions and triggers in Oracle PL/SQL
• Trouble shoot an issue during peer review.
• Worked to support UAT and solving user's queries.
• Visited Client for UAT, production movement of deliveries and for production support for environmental issue, application bugs, clarification etc.

• About Company: I worked in Eastern Software Systems Limited, Delhi. A SEI- CMM LEVEL-5 organization from March 20th, 2007 to Jan 28th 2008. ESS has its own ERP package EBIZFRAME modules like Sales, Purchase, Inventory, Finance, production, human resources which operate on Oracle and Forms developer 2000 10 G. and having prestigious clients like Taksal Pharma (P) Ltd, Wellspring Universal (100% Export )

Project Assignment:

• Taksal Pharma (P) Ltd
• Welspring Universal (100% Export )

Tool & Technology used :Form Developer 10 G , Oracle 10G, PL/SQL.

Role & Responsibilities:

• I worked as onsite engineer at client side to support & implement ERP product “Ebizframe”.
• I worked to collect requirements gathering , designing & customization of modules like HR, Purchase, Sales, Finance etc.
• I worked as onsite support engineer to support live system, resolve day to day reported issue.