Working as a ‘Data & Analytics Manager’, to develop and manage suite of products/solutions or data models using VBA, Python, DataIKU, Alteryx, Tableau.Managed, developed and played a role of solution architect for the complete value chain of products for Industrial Goods/Ops/Consumer practice area, covering Financials, Production, Import & Export, Supply Chain of companies and relevant industry specific products, developed in agile fashion.Brainstorming and providing scalable solutions to stakeholder’s requirements, with recommendations on which kind of scenario building would be required and how we can maximize the usage of our product e.g. a suite developed to analyze chemical plants capacity, supply & demand and the chemical companies’ financial views helped case teams to create and impact by serving 80% more cases and increase revenue by 60% per year.Implemented Big Data (AWS, Redshift) to handle voluminous data processing to generate analytical outputs and dashboards e.g. Cloud-based End-to-end solution for pricing and revenue management in travel and tourism to help case teams identify performance gaps and revenue opportunities in their client’s revenue. Developed small and large scale analytical & visualization products which can be customized as per client’s requirements or data availability e.g. developed a tool which can customize the regression method as per the data points available each month.Played a role of database architect for multiple products, where guided the team on best practices to create database structures or data marts, which are scalable and efficient to process data transformations effectively.Developed products providing industry benchmark comparisons to clients against the data collected via primary or secondary research or survey, designed and helped stakeholders and in generating and publishing the survey to end clients.

Worked as a ‘Team Lead’, on different projects to generate reporting tools using VBA, SQL and SAS Visual Analytics / Generating ETL via SQL/SAS DI Studio after creating the data models as per the requirements gathered from the client.Build Data Models to perform further analysis on the data and generate reports, dashboards.Created the different data marts required for fraud management system to be implemented for a bank.Managed a team of 3-4 people on different projects.Created data warehouse to collect data from different departments, for a judicial department, which are currently using different environments for their analytics or reporting purposes like MS Access, MS SQL Server and Oracle etc.Generated ETL’s in SQL/SAS DI Studio to create transformations required for loading the data into our data mart.Generated reports/dashboards using VBA, SAS BI/Report Studio and perform analysis using SAS Visual Analytics tool which will be used for identifying the revenue measures from different department departments.

Providing insights to Senior Management on Sales Pipeline.

Worked as a ‘technical expert’, for a team of 50-70 people, within the team with an aim to develop a ‘data expert’ profile in the team, Spend focused time and effort in developing 2-3 key team members as Subject Matter Experts for Product Groups, Sales Channel, Revenue and Segmentation Quality Lead – Overall responsibility for ensuring quality and accuracy of deliverables. To strengthen the review process so as to weed out errors and delays.Own and lead investigative/exploratory analysis in the team, Involved in projects like testing of the data migration of our client, to see if the migrated data’s quality is correct and this data can meet our client’s analytical and campaign generation requirements.Involved in projects like testing of the data migration of our client, to see if the migrated data’s quality is correct and this data can meet our client’s analytical and campaign generation requirements.Measuring campaign response / effectiveness on a Q-o-Q or monthly basis using Control cells to decide the viability of the various campaigns and identify the best winback method (TM/DM/EM)Documenting the key processes for each new campaign and build alert mechanism reports to ensure smooth progress with the help of water-tight processes.Performing the Pre-Campaign analysis so as to understand the feasibility of various campaigns before they are launched. Doing a ‘Deep Dive Analysis’ for analyzing the triggering events for Churn leading to customer profile and then suggesting Marketing Campaigns idea, by Analyzing the firmagraphics, behavioral and spending pattern of Consumers that help us build data for Predictive Modeling.Liaise with third party vendors of the client to analyze the data purchased by the client and its usefulness

Worked as Team Leader in the offshore data analytics team of a European telecom giant. This project involves the analyses of the client data as per the business/marketing managers requirement and delivering the analysis with meaningful insights, and developing the in depth knowledge of client’s data for the purpose of helping the business/marketing managers in aligning the business requirement with the available data.Taking Workstack Calls, i.e. coordinating with the client for their requirements, Generating weekly/monthly dashboard, showing our processes KPI & SLA.Developing the applications using Excel/Access VBA, Oracle PL/SQL, Responsible for research and development of the applicationsLiaisioning with clients for timely updates and for New Work Migration.

Providing training to students on various technologies e.g.: VB 6.0, JAVA and Windows NT 4.0.Actively involved in giving presentations of the centre regarding monthly review at NIIT Regional Office, Pune.