Manoj Balana

Manoj Balana

Programmer Analyst

Followers of Manoj Balana348 followers
location of Manoj BalanaBerlin, Berlin, Germany

Connect with Manoj Balana to Send Message

Connect

Connect with Manoj Balana to Send Message

Connect
  • Timeline

  • Skills

    Compare
    Responsibility
    Information technology
    Sales process
    Workforce
    Committed to work
    Market
    Clarification
    Accounting
    Linux
    Data warehousing
    Frs
    Biology
    Punjabi
    Tat
    C
    Detailed design
    Etl
    Windows
    Unit testing
    Sales
    Low level design
    Operating systems
    Applications
    Oracle database
    Clinical research
    Microsoft sql server
    Customer satisfaction
    Talend
    Communication
    English
    Life sciences
    Finance
    Anatomic pathology
    Vertica
    Novartis
    Oracle
    Executive positions
    Visibility
    Testing
    India
    Community outreach
    Hindi
    Sla
    Assessment
    General lab
    Decision making
    Learner
    Synopsis
    Project
    Requirements gathering
    Software lifecycle
    Iris
    Design
    Supports
    Calls
    Unix
    Industrial sector
    Informatica
    Java enterprise edition
    Downstream oil and gas
    Integration
    Technology solutions
    Pune
    Requirements analysis
    Champs
    Databases
  • About me

    I am currently working in Deloitte USI as Data warehouse developer and as a Data analyst using Informatica ETL tool and Tableau. I have over 4.5 years of experience in the field of data warehousing, analytics and information management. I completed my Masters in Computer Applications from the University of Pune. After this, I worked with Cognizant Technology Solutions as a Programmer Analyst. Here, I got an opportunity to work on assessing and handling data for business needs of clients in the healthcare and retail domain. Later, I took up a career with Viewics India Pvt Ltd as a Datawarehouse Developer. Viewics (now acquired by Roche) was then a startup and provides unprecedented access to disparate healthcare data to surface actionable intelligence and empower data-driven decision-making. Currently, I am working in Life Sciences domain for Deloitte US India Skills: Tableau,Informatica,Talend,Oracle,Vertica,Teradata,Unix,Control M

  • Education

    • University of Rajasthan

      2007 - 2010
      Bachelor's of Computer Application Information Technology First Class
    • Savitribai Phule Pune University

      2010 - 2013
      Master of Computer Applications (MCA) Information Technology Project Management First Class
  • 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

  • Licenses & Certifications