Sunil Kumar Email & Phone Number

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.

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.

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.
• 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.

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.

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.

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.