ABHISHEK PAREEK
Ashburn,VA
Summary
- Senior Data Manager, Analytics: Highly experienced Senior Data Manager specializing in Business Intelligence (BI) and data analytics with over 10 years of expertise. Proven success in designing, developing, and delivering impactful Tableau dashboards and data solutions that support data-driven decision-making in dynamic environments, including the healthcare and regulated industries. Strong background in digital and omnichannel data strategies, client engagement, and leading cross-functional teams to achieve business objectives.
- Digital Data Strategy & Analytics: Led the design and implementation of digital and omnichannel data strategies, aligning digital marketing objectives with measurable KPIs, benchmarks, and actionable insights to optimize marketing performance across various stages of the product lifecycle.
- Tableau Development & BI Engineering: Developed highly interactive and insightful Tableau dashboards and reports by leveraging advanced Tableau functionalities, such as calculated fields, parameters, data blending, and sets, to translate complex data into clear and actionable insights.
- SQL & Data Integration: Proficient in SQL for data querying, manipulation, and optimization, ensuring robust data integration and accuracy in Tableau visualizations. Skilled in ETL processes and data warehousing concepts, facilitating seamless data extraction and transformation into analytics-ready formats.
- Client-Facing & Stakeholder Management: Acted as the primary point of contact for key stakeholders, understanding their business objectives and translating them into impactful analytics projects. Built strong client relationships by delivering data-driven insights and recommendations that create business value.
- Omnichannel Data Initiatives: Directed projects focused on Measurement Frameworks, Market Mix Modeling, and Paid Media data standardization, delivering comprehensive digital performance reporting and insights that align with client objectives in the healthcare industry.
- Leadership & Team Development: Led cross-functional teams, mentoring analysts and consultants to drive high performance. Developed and implemented training programs to elevate digital literacy, enabling team members to execute digital and omnichannel analytics projects effectively.
- Advanced Analytics & Data Visualization: Applied storytelling and data visualization techniques to present findings, using tools such as Tableau, PowerBI, and Excel. Communicated complex analytical results to both technical and non-technical audiences, driving strategic decisions.
- Technical Expertise: Skilled in T-SQL, SAS, UNIX, and Teradata for SQL Server management and BI tasks. Developed and optimized Informatica mappings and workflows, managing ad-hoc requests and generating detailed financial and business reports.
- Quality Assurance & Performance Optimization: Conducted UAT to ensure accuracy and quality of data solutions before deployment. Experienced in performance tuning of Tableau dashboards for an optimal user experience and responsiveness.
Overview
11
11
years of professional experience
Work History
Senior Manager, Business Intelligence
MBIT Associates
08.2016 - Current
- Conduct extensive data analysis, focusing on identifying data sets, metadata, data definitions, formats, and cleansing processes
- Developed and maintained ETL processes to integrate data from multiple sources into both Power BI and Tableau for reporting and analytics, ensuring data accuracy and timely insights
- Designed and optimized data models and schema structures to support complex dashboards and visualizations in Power BI and Tableau, ensuring performance and scalability
- Utilized GCP services for cloud data storage and processing, integrating Google Big Query and Cloud Storage to power Power BI and Tableau dashboards
- Implemented data governance practices to ensure compliance with industry regulations and maintain data quality across BI solutions
- Collaborated with cross-functional teams to troubleshoot data integration issues and optimize ETL workflows using tools like SSIS and GCP-based solutions for efficient data processing
- Leveraged advanced Tableau and Power BI functionalities (e.g., LOD calculations, parameters, DAX, and sets) to develop interactive, insightful dashboards
- Conducted performance tuning of Power BI and Tableau dashboards, optimizing user experience for real-time data analysis and responsiveness
- Created dashboards to monitor and track key performance indicators.
- Created data models to support decision-making processes.
- Translate business requirements into data requirements, writing complex SQL queries to extract and package data for delivery
- Write and optimize SQL and PL/SQL queries to address granularity issues and identify relationships between data sets
- Led cross-functional teams to pilot and implement omnichannel strategies, with a strong focus on digital channels and data, enhancing client satisfaction through innovative client solutions.
- Directed engagements in areas such as Measurement Frameworks, Omnichannel Objectives translation into Digital KPIs, benchmarking, Digital Performance Reporting & Insights, Market Mix Modeling, and Paid Media data processing & standardization.
- Developed and implemented comprehensive digital and omnichannel data strategies, aligning marketing objectives with measurable KPIs and benchmarks for enhanced performance tracking.
- Created innovative analytical solutions to address critical business questions, optimizing marketing strategies across various stages of the pharmaceutical product lifecycle.
- Utilized storytelling and data visualization techniques to present findings and actionable recommendations to clients, effectively communicating complex insights in an engaging and understandable manner.
- Established and nurtured strong relationships with key stakeholders within pharmaceutical organizations, acting as the primary point of contact for understanding business objectives and translating them into actionable analytics initiatives.
- Collaborated closely with clients to identify and capitalize on opportunities for value creation through data-driven insights, ensuring solutions aligned with client needs and objectives.
- Led a high-performing team of analysts and consultants, providing guidance, mentorship, and professional development opportunities to build expertise in digital and omnichannel analytics.
- Built and implemented internal training programs to elevate digital literacy and equip both analysts and managers with the skills to execute digital and omnichannel projects effectively.
- Analyzed data to identify root causes of problems and recommend corrective actions.
- Developed customized reports, summarizing and presenting data in visually appealing format.
Senior BI Developer
Becton Dickinson
12.2020 - 12.2021
- Designed and created Power BI dashboards to visualize essential financial performance metrics, offering senior management clear, actionable insights that improved decision-making
- Optimized financial reporting by automating the aggregation and analysis of financial data, reducing manual work, and ensuring reports were delivered promptly
- Created Data Flow and Process Flow Diagrams for various data loading processes, ensuring smooth operations
- Designed and developed monthly and quarterly dashboards using Tableau and SQL, providing actionable insights into key business metrics and performance
- Created Tableau workbooks by blending data from multiple sources, ensuring seamless integration and accurate reporting
- Developed dashboards using Tableau to provide insights into supply chain metrics, helping to drive data-driven decision-making and optimize operations
- Utilized machine learning models for advanced analytics, forecasting demand, and optimizing inventory levels within the supply chain
- Ensured compliance with data governance policies across all data assets, maintaining high standards of data integrity and security
- Provided technical expertise in optimizing SQL queries and improving database performance to support efficient data analytics
- Developed real-time data processing solutions to proactively manage risks, ensuring scalability to handle growing volumes of supply chain data
- Implemented data governance and security protocols within Tableau Admin to safeguard sensitive business information
- Monitored Tableau Server performance, conducting routine maintenance to optimize resource utilization and ensure the smooth operation of critical business applications
- Collaborated with cross-functional teams to plan and execute server upgrades, patches, and migrations, minimizing disruptions to business operations
- Collaborated with business stakeholders to gather requirements and translate them into Alteryx workflows, delivering actionable insights that drive informed decision-making
- Automated data pipelines using orchestration tools like Apache Airflow, streamlining workflows and improving efficiency
- Spearheaded change management efforts for seamless adoption of new systems or processes among employees.
- Collaborated closely with peers from other departments to drive organizational success jointly as one cohesive unit.
Senior Tableau Developer
BCBS
08.2018 - 12.2020
- Executed Python programs with libraries like Matplotlib, NumPy, and Pandas for data analysis and visualization
- As Tableau Developer, primary activities included designing technology roadmap for Tableau; product installation and implementation development of insightful dashboards; serving as SME point of contact for Tableau and delivery of solutions adhering to BI industry best practices
- Developed interactive Tableau dashboards and visualizations to provide insights into healthcare analytics, including patient outcomes, operational efficiency, and financial performance
- Developed interactive Tableau dashboards and visualizations to analyze mobile device insurance claims data, providing insights into claim trends, customer behavior, and operational efficiency
- Collaborated with business stakeholders to gather requirements and translate them into actionable Tableau solutions that support decision-making and strategic initiatives
- Designed and optimized data models and schema designs specific to mobile insurance claims to ensure accurate and efficient data processing in Tableau
- Implemented advanced Tableau features such as geo-mapping, trend lines, and forecasting to enhance the depth and clarity of analytical insights for stakeholders
- Conducted performance tuning and optimization of Tableau dashboards to improve load times and user experience, especially on mobile devices
- Provided training and support to end-users on navigating and interpreting Tableau dashboards, empowering them to self-serve and derive actionable insights
- Collaborated with data engineers and IT teams to troubleshoot data integration issues and ensure data quality and consistency in Tableau dashboards
- Leveraged text, charts and graphs to communicate findings in understandable format.
- Analyzed large amounts of data to identify trends and find patterns, signals and hidden stories within data.
BI Developer
Bonita Pharmaceuticals
08.2013 - 08.2016
- Handled the entire software development lifecycle, including gathering requirements, designing, developing, managing changes, deploying, and training users
- Preparing Dashboards using calculations, parameters in Tableau
- Extensive experience in creating UI visualizations with Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau
- Designed and developed interactive dashboards and reports using advanced BI tools such as Tableau, Power BI, Qlik Sense, or Looker to visualize and communicate complex data insights
- Utilized cutting-edge visualization techniques, including heat maps, tree maps, and advanced chart types, to present data in a clear and compelling manner
- Collaborated closely with business stakeholders to understand their requirements and translate them into effective BI solutions that drive data-driven decision-making
- Integrated and transformed data from multiple sources (SQL databases, APIs, cloud services) using ETL tools (e.g., Informatica, Talend) to ensure data consistency and accuracy in BI dashboards
- Implemented data governance strategies and best practices to maintain data integrity and security across BI solutions, ensuring compliance with regulatory requirements (e.g., GDPR, HIPAA)
- Conducted performance tuning and optimization of BI queries and data pipelines to improve report generation speed and overall system efficiency
- Stayed current with industry trends and advancements in BI and visualization tools, evaluating and recommending new technologies to enhance BI capabilities and user experience
- Provided training and support to end-users on navigating and interpreting BI dashboards, empowering them to leverage self-service analytics for actionable insights
Education
Master of Science - Data Analytics
The University of Texas At Arlington
Arlington, TX12-2018
Skills
- Omnichannel and Digital Data Strategy – Expertise in leading and implementing omnichannel strategies with a focus on digital channels, data integration, and client satisfaction
- Digital Marketing Analytics and Measurement – Strong ability to translate digital marketing goals into measurable KPIs, and develop frameworks for tracking and optimizing performance
- Stakeholder Relationship Management – Skilled at building and maintaining relationships with key stakeholders, serving as the main point of contact for understanding business objectives and translating them into actionable projects
- Team Leadership and Mentorship – Experienced in leading cross-functional teams, guiding analysts and consultants, and fostering a culture of high performance and professional growth
- Data Visualization and Storytelling – Proficient in creating compelling, data-driven narratives using tools like Tableau and Power BI to effectively communicate insights and recommendations to clients
- Paid Media Campaign Management – 5 years of hands-on experience with digital paid media campaigns, including platforms like SA 360, DCM, and social listening tools such as Sprinklr and Brandwatch
- Project Management – Strong project management skills, overseeing the execution of digital analytics projects from inception to completion, ensuring alignment with client expectations, timelines, and quality standards
- Pharma Domain Knowledge – Deep understanding of the pharmaceutical industry and the ability to navigate the complexities and regulations within the sector
- Analytical Tools and Technical Skills – Proficient in using tools such as Google Analytics, Excel, Tableau, Power BI, SQL, and Python for advanced data analysis and reporting
- Business Development and Strategic Growth – Skilled in identifying new business opportunities, contributing to proposals and pitches, and supporting strategic growth initiatives within the Pharma Commercial Analytics practice
Tableauprofile
https://public.tableau.com/app/profile/abhishek3896
Timeline
Senior BI Developer
Becton Dickinson
12.2020 - 12.2021
Senior Tableau Developer
BCBS
08.2018 - 12.2020
Senior Manager, Business Intelligence
MBIT Associates
08.2016 - Current
BI Developer
Bonita Pharmaceuticals
08.2013 - 08.2016
Master of Science - Data Analytics
The University of Texas At Arlington
Similar Profiles
KOKILAVANI MKOKILAVANI M
PHY RTL Design Engineer at MBIT Wireless Private LimitedPHY RTL Design Engineer at MBIT Wireless Private Limited
DAKSH SINGHDAKSH SINGH
Technical IT Recruiter at MBIT COMPUTRAINING PRIVATE LIMITEDTechnical IT Recruiter at MBIT COMPUTRAINING PRIVATE LIMITED
DANA L. HAKESDANA L. HAKES
Curative Specialist at Liepold Harrison & Associates, Harrison McLaughlin & AssociatesCurative Specialist at Liepold Harrison & Associates, Harrison McLaughlin & Associates