Nakul Rathore
New Delhi
Summary
IT Analyst with over 7 years of experience specializing in IBM MQ management and data integration. Proven ability to enhance operational efficiency through automation and SQL development. Strong problem-solving skills complemented by a commitment to IT compliance and governance.
Overview
8
8
years of professional experience
Work History
IT Analyst
Tata Consultancy Services
New Delhi
09.2022 - Current
- Project: GlaxoSmithKline.
- GSK is a healthcare company that engages in the research, development, and manufacture of pharmaceutical medicines, vaccines, and consumer healthcare products.
- Maintained IBM MQ across Linux, Unix, and Windows platforms.
- Created and managed MQ queues, topics, channels, and queue managers.
- Troubleshot MQ issues including stuck queues and message latency.
- Deployed and maintained ESB integrations to enhance communication.
- Validated web service URLs using SOAPUI and Postman.
- Modified Ant scripts for certification deployment challenges using ESQL.
- Executed MQSI commands for managing message flow operations.
- Developed stored procedures in Microsoft SQL Server to automate tasks.
- Java Eclipse RTC (Rational Team Concert)
- Documented processes and maintained comprehensive records of IT operations.
- Provided support to end-users in troubleshooting application issues.
Senior Implementation Analyst
Mercer
03.2020 - 09.2022
- Developed and maintained predictive models using UK pension data.
- Connected multiple data sources, importing and transforming data for business intelligence via MySQL.
- Utilized Power Query to load and transform data into required formats.
- Created and deployed reports on Power BI service portal for stakeholder insights.
- Applied advanced Excel formulas for comprehensive data analysis and actions.
- Calculated member commutation processes through MIDAS software.
- Enhanced team efficiency by writing automation scripts for common checks.
- Established reliability through rigorous analysis and development of test standards.
Data Analyst
GlobalLogic
04.2018 - 03.2020
- Conducted exploratory data analysis using descriptive statistics and data visualization to establish baseline MLAs.
- Developed and automated a robust model achieving high accuracy for customer segmentation.
- Generated daily, weekly, and monthly MIS reports, automating dashboard creation with MS Excel.
- Designed customized applications for reporting utilizing Excel Pivot Tables and advanced formulas.
- Automated processes through Visual Basic for Applications to enhance efficiency.
- Standardized business processes by implementing internal templates and controls based on data analytics.
- Tracked and analyzed various reports, including budget forecasts, operational activities, and department metrics.
Education
Bachelor of Technology - Computer Technology/Computer Systems Technology
Bharati Vidyapeeth Deemed University
Pune01.2016
Skills
- IBM MQ management and operations
- ESQL
- Java, Eclipse, RTC
- Data integration and analysis
- Enterprise Service Bus architecture
- Technical support and troubleshooting
- Oracle SQL development
- ETL processes
- User acceptance testing
- Software development tools: JIRA, confluence
- SoapUI and Postman API testing
- Data analytics and reporting
- ServiceNow administration
- Microsoft Excel proficiency
- IT compliance and governance
- Incident management
- VBA programming
Timeline
IT Analyst
Tata Consultancy Services
09.2022 - Current
Senior Implementation Analyst
Mercer
03.2020 - 09.2022
Data Analyst
GlobalLogic
04.2018 - 03.2020
Bachelor of Technology - Computer Technology/Computer Systems Technology
Bharati Vidyapeeth Deemed University
Similar Profiles
Vrunda ChindhadeVrunda Chindhade
HR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services LimitedHR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services Limited
Sreya BasuSreya Basu
Procare Analyst at Tata Steel(Tata Consultancy Services)Procare Analyst at Tata Steel(Tata Consultancy Services)
Arun VArun V
Program Manager at Tata consultancy services | Financial Ombudsman ServicesProgram Manager at Tata consultancy services | Financial Ombudsman Services
Naimish AgnihotriNaimish Agnihotri
Assistant Delivery Manager at Tata Consultancy Services, Global Shared ServicesAssistant Delivery Manager at Tata Consultancy Services, Global Shared Services
Navdha SharmaNavdha Sharma
Sr. Manager- Social Media & Communication at CIN UniverseSr. Manager- Social Media & Communication at CIN Universe