SUMMARY:

• Partner with Global Business Operations team to gather data, create success ratio for all the marketing campaigns.
• Drive user engagement with the Microsoft products and calculate the factors. customer based on the past trend, segment, audience and other Travel and Tourism.
• Sensitized and aware the marketers to target the correct set of Campaign Management )
• Reporting and Tracking.
• Database Marketing and Online for profiling, WWLM for activity & opportunity upload and RIO for all
• Digital Marketing and advertising ( Planning, ET for Email Marketing, WWE for Event Management, RegSys Healthcare and Pharmaceuticals.
• Marketing Campaigns, like MBP for Budget Planning, EP for Execution
• Simultaneously worked on different tools to support End - to-End
• Execution of Microsoft marketing campaigns across the globe.

• Partner with Business Managers and assist in creating various reportsusing python scripts.
• Skills data collected from across the US in excel, CSV, and flat file format
• Monitoring data integrity and oversee processes to extract and clean tuning measures which reduced the response time by 60%. contribution to attain the team goal
• Optimizing the filter and search queries results using performance
• Analytical thinking and maximum and increased the revenue by 5%.
• Excellent interpersonal abilitiesreports helped sales to provide better estimates/insights for events functionality. speakers, the total budget allocated vs return on investments. These user requirements and ensuring based on spend history, top events by spend, top locations, top and managerial skills for analyzing dashboards using Power BI, Tableau which includes measurements communication, demonstrational
• Designing and developing various strategies for generating reports and levels and a team player with good pharmaceutical data records. possessing initiative spirit at various and functions using MS-SQL based database containing millions of
• A quick learner and self-starter
• Creating optimized complex queries, stored procedures, CTEs, Triggers agency. better forecast, data insight and analysis capabilities. leading digital and advertising creating reports for pre and post marketing campaigns for providing members while working at worlds pharmaceutical clients (GSK, Sanofi, BMS, Takeda etc. ) which includes
• Managed and Led team of 12
• Providing solution and services for major healthcare and and Business Intelligence tools.
• HealthSTAR Communication, Mahwah, NJ and Reporting using MS SQL Server
• Analysis, Manipulation, Processing
• 8+ years of experience in Data
• Responsible for End to End Online Campaign Management and Industry & Domain for promotional events. activities, Surveys, Webinars and use that to target the potentials leads markets) based on the data collected from different marketing (ET), MBP, WWE, Regsys campaigns & products across various regions (APAC, GCR, Europe, US Management, WWLM, Exact Target
• Worked on Email and Database Marketing strategy for Microsoft

TECHNICAL SKILLS:

Tools: and IDE Jupyter NotebookAccess, MySQL database trigger fields.

Databases: Microsoft SQL Server, MS which generates automatic emails using templates based on the Developed email notification service using SQL server broker service HLOOKUP, Data Analysis, VBA, Macros performing various kinds of transformations using SSIS.

Microsoft Excel: Pivot Table, VLOOKUPServer, flat files, etc.) and loaded the data into target data sources by

ETL tools: SSIS Designing ETL packages dealing with different data sources (SQL standards. QlikView, Google Analytics, SAS times, also anticipated future needs based on current data collection

BI tools: SSRS, Tableau, Power BIImplementing changes to improve the data quality and processing HTML, SAS, C# Excel, PowerPoint to provide meaningful information.

Programming: MS SQL Server, Pythondashboards and presentations for clients in SSRS, Power BI, Tableau

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Adept at providing Self-motivated individual with over 8 years of experience in data
• Education the overall performance of the user queries search results.
• Redesigned and optimized the existing database objects to improve dynamic queries result data-set.
• Cursors using MS SQL database for the portal back-end to return user
• Created complex Stored Procedures, Functions, Views, Triggers, and technology.
• Developed and implemented a web application using ASP.NET 3.5

Confidential

Senior Data Analyst

Responsibilities:

• Web Developer upload and data acquisition to improve overall database quality. segmentation of individual’s records, data standardization, and data
• Actively Involved in subsidiaries regional data cleansing projectsthe DNC Scorecard).
• Worked with Account Managers to improve the Scorecard (especially
• Analytics. targeting the right Customers for specific campaign using Customer
• Worked with Marketing Managers in Data Marketing initiatives for perations management team. for each individual and other teams as well to present them before the tasks and prepare bi-weekly and monthly resource utilization reports
• Managed and Led the team of 12 people, assigned and peer review the management for better transparency.
• Prepare periodic status reports and project updates for higher glitches to the global data acquisition team on monthly calls. developed and maintained, raise data anomalies and various data
• Ensure data documentation policies and procedures are properly actively participated and raised issues in user acceptance testing.
• Lead adhoc strategic projects to drive marketing growth and also Strategy & Insights.
• Developed and own relationships with key partners in Operations, Data Act as a subject matter expert for reporting and forecasting. acquisition which improved overall database quality by more than 40%. of individual’s records, data standardization, data upload and data developed subsidiaries regional data cleansing projects, segmentation
• Assist with on-boarding new partners, prioritizing Successfully by 30% in that region. data models and strategies to promote products which improved sales