Manoj Balana

Experience

• 

  Cognizant

  Aug 2013 - Feb 2016

  Programmer Analyst

  • Worked on different phases of data warehouse development life cycle i.e. designing, development, testing and implementation• Developing ETL mappings using Informatica• Interacting with business stakeholders and identifying enhancements/bugs based on the issues reported by them• Proactively monitoring the system processes and taking corrective action to resolve the issues• Monitoring and analyzing the server logs to determine performance and taking corrective actions when required• Participating in weekly status meetings with stakeholder and internal team meetings• Facilitating the transition of knowledge to new team members through KT sessions• Interacting with cross-functional teams to understand the end to end flow of data and implementing the changes as per upstream and downstream systems Show less

• 

  Viewics, Inc. (Acquired by Roche)

  Mar 2016 - Feb 2017

  Data Warehouse Developer

  Worked on tools like Informatica, Talend, Tableau, and Vertica• Extracting, cleansing, transforming, augmenting and analyzing hospital-based and commercial labs’ data to enable enhancement of their business• Created data visualization products using Tableau to facilitate decision making

• 

  Deloitte

  Mar 2017 - Sept 2018

  Consultant

  I am Working here as a Data warehouse developer using Informatica, Oracle, SQL Server and Teradata• Code migration of the existing application to Informatica for an American health insurance plan provider• Redesign the application and infrastructure to enable controlled data sourcing, to establish enterprise data management & data governance guidelines and to take advantage of enhanced capabilities such as parallel data processing, improved data quality for market risk reporting• Understanding the flow of existing application and creation of mapping documents from SYSBASE code• Design TDDs, suggesting changes, develop ETL mappings in Informatica and perform unit testing of code• Creation of Unix shell scripts to automate or reduce TAT of existing processes• Responsible for creation and delivery of the Functional Specification Document Show less

• 

  KPMG India

  Oct 2018 - Aug 2023

  Tested, cleaned, and standardized data to meet the business standards using Execute SQL task, Conditional Split, Data Conversion, and Derived column in different environmentsInteracted with Strategic Development Team, Business analyst to analyze business needs and developed technical specificationsConsult with clients and internal stakeholders to gather requirements and plan milestones in the research, development, and implementation phases of the project lifecycle

  • Assistant Manager

    Oct 2021 - Aug 2023

  • Consultant

    Oct 2018 - Aug 2023
• 

  HelloFresh

  Apr 2022 - now

  CRM Data Analyst

  • Collaborated with cross-functional teams to develop and implement a comprehensive global reactivations dashboard, providing real-time insights into customer re-engagement metrics and performance trends• Conducted in-depth analysis by utilizing advanced data analysis techniques to identify underlying patterns, root causes, and opportunities for enhancing reactivation strategies• Led and contributed to AB testing initiatives aimed at optimizing customer reactivation campaigns, resulting in a 10% increase in re-engagement rates within 1 Month• Regularly reported key performance indicators (KPIs), presenting actionable insights and recommendations to senior management to inform decision-making processes• Actively participated in strategy brainstorming sessions, contributing innovative ideas to improve reactivation approaches, customer segmentation, and personalized messaging tactics• Played a pivotal role in enhancing customer journey mapping by integrating reactivation touchpoints, contributing to improved customer retention and satisfaction• Assisted in the development of training materials and conducted workshops to educate team members on best practices for interpreting reactivation analytics, optimizing SQL and leveraging insights for strategic planning• Leveraged Python scripting to develop automated solutions, streamlining repetitive tasks and reducing manual effort, resulting in increased team efficiency and productivity Show less