Pushkar Balwadkar
Team Lead / Technical Architect · Accenture
Work Experience
Team Lead / Technical Architect
Accenture2017 – Present
Digital Marketing platform management for Insurance client. • Creating Data Filter, a group of criteria that segments a subscriber list or data extension. • Designed and deployed Emails, Landing Pages using Salesforce Marketing Cloud. • Created Custom Preference Center and Customer Consent Page using Cloud Pages through Web Studio. • Work on building Batch emails, User-Initiated emails and Triggered Sends. • Developed and Automated the Import, Data Extract and SQL Query activities using Automation Studio. Used Dynamic-content for subject line and for personalized email content. • Significant knowledge and experience with AMP Script and the Exact Target API • Configured and designed Journeys using Journey Builder. • Developed and deployed A/B testing strategies and provide test results to the Marketing Team to drive segmentation, delivery and Content decision. • Generate Tracking reports through Automations and also ad-hoc reports. • Using RALLY to manage requirements and defects. • Perform Unit Testing and maintaining Unit Test Scripts for every requirement. • Experience in Salesforce Marketing Cloud Implementation and Integration. • Managing team by making team understand the client's requirement clearly and achieve the result from the team within the defined deadline. • Peer code review along with unit tests review. • Project Status reporting.
Lead - Software
Synechron Technologies2011 – 2017
Understanding the Salesforce application's existing data model and modifying the same to include updates. Designed and developed classes to implement custom business logic for various functionalities. • Developed Apex classes, Apex Trigger, Visualforce Pages, SOQL queries, Field Validation Methods to meet the business requirements. • Converting Visualforce Pages into PDF, applying CSS. • Created Unit Tests and performed Unit Testing of the application to verify the desired functioning of the application. • Deployment of all the customizations from sandbox to production. This was achieved by creating Change Sets. • Resolve bugs which were reported by the testing team which includes fixes for fetching the metadata from self and remote organization. • Implemented Salesforce Add-In in Excel 2010 and utilize its functionality in VBA. • Replicated Salesforce Toolkit by creating DLL in .NET that replaced 32 bit Salesforce Toolkit to make it work in 64 bit MS Office. • Analyse existing VBA solution and improve the performance and enhance it further. • Developed applications to automate the daily report generation and sending task of the team. • Developed simplified tool for users to enhance their usage of an VBA application. • Communicate with clients, gather requirements from them and analyze their need. • Analyse .NET applications, debugged and enhanced it further. • Worked on Email Studio, Automation Studio in Salesforce Marketing Cloud (Exacttarget). • Experience in Salesforce Marketing Cloud Implementation and Integration. • Created Data Extensions and automated Import, SQL Queries, Filters, Emails, Data Extract, File Transfer, etc through Automation Studio. • Developed AMPScript code to personalize Email and dynamic contents. • Managing team by making team understand the client's requirement clearly and achieve the result from the team within the defined deadline. • Peer code review along with unit tests review.
Sr. Software Engineer
Zensar Technologies2011 – 2011
• Design, develop and maintain databases in SQL Server. • Analysed existing VBA solutions and .NET applications, debugged and enhanced it further. • Communicate with clients, gather requirements from them and analyze their need. • Analyze manual reports and automate it. • Implemented Advance VBA capabilities to integrate data into other MS Office program. • Managing team by making team understand the client's requirement clearly and achieve the result from the team within the defined deadline.
Sr. Executive
Sandvik Coromant, Sandvik Asia Ltd2006 – 2011
• Implemented the iAvenue Saratoga CRM system in Asia-Pacific region. • Responsible for Administration, Maintenance and Up-gradation of the CRM system. • Responsible for Configuration of CRM system on Server as well as on Client. • Develop applications in VBA, VB.NET, ASP.NET and Lotus Notes for enhancing the CRM system. • Worked on VB6 to .NET migration projects. • Circulate updated respective customer's Data to respective colleagues of Asia Pacific region on daily basis in the form of .DWN files without manually updating the DOWNLIST.DAT file. • Develop many in-house customized softwares in VB.NET, C#.NET and ASP.NET as per the requirement. • Develop reports in Excel Macros using SQL Queries, VBA and circulate it to all colleagues of Asia Pacific region. Also developed reports using Crystal Reports. • Developed solution for automatic modification of SQL Queries in Excel Pivot tables with parameter using VBA. • Developed solution for Converting RTF data into normal text for displaying it in Excel reports. • Troubleshooting user's problems. • Training colleagues. • Design and develop and maintain databases in SQL Server. Worked on PL-SQL (Triggers, procedure, cursors, user defined functions) • Improved the efficiency & time utilization of the dept as sales and marketing people can concentrate on their core jobs without the hassles of number crunching and presentation/ analysis.
Trainee Software Engineer
Aaditya Infotech2005 – 2006
(Worked while pursuing MCS)
• Designed and developed database in Oracle and MS Access • Developed ActiveX dlls in Visual Basic 6.0. • Developed GUI applications in Visual Basic 6.0 • Tested the developed applications • Studied existing applications, debugged and enhanced it further.
Education
Master Of Computer Science
T. J. College (Pune University)2006
Master Of Computer Science