Sunil Kumar Email & Phone Number

Olathe, Ks, Us

Kansas City Metropolitan Area

Chicago, Illinois, Us

As a 7x Salesforce Certified Lead Solution/Enterprise/Data/Integration Architect specializing in Salesforce Revenue Cloud (CPQ & Billing), Salesforce Data Cloud, and Service Cloud (Field Service), I provide end-to-end architectural leadership, designing and implementing scalable, secure, and high-performing Salesforce solutions that deliver measurable business value and align with overarching enterprise goals.I leverage my deep understanding of the Salesforce ecosystem, including AI, Agentforce, and Data Cloud, to craft innovative solutions that optimize business processes and enhance customer experiences. As a Data Architect, I design optimized data models and flows, ensuring seamless integration with diverse systems and enabling robust analytics. I utilize the power of Salesforce Data Cloud to create unified customer profiles, unlocking personalized experiences and targeted marketing. I also lead complex data migration projects from legacy systems to Salesforce, driving successful digital transformations.In my Enterprise Architect role, I collaborate with C-level stakeholders to develop strategic technology roadmaps and blueprints that align Salesforce with business objectives. I assess the existing technology landscape, identify gaps and opportunities, and establish governance frameworks to ensure adherence to standards and best practices.As an Integration Architect, I specialize in Salesforce-to-ERP integrations, designing seamless data exchange and process automation to optimize business processes. My expertise also extends to broader enterprise application integration, ensuring a cohesive and connected technology ecosystem.I actively collaborate with cross-functional teams, gathering requirements, translating them into technical solns & leading projects to successful completion. I'm passionate about identifying bottlenecks, optimizing workflows, and exceeding client expectations to drive tangible business impact through the strategic use of Salesforce.

Gb

• Lead Salesforce data management and migration projects for fast-growing mid-market to large enterprise companies.• Collaborate with solution and technical architects on medium to large-scale projects.• Conduct discovery and design workshops to define data requirements and user stories.• Assess and improve clients' data processes and architecture for on-premise and cloud systems.• Conduct team reviews and recommend data modeling, administrative, and design improvements.• Research and institutionalize advanced data technologies to build a data center of excellence.• Contribute to building and improving data consulting delivery capabilities.• Manage client expectations, lead implementation teams, and maintain scope.• Defining data architecture, identifying gaps, and delivering comprehensive solutions.• MDM, data governance, data security, and data quality implementations

Chicago, Illinois, Us

• Designed, implemented, and maintained data collection systems for moving data from legacy systems (Netsuite, spreadsheets, on-premise systems, cloud data) to next-generation cloud platforms (Salesforce CRM, CPQ, Zuora, etc.).• Performed data analysis using SQL and other tools to understand business use cases and data patterns.• Built data extraction services for importing data from various sources, including APIs, logs, and relational databases.• Designed and implemented medium to large custom application data models using tools like Erwin.• Developed ETL scripts and jobs to convert, transform, and load data into target systems using tools like Hitachi Kettle, DB Amp, and Workato.• Built data profiling and validation scripts to ensure data accuracy and integrity.• Developed data quality engine driven materialized views to identify data quality issues like duplicate data, missing attributes, and semantic errors.• Processed data collection and ETL pipelines to stage and load data in target systems for consumption.• Optimized data run infrastructure resources to improve performance.• Processed data pipelines to facilitate deeper analysis and reporting by the data and analytics department.• Created and maintained implementation documentation, including high-level design (HLD), low-level design (LLD), data mapping documents, run books, and project artifacts.• Monitored metrics, analyzed data, and recommended optimization strategies.• Developed requirements for data-related projects and worked with the data team to see projects through to completion.• Identified and addressed data integration pain points within legacy business processes.• Contributed to the design of internal procedures and technical frameworks around data technologies and data practices.

Overland Park, Kansas, Us

Overland Park, Kansas, Us

• Played a key role in various Salesforce CPQ and Billing cloud implementations and data migrations as a Senior Lead Data Engineer.• Led the installation and upgrade of Salesforce CPQ and Billing packages in multiple sandbox and production environments.• Optimized product and bundle design, configuration, and loading.• Defined and implemented guided selling configurations.• Designed and implemented product pricing rules.• Automated the entire quoting process, from opportunity creation to contract generation and renewal forecasting.• Configured approval workflows for specific quote scenarios.• Designed and implemented quote document templates.• Integrated electronic signature processes for various sales touchpoints in the lead-to-cash cycle.• Designed and configured an automated framework for data extraction, transformation, and loading (ETL) during large-scale data migrations, transferring quote-to-cash, CRM, CPQ, and billing data from legacy systems to Salesforce and other next-generation cloud platforms.• Provided post-production support.

Overland Park, Kansas, Us

• Worked on a key data analytics project utilizing Hadoop/Big Data platform for building predictive analytics models.• Extracted data from existing data sources (data marts/data warehouses) and ingested it into the Hadoop platform.• Performed data extraction validation to ensure data integrity.• Defined, maintained, and validated data masking and anonymization processes for security compliance in data staging environments.• Defined, built, owned, and maintained pre-production Hadoop environments.• Defined, designed, developed, and built ingestion workflows for data extraction into the Hadoop datalake from various sources.

Overland Park, Kansas, Us

• Participated in large-scale Telecom OSS conversions from legacy systems (CIRAS, ISYS, MSS) to NGN inventory management suite (Amdocs RM and TIRKS) as a Data Mapper/ETL developer.• Analyzed source data and defined mappings for source/target synchronization.• Developed data mapping code in a systematic and relational model to ensure successful conversion of physical and logical network elements.• Identified potential gaps and design trade-offs, working towards acceptable solutions to achieve project success and goals.• Provided post-migration support.

Teaneck, New Jersey, Us

• Participated in a large-scale application development project for a leading cable company, aiming to automate service fulfillment, capacity planning, and inventory management across the OSS stack.• Collaborated with stakeholders through JAD and RAD sessions, demonstrating exceptional communication and facilitation skills.• Performed comprehensive analyses (gap, impact, cost/benefit, risk) to guide project decisions and development.• Developed functional specifications and detailed project plans to ensure efficient execution.• Executed end-to-end testing of software products throughout the development lifecycle, including Amdocs Cramer COTS components and ASMS elements.• Prepared work breakdown structures, estimations, and test case documents.• Managed Requirement Traceability Matrices (RTMs) for delivered requirements.• Reviewed team-developed test cases to maintain compliance with business needs.• Provided support across various testing phases (IVVT, CIT, UAT, SIT) and conducted root cause analysis for identified issues.• Offered post-implementation support, application maintenance, and technical assistance to clients.

Pune, Maharashtra, In

• Successfully participated in early phase requirement capture and analysis for various projects.• Developed detailed user stories based on functional requirements gathered from JAD sessions.• Created acceptance test criteria for every requirement and user story.• Involved in detailed design sessions and reviewed high-level design documents.• Responsible for estimating effort (LoE) for releases and creating detailed Work Breakdown Structures (WBS).• Led the team in test plan and strategy development for each release.• Designed and executed test cases, ensuring timely completion before execution.• Tracked test execution, managed defects, and generated reports for QA management.• Coordinated with various teams (network, product engineering, client, development, QA) to optimize processes.• Participated in production defect triage and prioritization.• Contributed to process improvements and added value for clients.• Led offshore test case design and review processes.• Performed end-to-end testing, including pairwise and interface testing with external systems.• Provided functional and technical support to integrated environments and applications.• Possesses extensive knowledge of Amdocs Service Management Suite, Cramer, Metro-E, HFC Access, and Cell Back Haul services.• Led and coordinated offshore teams for complex projects.• Experienced in testing web services using SOAP UI.• Maintained RTM (Requirement Traceability Matrix) and proactively managed client expectations.• Resolved complex issues requiring design trade-offs.• Demonstrated expertise in telecom OSS, order management, inventory management, network activation, discovery, and reconciliation.