Ankit Khandelwal Email and Phone Number

Provisioning and configuration of Bupa Global environments which comprise of Sun Solaris Unix Server, Oracle Databse and for developemnt,testing, training and prodution support team above OS Level.Ensure that communication and notfication with stakeholders whenever the release schedule and deliver fir for purpose project development along with ensuring the production environment available at all times except planned downtime.Follow and adhere to the Bupa major incidents process when applicable.Monitoring azure application environment team via New Relic, Loggly and App-InSights tools.Provide support to the various project development scrums, testing teams, as welll as third party vendors.Manage day to day request/issues to ensure that all development changes are deployed to the appropriate environment in timely fashion.

Role and Responsibilities:Project Name : CTA (WMDMI - Wealth Management Data Management Initiative) The Wealth Management Data Management Initiative (WMDMI) proposed to Developing the regional data mart (RDM) instances which will collate data from authoritative data sources and then feed into global data mart that will aim to provide standardized information across all locations.WMDMI will drive the following tangible benefits:• Authorized data distributor of WM data at a local/regional level.• Agile and cost effective data integration between core platforms and satellite applications.• Ability to respond to regulatory data requests in timely and effective fashion.• Consistent reporting and analytics providing view of the business. Project Name : CyberSecurity Program (DMR - Data Management and Reporting) Major role is to capture data, assessment, monitoring and reporting required to demonstrate Compliance to DB Standards for Privilege Access.Securing and Managing Privileged accounts and access, preventing breaches and insider attacks.Environment must include Windows, UNIX, MSSQL, Oracle and Sybase and other Platform which are introduce in DB Infrastructure.Responsible for On-boarding of the DB Infrastructure in CyberArk Platform and co-ordinate with various teams for the same.Discover all accounts which can be used to gain Privileged access to target Configuration Items.Compare the list of accounts to control system.Produce reports that both prove compliance to DB control standards and highlight exceptions for remediation.

• Result-oriented professional offering 5+ Years of experience in Production support and development using Oracle SQL, PL-SQL and UNIX Shell Script.• Deep understanding of technology and Proven ability to be a strong professional with knowledge of the technologies and applications.• Developed and deployed Shell Scripts in the production for customized MIS reports, Application monitoring automation, extracting data dumps and loading data into Database.• Wrote stored procedures, functions, cursor and views for the new feeds to accommodate new business entities. Also wrote few complex SQL queries to fetch data and to present the information to users • Developing and deploying shell scripts in production for automation and application monitoring purpose and loading data dump extraction • Good knowledge of Relational Database Management Systems and Database applications.• Providing application maintenance and Development support with regard to the product / software application.• Knowledge of BMC Remedy, IBM DB2 Studio, TOAD, BISAS, COGNOS, WINSCP tools.• Excellent analytic, problem solving, and conceptual skills.• Delivered High level technical support to current and new business applications

• Working on Automations and handling the Application of AT&T U-verse Project .• Working on Cases in CRM/EM as well as prepare Documentation/SOP of the applications.• Application maintenance and providing production support 24*7.• Involved in process improvement by analyzing the Process flow of UCSDC project.• Use Various tools to handle the Order Fallout like BMC Remedy, CRM, SDP and PST also Generating SLA reports for the application• Using Query to verify all the data integration against the order

• Looking after Idea DSM Operations for PAN India, an Inventory Management System controls/operates on PAN India, IDEA’s end customer products and virtual products.• Ensure required configuration on Servers and Application mapping.• Using BMC Remedy Tool for providing resolution of issues/concern to the end user.• Providing access and error logs from Applications.• Using TOAD/SQL to extract reports catering business requirements. • Development of Shell Scripts for automated monitoring.• Automation of daily and monthly reports using UNIX Shell Scripts.• Use of Database system and Process which helps in taking decision for smooth running of Application.