KARAN N
Bengaluru
Summary
Hardworking and passionate problem-solver with analytical and driven mindset. Dedicated to achieving demanding development objectives according to tight schedules while producing impeccable code. Ready to help team achieve company goals.
Overview
5
5
years of professional experience
1
1
Certification
Work History
RPA DEVELOPER
INFOSYS LIMITED
02.2023 - Current
- Project : Nationale Nederlanden (NN) is a financial services company, active in 11 countries provides retirement services, pensions, insurance, banking and investments
- Served as technical lead for automating Surrender Process
- Used Queue mechanism and Re-Framework with multiple workflows invoked
- Implemented robust exception handling, effective logging, and retry mechanism, dynamic value changeability using Config File and assets
- Configured Automation process as per BRD, Collaborated with testers for UAT
- Process 1 : Process of surrendering Policies (2 FTEs) >> Environment : Web (CBPM, Titan, Juice, Knowledge Bank, Navigator), PDF, File Explorer (For Drag & Drop), Mainframe (Microfocus Rumba), Word, Email and Excel >> Description of Project : Automating Dutch applications for Prechecker-Maker (Looping, Fetching, Manipulating, Updating, Saving) and Checker (Reverify, Surrender) Bots
PYTHON AND DATABASE DEVELOPER
INFOSYS LIMITED
03.2022 - 01.2023
- Project : Select Portfolio Servicing, Inc (SPS) is a mortgage servicer with operations in Salt Lake City, Utah and Jacksonville, Florida
- Automating Letters' (PDF and SelectCE) fields extraction of a wave using Python (Before Text/After Text/Regex)
- Mapping of fields and Bots to letters in Letter QC Control Center Web (Ui for clients to audit and QC the processed data), Integration & Merging of Code
- Wave3 Python Use Cases Automation- CD080, CD680, CS003, CS090, CS091, CV001, CV006, EA003, LR042, LR068, LR072, LR086, LR064, LR964, SK003 (20 FTEs)
- Everyday runs for SIT and UAT & fixing the issues & Reruns, and exe replacements
- Updating logical Result column (Pass/Fail) comparing PDF Value and SelectCE application value using Stored Procedures
- Deployment activities included IIS restarts, SSIS package replacement, DB Scripts generation
- Migration of rows of DB table from SIT to UAT and UAT to Production
- Raising access requests for new users and raising issue requests for team
- Coordinated with L1, L2 teams for monitoring, versioning, change management and defect logging
- Individually developed, delivered and deployed Python Code against aggressive deadlines.
- Process 2 : RRR BKFS-Missing Assignment (2 FTEs) >> Environment : Excel (pandas), Web Application (BKFS - Selenium) and Desktop Application(CDT - pywinauto) >> Description of Project : Values of Loan numbers with 4 different Active Steps to be compared between BKFS and CDT applications, then status must be updated.
UIPATH - RPA DEVELOPER
IBM INDIA
02.2021 - 02.2022
- An Year of hands-on Experience on UiPath Studio
- Completed RPA Developer Foundation Course from UiPath Academy
- Extensive use of all the features available in UiPath Community edition
- Built UiPath POCs on these use cases from scratch:
- Process 3 : DB SELECT Queries automation >> Environment : Oracle Instant client, ODBC Driver, MS Excel and MS Outlook >> Description of Project : Running a set of Select queries was a part of daily activity. This process connects to DB, runs the queries thrice with some delay and sends an email notification with the output in an html table
- Process 4 : Aged tickets report downloading from Service Now >> Environment : Service Now Web Application, MS Excel and MS Outlook >> Description of Project : Aged tickets had to be addressed at least once a week. This process logins into Service Now through web browser, directs to specified path, downloads the .xlsx file, filters data with data manipulation techniques and sends an email
- Process 5 : VP reporting project >> Environment : Web browser and MS Excel >> Description of Project : Testing team had a daily repeated task. This process opens .html file, scraps data by including filters, saves in a .csv file and manipulates excel data.
ORACLE MIDDLEWARE APPLICATION DEVELOPER
IBM INDIA
11.2018 - 01.2021
- Project : Premier Farnell Ltd is a distributor of products for electronic system design, maintenance and repair throughout Europe, North America and Asia Pacific, with operations in 36 countries and trading in over 100
- Accomplished 2.5 years as Oracle Fusion Middleware - 11g Production support developer
- Managing the functionality and efficiency of all Middleware servers and OSB services
- Knowledge of OSB/SOA Weblogic Consoles, troubleshoot issues and problem investigation using logs in UNIX environment and provide root cause analysis, actively involved in Performing pre-agreed list of sanity checks after deployment of Middleware projects
- Maintain, monitor, identify and analyze system components, focus on predicting and preventing failures, Participation in implementing automation strategies, monitoring problem queues and working through problems to resolution as they arise
- Ensuring the Service Level Agreements for the production level agreements are met by resolving the different priority level monitoring and Customer driven Incidents
- Dealt with developers, DBA service providers, storage team, network team and other system teams to coordinate the resolution of problems and issues, Testing of XML messages in local for tracing the error
- Responsible for documenting all daily, weekly, and monthly reports. Participated in weekly meetings
- Strong ability to work independently and in a team and have good time management skills
- Role encompasses a multitude of activities including support to small code changes across domains.
Education
Bachelor of Engineering -
2018
- Attained an aggregate of 71.2% during graduation, built 2 projects - Obstacle avoiding Robot (Group project) and Speaking System for mute people using hand gestures (Major Project), Secured first place in inter College Technical quiz competition, was nominated for the best outgoing Student 2018. Presented technical seminar on Augmented Reality.
- Attended Internet of things by Tenet - Technotronics and Robotics by SakRobotix, Mobile repair workshop by PMKVY, Seminars like Rapid prototyping on IOT using Intel Galileo, Talk on Entrepreneurship as a career by Ravi Kiran and Applications of OFC, App design prototyping by iOS Finishing School.
Skills
- Understanding capabilities of SQL, XML, XML Schema and the knowledge of UNIX commands
- Fluent Verbal communication and strong written skill
- A hunger to know the latest and new technologies and ability to apply them quickly
- An ability to develop RPA prototypes and Proofs of Concept
- Acquired knowledge badges from IBM: Cognitive practitioner, Enterprise Design thinking
- IBM Quantum conversations, Electronics Industry Jumpstart, IBM Automation Compass
- Self-Motivated and Ability to develop new skills quickly
- Have a good background in Middleware Product support and Development (To at least a Basic level)
- Capable of researching packages and libraries, automation technique alternatives
Certification
- UiPath Certified RPA Associate v1.0 (UiRPA) issued on 2021-Feb-13 (expires never).
- Udemy- XML and XML Schema Definition course.
- Microsoft Certified Azure Fundamentals (expires never).
- Selenium using Python – Infosys LEX.
TOOLS USED
- MICROSOFT OFFICE TOOLS
- SQL DEVELOPER
- SERVICE NOW
- OEPE (ORACLE ENTERPRISE PACK FOR ECLIPSE)
- SUPERPUTTY
- SVN
- SHAREPOINT
- WINSCP
- VISUAL STUDIO
- SQL SERVER MANAGEMENT STUDIO
- UIPATH STUDIO
- ORCHESTRATOR
Activities and Interests
- Secured 15th position in IBM walkathon competition
- Secured 2nd Runner Up in IBM's I&U event for our short movie
- Attended CES 2021 as a CTA member for broadening knowledge on cutting edge technologies in IBM
- Participated and secured top 10 in AI Infosys NVIDIA Hackathon competition on building Object Detection AI Model using A100 GPU (Came across few AI Concepts - Transfer Learning, Yolo Model,Bounding box, TAO Tool kit, Dataset, Labeling, Augmentation, Inference, Epochs, Confidence Score)
- Awarded as budding star at Infosys TSG.
Timeline
RPA DEVELOPER - INFOSYS LIMITED
02.2023 - Current
PYTHON AND DATABASE DEVELOPER - INFOSYS LIMITED
03.2022 - 01.2023
UIPATH - RPA DEVELOPER - IBM INDIA
02.2021 - 02.2022
ORACLE MIDDLEWARE APPLICATION DEVELOPER - IBM INDIA
11.2018 - 01.2021
RITM-VTU - Bachelor of Engineering,