Akhilesh Soni

Business Analyst

Pune, Maharashtra, India10 yrs 3 mos experience
Most Likely To Switch

Key Highlights

  • 10 years of experience in data-driven solutions.
  • Expert in Salesforce and Google Cloud implementations.
  • Proven ability to bridge business and technology.
Stackforce AI infers this person is a Data Consultant specializing in CRM and data management solutions across various industries.

Contact

Skills

Core Skills

Data MigrationData LineageBusiness IntelligenceCrm ImplementationData ManagementEtl ProcessesDatabase ManagementData Analysis

Other Skills

Requirements GatheringMicrosoft SQL ServerETL ToolsData WarehousingExtract, Transform, Load (ETL)JIRAConfluenceData AnalyticsGoogle Cloud Platform (GCP)Data ModelingAgile & Waterfall MethodologiesUser StoriesIT Business AnalysisCRM SalesSalesforce Sales Cloud

About

Results-driven Senior Business Analyst with 10 years of experience delivering data-driven and CRM-focused solutions across consumer and customer data domains. Skilled in Salesforce (Sales & Service Cloud) implementations, business process optimization, data lineage, data migration (CDSW to GCP), AI/ML-powered retention strategies, and legacy system decommissioning. Proficient in Agile delivery, collaborating with business and technical teams to design solutions that drive efficiency and customer engagement. Experienced with tools including Power BI, MicroStrategy, Looker, SQL, GCP, and Azure. Adept at bridging the gap between business needs and technology capabilities, ensuring CRM and data solutions translate into actionable insights and measurable business value. Strong communicator with a proven ability to align technical initiatives with strategic business objectives. SKILLS:  CRM Tools: Salesforce (Sales & Service Cloud – Business Process Analysis, Stakeholder Management, Reports & Dashboards, UAT Coordination)  Database engines: Microsoft SQL Server, Big Query  Data Visualization: MicroStrategy, Looker, Tableau, Power BI, MS Excel  Business Analysis: Requirement Gathering, Process mapping, UAT  ITSM Tools: Confluence, JIRA, ServiceNow  Cloud Platforms: Microsoft Azure Services, Azure SQL Server, Azure DevOps, Azure Blob Storage  Methodologies: Agile, SDLC and Requirement gathering analysis  Data Management tools: Innovator, Enterprise Data Catalog  Data Modeling & Database Design: Dimensional & Fact, Data Vault, RDBMS, DWH  ETL and ELT Tool: Azure Data Factory, Azure Synapse, Azure Databricks, SSIS  MSFT Product: MS Word, MS Excel, MS Visio

Experience

10 yrs 3 mos
Total Experience
1 yr 8 mos
Average Tenure
2 yrs 6 mos
Current Experience

Deutsche telekom

Senior Business Analyst

Nov 2023Present · 2 yrs 6 mos · Pune, Maharashtra, India · Hybrid

  • ▪ Developed and maintained end-to-end data lineage, data dictionaries,
  • and data validation frameworks to ensure transparency, traceability,
  • and quality of critical telecom datasets.
  • ▪ Managed CDSW to Google Cloud Platform migration, developing and
  • maintaining a migration table inventory to ensure seamless and
  • compliant dataset transitions.
  • ▪ Led requirement gathering and stakeholder collaboration, translating
  • business objectives into actionable user stories, managing delivery
  • priorities, and facilitating Agile ceremonies via Jira.
  • ▪ Designed and implemented data models and interface mappings
  • using Innovator (German platform) to support complex data consumer
  • use cases.
  • ▪ Built MicroStrategy and looker dashboards to monitor daily pipeline
  • performance and KPIs, enabling real-time visibility to the data
  • migration status and proactive issue resolution.
  • ▪ Authored comprehensive Confluence documentation for enhancements
  • and migration use cases, ensuring long-term accessibility and cross-team
  • knowledge sharing.
Requirements GatheringBusiness IntelligenceMicrosoft SQL ServerETL ToolsData WarehousingExtract, Transform, Load (ETL)+12

Capgemini

Sr Data Consultant

Mar 2021Oct 2023 · 2 yrs 7 mos · Utrecht, Netherlands · On-site

  • ▪ Led requirements gathering, stakeholder workshops, and process
  • mapping for CRM (Salesforce Sales & Service Cloud), data migration,
  • and decommissioning programs.
  • ▪ Defined functional and technical scopes, producing business
  • requirement documents, data lineage, and impact analyses to guide
  • solution design.
  • ▪ Designed KPI-driven reporting and dashboard frameworks using
  • Salesforce, MicroStrategy, Looker and Power BI.
  • ▪ Translated business needs into data flows, transformation rules, and
  • integration specifications for Azure Data Factory, Azure Synapse,
  • Databricks, and Informatica PowerCenter.
  • ▪ Oversaw migration of legacy SSIS packages to Azure Synapse,
  • ensuring alignment with business rules, validations, and data quality
  • standards.
  • ▪ Acted as the key liaison between business users and development teams,
  • translating business needs into actionable technical deliverables while
  • ensuring smooth communication across all levels.
Microsoft AzureRequirements GatheringBusiness IntelligenceMicrosoft SQL ServerData AnalysisData Warehousing+5

Deloitte digital

Data Consultant

Jul 2018Dec 2020 · 2 yrs 5 mos · Greensboro, North Carolina, United States · On-site

  • ▪ Delivered daily ingestion services processing millions of records into a
  • centralized customer data platform, enabling a single customer view
  • for CRM systems such as Salesforce Sales & Service Cloud across
  • multiple client portfolios.
  • ▪ Managed end-to-end cloud integration and data management
  • solutions on Microsoft Azure (ADF Pipelines, Azure Blob Storage,
  • Batch Services), overseeing complete ETL workflows supporting CRM
  • and analytics platforms.
  • ▪ Acted as onsite system analyst and primary liaison with international
  • teams, coordinating with offshore resources to ensure seamless daily
  • Azure pipeline operations for multiple clients.
  • ▪ Designed and optimized SQL queries, triggers, procedures, and
  • functions to enhance reporting and analytics, enabling timely delivery
  • of campaign, sales, and subscription insights into Salesforce
  • dashboards and reports.
  • ▪ Produced and maintained comprehensive technical and system
  • specification documentation for all ETL processes, ensuring clarity for both
  • technical and business stakeholders.
Requirements GatheringAgile EnvironmentJIRAData AnalyticsAzure Data FactoryData Warehousing+6

International software systems, inc.

SQL Developer

Feb 2018Jul 2018 · 5 mos · Washington, District of Columbia, United States · On-site

  • Client : Avascent
  • ▪ Engineered and optimized large-scale database solutions, including
  • schema design, performance tuning, and query optimization, to
  • support high-volume data operations.
  • ▪ Partnered with business stakeholders, application developers, and
  • production teams to translate business needs into scalable, datadriven solutions.
  • ▪ Delivered ad hoc reporting, in-depth data analysis, and rapid
  • troubleshooting to resolve critical business and operational issues.
  • ▪ Authored and maintained comprehensive database documentation,
  • including system specifications, process diagrams, and connectivity
  • maps, ensuring cross-team clarity.
  • ▪ Documented and maintained database system specifications,
  • diagrams, and connectivity charts
Microsoft ExcelSQLSQL Server Integration Services (SSIS)Extract, Transform, Load (ETL)TableauDatabase Management

Staples

Software Engineer eComm

Nov 2016Jan 2018 · 1 yr 2 mos · Framingham, Massachusetts, United States · On-site

  • ▪ Developed Tableau sales reports (week-to-date, last-week) to track
  • weekly promotions for Promo, Inventory, and Sales teams.
  • ▪ Gathered data requirements with cross-functional teams and
  • implemented solutions to improve access to business insights.
  • ▪ Maintained Data Dictionary and ER diagrams in Confluence to
  • support data governance.
  • ▪ Built ETL workflows in SSIS to integrate SQL Server and Oracle data
  • into a centralized warehouse.
  • ▪ Partnered with DBAs on database design and source-to-target
  • mapping for accurate data integration.
  • ▪ Modeled Promo and Inventory data into relational sources for
  • analytics and reporting.
  • ▪ Implemented archiving strategy to enhance query speed and report
  • performance.
Microsoft SQL ServerJIRAData AnalysisExtract, Transform, Load (ETL)TableauIT Business Analysis

Northeastern university

Event Assistant

Jun 2016Oct 2016 · 4 mos · Boston, Massachusetts, United States · On-site

  • During my Master’s at Northeastern University, I worked as an Event Assistant, where I collaborated with the event management team to successfully host both large and small university events. I managed seating plans, ticketing, stage coordination, and crowd guidance, ensuring smooth execution and a positive experience for attendees.
TeamworkEvent PlanningOrganization Skills

Au bon pain

Sandwich Maker

Jan 2016May 2016 · 4 mos · Boston, Massachusetts, United States · On-site

  • During my Master’s at Northeastern University, Boston, I took on my first on-campus job as a sandwich maker. It taught me attention to detail, consistency, and customer service and I also became pretty good at making great sandwiches.
Attention to DetailConsistencyCustomer ServiceCustomer Engagement

Klouddata inc.

Data Analyst

Dec 2014Aug 2015 · 8 mos · Pune, Maharashtra, India

  • ▪ Led ETL testing and progress tracking, ensuring timely delivery of all
  • data processing activities involving large, complex datasets.
  • ▪ Extracted data from multiple Oracle databases, transformed it in
  • SSIS, and loaded it into SQL Server and Excel for analysis and
  • reporting.
  • ▪ Developed and optimized SQL scripts and stored procedures to
  • support data validation, transformation, and reporting requirements.
  • ▪ Leveraged data warehousing solutions to store, analyze, and retrieve
  • historical records, delivering actionable client account insights.
  • ▪ Conducted advanced data analysis to fulfill complex management
  • and client requests, driving informed decision-making.
Microsoft SQL ServerData AnalyticsData WarehousingExtract, Transform, Load (ETL)Business Objects Data IntegratorIT Business Analysis+1

Pcsoft erp solutions pvt. ltd.

Junior Data Analyst

Dec 2013Nov 2014 · 11 mos · Pune, Maharashtra, India

  • ▪ Collaborated in software implementation - ranging from basic SQL query and scripting, data comparison and document creation
  • ▪ Evaluated and analyzed functional specifications submitted by teams
  • ▪ Provided prototype data mappings for client presentations based on specification

Education

Northeastern University

Master of Science (M.S.) — Informatics

Jan 2015Jan 2017

Amravati University

Bachelor’s Degree — Electronics & Telecommunication

Jan 2008Jan 2013

Stackforce found 100+ more professionals with Data Migration & Data Lineage

Explore similar profiles based on matching skills and experience