Karan Bansal

CURRICULUM VITAE Karan Bansal # 81, Sugan Chand Compound Ambala, Haryana PIN-133001 Ph-no:- Email: - Career Objective – To work with an organization of repute that provides opportunities for learning and growth for recurring development to reach the zenith. Work Experience: 7 + years of experience in Production Support/Development of software systems based on Microsoft technologies. EXPERIENCE PROFILE: Offshore experience : 1. Worked in Motorola account in TCS, Chennai from November 2006 to December 2007. 2. Got a confirmation rating of 5/5. Onsite experience : 1. Worked in American Express Pvt Ltd in Gurgaon, India from December, 2007 to July 2009. 2. Got a Year end rating of 5/5. Freelancer experience : 1. Worked with Versata(Trilogy Inc.) as technical support engineer for ERP and POS softwares, On-Premise/Cloud based Exchange products, Sales Forecasting product from October 2012 to July 2016. 2. Have accumulated more than 5000 hours of work. TECHNICAL PROFILE: Platforms /OS : Microsoft Windows Server, 2012 r2, 2008, 2008 R2, XP, Vista, Windows 7/8/8.1, HPUX servers. Languages :VB scripting, Asp.Net, ASP, C, C++, SQL, PL/SQL DBMS :SQL Server 2000 and 2005, ORACLE 9i, Sybase TOOLS :Crystal reports 9.0, Informatica 8.1.1, Open/Deploy, Intellisuite, Tumbleweed Secure Transfer, VSS, Oracle SQL developer. CERTIFICATIONS : Oracle IZO-007 with 89 % Payment Cards Certification (Domain Certifications) EDUCATIONAL QUALIFICATIONS : Degree:Bachelor’s Degree in Electrical. Year of Passing:MAY 2006 (2002 – 2006) Percentage of marks:68 % (Aggregate) College + University:Chotu Ram State College Of Engg , Murthal Maharishi Dayanand University, Rohtak Degree:Higher Secondary (HSC) Year of Passing:MARCH 2002 Percentage of marks:83.0 % (Aggregate) School:SD Public School, Ambala Cantt Degree:SSC Year of Passing:MARCH 2000 Percentage of marks:80.6 % (Aggregate) School :ARMY School, Ambala Cantt C.B.S.E. Board. PROJECT PROFILE: Project Title : Motorola Duration : November 2006 – December 2007 Position : Production Support Executive Company : TCS Brief Summary : Motorola Online (MOL) is a B2B website for the enterprise customers of Motorola. This site allows them to view and purchase Motorola products, manage/track their orders, get their products serviced/repaired. MOL is a 24/7 application and is one of the most critical applications under N&E. It is used all over the world. Customers are categorized into ASIA, EMEA and NA regions. Around 80,000 users use MOL and it generates approximately 7 billion dollars annually. (About 27% of Motorola’s revenue). Responsibilities : Production support for MOL Solving issues raised by users through Remedy. Preparation of Maintenance manuals for the Application Coordinating with other resources and customers in analyzing the incidents and determining their impact on the system under consideration Requirement Analysis for enhancements/changes. In case of Change requests, Building Test cases and Constructing Test data. Performing Data fix and code fix. DR in case of Power outrage Provide Month-end, Quarter –end and year end support. Provide proper Handshake between the Applications Highlights 1. Got many client appréciations. 2. Got appreciations from my ASIA SME 3. My team achieved the feat of reducing the application bucket to a record all time low count of 2.Received Account level recognition for this. 4. Got a confirmation rating of 5. Project Title : Recgen 2 – American Express Pvt Ltd Client : American Express Pvt Ltd Duration : From Dec 2007 – Dec 2008 Position : L2/L3 support analyst. Company : TCS Brief Summary : Recgen 2 is an application used for daily/monthly account reconciliation process in AMEX. The application has both thick and thin clients. It allows the users to perform reconciliation, matching,month close related activities to there accounts and also to schedule the same process. The overall objective of the Recs Gen II (Reconciliation Generation II) project is to redefine the reconciliations process performed across American Express to address the Level 1 SOX (Sarbanes-Oxley) deficiency. The goal of the Recs Gen II Implementation Project is to implement the POA (Point of Arrival) Reconciliations process as per the New Reconciliations Policy and the POA process defined by the Six Sigma project. The application uses Sungard product named Intellisuite and custom solutions using Informatica, VB scripts, Batch Scripts , Tumbleweed have been developed/deployed around it to achieve the overall process flow. Responsibilities : Production support for Recgen 2 Solving issues raised by users through Managenow. Preparation of Maintenance manuals for the Application Coordinating with other resources and customers in analyzing the incidents Requirement Analysis for enhancements/changes. In case of Change requests, Building Test cases and Constructing Test data and executing / owning the CMR through Infoweb. Performing Data fix and code fix. Provide Month-end, Quarter–end and year end support. Mentoring new team members. Highlights Got many client appréciations. Received Achievement award in Client townhall. Have implemented script that has helped save around 350 IMRs within 3 months of release. Made configuration changes to Database which removed significant application downtime during patching/installation activities. Project Title Client : : IDN - American Express Pvt Ltd American Express Pvt Ltd Duration : January 2009 to May 2009 Position : Developer Company : TCS Brief Summary : IDN is the information delivery network of Amex. The Information Delivery Network is an analytical platform with easy access to standardized data, powerful tools, a robust governance structure, and an integrated execution system, providing an environment where American Express can rapidly understand and fully leverage business opportunities to grow profitably, without surprises, while measuring the impacts to our customers. Responsibilities : Understanding business needs and providing the automated process to get the relevant data that helps in analysis. Simulation and logic analysis Test new processes prior to implementing into production View specific transactional data Create ad-hoc reports Project Title : Everest Enterprise manager Duration : October 2012 to January 2013 Position : L1 Support Analyst Company : Versata Brief Summary : Everest Enterprise manager is fully integrated business management software and addresses the challenges of growing small and midsized businesses. It has in-built modules for Payroll, Payment processing, Stock management, Accounting, CRM studio, Retail website, POS. Responsibilities Highlights : : Managing customer reported issues through ticket management system Zendesk. Writing Knowledge Base articles to help the customers learn more about the product. Conduct training/demo for new/prospective clients. Help report bugs and testing new code releases/bug fixes. Help in managed upgrades for the customers. Highlights : Versata has a very dynamic work environment and most of the hired resources find it tough to meet the demands. Within one month of joining the project, I was among the top 3 resources in the entire pool under SMB support. Project Title : Prologic Duration : January 2013 to Dec 2015 Position : L1/L2 Support Analyst Company : Versata Trilogy Inc Brief Summary : Prologic is an application focused on Lifestyle and Fashion industry having clients based in UK. It provides the HO(CIMS) and POS functionality and has in-built capability for end-to-end Product Management, Price and Promotion, Supply Planning, Warehousing and Distribution. Prologic’s integrated ERP and POS solutions are tailor-made to help retailers learn from all retail channels, and ultimately make better business decisions. Responsibilities Highights : : Managing customer reported issues through ticket management system Zendesk. Writing Knowledge Base articles to help the customers learn more about the product. Help report bugs and testing new code releases/bug fixes. Been at the top of the SMB pool ranks for almost entire year. Was one out of the only two resources retained during a huge cost cutting effort in the project. Have received outstanding customer feedbacks. Was selected as a backup resource for new store installs. Project Title : Dell MessageOne Duration : Dec 2015 to July 2016 Position : L2 Support Analyst Company : Versata Trilogy Inc Brief Summary : Dell MessageOne is an integrated suite that consists of two products: EMS (Email Management Services) and AlertFind. EMS: EMS is a back up email continuity system which provides companies with an email system when their primary exchange systems or email providers are down. EMS in itself is an integrated suite which also provides Email Security (Anti Spam) , Email Archiving, On premise and cloud Journaling, Directory/Contacts/Calendar back up. AlertFind : AlertFind Enterprise Notification Service is a cloud based, multi-tenant emergency and mass notification service (EMNS) provided by Dell as a Software-as-a-Service offering on a subscription basis. It is intended to automate and facilitate notifications to recipients by broadcasting alerts or other messages via multiple communication channels defined in each recipient's notification profile. These channels of communication include voice calls to land lines or mobile phones using TTS (text-to-speech) or recorded voice capabilities, SMS, email and fax. AlertFind can also integrate seamlessly with enterprise systems of record. Also, valuable contact information and group definitions can be imported into the AlertFind database and data exported out of AlertFind to capture updates made by employees. Responsibilities Highights : : Managing customer reported issues through ticket management system Zendesk. Writing Knowledge Base articles to help the customers learn more about the product. Help report bugs and testing new code releases/bug fixes. Identify Saas issues and take ownership for Saas communication. Handling third party communication with vendors. Been at the top of the Applications team pool ranks. Have received outstanding customer feedbacks. Hobbies:- I have a very strong passion for teaching and have also worked as a Quant/logic faculty with reputed institutes preparing students for competitive exams like GMAT, GRE, and SAT. I have more than 10,000 hours of classroom teaching experience and public speaking. Positive Traits:- An optimist, a keen learner, ready and eager to face all sorts of challenges. I strongly believe that attitude is the most important factor for success. PERSONAL DETAILS: Name Karan Bansal Date of Birth 16th October,1984 Marital Status Married Father’s Name Mr . Rakesh Bansal Address for Communication # 81 , Sugan Chand Compound Ambala Cantt, Haryana Passport Number G- Passport Validity Uptil 18-DEC-2016 Place of Issue Chandigarh Email ID - References : Susan Vucak Karl Wooffindin Email :- Email :-PEM Versata Former IT SDM : Go Outdoors LTD. Viorel Curic Marvin Evers Email :- Email :-TCSM Versata Apps team IT SDM: GO Outdoors LTD.