SAPTARSHI ACHARYYA
SILCHAR
Summary
To create a niche for myself in a workplace and contribute to my organisation, and willing to work as a key performer in a creative and competitive environment.
Overview
1
1
Certification
12
12
years of professional experience
Work History
Senior Consultant at JPMorgan Chase & Co.
VIRTUSA Consulting Services Pvt Ltd
Hyderabad
01.2025 - Current
- Dedicated and detail-oriented Application/Production Support Analyst with hands-on experience in the CBA domain (Customer Banking, Business Banking, Consumer Banking, Auto Finance). Skilled in job scheduling (Control-M), job recovery, log analysis, ETL workflows (Informatica), cloud/on-prem job monitoring, incident management, Big Data log analysis (Hadoop), and SQL troubleshooting. Proven track record of recovering 10000+ failed jobs, ensuring SLA adherence, and minimising business impact through proactive monitoring and root cause analysis & production support in critical banking environments and raised JIRA tickets for root-cause fixes, enabling permanent resolution of recurring issues and reducing the risk of future job failures.
- Defined technical skills relevant to application and production support.
- Domains: Customer Banking, Business Banking, Consumer Banking, Auto Finance
- Job Scheduling Tools: Control-M (Cloud & On-prem job scheduling/monitoring, SLA tracking)
- Database: SQL (data validation, query execution, error analysis & advanced SQL queries)
- Big Data Tools: Hadoop (Log analysis, application/job monitoring)
- ETL Tools & Workflow: Informatica PowerCenter, Informatica Workflow Monitor
- Linux (file path verification, data error checks, data counts for .dat,.tok & ctrl files)
- Cloud Monitoring Tools: Control Centre (PSET), Cockpit View, Casper
- Ticketing Tools: ServiceNow (Incident categorisation, auto-closure post categorisation)
- Cutover and configured on-prem jobs to the cloud environment, streamlining job execution and enhancing monitoring capabilities.
- Professional Experience:
- Application/Production Support
- Supported applications across Customer Banking, Business Banking, Consumer Banking, and Auto Finance domains.
- Monitored and recovered over 10,000 failed jobs in Control-M, addressing connectivity, space, and source file issues to maintain operational integrity.
- Proactively monitored, recovered, and completed daily, weekly, and monthly batch jobs, ensuring seamless downstream processing and SLA compliance.
- Monitored both cloud and on-prem jobs in Control-M to ensure timely completion.
- Used Cockpit View and Casper to detect and resolve long-running and delayed jobs.
- Performed log analysis and error investigation on Hadoop servers to troubleshoot job/application failures & using SQL.
- Supported ETL workflows using Informatica PowerCenter and Workflow Monitor.
- Verified source file paths, job errors, and data counts on Linux servers for .dat and .tok files.
- Monitored cloud applications via Control Centre (PSET) to identify and resolve multiple errors.
- Categorised jobs in go/dtCategorize, which enabled incidents to auto-close in ServiceNow (SNOW) after categorisation.
- Coordinated with cross-functional teams to resolve incidents, effectively minimising downtime and mitigating production impact.
- Streamlined Preproc job, reducing running time from 24 hours to 10 minutes by eliminating unnecessary files, significantly enhancing processing efficiency.
- Provided details of the company for context.:
- 1) VIRTUSA Consulting Services Pvt Ltd (Working at Client location: JPMorgan Chase & Co.)
Sr. Software Developer.
IQVIA
Bangalore
11.2021
- Technology: SQL Developer, Application support in MuleSoft, Product Implementation, Product self-Alignment, Reltio MDM UI. Salesforce, Anypoint tool, Snowflake (IDP), Postman, Amazon SOS for data exchange, Data comparison for multiple sales areas in different downstream systems, Integration support, ETL workflows & Pipelines using Informatica PowerCenter.
- Responsibilities: -
- Provides Integration Support from Source to Target systems.
- Performed data migration tasks and integrated third-party systems with Informatica MDM Hub.
- Developed and customized Informatica MDM workflows for data ingestion, transformation, and syndication
- Transformed raw data from multiple sources into structured formats and loaded into data warehouse.
- Implemented data governance policies in alignment with business requirements for compliance and operational efficiency.
- Assisted in the creation and maintenance of technical documentation for all MDM processes and system configurations.
- Extracted data from various sources (CSV, JSON, REST APIs) and transformed into normalised formats
- Provides production support Globally for application specific in Middleware system.
- Integrated with AWS service such as S3, REDSHIFT to orchestrate ETL process into cloud environment.
- Improved ETL performance by optimizing SQL queries.
- Using MuleSoft Anypoint Platform for information-exchange & data processing from source API to external systems.
- Data management & support using SQL queries from source system Reltio MDM.
- Managing data pipeline, data reprocessing, data change request for merge entities & it's workflow in Snowflake (Orchestrated Analytics).
- Managing the new releases, patch & the workaround performed for fixing any records.
- Managing support for the merge records between the Entity ID that is performed in external system by the Client & the same ID are flown to downstream system or not, by the API's in Anypoint Platform and verifying the Payloads, Json file.
- Leading the Team who are responsible for monitoring checks for the production API's including CSM ticketing tool.
- Managing Data comparison for Health care records i.e., Product sales comparison, Employee sales comparison & processing records from source to target systems.
- Using Salesforce for self-alignment & executing queries for verifying the data from source to target.
- Using ETL tool Snowflake (IDP) the data are flowing from source system to downstream.
IT Executive
ITC Infotech India Limited.
09.2015 - 11.2021
- Professional Experience: Master Data Management Developer, SQL Developer
- Responsibilities : Teamed with the Managers to deduce the business requirements to produce effective technology solutions.
- Worked on data cleansing using the cleanse function in Informatica MDM.
- Supporting a Tier 1 technical environment & improvement through managed metrics & change management.
- Involved in UAT testing, mappings & other scheduled activities.
- Creating deployment groups of production migration, mappings, workflows & supporting post production support.
- Assisted Leads in designing & developing ETL workflows in SSIS.
- Experienced in complex SQL queries for data validation, transformation & troubleshooting.
- Monitored and optimized the performance of ETL jobs, identifying and resolving bottlenecks in the pipeline.
- Working with variables using Bash scripting & text manipulation, Streamlining processes.
- 1) Domain: CPG (Consumer Product Goods) PROJECT:
- Project Title IMAXX
- Responsibilities APPLICATION SUPPORT: Requirement Analysis, User Interface, Maintaining Master Data with Oracle- SQL Developer & MS Excel. Maintaining WEB Servers – Apache & Tomcat. Documentation of New Requirement, Preparing Presentation for ITC Business Users. Initiating Security Audit for both Internal & External, Manual Testing.
- Detail It is an android application built on GODB platform for Modern Trade Outlets (i.e. Big Bazaar, Spencer, Reliance Retail etc.) Application is used by the 3rd party vendors, need to communicate & manage the application Support for e.g.- Login & Data related issues, Sync Issues etc. Management of WEB Servers, Services, Maintaining Masters data & verifying OOS for all MT Outlets as per the data provided by ITC Business users every Month.
- Environment Windows 7
- Database Oracle SQL Developer
- Synopsis: This project calculates the total sales of each product for e.g. Category & Sub-Category wise & the working status of Merchandiser & also verifying Out of Stock against each SKU's for MT Outlets.
- 2) PROJECT:
- Project Title mAstra
- Responsibilities APPLICATION SUPPORT: App support by Oracle-SQL Developer & distribution of app via IBM MAAS 360. Maintaining WEB Servers – Apache & Tomcat. Preparing Presentation for ITC Business Users & Server Architecture.
- Detail It is an Android & IOS based application used by the Internal users of ITC. Application is used by the ITC users to verify the sales that has been made by the WD (Distributor of ITC). Management of WEB Servers.
- Environment Windows 7
- Database Oracle SQL Developer
- Synopsis: This project calculates the product that is mapped with WD's & the app allows to take orders from WD's & for security purpose app is distributed via IBM Maas 360 & played a key role in customer success management.
- 3) PROJECT:
- Project Title DHANUSH
- Responsibilities APPLICATION SUPPORT: App support by Oracle-SQL Developer. Preparing Master Data for more than 4.5 Lakhs Outlets for PAN INDIA. Experienced in error handling, logging & scheduling of ETL jobs for huge records to ensure data integrity and job reliability. Maintaining WEB Servers – Apache & Tomcat. Preparing Presentation for ITC Business Users & Server Architecture.
- Detail It is an android-based application used by the Merchandisers to audit & capture the sales of the Product & also implementing the architecture of the Outlets for every month, i.e. Visibility of the Outlets. Successfully Implementing Survey Data every month for all the Outlets which is audited & captured by the Merchandiser & Customers. Implementing Product i.e., New Brand for the outlets as per the previous month Sales for PAN INDIA
- Environment Windows 7
- Database Oracle SQL Developer
- Synopsis: This App contains Mapping from Manufacturing to Retail Outlets & transaction data for retail outlets & played a key role in customer success management.
- 4) MINACS
- Designation- Technical Support Advisor.
- Responsibilities- Worked with “MINACS” for “APPLE IOS PROCESS”as a Technical support advisor & supported all APPLE IOS DEVICES & MAC (OS) online and supported all Network & Internet issues and Software Issues for (IOS 7, 7.1, IOS8, 8.1, 8.2, 8.3) from Oct 2014 to May 2015.
Technical Support Advisor
MINACS
Bangalore
10.2014 - 05.2015
- Worked with MINACS for APPLE IOS PROCESS as a Technical support advisor.
- Supported all APPLE IOS DEVICES & MAC (OS) online and supported all Network & Internet issues and Software Issues for IOS versions 7 to 8.3.
Education
M.Sc. - Information Science
Institute Of Engineering & Management
Kolkata, WB01-2014
BSC - IT
Kuvempu University.
Bengaluru, KA01-2011
12th - Science
Crecent College
Silchar, AS01-2007
10th - General Study
Holy Cross School
Silchar, AS01-2005
Skills
- Data interpretation
- Customer success management
- Application support expertise
- Clinical data analytics
- ETL workflow troubleshooting
- Experienced in designing, developing, and optimising ETL processes
- Skilled in data extraction, transformation, and loading ETL from multiple sources into the data warehouse
- Workflow optimisation
- Experienced in MuleSoft troubleshooting
- Informatica performance tuning
- Incident management
- Informatica TDM expertise
- Experienced with Agile Methodologies and concepts
- Strong Excel- creating pivot tables, vlookup, pulling data regularly
- Application development
- Experienced in Orchestrated Analytics in Snowflake (IDP)
- Application server maintenance
- Apache / Tomcat and Database Servers, Back-ups of servers & applications
- Strategic management
- Cloud platform knowledge
- Stakeholder management
- Team collaboration
- Daily application support
- Customer problem-solving
- BASH scripting
- Monitoring implementation
- Web server management
- Job scheduling
- Monitoring tools
- Big data tools
- Web services
- Integration and middleware
- ETL tools
- Cloud data warehousing
- Programming languages
- Scripting languages
- Database : Oracle-SQL, MySQL, SQL Server, Dynamic SQL, T-SQL, Unix, PL-SQL, Snowflake DB, Redshift
- Vendor management
- MS Office tools
Certification
CERTIFIED MuleSoft Developer Level 1 on 2023-05-11
Project in M.Sc. (Information Science) -:
“DigitaI microfluidic biochip” using Heuristic Algorithm
PERSONAL DETAILS:
- Father's Name: LATE. GOPAL CHANDRA ACHARYYA
- Mother Name: MANIKA ACHARYYA
- Address: House 48, Rabindra Sarani. Silchar. Assam. Pin-788005
Hobbies and interests
- Travelling, exploring new places, and experiencing different cultures
DECLARATION
I hereby declare that all the above information is true to the best of my knowledge. SAPTARSHI ACHARYYA
Timeline
Senior Consultant at JPMorgan Chase & Co.
VIRTUSA Consulting Services Pvt Ltd
01.2025 - Current
Sr. Software Developer.
IQVIA
11.2021
IT Executive
ITC Infotech India Limited.
09.2015 - 11.2021
Technical Support Advisor
MINACS
10.2014 - 05.2015
M.Sc. - Information Science
Institute Of Engineering & Management
BSC - IT
Kuvempu University.
12th - Science
Crecent College
10th - General Study
Holy Cross School