Gursimran Singh Hira

Richmond, VA 857-***-**** adyo9z@r.postjobfree.com Linkedin.com/in/gshira

• Data Analyst with 5 years of experience in requirement solicitation and data collection from different sources, data cleaning, and analyzing data to gather insights for customer acquisition, customer retention, increasing visibility and approaching various target markets. Double MSc in Business Analytics and International Marketing.

• Well-versed with Python, R, SQL, and multiple data science libraries for finding insights from large datasets required for managerial decision. Expertise in Excel, Tableau and PowerPoint for creating models and data visualization.

• Strong understanding of customer acquisition strategies and execution

• An outstanding communication and comprehension skills. Experience

CAPITAL ONE DATA ANALYST (CONTRACTOR) Richmond, VA January 2022 - Present Developed and executed campaigns to acquire new customers for Capital One Card division and other developments.

• Communicated with business users and conduct thorough study and analysis of Capital One’s business processes to gather, identify and ascertain its needs and requirements in business intelligence analysis, marketing campaigns and customer accounts management

• Astutely understood the business intent behind each incoming marketing campaigns which are designed to drive superior customer acquisition, engagement and management. Be responsible and accountable for data requirements of the said campaign in terms of sourcing, analyzing, processing, and delivering data

• Performed data extraction, transformation, manipulation and refinery of customer related data, and move data between production systems and across multiple platforms

• Conducted data sanity check and quality check through data pipeline to ensure that all the legal compliances are met and fairness in treatment principles are applied to all the test subjects present in the company’s segmentation population through the date pipeline by designing validation test cases and executing them

• Derived statistical analytics, post processing and result reporting to the leadership team after completion of a campaign

• Produced analytics infrastructure for big data processing on AWS Cloud platform to streamline and automate recurring campaigns by scheduling data processing clusters that performs data segmentation, data hand off and statistical analytics required for result reporting

• Delivered weekly audit reports to the team for records using SQL, SNOWFLAKE Database and Excel

• Led training sessions, delivering engaging and informative content to effectively transfer knowledge and skills.

PEGASUS KNOWLEDGE SOLUTIONS DATA ANALYTICS INTERN Schaumburg, IL June 2021 – Jan 2022 Analytics internship to work and gain knowledge about Advanced Workforce Analytics and Advanced Banking Analytics.

• Independent research on the working of AWA and ABA

• Working on Data Visualization and KPI’s projects

• In-depth analysis about HR Data Integration, Data HUB, Product Architecture and Data Warehousing

EXPLORE BROADCASTING PVT. LTD. BUSINESS ANALYST Mumbai, India December 2017 – December 2018 Handled Marketing Analytics and Operations for Motion Pictures, Radio, Television, and other Entertainment Agencies.

• Collected data from different sources by doing quantitative research to analyze the target market for intellectual properties

• Implemented new marketing strategies based on analysis for customer acquisition and revenue growth

• Trained on sales of ERP for the Television and Broadcast environment for better sales management

• Designed marketing content based on different buyer’s persona for online and offline to promote events

• Conceptualized new intellectual property ideas and planned the framework

• Analyzed the market trends and provided insights via tableau for new intellectual properties in tourism and entertainment sector

MOMENTUM GROUP BUSINESS ANALYST - HEAD OF IP & MARKETING Mumbai, India October 2016 – March 2017 Developed new Intellectual Properties, shaped Old Properties, and handled Marketing Analytics for company.

• Designed intellectual properties for company. Planned and executed the framework for those properties i.e. structure of the event, fundraising and security

• Acquired sponsorships for 2 intellectual properties in entertainment sector targeted towards younger audience

• Created different surveys to collect data from different age group for understanding consumer’s need

• Evaluated data from surveys using visual insights to explain customer choices to stakeholders

• Developed marketing ideas for expanding the range of company’s business

• Created content for marketing over different platforms for attracting clients and increased visibility by 200%

EVERYMEDIA TECHNOLOGIES PVT LTD BUSINESS & SOCIAL MEDIA ANALYST Mumbai, India July 2016 – October 2016 Managed Online Marketing Platforms and Media Roll-Out Plans for Bollywood Movies, Production Houses and Celebrities

• Led as a Social Media Analyst in a cross-functional team for maximizing returns

• Researched different target market for different movie projects

• Controlled all social media accounts related to the projects

• Supervised and provided content for creatives development for promotion

• Strategized and executed media roll out plans on all social media platforms resulted into increase in followers on social platforms

• Analyzed reports from different platforms and made appropriate changes for creating a trend for promotions

• Developed marketing strategies based on insights for projects to target specific market depending upon the product AAWAAZ EDUCATION SERVICES HEAD OF OPERATIONS AND LOGISTIC New Delhi, India June 2015 – June 2016 Spearheaded role of leading operations, business development and marketing analytics for Aawaaz Education Services.

• Headed a team of 90 mentors and undertook training session in various Government Schools in New Delhi and Public schools all over the India

• Created graphic designs and media roll-out plans for offline and online marketing

• Used social media accounts to advertise about the company to collaborate with new schools in different states

• Created new curriculum designs for students of different age groups

• Collaborated with Teach for India’s team to understand the students and teaching curriculum in depth

• Stakeholder management between the company and 90 members Technical Skills and Certifications Software: MS Suite, MS Excel (Analysis), Photoshop, Python, Python – ML, RStudio – R, Google Analytics, Salesforce CRM, Tableau, SQL, Text Analysis, NLP

Certifications: Social Media Marketing (HubSpot), Google Analytics Certification, Introduction to R and Intermediate R Certification from Datacamp, Associate level certification in ActionSelling Languages: English (Fluent), Punjabi (Native), Hindi (Fluent) Education Master of Science in Business Analytics Apr 2021

Hult International Business School—San Francisco, CA Master of Science in International Marketing Aug 2020 Hult International Business School—Boston, MA

Bachelor of Commerce with Honors Jun 2015

Shri Ram College of Commerce, University of Delhi—New Delhi, India

Contact this candidate