Experience

• 

  Wunderman

  Jul 2009 - Jan 2010

  Database analyst

  Responsibility : - • Extracting of Data as per Request by using SQL or Tool(EMMA) • Presently working for Microsoft in MSC (Marketing Service Centre) Team.• Extensively involved in running campaigns for “Global Marketing Operations” of Microsoft (PRAGUE AND FRANCE). • Responsible to extract data from different Microsoft Exchange Servers and upload them into CRM.• Writing queries for different subsidiaries according to their business rules and specifications. • Responsible to work with data management operations team to organize MSI and MSO database. • Worked on scripts for data cleansing to make the data hygienic. • Creating Newsletters and Electronic Direct Mailers, uploading the worldwide data through data enrichment tool and generating the reports. • Pulling required information from the database by using SQL or by using assigned tool. Cleaning and Filtering the information as per request. • Manipulating huge data by using Import/Export function, SQL Server and Access• Creating User Defined Function and Macro in excel to automate the task.• Making Macro to automate the repetitive task. Show less

• 

  Nokia siemens networks

  Jan 2010 - Apr 2013

  Performance management engineer

  Tools and Environment: - Vb.Net, Oracle Scripting, VBA, MYSQL (Database) and Excel ReportingResponsibility : - • Creating Oracle Scripts to fetch the raw data for the reporting.• Creating stored procedure to Customized the Raw data as per requirement.• Having good command over the SQL, Store procedure, and functions.• Working as Performance Management Engineer (Performance Management is a team of Reporting and first level analysis of mobile network)• Working in TTSL(Tata Tele Services Ltd) Project. • To Automate the Report by using VB.Net as Front-End and MySQL as Back-End.• Creating Oracle Scripts to fetch the data directly from Main Oracle Database(OSS)• Creating VBA (Macro) to Automate Excel Report by taking input data from Excel Raw file, text file etc• Data Analysis using advance Excel and other source. Show less

• 

  Times internet limited

  May 2013 - Oct 2013

  Production support analyst

  Working as Lead Automation analyst and responsible for automating all the manual task of Production Team (Responsible for uploading and updating backend data of Indiatimes Shopping Site) . Technology used for automation is Excel, VBA MACRO, MYSql, MS Access

• 

  Metlife

  Jun 2018 - now

  - Main responsibility to provide the best solutions to the customer.- Implementation of end to end consulting projects based on Excel, VBA, Accesss, Macro, SQL etc- Data analysis and reconciliation of data.- Assessment of IT service cost for planning, budgeting and forecasting using Apptio Business Intelligence tool- Automation of the process of calculating the planning budget of the company and comparative analysis of the budget in order to figure out the changes in the services- Use of Proc Sql to create data set summary, perform queries, reconcile databases on SAS- SAS Macros and automation of analytical processes such as appending datasets to create a master dataset, segregating variables in to numeric and character variables- Automation of manual reports using VBA and SQL so as to improve manhour requirements- Preparation of monthly Service Cost Metrics report using excel which provides details of the expenses of the global services- Preparation and analysis of the Top Application report using excel for the topmost applications hosted globally Show less

  • Unit Manager

    Sept 2021 - now

  • Assistant Manager

    Jun 2018 - Aug 2021