Sonal Sachdeva Email & Phone Number

• Written multiple playbooks in ansible for sending notification to PagerDuty, copy, templating, cleanup and log rotation etc. • Difftool is in house developed microservice it was developed using Node.js. This service takes rest JSON request and can perform following operations like data extraction from database in JSON/CSV format, convert json data to excel format and it also send metrics to Prometheus. I had Enhanced this microservice for JSON to CSV and CSV to JSON, CSVs to XLS data conversions.• Configure jobs in Jenkins for execution using ansible.• Migrated existing Shell/Perl scripts that were scheduled through Crontab to run from Jenkins and Ansible. For this project to migrate scripts, ansible playbooks were written which interns call to these scripts, if there is some error in execution then playbook invokes task, which sends curl request to create incident in Pager Duty, PagerDuty creates the incident, sends mobile and slack alert for the same to inform team.

• Maintaining existing J2EE bases applications developed in struts, EJB and JPA. • Migrated RTC code to GitHub. • Developed REST based webservice for Password reset, which validates the input parameters and invokes Jenkins to run a job to serve the request and sends pager duty notification if parameters are incorrect. • Recently built and deployed J2EE application to remove log4j vulnerabilities. • Enhanced WLM application for procedure and screen changes and achieved performance improvement up to 25% in file processing, which has helped to meet SLA.• Updated Webservice application for xsd and business logic changes. • Developed Java application to check connectivity of LDCs and to create tickets for the LDC which have connectivity issue.

• Written multiple shell scripts to implement business logics for – SLA calculation, health monitors to check system health and alerting, monitors to clean up, log rotation, using SQL or PL/SQL to detect erroneous data and report the same using mails. • Enhanced Perl based in house Staging Table Loader application for multiple RFCs and deployed in the lower environments and maintained code for this application in RTC/Github. • Created and Updated artifacts like design, requirement, unit testing documents in IBM box.

Gurgaon, India

Project 1: Maintenance of Lestre and C&C application Tools & Technologies: Oracle8i,Oracle 11g, SQL Navigator, Core JavaRoles and Responsibilities: • Enhancement of existing sql scripts for new requirements.• Writing shell scripts for various purposes like purging, login usage report and job polling etc.• Developing Java reports on customer requirement for Lestre application • Worked on migration of existing Fuel and related applications from VMS platform to AIX platform. • Developed small application to replace old DB link. • Monitoring and ensure all the process invoked and completed successfully.• Tracking and managing tickets in Maximo for Credit and Collection application.• Conduct and participate in day to day code reviews and change document reviews.• Maintain PVCS for latest version of code in repository.• Maintain documents in RPM for project.• Track monthly status for quality purpose.Project 2: KM PortalTools & Technologies: Oracle9i, TOAD, J2EE, JSP, Jsp, Java, Struts 1.2, RAD 6.0, WAS 6.0, DB2 7.5.Roles and Responsibilities: • Setup RAD environment with integrated WAS.• Completed HLD for the KM portal.• Did coding and unit testing for user management functionality.Project 3: Migration of existing Delphi based application to J2EETools & Technologies: Oracle9i, TOAD, J2EE, JSP, Jsp, Java, Struts 1.2, SolrRoles and Responsibilities: • Setup CMS environment and debug the code.• Review and understand existing code in Delphi.• Came up with use cases for search functionality.• Prepared design document for existing classes in CMS.• Design and did the coding for search functionality using Solr.• Written and executed test cases for the search functionality using Solr.• Setup linux box for J2EE environment, migrated and tested the code on Linux.• Did Integration testing for the J2EE based application.• Assigned as a SPOC (Single point of Contact) for the client during testing phase.

Gurgaon, India

Project 1: NIM (Network Inventory Management) Tools & Technologies: Oracle9i, TOAD, J2EE, JSP, Java, Servlets, Struts, WebLogic 8.1 SP4, JDBC, Java, Clear Case, Eclipse.Roles and Responsibilities: • To help production support team which require code fixes and data cleansing issues.• Review and modified Weblogic settings for better application performance.• Solely handled couple of enhancements for Nextgen application.• To analyzed stack traces and available data to find out route cause of the problem.• Did data analysis of the Project for the migration phase.• Generated SQL Reports for data migration.• Suggested new configuration of the designs to meet customer requirements.• Automated the analysis for repetitively occurred problems.• Optimized existing code for some of the expose services to the clients.• Modified and executed test cases with existing test client for the Nextgen application during each release.• Worked as On-site Coordinator for 7 months in US.Project 2: (3) ScapeTools and Technologies: Oracle 9i, JDBC, Core Java, JUnit and DbUnit FrameworkRoles and Responsibilities: • Responsible for complete understanding about the application business logic and architecture. • Written JUnit test cases. • Set up environment for application e.g clover integration with Eclipse.Project 3: Ericsson Multi Activation- (EMA)Tools and Technologies: DUP, Shell ScriptingRoles and Responsibilities: • Develop the Business Logic for various HLR’s• Deployed EMA at the customer sites• Maintained product and its components like EMA Reports, logsProject 4: Enhancement and Maintenance of DNS and SNMP on NSK.Tools and Technologies: C,C++Roles and Responsibilities • Software enhancements to NSK SNMP and DNS as per customer requests. • Analyze and fix bugs reported on NSK SNMP and DNS and providing customer support.

Master Of Computer Applications (M.C.A.), Computer Programming, Specific Applications, 73

Bsc With Computer Applications, Computer Programming, Specific Applications, 72.6