Arnab Roy

Experience

• 

  Satyam Computer Services Ltd

  Jan 2004 - Apr 2006

  Software Engineer

  Software Engineer • Web applications development and maintenance in Visual Basic, Oracle PLSQL, ASP.NET (C#)• Client Server applications support and maintenance in VC++, ASP.NET and Oracle PLSQL.

• 

  Tata Consultancy Services

  May 2006 - Apr 2010

  Lead Information Technology Analyst

  As the Lead Information Technology Analyst at Tata Consultancy Services in the United Kingdom, I spearheaded the management of offshore teams for Large Scale Clarity PPM implementation across the landscape for 2000+ users which involved advanced performance tuning and custom design. Implemented Oracle PLSQL Server Pages & Advanced PLSQL data-warehousing solution. Help buliding the PPM Software implementation and user adoption across the board for business areas.

• 

  Wipro Technologies

  Apr 2010 - Jun 2013

  Lead Technical Specialist

  CA Technologies – Services Global Delivery Project and Portfolio Management.Responsible for monitoring Performance Tracking and Optimization, enhancing Clarity System performance utilizing tools such as HP SiteScope, Unix System Monitoring, Clarity NSA, IIS Monitoring, and Apache Tomcat.Developing scripts to monitor and optimize Clarity database performance through V$ views.Led the Business Objects Universe Development Project.Constructed the Reporting Layer on CA Clarity OLTP and created a custom BO Universe for Novartis.Conducted comprehensive end-to-end customer presentations of the Reporting Solution and rolled out implementation to the PMO Community globally (including demonstrations to 130+ Clients).Handling On-demand and On-premise CA Clarity customer environments.Executed RISO Implementation.Utilized Clarity Accelerators (CAPA, Earned Value, PMO, NPD).Proficient in Crystal Reports XI R2.Developed various Portlets including Grid, Graph, HTML, Drill Down, Hierarchy, and Filter.Conducted demos and trainings on CA Clarity 8.x, 12.x, 13.Managed XOG for the movement of Configurations across multiple clients and environments using Studio Assist, XOG Client.Created complex GEL Scripts and NSQL Portlets for workflows and various types of Portlets.Handled Actuate Reports and converted them to Crystal Reports.Actively participated in multiple projects as an Individual Contributor in Clarity Consulting. Show less

• 

  L&T Infotech

  Jun 2013 - Jun 2016

  Technical Implementation & Delivery

  In my role as a PPM Software and Technology Strategy professional at L&T Infotech in New York, I led Agile Delivery for CA Clarity PPM & BI Teams, managing resources, scoping projects, and ensuring quality delivery for entire SDLC. Led Agile Delivery for PPM & BI Team showcasing my expertise in Oracle Database, ETL, Datawarehouse, Gel Scripts, Java, Crystal Reports, and BOBJ.• Oversaw Delivery Management activities including resource management, project scoping, estimation, planning, risk management, specification finalization, resource administration, and quality management for the entire SDLC.• Managed teams following the onshore-offshore model involving multiple vendors (for both PPM & BI Teams).• Demonstrated Client Engagement skills & Multiple Vendor handling working experience.• Proficient in interfacing with clients, suggesting viable services & solutions, cultivating relations with them for securing repeat business, and ensuring quality delivery of solutions to the clients.• Proficient in SSRS, Business Objects Designer, CMC, Info View.• Experienced in working on DWH/Star/Snowflake Schemas/ETL/mappings to load data from multiple SQL Server data sources for loading into a custom reporting data mart.• Proficient in SQL, PL/SQL, developed Stored Procedures, Triggers, Functions, and Packages, in addition to writing DDL, DML, and Transaction queries using development tools like TOAD.• Universes and implementing row-level security.• Utilized Bar Charts, Tree Maps, Slicers, Pies, Scatter, Area, Cards, Multi-row Cards, KPIs, Drill-through features as visualization techniques in Power BI.• Leveraged Power BI Relationships, custom visuals, and published reports to dashboards on Power BI Service.• Utilized Power Query for data transformation, adding custom columns, transposing, invoking custom functions, and applying various data transformation techniques.• Skilled in Oracle Database, ETL, Datawarehouse, Gel Scripts, Java, Crystal Reports, BOBJ. Show less

• 

  Wyndham Hotels & Resorts

  Jul 2016 - now

  In my role as a Information Technology Technical Architect at Wyndham Hotels & Resorts, I spearheaded the architecture, process, and technology roadmaps for digital experience platforms - Microsoft Power Platform, Salesforce Service Cloud, Smartsheet Automations for multiple departments and business functions, Atlassian ecosystem for several teams, iPaaS integrations, RPA, Agentic AI Models, Prompt Engineering, ITSM IFS Assyst/ServiceNow, DataWarehouse Solutions, ETL/ETL, APIs, Python. I managed platform architecture initiatives, led cloud applications onboarding, orchestrated cloud integrations to enhance UX and drive business value.• Designed and implemented technical solution for Global Sales Operations team successfully utilizing AI, Product Strategy, Data Architecture, and Process Optimization to optimize sales processes more than billion dollars, resulting in significant time and cost savings.• Business Process Automation using AI Models, Data Integrations, API Gateways, workflow engineering across Finance, Global Sales, Learning and Development, Legal, PMO, HR, Revenue Management, Operations, Data and Mobile.• Led team of application developers in delivering cloud solutions, orchestration, integrating APIs for complex use cases.• Managed vendor engagement, pricing models, and ROI for SaaS subscriptions • Roadmapping and solution design for multiple cloud enterprise applications, architecture, design, rollout, product strategy, integrations, AI and user adoption.• Implemented data engineering solutions and facilitate large-scale enterprise application migrations.As a Key Technologist, I championed software platform innovation through COE initiatives• Spearheaded strategy for Conv AI Chatbot in various cloud applications, focusing on data security, storage, infrastructure, data model, APIs.• Vetting new applications through POCs and demos, identifying technical challenges, and architecting solutions to bridge gaps between business teams. Show less As an Engineering Technical Architect I led data architecture and engineering for Salesforce Service Cloud, including Leads, Opportunities, and Case. Additionally, I implemented cloud-based services like Microsoft Power BI & Power Automate for data engineering. • Chatbot, LUIS, QnA services, CLU, Azure Services,Conversational AI, BOT Services, Intents.• App architecture, integration strategy, engineering, cloud platform single sign on (Okta), APIs and Rest Services. Migration of on premise applications to cloud platform (SaaS) hosted on AWS and GCP, Expert on cloud based technologies and APIs using Rest APIs, JSON, XML, Web-services, SOAP, ETL, ELT, OData Connectors.• Salesforce Service Cloud – Data architecture and engineering for Leads, Opportunities, Case, Time based workflow, Email Studio, Process Builder, SOQL, Email services/alerts, Flows, Objects, Visualforce pages, Validation Rules, Change Sets, Apex Triggers, Email administration, Email-to-Case, Page layouts, Forms, Fields, AppExchange, Links and Actions, Multiple process automations, Lightning Experience• Cloud based services (SaaS) Microsoft Power BI & Power Automate – Data Engineering on reports to cloud data from various platforms using Power BI, Tableau, QlikView.• Platform as a Service (PaaS) – Data architect/Engineering for migration Service Now to Salesforce . Integration on these systems, complex business logic implementation process builders, workflows, validation rules, SOQL, SFDC case object customizations, dataloader.io, Heroku.• Data Integration / Business Intelligence using advanced RDBMS, Rest APIs, XSLT, XML, XSD, QlikView• AWS and GCP Migration of enterprise applications from on premise to cloud involving Kubernetes and Data Lakes• Data Architect IT Financial Data from various sources like SaaS, Excel, On Prem Apps and transforming and mapping them for Reporting and Analytics (in Power BI) Show less

  • Technical Architect

    Jun 2022 - now

  • Enterprise Applications Architect

    Jul 2016 - now