Home

Sandeep Kumar - WebSphere Commerce /Architect Admin at Commerce, Georgia

[email protected]

Location: Austin, Texas, USA

Relocation: yes

Visa: H1B

Sandeep Kumar Kallepalli LinkedIn Profile +1571-463-6046 [email protected] Page 1 Professional Summary: Around 14 years of IT experience in developing web applications, e-commerce applications using HCL Commerce (previously IBM WebSphere Commerce), Java / J2EE technologies Web services, AWS and Azure. Experience working in HCL Commerce versions 7, 8, 9.0 and 9.1 IBM Certified WebSphere Commerce Application Developer (V7 Fep7) and V8. Experience in Migration WebSphere commerce versions from WCS7 to WCS 8 and HCL Commerce 9 Excellent proficiency in core java concepts such as OOPS, Collections, Threading, generics, Exception handling, Thread pools. Stong knowledge in developing micro services using Spring Boot framework. Expertise in developing large scale applications using J2EE technologies like JDBC, Servlets, JSP, EJB and JPA. Experience implementing build and consume Soap Based Web Services and Restful Web Services Expertise in deployment activities for Staging and High availability Production systems, Docker and kubernetes. Having experience in implementing various business models like B2C, B2B and Extended Sites. Good Knowledge in major sub systems of WCS (Catalog, Member, Marketing & Order Management). Thorough knowledge on integrating WCS with the backend business systems like Payment Gateways. Hands-on and Implemented BOD and Name-Value pair frameworks in WCS. Experience in designing Front-end pages using HTML, CSS, JavaScript and React JS. Good Knowledge in HCL commerce Server Administration activities. Hands on experience working with AWS S3, Lambda, Cloud Front, Cloud Watch, API Gateway, EC2, IAM, Security Groups and Auto Scaling Good knowledge on Debugging Tools, AppDynamics, Grafana, Lens Basic understanding of streaming platforms like Apache Kafka. Expertise in code merging and repository handlings with CI/CD pipeline using Jenkins for Continuous Deployment Good working knowledge on SOLR and Elastic search customizations. Proficient in using Subversion (SVN), GIT for Version controlling. Experience in working with Log4j2, Log4j, SLF4J logging frameworks. Experience in developing unit test cases using Junit Good experience in working with software project management tools like JIRA and ADO. Good knowledge of DB2, Oracle and MySQL, SQLServer, stored procedures and writing highly complex queries. Having experience in writing and implementing UNIX shell scripts. Good experience in deploying and Managing applications across cloud environments using Amazon Elastic Container Services and Microsoft Azure. Technical Skills: Languages & Technologies Development Tools Java, J2EE, SQL, Servlets, JSP, EJB, Rational Application Developer, Struts, Hibernate, Web Services, Unix NetBeans, IntelliJ, Eclipse Shell Script Web Tools/Frameworks Web Servers and Application servers Struts 1.x / 2.x, AJAX, Servlets, JSP, IBM WebSphere Application Server, JSTL, , Spring MVC, Spring Batch, Apache Tomcat Sandeep Kumar Kallepalli LinkedIn Profile +1571-463-6046 [email protected] Page 2 Spring Data JPA, JSON Cloud Platforms Databases AWS, Azure Oracle, IBM DB2. Onshore Experience: Visited Brazil (Client location) for 5 times. Education: Bachelor of Technology in Computer Science, VITAM college of Engineering, JNTU Kakinada, Andhra Pradesh.(2006-2010) Professional Experience: Senior Developer HCL Commerce in Northern Tool and Equipment, from October, 2023 till date. Senior Technical Architect in ACL Digital, from February, 2023 till September, 2023. Senior Consultant in Perficient, from July, 2022 till March, 2023. Senior Technical Architect in HCL Technologies, from February,2020 till July, 2022. Senior Consultant in BlueSky Technology Partners (Brickyard Digital in India) from November, 2018 till December, 2019 Lead Consultant in Incresol Software Services Pvt., Ltd. Hyderabad from November,2011 till October, 2018 Developer in Nicole Solutions, Hyderabad from November,2010 till October, 2011 Work Experience: Project : Northern tool + Equipment Oct 2023 till date Role : Senior Developer HCL Commerce Client : Northern tool + Equipment, Burnsville, MN Description: NTE is a family-owned business established over 40 years supplying quality tools and equipment. With over 120 store locations across more than 20 states in USA, Northern Tool has a strong retail presence in the U.S. NTE has a website packed with over 100,000 tools, curbside store pickup, nationwide delivery and a team standing by on the phone always ready to take orders. NTE is a React based front-end store with Backend-end framework based on the HCL Commerce solution. Environment: HCL Commerce V9.1.5, db2, Microsoft Azure, Git Responsibilities: Planned and implemented multiple Rest based API s across the site on HCL Commerce Tool. Worked on various production bug fixes and enhancements like IOM shipping options and Payment gateways. Participated in HCL Commerce Architectural reviews and CICD pipeline jobs and branching strategies. Gathered requirements and participated in requirements analysis and converting requirements into technical specifications. Done unit testing and code review activities. Mentors team members in best practices and coding standards with in HCL Commerce. Involved in Deployment activities. Project : Nord N1 Mar'2023 Sep 2023 Sandeep Kumar Kallepalli LinkedIn Profile +1571-463-6046 [email protected] Page 3 Role : Technical Lead Client : Essilor Luxottica, USA Description: N1 is a headless BE framework based on the HCL Commerce solution that will be the baseline for the next Essilor Luxottica B2C rollouts. Speeding up the B2C implementations and standardizing the processes are the main goals of the project. Environment: HCL Commerce V9.0, Oracle Responsibilities: Participated in Architectural reviews Gathered requirements and participated in requirements analysis and converting requirements into technical specifications Planned and implemented multiple Rest based API s for prescriptions functionality. Done unit testing and code review activities Project : Lowes.com July'2022 Mar 2023 Role : Senior Consultant Client : Lowes.com, USA Description: Lowe's Companies, Inc is an American retail company specializing in home improvement. The company operates a chain of retail stores in the United States. Rona which is a subsidiary of Lowe s in Canada moved out and the brand conversion in place. Environment: HCL Commerce V8, DB2, AWS. Responsibilities: Created and executed Jenkins pipeline jobs for data loads of all subsystems. Extracted data from Rona database and formatted it according to HCL commerce OOB database models and created data load files for the same. Troubleshooting for the failed Jenkin jobs monitoring the Jenkins pipeline job logs and re- executed them with necessary fixes. Build container-based solutions using Docker and CI/CD pipeline using Jenkins. Project : Coles online Feb'2020 Jan 2023 Role : Technical Lead Client : Coles Group, Australia Description: Coles Online is an online retail site worked by Coles Supermarkets. The administration offers a wide scope of ordinary basic food items for buy by means of the web and resulting home conveyance or 'Click and Collect' areas. The administration is accessible to over 85% of the Australian populace Environment: HCL Commerce V8, DB2 Responsibilities: Involved in WCS 7 to WCS 8 migration activities Participated in Architectural reviews Gathered requirements and participated in requirements analysis and converting requirements into technical specifications Planned and implemented single page checkout for the store. Created custom REST Handlers for Controller Commands and Data Beans Done unit testing and code review activities Mentored team members in best practices and coding standards Project : MVS (Midwest Veterinary Supply) May 19 Dec'2019 Role : Senior Consultant Client : Midwest Veterinary Supply, USA Description: Midwest Veterinary Supply (MVS) currently offers a service to their veterinary clinic partners allowing them to host an eCommerce storefront in which pet owners can purchase medicine, food, and other Sandeep Kumar Kallepalli LinkedIn Profile +1571-463-6046 [email protected] Page 4 supplies for their animals. MVS planned to migrate the existing MVS eCommerce solution to one built upon the WebSphere Commerce platform utilizing both B2B and B2C functionalities. Environment: HCL Commerce V9, DB2, AWS Environment Responsibilities: Worked on User Registration module. Implemented UPS address Validation. SEO URL Shortening. Implemented Ticket Tracker for online requests from clinic admins. Project : Kay, Jared, Kayoutlet, Sterling Jewelers Nov 18 Apr 2019 Role : Senior Consultant Client : Signet Jewelers Ltd, USA Description: Signet Jewelers Limited is the world's largest retailer of diamond jewelry. Signet operates over 3,500 stores primarily under the name brands of Kay Jewelers, Zales, Jared The Galleria Of Jewelry, H.Samuel, Ernest Jones, Peoples, Piercing Pagoda, and JamesAllen.com. It has online stores for Kay.com, Jared.com, Kayoutlet.com, SterlingJewelers.com. Environment: IBM HTTP Server 7.0.0.39, IBM WebSphere Commerce Server 7.0 FEP 3, Oracle 11g, Red Hat Enterprise Linux Server release 6.8 Responsibilities: Worked on various defects identified by users and Errors identified in server logs. Project : Bemol WCS Enhancements Oct 14 Oct 2018 Role : Lead Consultant Client : Benchimol, Irm o e Cia LTDA,Brazil Description: Bemol Online is a project to migrate the existing PHP based eCommerce system to IBM WCS B2C store to enhance the online sales through different channels & integrating with SAP ECC. Project is divided into multiple sub-projects such as Desktop store, Mobile store, Tablet store and Mobile, Tablet Hybrid Apps and implementing new features. Environment: WebSphere Application Server 7.37, IBM WebSphere Commerce Server 7.0 FEP 4, Oracle 11g, Windows 7 and Linux. Responsibilities: Interacting with the client to gather requirement for new business requirements Involved in project planning & work allocation to team Deployment of the build in QAS & PRD environments Involved in migration of Bemol WCS Application's host servers to IBM Environment for all (PRD, QAS and DEV) the environments with interacting with IBM Team. Implemented the concept of Extended Site stores to switch the regions and sharing the shopping cart across the regions using Contracts. Implemented Extra Warranty selling as a service Review test plan/test cases and close interaction with testing team Performed code review for team members code Mentored the team members along with implementing the requirements. Taken responsibility as a Technical Business Analyst in the project and helped team as well as client accordingly. Sandeep Kumar Kallepalli LinkedIn Profile +1571-463-6046 [email protected] Page 5 Implemented the shortened URL's for event flows by using SEO URL Mappers. Involved in development of Custom Controller Commands, Task Commands and JSPs Created entity beans , access beans based on the requirement. Created custom REST Handlers from Controller Commands and Data Beans Project : Bemol Hybrid Mobile Apps (Android & iOS) Jun 14 Sep 14 Role : Senior Consultant Client : Benchimol, Irm o e Cia LTDA,Brazil Responsibilities: Modified configuration files to enable Android and IOS Apps Created eSpots to handle some of the client requirements Identified the location of the app user to show the nearest stores. Involved in development of Custom Controller Commands and JSPs Hosting of Apps in Android Google Play and IOS App Store Work allocation to team members and leaded the team for this project Coordinated with the Mobile Application development team Interacting with the client to gather requirements Review test plan/test cases and close interaction with testing team Project : Bemol Mobile and Tablet Store Nov 13 Jun 14 Role : Senior Consultant Client : Benchimol, Irm o e Cia LTDA,Brazil Responsibilities: Developed a POC on Mobile implementation and got acceptance for the project from client Publishing the Madison's Mobile store and Tablet store Participated in running the data load utility for categories Worked on Management Center (Marketing Sub System) for creation of promotions and coupons Worked on Catalog Sub System and extensively used the database interactions that belong to this subsystem Modified configuration files to enable Tablet store Created eSpots for each Top Category page Involved in integration with Google Analytics Deployment of the build in QAS & PRD environments Participated in code review activities for other team members Project : Bemol Desktop Store Oct 12 Oct 13 Role : Consultant Client : Benchimol, Irm o e Cia LTDA,Brazil Responsibilities: Installed the WCS tools in local VM and participated in Admin Activities of configuring SVN setup to establish the streamlined code integration across the landscape (Customer & Incresol landscape) Extended existing controller commands and implemented business logic Sandeep Kumar Kallepalli LinkedIn Profile +1571-463-6046 [email protected] Page 6 Created eSpots for home page and Top category pages Customized the user interface with HTML 5, CSS, DoJo and jQuery Worked on Scheduler jobs for running the data load utility Worked on Member, Catalog, Order, Marketing and Payment subsystems Involved in deployment activities Post production support and bug fixing Client : The BookPeople ,UK Nov 11 Sep 12 Project : The Book People Role : WCS Developer Description: The Book People is one of the UK s fastest growing on line retailers of affordable books for all, selling a wide range of children's story books, autobiographies, fiction books, Life style books, thriller books, TV, film & music related books and reference books. Founded in 1988, the Book People is an award- winning family company with staff who are passionate about books. Customers can buy books on line, by mail order, at the Book People s book events and through their distributor network, which delivers to schools, organizations and offices all over the UK bringing the best books directly to you each week. Environment: WebSphere Application Server 7.0, IBM WebSphere Commerce Server 7.0,DB2 UDB8.5, Windows XP and Linux. Responsibilities: Extended existing controller commands and implemented business logic Involved in development of Custom Controller Commands, Task Commands and JSPs Worked on marketing subsystem functionality like Creating Dialog activities, Customer Segment and Campaigns using management center Customized address book, so that user can save their work address Configured Newsletters functionality for all types of users Integrated Gift Registry for the store Client : Lear Corporation, Michigan, USA. Nov '10 Oct '11 Project : Waste Management System.(WMS) Role : Developer Description: Lear Corporation is one of the world's largest suppliers of automotive interior systems and components. Lear provides complete seat systems, electronic products and electrical distribution systems and other interior products. During its production process lots of waste is generated whose details have to be recorded and submitted to Environmental protection Agency (EPA) at the end of the year. WMS enables the company to maintain their daily reports of the waste being produced in a database. So the aggregated reports can be retrieved and submitted to EPA at the end of the year. WMS helps Lear to take steps to help keep the environment clean by their use of environmentally friendly materials and manufacturing practices with reference to the details persisted using WMS. Environment: Java, Servlets, JSP, Struts, Oracle 9i, JDBC, Rational Application Developer 6.0, WebSphere Application Server 6.0 Responsibilities: Involved in developing user interfaces using java server pages. Sandeep Kumar Kallepalli LinkedIn Profile +1571-463-6046 [email protected] Page 7 Implemented connection pooling using data source Implemented MVC design pattern Developed custom tag handlers for using in the front-end JSP pages. Keywords: continuous integration continuous deployment javascript sthree information technology Minnesota