Rohit Mishra
Ratlam
Summary
Experienced and impact-driven IT Engineer with 5+ years of Experience supporting critical banking systems and regulated enterprise environments. Specializes in L2/L3 production support, BAM/MIS reporting, SQL optimization, and platform stability across Finacle, iWORKS, and Trade Connect. Adept at resolving high-volume incidents, leading DR drills, and ensuring 99.9% uptime through proactive monitoring and RCA. Known for bridging technical execution with business needs—collaborating across Infra, DBA, Server Support, VA Patching, SDG , PAQ and QA teams to drive operational excellence and compliance.
Overview
5
5
years of professional experience
1
1
Certification
Work History
Software Engineer — Banking Infrastructure
Alchemy Techsol Pvt. Ltd. (IBM Vendor)
03.2024 - Current
- MIS reporting: Automated and delivered daily/monthly MIS via iWORKS to meet branch and audit needs, supporting 99.9% availability.
- BAM reporting: Built and maintained 40+ BAM reports using SSMS/SQL, improving accuracy and turnaround for business dashboards.
- Ticket resolution: Managed IT support ticketing system, ensuring timely resolution of technical. Closed 200+ tickets on weekly basis across Trade Connect, KCC, Procurement, Account opening, preventing business escalations.
- Root cause analysis: Performed deep-dive XML/Java Console analysis for NR/DIGICA and FI Account Workstage failures, reducing SLA breaches by ~25%.
- Finacle integration: Resolved FinAccount errors through SOAP UI with Finacle interfaces to stabilize transaction flows.
- Storage optimization: Executed server space creation and policy-based purging on DR & Production, boosting performance by ~40%.
- BAM sync recovery: Coordinated with DBA/Infra to fix iWORKS ↔ BAM sync failures, restoring data freshness and report reliability.
- Monitoring & alerting: Tuned Dynatrace thresholds and templates, cutting critical alerts by ~20% and preventing downtime.
- Deployments: Ran deployment validations, log capture, cache/queue purges, and DB-side checks during production rollouts.
- Utilities at scale: Installed/configured Bulk Upload/Download/Master Bulk utilities for high-volume document processing with approvals.
- Ops governance: Led monthly AUTS activity to de-provision inactive users.
- Platform tools: Monitored image utilities and SQL background jobs to ensure timely case transitions and downloads.
- KT & L1 enablement: Delivered KT to strengthen first-level analysis and day-to-day operations within the support team.
- Access control: Managed role/branch-based access provisioning and de-provisioning across banking applications.
- Handled ekyc issue on Production server co-ordinate with NPCI & UIDAI team for EKYC failure.
- Collaborated with stakeholders to translate business requirements into technical specifications, ensuring alignment with business goals.
CSV IT Engineer
Telnet Services
11.2022 - 08.2023
- Validation execution: Authored/executed 100+ IQ/OQ/PQ scripts ensuring GxP and 21 CFR Part 11 compliance.
- Documentation: Produced VSRs, traceability matrices, and SOP-aligned evidence packs for audit readiness.
- Upgrade & recovery: Drove compliant upgrades with zero data loss; implemented robust backup and restoration procedures.
- Stakeholder collaboration: Partnered with QA/IT to remediate deviations quickly and maintain inspection readiness.
- Client: Wockhardt Ltd.
Junior Officer — IT Systems
IPCA Laboratories Pvt. Ltd.
06.2020 - 11.2022
- Regulated systems: Administered 20+ systems (EDMS, LMS, Chromeleon, Empower, Tiamo, SCADA) across QC/Manufacturing.
- Access & integrity: Enforced role-based access, audit trails, and ALCOA+ practices across lab/manufacturing applications.
- Preventive ops: Executed scheduled maintenance and validated backups for servers, switches, and lab software.
- CSV support: Performed in-house IQ and maintained CSV-IT master lists and license calendars.
Education
B.E. - Information Technology
Srajan Institute of Technology, RGPV University
Ratlam, India01.2019
High School Diploma -
Srajan Institute of Technology, RGPV University
Ratlam, India01.2019
Skills
- Banking platforms: iWORKS (Newgen iBPS), Finacle, Trade Connect, Account Opening, Account Payable , Procurement, New Branch creation, Generic, PAQRT, HYVDR, SMDT , NR, STP Mapping, Pioneer Mapping etc
- Reporting & analytics: MIS, BAM report design, SSMS, SQL querying, XML/Java Console log analysis
- Databases: MS SQL Server, PostgreSQL,SSMS
- Middleware & servers: WebLogic, Windows Server, Server health checkup, Performance Monitoring
- Monitoring Tool : Dynatrace
- IT operations: L1/L2 support, ITIL incident/change, DR drills, backups/restores, Veritas Net Backup,storage management, purging activity, IT security Policy,
- Admin & security: User provisioning/de-provisioning, role-based access, AUTS Activity
- Tools & ticketing: SOAP UI, Postman, BMC Helix/Remedy
- Compliance & validation: 21 CFR Part 11, GxP, ALCOA, GAMP5; IQ/OQ/PQ, CSV
- Software development lifecycle
- Team collaboration
- Project management
Certification
- Business Analytics with Excel — SkillUp (2022)
- Master Diploma in Information Technology — HIIT (2018)
Timeline
Software Engineer — Banking Infrastructure
Alchemy Techsol Pvt. Ltd. (IBM Vendor)
03.2024 - Current
CSV IT Engineer
Telnet Services
11.2022 - 08.2023
Junior Officer — IT Systems
IPCA Laboratories Pvt. Ltd.
06.2020 - 11.2022
B.E. - Information Technology
Srajan Institute of Technology, RGPV University
High School Diploma -
Srajan Institute of Technology, RGPV University