Sahil Bansal Email and Phone Number

• Worked for clients Chevron Corp. and British Petroleum to Identify, analyze the customer’s Business Challenges, organizational Goals, objectives to build long-term relationship.• App Modernization done for migrating data from Legacy Systems to Azure DataLake, Data Factory, and Synaspe. • Solution Architecture, Design and analysis done for upstream oil production equipment models and midstream oil refineries data in Azure Data Factory, Synapse and Databricks. • Data modelling done and developed complex data curation Algorithms, data parsing and data cleansing done using Spark SQL to increase the number of matches between different data entities.• Automation done by Creating Pipelines to ingest data from Databricks to Master Management system.• Developed Power BI Dashboards and Reports for KPIs and metric counts using Databricks as Data Source. • Design and Develop Open Artificial Intelligence Chatbot using LLMs for Data in Neo4J graph Database.• Cloud sales and development by defining a sound Go To Market strategy & Business growth strategy to improve margins by generating new business opportunities.• Contract Management and negotiation with customer by collaborating with internal stakeholders.• Revenue Management using Resource Loading Sheets and Balance To Go Efforts Estimation. • Cost Management by effectively using appropriate pricing models and strategies depending upon Project Scope and Business Requirements.• Lead the team and manage the customer deliverables, strategic programs and integrated projects.• Sales and Revenue Forecasting by tracking the important metrics, dashboards and KPIs.

(Payroll Company: Strawberry Infotech)• Design architecture and Cloud Strategy formulation for implementation of Azure Data Solutions by selecting most suitable, cost effective, scalable components meeting business objectives.• Drive and manage the deployment of solutions onto the Azure platform by working with customers and internal team to envision, architect, and help build solutions• Maintain deep technical expertise in Data, BI & AI technologies; understanding market trends in target industry, competitive insights, and industry regulatory/compliance requirements• Establish relationships with key technical and non-technical decision makers to help drive long-term cloud adoption to resolve business problems and develop impactful solutions• Understand customer business requirements, challenge assumptions to motivate change, identify, validate, and grow opportunities to deliver tangible business value.• Project planning and scope, schedule, cost, quality and risk management.• Lead and manage a software development team to foster proper completion of assigned duties within timelines.• Interfaced with cross-functional team of business analysts, developers and technical support professionals to determine comprehensive list of requirement specifications for new applications.

(Client: Emaar Properties)• Coding and Development done in C#.net following on all stages of software development lifecycle, from requirement gathering to production releases.• Making enhancements and adding features to existing Web software.• Modified existing Web software to correct coding errors, upgrade interfaces and improve overall performance.

(Client: Etisalat, Ministry of Foreign Affairs)Worked closely with software development and testing team members to design and develop robust solutions to meet client requirements for functionality, scalability and performance.

• Interact with Onshore team in UK to get business requirements. • Coding in C#.net and database using SQL Server as backend.• Develop Web API Controllers to interact with the database.• Followed AGILE methodology using Rally tool by creating User Stories and tasks.• Developed Content Manager in .NET and SQL to take inputs for the system.• Maintain and commit code in SVN and deployment to UAT servers.

(Payroll Company: Aavas Infotech)Project Name : Market Communication System• Develop and design database structure of assigned module in SQL Server 2008(created tables, constraints, views, stored procedures, triggers and functions).• Coding done in C#.net as per the standard guidelines taking care of the performance.

(Payroll Company: WDC Limited)Project Name : Web Production Management SystemProject Description: System used in the BPO industry of IBM for both inbound and outbound processes in different lines of business.

Development done for Software System of US based client and pioneered new methods of code development to incorporate wider range of voices, enhancing final products with ideas otherwise overlooked.

Project Name : Human Resources Management System (Payroll Software)Project Description: Payroll software to calculate salaries of all the employees as per HR policies of the company. To keep track of the daily attendance, tax calculations and keep record of the loans, advances, arrears and other deductions to be made.

Development done for the Blackberry Enquiry Software in Java Programming Language.