PRAKASH CHANDRA TRIPATHY

Contact: +1-469-***-****

E-Mail: aduubk@r.postjobfree.com

Enterprise Solution Architech/Salesforce CPQ Product Administrator - Telecom & IT SOFTWARE SOLUTION

Seasoned Telecom OSS/BSS Enterprise Architect, Salesforce CPQ,Salesforce Revenue Cloud Product Administrator with close to 2 decades of insight of Telecom business, & systems architecture for telecom operators across North America,,South America, Middle East, Europe, Asia, Pacific & Africa. OSS/BSS Solution Design, Business Analysis, E2E Functional Consulting, Service Delivery Management, Project Management, Software Development, Application Implementation, Configuration, Order Management, Inventory Management,Billing, Provisioning and Telecom Product Catalog Management of critical business centric systems . Salesforce certified Platform Developer-1 and OCP- Oracle Certified Professional with more than 18+ years of experience in IT.

PROFILE SUMMARY

,

Worked with DIRECTTV, Hughes Netowork Systems, AT&T, British Telecom (BT) and having exgtensive experience on Enterprise Solution Architecture, BSS/OSS application Management and troubleshooting, Salesforce CPQ catalog configuration, Enterprise and Data Architecture, Solution Engineering etc.

Salesforce certified Platform Developer-I and Oracle Certified Professional having more than 18+ years of experience in OSS/BSS Solution Design, Business Analysis, E2E Functional Consulting, Service Delivery Management, Project Management, Software Development, Application Implementation and Configuration, User Acceptance Testing, and Operations and Production Support in technology landscape for Telecommunications industry clients in Europe, USA, Middle East and Africa. Salesforce CPQ,Salesforce Billing -Revenue Cloud Admin, Apex Development, Lightning Component Development

Functional experience includes Telecom Catalog Configuration and Retail Product Modelling using Salesforce CPQ, Telecom Provisioning, Online Charging System,, Telecom Billing, Telecom Revenue Assurance & Revenue Protection, Telecom Data warehousing and Geneva Billing System

Skilled in detailed design of Business Process Workflows using Case tools Such as SPARX, IBM RSA,Oracle Designer, Subversion etc

Led large complex projects in parallel spanning across multiple technologies. Experienced with Project transitioning; requirement gathering; client interfacing; project metrics; quality and processes for the project; and maintaining team and estimation. Adept in IT management, budget analysis, PMO reporting, and providing project status to all stakeholders.

Solid knowledge of data warehousing/BI applications, architectural framework, dimensional modelling, ETL design strategy, and data presentation services using BI tools.

Participated in data governance policy creation, management, and impact analysis of policies under consideration.Documented and maintained data standards, partnering with functional and business data owners to map existing data structures, usage, and common definitions

Used TOGAF and eTOM as an enterprise architecture framework to define business goals and align them with architecture objectives around enterprise software development.

Created logical data domains and models for data from existing systems with close attention paid to scale and future extensibility for rapidly growing busines. Evaluated physical data models to ensure they align to the corresponding logical data models. Involved in large scla data migration using scripting and used data pipeline for aggregating, organizing, and tranfeerring of large scale data.

Extensive experience in Oracle SQL, PLSQL,SQL * Loader, Informatica, Ab Initio, OWB, BO, Cognos ReportNet, SPARX,Rational Software Architect (RSA), Pro*C and Shell Scripting,Python etc.

DirecTV (DTV) Integration R6 conversion - converting over 1.9M accounts enabling OMS, Enabler, CRM, and other source data processed through numerous DW application - 9.3 million DTV customers were fully migrated to the IP platform

Experience in managing teams up to 135 people and revenue in excess of $5 million per year in an Offshore-Onsite model.

Technical COMPETENCIES

Design Tools and Architecture Framework = SPARX Enterprise Architect 16.0, IBM RSA 8.5 (Rational Software Architect), Togaf and eTOM

COTTS Prodcut - Salesforce CRM, Salesforce CPQ, Geneva Billing Systems,JIRA,Confluence

Colud Technologies :- Salescloud,Microsoft Azure and Amazon AWS

APIS – SOAP and REST (Salesforce)

Security – Net IQ Identity and Access Management

Databases: Oracle 8,8i, Oracle 9i,Oracle 10g, Oracle 11g, PL/SQL,SOSL,SOQL

Programming Languages: Apex, Python, C, C++, Pro*C,Java

ETL and BI Tools: Informatica, Oracle Warehouse Builder 9i, Ab Initio, AWS(Snowflake,Databricks and Datalake)

Application & Web Servers: WebLogic, Tomcat, Oracle 9i Application server

Reporting: Cognos ReportNet 8.0, Oracle Report Reports 9i, Crystal Report 7.0, Salesforce Tableau

GUI Tools: Salesforce CRM – Sales Admin,Apex and Lighting Development,Visual Basic v6.0, VC++ 6.0,Developer 2000, Forms 6i

Operating Systems: UNIX, SUN Solaris, Linux, HP, Windows 9x/2000/NT/XP/2009

Scripting: Expertise in writing UNIX Shell scripts Korn-Shell, C-Shell

Internet Technologies: HTML, Java Script, JDBC, XML, Servlet, RMI, Java Swing, JSP

Auto Deployment & Other Tools: JIRA,Confluence.CRIBL,Splunk,Viscio,Jenkins, Centops, TOAD, SQL*Loaderr, Eclipse

ORGANISATIONAL EXPERIENCE

AT&T DIRECTV / Ven Solutions, Germantown, MD May 2022 – Dec 2022

Telecom Enterprise Solution Architect– (May 2022 – 31st Dec 2022)

Own the E2E integrated solution and architecture design of Satellite Beam, Video Stream and PIP – Preferred internet Partner

Client-focused Enterprise Architect/Solution Architect with experience mainly in Solution Architecture for Telecom OSS/BSS domain.

Proficient in Sparx Enterprise Architect for creation of Context Diagram,Sequence Diagram

Used Message Broker, Teradata and Batch File transfer -sends the files to CDO DW STARS (S3) – AWS(Snowflake,Databricks and Datalake) in compliance with the NFRs i.e scalability, data availability, security, and performance

Created the design to handle streaming and satellite information consisting of Structured, Semi-strunctured and unstructured

Design and developed a future-ready integrated solution that assist our Telecom customers in managing major business processes in their overall enterprise structure

Building strong partnerships with the business and technology stakeholders of the enterprise segment

Facilitates discussions with business and technology stakeholders to understand how current systems support the business functions of the enterprise segment

Cultivates transformational and incremental opportunities for improving the positioning of systems that support the business functions of the enterprise segment

Develops the current state and future state architectures of the business and information systems domains of solutions through the definition of models and views

Leads intersystem design decisions like functional placement and integration that define or cross system boundaries

Presents strategic and tactical cross domain and intersystem solution design options and recommendations to decisions makers for decision

Facilitates the cross functional evaluation of technology products being procured

Capable to design company-wide cloud based architectures

Working with Project Managers, taking accountability for assisting in mitigating technology risks in delivery of solutions.

Coaches and guides technologist on system design decisions

Contributed to the definition of architectural principles that guide the application of technology within the enterprise

Contributed to the definition of the enterprise’s strategic technology direction by representing the alignment of technology to the needs of the enterprise segment

Contributed to the analysis of industry technology trends that are of possible value to the enterprise

Environment: Enterprise Solutin Architect SPARX-16.0,Microservices,API – SOAP and REST, AWS Cloud,Message Broker,Teradata

Hughes Network Systems, LLC (HUGHES) / Ven Solutions, Germantown, MD March 2020 – May 2022

Telecom Product Modelling (Salesforce), NetIQ IAM and IDM – Yahsat – (March 2020 – May 2022)

Product Configurator and E2E OSS/BSS functional consultant at Hughes Network Systems, LLC (HUGHES),. experience on configuration of Salesforce CPQ features (e.g. Product Bundles, Quote Templates, Product Rules, Price Rules, Approval Chains, etc.),

Worked on configuration of Salesforce Revenue Cloud tools to ensure accuracy, from quote to payment collection. . Experience on order management, invoice generation and adjustments, payment collections, and financial reporting etc.

Working on satellite-based Internet service with through understanding of Satellite Modems, Gateways, Antenna, Spot beam architecture and coverage, Uplink/downlink capacity,System connectivity and Terminal features.

Keeping a close track of Satellite internet characteristics, Internet data optimizations, Fair Access

Policy (FAP).Provide technical support to business units such as ordering, billing, Installation Portal,Product Configuration,customer services within Enterprise group.

Developed and maintained a thorough up-to-date understanding of Telecom OSS/BSS applications Networking, Product Configuration,Orderring,Provisioning,Inventory Management,Mediation, Billing and Data Warehousing platform.

Design, development, product configuration and product management of satellite and wireless communications for Various Satellite Service Provider spanning across geographies under Yahsat program

Using CRM tool Salesforce to configure Customer Billing Specification,Account Billing Specification,New and Upgrade Offers, FAP Prodcuts on new Service Plans for Various Service Provider in Africa,Brazil and Middle East.

Deep understanding of Salesforce Ecosystem to solve business problems with focus on Sales & Service Cloud and various integration patterns. Used Salesforce CRM – Sales Admin,Apex and Lighting Development.Created the Data Model, Applications,Apex calss,,SOQL,Triggers and VisualForce page for Yahsat Catalog Configuration

Extensive use of HughesNet Consumer and Commercial Installation Portal(IP) to keep track of the Network inventories- for satellite modems and other equipments.

Knowledge / experience with both traditional & modern integration paradigms – event-based, near-real-time APIs, etc.

Responsible for guiding overall architecture, engineering and implementation of Identity & AccessManagement (IAM) solutions for globally dispersed businesses, personnel and customers.

Strong knowledge in NetIQ Access Management and Authentication implementations. Working with IAM architects, application developers, administrators, consultants and vendors to build,configure, test and implement access management solutions that meet the business needs of the enterprise and are aligned and consistent with enterprise IT strategies.

Working on in rolling out of modern authentication - Multi-Factor Authentication (MFA) solutions

such as RSA SecurID, Federation, ADFS, Phone-as-a-token methods, FIDO compliant MFA, OAuth,

One-time password (OTP); Mobile Push and Social login;Use of Virtual Directory Service (VDS) to

implement enhanced Authentication and coarse grained authorization controls.

Involved in authentication capability for cloud based applications and infrastructure,advanced

biometric Authentication capabilities such as fingerprint scanning, retina, voice recognition, facial

recognition. Involved in evaluation, selection and configuration of Authentication products and

services from vendors.

Created the POC for NetIQ IAM license verification tool and Shared the steps to execute for different geographis and sent the report to NetIQ .

Environment: Salesforce Sales Cloud, Apex Programing, SOQL,SOSL, NetIQ Access and Identiry Managemet,JIRA, Splunk,Oracle SQL Developer, SQL, PL/SQL,UNIX shell scripting,IAM/IDM,Twilio etc

AT&T SERVICES, INC. / TECH MAHINDRA, Plano, TX and Pune, India JUN 2013 – Feb -2020

System Engineer – CP2.0 (Capacity Planner) (29-Jul-2019 –28-Feb-2020)

CP2.0 (Capacity Planner) CP 2.0 enables AT&T Dispatch Optimization Center (DOC) employees to make business decisions and execute changes that optimize Field Operations. The primary additions are Capacity setting configurations, long term view of projected volume, duration & technician count and technician relocation based on suggestions from Recommendation Engine.

Collaborate and provide business analysis,consultancy to the product owner, business sponsors, SMEs and testers during development

Lead design and solution architecture activities,

Coordinated across multiple teams both onshore and offshore.Maintaining functional specifications using TDP tool.

Environment: TDP,Oracle12,Hadoop,Pig,Hive,Python,R,H20,Spark,R,Mongo DB

Solution Specialist – BIDW – Business Intelligence Data Warehousing (eCDW, EDW, BOBI, etc.) (May 2016 – July 2019)

BIDW consists of several systems that support integrated data for Billing, Finance, Core (EDWDB), Sales, Marketing and Inventory, and provides BI to clients for Call Center data and Broadband (ADSL/U-verse) Technical Field Operations including Order, Scheduling, Ticket Dispatch, Trouble Management and Ticket Resolution data.

Work with cross-functional teams to address strategic program goals and commitment to improving Operational efficiencies.

Implement and configure changes per industry standards to improve application stability; migrate to newer hardware and software; and ensure continuous vendor support which has reduced risk to application availability.

Communicate Client business objectives and execute plans that fuel progressive change with project team and all stakeholders.

Provide day to day direction to project teams and regular project status to management. Engage Team to address Chronic issues and implement improvement plans for performance of P1—SLAs for finance/sales and Marketing customers.

Work on Service, Incident, Change, and Release Management best practices. Evaluate application performance; follow change activities; correlate implemented changes and service exceptions; and take action to resolve conflicts and improve performance.

Provide consulting support to the business customer during Outages, Events, User Acceptance Test (UAT) phases and various issue/management calls and schedule and coordinate knowledge sharing sessions among the team members.

Drive multiple automation and system stabilization initiatives with defined goals and targets. Rolled out the Dyson Dashboard for BIDW platform; implemented automation for Alerting for Password expiry, and Auto Monitoring and Auto Restart of abend jobs. Performed Auto Deployment using Centops and Jenkins and developed and customized fa.AI, Q-bots for operational efficiency. Optimized performance items for Post Teradata IntelliCloud migration and stabilized the DW environment.

Worked on migration of the largest standalone Teradata ABS platform to the Teradata IntelliCloud platform and completed 28 P1 SLA’s one day ahead of time. Involved in operations catchup processing for EDW and 200+ related applications post hardware/OS migration to the new EDW Teradata IntelliCloud platform, which has resulted in $86,000 cost savings.

Planned, successfully completed and validated DirecTV (DTV) Integration R6 conversion converting over 1.9M accounts enabling OMS, Enabler, CRM, and other source data processed through numerous DW application - 9.3 million DTV customers were fully migrated to the IP platform. Patched Oracle DB patching on 56 eCDW production Linux and Unix DB servers with latest critical patch with 65 new security fixes for Oracle Fusion Middleware and 301 new security fixes across the Oracle product families.

Environment: TOAD, Oracle SQL Developer, SQL, PL/SQL, UNIX shell scripting, Informatica Power Center 9.6, Dyson, Centops, Jenkins

Solution Specialist – IT Network Delivery – ITd

ITND is a Service & Network Activation platform that interprets fulfillment requests into specific network control commands.

Developed and maintained a thorough up-to-date understanding of the ITND platform and its various customizations and configurations for AT&T. Provided software application support by answering functionality inquiries and addressing troubleshooting issues. Managed all incoming support cases and client issues, ensuring that client SLAs were met, and issues fully resolved. Maintained and updated Help Center assets for the platform, including training materials, help quality, consistency, up-to-date accuracy and relevance of all Help Center assets, desk materials and videos.

Environment: TOAD, SQL, PL/SQL, UNIX Shell scripting,Splunk,4g-5G

Functional Consultant – Balance Manager/Care Portal/Order Entry Portal (Jun 2013 – Apr 2015)

Balance Manager creates customers, accounts and subscribers and provides near real time rating of usage generated by the subscribers. Managed requests from external systems for the Online Charging System (OCS) to provide control over accounts, subscribers, plans, orders and balances for different 3G/4G LTE devices.

Led Defect Management calls and weekly meetings with Finance Support and Estimation.

Updated issues with Oversight and Outage management and POC for troubleshooting upstream/downstream apps.

Prepared Process Improvement plan; developed and maintained Call flows; and updated Operational Manual.

Developed, reviewed and signed off on Interface Agreement document with other applications stakeholders.

Documented and communicated mitigation methods, temporary fixes, and procedures to production issues.

Identified and communicated opportunities for transaction flows through improvements and followed up with Dev and ST teams for Release activities. Gathered requirements for monitoring tool and served as SME for configuration/deployment and interface issues. Provided support during internal and external audits.

Monitored blocking locks in Balance Manager and ensured higher interface latency. Provided design expertise for Business Change projects and mentored Business Design Analysts.

Environment: TOAD, SQL, PL/SQL, UNIX Shell scripting,Splunk

BRITISH TELECOM, Pune, India MAY 2006 – MAY 2013

Solution Designer – Products, Services & Billing Systems (Oct 2012 – May 2013)

Supported BT Retail with product modeling and design for Product & Services including Consumer PSTN, Broadband, Vision, and Bundle (e.g. Strategic Bundles, Order Flow, Order Types and Billing), capturing New Products attribute data and defining the flows to end CRM and Billing Systems). Performed Customer requirement and E2E design analysis and prepared the product model for BT Retail. Defined and prepared the BB Access services; ISP services; VoIP service; base and overlay promotions; contracts; discounts; Bolt-Ons; Fiber Activation Charge products; Welcome Packs; and VAS products for new product offering.

Defined Attribute List (e.g. Tariff info; Sales Channels; Start Dates; Online Display info; Price Override info, etc.) and resolved issues with new product offerings. Defined and captured the data requirements in coordination with E2Edesign.

Worked on various product streams like BT Vision, Consumer PSTN, Broadband, and DF products. Captured the new products attribute data and defined the flows to end systems (e.g. One View, Geneva, Amdocs, OFS, Austin, ORCA, CMF, SAS, etc.).

Arranged design walkthrough workshops with E2E Designer and other stakeholders and obtained sign-off.

Environment: IBM RSA 8.0 (Rational Software Architect)

OSS Solution Designer – Andes DSN – E2E OSS Solution Design for Andes-Products SDK (Aug 2011 – Sep 2012)

OnTelecom OSS stack involved in E2E Solution Design of MobileXpress and AAI products.

Studied TO-BE processes and identified the ‘best-fit’ Platforms and components. Gathered requirements; analyzed and wrote the design documents; scheduled and conducted the CA/CFT; and prepared E2E Solution Design Document.

Led solution architecture review and design walkthrough workshops and obtained sign-off. Identified and escalated issues impacting Solution Design phase and defined all the systems and interfaces involved in the design scenarios.

Explained the dynamic design for various scenarios; covered all agreed stakeholder requirements; provided the key data elements to be passed between components; and described all scenarios applicable for proposed solution.

Environment: IBM RSA 8.0 (Rational Software Architect)

Technical Lead Solution Designer – BGS (Billing Gateway Server) and SIR (Sep 2008 – Aug 2011)

The Billing Gateway provides a generic framework based on gateway architecture connecting disparate Provisioning & Order Management systems to Phoenix (Geneva) to standardize the method of billing. BGS/Phoenix has created the ability to raise invoices to BT customers in over 30 Countries.

Involved in project design; verifying E2E traceability between Requirements and Component Business Processes and Interfaces; and Functional design document review. Tuned BGS applications to ensure efficient handling of volumes of Data.

Performed database design and code review to incorporate the new products and various CDR formats, and root cause analysis for all failure reasons for IPSDK orders including the preparation of solution design documents for existing problem/defects.

Created the gateway model for migration of 9 million customer where Billing information is fetched from diverse data source, loaded into BGS, transformed and loaded into target Geneva Billing System

Environment: Unix, PL/SQL, WebLogic, XML, JAVA,JSP, Servlets

Technical Lead (team size of 30) – SIR (Supplier Invoice Reconciliation)

SIR was a project to map all invoices to a standard format using defined information from an Access and Oracle database into a remote and processed using Ab initio. Provided direction for creation of high-level/low-level BI architectures and Design Document to meet customers’ requirements. Involved in ETL process for data extraction and loading from different systems.

Environment: UNIX Shell Scripting, Ab Initio, PL/SQL

Technical Lead– 21CN Charging & Routing Data Verification Utility (CARDVU21CN) – May 2006 – Aug 2008

Prepared all process-related documentation and involved in design, estimation, costing, and auditing with continuous customer interaction. Managed scope, time, quality, resources and project delivery; prepared work schedules and tracked project status.

Environment: UNIX, PL/SQL (Toad), Pro*C, Visio, MS-Project Manager

SERVISTA, India Dec 2005 – April 2006

WAREHOUSE DEVELOPER – Eiffel Home Phone Data Extract

Responsible for requirements gathering, analysis; functional specifications; warehouse architecture design in terms of data acquisition, dimensional modeling and physical database design strategies; and data presentation.

Environment: Oracle Warehouse Builder. Oracle 9i, Oracle Designer 6.0, PL/SQL, Cognos ReportNet 8.0,SQL * Loader

ACADEMIC DETAIL

Master of Computers (MCA), Madurai Kamraj University, India, 2001

Post-Graduation Diploma in Computer Application (PGDCA), XBCE Bhubaneswar, 1997

Bachelor of Science (BSc. Mathematics), Utkal University, India, 1995

ORACLE Certified Professional OCP 9i Application Developer

Salesforce Certified Platform Developer - I

CAREER HIGHLIGHTS

Received consecutive three quarters “Special Recognition Award” for British Telecom Billing and Payment Program

Received appreciation from customer and the distinction of receiving customer satisfaction consecutively 3 times 5 out of 5

Won the trophy for CSAT “Customer Satisfaction Award for Best Performing Team” at Tech Mahindra

PERSONAL DETAILS

Mailing Address: 18009 Cottage Garden Drive Apt-104, Germantown, Maryland – 20874

Marital Status: Married with two child

Contact this candidate