Arti Puneet Bansal
Data Specialist
Nashik
Summary
17 years of experience, including: - 9 years as a SAS Programmer with expertise in BASE SAS, SAS Macros, and SAS BI Tools for report generation and innovative solutions. - 6 years in DevOps, specializing in campaign management, automation, and big data technologies.2 Years in Data Engineering, worked as data engineer to create new data pipelines and build reports. Proven ability to interact with clients to gather requirements and communicate effectively with development teams.
Overview
19
19
years of professional experience
2
2
Certifications
Work History
Data Engineer
Outsourced India
11.2024 - Current
- Understand client's customer base (supply and demand) to identify opportunities for product improvements.
- Collaborate with Product, Marketing, Engineering, and Design teams to drive data-backed product strategies.
- Use SQL to build data pipelines, write complex queries, and perform detailed analysis.
- Automate reports and create dashboards to provide insights at scale.
- Break down complex data into clear, actionable insights for stakeholders.
- Define and track key metrics, investigate changes, and recommend actions.
- Explore data to uncover insights that support product development.
- Promote a data-driven, test-and-learn culture across teams.
- Perform data analysis for financial reporting
- Create Forecast and Actual GMV
- Create ROI report for Google Ad Campaigns
- Create report for PO Generation to automate the process for uploading files into tipalti system
Data Specialist
IBM India Pvt Ltd
08.2016 - 04.2024
- Provide support for Campaign Management System (CMS) in a DevOps environment.
- Led the migration of CMS applications from SAS to Big Data technologies, including Hive, Spark, and MySQL.
- Collaborated with marketing teams to understand requirements and deploy campaigns in production.
- Resolved production data issues and bugs by coordinating with data and development teams.
- Addressed market queries related to campaigns through Quest Cases.
Data Analyst
IBM India Pvt Ltd
01.2014 - 07.2016
- Led the Advanced Analytics team as a Work Cell Lead, implementing statistical models using SAS.
- Created and delivered weekly, monthly, and quarterly management reports through SAS.
- Managed a team of SAS professionals, ensuring timely delivery of analytics solutions.
System Specialist
Accenture
10.2011 - 09.2013
- Led the SAS DWH work cell for a general insurance client, developing data warehouse jobs using BASE SAS and Macros.
- Automated the creation of finance-related files.
- Collaborated with management to prepare sprint plans, resource utilization reports, and capacity planning metrics.
- Delivered earned value logistics reports weekly, improving project tracking.
Software Developer
Accenture
08.2010 - 09.2011
- Enhanced existing data warehouse systems using BASE SAS, Macros, and SAS reporting tools.
- Automated finance-related processes.
- Optimized performance of existing data warehouse jobs.
Senior Software Developer
SAS Research and Development
02.2008 - 07.2010
- Developed ETL jobs using SAS to streamline data integration and processing.
- Conducted product testing and generated reports using SAS BI Tools and SAS Programming.
- Provided production support for SAS Web Analytics projects.
Software Developer
Citigroup Global Services
09.2007 - 02.2008
- Created MIS reports using BASE SAS and SAS Macros.
- Automated report generation and delivery processes.
- Developed reusable macros, enhancing efficiency in report creation.
Software Developer
3i Infotech
01.2007 - 08.2007
- Migrated existing systems from Microsoft Excel Macros to SAS.
- Automated daily report generation and email distribution processes.
Education
BE - Information Technology
K.J. Somaiya I.E.I.T
Mumbai, Maharashtra07.2005
Skills
Programming Languages: BASE SAS, SAS Macros, Python
Certification
SAS 9 – Advanced Programmer
Timeline
Data Engineer
Outsourced India
11.2024 - Current
Data Specialist
IBM India Pvt Ltd
08.2016 - 04.2024
Data Analyst
IBM India Pvt Ltd
01.2014 - 07.2016
System Specialist
Accenture
10.2011 - 09.2013
Software Developer
Accenture
08.2010 - 09.2011
Senior Software Developer
SAS Research and Development
02.2008 - 07.2010
Software Developer
Citigroup Global Services
09.2007 - 02.2008
Software Developer
3i Infotech
01.2007 - 08.2007
BE - Information Technology
K.J. Somaiya I.E.I.T