Isha Bhatnagar

adg5g6@r.postjobfree.com

+1-703-***-****

Area of Interests:

Data exploration and Data analysis, Research, Business Intelligence, Tableau Reporting, Business Analytics, Site data Analysis, Model development, Market Segmentation and Dashboards, Digital Marketing, Cross Channel Campaigns, Marketing Campaign and Email Marketing

Professional Summary:

•9+ years of industry experience as Tableau Developer/ Adobe Campaign Developer and Reporting Analyst.

•Expert in analytical and problem-solving skills with Creative Implementation Techniques

•Experience in gathering & analyzing the business requirements and develop Business Requirements Documents and

Technical documentation for metadata modeling and report development.

•Experience in Analyzing the BI needs, interpreting business requirements, and translating them into reports using Tableau.

•Collaborated with Business users to understand user requirements, layout, and look and feel of the dashboards to be developed and created proof of concept / prototype the same using Tableau desktop.

•Experienced in designing and deploying workbooks with drill down, drill through and drop-down menu options and parameterized, linked reports using Tableau desktop.

•Strong knowledge in Tableau Desktop, Tableau Server and Tableau Reader, Tableau server architecture.

•Experience in designing and developing complex Tableau dashboards, advanced reporting with different types of filters, parameters, calculations, actions, and data blending with best practices.

•Developing Tableau visualizations based on the business need and implementing report performance optimization.

•Expertise in the design and development of Tableau visualization and dashboard solutions using Tableau Desktop and publishing the same on Tableau Server/ Public/ Reader and external websites.

•Extensive experience in various Tableau Desktop objects like Measures, Dimensions, Folder, Hierarchies, Extract, Filters, Table Calculation, Calculated fields, Sets, Groups, Parameters, Forecasting, Blending and Trend lines.

•Lead many technical discussions, architecture solutions.

•Interacting with multiple stakeholders to gather business needs & developed technical specs.

•Expertise in Tableau Advanced concepts like LOD expressions, Row-level Security, Dynamic Parameters

Dashboard Optimization technique.

• Experience in data retrieval, data manipulation, data analysis and presentation using data visualizations.

•Conceptualizing and developing novel reports, Interactive dashboards & KPI scorecards on Tableau.

•Good experience in dashboards designing with large data volumes from various data sources.

•Team player and played different roles in an Agile work environment.

•Ability to handle multiple tasks concurrently and meet the deadlines.

•Marketing automation and Campaign Management - Adobe Campaign (Formerly Neolane)

•Cross-Channel Marketing Campaigns strategy, planning and execution

•Expert in Adobe Campaign Classic / Adobe Campaign Standard (ACS)

•Email Marketing, Digital Marketing, Cross-Channel Marketing Optimization, Multi-Channel

•Integrated marketing cloud solutions for Cross/Multi-Channel Email Marketing.

•Marketing- Email/SMS/Push Notifications/Direct Mail.

•Experience with Adobe Campaign in creating, executing, tracking, and managing cross channel campaigns.

•Good Understanding on Campaign API’s, Data Model, Data Schemas, Delivery templates.

•Expertise in Website Content Management methods.

Technical Skills:

•Tableau Desktop, Tableau Server

•Reports and Interactive Dashboards, ETL, Python

•SQL Server, MS SQL, Oracle, SSRS, Toad

•MS Excel and MS Access

•Adobe Campaign Classic, Adobe Campaign Standard

•Agile Practitioner, JIRA,

•Java Script, HTML, XML, CSS, SOAP

Academics:

•Completed Masters in Science (Computer Science) from Sikkim Manipal University, India (2007-2008).

•Completed Post Graduate Diploma in Computer Application from Chaudhary Charan Singh University, India

(2005-2006)

•Completed Bachelor in Science from Chaudhary Charan Singh University India (2002-2005).

Professional Experience:

•Working as Software Engineer (Adobe Campaign and Tableau Developer) in Tissa Technology from March 2016 to Present. (https://tissatech.com/)

•Volunteer as a Technology Assistant in Maitland Montessori Middle school, Orlando FL, from August 2014 to January 2016. (https://www.maitlandmontessori.org/)

•Volunteer as a Technology Assistant in Akins High school, Austin TX, from August 2013 to December 2013. (https://www.austinisd.org/schools/akins

•Worked as Reporting Analyst in Center for Development of Advanced Computing (CDAC), India (Govt. of India Subsidiary) from July 2008 to Dec 2012. (https://cdac.in/)

Projects

1.Shipment Universe System (March 2016– Present)

Employer/Client: Tissa Technology/FedEx

Role: BI Developer

Technologies Used: Tableau

I was responsible to provide various reports related to the shipments, their movements and reports related to the notifications sent to customers. these dashboards were generated on huge volume of data with approx. 5~ million transactions/day, various reports and dashboard were created to provide business insights:

-Dashboard to analyze package movements and the peak times of the movements with various filters like, geographic filters, type of shipment, shipment priority etc.

-Designed, developed, tested and maintained Tableau functional reports based on user requirements.

-Deployed rich graphic visualizations with drill down and drop-down menu options, parameters, calculations, sets, groups, user filters using Tableau.

-Collected data from multiple sources, like RDBMS, In-Memory DBs (TIBCO Active Spaces)

-Built customized reports based on business unit.

-Developed Tableau data visualization using Cross Tabs, Heat maps, Scatter plots, geographic map, pie charts, bar charts etc.

-Utilized Tableau server to publish and share the reports with the business users.

-Accessing & transforming massive datasets through filtering, grouping, aggregation, & statistical calculation.

-Data Blending

Controlled data display by restricting data by User filters.

Developed Tableau workbooks from multiple data sources using Data Blending.

Created & maintained SQL scripts, indexes, & complex queries for data analysis and extraction.

2.Enterprise Notification System (December 2017– September 2019)

Employee/Client: Tissa Technology/FedEx

Role: Adobe Campaign Developer, Tableau Developer

Technologies Used: Adobe Campaign Classic, Tableau

Tableau was used to provide various dashboard and reports to provide insight on the data generated related to customer interactions via various channels like Email, SMS, In-App Push Notification, Direct Mail etc. These reports were designed and implemented to provide various filters (Channels, Geographic, Language, date and time etc.), graphical charts and drill-down capabilities using Tableau features:

-Participated in the collection of reporting requirements through detailed conversation with business/operational users.

-Defined and provided design and solution.

-Developed Tableau visualizations and dashboards using Tableau Desktop.

-Implemented Tableau dashboards to provide business insights on,

oNotification trends over time

oKeyword usage and patterns popularity

oSMS tracking and volume check based on geography, language

oDrill-down feature for the detailed information

oFilters for Channels like, Email, SMS, Direct Mail, Fax, In-App

oForecast reporting on the notification volume and trending

oProvided Geographic visualizations to cover the world map and drill down

oBuild and publish Tableau reports utilizing complex calculated fields, table calculations, filters, parameters.

-Scheduled Refresh of the reports.

-Work with business teams to review and sig offs on the reports.

-Provide on-going production support needed for the reports.

-Provide enhancements and maintenance support of dashboards.

-Lead the team in various design and implementation discussions.

Marketing Campaigns and Notifications are critical component in Logistics business, and as part the enterprise notification system where Adobe Campaign was used to design, construct, plan and send various notifications via Email, SMS, In-App Push Notification, Direct Mail etc. and also planned detailed marketing campaigns to support business objectives. These campaigns were targeted to various individual and business customers, campaigns were created to target different customer profiles based on gender, region, age, preferences, patterns, occasions, holidays etc.,

-Evaluate Marketing Campaign requirements and develop great relationships through expectation management and thought leadership.

-CRM campaigns, from briefing through to strategy & design and reporting as well as CRM segmentation.

-Defined and provided strategies for enterprise marketing management for cross channel marketing.

-Identify Target Audience, offer and creative concepts.

-Defined various cross channel campaigns in Adobe Campaign for email, SMS, in-app push, Direct mail communications.

-Worked with business teams to review and finalize campaign plans and notification designs.

-Provide analysis and interpretations of campaign data and market insights to identify key drivers for Marketing ROI optimization.

-Worked on Adobe Campaign Administrator for various configurations, user management etc.

-Designed and implemented workflows for the campaigns, using various workflow activities for delivery, actions, events.

-Drive adoption of common marketing processes and languages.

-working knowledge in ACM inbound and outbound integration

-Used JavaScript for various business logic in workflows.

3.Volunteer Work in USA

Maitland Montessori School, Maitland, FL (Aug 2014 – Jan 2016)

-Worked with middle school kids and provided technology assistance and mentored them in various projects

-Provided aid in primary classes.

Akins High School, Austin, TX (Aug 2013 – Dec 2013)

-Worked as Technology assistant in school lab

-provided guidance and support to high school kids in assignments and projects

4.Medicine and Health Data Analysis (June 2010 - Dec 2012)

Client: Gujrat Medical Service Corporation Limited, Gujrat, India (Govt. of India)

Role: Reporting Analyst

As part of CDAC and providing services to government institutes, I provided services related to the reporting and data analysts of these organizations using various tools like, SQL, Oracle, MS Access and MS Excel. During this assignment I performed below activities:

-Implemented reporting and analytics on various data sets from Quality Control, Hospitals, Medical Colleges.

-Understand business requirements and provide proof-of-concepts when needed.

-Developed various reports for Quality control about samples, labs, and sample results.

-Developed various reports for Hospitals, Medical colleges and their usage of various medicines and medical equipment helping in planning necessary availability of medical needs.

-Developed various reports and dashboards based on the data of patients received from different Hospitals.

5.Drug Warehouse Data Analysis (June 2009 – May 2010)

Client: Post Graduate Institute of Medical Education and Research, Chandigarh, India (Govt. of India)

Role: Reporting Analyst

As part of CDAC and providing services to government institutes, I provided services related to the reporting and data analysts of PGIMER using various tools like, SQL, Oracle, MS Access and MS Excel, during this assignment I performed below activities:

-Implemented reporting and analytics on various data sets from Procurement, Supplies, and Finance.

-Understand business requirements and provide proof-of-concepts when needed.

-Developed various reports about purchase, deliveries, stock ledger, drug availability and their expiry details.

-Developed various reports for Quality control about samples, labs, and sample results.

-Developed various reports for Finance and Supplier payments, supplier performance, and payments.

6.Healthcare Data Analysis (Aug 2008 – May 2009)

Client: Post Graduate Institute of Medical Education and Research, Chandigarh, India (Govt. of India)

Role: Reporting Analyst

As part of CDAC and providing services to government institutes, I provided services related to the reporting and data analysts of PGIMER using various tools like, SQL, Oracle, MS Access and MS Excel. During this assignment I performed below activities:

-Implemented reporting and analytics on various data sets from Patients, Care Services, and Medical Staff.

-Understand business requirements and provide proof-of-concepts when needed.

-Developed various reports about Medical Staff Work allotments, Patients data.

-Conduct internal audits and chart reviews to assist with the monitoring and tracking of data quality to improve healthcare system.

-Monitor and measure indicator and outcome measures to evaluate effectiveness of applied standards.

-Reviewed reports and analysis with authorities.

Personal details:

Date of Birth : 25th August 1985

Address : 2100 Raven Tower Ct, #105, Herndon VA, 20170

Work Authorization : Legally Authorized to work and No sponsorship needed (H4 EAD)

Contact this candidate